This assignment must be done using excel functions. Your final presentation may be in excel or as a word document. But you must hand in your excel spreadsheet. You must label what you are doing and show all excel spread sheets that you used. The inputs into the excel functions must be clearly labeled with no abbreviations and contain the correct units using the $ and % symbols. You must answer every question with a sentence. Nate Sudfield is buying a $875,000 house. He is taking out a 30 year mortgage at an annual interest rate of 3.15%. 1. Because he doesnt have a lot of job security, the bank is requiring a 25% down payment. How much is his down payment? 2. The bank requires 2 points at closing, how much is this? 3. Determine Nates monthly payment. 4. Determine the total interest paid over the life of the loan. 5. How much did Nate pay for his house? 6. Create an amortization table for the first two months. You must show your work.