{"id":12745,"date":"2018-11-27T18:39:33","date_gmt":"2018-11-28T00:39:33","guid":{"rendered":"https:\/\/www.adventuresincre.com\/academy\/?post_type=lp_course&p=12745"},"modified":"2020-12-03T15:31:45","modified_gmt":"2020-12-03T21:31:45","slug":"advanced-concepts-real-estate-financial-modeling","status":"publish","type":"lp_course","link":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/courses\/advanced-concepts-real-estate-financial-modeling\/","title":{"rendered":"Advanced Concepts in Real Estate Financial Modeling"},"content":{"rendered":"

COURSE DESCRIPTION<\/h4>\n

Advanced Concepts in Real Estate Financial Modeling is a supplemental bonus<\/em> course offered as part of the Accelerator curriculum. This course is not<\/strong> required to earn an Accelerator Certificate of Completion<\/em><\/span>, but instead is meant to teach concepts not directly addressed in the standard Accelerator curriculum but that you will likely use at some point in your career.<\/p>\n

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

    \n
  1. Learn to model floating (i.e. variable) rate debt<\/li>\n
  2. Perform sophisticated real estate sensitivity and scenario analysis using Excel\u2019s data table feature<\/li>\n
  3. Model multiple tranches of capital sources, dynamic to order in which sources are deployed<\/li>\n
  4. Learn a technique for modeling GP catch up provisions in equity waterfall modeling<\/li>\n
  5. Learn a technique for modeling LP clawback provisions in equity waterfall modeling<\/li>\n
  6. How to model quarterly and annual partnership distributions with monthly property-level cash flows<\/li>\n
  7. Discover a variety of advanced formatting techniques for more user-friendly and intuitive real estate models<\/li>\n
  8. Explore considerations in portfolio-level modeling<\/li>\n
  9. Learn one method for modeling partnership crystallization (i.e. ownership reset) in equity waterfall modeling<\/li>\n
  10. Model basic after-tax analysis, including the option to defer capital gains<\/li>\n
  11. And much more<\/li>\n<\/ol>\n

    Additional tutorials are regularly added to this course based on your recommendations<\/strong>. So if there is a real estate financial modeling topic not covered in the standard Accelerator curriculum, and you’d like to see Spencer or Michael teach it, let us know in this course’s forum.<\/p>\n

    CASE STUDY – NA<\/h4>\n

    Unlike standard Accelerator courses, this course does not have any specific case study. Nor are there quizzes or completion requirements. This course is a series of video (i.e. Watch Me Build) tutorials. Each tutorial includes a template Excel file for you to use to follow along, and a completed Excel file to see the answers.<\/p>\n

    PROPERTY TYPE<\/h4>\n
      \n
    • 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
      • This course was built using the Google Chrome browser, thus we recommend you use Google Chrome for optimal view experience<\/li>\n
      • This course is best taken on a desktop computer, although the platform is compatible with tablet and mobile devices<\/li>\n<\/ul>\n

        EXCEL PROFICIENCY REQUIREMENT<\/h4>\n
          \n
        • The course assumes you’ve spent significant time in the Accelerator and have at least an intermediate proficiency in Excel<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

          COURSE DESCRIPTION Advanced Concepts in Real Estate Financial Modeling is a supplemental bonus course offered as part of the Accelerator […]<\/p>\n","protected":false},"author":134,"featured_media":12760,"template":"","course_category":[369],"course_tag":[],"class_list":["post-12745","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-accelerator","course"],"_links":{"self":[{"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/lp_course\/12745","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":3,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/lp_course\/12745\/revisions"}],"predecessor-version":[{"id":15705,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/lp_course\/12745\/revisions\/15705"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/media\/12760"}],"wp:attachment":[{"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/media?parent=12745"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/course_category?post=12745"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/www.adventuresincre.com\/academy\/enterprise\/wp-json\/wp\/v2\/course_tag?post=12745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}