Entries by Spencer Burton

, ,

All-in-One Walkthrough #7 – Ground Lease Valuation Module

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 […]

, , , , ,

Why I’m REFM Excel for Real Estate Certified

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 […]

, , , , , , , , , , , ,

All-in-One Underwriting Model for Real Estate Development and Acquisition (Updated 6.17.17)

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 […]

,

Using COUNTIFS, SUMIFS, and AVERAGEIFS Excel Functions in Real Estate Underwriting

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. […]

What CRE Professionals Do

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.

, ,

All-in-One Walkthrough #6 – Underwriting a Hypothetical Multifamily Acquisition

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. […]

, ,

Introducing the Adventures in CRE Job Board

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 […]

, ,

All-in-One Walkthrough #5 – The Residual Land Value Calculation Module

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 […]