One broken cell used to throw off the whole file, but this template kept the logic clean and easy to trace. I cut my review time by about 3 hours because I could check the assumptions without digging through nested formulas.
Runway used to feel like a guess, but the monthly cash flow view made shortfalls much easier to spot. I booked a planning call the same day because the funding gap showed up clearly in the first pass.
Our statements and charts were scattered everywhere, and this pulled them into one file fast. I saved a full afternoon each month and had a cleaner package ready for our board update.
This is a five-year Excel or Google Sheets workbook that combines customer acquisition, active customer cohorts, hours paid, costs, scenarios and financial statements.
Use the workbook to plan how supported employment services business can acquire customers, keep active cohorts, transform demand for services into hours paid and combine operations with financial results.
Edit assumptions on start time, starting customers, marketing, CAC, mix of levels, customer life, monthly billing hours and hourly rate flows through revenue forecast and related reports.
The model takes over new customers from the expenditure marketing and CAC, retains the conglomerates of the layered customers, converts active customers to accountable hours, and prices of these hours according to the service level.
Marketing expenditure divided by CAC determines new customers for each period.
New customers are allocated at different levels of service with their declared life periods.
The customers starting and non-exhaustive cohorts determine active customers by the level.
Active customers multiply for monthly hours paid for an active customer.
Hours paid multiply by hourly rates and then the revenues are summarised at the level.
The revenue card combines the time of launch, marketing budgets, CAC, mix of customers, customer life, hours payable and hourly prices to the revenue engine from the service.
GROUNDS FOR THE REVENUE
The COGS & Operational Expenses sheet organises direct costs, variable expenditure and fixed operating costs over the forecast period.
OPERATING EXPENDITURE COGS
In the light of the analysis of the scenario, the low, base and high incomes, gross margin, premium margins and EBITDA were compared in the five-year forecast.
ANALYSIS SCENARIO
The table includes a set of models, scenario multipliers, key metrics, revenue mix, profitability, cash flow and return prospects for investments in one management screen.
DASHBOARD
The ready model fits the customer cohort services settled for an hour, while significant differences in revenue logic or operating schedules may require custom modelling.
The template is the starting point of planning, not a guarantee of performance.
The Financial Models Laboratory can build or adjust a model when your company needs different revenue logic, operating schedules or financial reporting.
ORDER A CUSTOM FINANCIAL MODELAfter booking, you receive a edited, supported financial model of employment for a five-year forecast with scenarios, financial statements and management reports.
Open and edit the model in Microsoft Excel or Google Sheets.
Plan your business within the five-year financial forecast with monthly and annual details.
Compare low, baseline and high cases from the model scenario perspective.
Review Income Statement, cash flow, balance sheet, distribution panel and supplementary reports.
The basic answers are visible in their entirety, without clicking on the accordion.
Revenues come from active customers multiplied by hours paid and hourly rates for each level of service. New customers come from marketing expenditures divided by CAC and remain active throughout their period.
You can edit start time, customer start, annual marketing budget, monthly seasonality, CAC, level allocation, customer life, hours paid and hourly rates.
The analysis of the scenario compares low, base and high cases in different cases, with respect to revenues, gross margin, premium margins and EBITDA. This helps to check how alternative assumptions change the expected results.
The product contains income statement, cash flow statement, balance sheet, dashboard, summary, verification receipts, ROIC, graphs, KPIs and other financial reports 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 a planned forecast based on the possible editing assumptions, not a guarantee of the results of business activity or financial results.
This downloadable financial model for a disability employment agency includes everything you need to build a comprehensive financial plan, from revenue modeling and expense forecasting to break-even analysis and investor-ready reports.
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
