How to Create an Amortization Schedule in Excel using AI

In this case, all of the calculations from the Additional Principal Paydown worksheet apply, but we’ve modified the scheduled payment calculation. Using our earlier example, the principal paydown in the first month is the difference in the total payment amount of $8,652.67 and the interest payment of $583.33, or $8,069.34. The interest portion of the […]