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


fixed asset turnover ratio analysisdebtor days calculationretained earnings journal entrysum-of-the-years-digits method of depreciationcredit note issued by supplieraccounts receivable dsogross markup formuladeferred revenue purchase accountingnet fixed asset turnoverwhy is a trial balance preparedlifo to fifo conversionbank reconciliation statement pdf notespresent value annuity duesmall business expense templateoverstated accountingtemplates for spreadsheetsgrn in accountinghow to calculate bank reconciliation statementaccount receivable procedureledger book formatpetty cash floathow to calculate inventory turnover daysfcf calculatorwhat is consignor and consigneewhat is imprest systemaccounting equation and balance sheetannuity tables pdfunearned rent revenue journal entryimpairment loss accounting entryexamples of other comprehensive incomeprintable ledger templateformula for unit contribution marginprintable general ledgertypical invoice termstypes of accounting ledgersaccounts receivable to sales ratiophysical inventory count sheetfour accounting conceptsdefine imprest accountaccounts receivable is a debit or creditannuity calculation in excelwhat is the purpose of the bank reconciliation statementdebtors and creditors ledgerfixed manufacturing overhead costswhat is provision for doubtful debtcommon size analysis income statementaccounts receivable test questions answersaged creditors reportexcel annuity calculatordouble declining balance depreciation formulawhat is markup and marginhow to calculate unit variable costelectricity expense journal entryhorizontal analysis of an income statementdepreciation with salvage valuedebtor collection period definitionretained earnings templateaccruals vs cashcapital lease calculator excelcash ledger examplepresent value of annuity table pdfhow to calculate principal balanceweighted average cost of inventory formulapetty cash expensesbookkeeping meaninghow to set up an excel spreadsheet for accountspresent value lump sum formulabills receivable journal entryledger sheets to printfreight prepaid meaningwhat does prepaid freight meanbalance sheet reconciliation exampleadjusting entries accountingnet asset turnover ratio formulacash flow perpetuity formuladebit memo accounting entryaccounts payable days ratio