Acquire Customers
New customers equal monthly marketing spend divided by customer acquisition cost.

The Water Delivery Financial Model is an editable five-year workbook for customer-cohort subscription revenue, operating costs, scenarios, and linked financial statements.
Plan how marketing-driven customer acquisition, tier mix, retention, monthly fees, delivery costs, staffing, and capital needs shape the water delivery forecast.
Editable assumptions feed the monthly calculation engine, which rolls operating activity into projected profitability, cash flow, balance sheet, scenario, and management views.
Marketing spend acquires new customers by CAC, allocates them across tiers, retains cohorts for their lifetime, and charges active customers monthly fees.
New customers equal monthly marketing spend divided by customer acquisition cost.
New customers are distributed across service tiers using the selected allocation mix.
Each customer cohort remains active for its stated lifetime before expiring.
Active customers in each tier are multiplied by that tier's monthly fee.
Total monthly revenue is the sum of revenue generated across all active tiers.
The Revenue Assumptions view connects marketing budget, CAC, tier allocation, customer lifetime, starting customers, and monthly fees to active customer cohorts.
The COGS & OPEX worksheet separates direct water and delivery costs from variable operating expenses and fixed overhead assumptions over the forecast.
The Scenario Analysis view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over five forecast years.
The Dashboard combines setup controls, scenario multipliers, core financials, revenue mix, profitability, cash flow, and investment payback in one management view.
The ready-made model fits recurring customer-cohort economics; structural custom work is more suitable when your revenue logic or reporting needs differ materially.
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 reporting than the ready-made structure provides.
ORDER A CUSTOM FINANCIAL MODELYou receive an instantly downloadable, fully editable Excel financial model with five-year projections, scenario analysis, and linked financial and management reports.
Change the water delivery assumptions and review how linked outputs respond.
Use monthly detail for the first two years and annual summaries thereafter.
Compare Low, Base, and High cases across revenue, margins, and EBITDA.
Review projected income statement, cash flow, balance sheet, and management reporting.
The essential answers are visible in full, with no accordion clicks required.
It calculates new customers from marketing spend and CAC, allocates them by tier, retains cohorts, and applies monthly fees to active customers.
You can change launch timing, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime, and monthly fees.
You can compare alternative five-year paths for revenue, gross margin, contribution margin, and EBITDA under the scenario settings.
The product shows projected income statement, cash flow, balance sheet, dashboard, scenarios, summary, valuation, break-even, ROIC, charts, KPIs, and related reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, schedules, or reporting structures.
It is a forecast based on editable assumptions, not a guarantee of revenue, profitability, cash flow, valuation, funding, or business performance.
This downloadable financial model for water bottle delivery includes everything you need to build a comprehensive financial plan, from detailed revenue modeling to five-year projections and break-even analysis.
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
The template made the modeling side feel manageable, even without advanced Excel skills. I finished the forecast in one afternoon instead of spending days trying to build formulas from scratch.
I was stuck staring at a blank sheet, and this gave me a clean starting point right away. It saved me about 10 hours and made the launch plan much easier to organize.
Switching between low, base, and high cases was confusing before this. Now the scenarios are already laid out clearly, and I could compare them in minutes before a lender call.