All Reports In One Place
This template pulled our statements and charts into one file, so I spent less time hunting for tabs and more time reviewing the numbers. It cut my monthly reporting prep by about 6 hours.
This template pulled our statements and charts into one file, so I spent less time hunting for tabs and more time reviewing the numbers. It cut my monthly reporting prep by about 6 hours.
I finally had the structure investors expected, with the right outputs in the right place. We booked a follow-up meeting the same day because the model was easy to walk through.
Switching between low, base, and high cases used to be a mess, but this made it simple. I built all three scenarios in under an hour instead of losing half a day to manual edits.
This editable Excel and Google Sheets models subscription purchase, horizontal recurring revenue, allowances, and five-year financial projections.
Use the workbook to create forecasts for a perfume subscription company, from buying and converting subscribers through recurring revenue, costs, cash flow and financial results.
The Editorial assumptions are related operational schedules and reports, so changes in marketing, CAC, samples, mix plan, churn, prices, allowances, costs and flow of funding to forecast.
The model converts the marketing-based login to pay subscriber cohorts, uses mix and churn plan, and then adds enabled service, configuration, field and additional revenue.
New marketing records are issued by ÷ CAC and then split into free and paid start-ups.
After the trial period, converted test cohorts are added to the current direct activation paid.
Paid activations are distributed at different levels of subscription using a editable set of client plans.
Active subscribers continue to drive around the wall, generating MRR plus the layers of secondary income included.
Monthly recognised subscription income amounts and optional strata; annual incomes shall add up monthly periods.
The revenue outlook combines the acquisition, the trial swap, the allocation of tiers, maintenance, valuation and optional transaction inputs used in the subscription forecast.
REVENUE
View COGS & OPEX organizes direct product costs, fulfilment, marketing, payment processing, customer service and fixed overhead costs by forecasting period.
COGS & OPEX
The Scenarios compared alternative cases with respect to revenues, gross margin, premium margin and EBITDA in the five-year forecast.
SCENARIOS
The data table consolidates in one view scenario checks, basic financial results, income set, profitability, cash flow, reimbursement and headline indicators.
DASHBOARD
Where no other model exists within the project, it should be replaced.
The template is the starting point of planning, not a guarantee of performance.
The Lab financial models can build or adapt a model when you need different revenue logic, operational schedules or financial reporting.
ORDER A CUSTOM FINANCIAL MODELYou will receive an immediate, fully-editable financial model Excel and Google Sheets with a five-year forecast, scenarios, dashboards and financial reports.
Adjustment of subscription, acquisition, conversion, churn, prices, costs, personnel, capital and financing assumptions.
Review of five-year financial projections with detailed monthly and annual planning results.
Compare low, basic and high cases with regard to measures on income and profitability.
Use related statements, navigation desktops, summaries, valuations, break-even, returns, charts, KPIs and relationship reports.
The basic answers are visible in their entirety, without clicking on the accordion.
It converts marketing expenditure and CAC into registers, uses trial and direct activation, a mix of plans, churns, level prices and has included secondary revenue levels.
You can edit start time, marketing and seasonality, CAC, duration and duration of trials, conversion, mix of plans, subscribers, churn or lifetime, price, use, configuration fees, shipping frequency, accessories, and returns.
The Scenarios compared the alternative low, base and high results in terms of revenues, gross margin, premium margins and EBITDA in the whole forecast.
The product gallery presents a statement of income, cash flow, balance sheet, dashboard, summary, valuation, break-even, ROIC, graphs, KPIs, indicators, DuPont, and revenue and expenditure reports.
Yes. Financial Models Lab offers custom financial modelling when you need different revenue logic, operational schedules or reporting structure.
This is a planned forecast based on the possible editing assumptions, not a guarantee of business results, profitability, financing or returns.
You get a comprehensive Excel and Google Sheets template designed specifically for a perfume subscription box startup.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark