Balance Sheet Data

Microsoft Corporation (MSFT)

$255.02

+0.33 (+0.13%)

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 133,768133,819136,527130,334104,749208,173.63241,045.77279,108.65323,181.93374,214.71
Total Cash (%)
Account Receivables 26,48129,52432,01138,04344,26152,709.0861,032.2370,669.6681,828.9194,750.29
Account Receivables (%)
Inventories 2,6622,0631,8952,6363,7424,055.294,695.655,437.126,295.687,289.82
Inventories (%)
Accounts Payable 8,6179,38212,53015,16319,00019,573.1522,663.8926,242.6830,386.6035,184.86
Accounts Payable (%)
Capital Expenditure -11,632-13,925-15,441-20,622-23,886-26,042.43-30,154.72-34,916.37-40,429.92-46,814.10
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.