Entries by Spencer Burton

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

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

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

, , ,

Bite-Sized CRE Lessons – A.CRE 30 Second Video Tutorials

As we continue to build out our A.CRE 101 series and our Glossary of Commercial Real Estate terms, we’ve started to supplement these initiatives with short (<30 second) video clips on how to do various CRE calculations and modeling tasks in Excel. You can think of these 30 second tutorials as bite-sized lessons in real […]

, , ,

Using the Cash-on-Cash Return in Real Estate Investment Analysis

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

, , , , , ,

Watch Me Build a 3-Tier Real Estate Equity Waterfall Model with IRR Hurdles

As I’ve mentioned in other Watch Me Build posts, one way to become a better real estate financial modeling professional, is to watch other professionals model. Thus, the more exposure you can get to other’s methods, the more adept a real estate professional you will become. This is especially the case with modeling real estate […]

, , , , , , ,

Watch Me Solve a REPE Technical Interview Modeling Test

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

, , , , , , ,

A.CRE 101: How to Build a Mortgage Amortization Table in Excel

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

, ,

A.CRE 101 – Using Dynamic Data Validation Lists in Real Estate Modeling

One Excel feature real estate financial modeling professionals use often is the data validation list. Where data validation is a method of limiting the possible inputs of a cell, the data validation list limits those inputs to a pre-defined list created by the financial modeling professional. In real estate financial modeling, these lists are essential […]

, ,

All-in-One (Ai1) Walkthrough #10 – Underwriting a Value-Add Office Investment

This walkthrough, our tenth in the series, takes you through the entire process of underwriting a hypothetical office value-add opportunity using the All-in-One (Ai1) Model. This walkthrough comes as a response to a question we recently received in the Ai1 Support Forum. Here is the question: We are exploring the route of acquiring a value […]

, ,

Why I Chose a Masters in Real Estate over an MBA

Going back to graduate school is a huge commitment. First there’s the admissions process, which means spending hours and hours studying for the GMAT or GRE, filling out lengthy admissions applications, writing dozens of mindless essays, preparing for and doing informal and formal admissions interviews, and enduring the stress of not knowing if you’re in, or […]