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

It is an editable five-year Excel and Google Sheets forecast linking customer acquisition, repeat buying, product mix, pricing, scenarios, and core financial statements.
Use the workbook to plan acquisition spending, customer retention, order volume, product mix, pricing, operating costs, staffing, funding, and projected financial performance.
Editable assumptions feed the monthly calculation engine, turning channel acquisition, repeat-customer cohorts, order frequency, units per order, product mix, pricing, costs, and financing into financial outputs.
The model acquires online and offline customers from marketing spend and CAC, builds repeat cohorts, calculates orders and units, allocates category mix, then prices category sales.
Online and offline marketing spend divided by channel CAC determines new customers.
A percentage of new customers becomes repeat buyers for its stated customer lifetime.
First-purchase orders plus active repeat customers times monthly repeat frequency determine total orders.
Total orders times average units per order determine units, then sales mix allocates categories.
Allocated category units are multiplied by category prices, then revenue is summed across categories and months.
The Revenue Assumptions sheet links channel marketing budgets, CAC, repeat-customer behavior, order frequency, units per order, category mix, and product prices to sales.
The COGS & Operational Expenses sheet separates direct costs, variable selling expenses, and fixed overhead so expenses flow into margins and cash requirements.
The Scenario Analysis view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across the forecast period.
The Dashboard combines setup controls, scenario outputs, revenue mix, profitability, cash flow, core financials, and investment payback into one management view.
The ready-made model fits ecommerce sales driven by channel acquisition, repeat-customer cohorts, orders, units, category mix, and pricing; materially different economics may require custom structure.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your revenue logic, operating schedules, or reporting requirements differ from the ready-made workbook.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable Glass Baby Bottle Sales financial model for instant download and use in Excel or Google Sheets.
Update ecommerce, cost, staffing, capital, and financing assumptions directly in the editable model.
Review monthly and annual projections across the five-year modeling horizon.
Compare Low, Base, and High cases through the workbook’s scenario view.
Review the Income Statement, Cash Flow Statement, Balance Sheet, and management outputs.
The essential answers are visible in full, with no accordion clicks required.
It combines first-purchase and repeat-customer orders, converts orders to units, allocates units by category mix, and multiplies category units by matching prices.
You can change launch date, online and offline marketing budgets and seasonality, channel CAC, repeat percentage and lifetime, repeat orders, units per order, category mix, and prices.
The Scenario Analysis view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA.
The workbook includes an Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Scenario Analysis, Valuation, Summary, Break-Even, ROIC, Charts, and KPIs.
Yes. Custom modeling can adapt revenue logic, operating schedules, or reporting when your requirements differ from the ready-made structure.
It is a planning forecast driven by editable assumptions, not a guarantee of business performance or financial results.
This comprehensive startup financial model for baby bottles includes everything you need to build a robust financial plan and secure funding for your 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
I’m not a finance person, so the color-coded inputs and clean tabs made the template easy to follow. I saved hours I would’ve spent fighting formulas and could finally build the model myself.
I wasn’t sure what investors expected, but this template showed the right structure right away. I used it to prepare our numbers and booked a meeting the same week.
The break-even and margin views made it much easier to see where the business could get stuck. I cut two weak assumptions and got a clearer path to profitability in one afternoon.