Creating Financial Projections for Your Business
Why Projections Matter Even If You Are Not Seeking Funding
Most business owners who skip financial projections discover problems too late. They launch with $10,000 in savings, spend $3,000 on inventory, $2,000 on a website, $1,500 on advertising, and realize by month three that they are running out of cash with revenue growing slower than expected. A simple 12-month projection would have revealed this gap before launch and given them the option to start smaller, save more before launching, or seek funding to bridge the gap.
Projections also force you to think about unit economics, the financial reality of each individual sale. If your product costs $12 to source, $4 to ship, $1.50 in packaging, and $0.90 in payment processing fees, your total cost per unit is $18.40. If you sell it for $35, your gross profit is $16.60 per unit. If your fixed monthly expenses are $4,000, you need to sell 241 units per month just to break even. That is 8 sales per day. If your customer acquisition cost through advertising is $8 per customer, your real break-even is 348 units because you need to cover the ad spend too. These are the numbers that determine whether your business can actually work, and they only become visible through projection modeling.
Step-by-Step Process
List every expense you will incur before your first sale. For an ecommerce business, this typically includes: business formation filing fees ($50 to $500), initial inventory purchase ($500 to $25,000+), website and ecommerce platform setup ($0 to $500 for Shopify/WooCommerce, more for custom builds), domain name and hosting ($15 to $150 per year), logo and branding ($0 to $2,000), product photography ($0 to $1,000), initial advertising budget ($500 to $5,000), business insurance first month ($30 to $100), packaging materials ($100 to $500), and miscellaneous supplies and software ($200 to $500). Total startup costs for a typical small ecommerce business range from $2,000 to $15,000. Add 25% to your total for expenses you have not thought of yet.
Use a bottom-up approach: estimate how many customers you can realistically acquire each month and multiply by your average order value. Do not start with the total market size and assume you will capture a percentage, because that top-down approach produces fantasy numbers. For a new ecommerce store, realistic month-one sales might be 30 to 100 orders if you are running paid advertising, or 5 to 20 orders if you are relying on organic traffic from SEO (which takes three to six months to ramp up). Model month-over-month growth at 10% to 20% for the first year, which accounts for learning, optimization, and word-of-mouth. If you are in a seasonal category, adjust for seasonality using Google Trends data from your market research.
COGS includes every direct cost associated with fulfilling a sale. For physical products: product purchase cost, inbound shipping from supplier, outbound shipping to customer (unless you charge for shipping), packaging materials, pick-and-pack labor (if using a fulfillment center, typically $2 to $5 per order), and payment processing fees (2.9% + $0.30 per transaction for Stripe/PayPal, slightly less for Shopify Payments). For a $35 product that costs $12 to source, your total COGS might be $18 to $20 per unit, giving you a gross margin of 43% to 49%. Gross margins below 30% make it very difficult to run a profitable ecommerce business after accounting for marketing and overhead costs. If your margins are below 30%, revisit your pricing strategy or find a way to reduce your sourcing costs.
Operating expenses are the costs of running your business beyond the direct cost of goods. Fixed monthly expenses typically include: ecommerce platform subscription ($29 to $299 per month for Shopify), software subscriptions (email marketing, accounting, inventory management: $50 to $300 total), internet and phone ($100 to $200), insurance ($30 to $100), rent or coworking space ($0 for home-based, $200 to $2,000 for dedicated space), and your own salary or owner's draw ($0 initially for many bootstrapped businesses, or whatever you need to cover living expenses). Variable expenses include: advertising spend (often your largest variable cost, typically $500 to $5,000+ per month), freelancer costs (design, copywriting, bookkeeping), and office supplies. Sum your fixed costs to determine your monthly overhead baseline, which is the revenue floor you must exceed before any profit appears.
A cash flow projection tracks when money comes in and when it goes out, which is different from profit. You might be profitable on paper but cash-negative in practice because of timing mismatches. Common cash flow gaps in ecommerce: you pay your supplier 30 days before inventory arrives, but you do not receive customer payments until after orders ship. If your supplier requires $5,000 upfront and your first month generates $3,000 in sales with a 14-day payment processor hold, you are cash-negative by $5,000+ in month one even if each sale is profitable. Build a month-by-month spreadsheet with columns for: beginning cash balance, cash inflows (sales, loans, investment), cash outflows (COGS, operating expenses, loan payments, inventory purchases, tax payments), and ending cash balance. The ending balance each month becomes the beginning balance of the next month. If any month shows a negative ending balance, you need more starting capital or need to adjust your timing. Our cash flow management guide covers this in depth.
Create three versions of your projection: worst-case (50% of expected revenue, 120% of expected expenses), expected (your best estimate based on research), and best-case (150% of expected revenue, 90% of expected expenses). The worst-case scenario is the most important because it answers the critical question: if everything takes twice as long and costs 20% more than you planned, can you survive? If the worst-case scenario shows you running out of cash in month four, you either need more starting capital, lower monthly expenses, or a faster path to revenue. The best-case scenario helps with planning for success: if demand exceeds expectations, do you have the inventory, fulfillment capacity, and customer service bandwidth to handle it? Present all three scenarios in your business plan to show investors or lenders that you have considered a range of outcomes.
What Lenders and Investors Look For
Banks evaluating a loan application focus on your ability to repay. They want to see that your projected cash flow comfortably covers the monthly loan payment (typically a debt service coverage ratio of 1.25 or higher, meaning your cash flow is 25% more than your debt obligations). They also want to see collateral, a personal guarantee, and evidence that your projections are based on realistic assumptions, not wishful thinking.
Investors focus on growth potential and return on investment. They want to see a large and growing market, strong unit economics, a clear path to profitability, and projected returns that justify the risk. A venture capital investor typically expects a 10x return on their investment within five to seven years. An angel investor may accept a 3x to 5x return. Your projections need to show a growth trajectory that makes these returns possible through revenue growth and margin expansion.
Both audiences spot unrealistic projections immediately. Revenue hockey sticks (flat for months then suddenly exponential) without a clear catalyst, perfectly smooth growth curves with no seasonal variation, and gross margins that exceed industry averages by 20+ points are all red flags. Base your projections on comparable businesses in your industry, cite your data sources, and be transparent about your assumptions. A conservative projection that you can defend is always better than an aggressive projection that falls apart under questioning.
Tools for Financial Projections
A spreadsheet (Google Sheets or Excel) is all you need for financial projections. Templates from SCORE (score.org), the SBA, and LivePlan provide pre-built frameworks with formulas that calculate totals, margins, and growth rates automatically. The SCORE financial projection template is free, SBA-approved, and includes separate worksheets for startup costs, revenue projections, P&L statements, and cash flow. For more sophisticated modeling, LivePlan ($20/month) automates much of the process and generates presentation-ready charts for your business plan. But the tool matters far less than the thinking behind the numbers. A simple spreadsheet with honest, well-researched numbers is infinitely more useful than a beautiful LivePlan report built on fantasy assumptions.