Cash Flow Reconciliation Template

This is a cash flow reconciliation template, brought to you by CFI, differentiating between earnings metrics.

by CFI
Corporate Finance Institute® (CFI) - Official provider of the Financial Modeling & Valuation Analyst (FMVA)™Follow 194

107 views|Start the discussion!|Bookmark

Description
This Cash Flow Reconciliation Template, brought to you CFI, is an effective Excel download that will make it simpler for the user to differentiate between the ways of looking at earnings made by your business.

More specifically, this template discerns Earnings Before Interest, Taxes, Depreciation and Amortization (EBITDA), which is heavily used in finance, Cash Flow (CF), Free Cash Flow (FCF), and Free Cash Flow to Firm (FCFF).

The Excel template is made up of an Income Statement, where the user is able to input their revenue, cost of goods sold (COGS), and other areas to return gross earnings and net earnings.

It also demonstrates the cash flow statement, including the cash from operations, cash from investing and the cash from financing.

This tool will then produce the data for the different types of earnings. Please refer to the accompanying video which gives a succinct tutorial on the different metrics and their nuances. It will help you to understand and utilize the Excel template more efficiently, whilst also giving more clarity regarding the download.

If you have any questions regarding this model or the video, do not hesitate to reach out by starting a discussion below.

To find more models and templates from CFI, please refer to our channel page.

This business tool includes
1 Excel Template, 1 YouTube Video