# All-in-One (Ai1) Underwriting Model

##### All | Argus | All-in-One | Excel Models | Excel Tips | Stochastic Modeling

All | Support Forum

### The Real Estate Financial Modeling Accelerator

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

### All-in-One (Ai1) Walkthrough #5 - The Residual Land Value Calculation Module

This walkthrough, our fifth in the series, explains how the Residual Land Value Calculation module works and how to implement this tool into your analysis. You might recall, a few months back we discussed the concept of residual land value…

### All-in-One (Ai1) Walkthrough #4 - The Rate Matrix Module

This walkthrough, our fourth in the series, explains how the Rate Matrix module works and how to implement this tool into your analysis. The rate matrix concept is new to this site, and not commonly used in the industry. Nonetheless, given…

### All-in-One (Ai1) Walkthrough #3 - Modeling a Hypothetical Retail Development Investment

This walkthrough, our third in the series, takes you through the entire process of modeling a simple development investment. I've created hypothetical assumptions for this exercise written out in PDF format (download link below) and then use…

### All-in-One (Ai1) Walkthrough #2 - Office, Retail, Industrial Rent Roll Tab

This walkthrough, our second in the series, will detail how to use the office/retail/industrial rent roll (see ORI-RR Tab). The rent roll tab is arguably the most important, and most complex, tab in the All-in-One model. Below we post a video…

### All-in-One (Ai1) Walkthrough #1 - Permanent Debt Tab

In an effort to provide greater instruction on how to use our All-in-One Underwriting Tool for Real Estate Development and Acquisition, we'll be developing a series of walkthrough videos and posts on the methodology behind the various components…

### Version Notes: All-in-One Underwriting Model

Version notes for the All-in-One Underwriting Model for Real Estate Development and Acquisition are found here as well as in the 'Version' tab of the Excel model. Download the Model Version 0.3.1 (March 11, 2017) Added version notes…