What rate of return is built into the annuity

Reference no: EM131977699

Question: Your girlfriend just won the Florida lottery. She has the choice of $15,000,000 today or a 20-year annuity of $1,050,000, with the first payment coming one year from today. What rate of return is built into the annuity? How would I find the answer using excel fucntions? The response must be typed, single spaced, must be in times new roman font (size 12) and must follow the APA format.

Reference no: EM131977699

Questions Cloud

What was the intrinsic value of a warrant : What was the intrinsic value of a warrant at the time of purchase? (Do not round intermediate calculations and round your answer to 2 decimal places.)

What is the npv of the decision to purchase new machine : A firm is considering an investment in new machine with price of $18.15 million to replace its existing machine.What is NPV of decision to purchase new machine.

Physician licensure and physician certification : What is the difference between physician licensure and physician certification?

Process of legislative health policy in the united states : What is the process of legislative health policy in the United States? How is this process related to the principal features of U.S. health policy?

What rate of return is built into the annuity : Your girlfriend just won the Florida lottery. She has the choice of $15,000,000 today or a 20-year annuity of $1,050,000, with the first payment coming.

Define numeric records management : Define numeric records management and list three reasons for storing records by the numeric method.

Human resource management versus organizational development : Without using outside sources, please compare and contrast human resource management versus organizational development.

What is the annual growth rate : Generation X's stock is currently selling for $15 a share. Their most recent dividend paid was $1.50/share and management just declared a dividend of $1.65.

Calculate the real exchange rate : Calculate the real exchange rate between the U.S. and the U.K, q$/£, on 1 March 2018. (round to 3 decimal places)

User Account

All Pages