ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculate correct interest on loan when debtor pays late (https://www.excelbanter.com/excel-discussion-misc-queries/24600-calculate-correct-interest-loan-when-debtor-pays-late.html)

O&D

Calculate correct interest on loan when debtor pays late
 
I am carrying a mortgage for someone who purchased property from me. The
problem is that the person paying cannot seem to ever pay on time. I built
the amoritization chart for on time payments, but need the formula for
properly posting the payments, and ensuring that I post the interest and
principal correctly. Sometimes the payments are up to 60 days past due.
Does anyone have this built already or can provide me the concept?


All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com