## Total Flexibility in your Payment Schedules

Completely adapt a payment schedule to your borrower’s needs and real life such as irregular payments, seasonal cashflow, interest-only, principal-only, partial, late, unpaid payments, lump sum, automatic fees, negative balances in intercompany loans, interest rate changes, residual value…

## Margill Law/Standard Edition – Regular and Irregular payment schedule

Question:

I was wondering who I could contact at Margill for help on calculating a rather complex amortization table.

Beginning on 6/25/17 – the principal loan amount was \$640,000 at an interest rate of 3% – payments of \$3,000 to begin on 1/1/2018.

• However, a payment of \$350,000 was made on 7/12/2017

Actually quite simple:

Go to “Recurring Payments” calculation. We will suppose this is compound interest, compounded monthly and monthly payments since it is a loan.

Let’s suppose 20 payments of \$3000 each (if payments are missing or if there are too many, you can add or delete after).

Enter the data below:

Then Compute or F5.

This is our preliminary schedule:

You can now edit the schedule by adding the lump sum payment and extra principal.

The payment and extra principal were made in 2017 so I should add three lines above my payment date of 2018-01-01

I can do this with this icon or the right mouse click: