Free Cash Flow Calculator

The purpose of free cash flow is to see what cash is available (free) from the operations of the business after allowing for cash to maintain the current growth rate.

This free cash flow is then available to improve growth by taking advantage of expansion opportunities, to invest in new products, and to reduce debt and pay dividends to equity providers.

The calculation is carried out using the free cash flow formula which deducts the capital expenditure from the operating cash flow for the accounting period.

Free cash flow = Operating cash flow – Capital expenditure

Both operating cash flow and capital expenditure are found on the cash flow statement of the business. Our tutorial on free cash flow explains in more detail how to locate these two items.

free cash flow calculator v 1.0
Free Cash Flow Calculator Preview
Using the Free Cash Flow Calculator

The Excel free cash flow calculator, available for download below, is used to compute free cash flow by entering details relating to the operating cash flow and the capital expenditure. The calculator is used as follows:

  • The operating cash flow is entered. Operating cash flow is found on the cash flow statement of the business.
  • The capital expenditure is entered. Capital expenditure is also found on the cash flow statement of the business. Strictly speaking the capital expenditure used in the calculation is the amount required to maintain the growth of the business at the current rate. In practice this figure is not generally available, and it is normal to use the total capital expenditure figure in the financial statements. The calculator calculates the free cash flow for the period.

There is no correct value for the free cash flow as it depends on the industry in which the business operates. It is useful to compare the calculated figure with other businesses in your industry using figures available from published financial statements.

Free Cash Flow Calculator Download

The free cash flow spreadsheet is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this free cash flow calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a free cash flow software that you might use when carrying out free cash flow analysis. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this free cash flow template, please let us know and we will try to fix it.
Free Cash Flow Calculator November 6th, 2016Team

You May Also Like

Related pages

issuance of common stock journal entryasset turnover ratio exampledouble entry for petty cashdepreciation schedule excelaccounts receivable aged trial balancecalculate variable expensesmarkup multipliercalculation of deferred tax on depreciationactivity based costingsaccounts receivable sampleaccount receivable calculationpetty cash definition in accountingstraight-line discount amortization9 step accounting cycleequation for inventory turnoverexpenses template small businessgearing ratioswhat is discount allowed and discount receivedgive journal entry for provisionexamples of period costsgraduated annuityhow to journalize payrollaccrual accounting versus cash accountingcalculate effective annual interest ratecosts of good sold formulaexample of cash disbursement journalintangibles accountingadjusting entry in accountingoperating asset turnover ratioselling and administrative expenses formulaaccrued expense journalaccrued expenses payablereversing entries in accountingwhat is the journal entry for accounts payableannuity payout calculator excelaccounts receivable report samplesale of fixed assets journal entrysuspense account and errorshow to compute operating expenseshow to calculate bad debt provisiongross debt equity ratiohow to calculate inventory in balance sheetcapital lease calculationstock valuation equationageing receivablesaccounting journal entries cheat sheetpayroll quizhow to calculate safety stock in excelleverage ratio calculatorretained profit balance sheetincome tax expense journal entrytrial balance depreciationfifo and lifo in accountingspreadsheet templates for small businessaccrued interest journal entryadjusting entry for unearned revenueaccumulated depreciation chart of accountsoverhead cost variance isdegree of operating leverage equationjournal entry to record depreciationbookkeeping spreadsheet excelcalculate the future value of an annuitycalculating gp percentageaccounting journal and ledgerwcr working capitaldeferred tax capital allowanceshow to calculate variable costingdividends declared balance sheetfuture value of an annuity duejournal for accountingtotal asset turnover ratio exampleshould i be an accountant quiznpv of a perpetuitycomputing payback periodhow to record depreciation expense journal entry