Mortgage Calculator

Creating a Loan Amortization and Interest Only Table in Excel

I put this video together for new real estate syndicators that are curious about some aspects of the financial modeling of a multifamily deal. While this video is not a complete step-by-step guide to real estate financial modeling, it will provide beginners with rudimentary knowledge and understanding of the logic and structure of loan amortization and interest table construction in Excel. Please note this video is not suitable for advanced financial modelers.

Subscribe to our Youtube Channel:

Subscribe to our Podcast at the following links:



Join our Facebook Deal Group, Network, Find a Mentor, Learn, and Get more Deals Done:

Download a FREE Step-by-Step Multifamily Real Estate Market Selection Guide:


Leave a Reply