Free template: Weekly Cash Decision Calculator. Download free →
Trusted by US SMBs, founders and CFOs

Free download

SMB 3-Statement Model

Tell us where to send it. No spam — one email with your file.

I am a

We store your details to send the file and occasional finance resources.

🎁 Free Excel Model

One assumptions sheet in. Three linked statements out — balanced, every year.

A fully linked three-statement model for a new business or new venture. Enter your revenue drivers, costs, capex and funding, and the income statement, balance sheet and cash flow build and reconcile themselves across a five-year forecast — with 20+ ratios and a one-page dashboard on top. Built by experienced finance professionals.

📥 Get your free EasePro Model
  • Experienced finance professionals
  • IS · balance sheet · cash flow, linked
  • Self-balancing check row
  • 20+ KPIs + dashboard
  • Excel format · no macros
Output — 5-year forecast summaryUSD $000s
YearRevenueEBITDANet income
FY11,200(150)(280)
FY22,30026060
FY33,600720400
FY44,8001,080720
FY56,0001,5001,050
Balance sheet check
0.00 every year
Change any assumption and the income statement, balance sheet and cash flow all re-tie — the check row stays at zero.
Revenue by forecast year ($000s)
FY1 FY2 FY3 FY4 FY5
Revenue Final forecast year Illustrative — replace with your own numbers
Illustrative sample: a new business moving from an early-year loss to profit
What's inside the file

One input sheet. Three statements, a KPI page, and a dashboard downstream.

Eight tabs in total, including a cover sheet and a written instruction sheet. Sample data ships in the file, so you can see a completed, balanced model before you change a single input.

Input · I1

Assumptions

Everything you control on one page: entity and forecast period, revenue drivers (product, service and subscription), pre-operation and ongoing costs, COGS and opex, capex, working capital, debt and equity funding, and the tax rate. Yellow cells with blue text are the only ones you edit.

Output · O3

Three linked statements

The income statement, balance sheet and cash flow, fully linked and self-balancing across five years — with a check row on the balance sheet that stays at zero. Change an assumption and all three re-tie automatically.

Output · O2

KPI sheet

20+ ratios in one place: profitability and return (ROA, ROE, ROIC), liquidity, leverage and solvency, efficiency (cash conversion cycle, asset turnover), and cash-flow metrics (FCF margin, CFO/EBITDA) — each across the full forecast.

Plus a one-page dashboard and the schedules that feed the model.

Output · O1

Dashboard

The whole model on one page — headline P&L, margins, returns and cash — built for a board slide or an investor update rather than a scroll through the workings.

Working · C1

Debt schedule

Debt drawdown, interest and repayment worked separately, then fed into the interest line, the cash flow, and the balance sheet — so financing flows through the model correctly.

Working · C2

Fixed assets & depreciation

Capex, gross fixed assets, accumulated depreciation and net book value on their own schedule, driving the depreciation charge and the balance-sheet asset line.

Inside the model

Every assumption on one sheet. Nothing hardcoded in the statements.

The reason most spreadsheet models cannot be reviewed — or trusted — is that assumptions are scattered through the workings, so a reviewer cannot tell an input from a calculation. Here every input lives on one sheet, in yellow, and the statements contain no hardcoded numbers at all.

Because it is built for a new business, pre-operation costs are handled explicitly and revenue is split into drivers you can forecast separately, rather than one blended growth rate that hides how the business actually scales.

I1_Assumptions — Input sheet
A · General information
Entity NameYour co.
Forecast Period5 years
Currency / DenominationUSD 000s
Revenue Start DateJan-25
B · Revenue drivers · per year
Product Sales700,000
Service Revenue400,000
Subscription Revenue100,000
C · Costs
Pre-operation direct costs250,000
COGS · % of revenue45.0%
Operating expenses · % of revenue30.0%
D · Capital & funding
Capital Expenditure500,000
Long-term Debt300,000
Equity Contribution400,000
Tax Rate9.0%
You type here Calculated downstream
Assumptions sheet: every input in one place, nothing buried in the statements
Why it has to be linked

Three tabs that do not talk to each other are not a model.

Plenty of "models" are three separate tabs that each look fine on their own. The test is whether they tie: net income has to flow to retained earnings and to the cash flow; capex has to hit the balance sheet and depreciation; debt has to move interest, cash and liabilities together. If any link is missing, the balance sheet stops balancing.

The test every real model has to pass
Total assets$4,240K
Total liabilities & equity$4,240K
Balance check0
Illustrative. If these two do not agree, the model is wrong somewhere — and a live check row tells you the moment it happens.

That is why the balance check matters. A model that self-balances is one where every assumption flows through all three statements correctly — so when you change revenue, or add a debt draw, or push capex out a year, you can trust that the whole picture updated, not just the tab you were looking at.

It is also what a lender or investor looks for first. A model that ties tells them the numbers are internally consistent before they even judge whether the assumptions are reasonable. One that does not tie ends the conversation early.

How to use it

Fill one sheet. Read three statements.

Every input sits on the assumptions tab; nothing downstream needs touching.

1

General info & revenue

Entity, forecast period, currency and revenue start date, then your revenue drivers — product, service and subscription — entered separately so each can be forecast on its own terms.

2

Costs & operating expenses

Pre-operation direct costs, COGS as a percentage of revenue, and operating expenses. The pre-operation lines are what make this work for a business that spends before it sells.

3

Capital, debt & funding

Capex, working-capital assumptions, long-term debt and equity contributions, and the tax rate. The debt and fixed-asset schedules do the rest.

4

Read the outputs

The three linked statements, the KPI sheet and the dashboard build themselves — and the balance check confirms it all ties, every year.

Is this for you?

Honest qualification. No fluff.

This model is for you if:

  • You are starting a new business or launching a new venture and need a five-year financial plan.
  • You need a proper, linked three-statement model — not three disconnected tabs.
  • A lender, investor, or board wants projections that tie and balance.
  • You have pre-operation costs to model before revenue begins.
  • You can split revenue into a few drivers and estimate cost and margin assumptions.
  • You want the ratios and a dashboard produced for you, not built by hand.

This is not for you if:

  • You need a formal valuation opinion or a written report — that is a different engagement.
  • You need multi-entity consolidation or FX-aware forecasting in one file.
  • You need scenario or Monte-Carlo analysis across many variables at once.
  • You want a short-term, weekly cash tool — a 13-week cash flow fits better.
  • Your business is established with years of actuals you would rather model from directly.

This is a self-serve model built to a defensible standard. If you would rather we build it around your business — or review one you already have before a raise — book a call and we will do it with you.

Frequently Asked

Questions about the model, answered honestly.

What format is the model?
A Microsoft Excel (.xlsx) file with eight tabs: a cover sheet, an instruction sheet, an assumptions input sheet, the three-statement forecast, a KPI sheet, a dashboard, and debt and fixed-asset working schedules. No macros and no add-ins. Every input is a yellow cell; everything else is formula-driven.
What does "three-statement" actually mean?
The income statement, balance sheet and cash flow are linked into one system rather than kept as separate tabs. Net income flows to equity and cash, capex flows to assets and depreciation, debt moves interest and cash together — and a balance check row stays at zero to prove it all ties. Change one assumption and all three statements update and reconcile.
Is this for a new business or an existing one?
It is built for a new business or new venture — it handles pre-operation costs and a revenue start date explicitly, and splits revenue into product, service and subscription drivers. It works for any business you can forecast on those terms; an established business with years of actuals may prefer to model from its own history.
Do I need to be an Excel expert to use it?
No. You only ever touch the yellow input cells on the assumptions sheet; every statement, ratio and chart downstream is formula-driven and locked to those inputs. The instruction sheet walks through each section.
Is this really free? Any catch?
Yes, free. We ask for a few details so we can send the file and follow up if you have questions. No credit card. No upsell sequence. You can unsubscribe at any time.
What if I need it built or reviewed properly for a raise?
EasePro's Financial Modeling Services build the model around your business, pressure-test the assumptions, and prepare it for diligence. If you are appraising a specific investment, pair it with the DCF valuation model; for a formal number a counterparty will accept, see Business Valuation.