Question: I only need answers for 5 and 6 please... also show what formulas you use to solve. Thank you. Sierra Pacific Community College District Finance


I only need answers for 5 and 6 please... also show what formulas you use to solve. Thank you.
Sierra Pacific Community College District Finance Office Student Loan Amortization Loan Amount 15,000.00 Loan Term Rate Payment Total Interest $ Total Principal Total Cost $0.00 4.00% $3,369.41 A53 over the life of the loan. Pmt Balance Interest Principal Total Payment Balance Using cell C8 and the payment calculated in ()enter a formula to calculate total principal paid over the life of the loan. Enter a formula calculating total principal and interest paid over the life of the loan. Using the datacalculated above, enter formulas or cell references for each column. Using the fill handle, copy the formulas throughout the table. Hint: At payment #60, your ending balance should be so. Your beginning balance should be last payment's ending balance (6)Enter a formula to total the Interest, Principal and Total Payment columns. Check that these 10 totals agree to your totals in cells FS, F6 and F7 12 13 14 15 16 17 18 19 20 21 21 23 24 25 26 27 28 29 31 32
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
