Question

In: Finance

1. John has started a new job and wants to open a retirement account. He is...

1. John has started a new job and wants to open a retirement account. He is now 26 years old and plans to retire if he is over 65. For this, he is considering depositing $ 2815 retirement accounts annually. Annual interest yield is 2%.
a. How much money will he save when he retires? Calculate by drawing a cash flow diagram.
b. If John wanted to save $ 150,000, how much money would he have to deposit into his retirement account annually with equal payments from 26 to 65?
c. In how many years would John have saved $ 45000? (If the result is fractional, leave it that way, do not round it).

Solutions

Expert Solution

FV of Annuity :

Annuity is series of cash flows that are deposited at regular intervals for specific period of time. Here deposits are made at the end of the period. FV of annuity is future value of cash flows deposited at regular intervals grown at specified int rate or Growth rate to future date.

FV of Annuity = CF [ (1+r)^n - 1 ] / r
r - Int rate per period
n - No. of periods

Part A:

Particulars Amount
Cash Flow $            2,815.00
Int Rate 2.000%
Periods 39


FV of Annuity = Cash Flow * [ [ ( 1 + r ) ^ n ] - 1 ] /r
= $ 2815 * [ [ ( 1 + 0.02 ) ^ 39 ] - 1 ] / 0.02
= $ 2815 * [ [ ( 1.02 ) ^ 39 ] - 1 ] / 0.02
= $ 2815 * [ [2.1647] - 1 ] / 0.02
= $ 2815 * [1.1647] /0.02
= $ 163937.83

Part B:

Particulars Amount
FV of Annuity $      150,000.00
Int Rate 2.0000%
Periods 39

FV of Annuity = Cash Flow * [ [(1+r)^n ] - 1 ] /r
$150000 = Cash Flow * [ [ ( 1 + 0.02 ) ^ 39 ] - 1 ] / 0.02
$150000 = Cash Flow * [ [ ( 1.02 ) ^ 39 ] - 1 ] / 0.02
$150000 = Cash Flow * [ [ ( 2.1647 ] - 1 ] / 0.02
$150000 = Cash Flow * [ 1.1647 ] / 0.02
Cash Flow = $ 150000 * 0.02 / 1.1647
Cash Flow = $ 2575.67

Part C:

Particulars Amount
FV of Annuity $      45,000.00
Int Rate 2.0000%
Cash flow 2815

FV of Annuity = Cash Flow * [ [(1+r)^n ] - 1 ] /r
$ 45000 = $ 2815 * [ [ ( 1 + 0.02 ) ^ n ] - 1 ] /0.02
$ 45000 = $ 2815 * [ [ ( 1.02 ) ^ n ] - 1 ] /0.02
[ [ ( 1.02 ) ^ n ] - 1 ] = 0.3197
( 1.02 ) ^ n = 1.3197
Take Log on both sides

Log ( ( 1.02 ) ^ n ) = Log ( 1.3197 )
Log ( a ^ b ) = b * Log ( a )

n * Log (1.02) = Log (1.3197 )
n * 0.0086 = 0.1205
n * 0.0086 = 0.1205
n = 14.0091

It takes 14 Years to be come 45000


Related Solutions

You have just started a new job that offers a retirement savings account. You have two...
You have just started a new job that offers a retirement savings account. You have two options: You can invest 5% of your monthly wages at 2% OR You can invest 4% of your monthly wages at 4%. Both are compounded monthly. b. Assume that you will always make $45,000 annually, how much will you have saved with the better plan after 15 years? c.Assume that you will always make $45,000 annually, how much will you have saved with the...
Allen wants to open a savings account. He will transfer $40,000 from another account to the...
Allen wants to open a savings account. He will transfer $40,000 from another account to the savings account today. After that, he will deposit $1,000 every month to the savings account. If the annual interest rate is 3.2%, what will be the account balance in his savings account after 5 years? a. $112,653.52 b. $123,877.44 c. $123,877.23 d. $111,903.31 how would this be solved using finance functions in excel?
Seamus McIntyre started saving for retirement today by investing $121 in an account earning 0.0835. He...
Seamus McIntyre started saving for retirement today by investing $121 in an account earning 0.0835. He plans to continue with monthly contributions of the same amount for 26 years. The present value of his investment is:
Seamus McIntyre started saving for retirement today by investing $241 in an account earning 0.0888. He...
Seamus McIntyre started saving for retirement today by investing $241 in an account earning 0.0888. He plans to continue with monthly contributions of the same amount for 32 years. The present value of his investment is:
Seamus McIntyre started saving for retirement today by investing $241 in an account earning 0.0419. He...
Seamus McIntyre started saving for retirement today by investing $241 in an account earning 0.0419. He plans to continue with monthly contributions of the same amount for 34 years. The present value of his investment is:
Seamus McIntyre started saving for retirement today by investing $509 in an account earning 0.0855. He...
Seamus McIntyre started saving for retirement today by investing $509 in an account earning 0.0855. He plans to continue with monthly contributions of the same amount for 24 years. The present value of his investment is:
"Seamus McIntyre started saving for retirement today by investing $384 in an account earning 0.0879. He...
"Seamus McIntyre started saving for retirement today by investing $384 in an account earning 0.0879. He plans to continue with monthly contributions of the same amount for 30 years. The present value of his investment is":
Lila Gibbons decides to open a retirement savings account today and she wants to make equal...
Lila Gibbons decides to open a retirement savings account today and she wants to make equal payments every month for the next 9 years. She anticipates she can earn 5.20% on the account which compounds monthly and would like to have $110,000 at the end of the 9 years. To achieve her goals, the payments should be closest to:    A.   $800.87.     B.   $797.42.     C.   $824.50.
John and Peter started their retirement savings at age 21. Since John is a very conservative...
John and Peter started their retirement savings at age 21. Since John is a very conservative person, he chose a very safe mutual fund. However, Peter chose an aggressive mutual fund. They have saved monthly the same amount for 40 years. John earned 10% annual return from his mutual fund but Peter earned 5% annual return from his mutual fund. Choose which one is correct about their account balance when they retired. A) John’s retirement account balance is exactly 50%...
Rocky Jackson, a friend of yours, just started a new job. He is attempting to fill...
Rocky Jackson, a friend of yours, just started a new job. He is attempting to fill out Form W-4 and has asked for your help. He would like to receive a large refund when he files his return and would, therefore, like to claim as few allowances as possible. Even though he is married and has four children, he is planning on claiming no allowances. What would you tell Rocky?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT