I need excel formula to solve it

Ha_Zutt 1 - . ALAB DE Problem 5-26 Perpetuities. Consider the data in the following table. Perpetuity 34 5 6 789 Annual Amount 20,000 100,000 | 3,000 | 60,000 Discount Rate 8% 100 6% 5 % B Determine the present value of each perpetuity. Solution Value of perpetuity A Value of perpetuity B Value of perpetuity C Value of perpetuity D Points 21 Requirements 1 In cell E15, by using cell references to the given data, calculate the present value of perpetuity A 2 In cell E16, by using cell references to the given data, calculate the present value of perpetuity B 3 In cell E17, by using cell references to the given data, calculate the present value of perpetuity C 4 In cell E18, by using cell references to the given data, calculate the present value of perpetuity D. 5 Save the workbook Close the workbook and then exit Excel Submit the workbook as directed. | Problem 5-26 2 . SAN