Loading...

Balance Sheet Data

Microsoft Corporation

Microsoft Corporation (MSFT)

Technology

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Total Cash 77,023.8085,712.6396,527.44113,243.06132,977.76133,768.47133,823.10154,140.97167,227.54181,425.15196,828.15
Total Cash (%)
Account Receivables 17,484.8919,546.0617,911.1518,276.7722,433.3626,475.5829,523.1330,200.1632,764.1535,545.8338,563.67
Account Receivables (%)
Inventories 1,938.442,657.082,900.972,251.552,182.502,659.702,063.853,399.573,688.194,001.324,341.03
Inventories (%)
Accounts Payable 5,472.787,988.626,681.597,192.217,387.658,619.199,388.0010,567.3311,464.4912,437.8313,493.80
Accounts Payable (%)
Capital Expenditure -4,258.34-5,487.83-5,942.31-8,340.77-8,131.25-11,632.04-13,930.99-11,181.71-12,131.03-13,160.96-14,278.32
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.