Cash Flow Reconciliation Template

Cash Flow Reconciliation Template

This cash flow reconciliation template will help you differentiate between EBITDA, CF, FCF and FCFF.

Below is a preview of the cash flow reconciliation template:

Cash Flow Reconciliation Template Screenshot

 

Download the Free Template

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

Cash Flow Reconciliation Template

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

 

EBITDA vs. Cash Flow vs. Free Cash Flow vs. Unlevered Free Cash Flow

There are major differences between EBITDACash FlowFree Cash Flow and Free Cash Flow to Firm.

#1 EBITDA

EBITDA can be easily calculated off the income statement by adding to the net income the taxes, interest, depreciation & amortization.

#2 Cash Flow (from Operations, levered)

Operating Cash Flow is a measure of cash generated by a business from its normal operating activities. Like EBITDA, depreciation and amortization are added back to cash from operations.  However, all other non-cash items like stock-based compensation, unrealized gains/losses, or write-downs are also added back.

Unlike EBITDA, cash from operations includes changes in net working capital items like accounts receivable, accounts payable and inventory.

Operating cash flow does not include capital expenditures.

#3 Free Cash Flow (FCF)

Free Cash Flow, also referred to as “Levered Free Cash Flow” or “Cash Flow to Equity”, can be easily derived from the statement of cash flows by taking operating cash flow and deducting capital expenditures.

FCF is the amount of cash flow available for discretionary spending by management/shareholders.

#4 Free Cash Flow to the Firm (FCFF)

Free Cash Flow to the Firm (also called Unlevered Free Cash Flow) requires a multi-step calculation and is used in Discounted Cash Flow analysis to arrive at the Enterprise Value. It is calculated based on the assumption that the firm was to have no debt.

 

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!