Ashley Cambry is planning for her retirement. She already has $12,500 in a retirement plan and will deposit $500 a month for the next 20 years. Her account manger says she will be earning 8.00% on an annual basis on this account at the time of retirement and Ashley plans to withdraw a sum each month during her 15 retirement years and then leave $120,000 to the College at the end of 15 ears to furnish a student lounge. During retirement her account will be earning a 6.00% return on an annual basis.
a. How much will Ashley be able to withdraw each month during retirement?
b. Instead of 6.00% what would Ashley's rate-of-return after retirement have to be so that she could withdraw $3,500 a month and still leave the same amount for the student lounge?© BrainMass Inc. brainmass.com October 17, 2018, 3:54 am ad1c9bdddf
Please refer attached file for better understanding of formulas in MS Excel.
Present deposit in her account=PV=$12,500
Number of periods=NPER=12*20=240 months
Interest rate=RATE=8%/12=0.67% per month
Solution describes the steps to calculate the monthly amount that Ashley can withdraw in the given case. It also calculates the rate of return that will enable Ashley to withdraw $3500 per month.
Calculations of the Time Value of Money
1) You invest $20,000 today, at a rate of 10% compound quarterly. What will the investment be worth at the end of year twenty?
2) You are offered an annuity that will pay you $9,000 at the end of each of the next 10 years. What is the maximum amount you would be willing to pay today for this annuity? (Assume you require a 15% rate of return on an investment of this nature.)
3) You have $15,000 to put down on a new house that cost $200,000, and you have been quoted the following finance terms by your local banker: 6% Annual Percentage Rate, for 30 years. If you decide to purchase this home, what will your monthly payment be? Additionally, over the life of the loan what would your total interest expense be?
4) You want to start saving for your child's education. You project that your child will need $170,000 to attend school 15 years from now. If you can earn a rate of return of 10% compounded semi-annually on a given investment, what dollar amount will you need to invest today to ensure your child can attend college?
5) Steaks Galore has $190,000 in excess cash that it wishes to invest. Bank One offers a certificate of deposit that is paying 10%, compounded monthly. Bank Two offers a certificate of deposit paying 9.5%, compounded daily. In which Bank should the firm opt to invest its' surplus cash? (You must use the EAR formula to solve this problem. In addition, you must show all of your work.) Additionally, what is the nominal and period rate of interest offered by Bank One?
6) You plan on depositing $3,000 in an account at the end of each of the next 5 years. If the account is paying interest at an annual rate of 10% per year, what will the total value of your investment be at the end of the 10th year?
7) Your Life Insurance Agent is trying to sell you an investment that will pay you $5,000 a year forever. If your required rate of return is 11% on an investment of this nature, what would you be willing to pay your agent today for this investment opportunity?
8) It is forecasted that you will receive the following cash inflows at the end of the next four years: Year 1 $1,000, Year 2 $2,000, Year 3 $4,000 and Year 4 $1,000. If upon receipt of these cash inflows, you can re-invest the amounts received at a rate of 10%, what will the total future value of this investment be?
9) While Bob Jones was a student at Tiffin University, he borrowed $43,063 in student loans at an annual rate of 7 percent. If Bob repays $500 per month, how long, to the nearest year, will it take him to repay the loan?
10) Company XYZ plans to invest $5 million to clear a tract of land and to set out some young trees. These trees will mature in 12 years, at which time XYZ plans to sell all the trees at an expected price of $10 million. What is XYZ's expected rate of return? In addition, given this rate of return, would you recommend that XYZ proceed with the plan? Why or why not.