We haven’t uploaded an apartment acquisition model to our Excel library of real estate models yet, and I didn’t have anything worth sharing in my personal library that wasn’t proprietary. So I thought I’d alter the real estate valuation model I posted last week to work with multifamily residential deals. The project started out simple enough, but became more complex as I came to the conclusion that I needed to add several modules that are specific to apartments.
The model is similar in many respects to the office/retail/industrial acquisition model, only the DCF is more robust. I’ve added several calculation modules to model free rent, releasing costs, lease-up days between leases, unit types, etc. The debt module is fairly simple (no monthly amortization shown), but it could be easily enhanced. Also, note that I hammered this out quickly on a Saturday morning, so there are likely errors that I hope you guys will help me find.
I’ve posted a video of how to use the model, during which I value an actual property from LoopNet. Please feel free to reach out with questions, comments or requests you may have.
Download The Model
To make this model accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (enter $0 if you’d like) or maximum (your support helps keep the content coming – typical real estate models sell for $100 – $300 each). Just enter a price together with an email address to send the download link to, and then click ‘Continue’. If you have any questions about our “Pay What You’re Able” program or why we offer our models on this basis, please reach out to either Mike or Spencer.
Real Estate Acquisition Model - Multifamily (v1.151)
- Acquisition model tailored specifically to apartments; could also be used for senior living and other for-rent residential product
- Similar to the real estate acquisition model built for office, retail, and industrial deals only the DCF is more comprehensive
- Property and investor level returns
- Inflation calculation
- Debt calculation
This Excel file (the "software") is distributed as is, completely without warranty or service support. www.AdventuresinCRE.com and its authors are not liable for the condition or performance of the software. www.AdventuresinCRE.com owns the copyright and grants users a perpetual, irrevocable, worldwide, non-exclusive, royalty-free license with respect to the software as set forth below.
www.AdventuresinCRE.com and its authors hereby disclaim all implied warranties. www.AdventuresinCRE.com grants the users the right to modify, copy, and redistribute the software and documentation, both within the user's organization and externally, subject to the following restrictions:
1. The users agree not to charge others for use of the software, regardless of whether users have altered and/or improved the software in anyway.
2. In any use of the software, the users agree to acknowledge the www.AdventuresinCRE.com authors that developed the software.
3. The users agree to obey all government restrictions governing redistribution or export of the software.
4. The users agree to reproduce any copyright notice which appears on the software and documentation on any copy or modification of such made available to others.
UPDATE: Uploaded v1.13; I found an error in how v1.0 was calculating debt service. I also corrected some minor formatting issues, moved the Investor Returns inputs to the Property Summary tab, and added a few ratios to the Annual Cash Flow tab.
About the Author: Born and raised in the Northwest United States, Spencer Burton has over 15 years of real estate investment and development experience. In his current position, Spencer assesses new acquisition, development, and debt opportunities for a $45bn real estate fund. He resides in Dallas, TX.