Question

In: Finance

you make monthly deposits into an account earning 4.1% for 18 years. afterwards, you stop making...

you make monthly deposits into an account earning 4.1% for 18 years. afterwards, you stop making deposits and withdraw $300 at the end of each month for 12 years. what must your monthly deposits be during the first 18 years? round to two decimal places.

Solutions

Expert Solution

Value of $300 withdrawn every year for 12 years (at t=18 years) = Present value of annuity
Present Value of annuity = P[{1-(1+r)^-n}/r]
where P = monthly withdrawl = $300
t = 12 years*12 months =144
r = 4.1%/12=0.3417% or 0.003417
PV of annuity = $300[{1-(1+0.003417)^-144}/0.003417]
= $300[{1-0.6119}/0.003417]
= $300[0.3811/0.003417]
= $300*113.5833
= $                             34,075.0
The future value of annuity of monthly payment at t=18yrs = Present value of annuity of $300 at t=18
Future value of annuity = P[{(1+r)^n}-1]/r
where P = Monthly payment
t = 18yrs812 months=216
r = 4.1%/12=0.3417% or 0.003417
therefore
$34,075 = P[{(1+0.003417)^216}-1]/0.003417
$34,075 = P[{(1.003417)^216}-1]/0.003417
$34,075 = P{2.089268-1}/0.003417
$34,075 = P*318.7791
$34075/318.7791 = P
$106.89 = P
Monthly payment to be deposited today =$106.89
There may be little difference due to decimal places.Please do not downvote on that basis
If you have any doubt,please ask
Please upvote the answer

Related Solutions

You make deposits at the end of each month into an account earning interest at a...
You make deposits at the end of each month into an account earning interest at a rate of 6%/year compounded monthly. Your deposits will be $2000/month in the first year, $2200/month in the second year, $2420/month in the third year, $2662 in the fourth year, and so on. How much will be in your account at the end of 40 years? No Excel answers please.
You plan to make monthly deposits of $1,000 into an account at the beginning of each...
You plan to make monthly deposits of $1,000 into an account at the beginning of each month for the next 12 years. If you can earn 3.0% interest, what will your final balance be by the end of 12 years? Round to the nearest cent. ​[Hint: Beginning of period monthly cash flows!]
You plan to make monthly deposits of $1,000 into an account at the beginning of each...
You plan to make monthly deposits of $1,000 into an account at the beginning of each month for the next 11 years. If you can earn 3.4% interest, what will your final balance be by the end of 11 years? Round to the nearest cent. ​[Hint: Beginning of period monthly cash flows!]
You are planning to make monthly deposits of $120 into a retirement account that pays 9...
You are planning to make monthly deposits of $120 into a retirement account that pays 9 percent annual interest (APR), compounded monthly. If your first deposit will be made one month from now, how large will your retirement account be in 19 years? rev: 09_17_2012 Multiple Choice $71,900.73 $75,495.77 $66,266.58 $68,305.69 $862,808.76
You are planning to make monthly deposits of $170 into a retirement account that pays 8...
You are planning to make monthly deposits of $170 into a retirement account that pays 8 percent interest compounded monthly. If your first deposit will be made one month from now, how large will your retirement account be in 21 years?
You are planning to make monthly deposits of $70 into a retirement account that pays 14...
You are planning to make monthly deposits of $70 into a retirement account that pays 14 percent interest compounded monthly. If your first deposit will be made one month from now, how large will your retirement account be in 22 years? $128,355.75, $1,466,922.82, $116,131.39, $122,243.57, $101,166.24
Ken planned to make monthly deposits in to a saving account at a nominal rate of...
Ken planned to make monthly deposits in to a saving account at a nominal rate of 3% compounded monthly for 180 months. The amount of deposit is k at the end of the k th month, where k = 1, 2, ..., 180. However, he was unemployed for a short period of time, so he missed the 1st through 9th payments. He made the rest of the payments as planned. How much does Ken have in his saving account at...
You put $8,000 in an account earning 5%. After 4 years you make another deposit into...
You put $8,000 in an account earning 5%. After 4 years you make another deposit into the same account. Three years later (that is, 7 years after your original deposit), the account balance is $20,000. What was the amount of the deposit at the end of year 4?
Your client will make twenty quarterly deposits of $5,000 into her retirement account earning 7.3% APR...
Your client will make twenty quarterly deposits of $5,000 into her retirement account earning 7.3% APR compounded daily. If the first deposit is made one quarter from today, how much will be in the account when the last deposited is made?
Suppose an investor plans to make monthly deposits into an account that pays 9% interest, compounded...
Suppose an investor plans to make monthly deposits into an account that pays 9% interest, compounded monthly, so that $100,000 will be in the account immediately after the payment at the end of Year 10. The first payment will occur at the end of Month 1 (one month from the present). How much must be deposited monthly?    A.   $517 per month    B.   $9,670 per month    C.   $6,580 per month    D.   $9,67 per month
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT