Bridgesheet

Three-statement model

Pro

Projects a company's income statement, balance sheet and cash flow statement over 3 to 10 years from operating, working capital, capex and debt assumptions. The balance sheet is checked every year.

Download the example file (.xlsx)
  • 8 sheets
  • Average-balance interest, no circularity
  • 4 integrity checks, 2 alerts
  • Input
  • Calculation

01 — General

Step 1 of 5

Tip: copy a block of cells in Excel or Google Sheets, then paste it into a table cell. Rows and columns fill in from that cell; rows are added when needed.

0 rows · from 0 to 5 · Amounts in k€

Live preview

Recalculating…

Download

Summary, charts and sensitivities, ready to drop into a presentation.

File language

Independent of the interface: for instance, generate a French or German model for a client abroad.

Model currencyEUReditable in the General step

Free plan: files carry a “Free version” notice.

Method

Revenue grows at the input rate. Cost of sales follows from the gross margin, and operating expenses are a percentage of revenue. EBITDA is gross profit less those expenses. Depreciation is the depreciation rate times opening net PP&E.

Receivables, inventory and payables come from DSO, DIO and DPO (revenue for receivables, cost of sales for the other two), on a 360 to 366 day year. Capex is a percentage of revenue. Debt falls by the scheduled repayment, capped at the outstanding principal.

Interest on debt and on cash is charged on opening balances by default. The average-balance option is solved with a closed-form formula, so the workbook has no circular reference and no iterative calculation to switch on in Excel.

Tax applies to positive pre-tax profit, with no tax losses carried forward. Dividends are a percentage of positive net income. Opening equity is derived to balance the base-year balance sheet, then moves with net income less dividends.

Each year the workbook checks that assets equal liabilities and equity, that the change in cash matches the cash flow statement, and that debt and PP&E stay non-negative. Two alerts flag negative cash or negative equity.

What's in the file

  1. 01CoverCompany, date, currency, language, checks status, contents, colour conventions and disclaimer.
  2. 02InputsOperating, working capital and financing assumptions, set year by year, plus base-year opening balances.
  3. 03Income statementFrom revenue to net income: gross profit, EBITDA, EBIT, interest and tax.
  4. 04Balance sheetAssets, liabilities and equity, base year included, with an assets minus liabilities difference line.
  5. 05Cash flowOperating, investing and financing cash flows, opening and closing cash, free cash flow.
  6. 06DebtAmortising term loan (opening, repayment, closing, interest) and the interest income calculation on cash.
  7. 07OutputsKey figures by year: growth, margins, cash flows, cash, net debt, net debt / EBITDA and equity.
  8. 08ChecksFour integrity checks counted as errors, and two alerts kept out of the total.