Acquire Customers
New customers equal marketing spend divided by customer acquisition cost.
It is an editable five-year Excel workbook that forecasts recurring client-fee revenue and connects it to costs, statements, scenarios, and management reports.
Plan customer acquisition, retention, service-tier pricing, operating costs, staffing, capital spending, financing, and cash needs in one structured forecast.
Editable assumptions feed monthly calculations and annual views so changes to customers, fees, costs, or funding flow through the model’s financial outputs.
Revenue starts with marketing-driven customer acquisition, assigns customers across service tiers, retains each cohort for its modeled lifetime, and charges monthly fees.
New customers equal marketing spend divided by customer acquisition cost.
New customers are assigned across service tiers using the entered allocation mix.
Starting customers and unexpired acquisition cohorts determine active customers by tier.
Each tier’s active customers are multiplied by its monthly fee per customer.
Monthly tier revenue is summed across all tiers and forecast months.
The Revenue Assumptions sheet connects launch timing, marketing spend, CAC, customer allocation, cohort lifetime, and monthly service fees to active-customer growth.
REVENUE ASSUMPTIONS
The COGS & OPEX sheet separates direct service costs, variable expenses, and fixed overhead so operating assumptions flow into the forecast.
COGS & OPEX
The Scenario Analysis view compares revenue, gross margin, contribution margin, and EBITDA trajectories across Low, Base, and High cases.
SCENARIO ANALYSIS
The Dashboard combines model setup, scenario controls, core financials, revenue mix, profitability, cash flow, and investment payback into one management view.
DASHBOARD
The model fits recurring service businesses with cohort-based customer revenue; materially different billing logic, operating schedules, or reporting may call for custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your revenue logic, operating schedules, or reporting requirements differ from the ready-made structure.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive an editable downloadable Excel model with a five-year forecast, scenario analysis, and integrated financial reporting.
Enter your own customer, pricing, cost, staffing, capital, and financing assumptions.
Review the plan across the model’s five-year projection horizon.
Compare Low, Base, and High cases using the workbook’s scenario controls.
Review projected statements, ratios, KPIs, charts, and decision-oriented reports.
The essential answers are visible in full, with no accordion clicks required.
It multiplies active customers in each service tier by the monthly fee per customer, then sums tiers and months. Customer acquisition, allocation, and retention determine the active customer base.
You can change the launch date, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime or churn convention, and monthly fees by tier.
The Scenario Analysis view compares revenue, gross margin, contribution margin, and EBITDA paths across the three cases. Scenario controls show how alternative assumptions change projected results.
Confirmed outputs include the income statement, cash flow statement, balance sheet, Dashboard, Scenarios, Summary, Break-Even, ROIC, Charts, KPIs, Ratios, Valuation, Sources & Uses, DuPont, Top Revenue, and Top Expenses.
Yes. Custom financial modeling can address different revenue logic, operating schedules, or reporting requirements when the ready-made structure does not match your needs.
It is a planning forecast driven by the assumptions entered into the workbook, not a guarantee of business performance, profitability, funding, or returns.
This comprehensive ESOP administration Excel template includes everything you need to build a complete financial plan, from initial setup costs to a five-year exit valuation.
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
I’m not strong in Excel, so the pre-built ESOP admin model made the setup feel manageable instead of overwhelming. It saved me about 6 hours I would’ve spent trying to figure out advanced formulas.
One broken cell used to make me second-guess every number, but this template kept the calculations organized and easy to trace. I caught an issue in minutes instead of spending half a day fixing a tangled sheet.
I kept putting off the model because starting from scratch felt like a lot. This template gave me a clear place to begin, and I had a working draft ready the same afternoon.