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 Nov 2022)

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…
a shopping center with robust sales and low occupancy cost
, , , , , , ,

Tenant Sales and Occupancy Cost in Retail Underwriting (UPDATED JUNE 2022)

When underwriting a retail investment, rollover risk is an incredibly important consideration. You, as a prospective debt or equity investor in the property, need to understand how secure the cash flows you're buying are; or in other words,…
, , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis (UPDATED MAY 2022)

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

Using Geometric Mean (or CAGR) as an Alternative to IRR

The internal rate of return (IRR) and compound annual growth rate (CAGR) are both metrics used to analyze investment returns. They're both commonly used in commercial real estate financial modeling, but what's the difference? When should you…
, , , , , , , , ,

Construction Draw Schedule: Accounting For True LTC (Updated Apr 2022)

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

Underwriting a Tenant with Private Credit

Recently, we had an Accelerator member ask a question about how to accurately determine a credit rating and spec income discount rate for a private tenant in a single tenant net lease deal. While the scenario specifically involved a medical…
, , ,

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

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 Accelerator 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.…