, , ,

Real Estate Financial Modeling Accelerator (Updated Apr 2020)

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 updating and adding to the Accelerator every week. Since launch,…
, , , , , , , , ,

Watch Me Build a Tenant Rollover Analysis Model

The feedback has been positive on the ‘Watch Me Build a Multifamily Model’ video I recorded earlier this year. So I thought I’d follow that up with another. This time I build a Real Estate Tenant Rollover Analysis Model and talk through…
,

University of North Carolina - Undergraduate Real Estate Profile

The Kenan-Flagler Business School undergraduate Real Estate concentration and Leonard W. Wood Center for Real Estate Studies Program as a whole has not only allowed me to receive educational and professional resources needed to break into…
, , , , , , , ,

Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020)

One way to become a better real estate financial modeling professional, is to watch other professionals model. I know in my career being able to physically see how others tackle different modeling problems has shaped my methods and made me better…
,

University of Southern California - Undergraduate Real Estate Profile

Growing up in Los Angeles and in a real estate family, I was exposed to the real estate industry from a young age. With this background, I knew I wanted to pursue a career in real estate. When it came time to start thinking about a college…
bite-sized real estate tutorials
, , ,

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…
,

University of California-Berkeley - Undergraduate Real Estate Profile

U.C. Berkeley has a wonderful real estate community with members from all colleges on campus, expert faculty, and a plethora of extracurricular opportunities. I came into Berkeley as a pre-med student and fell in love with real estate through…
, ,

Create Dynamic Sub-Property Type Drop-Down Menus in Excel

A few years ago, I created a tutorial on building smart drop-down menus in Excel using dynamic named ranges and data validation lists. This offered a great way to have drop-down menus in your model that could be easily changed by the user to…
vintage Walgreens on corner of two busy california streets
, , , , , , , , ,

Single Tenant NNN Lease Valuation Model (Updated Feb 2020)

I originally built this single tenant net lease (NNN) valuation Excel model back in 2016. Based on some feedback from a few of our readers, I've since made quite a few updates (see v2.0 updates video below). This model is an attempt to re-think…
, , , , ,

Watch Me Build Data Tables For Real Estate Sensitivity Analysis

This is a 3 part mini-series on using data tables in Excel to perform real estate sensitivity analysis. In this series, I'll walk you through how to build both one-variable and two-variable data tables in parts 1 and 2. And in Part 3, I'll walk…
, , , , , ,

Watch Me Build A Construction Draw Schedule (Updated Jan 2020)

In the following video, I record my screen and narrative my steps as I build a basic construction draw schedule. I've also included the template and completed worksheets from this Watch Me Build exercise. Basic Construction Financing &…
,

University of Wisconsin-Madison - Undergraduate Real Estate Profile

Perspectives on the University of Wisconsin-Madison Real Estate Undergraduate Degree The Real Estate and Urban Land Economics major in the Wisconsin School of Business promotes a well-rounded and in-depth learning experience for its students.…
,

Cornell University - Undergraduate Real Estate Profile

Before coming to Cornell University to pursue an undergraduate degree in Hotel Administration, I was somewhat aware of the real estate educational opportunities offered in the Hotel School, but did not expect they would play such a significant…