Real Estate Financial Modeling Accelerator (Updated October 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…
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…
Linear Mortgage Payment Schedule Tool (Updated July 2024)
We recently shared a new modeling test to our library of real estate case studies entitled UK Debt Advisory Firm Modeling Test. In that case study, the test asked the real estate professional to analyze the returns of three different debt options.…
Proforma de Alquiler de Vivienda Unifamiliar
Desde mi experiencia como economista y analista financiero en A.CRE, he observado cómo el mercado de alquiler de viviendas particulares ha ganado popularidad, especialmente en América Latina. En este contexto, es esencial contar con herramientas…
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…
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,…
Three LinkedIn Tips for Success in Real Estate
In the competitive world of commercial real estate, having a strong LinkedIn presence is essential. LinkedIn serves as a powerful tool for networking, job searching, and showcasing your professional achievements. It allows professionals to connect…
Una Visión General de las Funciones PAGOINT y PAGOPRIN de Excel – Usos y Desventajas (Modelo + Caso de Estudio)
Recientemente, recibimos una pregunta muy interesante en el “Q&A (Preguntas y Respuestas)” del Acelerador de Modelos Financieros Inmobiliarios de A.CRE, dicha pregunta estaba relacionada con el uso de las funciones PAGOINT Y PAGOPRIN…
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…
The Real Estate Resume – Tips and Resources (Updated July 2024)
Some of you are working to land that first professional job in real estate. Others are hoping to leverage existing education and industry experience to move up. Regardless of where you are, the content, format, and style of your real estate…
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,…
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…
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…
Guía para Evaluar el Crédito en la Suscripción de Propiedades con Inquilinos Privados
Recientemente, un miembro de nuestro programa -Acelerador- nos planteó una pregunta sobre cómo determinar con precisión una calificación crediticia y una tasa de descuento de ingresos especulativos para un inquilino privado en un acuerdo…