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. […]
When modeling real estate investments, industry practice is generally to stop at before-tax cash flow, rather than after-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily have the exact same tax treatment. So comparing the projected returns […]
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, we’re working to build the world’s largest library of real estate analyst GPTs. A few weeks ago, […]
In recent months, I’ve been working on an advanced real estate investment amortization table with interest-only capability, fixed and variable interest rates, multiple interest calculation methods (i.e. 30/360, Actual/Actual, Actual/365, Actual/360), monthly and annual periods, duration calculation, lender yield calculation, average life calculation, static and dynamic debt service payments, loan assumptions, and more. This module […]
In the fast-moving world of generative AI (gen AI), staying up to date on the latest advancements in AI is crucial for professionals in every field, but especially in commercial real estate. At A.CRE, we’re committed to sharing what we view as the critical developments in AI and their practical applications to CRE. One such […]
Choosing the right commercial real estate attorney is crucial for the success of any real estate transaction. The right attorney can help you navigate the complexities of real estate law, ensure compliance, and protect your interests. Attorneys also play a vital role in drafting, reviewing, and negotiating contracts, conducting due diligence, and providing legal advice […]