Question: Please help me with completing a savings spreadsheet with using Solver. Attached are the files needed. 1 2 3 4 5 6 7 8 9

 Please help me with completing a savings spreadsheet with using Solver.

Please help me with completing a savings spreadsheet with using Solver. Attached are the files needed.

Attached are the files needed. 1 2 3 4 5 6 7

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 AB C D E F G H College Savings Evaluator Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Starting Balance $ 2,500.00 $ 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 2,919.33 Annual Contribution 4,800.00 $ Withdrawal Return - Ending Balance 8% $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 $2,919.33 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 AB C D E F G H College Savings Evaluator Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Starting Balance $ 2,500.00 $ 2,977.65 9,214.70 16,220.07 24,057.55 32,796.19 42,510.79 53,282.36 65,198.62 78,354.58 92,853.14 108,805.74 126,333.04 142,777.43 160,484.02 179,530.66 200,000.00 185,793.62 170,711.02 128,156.21 82,976.71 61,552.59 Annual Contribution 5,495.20 $ 5,735.20 5,975.20 6,215.20 6,455.20 6,695.20 6,935.20 7,175.20 7,415.20 7,655.20 7,895.20 8,135.20 8,375.20 8,615.20 8,855.20 9,095.20 Withdrawal 25,000.00 25,000.00 50,000.00 50,000.00 25,000.00 25,000.00 Return Ending Balance 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% $2,977.65 $9,214.70 $16,220.07 $24,057.55 $32,796.19 $42,510.79 $53,282.36 $65,198.62 $78,354.58 $92,853.14 $108,805.74 $126,333.04 $142,777.43 $160,484.02 $179,530.66 $200,000.00 $185,793.62 $170,711.02 $128,156.21 $82,976.71 $61,552.59 $38,807.07

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!