Acquire Customers
Online and offline marketing spend is divided by each channel CAC, with channel seasonality applied.
It is an editable five-year ecommerce workbook that models customer acquisition, repeat buying, product sales, scenarios, financial statements, and management reporting.
Plan how marketing spend, customer acquisition, repeat purchasing, order volume, product mix, and pricing translate into an online vintage clothing forecast.
You edit the business assumptions, while the workbook links those drivers to revenue calculations, operating costs, financial statements, scenario comparisons, and management outputs.
The model builds orders from new and active repeat customers, converts orders into units, allocates units by product mix, then applies category prices.
Online and offline marketing spend is divided by each channel CAC, with channel seasonality applied.
A share of new customers becomes repeat buyers who remain active for the stated lifetime.
Monthly orders combine first purchases with active repeat customers multiplied by repeat order frequency.
Orders convert to units using units per order, then units are allocated by product sales mix.
Allocated category units are multiplied by category prices and summed across categories and months.
The Revenue view organizes acquisition budgets, CAC, repeat-customer behavior, units per order, product sales mix, and category pricing in one operating schedule.
REVENUE
The COGS & OPEX view separates cost of goods sold, variable expenses, and fixed expenses so operating assumptions can flow into the forecast.
COGS & OPEX
The Scenarios view compares alternative revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast for structured decision analysis.
SCENARIOS
The Dashboard combines model setup, scenario controls, core financials, revenue mix, profitability, cash flow, and investment payback into one management view.
DASHBOARD
It fits ecommerce stores using the supplied customer, repeat-order, unit-mix, and category-pricing logic; structurally different operations may need 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 financial reporting for your requirements.
ORDER A CUSTOM FINANCIAL MODELYou receive a fully editable Excel or Google Sheets financial model with a five-year forecast, scenario analysis, statements, and management reporting.
Open and edit the model in Microsoft Excel or Google Sheets.
Plan across the confirmed five-year projection period with monthly and annual reporting detail.
Compare Low, Base, and High cases using the workbook's scenario framework.
Review income statement, cash flow, balance sheet, dashboard, and other confirmed outputs.
The essential answers are visible in full, with no accordion clicks required.
It calculates new customers from channel spend and CAC, adds repeat-customer orders, converts orders to units, allocates product mix, and applies category prices.
You can edit launch timing, channel budgets and seasonality, CAC, repeat behavior, units per order, category mix, and category prices.
The Scenarios view compares alternative revenue, gross margin, contribution margin, and EBITDA paths across Low, Base, and High cases.
Confirmed outputs include the income statement, cash flow statement, balance sheet, Dashboard, Scenarios, Summary, and additional financial reports shown in the workbook gallery.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structures.
It is a planning forecast based on the assumptions entered into the workbook, not a guarantee of business performance.
This is a complete, five-year second-hand clothing business model with a dynamic dashboard, detailed financial statements, and fully editable assumptions.
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
This template pulled pricing, cost, and growth inputs into one place, so I could explain every number without chasing tabs. It saved me a couple hours of cleanup before I sent the plan out.
I didn’t have to build the model from scratch, which made starting my store plan feel manageable instead of overwhelming. I had a working forecast the same afternoon.
I’m not advanced in Excel, and this model kept the formulas out of my way while still giving me solid projections. That meant I could finish the forecast and book a meeting without asking for help.