Please Do not use excel fo calculations. It is hard for me to understand.

Jenny Jinglebell has always wished to own her own French macaroons shop. Ever since she tried her first macaroon, she thought it would be a brilliant idea to have her own shop where she can sell a multitude of flavors and colors of French macaroons. She purchased a premium site for the macaroons shop, right across the street from Campus Martius Park in Downtown Detroit.

After extensive research, Jenny decided that it is best for her to open a franchise at first. The franchise that best fit Jennys criteria is Franois Patisserie. A Franois Patisserie franchise costs $30,000, an amount that is amortized over 15 years. As a franchisee, Jenny needs to adhere to the companys building specifications. The building would cost an estimated $450,000 and would result in a $50,000 salvage value at the end of its 15-year life. The equipment needed is sold as a package by the corporate office at a cost of $200,000, will have a salvage value of $10,000 at the end of its 5-year life, equipment and must be replaced every 5 years.

Jenny estimates the annual revenue from a Franois Patisserie franchise at $950,000. Food costs typically run 36% of revenue. Annual operating expenses, not including depreciation, total $425,000. For financial reporting purposes, Jenny will use straight-line depreciation and amortization. Based on past experience, she uses a 16% discount rate.

Required:

a. Calculate the shops net present value over the franchises 15-year life.

b. Calculate the restaurants payback period.

c. Calculate the restaurants simple rate of return.

d. Should Jenny open a Franois Patisserie? Why or why not? Note: for comparison purposes, you should know that using Excel or a similar spreadsheet application Jenny calculates her IRR to be 22.64%.

e. What potential shortcomings do you see in Jennys estimates? How do you recommend she adjusts her analysis to address those shortcomings?