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

standard costing and variance analysis pdfbasis of apportionment of overheadsinfinite annuity formulapayment voucher word formatpresent value of bond calculatorbookkeeping depreciationhow to calculate pv of annuitystock holder equityhow do we complete a horizontal and vertical analysisuneven cash flowstatement of retained earnings equationinterest bearing liabilities balance sheetjournal entry for credit salesstatement of comprehensive income layoutcost accounting spreadsheetjob timesheetswhat is the formula for predetermined overhead rateintangible items examplesannuity fv calculatordefinition of prepaid expensesimple accounting equationroa dupontperpetual inventory system fifounrealized gain loss accountingdeclining balance depreciation calculatornet account receivable formuladupont analysis ratiospresent value of an annuity formula calculatortotal asset turnover ratio calculatorwhat is the accounting cycle stepsaged receivableconsignment accountsexample of journalizing in accountingaccounts receivable excel templatesales ledger sampledebtor ratiosuspense account balance sheetwhat are closing entriesdefine amortizationinvestment turnover formulavoucher payment samplecash receipt voucher samplecapital lease journal entriesbank recscalculating times interest earneddefine capital injectionwhat are consumable storesaccounting ledger paperaverage days sales in receivablesperpetual periodic inventoryratio roapresent value of annuity tableaccounts payable templateinterest bearing debt formulawhat is unadjusted trial balancecompound continuously interest formulaincome tax provision templatestate the accounting equationaccounting entries for accruals and prepaymentsunder the allowance method bad debt expense is recordedcashiers check definitionpv annuity factorunaccrued incomevariable cost definition and exampleformula for installment loanexplain retained earningsis patent an intangible assetfiguring markup percentagehow to compute contribution margin per unitinternal controls accounts receivableequity method of accounting journal entriesdouble entry bookkeeping tutorialdouble declining depreciation equationbad debt provision double entryaccounts receivable reconciliation examplecalculating degree of operating leveragefixed asset turnover interpretation