Real Estate Education

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

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated Jan 2025)

Before launching the Accelerator program, Michael and I received countless emails requesting a more structured, step-by-step real estate financial modeling training program. Over the years, we've covered hundreds of real estate modeling…
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…
Development Spread
, , , ,

Using Development Spread in Real Estate Analysis (Updated Jun 2024)

Real estate developments carry inherent risks, making them one of the most challenging investment opportunities. However, the potential for profit can justify the risks involved. Have you ever wondered how to assess the profit potential…
, ,

Mastering Return Metrics for Strategic Real Estate Investment Decisions

Return metrics are some of the key components for assessing commercial real estate investments. They give professionals an insight into the potential gains and risks associated with various properties. But which return metrics are most useful…
, , , , ,

Underwriting a Tenant with Private Credit (Updated June 2024)

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…
Dallas Case Study real estate market trend analysis
, ,

From Data to Decisions: Analyzing Real Estate Trends to Forecast Market Growth

Real estate market trend analysis is crucial for experienced professionals to identify up-and-coming neighborhoods. On a gut level, driving the streets of a community and engaging with residents, even for just an hour or two, can provide a clear…
IRR and XIRR are different
, , , , ,

Why Your IRR and XIRR are Different (Updated June 2024)

This post was inspired by a question on our real estate financial modeling Accelerator forum. Additionally, Spencer and I frequently get emails asking about this very issue, which is 'why the IRR (internal rate of return) and XIRR (extended…
, , , , ,

A.CRE 101: How to Use the Income Capitalization Approach to Value Income-Producing Property (Updated May 2024)

In commercial real estate, there are a few generally accepted methods for appraising (or valuing) real property. The three most common are the Cost Approach, the Sales Comparison Method, and the Income Approach. The Income Approach includes…
, , , , ,

Quick Thoughts on Evaluating Real Estate Investments Without Opening Excel

In our industry (commercial real estate), the ability to quickly evaluate investment opportunities is crucial for staying competitive. I know I've found in my professional career, that having a clear framework for evaluating - and then either…
after-tax cash flow analysis
, , , , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2024)

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

How to Hire Your Next Commercial Real Estate Attorney

Choosing the right commercial real estate attorney is crucial for the success of any real estate transaction. The right attorney can help you navigate the complexities of real estate law, ensure compliance, and protect your interests. Attorneys…
, , ,

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

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…