Final Prob. 1) Repayment of a loan requires the periodic payment of interest and principal. You are interested in the amount of principal you pay in the 60th period of a loan. A. We can use the PPMT(rate, per, nper px [f], [type]) function for this purpose. Assume the following parameters for the loan and PPMT function: rate = 2.75% (annual rate--don't forget to divide by 12 in PPMT function to match monthly input data--per nder) per = 60th month neer = 360 month pv = $200,000 (Hint: Your principal in the 60th period should be $409.94 for the data above). B. Create a two-way data table, using the Table function for the calculation of the principal payment for the 75th period for a variety of annual interest rates (rate=2.75% to 5.25%, 0.5% increments as row value) and present values of the loan (pv=200,000 to 350,000, in 25,000 increments as colurn value). Format results such that you have 2 decimals (123.45). C. Create a two-way data table, using absolute and relative references for the calculation of the principal payment for the 60th period for a variety of annual interest rates (rate-3.50 to 6.00%, 0.5% Increments as row value) and present values of the loan (pv=200,000 to 350,000, in 25,000 increments as column value). Format results such that you have 2 decimals (123.45) A. rates pere nper pv PPMT-> 0.0023 60 360 200000 ($409.94)