Balance Sheet Data

Microsoft Corp

Microsoft Corp (MSFT)

$214.24
-1.13 (-0.52%)

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
Total Cash 77,022.0085,709.0096,526.00113,240.00132,981.00133,768.00133,819.00136,527.00176,979.50193,735.87212,078.74232,158.30254,139.00
Total Cash (%)
Account Receivables 17,486.0019,544.0017,908.0018,277.0019,792.0026,481.0029,524.0032,011.0034,710.2737,996.6341,594.1545,532.2749,843.25
Account Receivables (%)
Inventories 1,938.002,660.002,902.002,251.002,181.002,662.002,063.001,895.003,736.464,090.234,477.494,901.425,365.49
Inventories (%)
Accounts Payable 4,828.007,432.006,591.006,898.007,390.008,617.009,382.0012,530.0012,158.3313,309.4814,569.6215,949.0717,459.12
Accounts Payable (%)
Capital Expenditure -4,257.00-5,485.00-5,944.00-8,343.00-8,129.00-11,632.00-13,925.00-15,441.00-13,572.34-14,857.36-16,264.05-17,803.93-19,489.60
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.