Complete Debt Schedule Template
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.
WHO IS THIS TEMPLATE FOR?
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.
WHAT ARE THE CONTENTS?
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.
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.
WHO IS THIS TEMPLATE FOR?
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.
WHAT ARE THE CONTENTS?
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.