Question

In: Accounting

8. I deposit $3,000 per month (at the end of each month) over the next 15...

8. I deposit $3,000 per month (at the end of each month) over the next 15 years. My investments earn 0.6 percent per month. I would like to have $1 million in 15 years. How much money should I deposit now?

Solutions

Expert Solution

Step-1:Calculation of future value of monthly deposit of $ 3,000
Future Value of monthly deposit = Monthly deposit*Future Value of annuity of 1
= $                3,000 * 322.532
= $    9,67,596.05
Working:
Future Value of annuity of 1 = (((1+i)^n)-1)/i Where,
= (((1+0.006)^180)-1)/0.006 i 0.60% =         0.006
= 322.532 n 15*12 = 180
Step-2:Calculation of Balance amount needed in 15 Years
Total amount needed in 15 years = $ 10,00,000.00
Future Value of monthly deposit = $    9,67,596.05
Balance amount needed further $       32,403.95
Step-3:Calculation of Amount to be deposited now
Present Value = Future Value *Present value of 1
= $       32,403.95 *    0.34069
= $       11,039.81
Working:
Present Value of 1 = (1+0.006)^-180
= 0.34069
Thus,
Amount should be deposited now $ 11,039.81

Related Solutions

You will deposit $80 at the end of each month for 15 years into an account...
You will deposit $80 at the end of each month for 15 years into an account with annual interest rate 3% compounded monthly, and then withdraw equal amounts at the end of each month for the following 25 years, ending with a zero balance. What will your monthly withdrawals be?
deposit $10,000 per year into an account at the end of each of the next 4...
deposit $10,000 per year into an account at the end of each of the next 4 years, and $15,000 into the account each year for the following 6 years. How much money will you have in the account at the end of the 10th year? Assume that we earn 10 percent nominal interest compounded annually on our investments. A. $76,319.18 B. $197,972.30 C. $130,000.00 D. $89,174.29 E. Something Else
A loan is to be repaid over 30 years, with month-end repayments of 3,000. If the...
A loan is to be repaid over 30 years, with month-end repayments of 3,000. If the interest rate is 6.5% p.a. compounded monthly. Calculate the principal paid for year 10. Correct your answer to the nearest cent without any units. (Do not use "$" or "," in your answer. e.g. 12345.67)  
A: You deposit $100 for the next 15 years earning 10% per year. What would your balance be at the end of the 15 Years?
Please show work and formulas: A: You deposit $100 for the next 15 years earning 10% per year. What would your balance be at the end of the 15 Years? B: You borrow $100,000 for 18 years at an annual rate of 7%. What would be your fixed QUARTERLY loan payment? C: For the loan in #5 above, what percent of your first payment would apply to the principal?
If you deposit $4,800 at the end of each of the next 20 yearsinto an...
If you deposit $4,800 at the end of each of the next 20 years into an account paying 10.8 percent interest, how much money will you have in the account in 20 years? (Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.)  Future value$   How much will you have if you make deposits for 40 years?(Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.)  Future value$   
If you deposit $5,000 at the end of each of the next 20 years into an...
If you deposit $5,000 at the end of each of the next 20 years into an account paying 10.8 percent interest, how much money will you have in the account in 20 years? How much will you have if you make deposits for 40 years? Show Work.
If you deposit $9127 at the end of each of the next 28 years into an...
If you deposit $9127 at the end of each of the next 28 years into an account paying 7.6 percent interest, how much money will you have in the account in 28 years? (Round time value factors to 6 decimal places and final answer to the nearest dollar amount. Omit the "$" sign and commas in your response. For example, $123,456 should be entered as 123456.)
Alexandra plans to deposit $1,000 into a fund at the end of each of the next...
Alexandra plans to deposit $1,000 into a fund at the end of each of the next eight years. If her fund earns 4.75 percent compounded annually, how much will she have at the end of eight years? A. $8,340 B. $8,525 C. $8,856 D. $9,297 E. $9,464 Randolph will receive a 20-year annuity with annual payments of $150. The first payment will be received at the end of Year 1, and the last payment will be received at the end...
If you deposit $5,900 at the end of each of the next 20 years into an...
If you deposit $5,900 at the end of each of the next 20 years into an account paying 10.8 percent interest, how much money will you have in the account in 20 years?
Derek can deposit $266.00 per month for the next 10 years into an account at Bank A. The first deposit will be made next month. Bank A pays 12.00%
Derek can deposit $266.00 per month for the next 10 years into an account at Bank A. The first deposit will be made next month. Bank A pays 12.00% and compounds interest monthly. Derek can deposit $2,572.00 per year for the next 10 years into an account at Bank B. The first deposit will be made next year. Bank B compounds interest annually. What rate must Bank B pay for Derek to have the same amount in both accounts after...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT