A couple is saving for retirement with three different accounts. The table below
ID: 2814920 • Letter: A
Question
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%Explanation / Answer
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.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.