D2C eCommerce Financial Model with DCF & Multiples Valuation

• D2C brand founders raising pre-seed, seed, or growth-stage capital
• Ecommerce operators selling on their own site plus marketplaces like Amazon and eBay
• FP&A consultants and agencies who need a reliable starting model instead of building one from scratch
• Anyone preparing a loan application or investor deck who needs credible 5-year projections fast

The workbook is structured so you always know where to enter data and where to read your results:

• Table of Content – Clickable navigation to every sheet
• Input Sheet – The single sheet you fill in (grey cells only)
• Startup Investment Summary – Total capital required, broken into CAPEX, marketing, payroll, and pre-revenue costs
• Company Valuation – Pre-money and post-money valuation, EV/EBITDA and EV/Revenue multiples, DCF-based valuation
• Dashboard – Visual summary of revenue, margins, and growth
• Customer Acquisition – Marketing spend, conversion rates, and customers reached by channel
• Revenue Breakdown / Revenue per Product – Sales performance by individual product
• Income Statement, Cash Flow Statement, Balance Sheet – Fully linked three-statement projections
• Payroll – Hiring plan, salaries, and annual increments
• KPI's – Key ecommerce performance metrics over time
• Depreciation and Amortization and Loan Amortization – Asset and debt schedules
• Sensitivity Analysis and Sensitivity Analysis Graphs – Stress-test your key assumptions visually

Every assumption is entered once in the Input Sheet and flows automatically into every other tab:

• Company details: business name, industry, currency, starting month and year
• Investment inputs: owner/investor capital, equity terms, expected investor return
• Loan inputs: loan amount, interest rate, financing term, and repayment schedule
• WACC and tax inputs: cost of equity, cost of debt, corporate tax rate, exit multiple
• Fixed assets/CAPEX: tangible assets (equipment, laptops) and intangible assets (website, app development) with useful life and salvage value
• Payroll plan: hire month, monthly salary, yearly salary increases, bonus %, payroll tax %, and employee benefits %
• Marketing budget by channel: Facebook, Instagram, Google Paid/SEO, YouTube, TikTok — with monthly spend, conversion rate, and customers reached per platform
• Product-level revenue assumptions: average price, % of total customers per product, and a full landed-cost breakdown per product (delivery cost, product cost, import cost, card payment fees)
• Other sales channel assumptions (Amazon, eBay, and more): quantity sold, monthly growth rate, price, and channel-specific fees including commission and fulfillment costs
• Warehouse assumptions: number of warehouses per year and monthly rental/employee cost
• Operating expenses: rent, IT support, utilities, insurance, legal, accounting, and more — each with its own annual growth rate

This template models D2C revenue the way real online stores actually sell — across multiple channels at once:

1. Direct-to-consumer sales through your own store, modeled per product with price, customer share, and full COGS breakdown
2. Other marketplace channels (Amazon, eBay, and similar) modeled separately, each with its own growth rate, pricing, and platform-specific fees like commission and fulfillment cost
3. Customer acquisition tied to revenue, so marketing spend by channel feeds directly into customers reached and, ultimately, into sales volume

This multi-channel, product-level structure is what makes this a true D2C ecommerce financial forecasting model, rather than a single-line "total revenue" assumption.

• Ready-to-use: download and start entering your own numbers immediately — no setup required
• Simple by design: only the grey input cells need to be filled; every statement and chart updates on its own
• Built for D2C ecommerce specifically: own-store sales, marketplace channels, landed costs, and warehousing are modeled natively
• Investor-ready outputs: valuation, dashboard, and sensitivity analysis are already formatted for fundraising and lender conversations
• Fully editable and unlocked: no password protection, so you can rename products, channels, and cost lines to match your business
• Five-year visibility: track how product margins, ad spend efficiency, and cash position evolve as you scale
• Built-in fundraising calculator: the Startup Investment Summary tab tells you exactly how much capital to raise across CAPEX, marketing, payroll, and working capital