Financial Projections & Key Metrics
Guide to Financial Modeling for Startups
Source: EY – The ultimate guide to financial modeling for startups
Why You Must Watch This
For startups, financial modeling is a critical tool to build a sustainable business, raise funding, and avoid cash flow pitfalls. EY’s guide shares best practices from working with over 1,000 startups and scaleups.
Key Takeaways
- Why You Need a Financial Model
- Proves your business can be economically viable.
- Prepares you for different scenarios (delays, slower sales, higher costs).
- Required in fundraising – investors, banks, and grant providers expect it.
- Keeps shareholders informed and holds you accountable to targets.
- Approaches to Forecasting
- Top-Down: Start from market size (TAM/SAM/SOM) → narrow to sales targets.
- Bottom-Up: Build from internal capacity and resources (sales funnel, marketing spend, conversions).
- Best Practice: Combine both. Use bottom-up for 1–2 years and top-down for 3–5 years.
- Core Outputs of a Good Model
- Financial Statements: P&L, balance sheet, cash flow.
- Operational Cash Flow Forecast: Manage liquidity month by month.
- KPIs: Sector-specific (e.g., LTV, CAC, churn for SaaS).
- Core Inputs You’ll Need
- Revenue Forecasts (top-down + bottom-up).
- COGS (production or delivery costs).
- Operating Expenses (OPEX): sales, marketing, admin.
- Personnel Forecasts (by category: direct labor, R&D, G&A, etc.).
- CapEx: equipment, software, facilities.
- Financing: equity, loans, subsidies.
- Supporting Elements
- Working Capital: Payment terms, receivables, payables.
- Depreciation & Taxes: Impact profitability and cash flow.
- Valuation (DCF): Leverage forecasts to value your startup.
- Scenarios & Sanity Checks
- Prepare base, best, and worst-case scenarios.
- Avoid common mistakes: overly optimistic revenues, missing OPEX, unrealistic margins.
- Funding Context
- Debt: Keeps control, but hard to access for early-stage startups.
- Equity: Common for startups, involves dilution.
- Other: Crowdfunding, convertible notes, subsidies, ICOs.
Key Financial Metrics Startups Should Track
Source: 7 Essential Financial Metrics For Startup Grow…
Why This Matters
Focusing on a handful of key metrics helps founders cut through the noise, monitor growth, and stay investor-ready.
Key Takeaways
- Revenue Growth – Measures how fast sales are increasing; steady growth signals market acceptance.
- Gross Margin – Percentage of revenue kept after direct costs; higher margins mean more room to fund growth.
- Burn Rate – How quickly capital is being spent; critical for knowing how long you can last before new funding.
- Customer Acquisition Cost (CAC) – Total cost to acquire one new customer; lower CAC = higher efficiency.
- Customer Lifetime Value (LTV) – Total expected revenue from one customer; higher LTV means customers drive long-term value.
- Cash Flow – Net cash inflows/outflows; positive cash flow gives flexibility to invest and weather shocks.
- Runway – How many months you can operate at current burn rate; more runway = more time to hit profitability or raise funds.
Actionable Steps
- Compare your CAC vs. LTV to validate scalability.
- Monitor burn and runway closely to time fundraising.
- Use gross margin and cash flow as early signals of financial health
