Create a new What SUP Present Value Analysis a) Using the ch7-01 file to start your work, modify that worksheet to do the following: I) 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 $95000 and illustrate the annual value of that investment II) calculate the future value of an investment of $20000 invested for 4 years at a rate of 3 percent and illustrate the annual value of that investment. III) calculate the future value of an investment of $8500 each year for 4 years at a rate of 3 percent and illustrate the annual value of that investment. IV) calculate the initial investment required to obtain a future value of $10500 assuming a rate of 3 percent for 4 years and illustrate the annual value of that invetment. b) save the file as ch7-01 _student_name (replacing student_name with your name) c) Print the resulting worksheet

A1 what sup C D 1 What SUP 2 Ch 07-01 3 Present Value Analysis Year Interest Annui Investment 6 Future need: 7 Term (in years): 8 Interest rate: 9 Annuity payment required: 10 $95,000.00 4 496 4 12 13 Current investment: 14 Interest rate: 15 Term (in years): 16 Investment value in future Year Interest lInvestment ($20,000.00) 3% 4 4 18 19 20 Current annuity investment: 21 Interest rate: 22 Term (in years): 23 Investment value in future: Year Interest Annui Investment ($8,500.000 3% 4 4 25 26 27 Future need: 28 Interest rate: 29 Term (in years): 30 Invest now: Year Interest lInvestment $10,500.00 3% 4 4 32