How to Calculate Free Cash Flow + Excel Examples (2024)

How to Calculate Free Cash Flow and What It Means

If you have the three financial statements, including the Cash Flow Statement, it should be easy to determine a company’s “Cash Flow”: just take the “Net Change in Cash” from the bottom of the Cash Flow Statement, right?

WRONG!

The problem is that companies can spend and receive their cash in many different ways, and not all these methods are “required” and “recurring.”

For example, if a company issues Debt or Equity, both activities boost its cash flow – but neither one is necessarily “required” for the business to keep operating.

A company could spend cash buying Financial Investments, issuing Dividends, or repurchasing shares, but all those activities are also “optional.”

To estimate the company’s discretionary cash flow, therefore, we need a more precise definition.

“Discretionary cash flow” means “cash flow after the company pays for what it needs to run its business and avoid being shut down by external parties such as lenders and the government.”

We can define this metric in different ways, but a simple one is Free Cash Flow:

  • Free Cash Flow = Cash Flow from Operations (CFO) – Capital Expenditures (CapEx)

There are other variations of Free Cash Flow, which we explore later in this course and the other written guides.

But this initial definition is a good one because:

  • Everything in a company’s “Operating Activities” section is required for its business – earning Net Income, paying for Inventory, collecting Receivables, etc.
  • But almost every line item within Investing and Financing Activities is “optional,” except for Capital Expenditures.

CapEx is a required item because companies need buildings, factories, and equipment to house employees, manufacture products, and sell them to customers.

Even companies that sell services or software need buildings and computer equipment, and spending on both of them is considered CapEx.

Free Cash Flow lets us quickly and easily assess a company’s ability to generate cash flow from its business, including the cost of servicing its Debt and other long-term funding.

How to Calculate Free Cash Flow Under IFRS and Other Accounting Systems

One important note – especially under IFRS – is that this definition assumes that Cash Flow from Operations deducts Net Interest Expense, Preferred Dividends, Taxes, and all Lease Expenses.

So, if the company you’re analyzing has a CFO section that does not do that, you will need to adjust it for comparability purposes.

For example, under IFRS, you should remove the Lease Depreciation add-back in CFO because it’s not a true “non-cash expense.”

The company still pays the full Lease Expense in cash; splitting it into Interest and Depreciation elements does not change that.

Here’s an example for Vivendi:

How to Calculate Free Cash Flow + Excel Examples (1)

Also, if CFO includes many items in the Non-Cash Adjustments section besides D&A and Deferred Taxes, you may want to remove them to standardize the formula.

“How to calculate Free Cash Flow” seems like a very simple topic/formula – and it mostly is that simple under U.S. GAAP.

Because of the changes to lease accounting made in 2019, however, the calculation is often more complex for non-U.S. companies.

How to Calculate Free Cash Flow: Comparison for Best Buy and Zendesk

Here’s a quick comparison of Free Cash Flow for Best Buy (a U.S.-based retailer) and Zendesk (a U.S.-based software company):

How to Calculate Free Cash Flow + Excel Examples (2)

For Best Buy, the interpretation is as follows:

FCF is positive and growing, which is good, and the company doesn’t seem to be “playing games” by artificially cutting CapEx or changing its Working Capital to boost its FCF.

In fact, the Change in Working Capital (“Changes in Operating Assets & Liabilities”) became negative in Year 3, but FCF increased anyway.

Revenue is also growing each year, so it seems like Best Buy has a healthy business whose FCF is based on growth in that core business.

For Zendesk, FCF is also positive and growing, but far more quickly than its Revenue Growth in two years.

One reason is that the Changes in Operating Assets & Liabilities are much less positive in Year 3, so FCF gets less of a boost from that.

But there’s another red flag here as well: Zendesk’s Net Income is very negative, while its FCF is positive.

Look at its statements, and you can quickly tell why:

How to Calculate Free Cash Flow + Excel Examples (3)

Generally, you want to see a positive and growing FCF.

If FCF is negative, that means the company is not running a sustainable business by itself – it’s relying on outside financing to stay afloat!

That’s OK for short periods, such as the first few years of a startup’s existence, but if a company stays like that for a decade, it raises serious questions.

If FCF is negative, the first step is to ask, “Why? Is it temporary or permanent? Are the losses decreasing as the company grows?”

If FCF is becoming more negative as the company grows, stay away.

If FCF is positive, you should also ask, “Why?” before assuming it’s a good thing.

For example:

  • Is the company’s FCF growing because it’s capturing more of the market, selling more, and achieving higher margins due to economies of scale? This is good.
  • Is the company’s FCF growing because of creative cost-cutting, or because it’s reducing its annual CapEx spending? This is not so good.
  • Is the company’s FCF growing despite falling sales, because it’s playing games with Working Capital or with CapEx and Depreciation? This is not good.

In real life, you use Free Cash Flow in the Discounted Cash Flow (DCF) analysis for valuing companies, and also in the Leveraged Buyout (LBO) analysis for assessing the acquisition and sale of a company.

You do not necessarily use the type of Free Cash Flow (CFO – CapEx) described here, but you do use variations of it.

For more on how to calculate Free Cash Flow, please see our Unlevered Free Cash Flow tutorial.

Premium Course Signup

How to Calculate Free Cash Flow + Excel Examples (4)

About Brian DeChesare

Brian DeChesare is the Founder of Mergers & Inquisitions and Breaking Into Wall Street. In his spare time, he enjoys lifting weights, running, traveling, obsessively watching TV shows, and defeating Sauron.

How to Calculate Free Cash Flow + Excel Examples (2024)

FAQs

How to Calculate Free Cash Flow + Excel Examples? ›

Enter "Total Cash Flow From Operating Activities" into cell A3, "Capital Expenditures" into cell A4, and "Free Cash Flow" into cell A5. Then, enter "=80670000000" into cell B3 and "=7310000000" into cell B4. To calculate FCF, enter the formula "=B3-B4" into cell B5. There you go.

How to calculate free cash flow examples? ›

To calculate FCF, locate sales or revenue on the income statement, subtract the sum of taxes and all operating costs (listed as “operating expenses”), which include items such as cost of goods sold (COGS) and selling, general, and administrative costs (SG&A).

What is the formula for present value of free cash flow in Excel? ›

Present value (PV) is the current value of an expected future stream of cash flow. Present value can be calculated relatively quickly using Microsoft Excel. The formula for calculating PV in Excel is =PV(rate, nper, pmt, [fv], [type]).

What is the formula for total free cash flow? ›

Free cash flow = sales revenue – (operating costs + taxes) – investments needed in operating capital. Free cash flow = total operating profit with taxes – total investment in operating capital.

What is free cash flow examples? ›

Free cash flow, or FCF, is the money that is left over after a business pays its operating expenses (OpEx), such as mortgage or rent, payroll, property taxes and inventory costs — and capital expenditures (CapEx). Examples of CapEx are long-term investments such as equipment, technology and real estate.

What is free cash flow for dummies? ›

You figure free cash flow by subtracting money spent for capital expenditures, which is money to purchase or improve assets, and money paid out in dividends from net cash provided by operating activities.

How do you calculate free cash flow for NPV? ›

If the project only has one cash flow, you can use the following net present value formula to calculate NPV:
  1. NPV = Cash flow / (1 + i)^t – initial investment.
  2. NPV = Today's value of the expected cash flows − Today's value of invested cash.
  3. ROI = (Total benefits – total costs) / total costs.

How do you determine free cash flow and NPV? ›

You can find the NPV from a discounted cash flow analysis, which assesses future cash flows of a project in present-day terms by using the time value of money. A free cash flow, on the other hand, is simply a period table of revenues minus expenses.

How is cash flow calculated? ›

You calculate cash flow by adjusting a company's net income through increasing or decreasing the differences in credit transactions, expenses and revenue (all of which are found on the income statements and balance sheets) between reporting periods.

Does Excel have a cash flow template? ›

Free Excel Cash Flow Template

Our cash flow template helps measure your company's financial performance. It displays the cash that your company has on hand after deducting elements such as salaries, rent, purchase of assets (e.g. equipment), and costs from the company income.

What is the easiest way to calculate cash flow? ›

To calculate operating cash flow, add your net income and non-cash expenses, then subtract the change in working capital. These can all be found in a cash-flow statement.

What is the NPV of cash flows in Excel? ›

The NPV function in Excel returns the net present value of an investment based on a discount or interest rate and a series of future cash flows. The syntax of the Excel NPV function is as follows: NPV(rate, value1, [value2], …)

How does Warren Buffett calculate free cash flow? ›

First, he studies what he refers to as "owner's earnings." This is essentially the cash flow available to shareholders, technically known as free cash flow-to-equity (FCFE). Buffett defines this metric as net income plus depreciation, minus any capital expenditures (CAPX) and working capital (W/C) costs.

What is a good FCF? ›

A “good” free cash flow conversion rate would typically be consistently around or above 100%, as it indicates efficient working capital management. If the FCF conversion rate of a company is in excess of 100%, that implies operational efficiency.

What is free cash flow vs EBITDA? ›

FCF allows investors to assess whether a company has excess cash available for these purposes, whereas EBITDA does not provide this insight. FCF is often considered a more conservative and resilient measure of a company's financial health. It accounts for the sustainability of a company's cash generation over time.

Top Articles
Latest Posts
Article information

Author: Sen. Ignacio Ratke

Last Updated:

Views: 6014

Rating: 4.6 / 5 (56 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Sen. Ignacio Ratke

Birthday: 1999-05-27

Address: Apt. 171 8116 Bailey Via, Roberthaven, GA 58289

Phone: +2585395768220

Job: Lead Liaison

Hobby: Lockpicking, LARPing, Lego building, Lapidary, Macrame, Book restoration, Bodybuilding

Introduction: My name is Sen. Ignacio Ratke, I am a adventurous, zealous, outstanding, agreeable, precious, excited, gifted person who loves writing and wants to share my knowledge and understanding with you.