insert Page Layout Formulas Data Review View Help F1 . 1. Point H B D E 1 Question 01: The Forest Financial Group 1 Point 2 3 The Forest Financial Group needs to prepare a sensitivity analysis for one of their clients. The client wishes to invest $10,000 per year over the next several years and wants to know what 4 the present value of that investment will be given changes in the discount rate and timeline. S Specifically, they want to know what their investment will be worth in today's dollars over the 6 next 4, 5, and 6 years. They also want to know the impact of a variable discount rate using 7 2.5%, 3.0%, 3.5%, and 4.0%. Like any good financial advisor, you realize that Excel's Present 8 Value function can you help you with this calculation, but you want to build a reusable What- If model that can be re-calculated at any time with different values for the years and discount 9 rate. Prepare a sensitivity table of the results using the above data. 10 11 12 13 14 15 16 17 18 19 20 21