Acquire Customers
Monthly marketing spend divided by CAC determines new customers entering the model.
This editable five-year workbook forecasts Wall Washing Lighting Design revenue from active customer cohorts, billable hours, and hourly rates, with monthly and annual statements and scenarios.
Use the model to plan customer acquisition, service mix, billable workload, hourly pricing, operating costs, financing, and the financial impact of changing business assumptions.
Editable assumptions feed monthly calculations that roll into annual views, financial statements, scenario comparisons, and management reporting across the five-year forecast.
The model acquires customers from marketing spend and CAC, retains service-tier cohorts, converts active customers into billable hours, and applies hourly rates.
Monthly marketing spend divided by CAC determines new customers entering the model.
New customers are split across service tiers and retained for each tier lifetime.
Starting customers plus still-active cohorts determine active customers by service tier.
Active customers multiplied by monthly billable hours produces billable hours by service tier.
Billable hours multiplied by hourly rates produces tier revenue, summed across tiers and months.
The Revenue worksheet links marketing spend, CAC, service-tier allocation, customer lifetimes, billable hours, and hourly rates to the client-cohort forecast.
REVENUE
The COGS & OPEX worksheet separates direct lighting-project costs, variable expenses, and fixed operating expenses so cost assumptions flow into 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 model setup, scenario controls, financial outputs, revenue mix, profitability, cash flow, and payback views in one management screen.
DASHBOARD
The ready-made workbook fits client-cohort, billable-hour lighting service economics; materially different revenue 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 you need different revenue logic, operating schedules, or financial reporting for your requirements.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable Wall Washing Lighting Design financial model for instant download with five-year forecasts, scenarios, and linked financial reports.
Open and change the Excel workbook inputs to reflect your business plan.
Review monthly and annual projections across the five-year planning horizon.
Compare Low, Base, and High cases through the model’s scenario view.
Review the Income Statement, Cash Flow Statement, and Balance Sheet outputs.
The essential answers are visible in full, with no accordion clicks required.
It calculates new customers from marketing spend and CAC, retains service-tier cohorts, converts active customers into billable hours, and applies hourly rates.
You can change the launch date, starting customers, marketing budget and seasonality, CAC, service-tier allocation, customer lifetimes, billable hours, and hourly rates.
The Scenarios view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the forecast.
The workbook includes an Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Summary, scenario analysis, and other reporting views.
Yes. Custom modeling can adapt revenue logic, operating schedules, and financial reporting when the ready-made structure does not match your requirements.
It is a planning forecast driven by editable assumptions, not a guarantee of business performance or financial results.
This single template provides everything you need for a complete financial feasibility study for a new lighting design venture, from initial startup costs to a full 5-year projection.
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 break-even and margin questions easy to see, so I spent less time guessing and more time planning. I got a cleaner view of profitability in under an hour.
I didn’t have to build the model from scratch, and that alone saved me half a day. The layout gave me a clear starting point and helped me finish the first draft before my meeting.
The built-in structure kept my spreadsheet from turning into a mess, and I caught issues fast instead of after hours of cleanup. That kept the model stable while I tested different assumptions.