Trusted by 25,000+ startup founders, investors and CPAs
No More Blank Starts
Megan Carter, OR
I didn’t know where to begin, and building a skylight install model from scratch felt bigger than the project itself. This template gave me a clean starting point and saved me about 6 hours.
Formulas Stayed Intact
Daniel Brooks, NC
I was worried one broken cell would throw off the whole sheet. The built-in formulas and layout made it much easier to trust the numbers and cut my double-checking time in half.
Investor Format Was Clear
Priya Shah, NJ
I wasn’t sure what outputs investors would expect for this kind of service business. The template laid out the assumptions and summaries so clearly that I booked a lender call the same day.
Model review
What does the financial model of a product called Skylight Installation Service include?
The Skylight Installation Service financial model is an editable five-year workbook modeling customer cohorts, billing hours, hourly rates, monthly forecasts, scenarios and financial statements.
Use your workbook to translate marketing acquisition of customers, mix of services, customer life expectancy, billing hours and hourly rates into structured operational forecast.
Editable assumptions flow through the revenue engine and combine cost schedules into monthly forecasts, low / underlying / high cases, reports and management reports.
Built to plan the editedReplace the sample assumptions with its own operational introductions and analyse how the related forecasts change.
customer-cohority revenue engine
How does Skylight's installation service calculate revenue?
The model transforms marketing expenses into new customers, allocates and maintains customer cohorts according to service level, then calculates billed hours and hourly revenues.
01
Get customers
New customers equals marketing expenses divided by customer acquisition costs.
02
Layers
New customers are allocated to selected service levels or customer levels.
03
Hold the cohort
Starting clients and still active cohorts remain based on the life of the client at each level.
04
Building Hours
Active customers multiply the average monthly billing hours for each service level.
05
Calculation of revenue
The accounting time is multiplied by an hourly rate and then the level revenues are added up over the months.
In the revenue statement there are combined expenses for marketing, CAC, customer allocation, life expectancy of cohorts, invoicing hours and hourly rates with the forecast of revenues from services.
Revenue assumptions
The spreadsheet for the forecasting of revenue shows the acquisition of customers, the activity of the cohort, the hours of invoicing and price entries.
02 / COGS & OPEX
What is the structure of operating expenses?
The COGS & OPEX spreadsheet separates the percentage of direct costs, variable operating costs and fixed costs repeated in the monthly forecast.
COGS & OPEX
The COGS & OPEX spreadsheet organises direct, variable and fixed cost assumptions with monthly results.
03 / Analysis of the scenario
What can be compared in different scenarios?
The scenario analysis compares the Low, Base, and High paths for revenue, gross margin, contribution margin and EBITDA over the five-year period of forecast.
Analysis of scenarios
The scenario analysis calculation sheet compares financial trajectorys with Low/Base/High in particular key performance measures.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use the navigation desktop to review configuration controls, multiple scenarios, financial results, mix of revenues, profitability, cash flow and investment return in one place.
Dashboard
You can use the navigation desktop to review the models, performance of selected cases, mix of revenues, profitability, cash flow and visualize the period of return of the investment.
Product adjustment
Is the Skylight installation service financial model suitable for you?
The template is suitable for companies that purchase customers of services through marketing and coinise active customer cohorts through invoicing hours and hourly rates.
Model ready
It fits perfectly
Your revenue starts with marketing expenses and customer acquisition costs.
You will provide new customers with different levels of services or customers.
Active customer cohorts remain for a specified life period of customers.
Your services are coined through paid hours and hourly rates.
Order structure
Think about the model
Your main revenue depends on the design offers, not the cohorts.
You need limitations on the ability directly related to crews, vehicles or installation sites.
You need additional operating schedules outside the associated template structure.
You need a reporting logic that is very different from the confirmed results 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?
Financial Models Lab can build or customize a model when you need a different revenue logic, operational schedule or financial reporting.
You will receive a fully-editable financial model for Excel and Google Sheets with five-month projections, scenarios, financial reports and management reports.
01
Editable workbook
Update model assumptions and related entrances to your window installation company.
02
Five-year forecast
Review of monthly revenues, costs, profitability, cash flow and financial situation forecasts.
03
Analysis of scenarios
Comparison of low, base and high cases in the framework of basic financial performance measures.
04
Financial statements
Use the linked income statement, cash flow, balance sheet, dashboard and summaries.
Before purchase
Air Light Mounting Service Financial Models FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the financial model calculate revenues from business activities called skylight installation?
It counts new customers with marketing expenses and CAC, stops cohorts, turns active customers into invoicing hours and increases hours by hourly rates.
02
Which assumptions can I change?
You can edit start-up times, beginners, marketing budgets and seasonality, CAC, customer mix, customer usage time, invoicing hours and hourly rates.
03
What can I compare between Low, Base, and High scenarios?
A comparison can be made between revenue, gross margin, contribution margin and EBITDA pathways for Low, Base, and High.
04
What financial results are taken into account?
The product presents the profit and loss account, cash flow report, balance sheet, navigation desktop, summary, scenario analysis and additional management reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. Financial Models Lab offers customized modeling for buyers who need different revenue logic, operating schedule or financial results.
06
Is the workbook a prediction or a guarantee?
This is a planning forecast based on edited assumptions, not a guarantee of business results or financial results.
What Does the Skylight Installation Service Financial Model Contain?
This Excel financial model for skylight installation service includes everything you need to build a comprehensive financial plan, from detailed revenue forecasts and expense breakdowns to valuation analysis and profitability metrics.
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
Analysis of scenarios
Dashboard
