An Excel Spreadsheet Contains the Following Information About Annuities: Column

Multiple Choice

An Excel spreadsheet contains the following information about annuities: Column A: Payment, Column B: Rate, Column C: Compounded, Column D: Years, Column E: Total Annuity Investment, Column F: Present Value Factor, Column G: Present Value of Annuity Investment, Column H: Total Interest. Which is the formula needed in Column G to calculate the Present Value of Annuity Investment?

A) =ROUND((B6*E6) ,2)
B) =ROUND((A6*F6) ,2)
C) =ROUND((A6*B6*D6) ,2)
D) =ROUND((E6*F6) ,2)