Time Value of Money
Not what you're looking for?
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?
Purchase this Solution
Solution Summary
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.
Solution Preview
Please refer attached file for better understanding of formulas in MS Excel.
a)
Present deposit in her account=PV=$12,500
Periodic deposit=PMT=500
Number of periods=NPER=12*20=240 months
Interest rate=RATE=8%/12=0.67% per month
Amount ...
Education
- BEng (Hons) , Birla Institute of Technology and Science, India
- MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
- "Thank you"
- "Really great step by step solution"
- "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
- "Thanks Again! This is totally a great service!"
- "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Operations Management
This quiz tests a student's knowledge about Operations Management
Introduction to Finance
This quiz test introductory finance topics.
Basics of corporate finance
These questions will test you on your knowledge of finance.