What is the formula for the perpituity?

A B \begin{tabular}{|c|c|c|} \hline C & D & \\ \hline Perpetuity & Amount & Rate \\ \hline A & 20,000 & 8% \\ \hline B & 100,000 & 10% \\ \hline C & 3,000 & 6% \\ \hline D & 60,000 & 5% \\ \hline \end{tabular} Determine the present value of each perpetuity. Solution Value of perpetuity A Value of perpetuity B Value of perpetuity C Value of perpetuity D \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \end{tabular} Requirements 1 In cell E15, by using cell references to the given data, calculate the present value of perpetuity A. Points 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. 1 1 1 1 0