There are a few basic, yet fundamental, real estate modeling skills you must master before anyone will take you seriously as a real estate professional. Building a mortgage amortization schedule is one of them. Virtually every model you create will require this skill – or some variation of what you do when you build an amortization table. […]
We’ve shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions (e.g. All-in-One, Apartment Valuation Model), but none was built for the express purpose of modeling value-add apartment deals. As a result, each has its limitations in value-add scenarios. So today, I’m excited to share a new […]
Since starting A.CRE, Michael and I have fielded email after email requesting a more structured real estate financial modeling training program on the site. Important Note: We’re regularly updating and adding to the Accelerator. Since launch, we’ve made dozens of content updates, added a bonus/optional Advanced Concepts in Real Estate Financial Modeling course, and responded […]
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 […]
In this ‘Day in the Life of a Commercial Real Estate Professional’ post, we hear from an EVP/Asset Manager working at a Family Office in California where this person has been located for the last 2 years. This professional has been kind enough to share what he/she does on a daily basis as well as […]
Over the years, my real estate equity waterfall with annual periods and the option of using either IRR or Equity Multiple Hurdles has been one of the most popular models download at Adventures in CRE. I’ve received dozens of requests for how to improve the model, and so I thought I’d incorporate some of those […]
For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it’s more a generalist tool than a specialized one. As a result, I’ve found it wanting when used to model developments. So a few […]
As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016 I released the first beta-version of the model – my All-in-One (Ai1) Underwriting […]
Several times in the last month, I’ve been asked to tackle an interesting real estate financial modeling challenge – pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw schedule. The real challenge in this exercise, is to have the actual construction draws transition into the […]
In a previous post, I showed you how to use the OFFSET function to create dynamic lists in Excel. As you become more comfortable using this function in real estate financial modeling, you’ll find that it has almost infinite applications when modeling real estate investments. In this tutorial, I share two more ways you might […]
We’ve received numerous requests over the years for a Self Storage Development Model in Excel. With strong investment and development activity in this niche property type, I recognize a self storage model on A.CRE is long overdue. But with so many other projects on our plates and limited experience with self storage, we just hadn’t […]
When I decided to share my real estate equity waterfall model in Excel, I never imagined it would be as popular as it has. The model has been downloaded thousands times and many of you have written to extend your thanks for sharing. It is gratifying to know that the model has been put to […]
A few years back, on a sleep Saturday afternoon while my kids were busy eating Halloween candy, I decided to create a simple real estate acquisition model in Excel for office, retail, and industrial deals. Since then, I’ve made various updates, including error fixes and functional improvements. The model calculates returns at the property and partnership […]
As promised, I’m following up the release of the A.CRE Value-Add Apartment Acquisition 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 […]