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 in the Ai1 Support Forum. Here is the question:
We are exploring the route of acquiring a value add office building. We will likely not take on any debt to start. I have a few questions as it relates to the model. I’m struggling to figure out how to enter an acquisition price of x dollars but also have some sort of development piece layered in.
My goal is to acquire the property for x dollars, put x dollars into cap ex per year while leasing the building up and exiting the property in year x. Could you please walk me through how this could be achieved.
In an effort to provide greater instruction on how to use our All-in-One Underwriting Tool for Real Estate Development and Acquisition, we’re developing a series of walkthrough videos and posts on the methodology behind the various components of the model. Our hope is that if you are empowered with the how, you’ll be more willing/able to provide feedback to improve the model.
If you haven’t already, you can download the model here. This walkthrough uses beta version 0.5.5 of the All-in-One Model.
Two Ways to Model Value-Add Using the Ai1
There are two methods for modeling value-add investments using the Ai1. The first method is to use the Development Module (set Development Length on the ‘Summary’ tab to a value greater than 0), modeling the renovation cash flows on the ‘Budget’ tab while setting the Operations Begin Date (on the ‘Summary’ tab) equal to the Analysis Start Date (also entered on the ‘Summary’ tab). Doing this allows for a bridge loan during the non-stabilized period (i.e. called construction financing in the model), which is taken out by a permanent loan at stabilization (per the Stabilization Date set on the ‘Summary’ tab).
However, in this hypothetical case it doesn’t make sense to use the first method. That is because the hypothetical investment won’t include debt, nor will it require robust renovation cash flow modeling. Thus, I choose to use the simpler second method. The second method involves using the Acquisitions module (leave Development Length on the ‘Summary’ tab set to 0), and modeling the renovation cash flows as ‘Other CapEx’ on the ‘ORI-OpSt’ tab. In the following video and using the assumptions below, I walk you through how to use this second method to model a value-add office investment using the Ai1 model.
Video Walkthrough – Underwriting a Hypothetical Value-Add Office Investment
Assumptions – Hypothetical Value-Add Office (No Debt and <15% Occupied)
- Investment name: Suburbs Park
- Parking: 85 spaces
- Year built: 1996
- Analysis start: Jan 1, 2018
- Construction length: 0 months
- Analysis period: 3 years
- Tenants: 6
- Net Rentable Area: 21,200 (1st Floor – 6,200 SF, 2nd Floor – 7,500 SF, 3rd Floor – 7,500 SF)
- In-place acquisition Price: $3,250,000 plus $75,000 in acquisition costs
- Market NOI cap rate for comparable properties: 6.00%
- Forecast growth in cap rate: 0 bps per year
- Exit cap rate: 6.00%
- Selling costs @ reversion: 2.0%
Permanent Debt Assumptions
Renovation Budget and Timing
- Lobby – $250,000 – 12 months
- Bathrooms – $50,000 – 12 months
- Exterior Upgrades – $100,000 – 24 months
- Deferred Maintenance – $75,000 – 24 months
- Soft Costs – $65,000 – 24 months
Rent Roll as of Analysis Start
- Expense Recovery – 100% of reimbursable operating expenses (NNN)
- Parking Income – $0
- Antenna Income – $15,000/yr
- Misc. Income – $7,500/yr
- Payroll @ $1.75 PSF; G&A @ $0.50 PSF; Utilities at 2.25 PSF; R&M @ 1.50 PSF; mgmt fee @ $27,500/yr; taxes @ $42,500/yr; insurance @ 12,500/yr
- Non-reimbursable @ 0.5% of EGI
- % Fixed: All but taxes, and insurance @ 0%; insurance @ 100%, taxes @ 75%
- Expenses grown at 2%
- Other CapEx: Per budget and timing; monthly cash flow schedule modeled in new tab
- Capital Reserve: $0.35 PSF