80.2K

Verified Solution

Link Copied!

Now create an amortization table that shows your investment balance at the end of each month during your pre-retirement savings period. Your ending balance should be the amount your specify. Your monthly savings is $778.53 what you calculated above You want to accumulate $4,547,300.13 what you calculated above Ending balance from amortization table Cell reference the ending balance on the amortization table. The value should equal the amount you want to accumulate, above. Beginning monthly rate of savings (+) or Amortization schedules Savings months balance return withdrawal (-) Ending balance 125,000.00 225,966.03 326,987.99 4 5 6 7 8 9 11 12 13 14 15 16 17 18 25,000.00 $778.53 $778.53 25,966.03 26,987.99 0.01 0.01 0.02 0.02 0.03 0.04 0.04 0.06 0.07 0.09 0.11 0.14 0.17 0.21 0.27 0.33 Now create an amortization table that shows your investment balance at the end of each month during your pre-retirement savings period. Your ending balance should be the amount your specify. Your monthly savings is $778.53 what you calculated above You want to accumulate $4,547,300.13 what you calculated above Ending balance from amortization table Cell reference the ending balance on the amortization table. The value should equal the amount you want to accumulate, above. Beginning monthly rate of savings (+) or Amortization schedules Savings months balance return withdrawal (-) Ending balance 125,000.00 225,966.03 326,987.99 4 5 6 7 8 9 11 12 13 14 15 16 17 18 25,000.00 $778.53 $778.53 25,966.03 26,987.99 0.01 0.01 0.02 0.02 0.03 0.04 0.04 0.06 0.07 0.09 0.11 0.14 0.17 0.21 0.27 0.33

Answer & Explanation Solved by verified expert

See Answer