Financial Projections Template: How to Build a Forecast That Works for Ecommerce
Most financial projections are fiction. They start with a revenue target - "we'll grow 30% next year" - and work backwards to make the numbers fit. The spreadsheet looks clean. The assumptions underneath it are fantasy.
Real projections start with unit economics and build up. What does it cost to acquire a customer? How often do they come back? What's the actual margin on each order? When you model from the inputs you can control, projections become a decision-making tool instead of a fundraising prop.
This article walks through the 6 components that belong in every ecommerce financial model, with a worked example showing how the same brand gets two very different outcomes depending on which levers they pull.
Key Takeaways
- Financial projections should be built bottom-up from unit economics (AOV, nCAC, retention) - not top-down from revenue targets
- The 6 inputs that drive every DTC financial model: product data, AOV, variable costs, nCAC, retention, and daily revenue
- Your nCAC will get worse as you scale - model efficiency decay or your projections will overstate profit
- Repeat customers change everything - a 30% vs 40% Year 1 repurchase rate can swing annual profit by 20%+
- Scenario planning (base/worst/best) is more valuable than a single "most likely" forecast
Why Most Financial Projections Fail
There are two ways to build projections. One works. The other gets you in trouble.
Top-down: "We did $2M last year. We want to grow 30%. So we need $2.6M next year." Then you figure out how much ad spend that requires, assume everything scales linearly, and present a nice upward curve.
Bottom-up: "We acquire X new customers per month at Y cost. Z% come back and reorder within 12 months. Each order generates $W in contribution profit. Here's what happens to the P&L under three scenarios."
Top-down projections fail because they assume the relationship between spend and revenue stays constant. It doesn't. Here's what goes wrong:
- nCAC doesn't stay flat. Your cost to acquire a new customer at $500/day in ad spend won't be the same at $2,000/day. Audiences saturate. Creative fatigues. CPMs rise. If your projections assume flat acquisition costs, they're wrong.
- New and repeat customers have different economics. A new customer might order at $65 AOV with a 45% margin. A repeat customer might order at $85 AOV with a 55% margin. Blending them hides the real dynamics.
- Revenue timing is not cash timing. You might be "profitable" on paper while running out of cash because inventory requires upfront payment, customers pay over time, and ad spend hits your card immediately.
- Annual averages mask monthly reality. A brand doing $200K/month in Q4 and $80K/month in Q1 looks very different from a brand doing $150K/month consistently - even if the annual total is similar.
What investors, CFOs, and your own planning process actually need: a model built on the variables you can control, tested against multiple scenarios.
The 6 Components of a Real Ecommerce Financial Model
Every DTC financial projection - whether you're doing $500K or $50M - depends on 6 input categories. Get these right and the model practically builds itself. Get them wrong and no amount of formatting makes the output useful.
1. Product Data - Your Revenue Foundation
This is the base layer. You need SKU-level (or at minimum category-level) data on:
- Price points - what each product or category actually sells for after discounts
- COGS - fully landed cost including freight, duties, and packaging
- New vs repeat distribution - which products new customers buy vs what repeat customers reorder
This matters because changing your product mix changes your entire model. If you launch a lower-margin product that becomes 30% of sales, your blended COGS shifts. If repeat customers gravitate toward higher-margin refills, your repeat economics improve. A flat "average COGS" assumption misses both of these dynamics.
2. AOV Modeling - Beyond the Average
Average Order Value is not a single number you plug in. It's a function of several variables:
- Discount rate - what percentage of orders use a promo code, and what's the average discount?
- Refund rate - what percentage of revenue comes back as returns?
- Shipping revenue - are you charging for shipping or absorbing it?
- Units per transaction - how many items per order, and is this trending up or down?
You can model these individually (more accurate) or plug in a decision value (simpler). Either way, model AOV separately for new and repeat customers. It's almost always different.
Example: A DTC skincare brand might see $62 AOV from new customers (buying a starter kit) and $78 AOV from repeat customers (buying full-size refills plus an add-on). Using a blended $70 for both segments hides a 26% difference.
3. Variable Costs - The Real Margin Picture
These are the costs that scale with every order:
- COGS - derived from your product data, not a flat percentage
- Fulfillment - pick, pack, and ship typically runs $3-8 per order depending on size, weight, and 3PL
- Payment processing - 2.9% + $0.30 on Shopify Payments, potentially higher on other processors
When you subtract these from net revenue, you get contribution margin per order - the actual profit available to cover marketing spend, fixed costs, and net profit. If your Shopify "profit" number doesn't match this calculation, it's because Shopify doesn't include all variable costs. See our Shopify profit margin calculator for how to find the real number.
4. nCAC and Efficiency Decay - The Scaling Reality
This is where most projections break. nCAC (new Customer Acquisition Cost) is your total marketing spend divided by new customers acquired. It's the cleanest signal of acquisition efficiency.
The problem: nCAC gets worse as you spend more. This isn't a bug - it's how paid acquisition works. You reach the most responsive audiences first. As you scale, you push into colder audiences with lower conversion rates and higher CPMs.
To model this realistically, apply an efficiency decay factor - typically 0.15 to 0.40 depending on market saturation and creative refresh rate. This means for every doubling of spend, your nCAC increases by 15-40%.
| Monthly Ad Spend | nCAC (0.25 Decay) | New Customers | Cost per Customer Increase |
|---|---|---|---|
| $15,000 | $45 | 333 | Baseline |
| $30,000 | $56 | 536 | +24% |
| $60,000 | $70 | 857 | +56% |
| $120,000 | $88 | 1,364 | +96% |
Notice: you spend 8x more but only acquire 4x more customers. Any projection that assumes a linear relationship between ad spend and customer acquisition is overstating growth and understating costs.
5. Retention - Where Profit Actually Lives
New customers cost money to acquire. Repeat customers are nearly free. That makes retention the single highest-leverage variable in your financial model.
You need monthly repurchase rates over a 12-month window. This means: of the customers acquired in Month 1, what percentage reorder in Month 2? Month 3? Month 6? Month 12? You can get this from Shopify cohort reports or your email/SMS platform.
If you don't have cohort data, use your Shopify returning customer rate as a starting point - but know that it understates the actual repurchase behavior for recent cohorts.
Why this matters so much:
| Scenario | Year 1 Repurchase Rate | Repeat Revenue (per 1,000 customers) | Impact on Annual Profit |
|---|---|---|---|
| Low retention | 25% | $19,500 | Baseline |
| Average retention | 35% | $27,300 | +40% repeat revenue |
| Strong retention | 45% | $35,100 | +80% repeat revenue |
A 20-point improvement in repurchase rate nearly doubles repeat revenue - at zero additional acquisition cost. No amount of ad spend optimization delivers that kind of leverage. If your financial model doesn't account for retention, it's missing the most important variable.
6. Daily Revenue Model - Putting It All Together
This is where the previous 5 components combine into an actual projection. The daily revenue model works by calculating:
- New customer revenue: daily ad spend / nCAC = new customers per day, multiplied by first-order AOV and margin
- Repeat customer revenue: all previously acquired customers who reorder on any given day, based on your retention curves
- Total revenue: new + repeat, minus variable costs, minus fixed costs = daily contribution profit
Over time, repeat customers compound. Early months are acquisition-heavy (high cost, low repeat revenue). Later months benefit from all the previously acquired customers who keep coming back. This is why DTC businesses often look unprofitable early but build substantial profit once the retention flywheel kicks in.
From the daily model, you can build:
- Monthly and annual P&L projections - revenue, COGS, variable costs, ad spend, fixed costs, net profit
- 13-week cash flow - when cash actually enters and leaves, including inventory purchases that front-load costs before revenue arrives
- Scenario comparisons - base case (current trajectory), worst case (nCAC worsens, retention drops), best case (retention improves, margins strengthen)
The 13-week cash flow is critical for any brand carrying inventory. A long cash conversion cycle means your projection can show profit while your bank account shows a shortfall. Profitable and cash-positive are two different things.
Financial Projections Example - Two Scenarios, Same Brand
Here's what this looks like in practice. Same DTC skincare brand, same starting point, two different strategies for the next 12 months.
Starting point: $2M trailing revenue, $75 AOV (blended), 55% contribution margin, $50 nCAC, 32% Year 1 repurchase rate, ~400 new customers/month.
| Scenario A: Scale Ad Spend 50% | Scenario B: Improve Retention 10pts | |
|---|---|---|
| Monthly ad spend | $30K (up from $20K) | $20K (unchanged) |
| nCAC | $62 (decay from scaling) | $50 (unchanged) |
| New customers/month | 484 | 400 |
| Year 1 repurchase rate | 32% (unchanged) | 42% (improved via email/CX) |
| Projected Year 2 revenue | $2.72M (+36%) | $2.58M (+29%) |
| Total ad spend (12 months) | $360K | $240K |
| Projected contribution profit | $196K | $279K |
| Profit margin | 7.2% | 10.8% |
Scenario A grows revenue faster but generates less profit. The $120K in additional ad spend gets eaten by nCAC decay - you're paying more per customer and those customers don't return any more often.
Scenario B grows revenue slower but generates 42% more profit. The retention improvement costs relatively little (better email flows, post-purchase experience) and every returning customer contributes margin without additional acquisition cost.
The takeaway: A 10% improvement in retention often generates more profit than a 50% increase in ad spend. Your financial model should make this visible before you commit the budget.
How to Build Your Own Financial Projections
Here's the step-by-step if you're building this from scratch:
Step 1: Gather your data. You need Shopify sales reports (revenue, orders, customer counts), ad platform data (spend by channel, new customer counts), and fulfillment invoices (actual shipping and handling costs per order).
Step 2: Calculate real variable costs per order. Don't use Shopify's "cost" field - it typically only includes COGS. Add fulfillment, shipping, and payment processing to get your true contribution margin.
Step 3: Segment new vs repeat. Calculate AOV, margin, and volume separately for each. This is the split that reveals whether your business is acquisition-dependent or retention-driven.
Step 4: Model nCAC with decay. Take your current nCAC and model what happens as spend increases. Use a 0.20-0.30 decay factor if you're unsure. This means a 2x increase in spend results in roughly 20-30% higher nCAC.
Step 5: Build monthly projections. Combine new customer acquisition (from Step 4) with repeat revenue (from your retention data) to project revenue month by month. Subtract variable costs, ad spend, and fixed costs for monthly profit.
Step 6: Run 3 scenarios. Vary your key assumptions by 15-25% in each direction. What if nCAC worsens by 20%? What if retention drops by 5 points? What if both improve? Three scenarios are more honest than one "most likely" number.
Step 7: Add cash flow. If you carry inventory, add a 13-week cash flow layer. This shows when cash actually enters and leaves, including inventory deposits that might be 60-90 days before the resulting revenue hits your account.
FAQ
How far out should ecommerce financial projections go?
12 months with monthly detail is the sweet spot. Beyond that, quarterly projections are fine through 24 months. Anything past 24 months is directional at best for most DTC brands - too many variables shift.
What's a reasonable growth rate to project?
Don't start with a growth rate. Start with your unit economics: how many new customers can you acquire at what cost, and what percentage come back. The growth rate is an output of those inputs, not an assumption you plug in. A brand with a $30 nCAC in a $60 CPM market has more scaling room than one at $80 nCAC in the same market.
Do I need a financial model if I'm under $1M?
Yes, but simpler. Focus on break-even ROAS, contribution margin per order, and cash runway. The full 6-component model becomes critical above $1M when you're making real scaling decisions.
How often should I update projections?
Monthly, against actuals. Compare what your model predicted to what actually happened. The gaps tell you which assumptions were wrong and how to adjust. A projection that never gets updated against reality is just a guess that aged.
From Framework to Forecast
The 6-component framework gives you the structure. The hard part is building it, maintaining it, and running scenarios consistently. If you want to do it yourself, the steps above give you the roadmap.
If you want to skip the spreadsheet build:
Model your P&L and cash flow with real unit economics. The MTN Forecasting Tool uses the same 6-component framework - product data, AOV, variable costs, nCAC with efficiency decay, retention curves, and daily revenue modeling - customized to your brand's numbers. See what happens to profitability before you commit the budget.
Start with the diagnostics. Before you project forward, you need to know where you stand today. The free Starter Toolkit calculates your contribution margin, break-even ROAS, and the baseline metrics that feed into any financial model.
Comments ()