Acquire Customers
Divide channel marketing spend by CAC, then combine online and offline new customers.

The DIY Craft Kits Financial Model is an editable five-year workbook that links customer acquisition, repeat orders, product sales, costs, scenarios, and financial statements.
Use the model to turn your marketing plans, customer behavior, order volumes, product mix, and pricing assumptions into an integrated DIY craft kits forecast.
Editable operating inputs feed the monthly calculations, while the workbook rolls results into annual views, Low/Base/High scenarios, statements, and management reporting.
Revenue starts with channel marketing spend and CAC, then adds repeat-customer cohorts, orders, units, product mix, and category pricing across the forecast.
Divide channel marketing spend by CAC, then combine online and offline new customers.
Apply repeat-customer rates, cohort lifetimes, and repeat-order frequency to active buyers.
Add first-purchase orders from new customers to recurring orders from active repeat customers.
Multiply orders by units per order, then allocate units across product categories by sales mix.
Multiply category units by category prices and sum category sales across each month.
The Revenue worksheet centralizes channel acquisition, repeat-customer behavior, order volume, product mix, and category pricing used by the ecommerce forecast.
The COGS & OPEX worksheet organizes direct costs, variable expenses, and fixed operating costs so the forecast can translate sales into margins and cash needs.
The Scenarios view compares alternative revenue, gross margin, contribution margin, and EBITDA outcomes so you can review how assumption changes affect the plan.
The Dashboard combines model setup, scenario controls, core financials, revenue mix, profitability, cash flow, and payback charts in one management view.
It fits businesses using this customer-acquisition, repeat-purchase, order-and-product-mix logic; materially different revenue structures may warrant a custom model.
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 from the ready-made template.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable DIY Craft Kits financial model for immediate download, with a five-year forecast, scenarios, statements, and management reports.
Update the model assumptions, operating inputs, costs, staffing, capital, and financing data.
Review detailed monthly calculations and annual financial projections across the five-year planning horizon.
Compare Low, Base, and High outcomes through the workbook's scenario framework.
Use the income statement, cash flow statement, balance sheet, Dashboard, and supporting reports.
The essential answers are visible in full, with no accordion clicks required.
It calculates new customers from channel marketing spend and CAC, then adds active repeat-customer orders. Orders convert to units, units are allocated by product mix, and category units are multiplied by prices.
You can edit launch timing, channel budgets and seasonality, CAC, repeat-customer behavior, units per order, product mix, and category prices. Cost, payroll, CAPEX, and other workbook inputs are also editable.
The Scenarios view lets you compare Low, Base, and High cases for revenue, margins, EBITDA, and related financial outcomes. Scenario multipliers change the selected case without rewriting the operating logic.
The workbook includes the income statement, cash flow statement, balance sheet, Dashboard, Summary, Break-Even, ROIC, Charts, KPIs, and supporting financial reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting.
It is a forecast built from editable assumptions, not a guarantee of business performance. Actual results will depend on your inputs and operating outcomes.
You get a powerful, pre-built financial model that includes a 5-year forecast, interactive dashboard, detailed cost breakdowns, and a comprehensive assumptions tab tailored for a DIY craft kit business.
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 assumption tabs put pricing, costs, and growth in one place, so I stopped chasing down numbers across different sheets. It saved me a couple hours and made the forecast much easier to explain.
I didn’t have to start from zero, which was the biggest relief. I had a working model the same day and booked our planning review faster than I expected.
I’m not deep into Excel, so the pre-built formulas and clean layout made this manageable. I filled it in without outside help and got a usable projection in under an hour.