In my experience, using the SUMPRODUCT function in Excel to calculate weighted average is one of the most oft-used Excel techniques in real estate financial modeling. I learned this technique on day one of my first real estate internship and I continue to use it at least once a week to this day. So in […]
I’ve fielded a handful of Cash-on-Cash (CoC) return questions of late. So, I thought it would be worthwhile to write a post on what the Cash-on-Cash return metric tells me about a potential real estate investment. This article is a primer, if you will, on when this metric is helpful to use in your analysis […]
Over the years, Michael and I have built and shared numerous real estate equity waterfall models, all multi-tiered and most with internal rate of return (IRR) hurdles. And as our readers have downloaded those models, I’ve received dozens of requests for an equity waterfall model with a simpler partnership structure. This model seeks to be an […]
We received a question from an A.CRE reader this week that I thought warranted a thorough response. The question was, and I paraphrase, “I am an LP looking for models to help vet syndication deals. Do you have any models that can be used to evaluate a deal from the perspective of an LP, as […]
We recently shared a new modeling test to our library of real estate case studies entitled UK Debt Advisory Firm Modeling Test. In that case study, the test asked the real estate professional to analyze the returns of three different debt options. Two of those debt options include a type of mortgage called a linear […]
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 months ago, […]
In our glossary of commercial real estate terms, we recently answered the question: what is debt yield? As a follow up to that entry, I thought I’d expand on the concept of debt yield by showing you how lenders use debt yield to come up with the appropriate mortgage loan amount. Lenders and Sensitivity to Loan […]
Some of you are working to land that first professional job in real estate. Others are hoping to leverage existing education and industry experience to move up. Regardless of where you are, the content, format, and style of your real estate resume is essential to success. In this post, I’ll discuss what makes real estate different from other […]
For our 12th case study, we offer a challenging opportunity with a value-add retail case study. These case studies are meant to help you practice mastering real estate financial modeling. The Maplewood Plaza case study puts you in the role of an Acquisition Analyst at Legacy Retail Partners, a family office based in Milwaukee, WI. […]
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 […]
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 […]
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 […]