Graph illustrating monthly cumulative principal and interest for a home mortgage loan.

Video Overview:

Dynamic Debt Schedule Up to 30 Years With Ability to Model Fixed or Interest Only, Fixed with Interest Only Period, Various Payment Cadence, and Optional Monthly And/Or Annual Prepayments

This debt schedule model is dynamic, easy to use, and can handle complicated debt situations such as fixed/interest-only, fixed with an interest-only period, amortizations up to 30 years, a various number of payments per year, and the ability to model annual and/or monthly prepayments. This model can be used to analyze all different types of debt with a schedule to clearly see the periodic total, interest, and principal payment per month as well as cumulative through the loan term.

The model is organized into the following sections (all formatted to PDF/print) for quick and easy navigation:

– Debt Schedule: This input/output tab is the only place in the model where assumptions are input/selected. The yellow-filled cells with blue text are for user inputs – only type into the yellow fill with blue text cells. The blue-filled cells with blue text are user dropdowns. Please use the dropdowns to make your selection. The model assumptions include:
– General Assumptions: This section contains general model assumptions, such as the loan name, analysis date for version control, the start date of the debt schedule, as well as the currency used in the model.
– Debt Assumptions: This section contains all of the assumptions that drive the debt schedule, including the opening balance of the loan, a selection for mortgage type (amortizing or interest only), the amortization period (select up to 30 years), the number of payments per year, the interest-only period (if applicable), the rate type (fixed or floating), the interest rate, as well as the ability to model monthly and/or annual prepayments.

– Data Validation: This tab contains lists of all data validation used throughout the model.

This model is a great tool for quickly modeling a variety of debt situations that are applicable across all industries.

This model template comes as both .pdf and .xlsx file types, which can be opened using MS Excel and any PDF File Viewer.