Free 3-Statement Financial Model Template
A fully linked income statement, balance sheet, and cash flow statement in one Excel workbook. Change any assumption and all three statements update — with a balance check that proves the model ties.
What's Included
- +Assumptions sheet — revenue, growth, margins, opex ratios, capex, AR/AP days, and tax rate. Edit only the blue cells.
- +Income statement — revenue through net income with gross margin, opex, EBITDA, D&A, and taxes.
- +Balance sheet — cash, receivables, PP&E, payables, and equity, with a balance check row.
- +Cash flow statement — operating, investing, and financing sections; ending cash flows back to the balance sheet.
How the Three Statements Link
- 1.Net income from the income statement flows into retained earnings on the balance sheet and is the first line of operating cash flow.
- 2.Working capital — changes in receivables and payables adjust operating cash flow, driven by your AR and AP day assumptions.
- 3.Capex and depreciation — capex reduces investing cash flow and builds PP&E; depreciation reverses through the income statement.
- 4.Ending cash from the cash flow statement becomes the cash balance on the balance sheet — which is why the model always balances.
Download the 3-Statement Model Template
Free Excel download with all three statements linked and a working balance check. Opens in Excel or Google Sheets.
Free forever · No email required · Excel & Google Sheets compatible
3-Statement Model FAQs
What is a 3-statement financial model?
A 3-statement financial model links the income statement, balance sheet, and cash flow statement into one integrated model. Net income flows into retained earnings and operating cash flow, working capital moves between the balance sheet and cash flow statement, and ending cash ties back to the balance sheet — so a change to any assumption updates all three statements consistently.
Does the template actually balance?
Yes. The balance sheet includes a "balance check" row that computes total assets minus total liabilities and equity. It shows zero in every period because the statements are linked by construction — cash comes from the cash flow statement, retained earnings accumulate net income, and working capital is driven by AR/AP day assumptions.
Can I use this template in Google Sheets?
Yes. Download the Excel file, then in Google Sheets go to File → Import → Upload and choose "Replace spreadsheet." All formulas and cross-sheet links carry over without changes.
How is this different from your SaaS financial model template?
The SaaS financial model is operational: MRR, CAC, LTV, burn, and runway for running the business. The 3-statement model is the accounting view: income statement, balance sheet, and cash flow, linked the way lenders, later-stage investors, and finance interviews expect. Many founders use both — the SaaS model to plan, the 3-statement model to report.
What time period does the template cover?
Three annual periods plus an opening balance column. Annual periods keep the model easy to audit and present; if you need monthly resolution for burn and runway planning, use the SaaS financial model template alongside it.