Question

You are currently 24. Based on your calculations, you will need $120,000 of income each year once you retire. You plan on retiring at age 65, and want to have enough money in your account so that you can draw payments out for 25 years (with the first payment taking place immediately upon your 65th birthday). Assume that all your funds earn an 11% annual return. You will begin making payments into your retirement account immediately and will make 41 payments into the account. How much must you invest each year in order to make your retirement goal? Now, assume that all other facts stay the same, but that your start with a balance of $10,000 in your account. Now what should your annual payments be?

Answer #1

Fund required facilitating cash out flow of $ 120,000 per year at the beginning of year for 25 years can be calculated using formula for present value of annuity due as:

PV (at the time of retirement) = P + P x
[1-(1+r)^{-(n-1)}/r]

P = Periodic payment = $ 120,000

r = rate per period = 11 % or 0.11 p.a.

n = number of periods = 25

PV = $ 120,000 + $ 120,000 x
[1-(1+0.11)^{-(25-1)}/0.11]

= $ 120,000 + $ 120,000 x
[1-(1.11)^{-(24)}/0.11]

= $ 120,000 + $ 120,000 x [(1-0.081704976)/0.11]

= $ 120,000 + $ 120,000 x (0.918295024/0.11)

= $ 120,000 + $ 120,000 x 8.348136578

= $ 120,000 + $ 1,001,776.3893 = $ 1,121,776.39

Future value of 41 number of immediate payment is $ 1,121,776.39.

Periodic payment can be calculated using formula for future value of annuity due as:

FV = (1 + r) x P x [(1+r) ^{n} – 1/r]

P = Periodic payment

r = rate per period = 11 % or 0.11 p.a.

n = number of periods = 41

$ 1,121,776.39 = (1 + 0.11) x P x [(1+0.11)^{41} –
1/0.11]

$ 1,121,776.39 = 1.11 x P x [(1.11)^{41} – 1/0.11]

$ 1,121,776.39 = 1.11 x P x [(72.15096271 – 1)/0.11]

$ 1,121,776.39 = 1.11 x P x (71.15096271/0.11)

$ 1,121,776.39 = 1.11 x P x 646.8269337

P = $ 1,121,776.39/ (1.11 x 646.8269337)

P = $ 1,121,776.39/717.9778964

P = $ 1,562.410758 or **$ 1,562.41**

$ 1,562.41 must be invested each year to achieve retirement goal.

Suppose you have $ 10,000 in your account.

So Future value of $ 10,000 after 41 years @ 11% compounding yearly is:

FV = $ 10,000 x (1+0.11)^{41}

= $ 10,000 x (1.11)^{41}

= $ 10,000 x 72.15096271 = $ 721,509.63

Required fund at the time of retirement = $ 1,121,776.39 - $ 721,509.63 = $ 400,266.76

Again applying the formula for future value of annuity due, we get cash flow as:

FV = (1 + r) x P x [(1+r) ^{n} – 1/r]

$ 400,266.76 = (1 + 0.11) x P x [(1+0.11)^{41} –
1/0.11]

$ 400,266.76 = 1.11 x P x [(1.11)^{41} – 1/0.11]

$ 400,266.76 = 1.11 x P x [(72.15096271 – 1)/0.11]

$ 400,266.76 = 1.11 x P x (71.15096271/0.11)

$ 400,266.76 = 1.11 x P x 646.8269337

P = $ 400,266.76/ (1.11 x 646.8269337)

P = $ 400,266.76/717.9778964 = $ 557.49176 or **$
557.49**

$ 557.49 need to invest each year to get retirement goal if there is balance of $ 10,000 in the account.

Assume you make annual contributions to a Roth IRA of $1,250
per year beginning on your 25th birthday. Assume further
that the account is projected to earn an annual return of 7.15% and
that you will retire on your 65th birthday. What is the
projected balance in the account on the date of your retirement?
Assume no contribution on your 65th birthday. In other
words, the last contribution occurs at the beginning of the
40th year, on your 64th birthday....

Assume that you are 24 years old today, and that you are
planning on retiring at age 65. Your salary is expected to increase
at a rate of 5% per year as long as you work. To save for your
retirement, you plan on making annual contributions to a retirement
account. Your first contribution will be made on your
25th birthday and will be 10% of your salary of $50,000
at that time. You plan to put aside 10% of...

Today is your 25th birthday. You have
decided that it is necessary to plan your own retirement since you
are not confident that government benefits will be available when
you retire. You will make annual payments into an
account earning 5% APY starting on your next birthday
(26th) a year from now. Your last payment
will occur on your 70th birthday. You have
decided that you need to plan for payments of $500,000 per year and
that there will be a total of 20...

Can you Solve it in Excel Please
Today is your 25th birthday. You have
decided that it is necessary to plan your own retirement since you
are not confident that government benefits will be available when
you retire. You will make annual payments into an
account earning 5% APY starting on your next birthday
(26th) a year from now. Your last payment
will occur on your 70th birthday. You have
decided that you need to plan for payments of $500,000 per year and
that...

Today is your 40th birthday (this is beginning of period, i.e.,
time 0). You expect to retire at age 65 and actuarial tables
suggest that you will live to be 85. You want to move to Hawaii
when you retire (on your 65th birthday). You estimate that it will
cost you $50,000 to make the move on your 65th birthday. Starting
on your 65th birthday and ending on your 84th birthday (all
withdrawals are at the beginning of the year),...

Jessica plans to retire on her 65th birthday. But she plans to work
part time until she turns 70. During these years of part-time work
she will neither make deposits to nor make withdrawals from her
retirement account. Exactly one year after the day she turns 70
after retiring she will begin to make annual withdrawal of $117,281
from her account until she turns 89. After this final draw she
wants $1.44 million remaining in her account. She will make...

A) Derek plans to retire on his 65th birthday. However, he plans
to work part-time until he turns 72.00. During these years of
part-time work, he will neither make deposits to nor take
withdrawals from his retirement account. Exactly one year after the
day he turns 72.0 when he fully retires, he will begin to make
annual withdrawals of $120,165.00 from his retirement account until
he turns 94.00. He he will make contributions to his retirement
account from his 26th...

Today is your 40th birthday. You expect to retire at age 65, and
actuarial tables suggest that you will live to be 100. You want to
move to Hawaii when you retire. You estimate that it will cost you
$200,000 to make the move (on your 65th birthday). Starting on your
65th birthday and ending on your 99th birthday, your annual living
expenses will be $25,000 a year. You expect to earn an annual
return of 7% on your savings. ...

You turned 35 today and have begun to think about saving for
retirement. You anticipate that you will retire at age 67 (on your
birthday), and will need $120,000 a year for 20 years, with the
first withdrawal occurring from the retirement account occurring on
your 67th birthday, and the last withdrawal occurring on your 86th
birthday.
a) If you begin to make monthly payments into your retirement
account today (on your 35th birthday), with the last payment into
the...

You are 40 years old and want to retire at age 60. Each year,
starting one year from now, you will deposit an equal amount into
a savings account that pays 7% interest. The last deposit will be
on your 60th birthday. On your 60th birthday you will switch the
accumulated savings into a safer bank account that pays only 3.5%
interest. You will withdraw your annual income of $120,000 at the
end of that year (on your 61st birthday)...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 5 minutes ago

asked 5 minutes ago

asked 22 minutes ago

asked 23 minutes ago

asked 24 minutes ago

asked 27 minutes ago

asked 33 minutes ago

asked 35 minutes ago

asked 35 minutes ago

asked 47 minutes ago

asked 56 minutes ago

asked 59 minutes ago