Complete Debt Schedule Template
Originally published: 27/06/2021 12:27
Publication number: ELQ-58478-1
View all versions & Certificate

Complete Debt Schedule Template

Debt Schedule/ Mortgage Calculator

This is a debt schedule calculation template. The template includes calculations for multiple kinds of the mortgages: constant payment, constant amortization and balloon repayment.

A professional excel tool which can be integrated into your financial model or used to make quick estimates for the cost of a loan.

Use your scenario or compare the scenarios.

Interest only period option is available within each debt schedules.


You are an investor looking for a professional detailed calculation of the loan amortization/ interest payments which you can integrate in your investment process.

A consultant who is looking to present the investment opportunity to clients or investors in a clean and well-designed manner.

A student or starting analyst who wish to learn from the best practices.


Upon download you will receive an unlocked excel file which consists of 3 tabs:
1. Constant payment loan with refinancing option
2. Constant amortization loan with refinancing option
3. Balloon Repayment loan

All financing scenarios include:
- Interest only period;
- LTV based loan amount;
- Flexible loan duration;
- Arrangement and Exit fees;
- Flexible amortization period.

Please feel free to direct message me if you have a question, need support or have an idea for the improvement of this template.

This Best Practice includes
1 Unlocked Excel File

Oksana Babenka offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Professional mortgage calculator
Financing Schedule

Debt calculations which can be integrated into any financial model



  • Be the first to review this Downloadable Best Practice

    Write a review

More Best Practices from Oksana Babenka

See all

Any questions on Complete Debt Schedule Template?

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

0.0 / 5 (0 votes)

please wait...