, , ,

Real Estate Financial Modeling Accelerator (Updated Dec 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. Over the years, we've covered hundreds of real estate modeling topics in our blog,…
, , ,

Hide and Unhide Tabs using Drop-down Menus in Excel

I'd like to share a handy little trick I learned this week for hiding and unhiding tabs in Excel using drop-down menus. Now this method requires you to use some basic VBA code and to save the Workbook as a Macro-Enabled file but don't be intimidated…
, , , , , ,

How to Use the Apartment Acquisition Model’s Monte Carlo Simulation Module

You may recall that a couple of weeks ago, I began to explore Stochastic Modeling concepts, or the idea of adding probability into my models, to get a more complete picture of the risk-return metrics of an investment. I became interested in…
, , ,

Waterfall Model For Real Estate Joint Ventures with Catch Up

I've just wrapped up a new JV waterfall model with catch up clause that I am excited to share on the site. This model was built as an addition to my back-of-the envelope retail/industrial/office acquisitions model I posted a few weeks back.…
, , , ,

Real Estate Debt Module in Excel

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

Understanding Taxes Series: Part 1 – Depreciation

Investing in real estate provides some tremendous tax incentives in the USA compared to other investments and is an important component to understanding real estate investing. Given the positive response I've received to my Understanding Leases…