Perpetuities Consider the data in the following table. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Discount rate Annual amount $20,000 8% Determine the present value of the perpetuity. The present value of the perpetuity is $ (Round to the nearest dollar.) Present value of an annuity Consider the following case. (Click on the icon here o, in order to copy the contents of the data table below into a spreadsheet) Amount of annuity $12,000 Interest rate 7% Period (years) 3 a. Calculate the present value of the annuity assuming that it is (1) An ordinary annuity. (2) An annuity due. b. Compare your findings in parts a(1) and a(2). All else being identical, which type of annuity-ordinary or annuity due is preferable? Explain why. BER The present value of the ordinary annuity is $ (Round to the nearest cent) Future value of an annuity Using the values below, answer the questions that follow. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet) Amount of annuity Interest rate Deposit period (years) $2,500 8% 10 a. Calculate the future value of the annuity, assuming that it is (1) An ordinary annuity. (2) An annuity due. b. Compare your findings in parts a(1) and a(2). All else being identical, which type of annuityordinary or annuity dueis preferable as an investment? Explain why a. (1) The future value of the ordinary annuity is S (Round to the nearest cent.)