Exercise 1: The example exercise is to work through a loan amortization example using Excel. Open Activity 3- Workbook. Go to the Exercise 1 worksheet. The example loan conditions are (enter these values under _): 1) 2) Loan amount borrowed (principal or pv) $100,000 Loan interest (rate) is 7.5% Loan term (number of payments or nper) is 9 years Annual payments of principal and interest Calculate the annual loan payment in cell C7 using the PMT function in Excel. The PMT function is in the formulas under the Financial menu option. In the PMT Menu box, the Rate is the interest rate, Nper is the number of payments or term, and PV is the principal amount borrowed (enter this as a negative value). FV and Type should be blank or you can enter 0. Use your mouse and use the cell reference to enter the required entries. Write the needed formulas in the given to calculate the interest payment and the principal payment for each period payment. 15', Interest Payment: Calculate the interest payment as follows: Interest payment = period interest rate * the outstanding loan balance. Start from Pmt Num 1 and use the loan balance of the previous period. You need to use absolute and relative cell addresses to accomplish this task! 2nd, Principle Payment: When you make payments on a loan, part of your payment goes for interest on the loan and part goes to pay back the loan (principle). Subtract the Interest Payment from the Annual Loan payment (i.e., principal and interest that you calculated using PMT) to calculate the amount paid on principal. 3rd, Loan Balance: Subtract the principal payment from the previous period outstanding balance. In each period, the loan balance is whatever loan balance was left from the previous payment minus principle payment. (Note: Loan Balance in period 0 is the amount borrowed)