Balance Sheet Data

Microsoft Corporation (MSFT)

$415.5

+1.86 (+0.45%)

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 133,819136,527130,334104,757111,262185,870.30211,899.30241,573.36275,402.93313,969.94
Total Cash (%)
Account Receivables 29,52432,01138,04344,26148,68854,974.3762,672.9071,449.5281,455.2092,862.07
Account Receivables (%)
Inventories 2,0631,8952,6363,7422,5003,672.024,186.244,772.485,440.816,202.73
Inventories (%)
Accounts Payable 9,38212,53015,16319,00018,09520,950.4123,884.2727,228.9931,042.1035,389.19
Accounts Payable (%)
Capital Expenditure -13,925-15,441-20,622-23,886-28,107-28,720.98-32,743.02-37,328.31-42,555.71-48,515.14
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.