This editable five-year workbook models customer acquisition, retained cohorts, billable hours, and hourly rates, then rolls results into scenarios and financial statements.
Use the workbook to translate customer acquisition and service activity assumptions into a structured five-year financial forecast for an auto glass repair operation.
Editable inputs feed the monthly calculation engine, which carries operating assumptions into scenarios, statements, and management reporting.
Built around service cohortsCustomer acquisition, retention, billable hours, and hourly rates remain the core revenue drivers.
CLIENT COHORT REVENUE ENGINE
How Does Auto Glass Repair Revenue Calculate in This Model?
The model acquires customers from marketing spend and CAC, retains service cohorts, converts active customers into billable hours, and applies hourly rates.
01
Acquire Customers
Monthly new customers equal marketing spend divided by customer acquisition cost.
02
Allocate Cohorts
New customers are split by service tier and retained for each tier’s customer lifetime.
03
Track Active Customers
Starting customers combine with all customer cohorts that remain active each month.
04
Calculate Hours
Active customers by tier multiply by average monthly billable hours per active customer.
05
Calculate Revenue
Billable hours multiply by hourly rates, with revenue summed across tiers and months.
CORE FORMULARevenue = Active customers × Billable hours per customer × Hourly rate
01 / REVENUE
How Does the Revenue Worksheet Build the Forecast?
The Revenue worksheet connects launch timing, marketing spend, CAC, service allocation, customer lifetimes, billable hours, and hourly rates to customer cohorts.
REVENUE
The Revenue view shows acquisition assumptions, customer cohorts, billable hours, rates, and customer trends.
02 / COGS & OPEX
How Are Direct Costs and Operating Expenses Structured?
The COGS & OPEX worksheet separates direct costs, variable expenses, and fixed expenses across annual assumptions and monthly forecast periods.
COGS & OPEX
The COGS & OPEX view shows direct, variable, and fixed expense assumptions.
03 / SCENARIOS
What Can You Compare Across Low, Base, and High Cases?
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across five forecast years.
SCENARIOS
The Scenarios view compares Low, Base, and High revenue, margin, and EBITDA paths.
04 / DASHBOARD
What Does the Dashboard Bring Together?
The Dashboard combines setup controls with scenario outputs, core financials, revenue mix, profitability, cash flow, and investment payback charts.
DASHBOARD
The Dashboard shows setup controls, scenario outputs, core financials, and management charts.
PRODUCT FIT
Is the Auto Glass Repair Financial Model Right for You?
The ready-made model fits businesses using customer cohorts, billable hours, and hourly rates; materially different operating logic may require structural custom work.
READY-MADE MODEL
A Good Fit
You acquire customers through marketing spend and CAC and track retained customer cohorts.
Billable hours per active customer are a central workload and revenue driver.
Service tiers use distinct customer lifetimes, monthly hours, and hourly rates.
You want five-year statements, Low/Base/High cases, and dashboard reporting.
CUSTOM STRUCTURE
Consider Custom Modeling
Your revenue logic does not center on billable hours and hourly rates.
You need operating schedules beyond customer cohorts, current cost modules, and staffing inputs.
You require reporting structures beyond the confirmed dashboard and financial statement outputs.
You need structural changes to cohort retention, service-tier allocation, or revenue calculations.
The template is a planning starting point, not a guarantee of performance.
CUSTOM FINANCIAL MODELING SERVICE
Need a Model Built Around Your Requirements?
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting structures.
The essential answers are visible in full, with no accordion clicks required.
01
How does the Auto Glass Repair Financial Model calculate revenue?
Revenue comes from active customer cohorts multiplied by billable hours per customer and hourly rates by service tier. New customers are driven by marketing spend divided by CAC.
02
Which assumptions can I change?
You can edit launch date, starting customers, marketing budget and seasonality, CAC, service allocation, customer lifetime, monthly billable hours, and hourly rates.
03
What can I compare in the Low, Base, and High scenarios?
The Scenarios view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across five years.
04
Which financial outputs are included?
The product shows projected P&L, cash flow, and balance sheet outputs, plus dashboard, ratios, charts, summary, break-even, ROIC, and valuation views.
05
Can Financial Models Lab adapt the model to custom requirements?
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structures.
06
Is this workbook a forecast or a guarantee?
It is a planning forecast based on the assumptions entered into the workbook. It does not guarantee business performance or financial results.
What Does the Auto Glass Repair Financial Model Contain?
This pre-written financial model template for windshield replacement provides everything you need to build a comprehensive financial plan from scratch.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Trusted by 25,000+ startup founders, investors and CPAs
Starting With A Real Model
Megan Carter, TX
The template gave me a place to begin instead of a blank sheet, which made the whole project feel manageable. I had my first draft ready the same day instead of stalling for a week.
Hours Saved On Forecasting
Derek Walsh, FL
I skipped the manual spreadsheet build and got straight to the numbers I needed. What would have taken me most of a day was done in a couple of hours.
Clearer Low, Base, High Cases
Priya Shah, NJ
The three-case setup made it easy to compare low, base, and high assumptions without rebuilding anything. I had a clean set of scenarios ready for my lender meeting in one afternoon.
Choosing a selection results in a full page refresh.
REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
