This form is a sample letter in Word format covering the subject matter of the title of the form.
This form is a sample letter in Word format covering the subject matter of the title of the form.
The formula to be used will be =IPMT( 5%/12, 1, 60, 50000). In the example above: As the payments are made monthly, it was necessary to convert the annual interest rate of 5% into a monthly rate (=5%/12), and the number of periods from years to months (=512).
You can ask your lender for an amortization schedule, but this might not be as helpful if you're looking to see how extra payments could impact that schedule.