Entries by Spencer Burton

, , , , , , , , , ,

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, I’ve never just grabbed an actual technical interview case study and walked our readers through how I […]

, , , , ,

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, let alone how the various capital sources work together to get a real estate deal done. In […]

, ,

All About Careers in Real Estate Consulting

Real estate consulting jobs include work in a variety of areas such as appraisal and valuation, entitlement services, portfolio strategy, enterprise M&S, workplace strategy, location footprint strategy, site acquisition and analysis, among others. Professionals who take positions at real estate consulting firms typically possess expertise in a specialized area of real estate for which they’re hired […]

, , , , , , ,

Hold-Sell Analysis in Real Estate (Updated June 2024)

In course 3 of our A.CRE Accelerator, we use a case study that revolves around a hold-sell (i.e. hold vs sell) analysis scenario to teach the anatomy of the real estate DCF. In that scenario, the student is an asset manager working for an open-end core fund. The fund is trying to determine whether it […]

, , , , ,

Land Development Model – Multi-Scenario (Updated Jun 2024)

Over the years, we’ve shared eight development-focused real estate financial models and numerous development-specific tools to the A.CRE Library of Excel Models. Nevertheless, there’s been a hole in the development offerings in our library. The library has been missing a model to analyze general land development scenarios, such as master-planned residential and commercial developer opportunities […]

, , ,

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 puts you in the role of a analyst candidate seeking a real estate asset […]

, , ,

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 latitude and longitude (or address) in Excel easy. It includes various features to help add or change the […]

, ,

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 originating new senior, secondary, and mezzanine debt; servicing existing loans; and seeking out financing for one’s own equity investments. Search our list […]