Loan Amortisation table in excel

loan amount 115,000.000

origonal intrest rate(APR) 6%

loan term(months) 360

PMT ?

JX =B1 A D $ E F Loan Amount 2 Original Interest Rate (APR) 3 Loan Term (Months) 4 PMT B 115,000.00 6% 360.00 $6,440.00 5 6 Original Loan Amortisation Table: 7 8 9 Beginning Principal 115,000.00 PMT Interest Principal deductiorEnding Principal 10 11 Month 1 2 3 4 5 12 13 14 15 6 7 16 8 17