Allow me to share my Industrial Development Model in Excel. Over the past year, I’ve been working to add more specialty real estate models to our library. While our All-in-One model certainly has its place, oftentimes really digging into the underwriting of a deal takes a hyper-focused tool. This model fits the definition of a […]
Pre-2008, I bought and sold my fair share of single family homes – both for investment purposes (rental or flips) and to live in. In those days, almost everyone was “investing” in residential real estate – hence the market crash. I personally don’t have any plans to get back into buying and selling homes, beyond […]
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 […]
Generally speaking, equity real estate investors spend their time modeling the upside while their debt partners spend their time modeling the down side. Equity investors generally focus on an investment’s internal rate of return, cash-on-cash return, equity multiple and other return metrics while debt investors focus on debt coverage, loan to value, debt yield and […]
Several years ago, we published a careers in real estate series where we discussed the various job sectors, business fields, and job functions that exist in the real estate industry. Additionally, we broke down compensation in real estate (salary + bonus) by position and level for 2014. Since then, each year we’ve followed up that […]
As promised, I’m following up the release of the A.CRE Apartment Development model with a series of walk-throughs and tutorials to help you better understand the various elements of the model. The tutorials start with the basics – a guide to getting started, and then get progressively more advanced. If you’ve already visited the model’s […]
In 2018, Michael and I designed and built the A.CRE Accelerator program. We sought to build the preeminent tool for learning and mastering real estate financial modeling. It was intended to provide a clear path to real estate financial modeling mastery, and ultimately give Accelerator Graduates a significant advantage in the industry. Now as we […]
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. […]
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 […]
Over the years, this real estate equity waterfall with annual periods and IRR or Equity Multiple hurdles has been one of the most popular models in our library of real estate Excel models. It’s been downloaded thousands of times and we’ve received dozens of suggestions for how to improve the model. As a result, we […]
Microsoft Excel is the primary tool used by real estate financial modeling professionals. Even while numerous non-Excel alternatives have attempted to de-throne Excel, the 35+ year-old software has shown to be surprisingly resilient to competition. And thus, if you intend to work in real estate you must be proficient in Excel. So what does it […]
Before moving to the principal side of the business, I began my career as a self-described real estate investment specialist, largely working as a land broker but dabbling in other areas including the popular “single-family flip” space. In all honesty, I wasn’t qualified for the title. In fact, I had little to no actual experience […]
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 […]
I originally uploaded this equity/construction loan draw and interest calculation tool to our library of real estate financial analysis models in 2016. Over the years, I’ve continued to update it as suggestions, comments, and requests flowed in from our readers. The model is meant to be used to forecast construction budget cash flows (uses), and then model […]
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 to master real estate financial modeling. In this case study, you play the role of a job candidate interviewing for a Capital Markets Associate role at […]