Skip to content
The Financial Modeller
Build free
What you get

What’s in every financial model we build.

One Excel workbook: inputs with sources, three linked statements, a valuation, scenarios, a dashboard and checks, built for your business.

Build my free modelSee a finished example
  • Free account
  • No card
  • Usually ready within the hour
Wattle Point Hotels.xlsxBalances
  1. 01CoverKey figures and an index of every sheet
  2. 02How It WorksA guide to every part of the model
  3. 03ValuationThe methods you chose, side by side
  4. 04SummaryThe dashboard: charts and KPIs
  5. 05FinancialsProfit and loss, balance sheet, cash flow
  6. 06InputsEvery assumption, with its source
  7. 07ScenariosUpside and downside cases
  8. 08Rooms · Staff · FundingYour building blocks, a sheet each
  9. 09ChecksProof that it balances in every period
Sheet by sheet

Six parts, one checked workbook.

  1. InputsSourced
    • Rooms, Wattle Point112Hotel register
    • Rooms, Harbour Street68Hotel register
    • Occupancy, FY2678.0%FY25 accounts, p.6
    • Average daily rate$214Booking report
    • Room rate growth3.0%Assumed
    • Wages growth3.5%Award rates

    Example: Wattle Point Hotels (fictional)

  2. FinancialsBalances
    Inputs · Occupancy, FY2674.0%
    Profit and loss
    Revenue17.8
    EBITDA4.8
    Net profit1.4
    Cash flow
    Net profit1.4
    Operating cash3.8
    Closing cash4.3
    Balance sheet
    Cash4.3
    Retained profits12.5
    Check0.00

    The same figure, linked from one statement to the next

    Example: Wattle Point Hotels (fictional)

  3. Valuation4 of 7 methods
    Discounted cash flow
    EV/EBITDA multiples
    Net asset value
    Precedent transactions
    Midpoint3035404550
    $39.5mEquity value, midpoint
    of the methods chosen
    • DCF
    • EV/EBITDA
    • P/E
    • NAV
    • Dividend discount
    • Sum of the parts
    • Precedents

    Example: Wattle Point Hotels (fictional)

  4. ScenariosDownside
    Key figureDownsidevs base
    Occupancy71.0%−7.0 pts
    Average daily rate$205−$9
    EBITDA, $m4.1−1.1
    Equity value, $m31.8−7.7

    Your inputs stay on the Inputs sheet; the switch moves the key drivers.

    Example: Wattle Point Hotels (fictional)

  5. SummaryBase case
    RevPAR$167
    Occupancy78.0%
    Daily rate$214
    EBITDA margin28.3%
    Revenue, $m

    Example: Wattle Point Hotels (fictional)

  6. How It Works · ChecksBalances
    How room revenue is builtRoom revenue $11.0m
    Rooms180
    Occupancy78.0%
    Daily rate$214
    Days365
    = rooms × occupancy × rate × days
    • Balance sheet balances0.00
    • Cash flow ties to cash0.00
    • Every building block’s own checks0.00
    • Total of all checks0.00

    Example: Wattle Point Hotels (fictional)

The hotel group in these pictures is made up. See a sample hotel model.

Your choices

Built the way you need it.

Choose the periods, the level of detail and the valuation methods. We build the rest around your business.

Period choices
4
Monthly, quarterly, half-yearly or annual
Years of forecast, at most
30
Short plans and long-life assets
Levels of detail
5
From very low to very high
Valuation methods
7
Choose the ones you need

  • Asset by asset

    Each site, property or segment on its own, or the whole business, with subtotals at every level.

  • Your track record

    Up to three years of past results beside the forecast, from your accounts or our research.

  • In your brand

    Your logo, colours and font on every sheet, with every model.

The house style

A complete model, not a template.

Every model is set out in one house style that any analyst, lender or board can follow.

  • A standard .xlsx, with no macros or add-ins
  • Inputs in blue on one Inputs sheet, each with its source
  • Links to other sheets in green, totals in bold
  • Every money figure in $, $’000, $m or $bn, at a switch
  • A Checks total on every sheet
How a template compares
Every industry

Building blocks that speak your industry’s language.

All 456 types of business
Your account

Your model, kept in your free account.

Nothing is edited in place: every change is a new version you can go back to.

After delivery

  • Every version kept

    Each change builds a new version. Compare any two, open or download any of them, or restore an earlier one.

  • Scenarios

    Change a few inputs, such as a higher interest rate, and compare the result with your base case.

  • Your actuals and budgets

    Upload accounts or a budget. We match the numbers to the model and you check them. Then we rebuild it.

  • Changes on request

    Ask for a change in plain words. We rebuild the model, check it again and email you when it is ready.