How do I create a loan payment schedule in Excel?
Loan Amortization ScheduleUse the PPMT function to calculate the principal part of the payment.Use the IPMT function to calculate the interest part of the payment.Update the balance.Select the range A7:E7 (first payment) and drag it down one row.Select the range A8:E8 (second payment) and drag it do...