You are saving for retirement. To live comfortably, you decide you will need to

Question

You are saving for retirement. To live comfortably, you decide you will need to save $1 million by the time you are 65. Today is your 25th birthday, and you decide, starting today and continuing on every birthday up to and including your 65th birthday, that you will put the same amount into a savings account. If the interest rate is 3%, how much must you set aside each year to make sure that you will have $1 million in the account on your 65th birthday? The amount to deposit each year is s(Round to the nearest dolilar)

Explanation / Answer

Yearly Amount to be paid

using PMT function in MS excel

pmt(rate,nper,pv,fv,type) rate = 3% nper = 41 years pv = 0 fv =1000000 type =1

PMT(3%,41,0,1000000,1)

($12,342.14)

Yearly Amount to be paid

using PMT function in MS excel

pmt(rate,nper,pv,fv,type) rate = 3% nper = 41 years pv = 0 fv =1000000 type =1

PMT(3%,41,0,1000000,1)

($12,342.14)

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.