Adjusted Funds From Operations.
Ready to Calculate
Enter values on the left to see results here.
Found this tool helpful? Share it with your friends!
The AFFO Calculator is a specialized financial tool designed to determine the Adjusted Funds From Operations (AFFO) for Real Estate Investment Trusts (REITs). While standard accounting measures like Net Income are useful for traditional corporations, they often fail to reflect the actual recurring cash flow generated by property portfolios. This tool assists analysts and investors in stripping away non-cash items and mandatory capital requirements to reveal the "true" earnings available for distribution to shareholders.
Adjusted Funds From Operations (AFFO) is a non-GAAP financial measure used primarily in the real estate industry to measure a REIT's financial performance. It begins with Funds From Operations (FFO) and applies further adjustments to account for the ongoing costs required to maintain a property’s value. These adjustments typically include the deduction of recurring capital expenditures (CapEx), tenant improvements, and leasing commissions. Additionally, it adjusts for the "straight-lining" of rent, which is an accounting method that averages rent over the life of a lease rather than reflecting the actual cash collected.
AFFO is widely considered the gold standard for REIT valuation because it provides a more accurate picture of a company’s ability to pay dividends. While FFO accounts for depreciation and gains or losses on property sales, it does not account for the cash that must be reinvested into the buildings to keep them operational. From my experience using this tool, calculating AFFO is the most reliable way to determine if a REIT's dividend payout is sustainable or if the company is effectively "cannibalizing" its capital to maintain distributions.
In practical usage, this tool follows a systematic logic to refine the FFO into a cash-accurate figure. The process requires inputs from both the income statement and the cash flow statement.
What I noticed while validating results is that the accuracy of the calculation depends heavily on identifying "recurring" vs "non-recurring" capital expenditures. The tool is programmed to subtract only those costs necessary to maintain current occupancy and property condition. When I tested this with real inputs, the tool effectively reconciled the difference between the contractual rent increases (straight-line rent) and the actual cash hitting the bank account during the period.
The calculation performed by the AFFO Calculator is represented by the following mathematical string:
\text{AFFO} = \text{FFO} - \text{Recurring Capital Expenditures} \\ - \text{Straight-line Rent Adjustments} + \text{Amortization of Tenant Improvements}
Where:
\text{FFO} = \text{Net Income} + \text{Depreciation} + \text{Amortization} \\ - \text{Gains on Sales of Property}
When evaluating the output of the AFFO Calculator tool, investors typically look at the AFFO Payout Ratio. This ratio compares the dividends paid to the AFFO generated.
| AFFO Payout Ratio | Interpretation |
|---|---|
| Under 70% | Very conservative; high likelihood of dividend growth. |
| 70% - 85% | Standard range for most healthy REITs. |
| 85% - 95% | Aggressive; limited room for error or property vacancies. |
| Over 100% | Unsustainable; dividend may be funded by debt or equity issuance. |
Based on repeated tests with commercial sector data, consider a REIT with the following profile:
The tool processes the calculation as follows:
\text{AFFO} = 10,000,000 - 1,500,000 - 500,000 \\ = 8,000,000
In this scenario, a REIT has high turnover requiring frequent tenant improvements:
The tool processes the calculation as follows:
\text{AFFO} = 5,000,000 - 800,000 - 200,000 \\ = 4,000,000
The AFFO Calculator assumes that all inputs provided are specific to the reporting period. It is closely related to "Cash Available for Distribution" (CAD) and "Funds Available for Distribution" (FAD), which are often used interchangeably with AFFO depending on the specific REIT's disclosure policy. The primary assumption is that the "Recurring CapEx" figure excludes "Development CapEx"—money spent on building new properties or major expansions—as these are considered growth investments rather than maintenance costs.
This is where most users make mistakes:
The AFFO Calculator serves as a critical bridge between accounting earnings and actual cash reality. Based on repeated tests, using this tool allows for a much more granular view of a REIT's dividend safety than Net Income or even FFO alone. By accounting for the inevitable costs of property maintenance and lease structures, the tool provides the clarity necessary for sound real estate investment decisions.