You are considering purchasing a new home with a price of $156,500. From the sale of a previous home and your savings, you plan on a down payment of $30,000. Directions: Create a worksheet similar to the one below to calculate your monthly house payment (not including any taxes). 1. Calculating an Affordable House Payment Insert house clip art here Selling Price Down Payment Interest Rate $ 156,500 $ 30,000 $ 156,500 $ 30,000 Length of Monthly Total Total Loan in Years Payment Principal Interest 30 15 2. Research local mortgage rates to perform the calculations; find a fair rate for a 15-year and a 30-year mortgage and include them in your worksheet. Use a function to calculate the monthly house payment. Assume you decide that, if you take the 30-year mortgage, you cannot afford a monthly payment higher than $550. Use Goal 3. 4. Snel to determine how much of a down navmont would be 3. a 4. Use a function to calculate the monthly house payment. Assume you decide that, if you take the 30-year mortgage, you cannot afford a monthly payment higher than $550. Use Goal Seek to determine how much of a down payment would be necessary to bring the house payment down to $550. Assume you decide that, if you take the 15-year mortgage, you cannot afford a monthly payment higher than $800. Use Goal 5. 6. Seek to determine how low the interest rate must be to bring the house payment down to $800. Apply formatting of your choice to the worksheet. Add a header to the worksheet that includes your name in the center. Save the worksheet as EL2-U2-SA1-HousePayment with the 7. . 8