Acquire Customers
Divide each channel's marketing spend by its CAC, then combine online and offline customers.
An editable five-year financial model that links customer acquisition, repeat purchasing, product sales mix, pricing, costs, and scenarios to monthly and annual financial outputs.
Use the workbook to plan how marketing spend, customer acquisition, repeat orders, product mix, pricing, and operating costs shape the financial outlook.
Editable assumptions flow through the model calculations into statements, scenario comparisons, and management views, so changes can be reviewed in one connected forecast.
Revenue starts with channel marketing spend and CAC, adds repeat-customer cohorts, converts resulting orders into units, allocates product mix, and applies category pricing.
Divide each channel's marketing spend by its CAC, then combine online and offline customers.
Apply the repeat-customer rate and keep each cohort active for its stated lifetime.
Add new-customer first purchases to active repeat customers times repeat orders per month.
Multiply orders by units per order, then allocate total units using the product sales mix.
Multiply allocated category units by category prices and total the resulting monthly product revenue.
The Revenue Assumptions view connects acquisition budgets, CAC, repeat-customer behavior, order volume, product mix, and category pricing to the ecommerce sales forecast.
REVENUE ASSUMPTIONS
The COGS & Operational Expenses view separates direct cost assumptions, variable operating expenses, and fixed expenses across the forecast period.
COGS & OPERATIONAL EXPENSES
The Scenario Analysis view compares alternative Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
SCENARIO ANALYSIS
The Dashboard combines scenario controls with core financials, revenue mix, profitability, cash flow, investment payback, working-capital assumptions, and key metrics.
DASHBOARD
The ready-made model fits businesses using this ecommerce customer-and-product logic; structurally different revenue, operating, or reporting requirements 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 financial and management reporting.
ORDER A CUSTOM FINANCIAL MODELYou receive the fully editable Eco-Friendly Stationery financial model for Excel and Google Sheets as an instant download with five-year forecasting and reporting.
Update the model's business assumptions in Excel or Google Sheets for your planning case.
Review five years of monthly and annual financial projections linked to the operating assumptions.
Compare Low, Base, and High cases for revenue and key profitability measures.
Review the income statement, cash flow statement, balance sheet, dashboard, and supporting reports.
The essential answers are visible in full, with no accordion clicks required.
It converts channel marketing spend and CAC into customers, adds repeat cohorts and orders, allocates units by product mix, and applies category pricing.
You can change launch timing, marketing budgets and seasonality, channel CAC, repeat-customer behavior, orders, units per order, product mix, and category prices.
The Scenario Analysis view compares Low, Base, and High revenue, gross margin, contribution margin, and EBITDA paths over the five-year forecast.
The workbook includes an income statement, cash flow statement, balance sheet, dashboard, summary, scenario analysis, valuation, break-even, ROIC, charts, KPIs, and supporting reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting.
It is a planning forecast driven by the assumptions entered into the workbook, not a guarantee of business performance or results.
You get a comprehensive financial model for a sustainable notebook company, complete with detailed financial statements, a dynamic dashboard, and fully customizable 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
I was dealing with statements and charts scattered across different files, and this template pulled everything into one clean view. It saved me hours of hunting through spreadsheets and made it easier to share a finished model.
I wasn’t sure what investors wanted to see, but this model gave me the right outputs and a structure I could follow. I booked a meeting faster because the assumptions and summaries were already organized.
Building the financials by hand was taking way too long, and this template cut that down fast. What used to eat up most of a day was done in a couple of hours, with room to check the numbers properly.