, , ,

Real Estate Financial Modeling Accelerator (Updated October 2024)

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

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

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…