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.