Posts

, , ,

Real Estate Financial Modeling Accelerator (Updated September 2019)

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

Create A Dynamic Revenue Row to Calculate Multiple Tenant Leases

I recently received an email from one of our readers asking how to create a dynamic revenue row for a pro forma that can capture rent changes for multiple tenants. I thought that this would make a great post for the site and would be a good…
,

Excel Tip: Copy Worksheets between Identical Models

From time to time, I come across modeling situations that Excel does not have built-in functionality to address. One particular situation I come across regularly, involves needing to transfer the contents of a worksheet, including all inputs,…
, , ,

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

Supercharge Excel with the WST Macros Add-in

A year ago I wrote about Wall St. Training and their free Excel modeling resources. In that post, I mentioned the free WST Macros and how it is an indispensable add-in; one that I use in my professional life daily.Well, version 4.4 was recently…
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…
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.…
, , , ,

Formulas I use to Create the Period and Date Rows at the Top of a Monthly Cash Flow Report

We've spent a lot of time here discussing and sharing different real estate models, and we've received a ton of feedback from our readers as a result. In some of that feedback we've received, several people have asked what period and date rows I…
, , , ,

Excel Tips: Creating Data Tables Part 1: One Variable Data Table + Inserting Text into Numerical Cells

The Excel model attached to this post is to show modelers how to (1) create and use data tables and (2) insert words into numerical cells.The Data Table function is a great tool that allows you to show numerous results for various return…
, , ,

Wall St. Training - Free Excel Resources

Wall Street Training (WST) is a fantastic site for free and paid Excel training resources. According to their site, they are "The world's leading provider of live and online financial training, serving a wide variety of investment banks, private…