Kellys Boutique has several questions for you that Excel can help answer. 1 Kelly is planning for the future and would like you to prepare a present value analysis. Using the file ch7-04 complete a present value analysis for the following situations. Save the file as ch7-04_student_name (replacing student_name with your name). Print this completed worksheet. Kelly would like to know the following: a. How much she would have to pay at the end of each year, assuming a 5 percent rate of return, to yield $150,000 at the end of 10 years. b. How much she would have at the end of 10 years if she invested $75,000 today, earning 5 percent per year. c. How much she would have at the end of 10 years if she invested $4,785 at the end of each year, earning 5 percent per year. d. How much she would have to invest today to have $204,530 in 10 years, earning 5 percent per year.