Cash Flow Ratios Calculator

Traditional accounting ratios are often based on the net income of a business. Net income is a subjective measure which can be manipulated by accounting assumptions and opinions. Operating cash flow is an alternative objective measure of performance, and this cash flow ratios calculator can be used to calculate three operating cash flow ratios.

  1. Operating cash flow / Net income
  2. Operating cash flow / Sales revenue
  3. Operating cash flow / Total assets

The use of these three ratios is more fully discussed in our cash flow ratio analysis post.

Using the Cash Flow Ratios Calculator

The Excel cash flow ratios calculator, available for download below, can be used to calculate the three ratios listed above by entering details from the financial statements of a business.

cash flow ratios calculator v 1.0
Cash Flow Ratios Calculator Preview

Income Statement

Enter the net income and sales revenue from the income statement of the business.

Balance Sheet

Enter the total assets shown on the balance sheet at the end of the accounting period. An ending balance sheet value must be entered for the Cash flow / Assets ratio to be calculated.

When calculating ratios involving balance sheet items it is best to use the average of the beginning and ending balance sheet amounts. If the beginning balance sheet is available enter the total assets value at the beginning of the year and the cash flow ratios calculator will use the average value. If the beginning balance sheet total assets is not available then enter zero and the ratio calculation will be carried out using the ending total assets.

Cash Flow Statement

Enter the cash flow from operating activities from the cash flow statement of the business.

The cash flow ratios calculator calculates the three ratios listed above.

Cash Flow Ratios Calculator Download

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

The amounts currently entered in the version available for download are those relating to the financial statements of Apple Inc. 2016.

The cash flow ratios calculator is one of many financial calculators used in bookkeeping and accounting, discover another at the links below.

Notes and major health warnings
Users use this cash flow ratios template 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 an operating cash flow calculator that you might use. It is purely illustrative of a cash flow calculator. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the Excel cash flow analysis calculator, please let us know and we will try to fix it.
Cash Flow Ratios Calculator September 26th, 2017Team

You May Also Like

Related pages

what is vertical analysis in accountingwhat is accrued salariesbookkeeping and accounting pdfbills receivable and bills payable meaningexamples of journalizing transactionshow to calculate activity based costingcontra entrieshigh liquidity ratiouncredited cheques and unpresented chequesinventory shortage is recorded whenpartnership accounting tutorialdepreciation straight line method calculatorhalf year rule depreciationpresent value annuity formulabond payable on balance sheetdeclining depreciation methodsubsidiary ledger exampleasset write off journal entryvariable overhead rateunearned revenue in balance sheetcollected accounts receivable journal entrywhat is labour efficiency variancepost closing journal entriesexpenses template small businessinterest receivable journal entryexample of absorption costingpresent value of perpetuitysample cash receipt templatepromissory note accountingcurrency translation adjustment journal entrytotal conversion cost formulapmt excel functionadjusting journal entries practicefob origin vs fob destinationoverapplied overhead journal entryhow to write off inventory in quickbookspercentage of sales method for calculating doubtful accountspresent value of a single sum calculatorunderstanding debits and credits accountingpayback equationamortization calculator excel downloadallowance for doubtful debts definitionperiodic and perpetualperpetuity calculation formulapay back period calculatorlayout of cash flow statementtable present value of annuityturnover of accounts receivablehow to calculate vertical analysis balance sheetperiodic inventory system closing entrieshorizontal and vertical analysisbalance sheet debits and creditspv of a perpetuity calculatorexamples of accrualsdistinguish between capital receipt and revenue receiptprintable accounting ledgerprove it test answers excelvertical analysis balance sheet examplecapitalized leasessample of trial balance worksheetloan balance calculator excelacid test ratio formulatransferable letter of credit flow chartdividends paid journal entryaccounting equation examplesbookkeeping practice testdeferred revenue entriesgross sales equationhow to calculate closing stock from trial balanceunearned revenue exampleshow to solve for variable costaccounting methods cash vs accrualcredit memo accounting entrytimesheets templatecontra account journal entryimpairment loss on intangible assets