All-in-One Model Walkthrough 2 - Office Retail Industrial Rent Roll Tab [Updated]

New/Updated walk-through. This is the second in a series of walkthrough videos on how to use All-in-One Model. Today I discuss the Office/Retail/Industrial Rent Roll tab within the Operation module. To read more about this tab or to download the model, visit the link below:
Download model: www.adventuresincre.com/re-mo...
00:00 - Introduction to Updating the Office Retail Industrial Rent Roll Tab
00:50 - Accessing and Navigating the ORI Rent Roll Tab in the All-in-One Model
02:00 - Detailed Walkthrough of Tenant Assumptions and Inputting Tenant Information
03:45 - Calculating Tenant Options, Lease Terms, and Rent Increase Methods
06:25 - Adding Lease Options and Customizing Rent Details in Option Tab
09:12 - Incorporating Unpaid Leasing Costs and Detailed Expense Reimbursement
10:45 - Streamlining Expense Reimbursement with Simplified Model Features
12:15 - Adjusting Pro Rata Share of Operating Expenses and Future Tenant Assumptions
14:00 - Setting Up Market Rent and Tenant Improvements for Future Tenants
15:44 - Customizing Market Rent Growth and Lease Length for Future Tenants
17:43 - Finalizing Tenant Information and Checking for Unallocated Square Footage
17:45 - Analyzing Assumptions on ORI Calc Tab and Understanding Cash Flows
19:31 - Summarizing Rent and Expense Recovery on ORI Opstat Tab
Learn to build institutional-quality real estate models: www.adventuresincre.com/accel...
SUBSCRIBE to A.CRE on CZcams: czcams.com/users/sburtonh...

[@pv0315]

Thanks a lot Spencer... Hope you and all your people are safe and well. 🙏🙏 Take care brother. God save all of us.

[@adventuresincre]

I'd previously created a similar walk-through for the ORI-RR tab back in 2017. A lot has changed since then, so it made sense to create a new video. Let me know if you have any questions!

[@A.A.A29]

It looks like Rental increases are assumed to take place on Jan 1st of the new year. Is there a way to modify this so that the yearly rental increases occur at each lease anniversary date?

[@gemcxx]

Is there a way to clear the existing data input fields other than going through every tab and deleting manually?

[@victorchiang82]

How would you add a month to month tenant?

[@TwiggyUND23]

Thanks Spencer - one question I have is regarding CF after financing for a levered return calc. If the debt payment includes principal paydown, wouldn't you just deduct interest expense from the cash flow (CF after interest expense) and use this for your levered IRR instead of CF after principal and interest?

[@VictorBrichaut]

Is there any way we can differentiate areas (office, mezzanine, warehouse, cold storage, etc.)? I'm guessing I could increase the number of tenants and use the tenant label to indicate the type of areas but this means duplicating a lot of information (lease start, renewal option, etc.).

[@chrisw8011]

The expense recoveries will never be exact when there are detailed amortization reimbursements, excluded items, caps, reimburse-after anchors, different denominators, etc. Amortization recoveries in particular can be a major source of revenue and they usually decline over time yet they are not an actual expense.
Any plans to introduce a detailed reimbursement tab / function to the model?