{"id":8948,"date":"2018-12-19T21:12:03","date_gmt":"2018-12-19T21:12:03","guid":{"rendered":"https:\/\/www.adventuresincre.com\/academy\/?post_type=lp_course&#038;p=8948"},"modified":"2019-07-20T09:26:04","modified_gmt":"2019-07-20T14:26:04","slug":"building-an-acquisitions-model-from-scratch","status":"publish","type":"lp_course","link":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/courses\/building-an-acquisitions-model-from-scratch\/","title":{"rendered":"9. Building an Acquisitions Model from Scratch"},"content":{"rendered":"<h4>COURSE DESCRIPTION<\/h4>\n<p>This is the 14th course in the 16-course Accelerator, and the first of three capstone courses. In this case-based course, you will put in practice what you learned in the previous courses to build an institutional-quality, single-tenant acquisition model from scratch. In this course you will rely heavily on the following concepts learned from previous Accelerator courses:<\/p>\n<ol>\n<li>Use the <em>inputs &#8211;&gt; calculation modules &#8211;&gt; outputs<\/em> concept to build a fully dynamic real estate model<\/li>\n<li>Create a direct cap pro forma to derive a purchase price<\/li>\n<li>Model operating cash flows, applying appropriate growth rate, recovery percentage, and vacancy assumptions<\/li>\n<li>Create a direct cap pro forma to derive a reversion value<\/li>\n<li>Layer in debt, modeling debt service, loan payoff, and various risk metrics<\/li>\n<li>Build a discounted cash flow model, summing to unlevered and levered net cash flow lines<\/li>\n<li>Calculate property-level return metrics<\/li>\n<li>Model a partnership waterfall to arrive at partnership-level returns<\/li>\n<li>Use proper formatting and layout convention<\/li>\n<\/ol>\n<h4>CASE DESCRIPTION &#8211; 10000 Fitness Way<\/h4>\n<p>You own a small real estate investment firm. Your firm, consisting of just you and an administrative assistant, largely sticks to a value-add multifamily investment strategy. Over the past nine years, you have bought and sold 12 class B and C multifamily properties totally over 1200 multifamily units. Your strategy has been simple. Buy underperforming, older apartment projects in good locations, renovate 70% &#8211; 80% of the units, and then sell the properties at a profit. However, as the cycle has matured, it has become ever more difficult to find profitable apartment flips. You are now convinced the market has reached peak pricing and you&#8217;re considering putting your gains into a more conservative long-term strategy while you wait for the buying opportunities to return. In addition to placing your own capital in a longer term real estate play, you have limited partners from previous deals who are anxious to redeploy their capital. You worry that if you don&#8217;t find a smart opportunity or two in the next 6-12 months, they may place their capital elsewhere. This evening you head to a local CCIM networking event. There, you bump into your old friend and former classmate from business school, <a href=\"https:\/\/www.eastlangellis.com\/team\/\" target=\"_blank\" rel=\"noopener noreferrer\">Trey Fishman<\/a>. Trey mentions that he is about to bring to market a great single-tenant acquisition opportunity. The tenant, a BBB-rated fitness operator, recently signed a 15-year absolute NNN lease with 2% annual rent bumps. He remarks that this asset would be a great place to park capital through a market downturn. You&#8217;re intrigued. While you don&#8217;t have direct experience in retail, the single-tenant NNN nature of the lease would make managing this asset simple. Which in turn would both allow you to place a portion of your capital in a steady investment and still have time to seek opportunistic investments. He offers to send you the book, and you gladly accept.<\/p>\n<h4>PROPERTY TYPE<\/h4>\n<ul>\n<li>Retail; most concepts apply to all property types<\/li>\n<\/ul>\n<h4>SOFTWARE RECOMMENDED\/REQUIRED<\/h4>\n<ul>\n<li>While we recommend using Microsoft Excel, as that is the industry standard, this course will work with most other spreadsheet software such as Google Sheets and OpenOffice Calc<\/li>\n<li>This course was built using the Google Chrome browser, thus we recommend you use Google Chrome for optimal view experience<\/li>\n<li>This course is best taken on a desktop computer, although the platform is compatible with tablet and mobile devices<\/li>\n<\/ul>\n<h4>EXCEL PROFICIENCY REQUIREMENT<\/h4>\n<ul>\n<li>The course assumes you have at least a basic proficiency working with Microsoft Excel<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>COURSE DESCRIPTION This is the 14th course in the 16-course Accelerator, and the first of three capstone courses. In this [&hellip;]<\/p>\n","protected":false},"author":134,"featured_media":8979,"template":"","course_category":[369],"course_tag":[362],"class_list":["post-8948","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-accelerator","course_tag-courses","course"],"_links":{"self":[{"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/lp_course\/8948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/users\/134"}],"version-history":[{"count":0,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/lp_course\/8948\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/media\/8979"}],"wp:attachment":[{"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/media?parent=8948"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/course_category?post=8948"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/course_tag?post=8948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}