Acquire Customers
Online and offline marketing spend divided by each channel CAC produces new customers.

This editable five-year Excel and Google Sheets model connects customer acquisition, repeat buying, product mix, pricing, costs, scenarios, and financial reports.
Use the workbook to plan how marketing-driven customer growth and repeat purchasing translate into orders, product units, revenue, costs, and financial performance.
You can change launch timing, channel budgets, customer acquisition costs, repeat-customer behavior, units per order, sales mix, and category pricing; linked calculations update the model outputs.
The model converts channel marketing spend into new customers, layers in active repeat buyers, calculates orders and units, then prices the allocated product mix.
Online and offline marketing spend divided by each channel CAC produces new customers.
A share of new customers becomes repeat buyers active for the stated lifetime.
New-customer first orders combine with active repeat customers multiplied by repeat order frequency.
Total orders convert to units per order, then sales mix allocates units across categories.
Allocated category units multiplied by category prices produce total ecommerce revenue.
The Revenue sheet links channel budgets and CAC to new customers, repeat behavior, orders, product units, sales mix, and category prices.
The COGS & OPEX sheet separates cost-of-goods assumptions from variable and fixed operating expenses across the forecast.
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The Dashboard combines model setup, scenario controls, key metrics, core financials, revenue mix, profitability, cash flow, and investment payback views.
The template fits customer-driven ecommerce publishing plans that use this acquisition, repeat-buyer, unit-mix, and pricing logic; structural departures 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.
ORDER A CUSTOM FINANCIAL MODELAfter purchase, you receive the fully editable five-year financial model for Excel and Google Sheets as an instant download.
Change the model assumptions and use the linked calculations for your own planning case.
Work with five years of projections and monthly financial forecasting across the planning period.
Compare Low, Base, and High cases using the workbook's scenario analysis view.
Review income statement, cash flow, balance sheet, summary, dashboard, and other confirmed reports.
The essential answers are visible in full, with no accordion clicks required.
It converts channel marketing spend and CAC into new customers, adds active repeat-buyer orders, calculates units, allocates sales mix, and applies category prices.
You can change launch date, channel marketing budgets and seasonality, CAC, repeat-customer behavior, units per order, sales mix, and category pricing.
The Scenarios view compares Low, Base, and High revenue, gross margin, contribution margin, and EBITDA paths across the forecast.
The current workbook gallery confirms the income statement, cash flow, balance sheet, dashboard, summary, break-even, ROIC, valuation, charts, KPIs, ratios, and supporting reports.
Yes. Financial Models Lab offers custom financial modeling when your revenue logic, operating schedules, or reporting requirements need a different structure.
It is a planning forecast driven by editable assumptions, not a guarantee of business performance or financial results.
This pre-written financial template for a children's book startup gives you a complete, five-year financial projection with detailed assumptions, revenue models, and cost structures tailored to an inclusive publishing venture.
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 helped me get pricing, cost, and growth assumptions into one place instead of chasing them across tabs. I could explain the numbers clearly in one meeting, which saved me a lot of back-and-forth.
I used to spend days building book sales, printing costs, and revenue projections by hand. This model turned that work into a few hours, and I had a clean 5-year forecast ready the same day.
The charts, P&L, cash flow, and summary pages were finally together instead of scattered across files. That made it much easier to share one polished package with my team and book a lender call.