Sold out

Sample Video

OVERVIEW

This introductory course offers a balance of videos, discrete exercise/solutions that can be layered on top of existing accounting and financial modeling acumen. This CRE-specific industry module is designed to get you up to speed quickly and efficiently, with a focus on unique aspects of commercial real estate that can be paired with broader TTS courses including Applied Excel, general 3-statement modeling and valuation.

4 hours of video content.
Estimated 10-12 hours to complete.

KEY FEATURES

  • Real estate represents a diverse mix of special use-cases including offices, apartments, data centers, healthcare, office, self-storage, malls, shopping centers and industrial buildings
  • Public markets are dominated by large, diversified REITs in the US that recently became the 11th sector of the S&P 500
  • The private CRE market is highly robust and requires both shared and unique tools compared to evaluating public REITs

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

  • Building a 30-year Debt Amortization Schedule in Excel including an interest only toggle
  • Calculating NPV and Going-in Cap Rates in Excel
  • Working with Date Functions in Financial Models
  • Calculating Common CRE Debt Ratios in Excel
  • REIT Metrics Explained including FFO and AFFO
  • Calculating Net Asset Value (NAV)
  • Reviewing Modeling Property Cash Flows for Different Deals
  • CRE Scenarios Analysis and ‘Back-to-back’ Data Tables
  • Calculating Unlevered and Levered IRRs in Excel

PREREQUISITES

This course is open to all. To maximize the benefit of this course we recommend an understanding of financial statements and Microsoft Excel.

 


Group Orders

We offer discounts for group orders on our self-study products. Group orders are an attractive option for companies or teams looking to upskill together.

Contact us at selfstudy@trainingthestreet.com to learn more about how to save money on group orders.


Browse Our Course Bundles Below:

Sold out

Sold out

Sold out

Sold out

Gain your recognition with our digital certificates

Training The Street has been teaching the biggest finance firms for over 20 years. To help unlock your career potential, we offer certificates to provide the recognition you deserve.

After you finish your course, you will receive a certificate which can be easily added to your LinkedIn profile.