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 - Forecasting

Understand the types of assets in commercial real estate, measuring real estate, lease types, rental revenues, OpEx and CapEx, and how income taxes are accounted for in commercial real estate.

Unlock Your Certificate   
 
0% Complete

15 Lessons (33m)

Show lesson playlist
  • Description & Objectives

  • 1. Introduction to Real Estate

    01:37
  • 2. Measuring Real Estate

    02:09
  • 3. Pro Rata Workout

    01:56
  • 4. Lease Types

    01:46
  • 5. Base Year Stop Workout

    06:29
  • 6. The RE Cash Flow Model

    01:42
  • 7. Rental Revenues

    02:10
  • 8. Non-Residential Revenue Workout

    01:45
  • 9. Residential Revenue Workout

    01:33
  • 10. Renewal Probability Workout

    03:55
  • 11. Additional Income and Percentage Rent

    01:49
  • 12. Percentage Rent Workout

    01:37
  • 13. Opex and Capex

    01:57
  • 14. Income Taxes

    01:09
  • 15. Real Estate - Forecasting Tryout


Prev: REITs - Comprehensive REIT Valuation Model (DCF) Next: Real Estate - Financing

Base Year Stop Workout

  • Notes
  • Questions
  • Transcript
  • 06:29

Calculate the amount of expense reimbursement based on tenant terms

Downloads

Base Year Stop Workout EmptyBase Year Stop Workout Full

Glossary

Expense Reimbursements FSG Full Service Gross net operating income Property Maintenance Rental Revenue
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

Real estate investing base year stop workout. We have a workout here for a base year stop, which is going to be implemented in a full service gross lease. If we go to the workout tab, we see that we have a tenant that has a five-year full service gross or FSG lease with a base year stop at year one. We're going to calculate the amount of expense reimbursement for the following tenant terms. So we have some information on the building, the revenue growth, expense growth, tenant square footage, gross leaseable area, et cetera. So the first thing we're gonna need to do is actually calculate the pro rata share of this tenant because they will be paying a percentage of the total building expenses after the base year. So that's simply going to be the tenant square footage divided by the net leaseable area, 13.4. And now we have to build out a little model here, which shouldn't be too difficult. We're just going to calculate the revenues going forward, as well as the expenses going forward based on the growth rate above. So the revenue calculation will be the revenue times one plus the revenue growth for the building and we can copy that across. And then the expense reimbursement for this tenant is what we're going to calculate. So we need to actually hold off on this for a minute and calculate our expenses. So we have our total operating expenses in year one, and then our net operating revenue will be the total revenue. Once we have that, less the operating expenses and we probably can just go in here and fill this out as well. And what's going to happen with these expenses is that they're also going to grow by three and a half percent per year. So it's going to be the previous year times one plus the building expense assumption. And if we anchor that in terms of the row and the column, we'll be able to actually calculate this for all of our expenses going down. And then, we can also copy across, calculate as well our total expenses and our net operating income. So now what's going to happen is the expense reimbursement is going to be equal to simply the difference between each of these operating expenses in their second year compared to their base stop year. Every year, they will simply have to pay that difference. And so in the first year, we're not going to pay anything. So the first thing we have to do here is we have to link our formula to the year that we're in, so that we know that if we're in year one, which is our base stop year, we're not paying anything. And then if we are in years two, three, four and five, the difference between the sum of the expenses in that year over the base stop year is what we will be applying our pro rata share to. So the first thing we'll do here is we'll do an if statement that says if, and I've named some of these cells. So we'll do equals base year equals zero, then zero. We don't want anything in that year. If we're not in the base year, then what's going to happen is we need the sum of the expenses in the year that we're in minus the sum of the base year expenses. And that difference times our pro rata share is going to give us the amount that this particular tenant must reimburse the landlord for. So it's going to be the sum of the expenses in the year that we're in, and these are going to float to the right as we copy to the right, minus the sum of the base year and those are going to be anchored. So I'll anchor them at the end. And I'm gonna close off the parenthesis here so that it does that calculation first. And now, here's where I'm going to apply the pro rata amount to and the pro rata cell has been named. So we can simply just link to that, not have to worry about absolute referencing it. I do have to go back and absolute reference the second summation because this summation is going to stay and then this summation will need to float. So if I copy this across, I should get the correct... If we look, it's taking the amount that it's over the base stop each year and it's applying the pro rata expense to that, so that the landlord is being reimbursed for expense growth.

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.