, , ,

The Real Estate Financial Modeling Accelerator

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

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

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

A.CRE 101: Watch Me 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…
, , , , , , , , ,

Construction Draw Schedule: Accounting For True LTC

When lenders provide debt for a development project, they lend based on a Loan-to-Cost ratio (LTC), which is simply the percent of the total budget the lender will agree to lend to the borrower. So, if a project costs $10MM, and a lender loans…
a large commercial real estate building
, , ,

Refinance Risk Analysis Tool in Excel

Simply put, equity real estate investors spend their time modeling the upside while their debt partners spend their time modeling the down side. Equity investors generally focus on an investment's internal rate of return, cash-on-cash return,…
, , , ,

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…