TransWikia.com

Loan Amortization with first payment period less than others

Personal Finance & Money Asked by Tamuna Kochladze on March 11, 2021

I’m trying to make loan amortization schedule where Interest rate is calculated on the exact period dates. (installment dates taking into account weekends and public holidays) and with the first payment less after than 30 days.
What I have –
Loan Amount 130,550
Interest Rate 8.2%
Tenor 240 month
Disbursement date 10/16/2020
First Payment date 02/11/2020

With General PMT formula I’m getting the 1,108.3 for monthly payments , however the interest is calculated only for 17 days and is equal to 130,550 * 8.2%/365/*(02/11/2020-10/16/2020) as a result in the first payment the principal is amortized more than it should. So my loan is fully amortized at 239 payment. The more interest rate the earlier it is amortized. I tried to shorten the tenor, but it should be at least half to be normal.

this is how my excel is look like
enter image description here
I need to get 240 month amortization and all rounding’s should be corrected at the last payment. Any Ideas?

One Answer

"I need to get 240 month amortization"

The closest with rounding is an instalment amount of 1107.11

There is no reason to make the first payment less; every month carries a different interest charge, so it would be completely arbitrary to make the first payment different.

With days, balance, interest and instalment amount in the columns.

enter image description here

Answered by Chris Degnen on March 11, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP