All-in-One (Ai1) Model – Tutorials

All | Argus | All-in-OneExcel Models | Excel TipsStochastic Modeling

All | Tutorials | DownloadSupport Forum

real estate financial modeling courses

, , , , , , ,

Hold-Sell Analysis in Real Estate

In course 3 of our A.CRE Accelerator, we use a case study that revolves around a hold-sell (i.e. hold vs sell) analysis scenario to teach the anatomy of the real estate DCF. In that scenario, the student is an asset manager working for an open-end…
,

Quick Tutorial: Add Line Items to OpSt Sheet in All-in-One

I was recently asked the question whether it's possible to add more other income or operating expense line items to the MF-OpSt or ORI-OpSt worksheets in my All-in-One Model for Underwriting Acquisitions and Development. Short answer is: out…
, , , ,

Understanding Treatment of Time 0 in the All-in-One Model

I received a very astute question/concern from a user of our All-in-One(Ai1) model in our Ai1 Support Forum late last month. I initially set out to answer the question in writing, but the more I thought about my response, the more I concluded…
, ,

All-in-One (Ai1) Walkthrough #10 - Underwriting a Value-Add Office Investment

This walkthrough, our tenth in the series, takes you through the entire process of underwriting a hypothetical office value-add opportunity using the All-in-One (Ai1) Model. This walkthrough comes as a response to a question we recently received…
, ,

All-in-One (Ai1) Walkthrough #9 - Print Mode and the IRR Matrix Report

This walkthrough, our ninth in the series, touches on the newly added (beta v0.5.3) 'Print Mode' and IRR Matrix Report in our All-in-One (Ai1) model. Print mode further enhances the printability of the model while the IRR Matrix Report adds…
, ,

All-in-One (Ai1) Walkthrough #8 - Tenancy Analysis Report for Office, Retail, and Industrial

This walkthrough, our eight in the series, explains how the Tenancy Analysis report for office, retail, and industrial real estate underwriting works in our All-in-One (Ai1) model. The Tenancy Analysis report includes a tenant rollover schedule,…
, ,

All-in-One (Ai1) Walkthrough #7 - Ground Lease Valuation Module

This walkthrough, our seventh in the series, explains how the Ground Lease Valuation Module works and how to implement this tool into your analysis. The All-in-One Model includes two methods to account for a ground lease. The first is to simply…
, ,

All-in-One (Ai1) Walkthrough #6 - Underwriting a Hypothetical Multifamily Acquisition

This walkthrough, our sixth in the series, takes you through the entire process of underwriting an apartment acquisition opportunity using the All-in-One Model's new multifamily module. I've created hypothetical assumptions for this exercise…
, ,

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…