In this tutorial, I answer a question from our Ai1 Support Forum on how to model a straightforward value add office opportunity using the Ai1 model. The video walks you through the process using some hypothetical assumptions I quickly came up with. Download the model, the assumptions, and follow along to better learn how to use the Ai1.
00:00 - Introduction
02:55 - Preparing and Setting Up the Model
04:00 - Explanation of Assumptions and Activation of Relevant Modules
06:00 - Setting up and Describing the Property and Investment
07:06 - Rent Roll Modeling and Tenant Assumptions
07:30 - Transition to Operating Statement and Assumptions for Income and Expenses
09:00 - Operating Statement Adjustments and NOI Calculations
10:00 - Capital Expenditures and Renovation Budgeting
11:29 - Monthly Operating Statement and Custom Renovation Cash Flows
14:01 - Modeling Renovation Cash Flows and Linking to Operating Statement
16:21 - Finalizing the Model and Reviewing Cash Flows
Download the latest version of the model: [ Ссылка ]
Download the assumptions for this scenario: [ Ссылка ]
Learn more about the author: [ Ссылка ]
![](https://i.ytimg.com/vi/rovNRkj_0DM/maxresdefault.jpg)