An AFFO calculator works out the adjusted funds from operations of a real estate investment trust, or REIT, a measure of the cash it earns from running its properties. Enter the net income and the adjustments, and the calculator gives the funds from operations and the AFFO. It uses a simplified two-step model that is our own working, built on the idea that FFO adds depreciation and amortization to net income and removes gains on property sales. [2][1] It runs in your browser and nothing you enter is sent anywhere.
How to use the AFFO calculator
- Enter the net income and the depreciation and amortisation.
- Enter any gains and losses from property sales, and the interest income.
- Enter the rent increases, the capital expenditures and the routine maintenance.
- Press Work out AFFO.
The two formulas
In this model the funds from operations are the net income, plus the depreciation and amortisation, plus the losses on property sales, minus the gains on property sales, minus the interest income. The AFFO is then the FFO plus the rent increases, minus the capital expenditures, minus the routine maintenance. The first step takes out items that are not part of running the properties, such as one-off sales and interest, and adds back the depreciation, which is a cost that does not use cash. Nareit's definition starts from net income, excludes gains and losses from sales of property, and adds depreciation and amortization. [1] The second step then adjusts for the cash that the properties really need.
Worked example
Our worked example is a REIT with a net income of 500,000, depreciation and amortisation of 150,000, losses of 80,000 and gains of 125,000 on property sales, and interest income of 75,000. The FFO is 500,000 plus 150,000 plus 80,000 minus 125,000 minus 75,000, which is 530,000. With rent increases of 50,000, capital expenditures of 60,000 and routine maintenance of 35,000, the AFFO is 530,000 plus 50,000 minus 60,000 minus 35,000, which is 485,000. In a simpler case, an FFO of 1,000 with a rent increase of 500 and no other adjustments gives an AFFO of 1,500.
Why AFFO is used
REITs pay out most of their income as dividends, and net income can be a poor guide to the cash they have to pay them from, because depreciation lowers the profit even though it costs no cash. FFO adds depreciation back, and AFFO goes a step further by subtracting the money that must be spent to keep the buildings in good condition. Nareit's discussion paper notes that analysts commonly deduct recurring capital spending from FFO to reach AFFO. [1] Investors therefore often compare the dividend with the AFFO, rather than with the net income.
Limits of this model
AFFO can be negative, and there is no single good value, so compare it with that of similar companies. The paper does not define AFFO, and companies calculate it in different ways. The FFO formula here also differs from the Nareit definition, which excludes gains and losses from debt restructuring and property sales and does not take off interest income. [1] For that reason, treat the result as a simplified model, and use the figures reported by the REIT when you need the official ones. Our FFO calculator may be closer to the standard.
Per-share figures
REITs often quote AFFO per share. To get it, divide the AFFO by the number of shares outstanding. This calculator does not include the number of shares. You can divide the result yourself.
Reading the result
The calculator shows the AFFO and the FFO. The FFO is the first step, and the AFFO is the final result after the adjustments for rent, capital spending and maintenance. A bigger AFFO means that the REIT has more cash left over, in this model, to pay dividends and to grow. If the AFFO is negative, the REIT is spending more on its buildings than it earns from them in that period.
Comparing REITs
To compare two REITs, run the calculator for each with the figures for the same period, and divide each AFFO by the number of shares to get the figure per share. You can then compare it with the dividend paid per share, which shows how much of the AFFO is paid out. A dividend that is close to or above the AFFO per share may be hard to keep up. Because there is no universal good value of AFFO, compare REITs of the same type.
Where the figures come from
Take the net income and the other figures from the income statement and the cash flow statement of the REIT, and from its supplementary reports, where it lists its capital expenditures and its gains and losses on sales. Companies may define some of the items in their own ways, so read the notes to the accounts. Use the same period, such as a quarter or a year, for every input.
Common mistakes
- Subtracting gains twice. Enter gains as a positive number, and the formula takes them off.
- Leaving out the capital expenditures. They reduce the AFFO.
- Using different periods. Use the same period for every figure.
- Comparing with the wrong peers. Compare REITs of the same kind.
What next
Use this often? Add AFFO to your Home screen.
Frequently asked questions
What is an AFFO calculator?
A tool that works out the adjusted funds from operations of a REIT from its net income and a list of adjustments.
What is the AFFO formula?
AFFO = FFO + rent increases − capital expenditures − routine maintenance.
What is the FFO formula in this calculator?
FFO = net income + depreciation and amortisation + losses − gains − interest income.
What is the AFFO in the worked example?
485,000, from an FFO of 530,000, plus 50,000, minus 60,000 and 35,000.
Is this the official FFO?
No. The formula here is simplified and differs from the Nareit definition, so check the REIT's own reports.
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.