Instructions:
- Read “Bubble & Bee Organic: The need for Pro Forma Financial Modeling” by Patterson and Cumber from your Harvard coursepack.
- At the top of page 7, Bubble & Bee identifies four potential scenarios for analysis (rent + 15% growth, rent + no growth, buy + 15% growth, buy + no growth).
- Complete the attached spreadsheet template to forecast Bubble & Bee’s financial performance in each of the four scenarios. You only need to forecast the income statement.
- Bubble & Bee management has provided guidance on the expected growth in each income statement item. You may choose to rely on this guidance, or you may edit it as you see fit.
- Answer the following questions:
- What are the advantages and disadvantages of buying the building?
- Which growth scenario do you think is more likely? Why? How can Bubble & Bee maximize growth?
- What recommendations would you make to Bubble & Bee? You can address the lease vs. buy decision, revenue growth, or anything else you think the company should focus on.