Balance Sheet Data

Microsoft Corporation

Microsoft Corporation (MSFT)

$208.9
0.2 (+0.10%)

Year
A/P
2013
Projected
2014
Projected
2015
Projected
2016
Projected
2017
Projected
2018
Projected
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Total Cash 76,774.6885,460.8296,284.13113,170.13132,881.19133,647.07133,823.10136,529.12172,736.10188,679.64206,094.77
Total Cash (%)
Account Receivables 17,484.8919,546.0617,911.1518,276.7722,433.3626,475.5829,523.1332,008.4034,603.4637,797.3641,286.06
Account Receivables (%)
Inventories 1,938.442,657.082,900.972,251.552,182.502,659.702,063.851,887.893,655.633,993.044,361.60
Inventories (%)
Accounts Payable 4,826.647,432.896,588.016,900.517,387.658,619.199,388.0012,528.7611,919.8413,020.0414,221.79
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-15,446.41-13,294.60-14,521.69-15,862.05
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.