Balance Sheet Data

Eli Lilly and Company (LLY)

$365.25

+3.53 (+0.98%)

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 8,034.108,086.402,438.503,681.303,908.606,464.976,846.467,250.467,678.318,131.40
Total Cash (%)
Account Receivables 5,262.206,204.905,541.506,9298,127.207,799.648,259.898,747.309,263.479,810.10
Account Receivables (%)
Inventories 4,458.304,111.803,190.703,980.303,8864,826.845,111.675,413.305,732.746,071.02
Inventories (%)
Accounts Payable 1,410.701,412.301,405.301,606.701,670.601,839.091,947.622,062.552,184.252,313.15
Accounts Payable (%)
Capital Expenditure -2,163.60-3,018.20-1,353.50-2,029.10-1,873.20-2,561.02-2,712.15-2,872.19-3,041.67-3,221.16
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.