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:
Download the Free Template
Enter your name and email in the form below and download the free template now!
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.
Excel Tutorial
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Excel Crash Course now to take your career to the next level and move up the ladder!
