Acquire Customers
Calculate new customers from marketing spend divided by customer acquisition cost.
It is an editable five-year Excel and Google Sheets workbook linking HDD customer cohorts, billable hours, hourly rates, costs, scenarios, and financial reports.
Use the workbook to plan customer acquisition, active service cohorts, billable workload, pricing, direct costs, operating expenses, staffing, capital needs, and cash flow.
You edit launch timing, marketing, CAC, customer mix, lifetimes, billable hours, hourly rates, and operating assumptions, then the workbook updates connected outputs.
The model estimates new customers from marketing spend and CAC, keeps active customer cohorts by service lifetime, calculates billable hours, and applies each hourly rate.
Calculate new customers from marketing spend divided by customer acquisition cost.
Allocate new customers by tier; active customers combine starting customers and unexpired lifetime cohorts.
Multiply active customers by average billable hours per customer each month.
Multiply billable hours by the hourly rate for each service category.
Sum service revenue across all enabled tiers and forecast months.
The Revenue worksheet lets you edit launch timing, marketing budget seasonality, CAC, customer allocation, lifetimes, billable hours, and hourly rates by service.
REVENUE
The COGS & OPEX worksheet organizes direct costs, variable expenses, fixed expenses, timing, and monthly schedules that feed the forecast.
COGS & OPEX
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
SCENARIOS
The Dashboard combines setup controls, scenario multipliers, headline KPIs, revenue mix, profitability, cash flow, and payback views in one management screen.
DASHBOARD
It fits businesses using customer cohorts, billable hours, and hourly rates; consider custom modeling when your revenue or reporting structure works differently.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your HDD revenue logic, operating schedules, or reporting requirements differ from the ready-made structure.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable five-year Excel and Google Sheets financial model with monthly and annual projections, scenarios, and financial reports.
Open the model and replace the prebuilt assumptions with your HDD planning inputs.
Review monthly and annual projections across the workbook’s five-year planning horizon.
Compare the built-in Low, Base, and High cases as assumptions change.
Review connected income statement, cash flow, balance sheet, and management outputs.
The essential answers are visible in full, with no accordion clicks required.
It estimates new customers from marketing spend and CAC, carries service cohorts through their lifetimes, then calculates billable hours times hourly rates and sums revenue.
You can edit launch date, starting customers, marketing budget and seasonality, CAC, service allocation, customer lifetimes, billable hours, and hourly rates.
You can compare Low, Base, and High revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast.
The workbook shows income statement, cash flow, balance sheet, Dashboard, Summary, break-even, valuation, ROIC, Charts, KPIs, and related reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structures.
It is a planning forecast based on the assumptions you enter, not a guarantee of business performance or financial results.
This comprehensive package includes a fully editable financial model in Excel and Google Sheets, complete with a dynamic dashboard, detailed financial statements, and pre-populated assumptions for a Horizontal Directional Drilling service.
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
This template helped me map runway and shortfalls before they became a problem, which saved me hours of guesswork and made lender conversations much easier.
I finally had a clear view of margins and break-even, instead of digging through a messy sheet. It cut my planning time by a full afternoon and gave me numbers I could explain quickly.
I’d been putting off the model for weeks, and this gave me a real starting point right away. I had the first draft built in under an hour, which made the whole project feel manageable.