Home › Templates › Three-Statement Financial Model
Three-Statement Financial Model
A 36-month integrated financial model. Revenue, headcount, expense and financing schedules feed an income statement, balance sheet and cash flow statement that tie to each other, with a department view and an annual dashboard.
Coming soon. This model is not yet available for download.
One click, no details required.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab and a list of every built-in check with its result. |
| Inputs | Model start month, tax and payroll assumptions, sensitivities and the opening balance sheet. |
| Revenue | Billings by revenue line with growth, recognition period and collection time. Produces revenue, receivables and deferred revenue. |
| Headcount | Roster with department, level, pay type, pay, bonus target and dates. Produces salaries, bonus accrual and payment, payroll taxes and benefits by department. |
| Expenses | One line per expense, with the timing of the expense and of the payment. Produces prepaid expenses and accounts payable. |
| Financing | Loans, equity raised, distributions, capital expenditure and depreciation. |
| Income Statement | Monthly and annual, by function, to net income. |
| Balance Sheet | Monthly, with a check that it balances in every month. |
| Cash Flow | Monthly indirect cash flow, with a direct-method proof built from the schedules. |
| Department View | Costs and contribution for one department or all, and totals by general ledger account. |
| Dashboard | Annual summary, key measures and charts. |
| Lists | Departments and their function, and general ledger accounts. |
Features
- Three statements that tie: the balance sheet balances in every month, and cash is proved a second way directly from the schedules.
- Revenue recognition over any number of months, so annual contracts billed up front create deferred revenue automatically.
- Collection time by revenue line drives accounts receivable.
- Headcount by person or planned hire, salaried or hourly, with pay increases, bonus accrual and annual payout, payroll taxes and benefits.
- Each expense has its own payment timing: in the month, one or two months later, or in advance by quarter or year. The difference becomes accounts payable or prepaid expenses.
- Loans with level or interest-only payments, equity rounds, distributions, capital expenditure and depreciation.
- Your own departments and general ledger accounts, with a view of costs and contribution for any department.
- Sensitivity percentages for billings and expenses to test other cases.
- Opening balance sheet with a controlled run-off of each opening balance.
Instructions
- On the Lists tab, enter departments, the function of each, and general ledger accounts.
- On the Inputs tab, enter the model start month, assumptions and opening balance sheet.
- Enter revenue lines, the roster, expense lines and financing on their tabs.
- Review the three statements and the Dashboard.
- Use the Department View tab for a single department.
- Confirm that every check on the Instructions tab shows OK.
Notes
Capacity is 12 revenue lines, 50 employees, 50 expense lines, 4 loans and 15 capital purchases over 36 months. Income tax is a single rate with no loss carry-forward. A model is a set of assumptions, not a forecast of results.
Related calculators
- Burn Rate and Runway CalculatorCalculate gross burn, net burn and months of cash runway from your cash balance, monthly revenue and monthly expenses.
- Free Cash Flow CalculatorCalculate free cash flow from operating cash flow and capital expenditures, with free cash flow margin and conversion.
- EBITDA CalculatorCalculate EBITDA and EBIT from net income by adding back interest, taxes, depreciation and amortization, with EBITDA margin.
- Break-Even Point CalculatorFind how many units and how much revenue you need to cover fixed costs, using price and variable cost per unit.
Need a version built for your process? Request a custom template quote.
To report an error or request a calculator or template, send feedback.
Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.