Part A:

INSTRUCTIONS: You plan to retire in $30$ years. You can save $$15,000$ a year and have found an RSP investment

that will return $4\mathrm{.}5\%.$ Determine how long will your funds last if you need $$45,000$ a year in today's dollars to live

comfortably from a RIF at earning $3\mathrm{.}2\%.$

Using the yellow cells and changing the data inputs answer the following questions:

How many years would your funds last if you worked for an additional $5$ years?

How many years would your funds last if you double your contribution over $30$ years?

Part B:

INSTRUCTIONS: Determine how many years would your funds last if your RIF earned the rates indicated in the

table using the original data of $30$ years to retirement and $$15,000$ annual contributions.