Year2 Year3 Year4 Sales Operating Income of Restaurants Percent of Sales Corporate Expenses Interest Corporate Operating Income Taxes Net Income Year 1 27490000 2625000 9.5% 481,075 350,700 $ 1,793,225 $ 609,697 $ 3281250 9.5% 515437.5 350,700 2,415,113 821,138.25 4265625 5758594 9.5% 9.5% 670068.75 904592.8125 $ 350,700 $ 350,700 $ 3,244,856 $ 4,503,301 $1,103,251.13 $1,531,122.32 $ $ Net Present Value of Investment for Restaurant Construction Planning Assumptions Loan to Cover Construction Costs Interest Rate Years to Repay $9,900,000 4.57% 25 Year 1 Growth in Sales Year 2 28.00% 1.50% 34.00% Year 3 40.00% 2.00% 34.00% Year 4 38.00% 2.00% 34.00% Corporate Expenses as percent of Sales 1.50% 34.00% Tax Rate Type of formula in cell C2 of the "Sales and Profit Plan" worksheet that uses the percentage in cell C8 in the "Assumptions" worksheet to calculate the projected sales for Year 2. Copy this formula and paste it to cells D2: E2. Type of formula into cell B9 that subtracts the value in cell B8 from the value in cell B7. Copy the formula in cell B9 and paste it into cells C9:E9. Type an NPV function and show NPV outcome in cell D12. You may use an input value from "Assumptions" worksheet