, , ,

Real Estate Financial Modeling Accelerator (Updated Feb 2021)

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. Over the years, we've covered hundreds of real estate modeling topics in our blog,…
, , , ,

How to Use the Construction Draw and Interest Calculation Model

As promised, I've recorded a tutorial on how to use my construction draw and interest calculation model. The 20 minute tutorial walks you through how to use the model to forecast construction cash flows during your development period. The model…
Circuit Breaker - Fix Circular References Errors in Excel
, , , ,

The Circuit Breaker – How to Fix Circular Reference Errors in Excel

If you've spent much time working with elaborate Excel workbooks that rely on iterative calculations to solve formulas with circular logic, you've undoubtedly come across a problem where if you accidently put an erroneous value in an input…
equity multiple
, , ,

Real Estate Waterfall Model – Equity Multiple Hurdles

I've created a companion to my real estate equity waterfall model to work with equity multiple hurdles, rather than IRR hurdles. It took me longer than I expected to build this, largely because I was over thinking it. I messed around with…
, , ,

Understanding Leases: Office Buildings – Part 2b

Grossing Up Reimbursable Expenses in ARGUS This post and video are a follow up to a post written back in late October discussing grossing up reimbursable expenses. If you haven’t gotten to read that yet, you can do so by clicking here:…
, , , ,

Apartment Valuation Tutorial Using the Real Estate Acquisition Model

I promised a how-to video for my real estate apartment acquisition model, and so I thought I'd use an actual property to do so. I grabbed a property from Loopnet that is currently for sale, and dropped the information from the listing into…
Excel 2016
,

Disable Animations – Excel 2013 (and Presumably in Excel 2016)

If you recently upgraded from Excel 2007 or Excel 2010 to either Excel 2013 or Excel 2016 for Windows, you've probably noticed a change that can be quite distracting (and even annoying!). Microsoft Excel now animates certain actions as you work.…
,

Understanding Leases: Office Buildings – Part 2a

Grossing Up Operating Expenses – What, How, Why, and its impact on the Three Common Bill-back Methods A common practice in office leases is to gross up the variable portion of the reimbursable expenses. Grossing up expenses is when the…
,

Understanding Leases: Office Buildings – Part 1

Billing Back Reimbursable Operating Expenses – Three Common Approaches for Office Buildings (ARGUS video example to follow next week) The three most common approaches to expense reimbursements in office leases are the (1) triple-net,…
,

Another Shot at Stuy Town – Blackstone’s $5.3 Billion Bet

Styuvesant Town-Peter Cooper Village, otherwise known as Stuy Town, is back in real estate news. Blackstone, together with Ivanhoe Cambridge and CWCapital Asset Management, have agreed to buy the 11,232-unit apartment complex for…
,

Introducing a New Blog Segment: Understanding Leases

We are rolling out a new segment this week called Understanding Leases. The aim is to help our readers learn about the more nuanced and unique concepts to commercial real estate leasing and provide general tips and understanding. Over time we…
, , , ,

Scenario Analysis using the Equity Waterfall Model

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

CRE Market Spotlight: Camden, NJ

After decades of being statistically one of the poorest cities in the country, it seems there are finally big changes coming to the city of Camden, NJ. With an extensive and generous state sponsored tax credit program luring big businesses to…
, ,

MS Excel Alternative to ARGUS DCF

It is little secret among our readers that I view ARGUS DCF as a necessary evil. On the one hand, it is the industry standard for underwriting real estate. Virtually every broker package for institutional quality deals comes with an ARGUS run,…
, ,

Adventures In CRE’s Events Calendar

We have begun to compile a calendar of events for some of the more well known trade organizations in the industry in order to give our readers a one stop place to find out about events that are happening throughout the US and internationally.…
, , , ,

How to Use My Real Estate Equity Waterfall Model

I took a few minutes this weekend, and created a video to help you use my real estate equity waterfall (IRR hurdle technique) model that I built in Excel. Again, keep in mind that the model is not standalone, but can be used with any of the…