Skip to content

Free download

Get the Three-Statement Driver Model

The full model with made-up sample data to start from. Leave your name and work email and the download button appears right away.

  • Plain Excel. No macros, no add-ins, no circular references.
  • 24 monthly columns plus two yearly totals.
  • The first month can be any month, so non-calendar fiscal years work.
  • Sample data from a made-up mid-size company to start from.
Free Excel templatePlanningForecastingCash

Free three-statement driver model template

See what your plan does to cash, month by month.

Most plans stop at the P&L. The balance sheet and cash flow get worked out separately, if at all, so the cash impact of a plan is a guess. This template links all three statements to one set of drivers. Change growth, margin, collections or capex and it shows up in cash straight away.

Free · Excel

The top of the Summary tab in the Three-Statement Driver Model for a made-up Sample Company: nine model checks all OK, two plan years side by side with profit and cash figures, and a chart of closing cash against the revolver and the minimum cash line, on sample data.

Highlights

  • Profit and cash, side by side

    The cash flow is shown both ways, direct and indirect, from the same numbers. A check proves they agree every month.

  • The revolver handled for you

    It draws to protect your minimum cash and repays when cash allows. If the facility is not enough, the model flags the gap.

  • Nine checks before anyone sees it

    The balance sheet balances in all 24 months, cash ties to the balance sheet, and the revolver stays within its limit.

Why link all three statements?

"We're profitable, so why is cash tight?" The indirect cash flow walks from net income to operating cash flow line by line: receivables, inventory, payables, accruals and tax. A chart puts net income and operating cash flow side by side for each month.

"What is one more day of DSO worth?" Change DSO, DIO or DPO and watch working capital, the cash conversion cycle and closing cash move. A plan that only lives in the P&L cannot answer that.

Where CFOs use it

  • Annual budgeting: test whether the budget can be funded before it is approved.
  • Monthly reforecast: update the drivers and see the new year-end cash and debt.
  • Board reporting: a one-page Summary with two plan years side by side.
  • Lender talks: show the revolver need, net debt to EBITDA and interest cover month by month.

What's inside

One input tab, three statements and a one-page Summary. Everything that isn't a shaded input is a formula.

  1. Drivers

    The only input tab, in four sections: settings, the opening balance sheet, seventeen green statement links (the only rows the statements take driver values from) and sample driver logic you can edit or replace with your own.

  2. Summary

    The nine model checks, key figures for both plan years with the change between them, a cash watch on the 24 months and two charts. Nothing to type here.

  3. P&L

    Revenue to net income, with margin and interest cover. Tax losses are used before any tax is due.

  4. Balance Sheet

    Monthly balances with a balance check, plus working capital, liquidity and debt ratios.

  5. Cash Flow

    Indirect and direct methods, tie-out checks, free cash flow, and the revolver and minimum cash calculation.

  6. About Vena and MCC

    Who built the template, and what changes when you run the same logic in Vena.

One file, every statement

The same model whether you keep the sample drivers or point the green link rows at your own.

  • Three-Statement Driver Model

    Monthly P&L, balance sheet and cash flow for a 24-month plan.

    The year-over-year KPIs any CFO uses, for both plan years: revenue growth, gross, EBITDA and net margin, free cash flow, cash conversion, net working capital, DSO, DIO, DPO, cash conversion cycle, current ratio, net debt, net debt to EBITDA and interest cover.

    Tabs

    • About Vena and MCC
    • Summary
    • Drivers
    • P&L
    • Balance Sheet
    • Cash Flow

How to use it

  1. Step 1: Fill in the settings

    Company name, unit, first forecast month, minimum cash, revolver limit, interest and tax rates.

  2. Step 2: Enter the opening balance sheet

    Your last actual month end. A check tells you if it doesn't balance.

  3. Step 3: Set the drivers

    Growth, gross margin, headcount, DSO, DIO, DPO, capex, debt and dividends. Shaded cells are inputs, everything else is a formula.

  4. Step 4: Read the Summary

    Every check must show a tick before the numbers are used. They prove the model is consistent, not that the drivers are right.

Questions about the template

Is the template really free?

Yes. Leave your name and work email and the download appears right away. The file is yours to keep and change.

Do I need Vena to use it?

Not to start. The three-statement model runs in plain Excel, with no macros and no add-ins. Vena comes in when drivers need to come from departments and many people, or when you want scenarios, approvals and an audit trail.

Can I use my own drivers?

Yes. The statements take their driver values only from the seventeen green link rows on the Drivers tab. Build your own drivers, point the green rows at them and the three statements keep working.

How is it different from the 13-week cash flow forecast?

This model is the monthly plan, P&L, balance sheet and cash flow over 24 months. The 13-week forecast is the week-by-week treasury view for the next quarter. Use both, this model for the plan and the 13-week file for near-term cash.

Is the sample data real?

No. The company and its numbers are made up, a generic mid-size company with about 54 million in revenue in the first plan year, shown in USD thousands.

The company and figures in this template are made-up sample data. MCC is an independent Vena partner.

Last updated

From a spreadsheet to a process you can trust

When the drivers need to come from departments and many people, when actuals should load automatically, or when you want scenarios, approvals and an audit trail, MCC can run the same logic in Vena for you.

Talk to our team
  1. 1

    Use this template

    Free, in plain Excel. Change the shaded inputs and the rest updates.

  2. 2

    Have MCC set it up in Vena

    Keep the Excel layout, and add one Vena data model, approvals and an audit trail. We build it and check that it ties.

  • The top of the Weekly Report tab in the 13-Week Cash Flow Forecast for the made-up Brightwater Distribution Co.: six summary tiles, then weeks 1 to 13 side by side with receipts, payments and total, on sample data.
    • Cash
    • Forecasting

    13-Week Cash Flow Forecast

    See every week of cash for the next quarter, when you'll touch the credit line, and whether the bank statement agrees. Two versions, Weekly or Weeks + Months.

    Free · Excel, 2 versions: Weekly and Weeks + MonthsDownload free

  • The top of the Budget Summary tab in Hotel Budget by Department for the made-up Larch Bay Hotel: all 12 checks pass, the budget headline and what-if line, twelve KPI tiles from occupancy to EBITDA, the USALI-style summary against last year and RevPAR by month, on sample data.
    • Planning
    • Hospitality

    Hotel Budget by Department

    A driver-based annual hotel budget. Occupancy and ADR by segment, covers by outlet, a USALI-style departmental P&L to GOP and EBITDA, and a what-if in one step.

    Free · ExcelDownload free

  • The top of the Summary tab in Hotel Renovation and Expansion Budget for the made-up Larch Bay Hotel, 80 rooms today and 120 after: all 13 checks pass, a one-line verdict and twelve tiles from total project cost and equity to return on cost, IRR, NPV, payback and DSCR, on sample data.
    • Hospitality
    • Planning

    Hotel Renovation and Expansion Budget

    Is the renovation worth it? Renovate against doing nothing, month by month for 10 years, with closure, ramp-up, the loan, equity returns and seven stress tests.

    Free · ExcelDownload free

Got a problem a template doesn't cover?

Talk to our team about it. Not ready for a call? Watch the Finance Speedrun and see how we solve a real finance problem live every week.