Future value of a portfolio. Rachel and Richard want to know when their current portfolio will be sufficient for them to retire. They have the following ! in their portfolio: Money market account: $37,000 Government bond mutual fund: $140,000 Large capital mutual fund: $107.000 Small capital mutual fund: $71,000 Real estate trust fund: 587,000 Rachel and Richard believe they need at least $2,000,000 to retire. They assume the money market account 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 there estate trust fund grows at 4.0% annually. Using a spreadsheet, calculate the end-of-year balance for the portfolio with the assumption that no more funds will be deposited into any of these accounts. How long will it be until they reach the $2,000,000 goal? 6 Given Data Money market account Government bond mutual fund Large capital mutual fund Small capital mutual fund Real estate trust fund Annual growth rate 2.5% 9.5 12.0%