Balance Sheet Data

Microsoft Corporation (MSFT)

$ 257.89
0.65 (+0.25%)

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,02285,70996,526113,240132,981133,768133,819136,527176,979.50193,735.87212,078.74232,158.30254,139
Total Cash (%)
Account Receivables 17,48619,54417,90818,27719,79226,48129,52432,01134,710.2737,996.6341,594.1545,532.2749,843.25
Account Receivables (%)
Inventories 1,9382,6602,9022,2512,1812,6622,0631,8953,736.464,090.234,477.494,901.425,365.49
Inventories (%)
Accounts Payable 4,8287,4326,5916,8987,3908,6179,38212,53012,158.3313,309.4814,569.6215,949.0717,459.12
Accounts Payable (%)
Capital Expenditure -4,257-5,485-5,944-8,343-8,129-11,632-13,925-15,441-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.