Acquire Customers
New customers equal marketing spend divided by customer acquisition cost.
It is an editable five-year Excel and Google Sheets workbook that links customer acquisition, service tiers, recurring fees, costs, and financial statements.
Use the model to plan how a wine cork recycling service can acquire customers, retain active accounts, charge tiered monthly fees, and support operating decisions.
Editable assumptions flow through monthly and annual projections, Low/Base/High cases, the income statement, cash flow statement, balance sheet, and management dashboard.
The model acquires customers from marketing spend, allocates them across service tiers, retains active cohorts, and multiplies active customers by monthly fees.
New customers equal marketing spend divided by customer acquisition cost.
New customers are allocated across the service tiers in the selected mix.
Starting customers and unexpired cohorts determine active customers by tier.
Each tier multiplies active customers by its monthly fee per customer.
Monthly tier revenue is summed across tiers and forecast periods.
The Revenue Assumptions view connects marketing, customer acquisition, tier allocation, customer lifetime, active customers, and monthly service fees.
REVENUE ASSUMPTIONS
The COGS & OPEX worksheet separates direct costs, variable expenses, and fixed operating expenses across the forecast period.
COGS & OPEX
The Scenario Analysis view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across five years.
SCENARIO ANALYSIS
The Dashboard combines setup controls, scenario multipliers, key metrics, financial results, revenue mix, cash flow, and investment payback views.
DASHBOARD
It fits businesses using recurring monthly service fees and customer cohorts; materially different revenue logic or operating structures may require custom modeling.
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 structure.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable Excel and Google Sheets financial model with five-year projections, scenarios, statements, and management reporting.
Update the model assumptions in Excel or Google Sheets for your business plan.
Review detailed monthly and annual projections across the five-year planning horizon.
Compare Low, Base, and High cases using the model scenario structure.
Review P&L, cash flow, balance sheet, summary, dashboard, and related model outputs.
The essential answers are visible in full, with no accordion clicks required.
Revenue is calculated by multiplying active customers in each service tier by the matching monthly fee, then summing tier revenue across months.
You can edit the launch date, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime or churn convention, and monthly fees.
The Scenario Analysis view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the forecast.
The product confirms P&L, cash flow, balance sheet, dashboard, summary, scenario analysis, and additional financial reports and charts.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structure.
It is a planning forecast based on editable assumptions, not a guarantee of financial or operating performance.
This Excel template for an environmental service startup provides everything you need to build a comprehensive financial plan, from initial cost analysis to long-term profit and loss projections.
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 made cash flow gaps easy to spot, so I could see a 9-month shortfall before it became a problem. That gave me time to tighten spending and book a lender call with cleaner numbers.
I didn’t have to start from scratch, and that alone saved me hours. The layout gave me a clear place to plug in launch costs and revenue assumptions without stalling out.
Building low, base, and high cases used to take forever, but this model made the comparison straightforward. I finished all three versions in under an hour and had a cleaner view for planning.