Funds From Operations Template

Funds From Operations Template

This funds from operations template allows you to calculate the FFO using the formula: FFO = Net Income + (Depreciation expense + Amortization expense + Losses on sale of assets) – (Gains on sale of assets + Interest income)

Here is a screenshot of the FFO template:

Funds From Operations Template Screenshot

 

Download the Free Template

Enter your name and email in the form below and download the free template now!

Funds From Operations Template

Download the free Excel template now to advance your finance knowledge!

 

Funds from operations (FFO), is the actual amount of cash flow generated from business operations.

In order to calculate the FFO, one must add the expenses or losses, which are not actually incurred from the operations, such as depreciation, amortization, and any losses on the sale of assets, to net income.  Then subtract any gains on the sale of assets and interest income.

FFOs are commonly used by companies that engage in Real Estate Investment Trusts (REITs), a business that primarily operates on income-generating real estate transactions. REIT companies are involved in commercial real estate – selling, leasing, and financing of office and apartment buildings, warehouses, hospitals, shopping centers, hotels, and timberlands.

 

More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.

Financial Analyst Certification

Become a certified Financial Modeling and Valuation Analyst (FMVA)™ by completing CFI’s online financial modeling classes and training program!