Acquire Customers
Calculate online and offline new customers from channel marketing spend divided by each channel CAC, then add them together.
This editable five-year workbook models customer acquisition, repeat orders, product mix, pricing, and monthly financial performance with Low, Base, and High cases.
Use the workbook to translate channel marketing budgets, customer acquisition costs, repeat-buyer behavior, order frequency, units per order, sales mix, and category pricing into a structured forecast.
Editable operating assumptions feed customer cohorts, unit allocation, revenue calculations, financial statements, scenarios, and management reports throughout the forecast.
Revenue follows customer acquisition into repeat cohorts, converts total orders into units, allocates units by product mix, and prices each category.
Calculate online and offline new customers from channel marketing spend divided by each channel CAC, then add them together.
Retain the repeat-buyer share by cohort lifetime and combine first purchases with repeat orders from active customers.
Multiply total monthly orders by average units per order to calculate the shared unit pool.
Allocate the shared units across product categories using the editable sales mix percentages.
Multiply each category’s allocated units by its matching price, then sum category revenue across each month.
The Revenue worksheet links channel acquisition, repeat-customer cohorts, order frequency, units per order, product mix, and annual category pricing.
REVENUE
The COGS & OPEX worksheet separates inventory sourcing costs, variable operating expenses, and recurring fixed expenses with editable timing and periodicity.
COGS & OPEX
The Scenarios report compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA through the five-year forecast.
SCENARIOS
The Dashboard combines setup controls, scenario multipliers, financing inputs, core financials, revenue mix, profitability, cash flow, KPIs, and payback in one view.
DASHBOARD
Choose the ready-made model when channel acquisition, repeat buyers, order-to-unit conversion, product mix, category pricing, and standard reporting match your planning structure.
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 for your planning requirements.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable five-year Radiation Survey Meter Sales financial model for Excel and Google Sheets as an instant download.
Work in Excel or Google Sheets and change the model’s editable operating and financial assumptions.
Review monthly and annual projections across the five-year planning horizon.
Compare Low, Base, and High cases across key financial outcomes.
Review the Dashboard, P&L, cash flow, balance sheet, summary, and other workbook reports.
The essential answers are visible in full, with no accordion clicks required.
It acquires customers by channel, builds active repeat cohorts, converts orders into units, allocates units by product mix, and prices each category.
You can change launch timing, channel marketing budgets and seasonality, CAC, repeat-customer behavior, units per order, product mix, and category pricing.
They let you compare alternative revenue, gross margin, contribution margin, and EBITDA trajectories across the five-year forecast.
The workbook gallery shows a Dashboard, P&L, cash flow statement, balance sheet, financial summary, charts, and other management reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structures.
It is a forecast built from editable assumptions, not a guarantee of business performance or financial results.
This downloadable Excel financial model for scientific equipment business provides everything you need to build a comprehensive financial plan, from initial startup costs to a five-year exit valuation.
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 stuck trying to build a model from zero, and this template gave me a clean place to start. It saved me hours of setup and let me move straight into assumptions instead of fighting the spreadsheet.
I couldn’t tell what investors would expect, but this model laid out the right outputs and order. It helped me prep a sharper lender call in one afternoon instead of guessing at the format.
The break-even and margin views made the numbers easy to read without digging through formulas. I spotted my weak pricing assumptions fast and cleaned them up before sharing the model with my partner.