Acquire Customers
Online and offline marketing spend divided by channel CAC calculates new customers by channel.
This editable five-year workbook models customer acquisition, repeat purchasing, category sales, costs, scenarios, and linked financial statements for a luxury ecommerce store.
Use the model to connect marketing budgets and CAC to customer volumes, repeat orders, category unit sales, pricing, costs, and financial performance.
Change the operating assumptions in the workbook, and the linked calculations update monthly projections, scenario views, statements, and management reports.
Revenue starts with channel marketing spend and CAC, adds active repeat buyers, converts orders into units, allocates category mix, and applies category prices.
Online and offline marketing spend divided by channel CAC calculates new customers by channel.
A share of new customers becomes repeat buyers who stay active for the stated lifetime.
Monthly orders combine first purchases with active repeat customers multiplied by repeat order frequency.
Orders become units using units per order, then category sales mix allocates the unit pool.
Allocated category units are multiplied by category prices and summed across categories and months.
The Revenue view brings together channel acquisition, repeat-customer behavior, order volumes, product mix, and category pricing that drive projected sales.
REVENUE
The COGS & OPEX view organizes direct costs, variable operating expenses, and fixed expenses with timing and percentage-based assumptions.
COGS & OPEX
The Scenarios view compares alternative cases for revenue, gross margin, contribution margin, and EBITDA across the five-year projection.
SCENARIOS
The Dashboard combines model setup, scenario controls, revenue and expense outputs, cash flow, profitability, key metrics, and payback charts.
DASHBOARD
The ready-made model fits a channel-driven luxury ecommerce structure; materially different revenue logic or operating schedules may call for custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting from the ready-made structure.
ORDER A CUSTOM FINANCIAL MODELYou receive an editable downloadable financial model with a five-year forecast, scenario analysis, and linked financial statements and management reports.
Open and edit the financial model in Excel or Google Sheets.
Project the business across five years with monthly cash-flow detail.
Compare Low, Base, and High cases through the model's scenario view.
Review linked P&L, cash flow, balance sheet, and management reporting outputs.
The essential answers are visible in full, with no accordion clicks required.
It calculates new customers from marketing spend and CAC, adds repeat cohorts, converts orders to units, allocates category mix, and applies category prices.
You can edit launch date, channel marketing budgets and seasonality, CAC, repeat behavior, units per order, sales mix, and category prices.
You can compare alternative revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast.
The product page shows P&L, cash flow, balance sheet, dashboard, scenarios, summary, break-even, ROIC, charts, KPIs, valuation, and other reports.
Yes. Financial Models Lab offers custom financial modeling for different revenue logic, operating schedules, or reporting requirements.
It is a planning forecast driven by the assumptions you enter, not a guarantee of business performance or financial results.
This downloadable financial template for luxury e-commerce provides everything you need to build a comprehensive financial plan, from initial startup costs to a full five-year forecast.
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
Building the forecast by hand was eating whole afternoons, and this template cut that down to one clean setup session. I had numbers ready to share the same day.
Runway was hard to read before, but this model laid out monthly cash flow and shortfalls in a way I could actually follow. I booked a planning call with my cofounder after seeing the gap months clearly.
One broken formula used to make me second-guess every tab, so the built-in structure was a relief. I caught assumptions faster and sent a cleaner model without worrying that one cell would throw off the whole file.