• The couple currently has $7,350 in their savings account. Each month, the couple will take money out of their savings account or deposit money into their savings account. In row 41, calculate the end-of-month balance in their savings account. In the first month, the end-of-month balance is calculated by adding the value in cell E5 to the Net Cash Flow value in row 38. For the remaining months, the end-of-month balance in their savings account is equal to the previous month's end-of-month balance plus the current month's Net Cash Flow value.
• In cell E6, enter a formula to display the value of the savings balance at the end of December.
• Thomas and Alison would like to have $15,000 in their savings account by the end of the year. Alison is planning to ask for a raise at her job. Determine the new value of Alisons monthly salary that will achieve a final savings balance of $15,000 (Hint: Use the What-If analysis, goal seek dont click OK, write down the answer and click cancel). Enter the correct answer you've received after using goal seek in cell I6.