Posts

, , ,

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,…
, , , , ,

How to Build a Fully Dynamic Mortgage Amortization Table in Excel

We were taught how to build a basic amortization table on day one of my real estate finance graduate studies at Cornell University. Over time, those basic skills expanded to include more complex variations of the same basic idea. I thought…