Acquire Customers
Divide marketing spend by CAC to calculate new customers for each month.
This editable 5-year workbook forecasts shock absorber replacement service performance from marketing-driven customer cohorts, billable hours, hourly rates, costs, and linked financial statements.
Use the workbook to plan how customer acquisition, retained service cohorts, technician billable hours, pricing, and operating costs translate into financial performance.
Editable assumptions feed the operating schedules, which in turn update monthly and annual projections, scenario comparisons, and the connected income statement, cash flow, and balance sheet.
Marketing spend divided by CAC creates new customers, service tiers retain each cohort for its stated lifetime, and active customers generate billable hours priced at tier-specific hourly rates.
Divide marketing spend by CAC to calculate new customers for each month.
Assign new customers across service tiers and retain each cohort for its stated lifetime.
Add starting customers to every acquired cohort that remains active in the month.
Multiply active customers by average monthly billable hours for each service tier.
Multiply tier billable hours by hourly rates, then add revenue across tiers and months.
The Revenue sheet brings launch timing, marketing budget, CAC, tier allocation, customer lifetime, billable hours, and hourly rates into the operating forecast.
REVENUE
The COGS & OPEX sheet separates direct service costs, variable expenses, and fixed operating expenses so cost assumptions can flow into margins and cash needs.
COGS & OPEX
The Scenarios view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the forecast horizon.
SCENARIOS
The Dashboard combines setup controls, scenario multipliers, headline KPIs, core financials, revenue mix, cash flow, profitability, and investment payback charts.
DASHBOARD
The ready-made model fits service businesses using customer cohorts, billable hours, and hourly rates, while materially different operating logic may need custom structure.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or financial and management reporting.
ORDER A CUSTOM FINANCIAL MODELYou receive an editable Steel Plate Bonding Structural Repair financial model with five-year monthly and annual projections, scenario analysis, and connected financial reports.
Customize the operating assumptions, service tiers, costs, staffing, and financing inputs for your plan.
Review monthly and annual projections across the model's five-year planning horizon.
Compare Low, Base, and High cases across revenue, margins, and EBITDA.
Use linked income statement, cash flow, balance sheet, dashboard, and summary reporting.
The essential answers are visible in full, with no accordion clicks required.
It acquires customers from marketing spend and CAC, retains them by service-tier lifetime, and multiplies active-customer billable hours by each tier's hourly rate.
You can edit launch date, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime, billable hours, and hourly rates.
The Scenarios view compares alternative paths for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The product shows linked income statement, cash flow, and balance sheet projections, plus dashboard, summary, break-even, ratios, valuation, and other reporting views.
Yes. Financial Models Lab offers custom financial modeling for different revenue logic, operating schedules, or reporting requirements.
It is an editable planning forecast based on the assumptions entered into the workbook, not a guarantee of business performance.
This downloadable, pre-written financial model for structural repair provides everything you need to build a comprehensive financial plan, from revenue modeling to break-even analysis.
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 made our cash runway and shortfall timing much easier to see, so we stopped guessing from month to month. I saved about 6 hours on planning and walked into our lender call with clearer numbers.
I’m not an Excel person, and this model kept the advanced parts out of my way while still giving me solid projections. I finished the first draft in under an hour and didn’t need help to update the assumptions.
I was worried one broken formula would throw off the whole repair plan, but the layout made checks easy to follow. I caught an input issue fast and had a clean version ready for our meeting the same day.