Trusted by 25,000+ startup founders, investors and CPAs
Formula-First Confidence
Megan Carter, TX
The spreadsheet stayed intact while I changed assumptions, which saved me from a broken-model headache and about 3 hours of cleanup. I could update inputs without worrying one wrong cell would throw everything off.
Investor-Ready Structure
Daniel Brooks, NY
This template showed me exactly what investors expect, so I stopped guessing and finished the deck outline in one afternoon. It made the funding story much clearer before my first meeting.
See Profit Margins Clearly
Lauren Mitchell, FL
I could finally see margins and break-even without digging through tabs, and that saved me a full day of manual checks. It made pricing and volume decisions much easier to explain.
Model review
What is included in the financial model of the Curated Gift Box Service?
This editable Excel workbook provides a five-year Curated Gift Box Service using customer acquisition, follow-up orders, product mix, prices and related financial statements.
Use the workbook to plan how marketing spending, CAC, repeat purchases, order units, gift box sales mix, and category prices translate into revenue and cash flow.
Editable operating income is the source of monthly calculations, while costs, payments, capital, financing, working capital and scenario controls are combined with financial statements and management.
Cohort-based e-commerceNew and recurring customer activities create orders and units before the sales mix allocates units in individual product categories.
revenue engine of the customer cohort
How is the revenue Curated Gift Box model calculated?
The model acquires customers by channel, transfers repeat buyers, converts orders into units, allocates units by sales mix and prices for each category.
01
Customer acquisition
Calculate new customers by channel as marketing expenditure shared by the CAC of that channel and then connect online and offline customers.
02
Multiple buyers
Use the percentage of customers visiting, the lifetime and the order visiting rate to maintain the activity of the qualifying customers.
03
build units
Add the first purchase order and repeat, and then multiply the total number of orders by the average unit per order.
04
Separate the mixture
Breakdown of the common set of units by product category using the introduced mix of sales.
05
Calculated Revenue
Multiple allocations of category units according to the price of the corresponding category, followed by the amount of revenue in individual categories and months.
Basic formulaRevenue = allocated units × category price
01 / Revenue
How do the income contributions build the gift box's forecast?
Worksheet revenue organizes channel marketing budgets, CAC, repeat customer behaviour, order units, gift box sales mix, prices and a forecast of revenue results.
Revenue
The revenue view displays purchases, multiple customers, mixes of individual gift boxes and price categories.
02 / COGS & OPEX
How are COGS and operating expenses organised?
Worksheet COGS and OPEX shall separate the percentage COGS related to revenue, Variable Costs and Fixed operating expenses as part of the five-year forecasts.
COGS & OPEX
The COGS & OPEX view shows the assumptions for direct, variable and fixed-time expenditure.
03 / Analysis of the scenario
How do you compare Low, Base, and High cases?
In terms of scenario analysis, the Low, Base, and High trajectories for revenue, gross margin, contribution margin and EBITDA over five years are compared.
Analysis of scenarios
The review of the analysis of the scenario compared revenue, gross margin, contribution margin and EBITDA in three cases.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use the dashboard to view model configurations, scenario checks, working capital contributions, financial data, revenue mix, profitability, cash flow and payback period visualization of investments.
Dashboard
Dashboard Consolidation of configurations, scenarios, mixes of revenue, profitability, cash flow and returns.
Product adjustment
Is the Curated Gift Box's financial model right for you?
A ready-made model is compatible with customer-acquired e-commerce sales, whereas substantially different revenue mechanisms, operating schedules or reporting structures may require individual modelling.
Model ready
It fits perfectly
You're gaining new customers by spending on channel marketing and setting up CAC.
Modeling repeat buyers based on repeat frequency, activity and average number of repeat orders.
You're predicting orders, units per order, a mix of sales of categories and price of categories.
You want Cases Low, Base, and High from financial statements and management reports.
Order structure
Think about the model
Your revenue depends on subscriptions, market fees, usage invoicing or another mechanism instead of e-commerce orders.
Customer retention requires more detailed cohort curves, churn logic, or repeated product-level behavior.
Your directory needs a record, fulfillment, license, or creator-owned program outside of your current operating configuration.
You need very different work schedules, calculations, or internal-requirements-based decision reports.
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.
After purchase, you will receive an editable Excel model as an instant download with a five-year monthly forecast, scenario analysis and related financial statements.
01
Editable workbook
Updating the launch time, marketing budgets, CAC, repeat customer data, assumptions regarding orders, sales mix, prices, costs, staff, capital and financing.
02
Five-year forecast
Planning of financial results over monthly 60 periods within the five-year projection horizon.
03
Analysis of scenarios
Compare Low, Base, and High cases in the workbook scenario.
04
Financial statements
Look at the income statement, the cash flow report, the balance sheet, the dashboard, the summary and the supplementary reports.
Before purchase
Curated Gift Box Service 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 the revenue from the Curated Gift Box Service?
It calculates new customers by channel from marketing expenditure divided by CAC, adds active recurring customer orders, converts orders into units, allocates units by sales mix and applies category prices.
02
What assumptions regarding the use of the gift box can be changed?
You can edit the launch date, channel marketing budgets and seasonality, CAC, recurring customer percentage and usage period, recurring orders, unit per order, category sales mix and category price.
03
What can I compare between Low, Base, and High scenarios?
A comparison can be made of the Low, Base, and High trends for revenue, gross margin, contribution margin and EBITDA in the five-year forecast.
04
What financial results are taken into account?
The workbook contains the income statement, the cash flow statement, the balance sheet, the dashboard, the summary, the profitability threshold, the ROIC, the charts, the KPIs, the indicators and the valuation.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or customize the model when you need a different revenue logic, operating schedule or reporting.
06
Is the workbook a prediction or a guarantee?
This is a planning forecast based on the assumptions contained in the workbook and not a guarantee of economic performance.
What Does the Curated Gift Box Service Financial Model Contain?
This pre-built financial model for a gift box company in Excel provides everything you need to build a comprehensive financial plan, from initial startup budget to a full five-year forecast.
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 & OPEX
Analysis of scenarios
Dashboard
