Question

This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals: - Years until retirement: 30 - Amount to withdraw each year: $90,000 - Years to withdraw in retirement: 30 - Interest rate: 8% Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into her account for her retirement fund. a. If she starts making these deposits in one year and makes her last deposit on the day she retires, what amount must she deposit annually to be able to make the desired withdrawals at retirement? b. Suppose your friend just inherited a large sum of money. Rather than making equal annual payments, she decided to make one lump-sum deposit today to cover her retirement needs. What amount does she have to deposit today? c.Suppose your friend's employer will contribute to the account each year as part of the company's profit sharing plan. In addition, your friend expects a distribution from a family trust several years from now. What amount must she deposit annually now to be able to make the desired withdrawals at retirement? Employer's annual contribution: $1,500 Years until trust fund distribution: 20 Amount of trust fund distribution: $25,000

Answer #1

a) Let's calculate the amount of money she would need to have in the account to fund her retirement using PV function

N = 30, PMT = 90,000, I/Y = 8%, FV = 0 => Compute PV = $1,013,200.50

Now, annual deposit can be calculated using PMT function

N = 30, I/Y = 8%, FV = $1,013,200.50, PV = 0 => Compute PMT = $8,943.96

b) Amount to be deposited today = FV / (1 + r)^n = 1,013,200.50 / (1 + 8%)^30 = $100,689.16

c) Value of trust fund distribution at retirement, FV = PV x (1 + r)^n = 25,000 x (1 + 8%)^10 = $53,973.12

Funds required at retirement = 1,013,200.50 - 53,973.12 = $959,227.38

Now, annual deposit can be calculated using PMT function

N = 30, I/Y = 8%, PV = 0, FV = 959,227.38 => Compute PMT = $8,467.52

But the employer will contribute $1,500 each year. Hence, her annual deposit = $6,967.52

This is a classic retirement problem. Your friend, Mary Jones,
is celebrating her 30th birthday and wants to start
saving for her anticipated retirement. She has the following years
to retirement and retirement spending goals, which are as
follows:
Years until
retirement:
30
Amount to withdraw each year upon
retirement:
$90,000
Years to withdraw in
retirement:
20
Interest
rate:
5%
Mary is planning to make equal annual deposits into her
retirement account, while her first withdrawal will take place one...

Your friend is celebrating her 35th birthday today wants to
start saving for her anticipated retirement at age 65. She wants to
be able to withdraw $105,000 from her savings account on each
birthday for 20 years following her retirement; the first
withdrawal will be on her 66th birthday. Your friend intends to
invest her money in the local credit union, which offer 7 percent
interest per year. She wants to make equal annual payments on each
birthday into the...

Your friend is celebrating her 25th birthday today and wants to
start saving for her anticipated retirement at age 65( she will
retire on her 65th birthday). She woukd like to be able to withdraw
$60,000 from her savings account on each birthday for at least 25
years following her retirement (the first withdrawl will be on her
66th birthday).
Your friend wants to invest her money in the local savings
bank which offers 5.5% per year. She wants to...

Your friend is celebrating her 25th birthday today and wants to
start saving for her anticipated retirement at age 65(she will
retire on her 65th birthday). She would like to be able to withdraw
$60,000 from her saving account on each birthday for at least 25
years following her retirement (the first withdrawl will be on her
66th birthday).
Your friend intends to invest her money in the local savings
bank which offers 5.5% per year. She wants to make...

Your friend is celebrating her 22nd birthday today
and wants to start saving for her anticipated retirement at age 60.
She estimates that the annual spending needs would be $210,000
based on the current price level, and inflation rate is expected to
be 4% per year. She wants to be able to make withdrawal for
spending needs on each year for 24 years following her retirement;
the first withdrawal will be on her 61st birthday. Your
friend intends to invest...

Input
Current age
25
Retirement age
60
Number of years until retirement
35
Annual withdrawal ($)
120,000
Number of years to withdraw
20
Interest rate (%)
6.00%
Employer contribution ($)
5,000
Trust fund distribution ($)
150,000
Age at trust fund distribution
45
Years until distribution
20
Calculation & Output
Present value of withdrawals
Question 4
Annual deposit until retirement
Question 5
Present value in lump sum
Question 6
Value of employer's...

Marie just turned 28 and are now seriously planning for her
retirement. Marie wishes to retire two years earlier than the
mandatory retirement age of 65. She hopes to be able to make
end-of-month withdrawals from her retirement account of $25,000 per
month for a 30-year period after that.
Marie's plan is to fund her retirement by making monthly
deposits between now and when she retires. The initial monthly
deposit will be made at the end of the coming month....

Jennifer decides today, on her 23rd birthday to start saving
towards her retirement so that she would receive on her 63rd
birthday a lump sum of $600,000 using today’s dollars.
a- If she intends to make 160 equal quarterly, end-of-period
deposits, what would be the amount of her quarterly deposits, in
real dollars using today’s dollars? Assume a market interest rate
of 2% per quarter and an inflation rate of 1.5% per quarter.
b- If she intends to make 40...

You wish to save money to provide for retirement. Beginning one
year from now, you will begin depositing a annual fixed amount into
a retirement savings account that will earn 8% annually. You will
make 30 such deposits. Then, one year after making the final
deposit, you will withdraw $100,000 annually for 20 years (no more
deposits). You wish to have $50,000 left in the account after the
20-year retirement period ends (note that this final cash flow has
the...

Your client is 21 years old. She wants to begin saving for
retirement, with the first payment to come one year from now. She
can save $8,000 per year, and you advise her to invest it in the
stock market, which you expect to provide an average return of 11%
in the future.
a. If she follows your advice, how much money will she have at
65? Round your answer to the nearest cent.
$
b. How much will she...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 9 seconds ago

asked 3 minutes ago

asked 6 minutes ago

asked 8 minutes ago

asked 9 minutes ago

asked 9 minutes ago

asked 11 minutes ago

asked 11 minutes ago

asked 12 minutes ago

asked 13 minutes ago

asked 17 minutes ago

asked 17 minutes ago