Posts

Real Estate Financial Modeling Accelerator (Updated Feb 2021)
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.
Over the years, we've covered hundreds of real estate modeling topics in our blog,…

The Advanced Mortgage Amortization Module
In recent months, I've been working on an advanced real estate investment amortization table with interest-only capability, fixed and variable interest rates, multiple interest calculation methods (i.e. 30/360, Actual/Actual, Actual/365, Actual/360),…

Dynamic Amortization Schedule (Updated 2.06.2020)
This is a dynamic amortization schedule for debt 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…

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…

Loan Payment Schedule and Balance Tracking Tool
A childhood friend called me this week and asked for a favor. He is the lender on a private real estate loan and was wanting a way to personally service the loan. Namely, he needed a tool to issue monthly invoices, track the principal vs interest…