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

what is office supplies expense in accountingaccounting entry for prepaid expensestrial balance is preparedaccounting adjusting entries practice problemsfuture value annuity due calculatordefine capacity cushionbank cash book formatprofit percentage calculation formulaadjusting entries journaldouble column cash book exampleaccounting receivable processconsigned inventory accountingbills receivablesaccounting treatment of intangible assetschange in accounts receivable formulameaning of amortiseadjusting journal entries unearned revenuetrade discount examplecredit memo journal entrybookkeeping worksheetsmarketable securities examples balance sheetconverting effective interest rate to nominalwhat is the purpose of preparing a bank reconciliationaged receivablesexample of overstatementgross profits formulahow to find acid test ratiowhat is gearing ratio formulajournal entry for bills receivableposting to a general ledgerexample of apportionmentcredit memo accounting entrywhat is the accounting cycle stepsverifiability accountingcalculating vacation accrualblank ledger templatenon profit financial statement template freesample retained earnings statementhow to figure out markup percentagehow to compute for effective interest ratedouble entry prepaymentdouble declining balance method equationsegregation of duties accounts receivabledepreciation expense calculatorcalculating the contribution margincash accounting vs accrualconsignment sales accountingleverage gearingdebt to owners equityincome statement for non profit organization templatezero coupon bond calculatorinventory adjustment journal entryunit contribution margin formulawhat is payroll liabilitiesdividend journal entriesaverage cost inventory methodhow to calculate nominal annual interest ratesimple petty cash book in excelrevenue projections templatemerchandise inventory balance sheethow to calculate interest compounded continuouslypresent value of stock with dividend calculatoradjusting lower cost of market inventory on valuationdefine amortization expenselump sum payment formulatrial balance worksheetcalculate contribution margincapital gearing formulaaccounting entry for prepaid insurancestockholders equity calculationloan accounting journal entriesbond amortization effective interest methoddso formulaaverage owner's equitycoupon bond calculator present valueservices rendered accounting entrypetty cash log excelcash dividend journal entry