Skip to content
Felix
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
  • Ask An Instructor
  • Support
  • Log in
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
Felix
  • Data
    • Company Analytics
    • My Filing Annotations
    • Market & Industry Data
    • United States
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
    • Europe
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
  • Models
  • Account
    • Edit my profile
    • My List
    • Restart Homepage Tour
    • Restart Company Analytics Tour
    • Restart Filings Tour
  • Log in
  • Ask An Instructor
    • Email Our Experts
    • Felix User Guide
    • Contact Support

REITs - Building a REIT Operating Model

Learn the steps to building a working REIT operating model.

Unlock Your Certificate   
 
0% Complete

13 Lessons (59m)

Show lesson playlist
  • Description & Objectives

  • 1. REIT Operating Model Revenues & Costs

    04:31
  • 2. REIT Operating Model Acquisitions

    03:41
  • 3. REIT Operating Model Develop Redevelop

    05:01
  • 4. REIT Operating Model Asset Disposals

    04:02
  • 5. REIT Operating Model Income Statement

    04:06
  • 6. REIT Operating Model Fixed Assets

    03:31
  • 7. REIT Operating Model Equity Investments

    03:38
  • 8. REIT Operating Model NCI

    03:39
  • 9. REIT Operating Model Balance Sheet

    03:12
  • 10. REIT Operating Model Dividends

    03:09
  • 11. REIT Operating Model Cash Flow Statement

    05:17
  • 12. REIT Operating Model Debt and Equity

    08:17
  • 13. REIT Operating Model Final Steps

    05:41

Prev: REITs - Capitalization Rates Next: REITs - REIT Valuation

REIT Operating Model NCI

  • Notes
  • Questions
  • Transcript
  • 03:39

Modeling the NCI on the balance sheet and income statement

Downloads

REIT Operating Model NCI_EmptyREIT Operating Model NCI_Full

Glossary

NCI Non controlling interests Real Estate Finance Real Estate modeling REIT Analysis REIT modeling REIT operating model REIT Valuation REITs
Back to top
Financial Edge Training

© Financial Edge Training 2025

Topics
Introduction to Finance Accounting Financial Modeling Valuation M&A and Divestitures Private Equity
Venture Capital Project Finance Credit Analysis Transaction Banking Restructuring Capital Markets
Asset Management Risk Management Economics Data Science and System
Request New Content
System Account User Guide Privacy Policy Terms & Conditions Log in
Transcript

REIT operating model, part eight, non-controlled investments or NCI. On the Calculations tab, we have another section below the equity co-investment beginning in row 45 for the non-controlling interest. And again, these are buildings that we've purchased a controlling stake, but not 100%. The building itself and its earnings have been consolidated into our earnings, but we are setting aside a portion to show the amount that we do not actually own. So again, we have a couple of assumptions here. Basically, the way this would work is not unlike the equity co-investment. We have an assumption for the net income attributable to the non-controlling interest, and then we also have any distributions that might be paid out. Now, in this situation, we are showing the distributions. It just depends on the building itself. If it is part of the REIT, and the REIT is paying distributions, then we would have to make some assumptions about distributions for that particular asset. But this is where it starts to get complicated. So I am showing the distributions here because this is a building that is controlled by a REIT and the REIT does pay distributions. Therefore, it is only logical that we assume that there are distributions going to the original owners of the building that are going to the non-controlling stakeholders of the building. So as far as calculating the net income is concerned, we have to go to the operating model. And we have an assumption in row 11 that says the net income attributable to NCI is growing at 3% per year. So we have two options here, and it's really just a matter of preference to calculate this on the operating model or to bring everything back to the calculations tab. There really isn't a right answer here. I think because the assumption is on this page, as well as the previous year's NCI income, I'm going to calculate it here. It's going to be one plus the 3% assumption times the previous year's NCI income. I can go ahead and remove the highlighting, Alt + H + H + N. Copy that across. And now I've got my NCI net income into my operating model income statement. So now to go back and finish the NCI calculation, the net income is going to increase the value of the NCI on the balance sheet. So I have to go ahead and link to my operating model to get that number. The beginning NCI balance is again equal to last year's ending NCI balance. And my current year's ending balance is the beginning balance plus the net income attributable to NCI minus any dividends.

And if I copy that across, and again, since my distributions does not change, I'm safe to copy the whole block. I now have my ending balance for the NCI. Now, I have a comment in G49 and I will scroll down so we can see it a little bit better. It says, technically, the NCI will also increase by the percentage of acquisitions that are not 100% owned. And that means that below, we have these assumptions for our acquisitions. And if we were to acquire buildings that we didn't have 100% ownership of, technically, the NCIs would increase by that amount as well. But as you can see, that would get very complicated and definitely beyond the scope of this model. So for this, we're just assuming that all of the acquisitions that we've made down below that have already factored into the model are 100% owned.

Content Requests and Questions

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account
Help

You need an account to contact support.

Create a free account or log in to an existing one

Sorry, you don't have access to that yet!

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

You have reached the limit of annotations (10) under our premium subscription. Upgrade to unlock unlimited annotations.

Find out more about our premium plan

You are trying to access content that requires a free account. Sign up or login in seconds!

Create a free account or log in to an existing one

You are trying to access content that requires a premium plan.

Find out more about our premium plan or log in to your account

Only US listed companies are available under our Free and Boost plans. Upgrade to Pro to access over 7,000 global companies across the US, UK, Canada, France, Italy, Germany, Hong Kong and more.

Find out more about our premium plan or log in to your account

A pro account is required for the Excel Add In

Find out more about our premium plan

Congratulations on completing

This field is hidden when viewing the form
Name(Required)
This field is hidden when viewing the form
Rate this course out of 5, where 5 is excellent and 1 is terrible.
Were the stated learning objectives met?(Required)
Were the stated prerequisite requirements appropriate and sufficient?(Required)
Were the program materials, including the qualified assessment, relevant and did they contribute to the achievement of the learning objectives?(Required)
Was the time allotted to the learning activity appropriate?(Required)
Are you happy for us to use your feedback and details in future marketing?(Required)

Thank you for already submitting feedback for this course.

CPE

What is CPE?

CPE stands for Continuing Professional Education, by completing learning activities you earn CPE credits to retain your professional credentials. CPE is required for Certified Public Accountants (CPAs). Financial Edge Training is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.

What are CPE credits?

For self study programs, 1 CPE credit is awarded for every 50 minutes of elearning content, this includes videos, workouts, tryouts, and exams.

CPE Exams

You must complete the CPE exam within 1 year of accessing a related playlist or course to earn CPE credits. To see how long you have left to complete a CPE exam, hover over the locked CPE credits button.

What if I'm not collecting CPE credits?

CPE exams do not count towards your FE certification. You do not need to complete the CPE exam if you are not collecting CPE credits, but you might find it useful for your own revision.


Further Help
  • Felix How to Guide walks you through the key functions and tools of the learning platform.
  • Playlists & Tryouts: Playlists are a collection of videos that teach you a specific skill and are tested with a tryout at the end. A tryout is a quiz that tests your knowledge and understanding of what you have just learned.
  • Exam: If you are collecting CPE points you must pass the relevant CPE exam within 1 year to receive credits.
  • Glossary: A glossary can be found below each video and provides definitions and explanations for terms and concepts. They are organized alphabetically to make it easy for you to find the term you need.
  • Search function: Use the Felix search function on the homepage to find content related to what you want to learn. Find related video content, lessons, and questions people have asked on the topic.
  • Closed Captions & Transcript: Closed captions and transcripts are available on videos. The video transcript can be found next to the closed captions in the video player. The transcript feature allows you to read the transcript of the video and search for key terms within the transcript.
  • Questions: If you have questions about the course content, you will find a section called Ask a Question underneath each video where you can submit questions to our expert instructor team.