Question

In: Finance

The company you work for will deposit $500 at the end of eachmonth into your...

The company you work for will deposit $500 at the end of each month into your retirement fund. Interest is compounded monthly. You plan to retire 12 years from now and estimate that you will need $3,000 per month out of the account for the next 10 years following your retirement. If the account pays 7.25% compounded monthly, how much (in addition to your company deposit)do you need to put into the account on monthly basis in order to meet your objective?

Solutions

Expert Solution

PV of Annuity:

Annuity is series of cash flows that are deposited at regular intervals for specific period of time. Here cash flows are happened at the end of the period. PV of annuity is current value of cash flows to be received at regular intervals discounted at specified int rate or discount rate to current date.

PV of Annuity = Cash Flow * [ 1 - [(1+r)^-n]] /r
r - Int rate per period
n - No. of periods

Particulars Amount
Cash Flow $            3,000.00
Int Rate 0.6042%
Periods 120

PV of Annuity = Cash Flow * [ 1 - [(1+r)^-n]] /r
= $ 3000 * [ 1 - [(1+0.006)^-120]] /0.006
= $ 3000 * [ 1 - [(1.006)^-120]] /0.006
= $ 3000 * [ 1 - [0.4854]] /0.006
= $ 3000 * [0.5146]] /0.006
= $ 255534.36
Monthly deposit required:

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

Particulars Amount
FV of Annuity $      255,534.36
Int Rate 0.6042%
Periods 144

FV of Annuity = Cash Flow * [ [(1+r)^n ] - 1 ] /r
$255534.36 = Cash Flow * [ [ ( 1 + 0.006 ) ^ 144 ] - 1 ] / 0.006
$255534.36 = Cash Flow * [ [ ( 1.006 ) ^ 144 ] - 1 ] / 0.006
$255534.36 = Cash Flow * [ [ ( 2.3807 ] - 1 ] / 0.006
$255534.36 = Cash Flow * [ 1.3807 ] / 0.006
Cash Flow = $ 255534.36 * 0.006 / 1.3807
Cash Flow = $ 1118.19

Additional deposit = $ 1118.19 - $ 500

= $ 618.19

Additional deposit ( In addition to $ 500) to be made is $ 618.19


Related Solutions

The company you work for will deposit $400 at the end of each month into your...
The company you work for will deposit $400 at the end of each month into your retirement find. Interest is compounded monthly. You plan to retire in 15 years from now and estimate that you will need $2,000 per month out of the account for the next 10 years following your retirement. If the account pays 7.25% compounded monthly, how much do you need to put into the account in addition to your company deposit in order to meet your...
Suppose you deposit $500 in an account at the end of this year, $400 at the...
Suppose you deposit $500 in an account at the end of this year, $400 at the end of next yer, and $300 at the end of the following year. The interest rate is 7.5%. How much will be in the account immediately after the third deposit is made? How much will be in the account at the end of three years if the deposits are made at the beginning of each year? Please show work and proper equation to use.
If you deposit 100, 200, and 500 at the end of periods 2, 4, 6 respectively...
If you deposit 100, 200, and 500 at the end of periods 2, 4, 6 respectively in an account that pays 10% compounded annually during the first two periods, 8% compounded annually in periods 3, 4, and 5, and 12% compounded annually in every period thereafter, how much would you have in the account at the end of period 8? Please provide solution with steps and explanation
(show work) 2 If you deposit $1,000 now and are promised payments of $500 three years...
(show work) 2 If you deposit $1,000 now and are promised payments of $500 three years from now and $1,500 five years from now, the equation that will yield the correct rate of return is:    A)   -1000 = 500(P/F,i,3) + 1500(P/F,i,5)    B)   0 = 1000 + 500(P/F,i,3) + 1500(P/F,i,5)    C)   1000 = -500(P/F,i,3) - 1500(P/F,i,5)    D)   0 = -1000 + 500(P/F,i,3) + 1500(P/F,i,5) 3 For the equation: 5,000 = 1,000(P/F,i,1) - 2,000(P/F,i,2) + 7,000(P/F,i,7) + 7,000(P/F,i,9),...
You deposit $1969.55 in an account today. You will deposit $566.09 at the end of each...
You deposit $1969.55 in an account today. You will deposit $566.09 at the end of each month for the next 12 months and $946.03 each month for the following 13 months. How much interest will you have earned in 25 months if the account pays 5% compounded monthly?
You deposit $1437.46 in an account today. You will deposit $547.45 at the end of each...
You deposit $1437.46 in an account today. You will deposit $547.45 at the end of each month for the next 14 months and $990.78 each month for the following 12 months. How much interest will you have earned in 26 months if the account pays 20% compounded monthly?
You deposit $5,000 into an account at the end of year 0. You deposit $5,000 every...
You deposit $5,000 into an account at the end of year 0. You deposit $5,000 every three (3) months beginning at the end of year 1 and continuing through the end of year 3. You also deposit into the account an amount X starting at the end of year 6 and repeat it every three (3) months for a total of four (4) deposits. You withdraw $112,160 at the end of year 7. After the withdrawal at the end of...
You deposit $500 at the beginning of each month into your saving account every month. After...
You deposit $500 at the beginning of each month into your saving account every month. After five years (60 deposits total), your account value is $50,000. Assuming monthly compounding, what is your monthly rate that the bank provides? a.   1.22% b.   1.14 c.    1.43% d.   1.57%
When you were born, your dear old aunt minnie promised to deposit $500 into a savings...
When you were born, your dear old aunt minnie promised to deposit $500 into a savings account bearing a 5% compounded annual rate on each birthday, beginning with your first. You have just turned 21 and want the dough. However, it turns out that dear old (forgetful) aunt minnie made no deposits on your fifth and eleventh birthdays. How much is in the account right now?
You think that you will be able to deposit $5,500 at the end of each of...
You think that you will be able to deposit $5,500 at the end of each of the next five years in a bank account paying six percent interest. You currently have $4,416 in the account. How much will you have in six years if you make no further deposits? Select one: a. $39,128.43 b. $1,212.00 c. $11,599.01 d. $40,541.65 e. $44,160.25
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT