Rounding Robin

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.

Register your interest

One click, no details required.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab and a list of every built-in check with its result.
InputsModel start month, tax and payroll assumptions, sensitivities and the opening balance sheet.
RevenueBillings by revenue line with growth, recognition period and collection time. Produces revenue, receivables and deferred revenue.
HeadcountRoster with department, level, pay type, pay, bonus target and dates. Produces salaries, bonus accrual and payment, payroll taxes and benefits by department.
ExpensesOne line per expense, with the timing of the expense and of the payment. Produces prepaid expenses and accounts payable.
FinancingLoans, equity raised, distributions, capital expenditure and depreciation.
Income StatementMonthly and annual, by function, to net income.
Balance SheetMonthly, with a check that it balances in every month.
Cash FlowMonthly indirect cash flow, with a direct-method proof built from the schedules.
Department ViewCosts and contribution for one department or all, and totals by general ledger account.
DashboardAnnual summary, key measures and charts.
ListsDepartments and their function, and general ledger accounts.

Features

Instructions

  1. On the Lists tab, enter departments, the function of each, and general ledger accounts.
  2. On the Inputs tab, enter the model start month, assumptions and opening balance sheet.
  3. Enter revenue lines, the roster, expense lines and financing on their tabs.
  4. Review the three statements and the Dashboard.
  5. Use the Department View tab for a single department.
  6. 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

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.