Clear Investor Story
I finally had a clean structure for the numbers, so I could answer investor questions without guessing. It saved me hours of reworking slides and made the funding conversation much easier to follow.
I finally had a clean structure for the numbers, so I could answer investor questions without guessing. It saved me hours of reworking slides and made the funding conversation much easier to follow.
I was worried one wrong cell would throw everything off, but this model kept the math organized and easy to check. I caught issues faster and avoided a late-night rebuild before my meeting.
The pricing, costs, and growth inputs were laid out clearly, so I wasn’t digging through scattered tabs anymore. It helped me tighten my plan and cut a full afternoon of cleanup.
This is a fully edited five-year Excel modeling workbook for beauty subscriptions, churn, level prices, operating costs, scenarios, and financial statements.
Use the planning workbook, as marketing seems, CAC, samples, paid activations, chrunns, mix levels, subscription prices and allowances translate into recurring needs for revenue and cash.
Editable assumptions relate to monthly calculations, scenarios and reports, including profit and loss accounts, cash flow accounts, balance sheets, distribution panels and summaries.
The model changes marketing-driven logins into paid subscriber cohorts, uses churn prices and accuracy levels, and adds on-line support, configuration, field, add-on and refund adjustments.
New provisions equal marketing expenditure divided by CAC, divided between free samples and direct paid start.
The earlier test cohorts shall be transformed after the duration of the trials and shall be combined with the current activations paid directly.
Paid activations are assigned at all levels, and then active roll subscribers forward after churn.
Level subscriptions add the possibility to use, configure, box, additional revenue and refund adjustments.
Annual amounts of monthly income recognised revenue layers; ARR remains only run-rate KPI.
The revenue card centralises marketing, CAC, trial time, paid conversion, mix of levels, subscriber life, prices, fees for configuration and transaction assumptions.
REVENUE
The COGS & OPEX sheet separates product and packaging costs from variable marketing, execution, dispatch and fixed operating costs.
COGS & OPEX
The Scenarios’ overall forecast compare low, base and high revenue, gross margin, premium margin and EBITDA.
SCENARIOS
The navigation desk combines configuration controls, scenario multipliers, basic finances, revenue mix, profitability, cash flow and return on investment in one view.
DASHBOARD
Matches subscriptions and cohorts economy of beauty boxing; custom modelling is more appropriate when revenue logic, operating schedules, or reporting differ materially.
The template is the starting point of planning, not a guarantee of performance.
The financial models of Lab can build or customize a model when you need different revenue logic, operating schedules or reporting around your requirements.
ORDER A CUSTOM FINANCIAL MODELAfter check-out you will receive an editable financial model Subscription Beauty Box for five-year planning with monthly and annual details, scenarios and financial reports.
Updated assumptions and model inputs in Excel download workbook.
The review forecasts throughout the five-year planning horizon.
Compare low, base and high cases with key financial results.
Preview income account, cash flow, balance sheet, dashboard and summary of results.
The basic answers are visible in their entirety, without clicking on the accordion.
The model converts marketing spending to registrations, separates tests and direct paid off start, uses conversion, mix levels, churns and prices, and then adds the included layer of monetization.
You can edit start time, marketing expenses, CAC, mix of trials and conversions, churn or life, level prices, usage, configuration fees, delivery, addition and return of expenditure.
The Scenarios compared the low, base and high revenues, gross margin, premium margin and the trajectory of EBITDA in the five-year forecast.
In the Workbook There Is a Statement About Income, Statement About the Flow of Money, Balance Sheet, Navigation Desk, Scenarios and Results of Summary.
Yes. Financial Models Lab can build or customize a model when you need different revenue logic, operating schedules, or reporting.
This is a forecasting model, not a performance guarantee. Results depend on assumptions and selected scenarios.
This downloadable financial plan for a new beauty subscription business contains everything you need to forecast performance, manage cash, and secure funding.
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