, , ,

Real Estate Financial Modeling Accelerator (Updated Jun 2022)

Prior to launching the Accelerator program, Michael and I fielded email after email requesting a more structured real estate financial modeling training program on the site. Over the years, we've covered hundreds of real estate modeling…
, , , , ,

Publicly Traded Tenant Analysis Tool (Updated May 2022)

In this post and corresponding video, I am going to walk you through a revamped tenant health worksheet that I shared a long time ago on the site. I spent some time giving it a makeover and decided to put together a video walkthrough for it. Publicly…
, , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis (UPDATED MAY 2022)

When modeling real estate investments, industry practice is generally to stop at before-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily have…
, ,

Using Geometric Mean (or CAGR) as an Alternative to IRR

The internal rate of return (IRR) and compound annual growth rate (CAGR) are both metrics used to analyze investment returns. They're both commonly used in commercial real estate financial modeling, but what's the difference? When should you…
, ,

Graduate Real Estate Series: UC Berkeley’s Master of Real Estate Development and Design

Prior to the MRED+D program, I worked for a general contractor in San Francisco. I worked on the repositioning and adaptive reuse of the historic industrial buildings at Pier 70. Pier 70 is a 40-acre urban infill mixed-use development on…
, , , ,

Scenario Analysis Tool using the Equity Waterfall Model (UPDATED MAY 2022)

I received a question this morning asking how to use scenario (or sensitivity) analysis with our Real Estate Equity Waterfall Model. I started to answer the question via email, decided to build an Excel file to go along with my answer, and ultimately…
, ,

Day in the Life of Mortgage Lending with Ian Hawk

In this ‘Day in the Life of a Commercial Real Estate Professional’ post, we hear from Ian Hawk, Associate at a real estate mortgage lending company, Dwight Mortgage Trust in New York City. Ian has been kind enough to share his typical…
, , , , ,

A.CRE Value-Add Apartment Acquisition Model (Updated May 2022)

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

Real Estate Development Tracker (UPDATED MAY 2022)

One of the many challenges of both analyzing real estate development deals and managing development projects is understanding and tracking the numerous differing but intertwining work streams. The more a development team takes the time…
UT Austin Tower CRE Undergraduate©2009 w.b.ledbetter,jr. / imageclectic.com
, ,

The University of Texas at Austin – Undergraduate Real Estate Profile

As a senior in high school awaiting acceptance offers from schools, I understood that finding my career passion was just as important as the school I attend. I was confident that the University of Texas at Austin would provide a path for…
, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated May 2022)

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

Real Estate Debt Module in Excel (Updated May 2022)

I thought I'd share the real estate debt module I built for the ARGUS alternative in Excel that I've been working on over the last few months. Most debt modules I've seen in real estate financial models only include the ability to model…
, , , ,

Real Estate Capital Account Tracking Tool (UPDATED MAY 2022)

I'll be the first to admit that real estate asset management doesn't get the attention it deserves on AdventuresinCRE.com. The real reason for this is that we're not necessarily asset management experts. I spent some time working in asset management…
,

Microsoft has blocked the macros in my A.CRE model – What now?

When downloading and opening an Excel model from A.CRE, some users may get the ominous message: "Microsoft has blocked macros from running because the source of this file is untrusted." If you've received this message, you're probably asking,…
, , , , , , ,

Physical Occupancy Calculation Model for Real Estate (UPDATED MAY 2022)

As many of you know, I'm in the midst of moving my family from Milwaukee to Dallas, and quite frankly I'm getting sick of eating out and sleeping in hotel rooms. So what better way to unwind from hours of whining kids and tiresome travel, than…
, , , ,

A.CRE Self Storage Development Model (Updated May 2022)

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…