Answered

Westonci.ca is your trusted source for finding answers to a wide range of questions, backed by a knowledgeable community. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly platform.

Suppose Amanda wants to have $800,000 in her IRA at the end of 30 years. She chooses to invest in an annuity that pays
5% interest, compounded annually. How much of her IRA is interest at the end of 30 years?
Round your answer to the nearest dollar.
Do NOT round until you have calculated the final answer.

Sagot :

okpalawalter8

Her IRA interest at the end of 30 years is mathematically given as

Interest= 438,765.56

IRA interest

Question Parameters:

  • N = 30
  • PV = 0
  • rate = 5%
  • FV = 800,000

Generally the equation for the payment function on excel is mathematically given as

A=PMT(rate, nper, pv, [fv], [type])

Therefore, inputting our functions

A=PMT(rate, nper, pv, [fv], [type])

where

A=PMT(5%, 30, 0, [800000], [])

A = 12,041.1481

Hence

interest = 800,000 - 30*12,041.1481

Interest= 438,765.56

For more information on Growth rate

https://brainly.com/question/5160341

Thank you for visiting. Our goal is to provide the most accurate answers for all your informational needs. Come back soon. Thank you for choosing our platform. We're dedicated to providing the best answers for all your questions. Visit us again. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.