Funds from Operations (FFO): Tutorial + Excel Examples (2024)

Funds from Operations (FFO) Definition: For Equity REITs, FFO equals Net Income + Real Estate-Related Depreciation & Amortization + Losses / (Gains) on Property Sales + Impairments. It is an improved version of Net Income that more accurately represents a REIT’s operating performance and may better indicate the Dividends a REIT can issue, which is critical for its business model.

Here’s an example calculation for AvalonBay, a multifamily REIT in the U.S.:

Funds from Operations (FFO): Tutorial + Excel Examples (1)

As background information, a real estate investment trust (REIT) is a company that buys, sells, develops, and operates properties and complies with very specific requirements to be exempt from corporate taxes (or pay very little in corporate taxes).

For example, U.S.-based REITs must distribute 90% of their Net Income as Dividends and earn 75% of their profits from real estate; also, 75% of their total assets must be real estate-related.

Due to the Dividend requirements, REITs maintain very low Cash balances and must, therefore, raise Debt and Equity constantly to acquire and develop properties.

For REITs, the FFO metric is an improved version of Net Income that more accurately captures their ability to issue Dividends.

Depreciation is a large non-cash expense for REITs, but it does not reduce their cash flow, so FFO adds it back.

Gains and Losses are non-recurring items that get reversed in the FFO calculation because they do not affect a REIT’s long-term ability to issue Dividends.

They do reduce the REIT’s income from properties, but the REIT typically redeploys the proceeds from these sales into new properties and makes up for it like that.

FFO does not “replace” traditional cash flow metrics such as Free Cash Flow (FCF) or Unlevered Free Cash Flow (UFCF).

It is a more relevant version of Net Income designed for the specific business nuances of REITs.

You can see the differences between FFO, FCF, and UFCF in this chart below for AvalonBay:

Funds from Operations (FFO): Tutorial + Excel Examples (2)

Files & Resources:

Funds from Operations – AvalonBay Calculations and Public Comps (XL)

Funds from Operations – Slides (PDF)

AvalonBay – 10-K Excerpts for FFO Calculation (PDF)

Vicinity Centres – Annual Report Excerpts for FFO Calculation (PDF)

Full Annual Reports – AvalonBay | Vicinity Centres

Video Table of Contents:

  • 0:00: Introduction
  • 4:20: Part 1: Why We Use FFO for REITs
  • 6:42: Part 2: Using FFO to Value REITs in Real Life
  • 8:19: Part 3: IFRS vs. U.S. GAAP Differences
  • 9:52: Part 4: FFO vs. FCF vs. NOI
  • 11:48: Part 5: AFFO and Other Variations of FFO
  • 13:20: Recap and Summary

Using Funds from Operations (FFO) to Value REITs in Real Life

In REIT valuation, you can use standard metrics and multiples such as EBITDA and TEV / EBITDA.

However, instead of Net Income and the P / E multiple, you should use Funds from Operations and the P / FFO multiple (Price per Share / FFO per Share or Equity Value / FFO).

If a REIT is growing its FFO more quickly than other, similar REITs, it should, in theory, trade at a higher FFO multiple.

In this set of public comps for AvalonBay, we see this expected, boring result:

Funds from Operations (FFO): Tutorial + Excel Examples (3)

In reality, this relationship between growth rates and multiples doesn’t always hold up for REITs because factors like leverage, development/acquisition activities, and focus geography also play big roles.

FFO multiples often vary more by REIT sub-sector (e.g., office vs. industrial vs. apartment) than by specific growth rates, especially since most REITs grow in a narrow range.

Outside of valuation, many investors and analysts also use FFO to benchmark REITs and compare their operational efficiency, profitability, and dividend-paying potential.

IFRS vs. U.S. GAAP Differences in the Funds from Operations Calculation

Under IFRS rules, REITs do not depreciate their properties; instead, they periodically revalue them and record the Unrealized Gains and Losses from these revaluations on their financial statements.

So, for non-U.S. REITs, we must adjust for both Realized and Unrealized Gains/Losses when calculating FFO to ensure it accurately reflects the operational performance.

There is no Depreciation add-back, but the adjustment for Gains and Losses is even bigger because Realized and Unrealized Gains and Losses are included.

Here’s an example for Vicinity Centres, an Australian REIT:

Funds from Operations (FFO): Tutorial + Excel Examples (4)

In other regions, REITs often use variations on FFO.

For example, many European REITs use EPRA Earnings, which is similar to FFO, but with these Unrealized Gains and Losses in place of Depreciation and additional adjustments for Deferred Taxes and a few other items.

Funds from Operations vs. Free Cash Flow

Free Cash Flow (FCF) more accurately represents the ongoing cash-flow generation of any company, including REITs, because it fully deducts Capital Expenditures (CapEx) and reflects the Change in Working Capital.

Free Cash Flow is normally defined like this:

FCF = Net Income + Depreciation & Amortization + Losses / (Gains) + Impairments +/- Change in Working Capital – CapEx

Because of this deduction for CapEx, which is always high for REITs, FCF is always significantly lower than FFO.

Here’s a full comparison for AvalonBay:

Funds from Operations (FFO): Tutorial + Excel Examples (5)

Since property acquisitions, developments, redevelopments, and sales are all recurring activities core to the business, they should all be part of a REIT’s CapEx.

Unlevered Free Cash Flow (UFCF) is similar in many ways since it also fully deducts CapEx; the difference is that it adds back the Net Interest Expense so that it’s capital structure-neutral:

Funds from Operations (FFO): Tutorial + Excel Examples (6)

Technically, we should adjust the Taxes for this Interest Expense add-back as well, but since they’re negligible for AvalonBay here, we don’t bother with that.

Funds from Operations (FFO) vs. Net Operating Income (NOI)

Funds from Operations (FFO) and Net Operating Income (NOI) are both important metrics for REITs, but they are calculated differently and represent different aspects of a REIT’s performance.

NOI is a property-level metric representing the total income generated from a REIT’s properties minus the cash operating expenses incurred, such as insurance, property taxes, management fees, and the sales and marketing required to attract new tenants.

It does not factor in the REIT’s corporate-level expenses, such as administrative costs, management fees, executive salaries, depreciation on the properties, or the interest payments on debt:

Funds from Operations (FFO): Tutorial + Excel Examples (7)

NOI is similar to EBITDA but for properties rather than normal companies.

FFO, on the other hand, is calculated at the trust or corporate level.

Since FFO deducts the REIT’s interest expense and corporate overhead, it’s always lower than NOI and more representative of the REIT’s Dividend-paying capacity.

Adjusted Funds from Operations (AFFO) and Other Variations

While Funds from Operations (FFO) is an “improved version of Net Income,” Adjusted Funds from Operations (AFFO) builds on FFO and brings it closer to the REIT’s “true cash flow.”

The exact definition of AFFO varies, but one common calculation method is as follows:

Adjusted Funds from Operations (AFFO) = FFO – Recurring Maintenance CapEx +/- Amortization of Lease Intangibles and Straight-Lining of Rent +/- Other Adjustments.

AFFO subtracts the recurring maintenance CapEx because this represents the ongoing spending the REIT needs to maintain its current properties and continue earning from them.

The Amortization of Lease Intangibles is an acquisition-related item with no cash impact, and the Straight-Lining of Rent is a common adjustment for office/retail/industrial properties related to rent recognized vs. cash payments received.

(Office, retail, and industrial properties usually use multi-year leases where the cash payments increase each year, but they recognize the rent evenly over each year of the lease term, which creates a difference in revenue recognized vs. cash revenue.)

AFFO may also add back or adjust for other non-recurring items in the last part of the formula (“Other Adjustments”).

Here’s an example of the AFFO calculation for Vicinity Centres in Australia:

Funds from Operations (FFO): Tutorial + Excel Examples (8)

While AFFO is closer to the “true cash flow” than FFO, it’s still far above actual Free Cash Flow because:

  • AFFO does not factor in the Change in Working Capital, but FCF does.
  • AFFO does not subtract Growth CapEx (i.e., spending on developing or acquiring new properties), while FCF does.

The other issue is that AFFO is a “non-standard” metric, and each REIT calculates it differently.

This makes a proper comparison difficult unless you go to the REIT’s statements and calculate AFFO manually in the same way for each REIT in your set.

Final Thoughts on Funds from Operations (FFO)

While Funds from Operations (FFO) is a critical metric for REITs that always factors into 3-statement models and valuations, it’s not the only metric you care about.

Free Cash Flow and EBITDA remain important, and other REIT-specific metrics, such as NOI and AFFO, are also useful.

As with any other metric, the key with FFO is to understand its uses, advantages, and disadvantages to interpret it properly.

Premium Course Signup

Funds from Operations (FFO): Tutorial + Excel Examples (9)

About Brian DeChesare

Brian DeChesare is the Founder of Mergers & Inquisitions and Breaking Into Wall Street. In his spare time, he enjoys lifting weights, running, traveling, obsessively watching TV shows, and defeating Sauron.

Funds from Operations (FFO): Tutorial + Excel Examples (2024)

FAQs

How do you calculate FFO funds from operations? ›

FFO is calculated by adding depreciation, amortization, and losses on sales of assets to earnings and then subtracting any gains on sales of assets and any interest income. It is sometimes quoted on a per-share basis.

What is an example of funds from operations? ›

For example, for a company selling jewellery, income from investments or a one-time sale of a fixed asset could be considered non-operating income. Removing such non-operational transactions gives you the funds from operations.

How do you prepare funds from operations? ›

Therefore, to calculate funds from operations, one must deduct any interest income and non-recurring gains from the net income. Then they must add back interest expense, losses from the sale of assets, and depreciation & amortisation to the net income.

What is the formula for funds from operations to debt ratio? ›

FFO-to-Debt = FFO / Total debt

A type of leverage ratio which measures a firm's FFO to its total debt. A higher ratio indicates more cash flow to service debt, and hence lower credit risk.

What is the formula for adjusted funds from operations? ›

Though no one official measure exists, an AFFO formula is along the lines of AFFO = FFO + rent increases - capital expenditures - routine maintenance amounts.

Is FFO the same as Ebitda? ›

Funds From Operations is similar to free cash flow. It describes the amount of income a company produces before deprecation expenses and income tax. It differs from EBITDA because it does not exclude interest expenses.

Why use funds from operations? ›

Any operating results computed when using the cost accounting method do not usually serve as an accurate measurement of performance. Real estate companies use FFO as a more accurate operating performance benchmark. Investors also use this metric to determine the financial performance of a real estate company.

What is the difference between funds from operations and net profit? ›

Net gain or benefit is the cash that remains with an organisation after deducting every single cost. Cash flow from operating activities is the cash that streams all through an organisation for its different exercises and business activities.

Is FFO the same as CFO? ›

However, the FFO metric neglects changes in working capital and other discretionary cash flow adjustments. Cash from Operations (CFO) → The funds from operations (FFO) metric is similar – yet still not identical – to cash from operations (CFO).

What is a good FFO to debt ratio? ›

For corporations, the credit agency Standard & Poor's considers a company with an FFO to total debt ratio of more than 0.6 to have minimal risk.

What is a good FFO for a REIT? ›

REITs tend to have higher-than-average payout ratios, and 70–80% of FFO is common. But if this percentage is too close to (or higher than) 100%, a dividend cut could be on the horizon.

What is a good cash from operations to debt ratio? ›

However, a healthy ratio would generally fall between 1.0 and 2.0, with anything above 2.0 being considered very strong. This indicates that the company has more than enough operational cash flow to cover its total debt.

What is the formula for operating funds ratio? ›

The operating ratio is calculated by dividing a company's total operating costs by its net sales. Sales represent the starting line item of the income statement (“top line”), whereas operating costs refer to the routine expenses incurred by a company as part of its normal course of operations.

What is price to funds from operations ratio? ›

P/FFO measures the ratio of the share price to the mean cash flow from operations. A high ratio suggests that the stock is priced higher compared to the company's cash flow - a sign of high investor confidence. Nevertheless, a high ratio also suggests that a stock may be overpriced.

Is FFO the same as operating income? ›

Net Operating Income (NOI) → While funds from operations (FFO) provide a levered measure of profit after taxes and overhead, net operating income (NOI) provides a pure, property-level measure of profit.

How do you calculate total cash flow from operations? ›

The cash flow from operations can be calculated in this way:
  1. Cash flow from operations = Funds from operations + changes in working capital.
  2. Funds in operations = Net income + depreciation + amortisation + deferred taxes + investment tax credit + other funds.
Sep 11, 2022

Top Articles
Latest Posts
Article information

Author: Dean Jakubowski Ret

Last Updated:

Views: 5524

Rating: 5 / 5 (70 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Dean Jakubowski Ret

Birthday: 1996-05-10

Address: Apt. 425 4346 Santiago Islands, Shariside, AK 38830-1874

Phone: +96313309894162

Job: Legacy Sales Designer

Hobby: Baseball, Wood carving, Candle making, Jigsaw puzzles, Lacemaking, Parkour, Drawing

Introduction: My name is Dean Jakubowski Ret, I am a enthusiastic, friendly, homely, handsome, zealous, brainy, elegant person who loves writing and wants to share my knowledge and understanding with you.