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 job candidate interviewing for a Capital Markets Associate role and must […]
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 […]
Once a real estate asset is acquired by an acquisitions professional or developed by a development professional, it falls to real estate management jobs to operate the property successfully. This team is made up of property managers, asset managers, and portfolio managers with the help of real estate accountants. Search our list of jobs in asset management […]
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 puts you in the role of a private investor looking to […]
The aggregate value of all commercial real estate holdings in the United States exceeds $5 trillion, with a significant portion owned by large corporations. These companies, while not primarily in the business of real estate investment, rely heavily on their property assets for their core operations. As a result, corporate real estate jobs have become […]
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 […]
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 […]
Recently, we had an Accelerator member ask a question about how to accurately determine a credit rating and spec income discount rate for a private tenant in a single tenant net lease deal. While the scenario specifically involved a medical office tenant (a doctor’s practice), the application could easily be applied to a number of […]
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 […]
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 […]
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 at an international industrial development firm, tasked with assessing the fair value of […]
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, the AI model (i.e. in this case a GPT-4 powered custom GPT) not only was capable of analyzing financial data, but also actually […]
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 two methods, the simpler of the two is the Direct Capitalization method, which this post will cover. The […]
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 passing or spending more time on – investments is crucial to managing an efficient pipeline. Thus, being able […]
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 estate financial modeling Accelerator program covering the mechanics of modeling ground leases. […]