This is a dynamic debt amortization module that gives the user the capability to model a loan with an interest only period up front and an amortizing floating rate debt repayment period once the interest only period is over. This module also allows the user to model other more straightforward scenarios such as an interest only loan and a loan with no interest only period and a fixed interest rate. Along with the download below, there is a video that explains how to use this module and also how the formulas work for those who are interested in learning more about the mechanics.
This module is built to account for a 360-month (30-year) period with an interest only period of the users choosing, a floating rate or fixed rate amortization period of the user’s choosing, and the ability to select a balloon payment date. The module has a place to insert the floating rate debt forecast (row 19) and if you would like to use this module for a fixed interest rate loan, you just need to insert the same interest rate across the entirety row 19.
Additional Learning Component
I also added a second sheet to this model, as mentioned in the video, for those who are less experienced with building amortization tables and want an easy-to-understand model to see how a basic, fixed rate amortization table works. The payment function in this module is a bit more complex due to having to constantly recalculate the payment for floating rate debt, so the second sheet is provided to give a more basic understanding of straight forward amortization schedules.
This module can be inserted into your own model by simply linking the payment line form this module into the debt payment section of your model being careful to properly sync up the dates.
Hope you find the module and video useful.
Download The Model
To make this model accessible to everyone, it is offered on a "Pay What You're Able" basis with no minimum (enter $0 if you'd like) or maximum (your support helps keep the content coming - typical real estate models sell for $100 - $300 each). Just enter a price together with an email address to send the download link to, and then click 'Continue'. If you have any questions about our "Pay What You're Able" program or why we offer our models on this basis, please reach out to either Mike or Spencer.
Note (especially for Gmail users): The model is sent via email and occasionally is blocked by spam filters. If you don't see the email arrive within five minutes, check your spam folder.
Dynamic Amortization Schedule
- Interest only period
- Floating and fixed rate debt
- Amortize a floating rate loan
- Standard interest only loan
- Standard amortizing fixed rate loan
This Excel file (the "software") is distributed as is, completely without warranty or service support. www.AdventuresinCRE.com and its authors are not liable for the condition or performance of the software. www.AdventuresinCRE.com owns the copyright and grants users a perpetual, irrevocable, worldwide, non-exclusive, royalty-free license with respect to the software as set forth below.
www.AdventuresinCRE.com and its authors hereby disclaim all implied warranties. www.AdventuresinCRE.com grants the users the right to modify, copy, and redistribute the software and documentation, both within the user's organization and externally, subject to the following restrictions:
1. The users agree not to charge others for use of the software, regardless of whether users have altered and/or improved the software in anyway.
2. In any use of the software, the users agree to acknowledge the www.AdventuresinCRE.com authors that developed the software.
3. The users agree to obey all government restrictions governing redistribution or export of the software.
4. The users agree to reproduce any copyright notice which appears on the software and documentation on any copy or modification of such made available to others.
About the Author: Michael Belasco has over eight years of real estate and construction experience. He currently works for a global real estate investment, development, and asset management firm in San Francisco managing large scale development projects in the city. Michael has both an MBA and Master in Real Estate with a concentration in Real Estate Finance from Cornell University.