{"id":8973,"date":"2018-12-19T21:30:58","date_gmt":"2018-12-19T21:30:58","guid":{"rendered":"https:\/\/www.adventuresincre.com\/academy\/?post_type=lp_course&p=8973"},"modified":"2019-08-22T16:36:50","modified_gmt":"2019-08-22T21:36:50","slug":"calculating-key-risk-and-return-metrics","status":"publish","type":"lp_course","link":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/courses\/calculating-key-risk-and-return-metrics\/","title":{"rendered":"3a. Calculating Key Risk and Return Metrics"},"content":{"rendered":"

This is the fourth course in the 16-course Accelerator and a companion to course\u00a03. Anatomy of the Real Estate DCF<\/a>. In this\u00a0 mini-course, you will continue where you left off with the Lakefront Industrial I hold\/sell analysis case. Taking the DCF model you built from scratch, you will calculate other important risk and return metrics to complete your analysis.<\/p>\n

The concepts learned in course 3. Anatomy of the Real Estate DCF, together with those learned\u00a0in this course, provide the framework for building more sophisticated acquisition, development, and value-add models later in the Accelerator.<\/p>\n

In this course you will learn to calculate:<\/p>\n

    \n
  1. Unlevered and Levered IRR (annual and non-annual periods)<\/li>\n
  2. Unlevered and Levered Equity Multiple<\/li>\n
  3. Free and Clear Return and Cash-on-Cash Return<\/li>\n
  4. Net Profit<\/li>\n
  5. Average Rate of Return<\/li>\n
  6. Operating Expense Ratio<\/li>\n
  7. Expense Recovery Ratio<\/li>\n
  8. Economic and Physical Occupancy<\/li>\n<\/ol>\n

    In addition, we will show a technique for partitioning the IRR and Equity Multiple.<\/p>\n

    CASE DESCRIPTION \u2013 LAKEFRONT INDUSTRIAL PART 2<\/h4>\n

    Continuing the case from course 3, you are a member of A.CRE Advisors\u2019 asset management team. You are personally responsible\u00a0for managing 17 industrial assets. Your assets consist largely of bulk warehouses built in this cycle (i.e. since 2010) for e-commerce and logistics tenants.<\/p>\n

    The assets are all held within an open-end\u00a0core<\/a>\u00a0fund, with no expressly defined fund termination date. The strategy is to provide consistent long-term income to the investors, while timing acquisitions and dispositions so as to maximize overall returns and beat the\u00a0NFI-ODCE index<\/a>.<\/p>\n

    In a recent conversation with your portfolio manager, he mentions that the acquisitions team is looking at an exciting industrial opportunity. However, he doesn\u2019t want to add another industrial asset to the fund without identifying an equally attractive disposition opportunity. Lakefront Industrial Building 1 comes up as a potential disposition target, and so you commit to doing a hold\/sell analysis on the property.<\/p>\n

    You’ve built a 10-year discounted cash flow model forecasting the projected cash flows for Lakefront Industrial Building I were you to hold the asset long-term. You also quickly calculated the unlevered IRR of that scenario. You’ve now been asked to analyze the hold scenario further and calculate a few more risk and return metrics to help your Portfolio Manager make a more informed decision.<\/p>\n

    PROPERTY TYPE<\/h4>\n
      \n
    • Industrial; concepts apply to all property types<\/li>\n<\/ul>\n

      SOFTWARE RECOMMENDED\/REQUIRED<\/h4>\n
        \n
      • 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<\/ul>\n

        EXCEL PROFICIENCY REQUIREMENT<\/h4>\n
          \n
        • The course assumes you have at least an intermediate proficiency working with Microsoft Excel, Google Sheets, or OpenOffice Calc<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

          This is the fourth course in the 16-course Accelerator and a companion to course\u00a03. Anatomy of the Real Estate DCF. […]<\/p>\n","protected":false},"author":1,"featured_media":8975,"template":"","course_category":[369],"course_tag":[360,362,358,359,357,356],"class_list":["post-8973","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-accelerator","course_tag-cash-on-cash-return","course_tag-courses","course_tag-debt-service-coverage","course_tag-debt-yield","course_tag-equity-multiple","course_tag-irr","course"],"_links":{"self":[{"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/lp_course\/8973","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\/1"}],"version-history":[{"count":0,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/lp_course\/8973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/media\/8975"}],"wp:attachment":[{"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/media?parent=8973"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/course_category?post=8973"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/course_tag?post=8973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}