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 Levered Cash Flows

  • Notes
  • Questions
  • Transcript
  • 07:43

Calculate the levered cash flows

Downloads

10. Real Estate Investing Model Levered Cash Flows Empty10. Real Estate Investing Model Levered Cash Flows Full

Glossary

Mezzanine Mortgage Loan
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

Let's now take a look at the levered cash flows. The first thing we need to consider is that we're now only dealing with the cash flows to the equity stakeholders, so we need to be netting out any of the debt cash flows. The first thing that we'll deal with are the funds provided by the debt stakeholders for the initial purchase. So we have to put the term loan or the mortgage loan in here in year zero as being funds provided by the debt stakeholders, and that's going to be equal to the loan balance at the beginning of the loan, or we could go to the deal terms, and get the amount from the sources and uses. It's really the same thing as well as the mezzanine. The debt fees we only have at this point on the deal terms page so it will be the sum of the loan fees for the term loan as well as the mezzanine loan fees. Now these are actually going to be negative because they are not funding being provided, but they're actually transaction cost similar to the closing costs. So again, we're gonna be copying these forward and we also need to take into consideration the debt repayment at the sale of the transaction. So we're gonna need to link all of these amounts to the actual date that we are in. So in terms of the term loan in the mezzanine, what we have to do here is, again, we don't want this showing as being provided in year one 'cause all that we'll do is simply copy the current balance. We only want this to show up if the debt is going to be paid off in that year. So what we have to do is we have to actually create kind of a separate formula for this. The debt fees are only getting paid once, so let's take care of those first. Those aren't gonna come up again because they're only on issuance. So those are gonna be linked to the year that we're in, and if this is equal to zero, then we wanna show the debt fees, if not, we don't wanna show the debt fees. In terms of whether or not we see debt being repaid from month one through the end of the model, through the end of the forecast period, that is actually going to only be dependent on whether or not we sell the asset. So technically of course we do have to repay the loan, but again, that's really beyond the expected hold period. So again, without over complicating this, what we really wanna show here is that when we actually sell the asset, that the returns to the equity holders are dependent upon paying down the outstanding balance of the debt first. So the easiest way to do that is to simply, again, link to our dates and have that tell us whether or not we should be repaying. So equals if the month that we are in is equal to the exit date as established on the deal terms page, then what we want to see here is the repayment, which is a negative of the outstanding balance of the loan, and in that case, that's going to be the amount that is owed at the end of that year, and what that does, of course, it zeros it out if we are not in the correct month. Now, if we happen to be in the correct month, we should see the repayment of that loan, and we do. So the same thing is going to happen with the mezzanine. In fact, what I'll do is I'll even just be slightly lazy and I'll copy the beginning of that formula, and I'll put that down here. I'll say equals D3 equal to deal term exit month, give me the opposite of the balance of the mezzanine, and the debt fees, of course, should copy across the debt term fees, if we go ahead and anchor ourselves here, this is a formula that we can also copy across, and it shouldn't give us any value ever again. So again, if I change this to month 60, it shows that we're repaying the mezzanine, and we're repaying the term loan. So, what does that mean for the total levered cash flow? So the total levered cash flow is slightly different from the unlevered cash flow because instead of starting with cash flow available before debt service, we need to start with cash flow available after debt service to make sure that we are including any interest in principle payments. So the total levered cash flow here is going to be equal to the cash flow available after debt service. I'll use the sum function, the cash flow available after debt service, net of any of the acquisition costs, et cetera, that were established at the purchase of the building, as well as any proceeds at the sale of the building, netting anything that was provided by the debt stakeholders, and what that will do is it will give us an amount that actually represents, in this case, the amount that the equity holders have invested at this point in the deal, the 115,560. and this amount should match exactly what is on our deal terms as having been invested by the equity holders. So we should now be able to copy that across, and again, it's the same thing that we ran into with the unlevered cash flow, which is to say that we only wanna show cash flow being, flowing to the equity holders if we are before that or at that sale date. We don't wanna show anything beyond that. So what I will do here again is I will copy the terms from my unlevered cash flows and I will bring them down here so that we're saying if we are less than or equal to the deal date of 60 months for the sale of the building then we want to see these cash flows. If we're beyond that, then we wanna see a zero, and if we copy this out again to month 61, we should see that taking place, and we do. Now, one thing that we wanna be careful of, is we wanna make sure that we have all our cash flows correct, So what we see here is that the levered cash flow, in terms of what is flowing to the equity holders, has grown from 115,560, which was the investment, up to 195,725.1, and this simply means that the increased value of the building after the paydown of debt is flowing to the equity holders, and this is the levered cash flows. So these are the residual cash flows that flow to the equity holders and the equity holders, in addition to getting the proceeds at the sale of the building, are also entitled to all the residual cash flows up until then, and this is what we'll look at when we calculate our returns next.

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.