How to Use This Resource: This guide explains the financial concepts behind the Sunrise Cafe Expansion workbook. Read it before starting the assignment to understand CAGR, projection methods, ramp-up modeling, and scenario planning.
In Unit 7, you analyzed the past. In this unit, you project the future. Financial projections are how businesses answer "what if?" questions with numbers instead of guesses. Every company that plans to expand, hire, borrow money, or launch a new product builds projections first.
CAGR: Measuring Growth
Before you can project forward, you need to measure how fast a business is growing. The standard tool for this is CAGR (Compound Annual Growth Rate), though for monthly data we calculate a compound monthly growth rate using the same formula.
Growth Rate = (End Value / Start Value) ^ (1 / Number of Periods) − 1
The key question is: how many periods? Count the gaps between your start and end points, not the number of data points. If you have data from January through December, that is 12 months of data but only 11 periods of growth (Jan→Feb, Feb→Mar, …, Nov→Dec).
A cafe earned $23,500 in January and $31,100 in December.
Step by step:
- Divide: $31,100 / $23,500 = 1.3234
- Raise to the power of 1/11: 1.3234 ^ 0.0909 = 1.0258
- Subtract 1: 1.0258 − 1 = 0.0258 = 2.58% per month
If January revenue is in cell B5 and December revenue is in cell B16:
Format the result as a percentage. You should get approximately 2.6%.
A 2.6% monthly growth rate might sound small, but compounding is powerful. Over a full year, it turns $23,500 into $31,100, a 32% increase. This is exactly why CAGR is more useful than simply averaging each month's change: it accounts for the fact that growth builds on itself.
Flat vs. Growth Projections
Once you know the growth rate, there are two common ways to project future revenue:
Assume every future month equals your current average monthly revenue. If the cafe averaged $27,500/month this year, project $27,500 for every month next year. This is conservative. It ignores any growth trend.
Start from your most recent month's revenue and grow it forward using the CAGR you calculated. Each month equals the previous month multiplied by (1 + growth rate).
If your growth rate is in one cell (say you calculated it as 2.58%) and January Year 2 revenue is in cell E8:
Each cell references the one above it. This "chain" approach makes the formula easy to copy down.
Neither method is perfect. Flat projections underestimate growing businesses. Growth projections can overestimate if the business is approaching market saturation. Most analysts use growth projections but apply judgment about whether the rate is sustainable. A cafe that grew 2.6% monthly in its first year may slow in its second year as the initial novelty fades.
Revenue Ramp-Up
When a business opens a new location, that location does not immediately earn the same revenue as the original. It takes time to build awareness, attract regulars, and reach capacity. This period is called the ramp-up.
If the original cafe earns $31,100/month, a second location might earn only $9,300 in its first month (about 30% of the original). Over the next year, as more customers discover it, revenue grows toward some target fraction of the original. Whether it reaches 60%, 75%, or 100% depends on factors like location quality, competition, and marketing.
A common simplification is linear ramp-up: revenue increases by the same dollar amount each month from a starting percentage to a target percentage. The formula is:
For example, ramping from 30% to 75% over 12 months:
The ramp-up period is financially dangerous. During these early months, the new location has most of its costs (rent, wages, loan payments) but only a fraction of its eventual revenue. The business must have enough cash to survive this period of losses.
Fixed vs. Variable Costs
Fixed costs stay the same regardless of how much revenue the business generates. Rent, loan payments, and base wages are fixed. The new location pays $4,000/month in rent whether it serves 100 customers or 1,000.
Variable costs change with revenue. Ingredients are a variable cost. If the cafe's ingredient cost ratio is 30%, then for every $1,000 in additional revenue, ingredient costs increase by $300. You can calculate this ratio from the original location's historical data: total ingredient costs divided by total revenue.
This distinction matters because during the ramp-up period, the new location has nearly all of its fixed costs but low revenue. As revenue grows, variable costs grow too, but the fixed costs stay flat, so a larger share of each new dollar goes to profit.
Scenario Planning
No one knows exactly what will happen. Scenario planning addresses this by modeling multiple possible futures and comparing the outcomes:
| Scenario | What It Assumes | Purpose |
|---|---|---|
| Bear (Pessimistic) | Revenue ramps up slowly. The new location reaches a lower fraction of the original's revenue. | Defines the worst plausible case. If you can survive the bear case, the expansion is low risk. |
| Neutral (Base Case) | Things go roughly as expected. The most likely single outcome. | The plan you build around. |
| Bull (Optimistic) | Customer acquisition goes smoothly. Revenue ramps up faster, reaching a higher fraction of the original. | Defines the upside. |
In the workbook, the only number that changes between scenarios is the target revenue percentage at Month 12. Everything else (rent, wages, loan payments, ingredient ratio) stays the same. This isolates the key question: how fast does the new location build its customer base?
How do you decide what percentages to use? In practice, scenario assumptions are informed by qualitative research: reading industry news, analyst reports, and company filings. Is there a new competitor opening nearby? Has the neighborhood been growing? Are ingredient costs rising? A bear case for a cafe expanding into an area with three new competitors looks different from a bear case for a cafe expanding into an underserved neighborhood. The numbers in a model should reflect what you actually know about the business and its environment.
Making the bull case unrealistically optimistic or the bear case unrealistically pessimistic. Good scenarios are all plausible. The bear case is not "everything goes wrong at once." It is "growth is slower than expected." The bull case is not "the cafe becomes the most popular restaurant in the city." It is "customer acquisition goes smoothly."
Break-Even Analysis
Break-even is the point where revenue equals costs:
The first month where the new location's revenue exceeds its costs. After this point, the location makes money each month going forward. Look for the month where Monthly P/L first goes positive.
The month where total revenue since opening first exceeds total costs since opening. This takes longer because the business must first earn back the losses accumulated during the ramp-up.
For many new locations, monthly break-even happens within the first year but cumulative break-even takes 18 to 24 months. This is normal. The critical question is: does the business have enough cash reserves to survive until that point? The most negative value in the Cumulative P/L column tells you the maximum cash the business needs to set aside.
Debt Servicing
Many expansions are funded by loans. The key number is the monthly payment: a fixed amount that covers both principal repayment and interest. For an $80,000 loan at 8% over 5 years, the monthly payment is approximately $1,622. This payment is the same every month for the life of the loan, regardless of how the business is doing. This is why over-leveraging (borrowing too much) is dangerous: the debt payments can sink a business during a downturn.
Putting It All Together
The workbook walks you through the complete process:
- Measure historical performance (Tab 1: averages, CAGR, trend interpretation)
- Project the existing business forward (Tab 2: flat vs. growth projections)
- Model the new location (Tab 3: costs, revenue ramp-up, break-even)
- Run multiple scenarios and decide (Tab 4: bear/neutral/bull, charts, recommendation)
This is the same process, at a simplified level, that professional financial analysts use when evaluating whether a company should expand, acquire another business, or launch a new product.