Spreadsheet: 709720d1608522308-help-with-ipmt-formulas-for-advance-payments-on-a-loan-amortization-schedule-loan_amortization-2
Sheet: Example

© www.excel-skills.com.au
[NAME] |  |  | 200000
Annual Interest Rate |  |  | 0.051
Loan Period (in months) |  |  | 24
Original Repayment Amount
Loan Start Date |  |  | 2017-01-01 00:00:00
Repayment Type |  |  | Beginning
Residual Value |  |  | 15000
Month | Cell  Ref | Repayment Number | Opening  Balance | Loan  Repayment | Interest  Charged | Capital  Repaid | Closing  Balance | % Capital  Outstanding |  | Interest  Rate |  | [NAME] |  | ipmt arrears
 |  | 1
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051
 |  |  |  |  |  |  |  |  |  | 0.051