, , ,

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

Proforma de Construcción de Viviendas Particulares Para Constructores Residenciales

La proforma de construcción de viviendas particulares es una herramienta esencial para constructores residenciales que buscan optimizar sus proyectos y asegurar su viabilidad financiera. Este modelo nos proporciona una visión detallada de…
, , ,

A.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jun 2024)

The A.CRE Geocoding Excel Add-in uses the Google Geocoding API to automatically convert a given address to latitude and longitude coordinates, or to convert a given latitude and longitude coordinate to an address. The add-in makes auto-populating…
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…
, ,

All About Careers in Real Estate Finance and Debt (Updated June 2024)

Real estate debt and finance jobs encompass a wide range of roles and responsibilities, but generally professionals working in this area are responsible for originating, managing, sourcing, and/or assessing debt investments. Roles might include…
, , , , ,

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

Mejora tu Desempeño en Excel con el Complemento “Excel 4 CRE” (Actualizado Junio 2024)

Hoy estamos encantados de compartir con la comunidad A.CRE una nueva herramienta de Excel, que permite mejorar el desempeño de los profesionales inmobiliarios cuando están desarrollando las tareas típicas de modelado financiero ¡Sí, estoy…
, ,

¡Lanzamiento del Complemento “Excel 4 CRE” Completamente en Español! (Actualizado Junio 2024)

Hace aproximadamente un mes colocamos a disposición de nuestros usuarios el complemento “Excel 4 CRE” junto con un tutorial en español de cómo utilizarlo, sin embargo, en aquel momento el complemento seguía estando totalmente en inglés.…
, ,

Valuación Sofisticada de Propiedades — El Desafío de los Datos Respecto a las Tasas de Capitalización de Mercado (Caso de Estudio)

Toda propiedad generadora de ingresos constantes y predecibles, por ejemplo, por renta, puede valorarse utilizando el método de capitalización directa, y cuando un tipo de propiedad no se valúa de esta manera, se presenta una gran oportunidad…
, , ,

Using Generative AI to Outperform Humans at Financial Statement Analysis

Researchers at the University of Chicago recently released the results of an important study that evaluated GPT-4's financial analysis capabilities by predicting future earnings from financial statements. By using Chain-of-Thought (CoT) reasoning,…
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…
, , , ,

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

Modelo de Valoración de Propiedades con Arrendatario Único (NNN – Arrendamiento Tripe Neto) (Actualizado Junio 2024)

Existen un sinfín de oportunidades cuando evaluamos una inversión inmobiliaria, pero si algo es cierto, es que la valoración precisa de propiedades es fundamental para tomar decisiones informadas y estratégicas. Los arrendamientos triples…
, , , , ,

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

Ground Lease Valuation Model (Updated May 2024)

The topic of ground leases has come up several times in the past few weeks. Numerous A.CRE readers have emailed to ask for a purpose-built Ground Lease Valuation Model. And I'm in the process of creating an Advanced Concepts Module for our real…