SOLVE USING EXCEL PLEASE !

Question 7 (1 point) You just purchased a growing perpetuity. You paid $71,500 for the growing perpetuity. The perpetuity will make annual payments. The first payment will be received 1 year from today. The payment will growth by 1.8% per year. The required rate of return is 7.3% compounded annually. What is the amount of the payment that you will receive one year from today? Your Answer: Answer Question 4 (1 point) You purchase a growing annuity. The growing annuity will make a payment of $9,800 one year from today. The payment will increase by 5.9% per year. There will be a total of 19 payments. You require a rate of return of 11.9% compounded annually. How much should you pay for the growing annuity? Your