Template Preview

Loan Amortization Schedule Template

A free Excel template that generates a complete CRE loan amortization schedule. Enter your loan amount, interest rate, amortization period, interest-only period, and loan term and the template builds the full schedule for you. One tab: loan inputs at the top, a 10-year annual summary, and a monthly breakdown below that.

Free

Loan Information: Loan amount, interest rate, amortization period, interest-only period, and loan term. These five inputs drive the schedule.
Annual Summary: Beginning balance, payment, interest, principal, and ending balance for each of the first 10 years.
Monthly Detail: The same schedule broken out month by month up to the full 120 month term.
Balloon Payment: Calculated automatically based on your loan term, shown on top of the regular amortization paydown.

A note on how we build.

Every tool and template on Model The Deal is intentionally simple. Unnecessary complexity gets in the way of understanding. Every formula is visible and nothing is hidden behind a black box.

We actively encourage you to open the model, follow the logic, and rebuild it yourself. While our goal is to give you a working template that is ready to go, it is also to build your understanding of how these calculations actually work.

This template is provided as-is. For general questions or feedback, please contact us.

Want to test a few loan structures before you commit to one in Excel? Try the Commercial Loan Calculator first, then download this template to build out the full schedule.