Let's evaluate saving money over a 10 year period. We want to have some column headers, so do the following. In cell A1 put the text "Current Savings" (This is our present value). In cell B1 put the text "APR In cell Ct put the text "NPER" In cell D1 put the text "Savings Per Month". In cell E1 put the text "Final Savings. Now below each cell let's put a value. In cell A2 put the value $2000.00 and format the cell as currency with two decimal places. In cell B2 put the value 3 and format the cell as a percentage. In cell C2 put the value 120 for the 10 years of savings each month we will do. In cell D2 put the value $250.00 and format the cell as currency with two decimal places. This is our payment at the end of the payment period. In cell E2 put a future value formula to calculate the total savings at the end of the 10 year period. Now that you have done the calculation for 10 years and verified the number is $32236.65 let's do a goal seek. Using Goal Seek, find the savings per month needed to have 540000.00 at the end of the 10 year period. Record the Goal Seek in a macro with a button to run it