Trusted by 25,000+ startup founders, investors and CPAs
Saved Me A Full Week
Megan Carter, TX
Building the solar install model by hand would’ve eaten up days. This template cut the setup down to a few hours, so I could move straight to pricing and bids.
Investor Questions Answered Fast
Daniel Brooks, CA
I wasn’t sure what investors would expect, but the layout made it obvious. I booked a meeting the same day because the model was already organized the way I needed.
Clean Assumptions, Clearer Forecast
Sarah Mitchell, FL
Pricing, equipment costs, and growth were all over the place before this. The assumption tabs pulled everything into one place, and I could finally test changes without breaking the model.
Model review
What is the financial model for installing solar panels?
The editable five-year workbooks modelled customer acquisition, service cohort maintenance, billable hours, hourly rates, costs, scenarios and related financial statements.
Use the workbook to plan how a solar panel installation company is transforming marketing and customer demand into billable hours, service revenue, spending and cash flow.
The editable acquisitions, cohorts, hours, rates, costs, employment and capital assumptions flow through the calculations to the scenarios, dashboard and financial statements.
Built around the service economyThe operational logic follows customer acquisition, service allocation, customer lifetime, billable hours and hourly rates.
customer-cohority revenue engine
How is the revenue calculated from the installation of solar panels in the model?
Revenue starts with marketing-based customer acquisition, withholding cohorts by service level, turning active customers into billable hours, and applying hourly rates.
01
Get customers
New customers equals marketing expenditure divided by CAC, using monthly marketing seasonality.
02
Department and maintenance
New customers are allocated according to the level of service and each cohort remains active throughout the customer's life.
03
Active clients
Start-up customers and any still active cohort join an active client base at the level.
04
Calculated hours
Active customers multiply the average billing hours per customer per month for each level.
05
Total revenue
The billing time is multiplied by the hourly rates and the monthly revenue are then combined at different service levels.
How are the revenue solar panel installations structured?
Article revenue assumptions links marketing, customer allocation, lifetime, active customers, billable hours and hourly rates with the revenue cohort-based engine.
Revenue assumptions
Revenue assumptions show marketing, customer cohorts, billable hours and price per hour.
02 / COGS & OPEX
How are the costs of installing solar panels and operating costs planned?
The COGS and OPEX items separate the cost of goods sold, variable costs and fixed operating expenses under the five-year forecast.
COGS & OPEX
COGS & OPEX shows the percentages of direct costs, variable costs and recurring fixed costs.
03 / Scenarios
What could be compared to the scenario of installing solar panels?
The scenario compares low, basic and high cases with respect to revenue, gross margin, contribution margin and EBITDA over five years.
Scenarios
The scenario charts compare the results of low, basic and high level and margin revenue.
04 / Dashboard
What connects the solar panel to the Installation Dashboard?
The Dashboard combines scenario control, headline KPIs, core finance, revenue mix, profitability, cash flow and payback period charts in one view.
Dashboard
The Dashboard combines the setting of scenarios, financial summaries and five-year management charts.
Product adjustment
Is the financial model for installing solar panels right for you?
The ready-made model is suitable for solar panel installation companies that use customer cohorts and billable hours; structurally different revenue or reporting requirements may require custom modelling.
Model ready
It fits perfectly
You're gaining customers through marketing spending and setting up a CAC.
You're identifying new customers at different levels of service with specific customer lifetimes.
Labour prices are described by hours and hourly rates by category of services.
You need five-year statements, screenplays, and edited operational data boards.
Order structure
Think about the model
Your revenue depends on energy generation, PPA, performance factors or energy market prices instead of paid hours.
You need project-by-project construction, financing, tax capital, or asset level schedules beyond that operational logic.
You need vastly different customer cohort rules, billing units, or contract structures.
You need reporting sizes or operational schedules that are different from the structure of the workbook.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
The Financial Models Lab can build or customize the model when you need a different revenue logic, operational schedule or reporting for your needs.
After purchase, you will receive a fully editable financial model Excel for immediate download, with five-year forecasts, scenarios and related financial statements.
01
Book to be edited
Replace assumptions regarding purchase planning, mix of services, prices, costs, employment and model setting.
02
5 - Annual Forecast
A review of the five-year forecasts with detailed monthly and annual cash flow planning.
03
Analysis of scenarios
Compare the Low, Base and High cases using scenario charts and multipliers.
04
Financial statements
Use the income statement, cash flow, balance sheet, summaries and dashboard views.
Before purchase
Installation of solar panels Financial model FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the model calculate the revenue from the installation of solar panels?
It excludes new customers from marketing and CAC spending, retains cohorts for life, converts active customers into billing hours and applies hourly rates at the level.
02
Which solar panel installation requirements can I change?
You can change the launch time, initial customers, marketing budget and seasonality, CAC, level allocation, customer usage time, billable hours and hourly rates.
03
What can I compare between low, basic and high scenarios?
A comparison of the low, basic and high revenue, gross margin, contribution margin and EBITDA trajectories of the five-year forecast can be made.
04
What financial results are taken into account?
The workbook contains the income statement, the cash flow report, the balance sheet, the financial summary, the scenarios and the dashboard.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or adapt the model to different revenue logic, operational schedules or reporting requirements.
06
Is this workbook a prediction or a guarantee?
It's editable forecast planning based on the assumptions you put in, not a guarantee of business or financial results.
What Does the Solar Panel Installation Financial Model Contain?
This downloadable solar project financial model excel file includes 5-year financial projections, a dynamic dashboard, and all essential financial statements.
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
Choosing a selection results in a full page refresh.
Revenue assumptions
COGS & OPEX
Scenarios
Dashboard
