Trusted by 25,000+ startup founders, investors and CPAs
Saved Me A Full Day
Megan Torres, FL
Building the forecast from scratch would’ve taken me all weekend, but this template cut it down to a few hours. I had a clean model ready to share with my lender the same afternoon.
Easy To Follow Tabs
Brian Ellis, OR
I’m not an Excel power user, so this was a relief. The layout made the assumptions easy to enter, and I finished the model without needing outside help.
No More Broken Cells
Lauren Mitchell, NC
I used to worry one bad formula would throw off the whole sheet, but this template kept everything tied together. That saved me from a last-minute recheck before sending it to my partner.
Model review
What is the financial model of a living green wall installation?
This is an editable five-year workbook that models customer acquisition, billed hours of service, costs, scenarios and basic financial statements.
Use the workbook to plan how marketing-based customer growth, a mix of wall-to-wall services, billed workload, hourly price, and operating expenses translate into financial results.
Effects on marketing, CAC, level allocation, customer life, billable hours and hourly rates flow through monthly calculations into revenue and reporting.
Built around assembly servicesThe revenue logic is based on active customer cohorts, payable hours per customer and hourly rates per service category.
revenue engine of the customer cohort
How is revenue calculated in the living green wall installation model?
Revenue comes from an active cohort of customers generating payable hours of service, with the monthly hours of each level multiplied by the hourly rate applied.
01
Get customers
New customers equals marketing expenses divided by customer acquisition costs.
02
Layers
New customers are assigned to specific levels or categories of services.
03
Hold the cohort
Start-up customers and unspecified acquired groups identify active customers each month.
04
Building Hours
Active customers multiply the average billing hours per customer for each level.
05
Calculation of revenue
The settlement time shall be multiplied by the hourly rate and then revenue summed in individual levels and months.
In the revenue Assumption view, the start-up time, marketing, CAC, service allocation, customer lifetime, billable hours and hourly rates for green wall services are organized.
Revenue assumptions
Worksheet presents assumptions regarding the acquisition, customer group, green wall service mix, billable hours and hourly price.
02 / COGS & OPEX
How are operating expenses organised?
Worksheet COGS & OPEX shall separate the percentage direct costs, Variable operating expenses and recurring fixed costs throughout forecast.
COGS & OPEX
The cost programme shall break down COGS, variable costs, fixed costs and monthly operating costs of forecast.
03 / Analysis of the scenario
What can be compared in different scenarios?
In the context of the scenario analysis, the low, basic and high cases for the five-year range of revenue, gross margin, contribution margin and EBITDA are compared.
Analysis of scenarios
The scenario view presents cases with low, basic and high levels in four five-year measures of effectiveness.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard combines model configuration, scenario control, key metrics, basic finance, a mix of revenue, profitability, cash flow and return on investment charts.
Dashboard
The subsidiaries consolidate configuration controls, KPIs, financial summaries, the revenue mix, cash flow and repayment.
Product adjustment
Is the financial model of a living green wall installation right for you?
The ready-made model is suitable for service providers using customer cohorts, paid hours and hourly rates; structurally different economies may require individual modelling.
Model ready
It fits perfectly
Your revenue depends on acquiring customers through a specific marketing budget and CAC.
You want to model multiple service categories with different client allocations and lifetimes.
Labour prices are mainly based on hours paid multiplied by hourly rates.
You need five-year monthly and annual projections with a script and financial reporting.
Order structure
Think about the model
Your main revenue logic is project accomplishments, ongoing offers, subscriptions, or other structure not driven by billing hours.
You need specialized operating schedules outside of customer cohorts, personnel, costs and capital expenditures.
You need a substantially different reporting structure or customized management outcomes.
You need a model tailored to the business principles not represented by the current service framework.
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 Model Laboratory may build or adapt the model where the revenue logic, operational schedules or reporting requirements differ from the finished structure.
You will receive a fully editable financial model as an instant download, with five-year projections, scenario analysis and integrated financial reporting.
01
Book to be edited
Changes in revenue, costs, personnel, capital and model assumptions in relation to business activities.
02
5 - Annual Forecast
A review of the detailed monthly and annual forecasts over the five-year model horizon.
03
Analysis of scenarios
Compare the Low, Base and High cases using a special scenario analysis view.
04
Financial statements
A review of the anticipated reports on income, cash flow, balance sheet, table and supplementary reports.
Before purchase
Living green wall of the Financial model FAQ facility
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 living green walls?
It calculates the revenue from active customers, the average billable hours per active customer and the hourly rates per service level. New customer cohorts are created from marketing expenditure shared by CAC.
02
Which assumptions can I change?
You can change the launch time, initial customers, marketing budget and seasonality, CAC, service allocation, customer life, billable hours and hourly rates.
03
What can I compare between low, basic and high scenarios?
From the perspective of the scenario analysis, the alternative cases for revenue, gross margin, contribution margin and EBITDA under the five-year forecast are compared.
04
What financial results are taken into account?
The product shall present the income statement, the report of cash flow, the balance sheet, dashboard, the summary, the settlement, ROIC, the estimates, the charts, KPI, the relationships and supporting reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers personalised financial modelling for different revenue logics, operational schedules or reporting requirements.
06
Is this 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 Living Green Wall Installation Financial Model Contain?
You get a complete toolkit to build a comprehensive financial plan for your living green wall installation business.
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
