0.1 Welcome: the model you will build

In this lesson

Meet Copper Kettle Coffee Roasters: 8 cafes in Portland, a wholesale roasting business and an online coffee subscription. The owners want to open more cafes and build a bigger roastery in 2027. They need a five-year forecast, a valuation and a budget they can trust - that is what you will build in this course.

• A tour of the finished model: inputs, schedules, the three statements, DCF, scenarios and checks

Steps

1. Open the complete model file and click through every tab
2. Change one blue input on the Inputs tab and watch revenue, cash and value per share update
3. Set it back before you close the file

Chapters

• 00:00 Welcome
• 00:17 Meet Copper Kettle Coffee Roasters
• 00:39 The Inputs tab
• 01:05 Revenue from simple drivers
• 01:33 The schedules
• 01:50 The income statement
• 02:11 The cash flow statement
• 02:32 The balance sheet balances
• 02:51 What the business is worth
• 03:14 Scenarios and checks
• 03:34 Your turn

Your turn

• Find the 2030 value per share on the DCF tab and write it down - you will rebuild it yourself

Practice files

Download Module-00-Welcome-Practice-Files.zip from the Practice resources tab and open the folder Lesson 0.1: Copper_Kettle_Complete_Model.xlsx. The Practice file is where you start; the Solution file shows the finished result.

Copper Kettle Coffee Roasters and Bluebird Bakery Co. are fictional businesses; all numbers are for training only.