Exercise 1 (15 points). The example exercise is to work through a loan amortization example using Excel. Open Computer exercise 4-Workbook. Go to the Exercise 1 worksheet The example loan conditions are (enter these values under Loan Temm 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 Grading for Loan Terms table: 1 point for Borrowed, Rate, and Term. 1) 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. (3 points) 2) Write the needed formulas in the Loan Amortiz able given to calculate the interest payment and the principal payment for each period payment. (3 points for Interest Payment column, 3 points for Principle Payment column, 2 points for Loan Balance column) 1", Interest Payment: Calculate the interest payment as follows: Interest payment - period interest rate * the outstanding loan balance. Start from Pint Num 1 and use the loan balance of the previous period. You need to use absolute and relative cell addresses to accomplish this task! 2ad, 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) 42, copy and paste the formulas for the remaining 8 payments