What this lesson covers
How to build financial projections for a business that doesn’t yet have historical data. This lesson covers the construction of a revenue model, break-even analysis, pro forma financial statements, and a use of funds breakdown. The emphasis is on making your assumptions explicit rather than on producing impressive-looking numbers.
Prerequisites
Reading Financial Statements. You need to understand what each financial statement reports before you can construct projected versions.
Step 1: Build the revenue model
The revenue model is the foundation. Every other number in your projections derives from it — directly or indirectly. Start by answering four questions:
- What do you sell? List every revenue stream. A restaurant sells food, beverages, catering, and possibly event hosting. Each stream has different pricing and cost structures.
- What does the customer pay per transaction? This is your average check. Base it on your menu prices and expected product mix — not on what you hope customers will spend.
- How many transactions per day/week/month? Estimate customer volume. Ground this in something concrete: the number of seats and estimated turns per meal service, or the foot traffic past your location, or comparable businesses’ reported volumes.
- How does volume change over time? New businesses don’t open at full capacity. Project a ramp-up period — perhaps 40% of capacity in month one, 60% by month three, 80% by month six.
Worked example: revenue model for a small restaurant
| Revenue stream | Average check | Transactions/day | Days/month | Monthly revenue |
|---|---|---|---|---|
| Lunch service | $14 | 35 | 26 | $12,740 |
| Dinner service | $26 | 45 | 26 | $30,420 |
| Beverage (bar) | $9 | 30 | 26 | $7,020 |
| Weekend events | $800/event | 2/month | — | $1,600 |
| Total (at full capacity) | $51,780 |
Apply the ramp-up: month 1 at 40% = 31,068. Month 6 at 80% = 51,780.
Write down every assumption. “35 lunch transactions/day” is a claim — what’s it based on? Seat count, comparable restaurants, location traffic data? An investor will ask.
Step 2: Identify and classify costs
Divide all costs into fixed and variable:
Fixed costs don’t change with sales volume (within a relevant range):
- Rent / mortgage
- Insurance
- Salaried wages
- Loan payments
- Licenses and permits
- Utilities (base amount)
- Accounting and legal fees
Variable costs scale with sales:
- Cost of goods sold (ingredients, materials)
- Hourly labor (additional staff for busy periods)
- Packaging and supplies
- Credit card processing fees
- Utilities (usage-based portion)
Some costs are semi-variable — they have a fixed base plus a variable component. Utilities are the classic example. For projection purposes, estimate the fixed and variable portions separately.
Worked example: cost structure
| Fixed costs (monthly) | Amount |
|---|---|
| Rent | $3,200 |
| Insurance | $450 |
| Salaried staff (manager, cook) | $7,500 |
| Loan payment | $850 |
| Licenses/permits (amortized) | $150 |
| Utilities (base) | $400 |
| Accounting | $300 |
| Total fixed | $12,850 |
| Variable costs | Rate |
|---|---|
| Food cost | 30% of food revenue |
| Beverage cost | 22% of beverage revenue |
| Hourly labor | 15% of total revenue |
| Supplies/packaging | 2% of total revenue |
| Credit card fees | 3% of total revenue |
| Utilities (variable) | 1% of total revenue |
| Total variable | ~51% of revenue (blended) |
Step 3: Calculate break-even
Break-even analysis answers: at what monthly revenue does the business cover all costs?
Break-even revenue = Fixed costs ÷ (1 − Variable cost ratio)
Using the example above:
- Fixed costs: $12,850/month
- Variable cost ratio: 0.51 (51% of revenue goes to variable costs)
- Break-even: 12,850 ÷ 0.49 = $26,224/month
This means the restaurant needs roughly 20,712 — below break-even. At 60% capacity (month 3), revenue is $31,068 — above break-even. The business should expect to lose money for approximately the first two months.
Break-even in customers: 16, break-even requires about 1,639 transactions per month, or roughly 63 per day across 26 operating days.
Step 4: Build pro forma statements
Now assemble these inputs into projected financial statements for 12 months (monthly) and years 2–3 (annually). Use the same structure from Reading Financial Statements:
Pro forma income statement
For each month, calculate:
- Revenue (from revenue model, applying ramp-up)
- COGS (food cost % × food revenue + beverage cost % × beverage revenue)
- Gross profit (revenue − COGS)
- Operating expenses (fixed costs + variable operating costs)
- Operating income (gross profit − operating expenses)
- Net income (operating income − interest − estimated taxes)
Pro forma cash flow statement
Adjust the income statement for timing:
- When do customers pay? (Immediately for counter service; 30–60 days for catering invoices)
- When do you pay suppliers? (Often 15–30 days after delivery)
- When are large purchases made? (Equipment before opening; replacements as needed)
- When does invested capital arrive? (Up front, in tranches, or on milestones?)
Pro forma balance sheet
Project end-of-period position:
- Cash: opening balance + net cash flow
- Receivables, inventory, and payables: based on operating assumptions
- Equipment: initial value minus depreciation
- Loans: opening balance minus principal payments
- Equity: initial investment + cumulative retained earnings
Consistency check
Verify that:
- Net income on the income statement equals the change in retained earnings on the balance sheet
- Ending cash on the cash flow statement equals cash on the balance sheet
- All three statements tell the same story from different angles
Step 5: Write the use-of-funds statement
The use of funds specifies how invested capital will be allocated. Be specific — “marketing” is not specific enough; “three months of digital advertising at 2,500)” is.
Worked example
For a $75,000 investment:
| Category | Amount | % |
|---|---|---|
| Leasehold improvements (kitchen build-out) | $22,000 | 29% |
| Equipment (oven, refrigeration, POS) | $18,000 | 24% |
| Initial inventory (food, beverage, supplies) | $5,500 | 7% |
| Marketing (pre-opening + first 3 months) | $6,100 | 8% |
| Working capital (covers operating losses during ramp-up) | $18,400 | 25% |
| Licenses, permits, legal fees | $3,000 | 4% |
| Contingency reserve | $2,000 | 3% |
| Total | $75,000 | 100% |
The working capital allocation should match your projected cash flow — if you expect two months of losses at approximately 8,000/month plus a cash buffer, $18,400 is defensible. If your projections show three months of losses, this number is too low.
Common mistakes
- Optimistic revenue, realistic costs: Projections that show aggressive revenue growth but carefully researched costs are the most common failure mode. Reverse the bias — conservative revenue, generous cost estimates — and see if the business still works.
- Ignoring ramp-up: No business opens at full capacity. A projection that shows month-one revenue at steady-state levels is not credible.
- Conflating profit and cash: A profitable month can still produce negative cash flow. Build the cash flow statement — don’t skip it.
- Round numbers everywhere: “25,000 in costs” signal that the projections were invented rather than calculated. Real projections have odd numbers because they derive from specific assumptions.
- No sensitivity analysis: What happens if average check is 15% lower than projected? What if ramp-up takes twice as long? Test your projections against unfavorable scenarios.
Guidance
- Build a 12-month projection for a business you know or are planning. Start with the revenue model and work through each step.
- After completing it, change one key assumption (average check drops by $3, or ramp-up takes two extra months) and observe how the change cascades through all three statements.
- Show the projections to someone unfamiliar with the business and ask them to identify the assumptions. If they can’t find them, the assumptions are hidden — make them explicit.