, , ,

Real Estate Financial Modeling Accelerator (Updated Nov 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…
SUMIF and Other Excel Functions for Real Estate Analysis
,

Using COUNTIFS, SUMIFS, and AVERAGEIFS Excel Functions in Real Estate Underwriting (Updated Aug 2024)

Why use COUNTIFS, SUMIFS, and AVERAGEIFS functions in real estate? When real estate analysts first start their careers, they're often required to work with large data sets and to transpose property and portfolio information from one format to…
,

El Auge del Mercado de Alquileres Temporales en Latinoamérica: Oportunidades y Perspectivas

En el reciente Gran Salón Inmobiliario 2024, celebrado en Bogotá, Colombia, A.CRE tuvo la oportunidad de participar en uno de los eventos más grandes del año para la industria inmobiliaria colombiana. Este evento reunió a líderes del sector,…
, , ,

Supercharge Excel with the ‘Excel 4 CRE’ Add-In (Updated Aug 2024)

Today, we're thrilled to share with the A.CRE community a new timesaving (and free) Excel tool: the 'Excel 4 CRE' Add-in! Over the past year, we at A.CRE (together with our new favorite companion, ChatGPT!) have been developing and sharing this…
First real estate job
,

Landing Your First Analyst Job in Commercial Real Estate (Updated Aug 2024)

That first job in real estate, most likely at the analyst-level, will be one of the most important jobs - if not the most important job - of your real estate career. Now don't misunderstand me. Failures can be overcome, wrong decisions can…
, , , , , ,

Watch Me Build a 3-Tier Real Estate Equity Waterfall Model (Updated Aug 2024)

As I've mentioned in other Watch Me Build posts, one way to become a better real estate financial modeling professional, is to watch other professionals model. Thus, the more exposure you can get to other's methods, the more adept a real estate…
, , , ,

Modelo de Valuación de Arrendamiento de Terrenos en Excel (Actualizado Agosto 2024)

Después de la publicación del post “¿Vale la Pena Invertir en un Desarrollo Inmobiliario?” pensé en la idea de publicar un nuevo modelo financiero inmobiliario, pero esta vez sentía que A.CRE debía cubrir un área del sector que no…
Real Estate Tokenization
, , ,

Exploring Tokenization in Commercial Real Estate

I have always been interested in developing technology trends, and, in the spirit of exploring future possibilities in our industry, I wanted to discuss a developing trend of tokenization in commercial real estate. If you're not yet familiar…
government real estate
, ,

All About Real Estate Careers in Government and Non-Profit (Updated Aug 2024)

A host of real estate related jobs are available at government and non-profit organizations. Examples of roles in this area might include business development professionals working with local developers and real estate investors to coordinate…
Discounted Cash Flow (DCF) Property
, , , ,

A.CRE 101: How To Use The Discounted Cash Flow (DCF) Method To Value Income Producing Property (Updated Aug 2024)

The Discounted Cash Flow Method is a method to value a project by taking all future projected cash flows of the project and discounting them back to time zero (date of purchase) using a predetermined discount rate (the discount rate when used…
, ,

¡La Experiencia de A.CRE en el Gran Salón Inmobiliario de Bogotá 2024!

Del 8 al 11 de Agosto del presente año, se llevó a cabo “El Gran Salón Inmobiliario” en la ciudad de Bogotá, Colombia, organizado por Corferias y la Lonja de Bogotá. El evento inmobiliario contó con la participación de prestigiosas…
, , , , , , ,

How to Run Monte Carlo Simulations in Excel (Updated Aug 2024)

So you want to run Monte Carlo simulations in Excel, but your project isn't large enough or you don't do this type of probabilistic analysis enough to warrant buying an expensive add-in. Well, you've come to the right place. Excel's built-in…
Through The Entitlement Process
, , , , ,

Through The Entitlement Process: Identifying Risks and Strategies For Mitigation (Updated Aug 2024)

Investing in and developing an unentitled site, broadly speaking, is one of the riskiest, yet rewarding, endeavors in the commercial real estate industry. The entitlement process, in particular, is fraught with the potential for setbacks and…
, , , , ,

Análisis de Retención-Venta en Bienes Raíces Comerciales

En el curso 3 de nuestro Acelerador de modelos financieros inmobiliarios de A.CRE, utilizamos un caso práctico que gira en torno a un escenario de análisis de retención-venta de una propiedad (es decir, mantener frente a vender) para enseñar…
, , ,

Análisis de una Inversión Inmobiliaria desde la Perspectiva de un Socio Limitado (LP)

¿Qué es un socio limitado en los bienes raíces comerciales? En el ámbito de los bienes raíces comerciales, un socio limitado es una persona o entidad que invierte capital en un proyecto inmobiliario sin participar en su gestión diaria.…
, , , ,

Loan Payment Schedule and Balance Tracking Tool (Updated Aug 2024)

A childhood friend called me this week and asked for a favor. He is the lender on a private real estate loan and was wanting a way to personally service the loan. Namely, he needed a tool to issue monthly invoices, track the principal vs interest…