For those who have added the Adventures in CRE Job Board (A.CRE Jobs) to your commercial real estate job search process, we have some exciting news! We’d like to announce the launch of the newly completed A.CRE Jobs app for Android and iOS devices. To download the free app, open a browser on your mobile […]
This walkthrough, our seventh in the series, explains how the Ground Lease Valuation Module works and how to implement this tool into your analysis. The All-in-One Model includes two methods to account for a ground lease. The first is to simply include the ground lease payments in the operating expenses (above NOI), thus reducing the value […]
In the unlikely event you’ve visited my LinkedIn page lately or happened upon Bruce Kirsch’s list of REFM Certification Holders, you might have noticed that over the last year I’ve completed my REFM Excel for Real Estate certification. In coming across this obscure fact you might have further wondered – uh, why? I mean, I already have […]
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 Underwriting Tool […]
Why use COUNTIFS, SUMIFS, and AVERAGEIFS functions in real estate? When real estate analysts first start their careers, they’re often required to work with large data sets and to transpose property and portfolio information from one format to another in Excel. At first, being unfamiliar with many of Excel’s functions, they manually perform these operations. […]
A series of posts on what commercial real estate professionals do. These posts cover a variety of job functions including acquisitions, development, asset management, consulting, investment banking, advisory, academia, and much more.
This walkthrough, our sixth in the series, takes you through the entire process of underwriting an apartment acquisition opportunity using the All-in-One Model’s new multifamily module. I’ve created hypothetical assumptions for this exercise written out in PDF format (download link below) and then use those assumptions to assess an appropriate purchase price for this opportunity. […]
Michael and I are excited to announce the release of the Adventures in CRE Job Board. This effort is the culmination of almost of a year’s worth of deliberation, planning, design, and networking effort. And while this is only the beginning (we’re calling this phase our “Early Launch”), we’re nonetheless enthusiastic about the potential for this new […]
This walkthrough, our fifth in the series, explains how the Residual Land Value Calculation module works and how to implement this tool into your analysis. You might recall, a few months back we discussed the concept of residual land value and shared a basic residual land value model. This module expands on the concepts discussed in that […]