Balance sheet
Every line from a schedule, and the check.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: balance sheet.Updated 30 September 2026
Part of project finance and infrastructure models, with the models, labs and guides around it.
What it does
In a well-built model no forecast line on the balance sheet is calculated on the balance sheet. Cash comes from the cash flow statement, receivables and payables from the working-capital schedule, fixed assets from the roll-forward, debt from the debt schedule, equity from its roll-forward. The check at the foot is then a statement about the whole model.
Where it lives
The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.
- Balance Sheet, rows 6–10: Cash, Accounts receivable, Inventory, Net PP&E…
- Balance Sheet, rows 13–16: Accounts payable, Revolver, Term loan, Total liabilities
- Balance Sheet, rows 19–24: Share capital, Retained earnings, Total equity, Total liabilities and equity…
- Financials, row 12: Dividends
- Financials, rows 47–59: Cash, Receivables, Aircraft and equipment, Right-of-use assets, leased aircraft…
- Reported, rows 43–60: Cash and cash equivalents, Restricted cash, Investment in finance leases, net, Flight equipment held for sale…
- Reported, rows 90–99: Book value per ordinary share outstanding, excluding unvested restricted stock, as reported, 50% equity credit for long-term subordinated debt, Adjusted debt, as reported, Adjusted equity, as reported…
- Derived, rows 40–51: Debt / total equity (book), Adjusted debt rebuilt: debt - cash - the equity credit, Adjusted equity rebuilt: total equity + the equity credit, Adjusted debt to equity rebuilt…
- P&L & Cash Flow, rows 41–49: Other assets: cash, finance leases, held for sale, prepayments and the rest, Total assets, Liabilities other than debt: maintenance, deposits, deferred tax and the rest, Assets to fund with debt and equity…
What a reviewer looks for
- A plug in cash or equity to force the check to zero.
- A history that does not itself balance, so the forecast inherits the gap.
Learn it, then build it
Understand · Primer
Three-Statement Modelling
Build · Lab · ~8 min
Three-Statement Linker
Walk any event through all three statements in the right order, with the right signs, and prove the balance sheet balances rather than asserting it.
Read · Guide · 7 min
"Walk Me Through the Three Statements" and Every Follow-Up
Read · Guide · 11 min
How to Review a Financial Model Before It Leaves Your Desk
Vocabulary: The Three Financial Statements.