Balance Sheet Data


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
2024
Projected
Total Cash 34.2077.95352.21201.88368.12224.87144.80206.42248.29298.66359.25432.13
Total Cash (%)
Account Receivables 65187.55150.62283.15141.38153.13134.17179.92216.42260.32313.13376.65
Account Receivables (%)
Inventories 56135.20185.32174.79183.57173.65170.05173.80209.06251.47302.48363.84
Inventories (%)
Accounts Payable 2347.3246.0259.5351.9839.5744.9651.8762.4075.0590.28108.59
Accounts Payable (%)
Capital Expenditure -11.64-29.57-27.93-74.94-95.17-69.11-30.45-51.92-62.45-75.12-90.35-108.68
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.