How to Create a Profit & Loss Forecast
Build credible P&L projections that show investors when you'll be profitable. Learn line-item forecasting, revenue modeling, and expense estimation with real examples.
A Profit & Loss (P&L) forecast—also called an income statement projection—shows whether your business will make or lose money over the next 3-5 years. It's the most scrutinized financial document in your business plan because it reveals your path to profitability and validates your business model's viability.
Anatomy of a P&L Statement
Every P&L follows the same structure. Here's the skeleton:
Forecasting Revenue: The Top Line
Revenue projections should be bottoms-up, not top-down. Don't say "we'll capture 1% of a $10B market." Instead, build from unit sales:
Example: SaaS Company
| Metric | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| New customers/mo | 20 | 50 | 100 |
| Avg price/month | $99 | $99 | $129 |
| Total customers EOY | 200 | 750 | 1,800 |
| Churn rate | 5% | 4% | 3% |
| Annual Revenue | $180K | $832K | $2.5M |
Notice the detail. You're not pulling numbers from thin air—you're showing how many customers you need to acquire each month and at what price. Investors can challenge your assumptions, which is exactly what you want. It proves you've done the math.
Cost of Goods Sold (COGS): What It Costs to Deliver
COGS includes only direct costs that scale with revenue. If you don't make a sale, you don't incur the cost:
✓ COGS Examples
- • Product: Raw materials, packaging
- • SaaS: Hosting costs, API fees
- • Service: Contractor/freelancer fees
- • Restaurant: Food & beverage costs
✗ NOT COGS
- • Salaries (operating expense)
- • Rent (operating expense)
- • Marketing (operating expense)
- • Software subscriptions (OpEx)
A healthy gross margin (Revenue - COGS) should be 60-80% for SaaS, 50-70% for services, 30-50% for physical products. If your gross margin is below 30%, you have a pricing problem or a cost structure problem.
Operating Expenses: Running the Business
Operating expenses (OpEx) are fixed and semi-variable costs to run the business. Break them into categories:
Typical OpEx Categories
Sales & Marketing (S&M)
Salaries, advertising, events, tools (HubSpot, Google Ads)
Benchmark: 40-50% of revenue for early-stage startups
General & Administrative (G&A)
Rent, legal, accounting, insurance, office supplies
Benchmark: 10-20% of revenue
Research & Development (R&D)
Engineering salaries, product development, software tools
Benchmark: 15-25% of revenue for tech companies
The Path to Profitability
Most businesses lose money in Year 1-2 while building customer base. Investors want to see:
- When you'll break even: The month/quarter where revenue exceeds expenses
- Path to profitability: Clear milestones showing improving unit economics
- Operating leverage: Revenue growing faster than expenses (proof the model scales)
Example Timeline
- Year 1: -$200K loss (building product, early customers)
- Year 2: -$100K loss (revenue growing, costs stabilizing)
- Year 3: +$300K profit (hit scale, positive unit economics)
Key Ratios Investors Watch
Don't just show the P&L—analyze it with these ratios:
Gross Margin %
= (Revenue - COGS) ÷ Revenue × 100
Target: 60%+ for SaaS, 40%+ for products
Operating Margin %
= Operating Income ÷ Revenue × 100
Target: Break even by Year 3, 20%+ by Year 5
Burn Rate
= Monthly net loss (how fast you're spending cash)
Target: Minimize while maintaining growth
Common Forecasting Mistakes
- 🚫 Hockey stick projections: Going from $0 to $10M in Year 2 with no justification
- 🚫 Forgetting seasonality: Retail spikes in Q4; B2B slows in summer
- 🚫 Underestimating expenses: Always pad 10-20% for unexpected costs
- 🚫 Static assumptions: Prices, costs, and conversion rates change over time