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

Real Estate - Case in Point

Real Estate Case in Point.

Unlock Your Certificate   
 
0% Complete

11 Lessons (75m)

Show lesson playlist
  • Description & Objectives

  • 1. Real Estate Investing Model Deal Terms

    05:43
  • 2. Real Estate Investing Model Calcs Revenues

    08:11
  • 3. Real Estate Investing Model Calcs Opex

    04:24
  • 4. Real Estate Investing Model CF NRR

    04:36
  • 5. Real Estate Investing Model CF Opex

    05:35
  • 6. Real Estate Investing Model CF Expense Reimb

    04:31
  • 7. Real Estate Investing Model CF Capex

    04:02
  • 8. Real Estate Investing Model CF After Debt Service with Debt Calcs

    12:28
  • 9. Real Estate Investing Model Unlevered Cash Flows

    07:09
  • 10. Real Estate Investing Model Levered Cash Flows

    07:43
  • 11. Real Estate Investing Model Returns

    09:50

Prev: Real Estate - Cap Rates and Other Metrics

Real Estate Investing Model CF Opex

  • Notes
  • Questions
  • Transcript
  • 05:35

Calculate the expense reimbursement in cash flow statement

Downloads

5. Real Estate Investing Model CF Opex Empty5. Real Estate Investing Model CF_Opex Full

Glossary

Expense Reimbursements Real Estate Cash Flow
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

The next section of the cash flow statement are the expense reimbursements. These are actual income flows into the landlord or building owner. However, we can't calculate those until we have the operating expenditures calculated. So the next thing we will do is calculate the operating expenditures. We've already done some of the work on the calcs, so we will link to the common area maintenance expenditures on the Calcs page, and that is 31 cents per square foot. This is a monthly charge. However, it is again still in actual dollars and we need to put this in thousands of dollars. So we're gonna take the monthly expenditure and divide by 1,000 and then multiply by the net leaseable area, the total net leaseable area, and that's going to get anchored because it won't change. Once we have that, we can move on to the CAM utilities. The last thing I need to do here is actually flip this to the negative, so that my expenses show up as a negative because this is a cash flow statement and expenses do need to show up as a negative on cash flow statements. This formula is not copyable because we have the row in between each expense for the increase. So we're gonna have to do this the old-fashioned way, which is line by line. Next is the CAM utilities divided by 1,000 times the net leaseable area, and that's a cell we also might want to name perhaps in another model, so that we can just reference the named cell as opposed to having to absolute reference the linked cell. The insurance is going to be equal to the insurance cost per square foot divided by 1,000 times the net leaseable area, times negative one. And the same thing for repairs and maintenance divided by 1,000 times the net leaseable area anchored, going re-anchor this cell as well, times negative one. And now property taxes are going to be not driven by net leaseable area, but they're gonna be driven instead by the property value. So we have a monthly property tax assessment here of 2/10 of a percent. Technically, in terms of cash flows, property taxes are not paid every month. They're paid typically on a schedule, quarterly, semi-annually, perhaps annually. But in order to do this in the most easy way for demonstration purposes, we are going to essentially accrue them each month. So what we'll do here is we'll take the property tax as a monthly percentage and multiply it by the building value, which is on deal terms page. And that is effectively the purchase price and the taxes will go up a little bit each year based on that. And I'm gonna anchor the deal terms price. I know it's possible depending on the location that the building will be assessed every year or perhaps not. So that's just more of a function of where the asset is. And this, of course, is going to be also a negative. Property management fee is next. And this is the fee that is paid either to the owner or landlord if they're the property manager or perhaps it could be paid to a third party. And that's going to be based according to our assumptions on the gross potential rent. So this 1% is going to be applied to the gross potential rent. And this is actually gonna be copyable because the next assumption is also based on GPR. So what we wanna do is we want to let the rows float and anchor the column and then we wanna anchor that to the gross potential revenue where we wanna anchor the row and let the column float, multiplied by negative one. And then we should be able to copy that down correctly so that we pick up the other non-reimbursable expenses. And what I mean by that are that even for triple net leases, which do tend to cover all of the expenses, there are always going to be some expenses that are non-reimbursable. For example, if the building owner has to hire lawyers to handle a situation or the accountants to handle the audits, a lot of those expenses are not gonna be passed along because they're for the owner's purpose, meaning they're for the owner to present to the shareholders. So even in a triple net lease, fully triple net lease building, there are always gonna be some expenses that are non-reimbursable. We can add these up to get our total other income or expense in this situation. And that is now something we can copy across to the end of the model. And it looks as though everything has copied correctly and we'll just see if we're picking up our increases in month 13 and we are, so that gives me good reason to believe that we've done that correctly.

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.