Please also show my the formula's you use to solve the problems, thank you.

Sierra Pacific Community College District Finance Office Student Loan Amortization TAB INSTRUCTIONS: 15,000.00 Total Interest Total Princi Total Cost Enter a PMTfunction Loan Amount Loan Term Rate Hint: Formulas tab, Financial 4,00% Use the following resourceto review each of the variables in the PMT fu 12) using cell C8 and the payment calculated in (1, enter a formula to calculate total loan interest 10 over the life of the loan. Beginning Balance 12 13 Interest Total Payment Using cell C3 and the payment calculated in (1), enter a formula to calculate total principal paid over the life of the loan. 15 (4) Enter a formula calculating total principal and interest paid over the life ofthe loan