Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Celine is currently 24 years old and plans to retire on her 64 th Birthday. She anticipates her annual living expenses to be $50,000, inflation-adjusted,

Celine is currently 24 years old and plans to retire on her 64th Birthday. She anticipates her annual living expenses to be $50,000, inflation-adjusted, and her life expectancy is 95. She plans to save a fixed amount every year in an RRSP account to benefit from its tax deferrals. In addition, she plans, while she is working, to invest her money in a broad market, low-fee, indexed fund, with an average rate of return of 10% per year and volatility of 15%. Upon retirement, she plans to move her money to a GIC account with a 3% annual rate of return. She anticipates she needs to pay 15% tax on her retirement withdrawals and the inflation rate is 2% per year.

  1. How much should she contribute to the RRSP account, at the end of each year, so that she would be able to consume the equivalent of $50K, after-tax deductions, at beginning of each year in her retirement? In this part, ignore the risk of the indexed fund and work only with its average return value. (clarification: the first and last deposits to the account are on her 25th and 64th birthdays. The first and last withdrawals are on the first day after her 64th and 94th birthdays).

Your output excel sheet should have at least three columns: Age of your client (from 25 to 94), annual deposit/withdrawal at each year, and the account balance at the end of each year.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Of Capital In Managerial Finance

Authors: Dennis Schlegel

2015th Edition

3319151347, 978-3319151342

More Books

Students also viewed these Finance questions

Question

=+derived from the assignment will balance the costs?

Answered: 1 week ago