Answered

Looking for trustworthy answers? Westonci.ca is the ultimate Q&A platform where experts share their knowledge on various topics. Explore a wealth of knowledge from professionals across various disciplines on our comprehensive Q&A platform. Experience the convenience of finding accurate answers to your questions from knowledgeable experts on our 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

We hope this information was helpful. Feel free to return anytime for more answers to your questions and concerns. We appreciate your time. Please come back anytime for the latest information and answers to your questions. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.