I want to know Monthly Payment, Principal Payment, Total Amount(Yellow parts) just left sides is enough. Can you show me the specific formula of your EXCEL. So, I can compare my data. Thank you.

Loan Repayment 15 Points Write formulas in the yellow cells to determine interest and payment amounts. Use the PMT and PPMT functions we learned in class. Enter formluas in cells B13:C15 Bank Loans Interest Rate (annual rate) Amortization (years) Loan Amount Bank A 3.25% 7 250.000 $ Bank B 6.75% 3 250,000 Function Arguments ? $ PMT Rate 1 = number Monthly Payment =PMT() Principal Payment for the first month Total Amount of Loan to be paid Back Nper 1 = number Pv 1 = number Which loan is better and why? FV 1 = number Type 1 = number Calculates the payment for a loan based on constant payments and a constant interest rate. Rate is the interest rate per period for the loan. For example, use 6%/4 for quarterly payments at 6% APR. Formula result = Help on this function OK Cancel