AFFO Calculator — Adjusted Funds From Operations

AFFO Calculator — Adjusted Funds From Operations
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description

Adjusted Funds From Operations Calculator

Reconcile a REIT's reported net income to funds from operations (FFO), then adjust recurring property-level cash requirements to estimate AFFO.

FFO $530,000.00 AFFO $485,000.00 AFFO / FFO 91.51% Net adjustment -$15,000.00

REIT financial inputs

Use one consistent reporting period and currency basis for every field. The starting example uses annual U.S. dollar amounts.

Funds from operations

Start with net income, add back real estate depreciation and qualifying losses, then remove gains and interest income.

GAAP net income; negative values are allowed.
Qualifying real estate depreciation and amortization.
Property-sale gains excluded from recurring FFO.
Property-sale losses added back in the reconciliation.
Non-property interest income removed from this model's FFO.
AFFO adjustments

Adjust FFO for recurring rent changes and property cash needs that are not fully reflected in the FFO subtotal.

Enter a positive increase or negative reversal/decrease.
Recurring capital improvements needed to sustain properties.
Recurring maintenance not already captured as an AFFO deduction.

AFFO reconciliation chart

The chart shows each signed contribution from net income to the final AFFO result.

    The largest positive and negative adjustments are highlighted so the recurring earnings bridge can be reviewed without relying on the chart alone.

    Reconciliation detail

    Stage Line item Treatment Amount Running result
    All rows use the same current-state model as the result cards, chart, accessible summary, and Excel workbook. Negative AFFO is permitted and should be investigated rather than suppressed.

    How to use and interpret the AFFO calculation

    Adjusted funds from operations is a non-GAAP analytical measure used to estimate the recurring funds generated by a real estate investment trust after selected property-level cash requirements. It begins with funds from operations, then adjusts for items such as recurring capital expenditures and maintenance. Because AFFO definitions vary among issuers and analysts, the result is most useful when the same methodology is applied consistently across periods and compared with the company's own reconciliation disclosures.

    What the calculator estimates

    The calculator performs two linked reconciliations. First, it converts net income to FFO by adding depreciation and amortization and property-sale losses, while subtracting property-sale gains and interest income under this model. Second, it converts FFO to AFFO by adding the rent adjustment and subtracting recurring capital expenditures and routine maintenance. The principal formulas are:

    FFO = net income + depreciation and amortization + property-sale losses − property-sale gains − interest income
    AFFO = FFO + straight-line rent adjustments − capital expenditures − routine maintenance

    Industry definitions are not perfectly uniform. Nareit's FFO definition explains why real estate depreciation is commonly adjusted, while its AFFO glossary entry describes AFFO as a recurring or normalized FFO measure after capital improvement funding. Public-company users should reconcile the inputs to the issuer's filed reports and non-GAAP disclosures rather than treating any generic formula as authoritative.

    Field-by-field guidance

    • Net income is the GAAP bottom-line result for the selected reporting period. It is required for a meaningful reconciliation and may be negative. A higher net income generally raises both FFO and AFFO dollar for dollar. Do not mix quarterly net income with annual adjustments.
    • Depreciation and amortization should include the qualifying real estate amounts used in the company's FFO reconciliation. It is normally nonnegative and increases FFO. A common mistake is adding back depreciation that the issuer does not classify as a real estate FFO adjustment.
    • Gains from property sales are entered as a positive amount and deducted. Larger gains lower FFO in this reconciliation because property dispositions are separated from recurring property operations. Do not enter a gain as a negative number.
    • Losses from property sales are entered as a positive amount and added back. Larger losses raise the reconciled FFO, not because the loss is beneficial, but because the property-sale effect is removed from the recurring operating measure.
    • Interest income is deducted under the selected model. Use the same category and scope as the source reconciliation. If an issuer keeps certain interest income in FFO, enter zero here and document the difference outside the calculator.
    • Straight-line rent adjustments capture the selected rent-related normalization. Positive values raise AFFO; negative reversals or rent decreases reduce it. Confirm the sign convention used in the issuer's supplemental package because many published AFFO reconciliations deduct straight-line rent rather than add a broadly labeled rent increase.
    • Capital expenditures represent recurring capital funding needed to maintain the productive capacity of the property portfolio. They reduce AFFO. Separate recurring maintenance capital from acquisitions, development spending, or major expansions unless the chosen methodology explicitly includes them.
    • Routine maintenance captures recurring property upkeep not already included in another deduction. It reduces AFFO. Avoid double counting amounts already included in capital expenditures or operating expenses embedded in net income.

    Understanding every result

    FFO is the intermediate operating measure after the first reconciliation. A positive FFO does not automatically mean the REIT can fully fund dividends, debt service, and recurring property investment. AFFO is the primary output after the selected recurring adjustments. Positive AFFO means funds remain under the entered assumptions; zero indicates the additions and deductions exactly absorb the starting economics; negative AFFO indicates the selected recurring cash requirements exceed the reconciled operating funds.

    AFFO / FFO shows how much of FFO remains after the second-stage adjustments. A ratio below 100% means the net AFFO adjustments are deductive; above 100% means the entered rent adjustment exceeds capital and maintenance deductions. When FFO is zero, the ratio is shown as unavailable rather than producing an infinite or misleading percentage. Total additions aggregates depreciation, property-sale losses, and positive rent adjustments. Total deductions aggregates property-sale gains, interest income, capital expenditures, maintenance, and any negative rent adjustment. Net adjustment is AFFO minus net income.

    Reading the chart and reconciliation table

    The horizontal chart assigns positive adjustments to one color, deductions to another, and the final AFFO result to a distinct outcome color. Bar length represents absolute magnitude, while position around the center line shows direction. The adjacent legend explains the visual roles, and the exact-value list provides the underlying amounts for users who cannot or prefer not to interpret the graphic. The table presents the same model as a running bridge: each row shows the stage, treatment, signed amount, and cumulative result. The FFO subtotal and final AFFO row are emphasized for faster review. p>

    Practical comparison and common limitations

    Use consistent reporting periods, currencies, consolidation scopes, and sign conventions. Compare AFFO with prior periods, management guidance, dividends, and debt obligations only after checking how the issuer defines its adjustments. The SEC's REIT investor bulletin provides general background on publicly traded REITs, and the SEC's REIT disclosure guidance discusses the sector's reporting context. AFFO is not a substitute for GAAP cash flow, liquidity analysis, property-level net operating income, leverage review, or a complete assessment of the REIT's dividend policy. This calculator is an analytical aid, not personalized investment, accounting, tax, or legal advice.