, , ,

Real Estate Financial Modeling Accelerator (Updated June 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…
, ,

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

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

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

Mixed-Use Development Model: Condo and Retail (Updated Jun 2024)

In this post, I walk you through the A.CRE Mixed Use Development Model for Condo and Retail projects. The model is basically a reworked and expanded version of the Condo Development Model, so if you are familiar with that, this should feel and…
, , , , ,

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

Case Study #4 – The Stones Hotel Acquisition – Case Only (Updated May 2024)

This case study on hotel acquisition is the fourth in a series shared by A.CRE, designed to enhance your skills in real estate financial modeling. In this scenario, you take on the role of an associate at a prominent firm specializing in debt…
, ,

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

All About Careers in Real Estate Acquisitions (Updated May 2024)

In acquisitions jobs, professionals typically source, analyze, conduct due diligence on, and negotiate the purchase of new equity investments for their real estate investment firms. It's important to note that acquisitions professionals generally…
, , , ,

Entry-Level Position in Real Estate: Breaking Through the No Experience Barrier

Recruiting for an entry-level position in real estate can be daunting, particularly for those entering this highly competitive field where experience is often prized above all. How does one 'break through' when traditional pathways seem blocked…
, , , , ,

Real Estate Debt Module in Excel (Updated May 2024)

I thought I'd share the real estate debt module I originally built for the ARGUS alternative in Excel. Most debt modules I've seen in real estate financial models only include the ability to model fully amortizing senior debt. Mike challenged…