Posts

A.CRE 101: How to Build a Mortgage Amortization Table in Excel
There are a few basic, yet fundamental, real estate modeling skills you must master before anyone will take you seriously as a real estate professional. Building a mortgage amortization schedule is one of them. Virtually every model you create…

Dynamic Amortization Schedule
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…

Advanced Real Estate Amortization Table
Here is a more advanced real estate investment amortization table with interest-only capability, multiple interest calculation methods (360/30, 365/Actual, 360/Actual), monthly and annual periods, duration calculation, lender yield calculation,…