Reference no: EM131581282

Problem - Ryan Huston's lifelong dream is to own a restaurant. He owns a premium site for a restaurant across the street from the local university. Now he needs to decide what kind of restaurant to open.

Recently, Ryan began to investigate one of the fastest-growing fast-food franchises in the country, Chuck's Chicken Shack. A Chuck's Chicken Shack franchise costs $69,600, an amount that is amortized over 15 years. As a franchisee, Ryan would need to adhere to the company's building specifications. The building would cost an estimated $1,044,000 and would have a $116,000 salvage value at the end of its 15-year life. The restaurant equipment (fryers, steam tables, booths, counters) is sold as a package by the corporate office at a cost of $464,000, will have a salvage value of $23,200 at the end of its five-year life, and must be replaced every five years.

Ryan estimates the annual revenue from a Chuck's Chicken Shack franchise at $2,204,000. Food costs typically run 36% of revenue. Annual operating expenses, not including depreciation, total $986,000. For financial reporting purposes, Ryan will use straight-line depreciation and amortization. Based on past experience, he uses a 16% discount rate.

(a) Calculate the restaurant's net present value over the franchise's 15-year life.

(b) Use Excel or a similar spreadsheet application to calculate the restaurant's internal rate of return over the franchise's 15-year life.