1 Create a new What SUP Present Value Analysis a. Using the ch7-01 le to start your work, modify that worksheet to do the following: i. ii. iv. Calculate the annuity payment required at the end of each year for the next 4 years at 4 percent such that the value in 4 years is $95,000 and illustrate the annual value of that investment. Calculate the future value of an investment of $20,000 invested for 4 years at a rate of 3 percent and illustrate the annual value of that investment. Calculate the future value of an investment of $8,500 each year for 4 years at a rate of 3 percent and illustrate the annual value of that investment. Calculate the initial investment required to obtain a future value of $10,500, assuming a rate of 3 percent for 4 years and illus- trate the annual value of that investment. b. Save the file as ch7-01_student_name (replacing student_name with your name). C. Print the resulting worksheet.What SUP Ch 07-01 Present Value Analysis Year Interest Annuity Investment Future need: $95,000.00 0 Term (in years): 4 1 Interest rate: 4% 2 Annuity payment required: 3 4 Current investment: $20,000.00) Interest rate: 3% Term (in years): 4 Investment value in future: Year Interest Annuity Investment Current annuity investment: ($8,500.00) 0 Interest rate: 3% 1 Term (in years): 4 2 Investment value in future: 3 4 Year Interest Investment Future need: $ 10,500.00 0 Interest rate: 3% 1 Term (in years): 4 2 Invest now: 3 4