Posts

, , ,

Real Estate Financial Modeling Accelerator (Updated September 2019)

Since starting A.CRE, Michael and I have fielded email after email requesting a more structured real estate financial modeling training program on the site. Important Note: We're updating and adding to the Accelerator every week. Since launch,…
, , , , , ,

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

(Updated August 7, 2019 to include a Watch Me Build video and Downloadable file)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…
, , , , , , , ,

Watch Me Build a Dynamic 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…
, , , ,

3-Tiered Acquisition Debt Module

This is a 3-tiered debt module that will allow the user to add one to three tiers of debt to his or her real estate DCF model. Includes the option to layer in senior debt, secondary debt, and mezzanine debt; calculate interest on either…
, , ,

Commercial Mortgage Loan Analysis Model

Over the years, I've received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount…
, , ,

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

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