How to Adjust an Amortization Table for a Missed Payment

Step 1

Check the loan agreement for the implications of a missed payment. Not only does a missed payment lengthen the total amount of time required to pay back a loan, it may also trigger fees and interest rate increases. Confirm these repercussions with your lender.

Step 2

Add the amount of the missed payment, plus any fees, to the outstanding principal amount from the previous payment period. This is new outstanding principal, less any increased interest. If the software you use for your amortization schedule does all of the calculations for you, you may skip this step.

Step 3

Make the adjustments on your amortization table. You will need to update the principal, if your software does not make this computation for you. If it does, you can simply plug in “0” for the missed payment, and allow the software to update the principal accordingly. You should also update the interest rate if it increased after the missed payment. Software program setups vary, but you should change this information in the part of the spreadsheet that allows you to enter the basic terms of your loan. Use your spreadsheet’s “calculate” function to generate a new amortization table that accounts for the missed payment.