Your company took out an amortizing loan with the following terms: Part 1 Attempt 1/10 for 10pts What is the annual payment on the loan (as a positive number)? Use Excel's PMTO function. Part 2 Attempt 1/10 for 10 pts. Create an amortization table in Excel. What is the outstanding balance at the end of the first year? You just took out a 15-year traditional fixed-rate mortgage for $600,000 to buy a house. The interest rate is 8.4% (APR) and you have to make payments monthly. Part 1 Attempt 1/10 for 10 pts. What is your monthly payment? Part 2 1. Attempt 1/10 for 10 pts. How much of your first monthly payment goes towards paying down the outstanding balance (in \$)? Part 3 - Attempt 1/10 for 10 pts. How much of your 13th monthly payment goes towards paying down the outstanding balance (in \$)? What is the outstanding balance at the end of year 20? Part 4 What is the outstanding balance at the end of year 30