Multiple Debt Calculator Model
Originally published: 14/09/2020 08:21
Last version published: 25/01/2021 08:51
Publication number: ELQ-44324-4
View all versions & Certificate
certified

Multiple Debt Calculator Model

Calculate your debt schedule for all of your loans at once

Description
Key features:
1) Multiple loans at once
2) Dynamic model
3) Pre-payment calculation
4) Different maturity options (up to 10 years)

If you run a business, you must have surely came across a scenario when you have multiple loans, and some times it is difficult to track all these loans. Furthermore, you need to decide which loan to pay first to save interest out go.

This model will help you track all of your loans at once. It allows you to track interest payment and principal payments done (or to be done) for each month and up to ten years.

Model is highly flexible, it allows you to enter loans start date (and date, I meant 'any date'), interest rate, and loan maturity period (choose from as low as 6 months to up to 10 years).

It is not just normal loan calculator, it also allows you to enter pre-payment date and model will fetch the amount payable for that particular pre payment date.

I know, it might not capture all the scenarios, but I have tried to capture as much as I can. Definitely you can reach out to me for further suggestions and I will promise to update the next version.

This Best Practice includes
1 Excel template

AZ Finserv offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Amir Ganic(last updated: 22/01/2021 12:34)
  • Diana Bianu(last updated: 05/12/2020 13:45)
  • gangadhar s(last updated: 13/10/2020 03:05)

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Multiple Debt Calculator Model?

The user community and author are here to help. Go ahead!


5.0 / 5 (3 votes)

please wait...