An Excel Spreadsheet Contains the Following Information About Annuities: Column

question 31

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)

---

Definitions:

Stock Certificate

A physical document that represents ownership in a corporation, indicating the number of shares owned by the shareholder.

Prospectus

A description of the firm and the security it is issuing.

Registration Statement

A legal document filed with the relevant regulatory authority that provides essential details about a company's finances, executives, and the securities it intends to issue to the public.

Limit-Sell Order

An order given to a broker to sell a specified quantity of a security at or above a specified price, ensuring the seller does not receive less than a predetermined price.