CRE Investment Analysis

AllA.CRE 101 | College Education | Special Topics Book Reviews | CRE Terms | Find a Job

All | Investment Analysis | Interesting Deals | Leases | Taxes

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated July 2021)

Prior to launching the Accelerator program, Michael and I 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…
, , ,

Limitations of IRR When Evaluating Real Estate Investments

The internal rate of return is one of the most commonly used return metrics to analyze real estate investment opportunities. Simply put, the IRR is the anticipated, project-determined discount rate an investor is expected to earn over the life…
, , , , ,

The A.CRE Method for Doing Cap Rate Math in Your Head

In this post, I'd like to share a method that, with a little practice, will enable you to quickly do cap rate math in your head; whether it’s quickly figuring out what the sale or purchase price would be of a property based on the NOI and…
, , , ,

Could You Be Exiting Too Early? Don’t Forget to Analyze Your Reinvestment Rate

When attempting to maximize the value of your money invested in real estate, the timing of your exit is key to maximize your return. Exit too early, and you might leave money on the table. Exit too late, and you might have better used that capital…
, , , , , ,

Calculate Residual Land Value in Excel

Here's the scenario. You're a real estate developer. You spot a prime parcel of land that would be perfect for your real estate project. So you approach the owner of the land about selling and she says, "Okay, bring me an offer." How much do…
, , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis

When modeling real estate investments, industry practice is generally to stop at before-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily have…
, ,

How to Quickly Evaluate Real Estate Opportunities (Without Opening Excel)

We regularly respond to questions from A.CRE and Accelerator members as it relates to analyzing and evaluating real estate investment opportunities. Recently, in an Accelerator forum post a young professional marveled at how certain individuals…
, , , ,

Analyzing Value-Add Investments in Real Estate Using Yield-on-Cost

So a question recently came in around why a commercial real estate investor would use the Yield-on-Cost metric to assess a value-add real estate investment. This question came on the heals of several other questions also related to development…
, , ,

Using the Cash-on-Cash Return in Real Estate Investment Analysis

I’ve fielded a handful of Cash-on-Cash (CoC) return questions of late. So, I thought it would be worthwhile to write a post on what the Cash-on-Cash return metric tells me about a potential real estate investment. This article is a primer,…
, , , , , ,

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

Modeling a Property Tax Abatement in Real Estate

We often field questions around how to model property tax abatements. This is a concept we've addressed in our All-in-One forum and a question around valuing property tax abatements came up recently in our A.CRE Accelerator Advanced Concepts…
, , ,

Deep Dive: Understanding Acquisitions: The Letter of Intent (LOI)

The Letter of Intent - Legal Issues The letter of intent is a critical document that is written up at the beginning of a potential real estate transaction between either a prospective buyer and seller or a prospective tenant and landlord.…
, , , ,

Understanding Treatment of Time 0 in the All-in-One Model

I received a very astute question/concern from a user of our All-in-One(Ai1) model in our Ai1 Support Forum late last month. I initially set out to answer the question in writing, but the more I thought about my response, the more I concluded…
, , , ,

All About Cap Ex

In this post, we are going to take a deeper look into capital expenditures. What it is and how we account for it in cre underwriting. Capital expenditures, commonly referred to as Cap Ex, are expenses that occur outside of normal operating…
, , , ,

The A.CRE Method For Doing Cap Rate Mental Math – Practice Tool

At the bottom of this post is a downloadable practice tool for the A.CRE Method for doing cap rate mental math. The tool will generate an endless number of random cap rates and NOIs to practice with and will walk you step by step through how…
, , , ,

A.CRE 101: How To Use The Discounted Cash Flow (DCF) Method To Value Income Producing Property

The Discounted Cash Flow Method is a method to value a project by taking all future projected cash flows of the project and discounting them back to time zero (date of purchase) using a predetermined discount rate (the discount rate when used…