Financial Projections Template for Ecommerce Businesses

Tested prompts for ecommerce financial projections template compared across 5 leading AI models.

BEST BY JUDGE SCORE Claude Haiku 4.5 9/10

You're launching or running an ecommerce business and need a financial projections template that actually reflects how online stores make money. Generic SaaS or retail spreadsheets miss the variables that matter: CAC by channel, return rates, Shopify and payment processor fees, inventory turnover, and the gap between when you pay suppliers and when Stripe deposits cash. You need something you can plug real numbers into for an investor deck, a bank loan, or just to see if your unit economics work.

This page gives you a prompt that generates a complete ecommerce financial model, tested across four AI models so you can see which output fits your situation. Copy the prompt, paste your numbers, and get back a 12 to 36 month projection covering revenue, COGS, operating expenses, cash flow, and key DTC metrics.

Use it before you pitch investors, before you commit to a big inventory order, or when you're trying to figure out if paid ads at your current ROAS will ever turn profitable.

When to use this

Use an AI-generated projection template when you need a structured financial model fast and your business has enough operating history or clear assumptions to plug in. It works best when you can define your channels, AOV, margin, and ad spend. It's ideal for pre-seed decks, bank applications, or internal planning where precision matters less than a defensible framework.

Building an investor pitch deck for a DTC brand raising pre-seed or seed
Applying for a line of credit, SBA loan, or inventory financing
Modeling the impact of scaling paid acquisition from $5K to $50K/month
Deciding whether to launch a new SKU or expand into a new sales channel
Running monthly forecast versus actuals as a founder without a finance hire

When this format breaks down

You need GAAP-compliant audited financials for a Series B or later round, where a CFO or accountant should build the model
Your business model is complex marketplace or B2B wholesale with custom payment terms that standard ecommerce templates don't handle
You have zero operating data and no benchmarks, making every assumption a guess the AI will anchor on uncritically
You need tax-specific projections or entity structure modeling that requires a CPA's judgment

The prompt we tested

You are a financial modeling expert specializing in ecommerce businesses. Build a comprehensive 3-year financial projections template based on the business details provided below.

Business details:
We're launching a DTC skincare brand in Q1 with an average order value of $65 and a starting cost of goods around 28%. We plan to drive traffic primarily through Meta ads with a $15k/month initial budget and Shopify as our platform, and we want to see how the business scales over 3 years assuming 8% month-over-month growth.

Follow these formatting and content rules:
Output the template as structured markdown tables covering: Revenue Assumptions (traffic, conversion rate, AOV, repeat rate), Revenue Forecast, COGS & Gross Margin, Operating Expenses (marketing, fulfillment, payment processing, software, payroll), EBITDA, Cash Flow, and Key Ecommerce KPIs (CAC, LTV, contribution margin, ROAS). Show Year 1 month-by-month and Years 2-3 annually, include a clearly labeled Assumptions section with editable inputs and their default values, and end with 3-5 sensitivity notes explaining which levers most impact profitability.

Produce the full financial projections template now, with clearly labeled sections, monthly line items for Year 1 and annual figures for Years 2-3, and explicit formulas/assumptions the user can plug their own numbers into.

Model comparison

Model	Quality	Cost	Latency	Tokens
Claude Opus 4.7	9	$0.1607	27.2s	476 / 2048
Claude Haiku 4.5	9	$0.0106	15.0s	327 / 2048
GPT-5.4	Not run yet
Gemini 2.5 Pro	Not run yet
Grok 4.1 Fast Reasoning	9	$0.0011	135.9s	423 / 2048

Outputs

Claude Opus 4.7 9/10

# DTC Skincare Brand — 3-Year Financial Projections Template

> **Scope:** Year 1 monthly + Years 2–3 annual. All cells are editable. Formulas shown in `code` so you can drop into Excel/Google Sheets.

---

## 1. Assumptions (Editable Inputs)

| Input | Default | Notes / Formula |
|---|---|---|
| Launch month | Jan (M1) | Q1 launch |
| Starting ad spend | $15,000/mo | Meta-led paid acquisition |
| MoM growth rate | 8% | Applied to revenue drivers |
| Average Order Value (AOV) | $65 | Trending to $72 by Y3 (bundle/upsell) |
| Starting conversion rate | 1.8% | Industry DTC skincare benchmark |
| Mature conversion rate | 2.8% | Y2–Y3 with CRO + returning customers |
| Starting CAC | $35 | `Ad spend / New customers` |
| Repeat purchase rate (Y1) | 15% | Rises to 30% (Y2), 40% (Y3) |
| Purchase frequency (repeat) | 2.2x/yr | Once subscription launches Y2 |
| COGS % of revenue | 28% → 25% (scale) | Volume discounts on raws + packaging |
| Payment processing | 2.9% + $0.30/order | Shopify Payments |
| Shopify platform fee | $299/mo (Advanced) | Y1: Basic $39; Y2+: Advanced |
| Fulfillment / pick-pack-ship | $8.50/order | 3PL blended |
| Returns & refunds | 3% of revenue | Skincare allergen/dissatisfaction |
| Software stack (Klaviyo, reviews, etc.) | $800/mo | Scales with list size |
| Payroll (founder + contractors) | $18k/mo Y1 | Grows with headcount |
| Starting cash | $250,000 | Seed/self-funded |
| Inventory days on hand | 75 days | Working-capital driver |

---

## 2. Revenue Assumptions — Year 1 Monthly

| Metric | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ad spend ($) | 15,000 | 16,200 | 17,496 | 18,896 | 20,408 | 22,040 | 23,803 | 25,708 | 27,764 | 29,985 | 32,384 | 34,975 |
| Sessions (CPC $1.50) | 10,000 | 10,800 | 11,664 | 12,597 | 13,605 | 14,694 | 15,869 | 17,139 | 18,510 | 19,990 | 21,590 | 23,317 |
| Conv. rate | 1.6% | 1.7% | 1.8% | 1.9% | 2.0% | 2.0% | 2.1% | 2.1% | 2.2% | 2.2% | 2.3% | 2.3% |
| New orders | 160 | 184 | 210 | 239 | 272 | 294 | 333 | 360 | 407 | 440 | 497 | 536 |
| Repeat orders (15%) | 0 | 24 | 31 | 38 | 46 | 54 | 62 | 70 | 81 | 91 | 104 | 117 |
| **Total orders** | **160** | **208** | **241** | **277** | **318** | **348** | **395** | **430** | **488** | **531** | **601** | **653** |
| AOV ($) | 65 | 65 | 65 | 66 | 66 | 66 | 67 | 67 | 68 | 68 | 69 | 70 |

**Formulas:**
- `Ad spend(m) = Ad spend(m-1) × 1.08`
- `Sessions = Ad spend / CPC`
- `New orders = Sessions × Conv. rate`
- `Repeat orders = Prior cumulative customers × Repeat rate / 12`

---

## 3. Revenue Forecast

### Year 1 Monthly

| $ | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | **Y1 Total** |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Gross revenue | 10,400 | 13,520 | 15,665 | 18,282 | 20,988 | 22,968 | 26,465 | 28,810 | 33,184 | 36,108 | 41,469 | 45,710 | **313,569** |
| Returns (3%) | (312) | (406) | (470) | (548) | (630) | (689) | (794) | (864) | (996) | (1,083) | (1,244) | (1,371) | (9,407) |
| **Net revenue** | **10,088** | **13,114** | **15,195** | **17,734** | **20,358** | **22,279** | **25,671** | **27,946** | **32,188** | **35,025** | **40,225** | **44,339** | **304,162** |

### Years 2–3 Annual

| $ | Y2 | Y3 |
|---|---|---|
| Ad spend | 780,000 | 1,500,000 |
| Blended ROAS | 3.2x | 3.6x |
| Gross revenue | 2,496,000 | 5,400,000 |
| Returns (3%) | (74,880) | (162,000) |
| **Net revenue** | **2,421,120** | **5,238,000** |

---

## 4. COGS & Gross Margin

### Year 1 Monthly

| $ | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | **Y1** |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COGS (28%) | 2,825

Claude Haiku 4.5 9/10

# DTC Skincare Brand - 3-Year Financial Projections Template

## ASSUMPTIONS & INPUT PARAMETERS

| Assumption Category | Metric | Default Value | Unit | Notes |
|---|---|---|---|---|
| **Growth & Traffic** | Monthly Growth Rate | 8% | % | Applied month-over-month |
| | Starting Monthly Sessions (M1) | 1,500 | sessions | Initial organic + paid traffic |
| **Conversion & AOV** | Conversion Rate | 2.5% | % | Sessions → Orders |
| | Average Order Value (AOV) | $65 | $ | Per transaction |
| | Repeat Purchase Rate (YoY) | 35% | % | % of customers who buy again |
| | Repeat Purchase Frequency | 2.2 | times/year | Additional purchases per repeat customer |
| **Cost Structure** | COGS as % of Revenue | 28% | % | Product + packaging + inbound shipping |
| | Fulfillment Cost per Order | $2.50 | $ | Outbound shipping + handling |
| **Marketing & CAC** | Meta Ads Monthly Budget (M1) | $15,000 | $ | Starting ad spend |
| | Meta Ads Growth | 12% | % monthly | Scaling ad budget month-over-month |
| | ROAS Target | 2.5x | multiplier | Return on Ad Spend |
| **Operating Expenses** | Payment Processing Fee | 2.9% | % of revenue | Stripe/Shopify Payments standard |
| | Shopify Base Subscription | $299 | $/month | Plan: Shopify Plus scaling |
| | Additional Software (email, SMS, analytics) | $500 | $/month | Klaviyo, Gorgias, Northbeam, etc. |
| | Customer Service Staff (M7 onwards) | $3,000 | $/month | 1 FTE starting month 7 |
| | Operations/Admin Staff (M10 onwards) | $4,500 | $/month | 1 FTE starting month 10 |
| | Founder/CEO Salary (M1 onwards) | $3,500 | $/month | Adjusted for runway |
| | Packaging & Design | $1,000 | $/month | Creative, updated creative tests |
| | Miscellaneous (insurance, compliance, returns) | 2% | % of revenue | Variable overhead |
| **Funding & Cash** | Starting Cash | $50,000 | $ | Runway buffer |
| | Tax Rate (EBITDA basis) | 0% | % | No taxes assumed Year 1-2 (NOLs) |
| **Year 2-3 Adjustments** | AOV Growth (annual) | 8% | % | Upsells, bundling, price increases |
| | Repeat Rate Growth | 3% | ppts annually | Improving retention |
| | COGS Improvement | -1% | ppts annually | Volume discounts on manufacturing |

---

## YEAR 1: MONTH-BY-MONTH REVENUE FORECAST

| Month | Month # | Sessions | Conversion Rate | Orders | AOV ($) | Gross Revenue | Repeat Revenue | **Total Revenue** |
|---|---|---|---|---|---|---|---|---|
| January | 1 | 1,500 | 2.5% | 38 | $65.00 | $2,470 | $0 | **$2,470** |
| February | 2 | 1,620 | 2.5% | 41 | $65.00 | $2,668 | $108 | **$2,776** |
| March | 3 | 1,750 | 2.5% | 44 | $65.00 | $2,881 | $235 | **$3,116** |
| April | 4 | 1,890 | 2.5% | 47 | $65.00 | $3,111 | $406 | **$3,517** |
| May | 5 | 2,040 | 2.5% | 51 | $65.00 | $3,360 | $620 | **$3,980** |
| June | 6 | 2,203 | 2.5% | 55 | $65.00 | $3,628 | $883 | **$4,511** |
| July | 7 | 2,379 | 2.5% | 60 | $65.00 | $3,917 | $1,198 | **$5,115** |
| August | 8 | 2,570 | 2.5% | 64 | $65.00 | $4,229 | $1,570 | **$5,799** |
| September | 9 | 2,775 | 2.5% | 69 | $65.00 | $4,567 | $2,005 | **$6,572** |
| October | 10 | 2,996 | 2.5% | 75 | $65.00 | $4,933 | $2,511 | **$7,444** |
| November | 11 | 3,235 | 2.5% | 81 | $65.00 | $5,328 | $3,100 | **$8,428** |
| December | 12 | 3,494 | 2.5% | 87 | $65.00 | $5,755 | $3,793 | **$9,548** |
| **YEAR 1 TOTAL** | — | 32,127 | 2.5% | 803 | $65.00 | $52,878 | $16,410 | **$69,288** |

**Formulas Used:**
- Sessions(M) = Sessions(M-1) × (1 + 8%)
- Orders = Sessions × Conversion Rate
- Gross Revenue = Orders × AOV
- Repeat Revenue = Prior months' customers × Repeat Rate × Average repeat frequency per month
- Total Revenue = Gross Revenue + Repeat Revenue

---

## YEAR 1: COST OF GOODS SOLD & GROSS MARGIN

| Month | Total Revenue | COGS (28%) | Fulfillment Cost | **Total COGS** | **Gross Profit** | **Gross Margin %** |
|---|---|---|---|---|---|---|
| January | $2,470 | $692 | $95 | $787 | $1,683 | 68.1% |
| February | $2,776 | $777 | $103 | $880 | $1,896 | 68.3% |
| March | $3,116 | $872 | $116 | $988 | $2,128 | 68.3% |
| April | $3,517 | $984 | $118 | $1,102 | $2,415 | 68.7% |
| May | $3,980 | $1,114 | $128 | $1,242 | $2,738 | 68.8% |
| June | $4,511 | $1,263 | $138 | $1,401 | $3,110 | 69.0% |
| July | $5,115 | $1,432 | $151 | $1,583 | $3,532 | 69.1% |
| August | $5,799 | $1,624 | $161 | $1,785 | $4,014 | 69.2% |
| September | $6,572 | $1,840 | $174 | $2,014 | $4,558 | 69.3% |
| October | $7,444 | $2,084 | $188 | $2,272 | $5,172 | 69.5% |
| November | $8,428 | $2,360 | $204 | $2,564 | $5,864 | 69.6% |
| December | $9,548 | $2,673 | $218 | $2,891 | $6,657 | 69.7% |
| **YEAR 1 TOTAL** | $69,288 | $19,402 | $2,008 | $21,410 | $47,878 | **69.

Grok 4.1 Fast Reasoning 9/10

# 3-Year Financial Projections Template: DTC Skincare Brand

This template projects a 3-year financial model for a DTC skincare brand launching in Month 1 (Q1 Year 1) on Shopify, with primary traffic from Meta ads. Revenue scales with 8% MoM growth in ad spend (driving paid traffic), constant CPC and conversion rate, and repeat revenue buildup. All figures in USD, rounded to nearest whole dollar. Orders rounded to nearest whole number.

**How to use:** 
- Edit values in the **Assumptions** table (e.g., copy to Excel/Google Sheets).
- Formulas are explicit below each table or in notes. Replace defaults with your numbers and recalculate (e.g., drag formulas).
- Key formulas:
  - Traffic_t = Ad Spend_t / CPC
  - New Orders_t = Traffic_t × Conversion Rate
  - New Revenue_t = New Orders_t × AOV
  - Repeat Revenue_t = Repeat Rate × Total Revenue_{t-1} (Month 1 = $0)
  - Total Revenue_t = New Revenue_t + Repeat Revenue_t
  - Total Orders_t = Total Revenue_t / AOV
  - Ad Spend_t = Prior Ad Spend × (1 + MoM Ad Growth)
  - Payroll_t = Prior Payroll × (1 + MoM Payroll Growth)
- Years 2-3 assume continued 8% MoM ad spend growth and same rates (annual aggregates from Months 13-24 and 25-36).

## Assumptions
Editable inputs with defaults based on business details (AOV $65, COGS 28%, initial ad $15k/mo, 8% MoM growth).

| Parameter                  | Default Value | Notes/Formula |
|----------------------------|---------------|---------------|
| AOV                        | $65          | Average Order Value |
| COGS %                     | 28%          | % of Total Revenue |
| CPC                        | $1.00        | Cost per visitor (Meta ads) |
| Conversion Rate            | 2.5%         | Traffic to orders |
| Repeat Rate (monthly)      | 12%          | % of prior Total Revenue from repeats |
| Initial Ad Spend (Month 1) | $15,000      | Marketing budget (100% variable ads) |
| MoM Ad Spend Growth        | 8%           | Drives scaling |
| Fulfillment $/Order        | $8.00        | Shipping/packaging per total order |
| Payment Processing %       | 2.9%         | % of Total Revenue |
| Payment Processing Fixed   | $0.30        | Per total order |
| Software Fixed/mo          | $500         | Shopify + apps (fixed) |
| Initial Payroll/mo (M1)    | $5,000       | Founder/team; scales separately |
| MoM Payroll Growth         | 5%           | Conservative scaling |
| Starting Cash (pre-M1)     | $200,000     | Seed capital for burn |

## Revenue Assumptions
Monthly for Year 1 (traffic driven by ad spend). Annual new orders = sum(Traffic × Conv Rate). Repeats build over time.

| Period     | Traffic (Visitors) | New Orders | Repeat Rev | Total Revenue |
|------------|---------------------|------------|------------|---------------|
| Month 1   | 15,000             | 375       | $0        | $24,375      |
| Month 2   | 16,200             | 405       | $2,925    | $29,250      |
| Month 3   | 17,496             | 437       | $3,510    | $31,941      |
| Month 4   | 18,896             | 473       | $3,833    | $34,563      |
| Month 5   | 20,407             | 510       | $4,148    | $37,310      |
| Month 6   | 22,040             | 551       | $4,477    | $40,292      |
| Month 7   | 23,803             | 595       | $4,835    | $43,515      |
| Month 8   | 25,707             | 643       | $5,222    | $46,996      |
| Month 9   | 27,764             | 694       | $5,640    | $50,756      |
| Month 10  | 29,985             | 750       | $6,091    | $54,818      |
| Month 11  | 32,384             | 810       | $6,578    | $59,202      |
| Month 12  | 34,975             | 874       | $7,104    | $63,963      |
| **Year 1 Total** | **284,657**   | **7,117** | **54,363**| **516,981**  |
| **Year 2**       | **722,220**     | **18,056** | **199,412**| **1,310,926**|
| **Year 3**       | **1,812,500**   | **45,313** | **549,149**| **3,301,549**|

*Formulas: See top. Year 2/3 traffic = prior year end traffic × 1.08^12 ×12-mo geometric sum factor (18.977).*

## Revenue Forecast
Cumulative scaling with repeats.

| Period     | Total Revenue |
|------------|---------------|
| Month 1   | $24,375      |
| Month 2   | $29,250      |
| Month 3   | $31,941      |
| Month 4   | $34,563      |
| Month 5   | $37,310      |
| Month 6   | $40,292      |
| Month 7   | $43,515      |
| Month 8   | $46,996      |
| Month 9   | $50,756      |
| Month 10  | $54,818      |
| Month 11  | $59,202      |
| Month 12  | $63,963      |
| **Year 1 Total** | **$516,981** |
| **Year 2**      | **$1,310,926**|
| **Year 3**      | **$3,301,549**|

## COGS & Gross Margin
COGS = Revenue × 28%. Gross Margin $ = Revenue - COGS. % = 72% constant.

| Period     | COGS     | Gross Profit | Gross Margin % |
|------------|----------|--------------|----------------|
| Month 1   | $6,825  | $17,550     | 72%           |
| Month 2   | $8,190  | $21,060     | 72%           |
| Month 3   | $8,944  | $22,997     | 72%           |
| Month 4   | $9,678  | $24,885     | 72%           |
| Month 5   | $10,447 | $26,863     | 72%           |
| Month 6   | $11,282 | $29,010     | 72%           |
| Month 7   | $12,184 | $31,331     | 72%           |
| Month 8   | $13,159 | $33,837     | 72%           |
| Month 9   | $14,212 | $36,544     | 72%           |
| Month 10  | $15,349 | $39,469     | 72%           |
| Month 11  | $16,577 | $42,625     | 72%           |
| Month 12  | $17,910 | $46,053     | 72%           |
| **Year 1 Total** | **$144,756** | **$372,225** | **72%**     |
| **Year 2**      | **$367,059**  | **$943,867** | **72%**     |
| **Year 3**      | **$924,434**  | **$2,377,115**| **72%**    |

## Operating Expenses
Marketing = ad spend. Fulfillment = Orders × $8. Payment = Rev × 2.9% + Orders × $0.30. Software = $500/mo (annual $6k). Payroll as scaled.

| Period     | Marketing | Fulfillment | Payment Proc. | Software | Payroll  | Total OpEx |
|------------|-----------|-------------|---------------|----------|----------|------------|
| Month 1   | $15,000  | $3,000     | $708         | $500    | $5,000  | $24,208   |
| Month 2   | $16,200  | $3,600     | $849         | $500    | $5,250  | $26,399   |
| Month 3   | $17,496  | $3,931     | $927         | $500    | $5,513  | $28,367   |
| Month 4   | $18,896  | $4,256     | $1,003       | $500    | $5,789  | $30,444   |
| Month 5   | $20,407  | $4,592     | $1,083       | $500    | $6,078

What makes these work

01

Feed it your actual CAC by channel
Don't give the AI a blended CAC. Break it out by Meta, Google, TikTok, and organic so the model can show how channel mix shifts your blended acquisition cost as you scale. Blended numbers hide the truth that Meta CAC often doubles past $30K monthly spend.
02

Separate variable from fixed costs cleanly
Ecommerce models break when 3PL fees, payment processing, and shipping get lumped into OpEx. Tell the AI to treat these as variable and tie them to order volume. This makes your contribution margin meaningful and lets you stress-test revenue scenarios.
03

Always request a cash flow view
P&L profitability and cash profitability are different animals in ecommerce because inventory eats cash months before revenue shows up. Ask for a cash flow statement that accounts for supplier deposits, inventory lead times, and payment processor holds.
04

Include sensitivity on two variables
Ask the model to flex ROAS and repeat rate. These are the two assumptions that make or break DTC models. A sensitivity table showing outcomes at 1.8x, 2.2x, and 2.6x ROAS crossed with 15%, 25%, and 35% repeat rate tells investors you've thought about downside.

More example scenarios

#01 · Skincare DTC brand projecting Year 1 with paid social

Input

Skincare brand launching on Shopify. AOV $65, gross margin 72%, Meta ads budget $15K/month at 2.1 ROAS, 18% repeat rate within 90 days, 4% return rate. Founder salary $4K/month, 3PL fees $6/order. Project 12 months with monthly P&L and cash flow.

Expected output

Month 1-12 P&L showing revenue scaling from $31K to $58K, gross profit after COGS and returns, detailed OpEx with ad spend, 3PL, Shopify fees at 2.9% plus $0.30. Contribution margin of 28% after variable costs. Cash flow section flags a $22K working capital gap in Month 4 driven by inventory reorder.

#02 · Apparel brand modeling inventory financing need

Input

Streetwear brand, $400K revenue last 12 months, 55% gross margin, seasonal peaks in November. Inventory lead time 90 days, supplier terms net 30 with 30% deposit. Considering $150K inventory loan at 12% APR to fund Q4. Model 18 months with and without loan.

Expected output

Two-scenario model. Without loan: Q4 revenue capped at $180K due to stockouts, full-year revenue $520K. With loan: Q4 revenue $340K, full-year $720K, loan interest expense $14K, net benefit $86K. Cash flow shows payback by Month 14.

#03 · Subscription box service pre-seed projections

Input

Monthly coffee subscription, $35/month, 62% gross margin including shipping. Current: 400 subscribers, 6% monthly churn, $28 CAC. Planning to raise $500K pre-seed. Model 24 months assuming CAC scales to $42 at 10x current ad spend.

Expected output

MRR projection growing from $14K to $87K by Month 24. LTV calculated at $364, LTV/CAC ratio 8.7x degrading to 6.2x at scale. Runway analysis: $500K raise plus revenue funds 22 months at planned burn. Flags churn as the single biggest sensitivity variable.

#04 · Home goods brand expanding to Amazon

Input

Home decor brand doing $80K/month on Shopify at 45% contribution margin. Launching on Amazon FBA, expecting $20K/month by Month 6. Amazon fees 15% referral plus $4/unit FBA, expected ACoS 28%. Model blended P&L for 12 months.

Expected output

Channel-split P&L: Shopify margin holds at 45%, Amazon margin lands at 19% after fees and ACoS. Blended contribution margin drops from 45% to 38% as Amazon mix grows. Total revenue reaches $1.2M Year 1, but recommends monitoring Amazon unit economics monthly.

Common mistakes to avoid

Using revenue instead of contribution margin
Founders project $2M in Year 1 revenue and forget that at 22% contribution margin, that's only $440K to cover fixed costs and payroll. Always build from contribution margin up, not revenue down.
Ignoring return rates and chargebacks
A 12% return rate on apparel or a 2% chargeback rate on high-AOV goods can wipe out your margin. The AI won't add these unless you specify them. Build refunds and chargebacks in as a revenue contra-line.
Assuming flat CAC as you scale
Paid acquisition gets more expensive as you spend more, not less. If your model shows CAC holding at $28 while ad budget 5x's, the model is wrong. Force CAC inflation of 15 to 30% per doubling of spend.
Forgetting payment processor holds
Stripe and Shopify Payments hold reserves for new merchants, sometimes 20% for 90 days. This can create a real cash crunch that a standard P&L hides. Model your actual deposit schedule, not your gross sales.
Not tying inventory to revenue
Many templates treat inventory as a one-time purchase. In reality, you reorder every 60 to 120 days. If the AI doesn't build recurring inventory purchases tied to sell-through, your cash projections are fiction.

Related queries

Frequently asked questions

What should an ecommerce financial projection include?

At minimum: monthly revenue by channel, COGS with landed cost, variable costs (shipping, 3PL, processing fees, ad spend), fixed OpEx, contribution margin, EBITDA, and a cash flow statement that accounts for inventory timing. For investors, add LTV, CAC, payback period, and channel-level ROAS.

How many months should I project out?

12 months monthly for operational planning, 24 to 36 months for fundraising. Anything beyond 36 months in ecommerce is speculation because CAC, platform fees, and consumer behavior shift too fast. Investors care most about the first 18 months and the path to profitability or next round.

Can I use this template for a Kickstarter or pre-launch brand?

Yes, but flag every assumption clearly. Without sales data, you're modeling off benchmarks: expect 2 to 3% conversion rate, $40 to $80 AOV for consumer goods, and CAC of $25 to $60 depending on category. Build three scenarios (conservative, base, aggressive) instead of a single point estimate.

What's a realistic gross margin for an ecommerce business?

Apparel and accessories typically run 55 to 70%, beauty and skincare 65 to 80%, food and beverage 35 to 55%, electronics 20 to 40%, and print-on-demand 15 to 30%. These are after COGS and landed cost but before shipping, fees, and ad spend. Your contribution margin after variable costs is usually 20 to 35 points lower.

Do I need Excel skills to use an AI-generated template?

Basic spreadsheet skills help, but the AI can output in formats you paste directly into Google Sheets or Excel. Ask for the response as a markdown table or CSV. For a working model with formulas, you'll need to build those yourself or ask the AI to generate Google Sheets formulas explicitly.

How accurate are AI-generated financial projections?

The structure is reliable. The numbers are only as good as the assumptions you feed in. AI won't sanity-check whether your 3x ROAS assumption is realistic for your category, and it will happily extrapolate a hockey stick. Treat the output as a framework you validate against benchmarks and your own data.