The Real Estate Analyst includes

Real Estate Investing

4.2 STARS

Star Rating
Accordion White Arrow Icon

About

Master the technical skills needed for real estate financing and learn how to analyze and interpret market data to inform investment decisions.

Completion time

4 Hours

Level

Skills Certificate

About

Master the technical skills needed for real estate financing and learn how to analyze and interpret market data to inform investment decisions.

Completion time

4 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Real Estate Forecasting

30

6

Accordion Arrow Icon

Video minutes30

Excel Exercises6

  • Introduction to Real Estate
  • Measuring Real Estate
  • Lease Types
    • Pro rata calculations
    • Base year stop
  • The Cash Flow Statement
  • Rental Revenues
    • Gross versus Net
    • Modeling revenues from different types of assets
    • Renewal probability
  • Additional Income
    • Percentage Rent
  • Operating expenditures
  • Capital Expenditures
  • Income Taxes

Real Estate Financing

22

4

Accordion Arrow Icon

Video minutes22

Excel Exercises4

  • Overview of the capital structures
  • Debt
    • Loan sizing (LTV and LTC)
    • Amortizing loans with balloons
    • Mezzanine
  • Equity
    • Preferred vs common
    • GPs and LPs
    • Promoted interest
  • Equity Waterfalls

Cap Rates and Other Metrics

12

2

Accordion Arrow Icon

Video minutes12

Excel Exercises2

  • Calculation and comparison cap rates
  • IRR, Cash on Cash Yield, Breakeven, Multiple of Money

Real Estate Case Study Model

74

10

Accordion Arrow Icon

Video minutes74

Excel Exercises10

  • Going in and Exit Cap Rates
  • Financing sources and uses
  • Differing Lease types and pro rata calculations
  • Rental revenues and adjustments
  • Operating expenditures and reimbursements
  • Capex, Tis, Reserves, Lease commission
  • Unlevered and levered cash flows
  • Return metrics

Real Estate (REIT) Modeling and Valuation

4.2 STARS

Star Rating
Accordion White Arrow Icon

About

Get to grips with real estate modeling and valuation in full. Bridge the gap between your existing accounting knowledge and learn what REITs are, how to analyze them, and how to value them with our online real estate investing course. Master the critical skills needed to complete a comprehensive REIT valuation model based on real company data.

Completion time

6.5 Hours

Level

Skills Certificate

About

Get to grips with real estate modeling and valuation in full. Bridge the gap between your existing accounting knowledge and learn what REITs are, how to analyze them, and how to value them with our online real estate investing course. Master the critical skills needed to complete a comprehensive REIT valuation model based on real company data.

Completion time

6.5 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Introduction to REITs

10

0

Accordion Arrow Icon

Video minutes10

Excel Exercises0

  • What is a REIT?
  • How a REIT is structured
  • Presentation in the financials
  • How REITs grow

FFO and AFFO

15

3

Accordion Arrow Icon

Video minutes15

Excel Exercises3

  • Defining and calculating Funds from Operations (FFO)
  • Defining and calculating Adjusted Funds from Operations (AFFO)
  • Understanding straight-line leases

US GAAP vs IFRS

3

0

Accordion Arrow Icon

Video minutes3

Excel Exercises0

  • Summary of IFRS 40
  • FFO and AFFO for non-US REITs
  • Impact on valuation

Cap Rates

14

2

Accordion Arrow Icon

Video minutes14

Excel Exercises2

  • Calculating NOI
  • How leases and property types affect cap rate
  • Applying the analysis to investments

Building a REIT Operating Model

63

13

Accordion Arrow Icon

Video minutes63

Excel Exercises13

  • Preparing the supplemental calculations of Revenues & Costs
  • Preparing fixed assets calculations of Property Acquisitions, Property Development/Redevelopment, Asset Disposals
  • Calculating Dividends using FFO
  • Calculating Equity Investments and NCI
  • Preparing the Income Statement
  • Preparing the Balance Sheet
  • Preparing the Cash Flow Statement
  • Calculating the Debt and Equity needed to fund future growth

REIT Valuation

32

2

Accordion Arrow Icon

Video minutes32

Excel Exercises2

  • How valuing REITs differs from traditional corporates
  • Valuation using NAV, trading and transaction comparables, and DCF
  • Calculating cost of capital for a REIT

Comprehensive REIT Valuation Model - NAV

14

4

Accordion Arrow Icon

Video minutes14

Excel Exercises4

  • Calculating fully diluted shares
  • Calculating the operating assets with capitalized income
  • Calculating equity investments and other operating, non-real-estate assets
  • Calculating liabilities and other claims on assets

Comprehensive REIT Valuation Model - DCF

30

7

Accordion Arrow Icon

Video minutes30

Excel Exercises7

  • Calculating WACC
  • Calculating PV of FCF
  • Determining dilution from future equity issuances
  • Calculating terminal valuing using multiples and perpetuity method
  • Running sensitivities

Get Certification Recognized on Wall Street

Upgrade your résumé with certification recognized by the top 4 investment banks.

Our exams are similar to assessments at the top firms. This means they are going to challenge you. Our online courses will teach you everything you need to know to succeed.
The Real Estate Analyst course is made up of 2 skills certificates. Pass each one to unlock your micro-degree. Certification can easily be added to LinkedIn, demonstrating your achievement which will be recognized by the most prestigious firms on Wall Street.

THIS MICRO-DEGREE HAS BEEN REVIEWED BY

Colin Evans

Managing Director at J.P. Morgan

Colin Evans is a Managing Director at J.P. Morgan and leads the financial institutions coverage team globally for Corporate Banking

Dr. Bridget Lyons

Professor of Finance

Professor of Finance at the Jack Welch College of Business at Sacred Heart University and Associate Instructor

Chris Bishko

CFO

CFO with over 25 years experience as an operator, investor and investment banker in technology and financial services.

Our Alumni

DEMONSTRATE YOU'RE AS GOOD AS THE BEST

By completing The Real Estate Analyst course, you will be able to join our prestigious alumni on LinkedIn alongside hires at the top 4 investment banks. After becoming a member of this elite community, you can unlock exclusive benefits such as course discounts and more.

Frequently Asked Questions

What tech do I need?

Accordion Arrow Icon

Access your course across desktop, laptop, tablet or phone; either via our web portal or the dedicated mobile app. While we have optimized our video quality and size, we recommend a broadband connection to enable uninterrupted video playback. A PDF reader and spreadsheet application are required to open the supporting resources.

Is it right for me?

Accordion Arrow Icon

The Real Estate Analyst is perfect for those with basic modeling, valuation, and excel skills who want to break into the commercial real estate industry, prepare for interviews or an internship or come up the curve quickly in preparation for a new role in commercial real estate, private equity, or investment banking.

Are Financial Edge's courses credible?

Accordion Arrow Icon

The 4 leading investment banks, as rated by the FT, hire us to train their incoming analysts. If you are looking to join the best analysts in the world, why not challenge yourself with the same content and certification with the same Wall Street instructors ready to answer your questions.

Will this course help me land a job as a real estate analyst?

Accordion Arrow Icon

Absolutely. Develop the practical skills needed to impress at interviews, whether you’re looking to break into the industry or change roles within your firm.

How long do I have to complete the Real Estate Analyst course?

Accordion Arrow Icon

We offer lifetime access on all online courses! Fit studying around your schedule. Learn at your own pace with on-demand videos, practical examples to download, and expert instructor support.

Are there any hidden costs?

Accordion Arrow Icon

No. Everything you need to earn your micro-degree is included, from instructor-led videos and Excel exercises to the exam.

What is CPD?

Accordion Arrow Icon

All Financial Edge online courses are CPD accredited. CPD stands for Continuing Professional Development and makes demonstrating your commitment to learning easy. Your institution or accrediting body may track CDP points through activities, units or hours. Check with the relevant party to find out how you should be monitoring your progress.