FFO Calculator

FFO Calculator
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description

Funds From Operations (FFO) Calculator

Convert reported net income into a REIT-focused operating measure by adding back real-estate depreciation and removing selected property-sale and interest effects.

FFO $530,000.00 Net adjustment $30,000.00 Excluded inflows $200,000.00

Financial statement inputs

Enter values for the same reporting period. Amounts may be typed with or without dollar signs and commas.

GAAP net income attributable to the period. A loss may be entered as a negative value.

Real-estate depreciation and amortization added back to net income.

Recognized gains from real-estate dispositions; these are subtracted in this model.

Recognized losses from property dispositions; these are added back in this model.

Interest earnings treated here as a non-property operating inflow and subtracted.

Calculation $500,000.00 + $150,000.00 + $80,000.00 − $125,000.00 − $75,000.00

Live results

Results recalculate as assumptions change.

Funds from operations $530,000.00 FFO is $530,000.00 for the entered reporting period.
Net adjustment $30,000.00 Total additions less total deductions.
Adjustment vs. net income 6.00% Net adjustment divided by absolute net income.
Positive base $730,000.00 Net income plus D&A and property-sale losses.
Excluded inflows $200,000.00 Property-sale gains plus interest income.
Interpretation: FFO is above reported net income because the add-backs exceed the deductions.

Net income to FFO bridge

The bridge shows how each entered adjustment moves reported net income to funds from operations.

Enter non-zero values above to see the FFO bridge.
Waterfall chart from net income to funds from operations Net income of $500,000.00 is adjusted by depreciation and amortization, property losses, property gains, and interest income to reach FFO of $530,000.00.
Detailed FFO bridge values
Bridge item Adjustment Running total Treatment
The running total begins with net income. Add-backs increase the bridge, while excluded gains and interest income decrease it.
Current inputs create a net positive adjustment of $30,000.00, taking FFO to $530,000.00.

What does this FFO calculator estimate?

This calculator estimates funds from operations for a real estate investment trust or another property-focused business using a concise bridge from reported net income. FFO is a supplemental operating measure, not a replacement for GAAP net income, operating cash flow, or free cash flow. Its purpose is to reduce the distortion that real-estate depreciation and one-time property dispositions can create when a reader is trying to understand recurring property operations.

The model follows the displayed equation: net income plus depreciation and amortization plus losses from property sales, minus gains from property sales and interest income. The result is shown as a total for the reporting period entered. Keep every input on the same basis—for example, all annual figures or all quarterly figures—and use amounts attributable to the same entity and ownership scope.

FFO = net income + depreciation and amortization + property-sale losses − property-sale gains − interest income

How should each input be entered?

Net income

Use the bottom-line earnings figure for the reporting period and scope you are analyzing. This field is required for a meaningful bridge, although the calculator will accept zero. Net income can be negative when the entity reports a loss. A higher net income generally raises FFO dollar for dollar, while a lower or negative value reduces it. A common mistake is mixing consolidated net income with adjustments that relate only to one subsidiary or property group.

Depreciation and amortization

Enter the real-estate depreciation and amortization intended to be added back. Use a non-negative amount. Increasing this input increases FFO dollar for dollar because the model treats the charge as an accounting allocation rather than a current-period property cash outflow. Avoid automatically adding back every amortization line without checking the reporting definition being used. Public REIT disclosures may limit the adjustment to qualifying real-estate assets and may include proportionate adjustments for unconsolidated ventures.

Gains and losses from property sales

Enter gains and losses in their separate fields as positive amounts. A property-sale gain is subtracted because it can make net income look stronger even though it does not arise from ongoing rental operations. A property-sale loss is added back for the opposite reason. Do not enter a loss as a negative number in the loss field; doing so would reverse the intended treatment. Confirm whether the transaction is a qualifying real-estate disposition under the company’s stated FFO policy.

Interest income

Enter the interest income excluded by this calculator’s formula as a non-negative value. Higher interest income lowers the calculated FFO because the model removes that financial inflow from the property-operating bridge. This treatment is useful for matching the reference formula used here, but company-reported FFO definitions can differ. Review the issuer’s reconciliation before comparing this result with a published non-GAAP measure.

How should the results be interpreted?

Funds from operations is the principal output. A positive value means the adjusted bridge ends above zero; a negative value means the entered net loss and deductions exceed the add-backs. A larger FFO is not automatically “better” without context. Analysts normally compare FFO across periods, against guidance, per share, and relative to a REIT’s size, debt load, capital needs, and dividend commitments.

Net adjustment is the difference between FFO and net income. A positive adjustment means depreciation, amortization, and property-sale losses exceed property-sale gains and interest income. A negative adjustment means the deductions are larger. Adjustment versus net income expresses that difference as a percentage of the absolute net-income base; it becomes unavailable when net income is zero because division by zero would be misleading.

Positive base combines net income with the two add-back categories. Excluded inflows combines property-sale gains and interest income. These intermediate values help users locate the drivers of the bridge, but they are not standardized performance metrics on their own.

What does the waterfall chart show?

The chart begins with net income, then applies each adjustment in sequence. Upward bars are additions, downward bars are deductions, and the final bar is FFO. The accompanying legend and table use the same underlying values as the results panel and Excel export. The running-total column makes the arithmetic auditable: each row’s ending balance becomes the next row’s starting point.

Changing depreciation or property losses moves the bridge upward. Increasing property gains or interest income moves it downward. If every input is zero, the chart is intentionally replaced by a compact empty state rather than displaying a meaningless plot.

How does FFO differ from cash flow and AFFO?

FFO is not the same as cash generated from operations. It starts from accounting net income and applies selected adjustments, whereas the cash flow statement also reflects working-capital movements and other non-cash items. Adjusted funds from operations, or AFFO, usually makes additional company- or analyst-defined adjustments for recurring capital expenditures, straight-line rent, leasing costs, and other normalization items. Because AFFO lacks one universal calculation, compare definitions carefully.

For the industry definition and its development, consult the Nareit FFO overview and the Nareit FFO white paper. The SEC investor bulletin on publicly traded REITs provides broader REIT context, while the IRS Form 1120-REIT page covers federal tax filing information. These resources should be read alongside the specific company’s filings and reconciliation disclosures.

What are the main limitations and common mistakes?

  • Do not mix annual inputs with quarterly inputs or consolidated figures with property-level figures.
  • Do not treat FFO as cash available for dividends without considering recurring capital expenditure, debt service, leasing costs, and working capital.
  • Do not assume every issuer uses the identical adjustment set. Company-reported FFO may include joint-venture, impairment, noncontrolling-interest, or other reconciliation items not represented here.
  • Do not enter gains or losses with the wrong sign. Use positive values in their dedicated fields and let the calculator apply the addition or subtraction.
  • Use trends, per-share measures, and reconciliations rather than interpreting one absolute FFO number in isolation.

This calculator is an educational modeling tool. It does not provide investment, accounting, tax, or legal advice.