Balance Sheet Data

Microsoft Corporation (MSFT)

$ 299.56
0.98 0.33%

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 132,981133,768133,819136,527130,334215,648.63252,253.49295,071.77345,158.15403,746.36
Total Cash (%)
Account Receivables 19,79226,48129,52432,01138,04345,016.1752,657.3561,595.5772,050.9984,281.14
Account Receivables (%)
Inventories 2,1812,6622,0631,8952,6363,684.414,309.825,041.385,897.126,898.11
Inventories (%)
Accounts Payable 7,3908,6179,38212,53015,16316,225.5618,979.7422,201.4225,969.9630,378.18
Accounts Payable (%)
Capital Expenditure -8,129-11,632-13,925-15,441-20,622-21,120.11-24,705.11-28,898.63-33,803.97-39,541.96
Capital Expenditure (%)



To support growth, companies need to keep investing in capital items – including property, plants and equipment.
To calculate this net investment,we take capital expenditure (found in the company’s statement of cash flows) and subtract non-cash depreciation (found on the income statement).
Working capital refers to the cash a company needs for day-to-day operations.
The faster a company expands, the more cash it will need.
To calculate working capital, we take current assets and subtract current liabilities.
You can find both of these on a company’s balance sheet, which is published in its quarterly and annual financial statements.