Please help answer the last part question with this template. What discount rate would cause the two alternatives to have the same cost in present value terms? I can get get the alternative to match. Please send corrected answer in excel format.

6. The narrow gravel road to Jehnzen Lake is open only for the summer months. At present, the county spends $750 per mile each year to prepare the road for summer traffic and another $150 per mile for maintenance during the period in which it is open. A "permanent" road could be constructed at a cost of $10,000 per mile; the county would have to spend $800 per mile for maintenance (patch- ing, etc.) only every five years through the thirty-year life of the road. Prospects for the area suggest that the road would have to be relocated at the end of that period. If 5 percent is a reasonable discount rate, which option is less costly? What discount rate would cause the two alternatives to have the same cost in present value terms A E H 1 2 4 5 7 8 Alternative Upfront 10000 Year 5 627 Year 10 491 Year 15 385 Year 20 302 Year 25 236 Year 30 185 Total 12226 800 300 10 11 12 13 14 15 16 17 18 19 20 21 22 900 Dsicount Rate: 0.0500 Current Road HPY 13,835.21 Year Current Road Proposed 0 10000 1 900 2 900 3 900 4 900 5 900 800 6 900 7 900 900 900 10 900 800 11 900 12 13 900 14 900 15 900 800 16 17 900 18 900 19 900 20 800 21 900 22 900 23 900 24 900 25 900 800 26 900 27 900 28 900 29 900 30 900 M N Use trial and error to find the rate that will get the same NPV for both options. Dsicount Rate: 0.03649 Current Road NPY Alternative 13,835.21 Upfront 10000 Year Current Roc Proposed Year 5 669 0 10000 Year 10 559 1 900 Year 15 467 2 Year 20 391 3 900 Year 25 327 4 900 Year 30 273 5 100 800 Total 12685 6 7 900 8 900 900 10 100 800 11 900 12 900 13 900 14 900 15 100 800 16 900 17 900 18 900 19 900 20 800 21 900 22 900 23 900 24 900 25 100 800 26 900 27 900 28 900 29 900 30 900 800 24 25 26 27 28 900 100 35 37