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 orders, product mix, pricing, costs, scenarios, and financial reports.
Use the workbook to plan how marketing-driven customer growth and repeat purchasing translate into plant 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 plant-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, plant-product units, sales mix, and category prices.
REVENUE
The COGS & OPEX sheet separates cost-of-goods assumptions from variable and fixed operating expenses across the forecast.
COGS & OPEX
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
SCENARIOS
The Dashboard combines model setup, scenario controls, key metrics, core financials, revenue mix, profitability, cash flow, and investment payback views.
DASHBOARD
The template fits customer-driven online plant nursery plans using 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 analysis 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 workbook includes the income statement, cash flow, balance sheet, Dashboard, Summary, and additional analysis reports shown in the preview.
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.
You receive a downloadable financial model for a virtual plant store, complete with pre-built financial statements, a dynamic dashboard, and detailed sections for all your 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 worried one broken cell would throw everything off, but this template kept the math organized and easy to trace. I saved hours checking formulas and could move ahead without second-guessing every input.
I couldn’t tell what investors wanted before, but the structure here made it obvious. The summary tabs and projections gave me a cleaner story, and I booked a follow-up meeting with my advisor after sharing it.
I’m not strong in Excel, so this was a relief. The layout was easy to follow, and I finished a usable five-year plan in an afternoon instead of handing it off to someone else.