Tom is considering expanding his restaurant empire and opening up a new restaurant downtown. The life of the restaurant is expected to be 10 years, at which time Tom plans to retire. Tom is unsure of the proper discount rate to use, but he believes it is either 8% or 12%. Likewise, he thinks his IRR Hurdle rate is 9% or 11%. Tom has developed two scenarios for the projected cash flows of his restaurant empire. The cash flows are shown below. Prepare an analysis and conclude whether or not you believe that Tom should open up the new restaurant. Submit a Word document, but include any analysis that you believe is appropriate from Excel. Year 0 1 2 3 4 5 6 7 8 9 10 Scenario 1 Scenario 2 (400,000) (500,000) 20,000 25,000 30,000 40,000 45,000 40,000 50,000 40,000 50,000 40,000 50,000 40,000 50,000 40,000 50,000 40,000 50,000 40,000 600,000 300,000