Integrated Excel Problem 15-4 (Static) Daniel and Jan agreed to pay $560,000 for a four-bedroom colonial home in Waltham, Massachusetts, with a $60,000 down paymen They have a 30 -year mortgage at a fixed rate of 6.00%. Required: Please use the above information and the provided Amortization Chart to answer the below questions: (Use Table 15-1) 1. What is the principal (loan)? 2. How many total payments on this mortgage? 3. How much is their monthly payment? 4. How much of the first monthly payment is going towards interest? 5. How much of the first monthly payment is going towards principal? 6. After the first payment, what would be the balance of the principal? Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect