Amortisation Schedule Excel Template. > who can use the amortization schedule excel templates? On a simple loan amortization schedule excel with moratorium period, finance charges are calculated based on the unpaid principal balance of the contract.

Amortization is calculated using below formula: Depending on the type, you can make payments accordingly on the basis of the compounding interest. Know at a glance your balance and interest payments on any loan with this simple loan calculator in excel.