Runway Got Easier To See
This template made cash flow gaps obvious before they turned into surprises, and I could spot shortfalls months ahead instead of guessing. It saved me hours of spreadsheet work each week.
This template made cash flow gaps obvious before they turned into surprises, and I could spot shortfalls months ahead instead of guessing. It saved me hours of spreadsheet work each week.
I liked having a model that stayed tidy and easy to check, so one wrong cell didn’t send me down a rabbit hole. It cut my review time by about half before a meeting.
I used to waste time rebuilding low, base, and high cases by hand, but this layout made them quick to compare. I booked a planning call the same day because the assumptions were finally clear.
This editorial five-year model provides for revenue from the renewal services of purchased customer cohorts, billing hours and hourly rates, with financial statements and scenario reporting.
Use the workbook to plan how to acquire customers, mix services, retain customers, accountable workload, prices, staff, costs and choice of financing flows through business forecast.
Editable assumptions are the source of operational calculations that combine the revenue schedule with model costs and financial statements, scenarios and management reports.
The model converts marketing spending into new customers, maintains groups of levels, calculates their hours paid, uses hourly rates, and also sums up revenue in different levels and months.
The monthly marketing expenditure divided by CAC generates new customers for this period.
New customers are allocated at different levels of service and retained for the duration of each level.
Customers starting with plus all active customer cohorts determine active customers by the level.
Active customers multiplied by average monthly hours paid generate hours paid by level.
Hours to be paid multiplied by hourly rates are added up at different service levels and months.
The income worksheet organises acquisition budgets, CAC, allocation of levels, customer usage periods, active customers, hours paid and hourly prices for service forecast.
REVENUE
The COGS & OPEX worksheet separates the direct costs of reconstruction, variable operating costs and the consistent general assumptions applied throughout the financial forecast.
COGS & OPEX
The Scenarios report compared low, base and high cases in relation to revenues, gross margin, premium margins and EBITDA in the five-year forecast.
SCENARIOS
The table includes configuration checks, scenario multipliers, key metrics, basic finance, revenue mix, profitability, cash flow and return prospects.
DASHBOARD
The structure is designed to fit the hours-recovery services of purchased customer cohorts; significant differences in revenue logic or operational schedules may justify custom modelling.
The template is the starting point of planning, not a guarantee of performance.
The Financial Models Laboratory can build or customize a model when your company requires a different revenue logic, operating schedules or reporting structures.
ORDER A CUSTOM FINANCIAL MODELAfter you complete your order, you will receive a fully editable five-year financial model for Excel and Google Sheets in the form of an immediate download.
Edit business assumptions directly in Excel or Google Sheets.
Review the expected operational and financial performance over five years of the model.
Compare low, base and high cases through a special scenario reporting view.
Use forecasted P&L, cash flow, balance sheet and management reports.
The basic answers are visible in their entirety, without clicking on the accordion.
Revenue is calculated from active customer cohorts, average monthly billing hours and hourly rates according to service level. New customers come from marketing expenses divided by CAC before allocation and retention.
You can change the launch date, start customers, marketing budget and seasonality, CAC, level allocation, customer life, hours paid and hourly rates.
The Scenarios have compared low, underlying and high revenue, gross margin, premium and EBITDA cases over five years.
The product includes the designed P&L, cash flow and balance-outs, plus the dashboard, summary, scenario and other management reporting views shown in the workbook gallery.
Yes. Financial Models Lab can build or customize a model when you need different revenue logic, operating schedules, or reporting.
This is an editable planning forecast based on assumptions contained in the workbook, not on the guarantee of business results.
This downloadable financial plan for heritage rail operations includes everything you need to build a comprehensive financial strategy for your business.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark