Trusted by 25,000+ startup founders, investors and CPAs
Clear Break-Even Insight
Megan Foster, TX
This template made margins and break-even much easier to see, and I finally stopped guessing at pricing. It saved me hours of spreadsheet work when I was checking different scenarios.
All Reports In One File
Daniel Reed, NY
I used to keep the P&L, charts, and assumptions in separate files, which was a mess. Having everything in one place cut my monthly reporting prep by about 4 hours.
Cash Flow Looks Much Clearer
Lauren Mitchell, FL
The monthly cash flow view made runway and shortfalls easier to track, so I could plan funding earlier. It helped me spot a gap before it turned into a problem.
MODEL OVERVIEW
What Is the Financial Model of Pepper Spirit Installation?
The Financial Installation Ilusion model from Pepper is a five-year workbook that combines product line units, prices, seasonality and cost assumptions with financial statements, scenarios and dashboard reporting.
Use the model to plan how different products of Pepper's Ghost installation go since take-off and unit size through sales revenue, costs, profitability, cash flow and financial situation.
Editable operational assumptions are the source of monthly calculations, while annual summaries, scenarios, statements and management views are updated from these inputs.
Built for product line planningChange in the size of units, prices, start dates, seasonality, costs, personnel and capital assumptions to check how the forecasts react.
ENGINE OF REVENUE WITH A LINE OF PRODUCTS
How Does Model Calculate the Revenue from Pepper's Ghost Installation?
The model multiplys the recognised product units at the sales price of each line, applies the launch date and monthly seasonality once and then adds any separately possible additional income.
01
Define Product Lines
Set each line of installation product produced and the time it is started, if applicable.
02
Enter Volume of Units
The units produced for each product and the forecasting period shall be reported.
03
Set Sales Prices
Assigning a matched sales price per unit for each of the product lines included.
04
Application of Recognition
The shown revenue schedule treats the units produced as a sales volume and then the monthly seasonality is applied once.
05
Calculate Income
Total recognised sales revenue of product lines and any separately entered additional income.
FORM OF CORRECTIONRevenue = units produced × selling price + ancillary revenue
01 / REVENUE
Which Entry Drive Product-Rising Line?
The five-year plan combines product names and the timetable for starting business with the units produced, sales prices, seasonality and revenue projections at product level.
REVENUE
The sheet shows the dates of launch, unit size, price, seasonality and revenue forecasts at product level.
02 / COGS
How Are the Product Costs Structured?
The COGS provides direct costs specific to the product based on calculations, annual assumptions and monthly schedules, so that cost drivers can follow the revenue forecast.
COGS
The sheet shows the product-specific cost categories, calculation bases, assumptions and monthly cost schedules.
03 / SCENARIO ANALYSIS
What Can Be Compared in Low, Basic and High Cases?
In the light of the analysis of the scenarios, the low, base and high results in terms of revenues, gross margin, premium margins and EBITDA were compared in the five-year forecast.
ANALYSIS SCENARIO
The view shows low, base and high paths for revenue and profitability resources.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The navigation desk combines the control of scenarios with the basic finances, the mix of revenues, cash flow, profitability, return on investment and the headings on operational indicators and returns.
DASHBOARD
The dashboard combines scenario settings, financial trends, revenue mix, cash flow, cost reimbursement and metrics.
FIT OF PRODUCTS
Is Illusion Financial Model Suitable for You?
The template fits with product-based installation companies that provide units and prices by line, while significant differences in income recognition or operating schedules may require non-standard modelling.
MODEL BY MADA READY
Good Example
You sell different Pepper's Ghost installation products with separate quantities and prices.
Estimated time of product start, annual number of units and monthly seasonality.
You want a specific product COGS related to operating costs, wages and CAPEX.
You use low/basic/high scenario analysis and navigation desktop reporting to plan.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your basic income is consistent with subscriptions, hourly fees or transaction fees instead of selling products.
Your recognition of income requires a substantial variety of reservations, deliveries, or inventory conventions.
Your operational schedules require production, performance, or inventory logic beyond product line setting.
Reporting structure requires custom management results or business schedules.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The financial models of Lab may build or adapt a model where the revenue logic, operational schedules or reporting requirements differ from the final template.
You will receive an editable financial model Excel and Google Sheets with five-year monthly and annual forecasts, low-base/High and related financial reports.
01
Editable workbook
Directly change revenues, costs, staff, capital, financing and other supported assumptions.
02
Five-year forecast
Review of detailed monthly and annual forecasts throughout the five-year planning period.
03
Analysis of scenarios
Compare low, base and high cases through a special view of the script.
04
Financial statements
Use associated P&L, cash flow, balance sheet, summary, dashboard and follow-up reports.
BEFORE BUYING IMPORTANT INFORMATION
Illusion Illusion Installation Pepper's Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the revenue of Ghost Illusion Pepper's installation?
Multiply units produced for each option of the product line by the matching selling price, then sum up the revenue from the product and any separately included additional revenue. Monthly seasonality is applied once the annual input data is reported monthly.
02
What are the assumptions I can change?
You can edit product line names, start time, unit volumes, sales prices, sales by or recognition of stocks where displayed, monthly seasonality and included additional revenue.
03
What can I compare in Low, Base and High scenarios?
In the light of the analysis, the scenarios compared low, basic and high revenue paths, gross margin, premium margin and EBITDA in the five-year forecast.
04
What financial results are taken into account?
The current product shows a dashboard, income statement, cash flow statement, balance sheet, summary, scenario analysis and additional management reports and charts.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. The financial models Lab offers custom financial modelling when you need different revenue logic, operating schedules or reporting structures.
06
Is this a forecast or a guarantee?
This is a planned forecast based on assumptions for the edition, not on the guarantee of revenue, profitability, financing, returns or business performance.
What Does the Pepper's Ghost Illusion Installation Financial Model Contain?
This comprehensive template includes everything you need to build a robust financial plan, from detailed revenue and expense forecasting to valuation analysis and investor-ready summaries.
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
COGS
ANALYSIS SCENARIO
DASHBOARD
