Welcome to SpreadsheetZONE, Login or Register

    

Loan Amortisation Schedule Calculator and Planner

+Like us on Facebook
+Like us on Twitter
     
Title:
Loan Amortisation Schedule Calculator and Planner
Author:
smartekits
Downloads:
1039
Rating:
Language:
English


Overview:
With this calculator you can easily generate amortisation schedules. With traditional loan calculators you need to specify the total loan length or number of periods. It then calculates your repayment amount. This calculator is different; it works the other way around. You set your desired repayment amount and it calculates the total time it will take to repay the loan. This way you can easily perform loan modelling and see how the repayment amounts will affect loan duration. Other handy features: - choose weekly, fortnightly or monthly repayment cycle - add any number of extra repayments into the schedule The calculator provides these results: - detailed amortisation schedule - total repayments amount paid - total interest paid - total principal paid (equals original loan amount) - length of time in years it will take to repay the loan
You must sign-in or register to comment on templates