Nicole has just turned 41 and has accumulated $24 500 in her RRSP. She makes month-end...

Free

80.2K

Verified Solution

Question

Finance

Nicole has just turned 41 and has accumulated $24 500 in herRRSP. She makes month-end contributions of $400 to the plan andintends to do so until she retires at the age of 60. The RRSP willbe allowed to continue to accumulate until she reaches the age of65. If the RRSP earns 6% compounded monthly for the next 24 years,how much will her RRSP contain when she turns 65?

Answer & Explanation Solved by verified expert

4.3 Ratings (683 Votes)


Pv	Current amount in RRSP	$24,500
Rate	Monthly interest rate=(6/12)%	0.50%
Nper	Number of Months Savings tillshe retires	228	(60-41)*12
Pmt	Monthly Savings	$400
FV	Future value of savings at age 60	$245,820.47	(Using FV function of excel with Rate=0.5%, Nper=228, Pmt=-400, Pv=-24500)
	Excel Command: =FV(0.5%,228,-400,-24500)

	Amount Accumulated at age 65
Pv1	Amount Accumulated at age 60	$245,820.47
Rate	Monthly interest rate=(6/12)%	0.50%
Nper1	Number of months=5*12	60
FV1	Accumulated amount at age 65	$331,574.98	(Using FV function of excel with Rate=0.5%, Nper=60, Pv=-245820.47)
	Excel Command:=FV(0.5%,60,,-245820.47)

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

Nicole has just turned 41 and has accumulated $24 500 in herRRSP. She makes month-end contributions of $400 to the plan andintends to do so until she retires at the age of 60. The RRSP willbe allowed to continue to accumulate until she reaches the age of65. If the RRSP earns 6% compounded monthly for the next 24 years,how much will her RRSP contain when she turns 65?

Nicole has just turned 41 and has accumulated $24 500 in her RRSP. She makes month-end...

Free

80.2K

Verified Solution

Question

Finance

Answer & Explanation Solved by verified expert

Get Answers to Unlimited Questions

Membership Benefits:

Transcribed Image Text

Other questions asked by students