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

3-Tiered Acquisition Debt Module

This is a debt module that will allow the user to add one to three tiers of debt to his or her DCF model. This excel file should be fairly intuitive and easy to understand and the entire model is on one sheet. Download it from the link below…
,

30/360, Actual/365, and Actual/360 - How Lenders Calculate Interest on CRE Loans – Some Important Insights

Commercial real estate lenders commonly calculate loans in three ways: 30/360, Actual/365 (aka 365/365), and Actual/360 (aka 365/360). Real estate professionals should be aware of these methods if they want to understand the real interest…
, , , ,

Real Estate Debt Module in Excel

I thought I'd share the real estate debt module I built for the ARGUS alternative in Excel that I've been working on over the last few months. Most debt modules I've seen in real estate financial models only include the ability to model…
, , ,

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…