Soft Story Retrofit Financial Model Template for Excel and Google Sheets
Five-year projections, dashboard, P&L, cash flow, balance sheet, and three scenarios - pre-built in Excel and Google Sheets. Built for soft story seismic retrofit projects. Delivered as an instant download.
Trusted by 25,000+ startup founders, investors and CPAs
Scenario Planning Made Simple
Megan Collins, CA
The low, base, and high cases were already laid out, so I stopped wasting time toggling assumptions by hand. I built my forecast in under an hour and had a cleaner version ready to share the same day.
Profitability Was Easy To See
Derek Lawson, TX
I could finally see margins and break-even without digging through formulas, which made pricing decisions much easier. It saved me a few hours and gave me a clear number to discuss in our lender meeting.
Easy Enough For Non-Modelers
Priya Shah, NY
I’m not deep in Excel, so the step-by-step layout was a relief. I filled in the inputs and had a working model fast, without needing to call in a consultant.
Model review
What does the financial model of a product called Soft Story Seismic Retrofit include?
This editable five-year workbook forecasts the upgrade offers based on the units produced and sales prices, and then combines results with scenarios and financial statements.
Use the model to plan separate lines of modernisation and related service lines, establish unit size and prices, plan operational costs and review the expected financial results.
The operational assumptions shall be updated through monthly and annual calculations to the navigation desktop, scenario analysis, profit and loss account, cash flow and balance sheet statements.
Built around edited driversChange the number of product lines, prices, seasonality, costs, employment, capital expenditure and financing assumptions to reflect your plan.
revenue engine of the product line
How does the financial model calculate revenues from business activities called Soft Story Seismic Retrofit?
Each offer is made to predict the units produced independently, multiplied by the corresponding selling price, applied the seasonality once a month and added the enabling additional revenue.
01
Definition of the line
Set the name of each tender and the launch date when the start date is valid.
02
forecasting units
Enter units produced for each offer; the visible schedule treats this production as a recognised sales volume.
03
Prices set
Set the appropriate selling price per unit of each line on.
04
time allocation
The monthly seasonality shall be applied once and the additional revenue paid separately, if possible, shall be taken into account.
05
Calculation of revenue
Revenues from total units within lines provided plus any additional revenue.
Basic formularevenue = units produced × sales price + additional revenue
01 / Settlement of revenue
How is revenue organised?
The revenue setting view organizes the name of the offers, the time of launch, the number of units, the sales prices, seasonality and resulting revenue forecasts in one operating schedule.
revenue scope
The view shows the volume of offers, prices, seasonality and forecast revenues.
02 / COGS
How does the structure of the COGS schedule lead to direct costs?
The COGS view separates the categories of direct costs according to offers and calculation bases, supporting both the interest related to income and the operational assumptions per unit.
COGS
The COGS view shows the categories of direct costs specific to the offer and the basis for calculation.
03 / Analysis of the scenario
What's there to compare in scenario analysis?
The scenario analysis compares the Low, Base, and High levels for revenue, gross margin, contribution margin and EBITDA over the forecast period of five years.
Analysis of scenarios
The report presents the financial results of low, base and high throughout the forecast.
04 / Dashboard
What Does the Dashboard Bring Together?
The navigation desk allows an overview of the overall configuration, scenario control, key performance indicators (KPIs), a mix of revenues, profitability, cash flow and a period of return on investments in one place.
Dashboard
navigation desktop consolidation of configuration control, scenario results, KPIs and financial charts.
Product adjustment
Is Soft Story Seismic Retrofit the financial model suitable for you?
The ready model adapts the planning of individual and valuable revenues to the workbook structure; significantly different contract logic or reporting may require individual modelling.
Model ready
It fits perfectly
Your offers can be expected based on units manufactured and corresponding sales prices.
You want the annual drivers to be allocated according to the monthly seasonal schedule.
You need an editable five-year forecast with P&L, cash flows and balance sheet results.
You want a comparison of low, base and high plus a combined navigation desktop.
Order structure
Think about the model
Your revenue depends primarily on invoicing, payment or progress claims.
Your recognition logic requires customized work in progress or inventory schedules.
Your cost model requires labour costs at project level outside the COGS structure.
Your reporting structure or entity requires timetables beyond the standard model 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?
The Financial Models Laboratory may build or adapt the model where a different revenue logic, operational schedule or reporting is needed than provided in the ready-made template.
You will receive a fully-editable financial model of Excel and Google Sheets with five-year forecasts, scenario analysis, navigation desktop reporting and basic financial statements.
01
Editable workbook
Update of operational assumptions, costs, employment, capital, financing and reporting of the model.
02
Five-year forecast
Review of five-year forecasts with detailed monthly and annual financial statements.
03
Analysis of scenarios
Compare Low, Base, and High cases in key financial results.
04
Financial statements
Use your navigational desktop, P&L, cash flow and balance sheet to review your planning.
Before purchase
Soft Story Sysmic Retrofit Financial model 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 Soft Story Seismic Retrofit?
Revenues shall be calculated from units produced for each tender provided that it is multiplied by the relevant selling price, using monthly seasonality and added additional revenue when available.
02
Which assumptions can I change?
You can edit the names of the offers, start dates, units produced, sales prices, monthly seasonality, additional income and related operational assumptions of the model.
03
What can I compare low, base, and high scenarios to?
In view of the analysis of the scenario, the alternative paths of revenue, gross margin, contribution margin and EBITDA under the five-year forecast are compared.
04
What financial results are taken into account?
The model includes a navigational desktop, P&L, cash flow report, balance sheet, scenario analysis and additional financial reporting views.
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 the workbook a prediction or a guarantee?
This is an editable planning forecast based on the assumptions you are introducing, not the guarantee of business results or financial results.
What Does the Soft Story Seismic Retrofit Financial Model Contain?
You get a comprehensive and fully editable financial model in Excel and Google Sheets format, complete with a dynamic dashboard, 5-year forecasts, and detailed breakdowns of all revenues, costs, and investments.
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 scope
COGS
Analysis of scenarios
Dashboard
