Question
In: Accounting
Today is your 22nd birthday. You plan to retire on your 60th birthday, immediately after making...
Today is your 22nd birthday. You plan to retire on your 60th birthday, immediately after making your last savings deposit, and begin collecting your retirement payments on your 61st birthday. You decide that your retirement payment will be $80,000 at age 61, growing at 1.5% per year afterwards, and you expect to collect a total of 35 payments. Starting on your 23rd birthday, and on every birthday before you retire, you will make a deposit into your retirement savings account. Your annual savings deposit will be the same every year.
a)What is your annual deposit if you estimate earning an interest rate of 2% during retirement and an interest rate of 3% before retirement?
b)What is your annual deposit if you estimate the interest rate next year will be 0.5% and will increase by 0.065% each year (i.e. two years from now the interest rate will be 0.565%)?
c)You estimate that you will be able to save $6,000 per year. What rate of return will you need to earn before retirement? (assume the interest rate during retirement is 2%)
d)Analyze the results in parts a, b, and c –which of the three scenarios is most “efficient” in terms of the proportion of your retirement funded by interest earned on your savings? Which of the three scenarios do you think is the most realistic in terms of the amounts saved or the interest rate required?
Solutions
Expert Solution
| Forumala for calculating annual deposits to be made if invested at the end of year | |||||
| P = F X I / [{(1 + I)^N} - 1] | |||||
| where, | |||||
| P - Annual deposits | |||||
| F - Retirement Payment | |||||
| I - Rate of return | |||||
| N - Number of deposits | |||||
| Now | |||||
| As per problem, | |||||
| I - 3% | |||||
| N - 38 | |||||
| Payment expected to be recived at age 61 is $80,000 and post retirement return is 2% | |||||
| Therefore, Fund at age of 60 will be = $80,000 / 102 * 100 = $78,431.37 | |||||
| F - $78,431.37 | |||||
| a) | P | = F X I / [{(1 + I)^N} - 1] | |||
| = $78,431.37 X 0.03 / [{(1 + 0.03)^38} - 1] | |||||
| = $78,431.37 X 0.014459 | |||||
| = $1,134.04 | |||||
| I need to make deposits of $1,134.04 every year | |||||
| b) | If rate of interest will be 0.565% at my 24th birthday then | ||||
| I - 0.565% | |||||
| N - (60-23) = 37 | |||||
| P | = F X I / [{(1 + I)^N} - 1] | ||||
| = $78,431.37 X 0.0565 / [{(1 + 0.00565)^37} - 1] | |||||
| = $78,431.37 X 0.024376 | |||||
| = $1911.87 | |||||
| After trail and error method we get that $1,855.87 should be deposited |
| Age | Opening Balance | Amount Invested | Interest | End Balance | ||
| 23 | $ - | $ 1,855.87 | $ 9.28 | $ 1,865.15 | ||
| 24 | $ 1,865.15 | $ 1,855.87 | $ 10.49 | $ 3,731.51 | ||
| 25 | $ 3,731.51 | $ 1,855.87 | $ 21.08 | $ 5,608.46 | ||
| 26 | $ 5,608.46 | $ 1,855.87 | $ 31.69 | $ 7,496.02 | ||
| 27 | $ 7,496.02 | $ 1,855.87 | $ 42.35 | $ 9,394.24 | ||
| 28 | $ 9,394.24 | $ 1,855.87 | $ 53.08 | $ 11,303.19 | ||
| 29 | $ 11,303.19 | $ 1,855.87 | $ 63.86 | $ 13,222.92 | ||
| 30 | $ 13,222.92 | $ 1,855.87 | $ 74.71 | $ 15,153.50 | ||
| 31 | $ 15,153.50 | $ 1,855.87 | $ 85.62 | $ 17,094.99 | ||
| 32 | $ 17,094.99 | $ 1,855.87 | $ 96.59 | $ 19,047.44 | ||
| 33 | $ 19,047.44 | $ 1,855.87 | $ 107.62 | $ 21,010.93 | ||
| 34 | $ 21,010.93 | $ 1,855.87 | $ 118.71 | $ 22,985.51 | ||
| 35 | $ 22,985.51 | $ 1,855.87 | $ 129.87 | $ 24,971.25 | ||
| 36 | $ 24,971.25 | $ 1,855.87 | $ 141.09 | $ 26,968.21 | ||
| 37 | $ 26,968.21 | $ 1,855.87 | $ 152.37 | $ 28,976.45 | ||
| 38 | $ 28,976.45 | $ 1,855.87 | $ 163.72 | $ 30,996.03 | ||
| 39 | $ 30,996.03 | $ 1,855.87 | $ 175.13 | $ 33,027.03 | ||
| 40 | $ 33,027.03 | $ 1,855.87 | $ 186.60 | $ 35,069.51 | ||
| 41 | $ 35,069.51 | $ 1,855.87 | $ 198.14 | $ 37,123.52 | ||
| 42 | $ 37,123.52 | $ 1,855.87 | $ 209.75 | $ 39,189.14 | ||
| 43 | $ 39,189.14 | $ 1,855.87 | $ 221.42 | $ 41,266.42 | ||
| 44 | $ 41,266.42 | $ 1,855.87 | $ 233.16 | $ 43,355.45 | ||
| 45 | $ 43,355.45 | $ 1,855.87 | $ 244.96 | $ 45,456.28 | ||
| 46 | $ 45,456.28 | $ 1,855.87 | $ 256.83 | $ 47,568.98 | ||
| 47 | $ 47,568.98 | $ 1,855.87 | $ 268.76 | $ 49,693.61 |
 ekkarill92 answered 1 year agoRelated SolutionsToday is your 30th birthday and you plan to retire in 30 years when you are...Today is your 30th birthday and you plan to retire in 30 years
when you are 60. You expect to need $75,000 a year in retirement
(the first $75,000 will be paid on your 61st birthday) and expect
to live to be 95. If you assume you can earn a nominal rate of 5.5%
on your investments calculate the amount you will need to save each
year until you retire if you start saving next year on your 31st
birthday....
You are celebrating your 22nd birthday today. You have decided to start investing toward your retirement...You are celebrating your 22nd birthday today. You
have decided to start investing toward your retirement beginning
one month from today. For the first twenty years, you will invest
$500 every month. During the next ten years, you will increase your
contributions to $900 per month. For the remainder of your working
life until you retire at age 67, you plan to invest $1,500 every
month. If your investments earn a rate of return of 8.4 percent
throughout your working...
1a) Today is your 22nd birthday. Suppose you decide to start saving $15,000 annually for retirement,...1a) Today is your 22nd birthday. Suppose you decide to start
saving $15,000 annually for retirement, with the first deposit
being made one year from today. You expect to earn a return of 9
percent per year on this money. Considering that you plan to retire
28 years from today and that you expect to live for 30 years after
retirement, how much can you spend each year after you retire? You
will be able to withdraw your first amount...
Today is your 25th birthday. Your goal is to retire when you turn 70 years old...
Today is your 25th birthday. Your goal is to retire
when you turn 70 years old and have sufficient monthly income until
your expected demise on your 99th birthday. In order to
realize your goal, you are planning to make deposits into a
target-date retirement fund that is expected to generate 7.8%
annual return, compounded monthly. You want to be able to make
monthly withdrawals from this fund starting one month after your
retirement until your expected demise. These monthly...
On your 22nd birthday, you decided to invest $5,000 in a mutual fund that earns 7%...On your 22nd birthday, you decided to invest $5,000
in a mutual fund that earns 7% per year. You continue to make this
deposit every year until you retire at the age of 67. You expect
your salary to increase by an average of 4% each year during the
time and this will increase your annual deposit by 4%. How much
money will you have accumulated in your mutual fund when you
retire?
Suppose you are fresh out of college and plan to immediately start working and retire in...
Suppose you are fresh out of college and plan to immediately
start working and retire in 40 years, after which you plan to live
for another 20 years after retirement. Assuming that the
interest rate from now until the end of retirement will average
about 5% and that your income before retirement will likely be
about $80,000 per year, how much should you save annually between
now and retirement:
If you want to replace about 75% of your pre-retirement income
after...
You just celebrated your 25th birthday today. You plan to invest $2000 annually, with the first...You just celebrated your 25th birthday today. You plan to invest
$2000 annually, with the first $2000 invested on your 26th birthday
and the last invested on your 60th birthday.
What is the value of this investment on your 61st birthday if
all invested funds earn 6 percent annually?
Today is your 25th birthday, and you want to save $2.4 Million by your birthday at...Today is your 25th birthday, and you want to save $2.4 Million
by your birthday at age 70. If you expect to earn 7% APR compounded
monthly in your retirement account, what constant payment at the
end of each month must you deposit into the account through your
70th birthday in order to reach your retirement savings goal on
your 70th birthday? (Answer to the nearest penny.)
Mr. Ambitious is celebrating his 30th birthday today. He plans to retire shortly after his 50th...Mr. Ambitious is celebrating his 30th birthday today.
He plans to retire shortly after his 50th birthday and estimates
that he can live comfortably off a pension of $50,000 per year,
paid annually for 40 years starting with his 51st birthday.
He reckons that in order to achieve this, he only needs to
invest $50,000 into his retirement fund every two years until he
retires.
The first investment will be made on his 32nd birthday and the
last on his...
34. Suppose you are fresh out of college and plan to immediately start working and retire...34. Suppose you are fresh out of college and plan to
immediately start working and retire in 40 years, after which you
plan to live for another 20 years after retirement. Assuming that
the interest rate from now until the end of retirement will average
about 5% and that your income before retirement will likely be
about $80,000 per year, how much should you save annually between
now and retirement:
a. If you want to replace about 75% of your...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|