Trusted by 25,000+ startup founders, investors and CPAs
Clear Profit Picture
Megan Collins, TX
This template made margins and break-even easy to see, so I could spot the weak spots fast and tighten the plan before our lender call.
Safer Formula Editing
Derek Nguyen, OR
I stopped worrying that one broken cell would throw off the whole model. The structure kept my edits clean, and I saved about 4 hours of back-and-forth checking.
Cash Flow Made Clear
Priya Shah, FL
It showed runway and likely shortfalls in a way I could actually use, so I booked our funding review with better timing and fewer guesses.
Model review
What is the financial model for sustainable housing?
This is an editable five-year workbook on customer acquisition planning, billable hours, hourly rates, costs, scenarios and related financial statements.
Use the model to translate the landing ship service plan into monthly revenue, operating expenses, cash flow, profitability and financial position.
The editable assumptions are the source of the workbook calculations, while the dashboard, scenario analysis and financial statements are updated from the basic operational plan.
Built around the client's activityRevenue results from active customer groups, their billable hours and the hourly rates assigned to each service category.
revenue engine of the customer cohort
How is the revenue calculated from the construction of land ships in this model?
Marketing costs and CAC create new customers, cohorts remain active throughout life and active customers generate billable hours by service level.
01
Get customers
Monthly marketing spending divided by CAC determines new customers.
02
Layers
New customers are assigned to all updated service levels.
03
Hold the cohort
Initial and unusual client cohorts identify active clients each month.
04
Building Hours
Active customers multiply by average monthly billing hours for each level.
05
Calculation of revenue
Settlement activities are multiplied by hourly rates and then combined with level revenue.
In the revenue Assumptions view, start-up times, marketing, CAC, customer mix, usage time, billable hours, rates and monthly seasonality are organized.
Revenue assumptions
The Worksheet shows the purchase, the allocation of customers, the lifetime of the cohort, the billing time, the price and the seasonal contribution.
02 / COGS & operating expenses
How are construction and operating costs organised?
COGS & Operating expenses separates direct costs, variable costs and fixed overhead costs with detailed time and monthly calculation information.
COGS and operating expenses
Worksheet shall break down COGS, Variable operating expenses and recurring general costs by period.
03 / Analysis of the scenario
What can be compared with things low, low, and high?
The scenario analysis compares the alternative revenue, gross margin, contribution margin and EBITDA paths for low, basic and high workbook cases.
Analysis of scenarios
The projection shows the results of revenue and the margins of low, basic and high levels over the five years forecast.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard combines configuration controls, scenario outcomes, core finance, revenue mix, profitability, cash flow and return on investment in one management view.
Dashboard
The Dashboard summarizes the configuration, scenarios, KPIs, revenue, profitability, cash flow and repayment.
Product adjustment
Is the financial model for building sustainable homes on a land ship right for you?
This corresponds to a service business run by customer cohorts, billable hours and hourly rates; different structures of revenue logic may require individual modelling.
Model ready
It fits perfectly
Your revenues come primarily from paid construction, design or installation hours.
You're getting customers through a marketing budget and you're tracking the cost of acquisition.
You want different levels of service with different customer lifetimes, hours and prices.
You need related costs, scenarios, statements and management reports as part of that operational plan.
Order structure
Think about the model
Your main revenue depends on home sales, not customer billed hours.
Your basic revenue logic is billing, maintaining, or recognizing contract-specific instead of customer billed hours.
Your main operating engine is a project-by-project construction schedule, not a customer cohort.
The reporting structure requires substantially different calculations or specialist results.
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 an immediate, fully editable financial model for Excel or Google Sheets with five-year forecasts and linked reports.
01
Book to be edited
Update the revenue, costs, staff, capital, funding and other assumptions for the plan.
02
Forecast five years old
An overview of the five forecast years with detailed monthly calculations and annual reporting visions.
03
Analysis of scenarios
Compare the Low, Base and High cases in key revenue and profitability areas.
04
Financial statements
Use the related income, cash flow, balance sheet, dashboard and summary reports.
Before purchase
Shipbuilding Sustainable home building 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 construction of the Earthship?
It counts new customers from marketing and CAC spending, maintains active cohorts, and then multiplies billed hours by hourly rates at each service level.
02
Which assumptions can I change?
You can change the launch time, initial customers, marketing budgets and seasonality, CAC, level allocations, customer lifetime, billable hours and hourly rates.
03
What can I compare between low, basic and high scenarios?
Alternative revenue, gross margins, contribution margins and EBITDA paths can be compared in three scenarios.
04
What financial results are taken into account?
The product shall present the income statement, the cash flow report, the balance sheet, the dashboard, the summary, the settlement, the ROIC, the estimates, the charts, the KPIs and other reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers individual financial modeling when you need a different revenue logic, operational schedule or reporting.
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 Earthship Sustainable Home Construction Financial Model Contain?
Your download includes a comprehensive financial model template with pre-built statements, dashboards, and assumption tabs to guide your budgeting for autonomous home construction.
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 and operating expenses
Analysis of scenarios
Dashboard
