The statements · in 3 models

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.

Integrated three-statement model
  • 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…
Airline operating and valuation model
  • Financials, row 12: Dividends
  • Financials, rows 47–59: Cash, Receivables, Aircraft and equipment, Right-of-use assets, leased aircraft…
AerCap operating model
  • 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

Vocabulary: The Three Financial Statements.

Other the statements