Pro Forma Cash Flow Statement Modeling with Projected NOI

Hello! Welcome back.

In our last lesson, we constructed a multi-year projection of Net Operating Income (NOI) by forecasting rental income and operating expenses with specific growth assumptions. We established that NOI is the fundamental measure of a property's operational profitability, independent of financing or taxes.

However, as an investor, your ultimate concern is the cash that actually flows into and out of your bank account. This lesson bridges the gap between the property's income and your own. Our learning outcome is to model a multi-year pro forma cash flow statement, including projected NOI. We will take our NOI forecast and incorporate the "below the line" items—Capital Expenditures and Debt Service—to arrive at the Pre-Tax Cash Flow.

1. From Property Profitability to Investor Cash Flow

The pro forma cash flow statement is a financial narrative of your investment. We've already written the first part of the story: how the property itself performs. Now, we add the chapters about how you, the investor, finance and maintain it over the long term.

These additional cash flows are called "below the line" items because they are accounted for after NOI has been calculated. The primary items are:

• Capital Costs: Major investments to maintain or improve the property (CapEx).
• Financing Costs: The mortgage payments (debt service).

Subtracting these from NOI gives us the cash flow available to you as the equity holder before paying income taxes.

To visualize this structure, let's turn to the "Mergers & Inquisitions" video, which provides a clear, high-level map of the cash flow waterfall.

2. Modeling Capital Expenditures (CapEx)

As we learned in Module 1, Capital Expenditures are significant, infrequent costs that improve a property or extend its life, such as replacing a roof or renovating a kitchen. They are not operating expenses and are therefore excluded from the NOI calculation.

However, they are very real cash outflows. In a multi-year pro forma, we must account for them. There are two primary ways to model CapEx:

1. Lump-Sum Method: If you have a specific capital plan (e.g., renovating kitchens in Year 3 for €20,000), you would model this as a single large cash outflow in that specific year. This is accurate but can make cash flow appear very volatile.
2. CapEx Reserve Method: This is the standard for professional analysis. Instead of modeling large, irregular outflows, you budget a consistent annual amount called a "CapEx Reserve." This amount is an estimate of the average annual cost of future capital projects. It's typically calculated as a fixed amount per unit (e.g., €250/unit/year) or as a percentage of the property's value or effective gross income. This method smooths the projected cash flows, providing a more stable and realistic picture of long-term performance.

For a detailed explanation of the different types of capital costs you'll encounter, the following clip is very useful.

In our pro forma, we will subtract this annual CapEx reserve from NOI. The result is often called Adjusted NOI or Cash Flow Before Debt Service.

3. Modeling Debt Service

In Module 2, you learned how to calculate the mortgage payment, or debt service, for a property loan in Spain. Now, we integrate this into our annual cash flow statement.

• Annual Debt Service = Monthly Mortgage Payment × 12

A crucial point for a fixed-rate mortgage is that this annual payment remains constant for the entire loan term. This creates a powerful dynamic: while your rental income and even your operating expenses are projected to grow with inflation, your largest single cash outflow—the mortgage—stays fixed. This is one of the primary ways leverage generates wealth in real estate.

The following video, focused on the Spanish market, excellently illustrates this exact point.

4. Assembling the Complete Pro Forma Statement

We now have all the components to build our complete pro forma cash flow statement, from revenue down to the cash flow before taxes.

The structure is a waterfall:

1. Start with Effective Gross Income (EGI).
2. Subtract Total Operating Expenses.
3. This gives you Net Operating Income (NOI).
4. Subtract the Annual CapEx Reserve.
5. This gives you Cash Flow Before Debt Service (or Adjusted NOI).
6. Subtract the Annual Debt Service.
7. The result is your Pre-Tax Cash Flow (CFBT).

The following article provides a step-by-step guide to building this waterfall in a spreadsheet. It's an excellent blueprint for how to structure your own models.

Example Pro Forma (Continuing from Last Lesson)

Let's expand the table from our previous lesson to include the "below the line" items.

• New Assumptions:
  • Loan Amount: €300,000 at 3.5% for 30 years. Annual Debt Service = €16,160.
  • CapEx Reserve: €2,000 per year, growing at 2% annually.

Line Item	Year 1	Year 2	Year 3	Year 4	Year 5
Effective Gross Income (EGI)	€95,000	€97,850	€100,785	€103,809	€106,923
- Total Operating Expenses	(€16,750)	(€17,133)	(€17,524)	(€17,924)	(€18,336)
= Net Operating Income (NOI)	€78,250	€80,717	€83,261	€85,885	€88,587
- CapEx Reserve	(€2,000)	(€2,040)	(€2,081)	(€2,122)	(€2,165)
= Cash Flow Before Debt Service	€76,250	€78,677	€81,180	€83,763	€86,422
- Annual Debt Service	(€16,160)	(€16,160)	(€16,160)	(€16,160)	(€16,160)
= Pre-Tax Cash Flow (CFBT)	€60,090	€62,517	€65,020	€67,603	€70,262

You can clearly see how the Pre-Tax Cash Flow grows each year, driven by increasing NOI and a fixed debt payment.

Test your understanding!

In the last lesson's exercise, you calculated the projected NOI for Year 2 to be €34,062.

Now, let's add the "below the line" items for that same property:

• You secured a mortgage with a fixed annual debt service of €18,000.
• You decide to budget a CapEx reserve of €1,500 for Year 1, which you will increase by 3% per year.

What is the projected Pre-Tax Cash Flow (CFBT) for Year 2?

Show answer

1. Start with Year 2 NOI: €34,062 (from previous lesson's exercise)
2. Calculate Year 2 CapEx Reserve:
   • Year 1 Reserve = €1,500
   • Year 2 Reserve = €1,500 * (1 + 0.03) = €1,545
3. Calculate Cash Flow Before Debt Service:
   • €34,062 (NOI) - €1,545 (CapEx) = €32,517
4. Calculate Pre-Tax Cash Flow:
   • €32,517 (Cash Flow Before Debt) - €18,000 (Annual Debt Service) = €14,517

The Pre-Tax Cash Flow for Year 2 is €14,517.

Conclusion

In this lesson, we completed the journey from a property's operational income to the investor's pre-tax cash flow. By modeling a full multi-year pro forma statement, you have created the core financial forecast for any real estate investment. This statement is the foundation upon which nearly all major investment decisions and return calculations are built.

Key Takeaways:

• A complete pro forma cash flow statement extends from revenue down to Pre-Tax Cash Flow (CFBT).
• "Below the line" items, like CapEx and debt service, are subtracted from NOI to determine the cash flow to the equity investor.
• Modeling a CapEx reserve is a professional standard that smooths out long-term cash flow projections.
• The contrast between inflating rental income and a fixed mortgage payment is a fundamental driver of cash flow growth in leveraged real estate.

Preview of the Next Lesson:
Our pro forma now projects the annual cash flows during the holding period. But a major part of your return comes from selling the property. In our next lesson, we will learn how to calculate the reversion value (projected sale price) at the end of the holding period. This is the final major cash flow component needed before we can calculate total investment returns like NPV and IRR.