個案總覽

Excel spreadsheet for instructors.

An entrepreneur is looking for business opportunities since she immigrated to London, Ontario. She has come across a franchising opportunity with Williams Coffee Pub (WCP). The promotional material for WCP indicates that annual sales for a typical restaurant can be up to $1,700,000 with a profit margin of 17.5 per cent. This business opportunity seems very attractive, however, she must do some additional investigation. The purpose of this case is for students to build a spreadsheet-based cash flow model and to use the model to perform basic sensitivity or What if? analysis.

An entrepreneur is looking for business opportunities since she immigrated to London, Ontario. She has come across a franchising opportunity with Williams Coffee Pub (WCP). The promotional material for WCP indicates that annual sales for a typical restaurant can be up to $1,700,000 with a profit margin of 17.5 per cent. This business opportunity seems very attractive, however, she must do some additional investigation. The purpose of this case is for students to build a spreadsheet-based cash flow model and to use the model to perform basic sensitivity or "What if?" analysis.