Tag Archive for: case study
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…
Case Study #14 – AIRNYC: Short-Term Rental Acquisition (Case Only)
For our 14th case study, we explore rising investment in short-term rentals with a challenging, real-world acquisition analysis. These case studies are designed to help you practice and perfect your real estate financial modeling skills. This…
Real Estate Case Studies Creator Assistant – Custom GPT by A.CRE (Updated Oct 2024)
If you've spent any time following us here at A.CRE you know that AI applications in real estate financial modeling is a topic we are fascinated (and excited) about! As a consequence, we're underway with several initiatives to explore AI in…
Case Study #13 – “BioMedica” Chain Drugstore – Build-to-Suit Investment in Colombia (Case Only)
In this triple net lease case study, we explore a real-world scenario involving the development of a build-to-suit commercial property for a leading drugstore chain in Colombia. By examining this scenario, you will gain hands-on experience analyzing…
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…
STNL Sales Comp Analysis Tool – Custom GPT by A.CRE
At A.CRE, we've built dozens of custom GPTs for internal and external purposes. Some of the GPTs have general application, while others are custom GPTs specifically for commercial real estate. And among those custom GPTs specifically for CRE,…
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…
Case Study #12 – Maplewood Plaza: Value-Add Retail (Case Only)
For our 12th case study, we offer a challenging opportunity with a value-add retail case study. These case studies are meant to help you practice mastering real estate financial modeling. The Maplewood Plaza case study puts you in the role of…
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…
Case Study #10 – Class A Industrial Warehouse + Rooftop Solar PV Plant (Case + Solution)
This case study explores a development of a 40-acre warehouse in Kasara, near Nashik, India. This industrial case study combines rental income with solar energy initiatives. In this article, we'll examine the financial strategies, including…
Case Study #9 – UK Debt Advisory Firm Modeling Test (Case + Solution, Updated June 2024)
This is the 9th real estate case study in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice mastering real estate financial modeling. In this case study, you play the role of a…
Case Study #8 – Walgreens vs. Walgreens – STNL Investor (Case + Solution, Updated June 2024)
This is the 8th real estate case study in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Walgreens vs. Walgreens - STNL Investor…
Case Study #7 -The Cellon Group – Asset Management Analyst Test (Case + Solution, Updated June 2024)
This is the seventh in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Cellon Group - Real Estate Asset Management Analyst Test…
Case Study #6 – Hamilton Park Phase VIII (Case + Solution, Updated June 2024)
This is the six in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice mastering real estate financial modeling. Hamilton Park VIII puts you in the role of a development associate…
Case Study #5 – The Jefferson Branded Condo Development – Case Only (Updated June 2024)
This is the fifth in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Jefferson Branded Condo Development puts you in the position…
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…