, , ,

Real Estate Financial Modeling Accelerator (Updated Nov 2024)

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…
Discounted Cash Flow (DCF) Property
, , , ,

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

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

How to Run Monte Carlo Simulations in Excel (Updated Aug 2024)

So you want to run Monte Carlo simulations in Excel, but your project isn't large enough or you don't do this type of probabilistic analysis enough to warrant buying an expensive add-in. Well, you've come to the right place. Excel's built-in…
Through The Entitlement Process
, , , , ,

Through The Entitlement Process: Identifying Risks and Strategies For Mitigation (Updated Aug 2024)

Investing in and developing an unentitled site, broadly speaking, is one of the riskiest, yet rewarding, endeavors in the commercial real estate industry. The entitlement process, in particular, is fraught with the potential for setbacks and…
, , , ,

Analyzing Value-Add Investments in Real Estate Using Yield-on-Cost (Updated Aug 2024)

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…
SUMPRODUCT Weighted Average
, ,

Using SUMPRODUCT to Calculate Weighted Average in Real Estate (Updated Aug 2024)

In my experience, using the SUMPRODUCT function in Excel to calculate weighted average is one of the most oft-used Excel techniques in real estate financial modeling. I learned this technique on day one of my first real estate internship and…
Using the Cash-on-Cash Return in Real Estate Investment Analysis
, , ,

Using the Cash-on-Cash Return in Real Estate Investment Analysis (Updated Aug 2024)

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

LinkedIn Job Search 101 for CRE Professionals (Updated Aug 2024)

Our goal with this post is to help you use LinkedIn most effectively in your job search. It's the first post in a series of a LinkedIn 101 networking series to help you get the most out of this resource. Because commercial real estate is such…
UNDERWRITING CAPITAL RESERVES
, , ,

The Road To A Stabilized NOI – Underwriting Real Estate Capital Reserves (Case Study – Case Only)

Achieving a stabilized Net Operating Income (NOI) in real estate requires careful planning and sound execution. One element that can cause confusion is when underwriting capital reserves. Should they go above the line (i.e., as an Operating…
, ,

Analyzing a Real Estate Investment from the Perspective of an LP

We received a question from an A.CRE reader this week that I thought warranted a thorough response. The question was, and I paraphrase, "I am an LP looking for models to help vet syndication deals. Do you have any models that can be used to…
, ,

Tips to Nail Your Next Commercial Real Estate Interview (Updated July 2024)

Recently, our team partnered with the Graduate Real Estate Council at Cornell University where we worked with their students in providing mock interviews with Cornell alumni. Our goal in this effort was to help these students at the beginning…
Loan Debt Yield Calculation
, , ,

How to Use Debt Yield to Calculate Loan Amount (Updated July 2024)

In our glossary of commercial real estate terms, we recently answered the question: what is debt yield? As a follow up to that entry, I thought I’d expand on the concept of debt yield by showing you how lenders use debt yield to come up with…
, , , , , , , , , ,

Watch Me Solve a REPE Technical Interview Modeling Test (Updated July 2024)

What better way to spend some free time over the Thanksgiving holiday, than to record myself completing a real estate private equity technical interview exercise! While I've offered help with the real estate technical interview in the past,…
Desk for with Computer for IPMT & PPMT Excel Functions
, , , ,

An Overview Of IPMT and PPMT Excel Functions – Uses And Drawbacks (Model + Case Study)

We recently received an intriguing question in the Q&A section of the A.CRE Real Estate Financial Modeling Accelerator regarding the uses of the IPMT and PPMT Excel functions. As such, I’d like to take the opportunity to discuss it. First…
real estate private equity
, , , , ,

Deep Dive – Sources of Capital: Real Estate Private Equity (Updated July 2024)

Capital for commercial real estate investments is generally sourced from one or more of the following buckets: public equity, public debt, private equity, or private debt. In my experience, few people fully understand these four buckets of capital,…
, ,

Understanding Low-Income Housing Tax Credit (LIHTC) Investments

In this article, we explore Low-Income Housing Tax Credit (LIHTC) investments, a key component in the affordable housing sector. Established to encourage private investment, the LIHTC program offers tax credits to developers for creating and…