Thelma and Thomas want to retire with $2,000,000 in their portfolio. They plan on putting away $20,000
Question:
Thelma and Thomas want to retire with $2,000,000 in their portfolio. They plan on putting away $20,000 per year into five different accounts each year ($4,000 per account). They have set up the following accounts and the first contributions will be made at the end of this year. All contributions will be made at the end of each year.
Money Market Account |
Government Bond Mutual Fund |
Large Capital Mutual Fund |
Small Capital Mutual Fund |
Real Estate Trust Fund |
The Money Market grows at 2.5% annually, the Government Bond Mutual Fund grows at 5.5% annually, the Large Capital Mutual Fund grows at 9.5% annually, the Small Capital Mutual Fund grows at 12.0% annually and the Real Estate Trust Fund grows at 4.0% annually.
Required
Calculate the amount that is accumulated under each fund and show the total accumulation after 15 years.
Using a spreadsheet, calculate the end of year balance for the portfolio with the assumption that no additional funds will be deposited into any of these accounts above the $4,000 annual contributions to each account in each year. How long until they reach the $2,000,000 goal?
Personal Financial Planning
ISBN: 9780357438480
15th Edition
Authors: Randy Billingsley, Lawrence J. Gitman, Michael D. Joehnk