Balance Sheet Data

Eli Lilly and Company (LLY)

$792.28

+10.16 (+1.30%)

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 2,438.503,681.303,908.602,211.802,927.704,262.904,749.875,292.465,897.036,570.67
Total Cash (%)
Account Receivables 5,541.506,9298,127.208,558.9011,336.2011,024.2612,283.5913,686.7815,250.2616,992.34
Account Receivables (%)
Inventories 3,190.703,980.303,8864,309.705,772.805,798.756,461.157,199.238,021.628,937.95
Inventories (%)
Accounts Payable 1,405.301,606.701,670.601,930.602,598.802,518.812,806.543,127.143,484.363,882.39
Accounts Payable (%)
Capital Expenditure -1,353.50-2,029.10-1,873.20-2,484-7,392.10-3,902.08-4,347.82-4,844.49-5,397.88-6,014.50
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.