Acquire Customers
Divide each channel's marketing spend by its CAC, then combine online and offline customers.
This editable Excel and Google Sheets workbook models five years of bamboo-clothing sales, monthly and annual projections, three scenarios, and core financial statements.
Plan customer acquisition, repeat purchasing, product mix, pricing, costs, staffing, capital needs, and financial performance in one structured forecast.
Editable assumptions feed the revenue engine and operating schedules, which roll into scenario analysis, the dashboard, and the income statement, cash flow statement, and balance sheet.
Marketing spend and CAC create new customers, repeat cohorts add recurring orders, units are allocated by product mix, and category prices produce total ecommerce revenue.
Divide each channel's marketing spend by its CAC, then combine online and offline customers.
Apply repeat-buyer share, customer lifetime, and monthly order frequency to active cohorts.
Add first-purchase and repeat orders, then multiply total orders by average units per order.
Distribute units across product categories using the sales mix and matching category prices.
Multiply allocated category units by category prices and sum revenue across categories and months.
The Revenue view connects marketing budgets, CAC, repeat-customer behavior, orders, unit volumes, product mix, and category prices to the sales forecast.
REVENUE
The COGS & OPEX view organizes direct costs, variable expenses, and fixed operating expenses across the five-year forecast.
COGS & OPEX
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA over five years.
SCENARIOS
The Dashboard combines scenario controls, core financials, revenue mix, profitability, cash flow, and investment payback in one management view.
DASHBOARD
The ready-made model fits ecommerce brands using customer-acquisition, repeat-purchase, product-mix, and category-pricing logic; different operating structures may require custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your business needs different revenue logic, operating schedules, or reporting structure.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable five-year financial model for Excel and Google Sheets with scenarios, dashboard reporting, and core financial statements.
Update assumptions and model inputs in Excel or Google Sheets.
Review projections across a five-year planning horizon.
Compare Low, Base, and High forecast cases in the Scenarios view.
Review the income statement, cash flow statement, balance sheet, dashboard, and summary outputs.
The essential answers are visible in full, with no accordion clicks required.
The model converts channel marketing spend and CAC into new customers, adds repeat-customer cohorts, converts orders into units, allocates units by product mix, and applies category prices.
You can change the launch date, channel marketing budgets and seasonality, CAC, repeat-customer behavior, units per order, product sales mix, and category prices by forecast year.
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The workbook includes the dashboard, income statement, cash flow statement, balance sheet, summary, scenarios, and additional financial analysis views shown in the product gallery.
Yes. Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting structure.
It is a planning forecast based on the assumptions you enter, not a guarantee of business performance or financial results.
You get a pre-written financial model for an ethical fashion company, complete with researched assumptions, financial statements, and a dynamic dashboard, all ready for your inputs.
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 our scattered statements and charts into one clear file, so I could review everything in minutes instead of digging through tabs and old versions. It made our monthly update much easier to share with the team.
I kept putting off the model because starting from scratch felt like too much. With this template, I had a working five-year plan in one afternoon and a clean base for our launch meeting.
I’m not strong in Excel, so the built-in structure and clear inputs saved me from getting stuck on formulas. I finished the forecast without outside help and booked a lender call the same day.