A couple is saving for retirement with three different accounts. The table below shows the current balances in their accounts, along with their yearly contribution, and the yearly return on each account. The couple will retire in 24.00 years and pool the money into a savings account that pays 4.00% APR. They plan on living for 29.00 more years and making their yearly withdrawals at the beginning of the year. What will be their yearly withdrawal?
| Account | Balance | Yearly Contribution | APR |
|---|---|---|---|
| Fidelity Mutual Fund | $20,246.00 | $1,000.00 | 6.00% |
| Vanguard Mutual Fund | $182,789.00 | $10,000.00 | 8.00% |
| Employer 401k | $302,262.00 | $15,000.00 | 6.00% |
| PV | PMT | Rate | FV | Formula | |
| Account | Balance | Yearly Contribution | APR | Future value after 24 years | Hint |
| Fidelity Mutual Fund | $20,246.00 | $1,000.00 | 6.00% | $132,790.31 | =FV(6%,24,-1000,-20246) |
| Vanguard Mutual Fund | $182,789.00 | $10,000.00 | 8.00% | $1,826,745.68 | =FV(8%,24,-10000,-182789) |
| Employer 401k | $302,262.00 | $15,000.00 | 6.00% | $1,986,072.74 | =FV(6%,24,-15000,-302262) |
| Total accumulated value | $3,945,608.73 | ||||
| Now this accumulated balance will become PV after 24 years and pension amount will be calculated as follows: | |||||
| Pension amt. | $223,381.91 | Ans | |||
| =PMT(4%,29,-3945608.73,,1) | |||||
| Here | Rate | 4% | |||
| NPER | 29 | ||||
| PV | $3,945,608.73 | ||||
| Note: PV is used as - figure for calculation in financial calculator or excel. | |||||
| 1 is used in the end for annuity due, beginning of year | |||||
| Please feel free to ask for any further issue, thanks. | |||||
Get Answers For Free
Most questions answered within 1 hours.