Description
FRAccRecTurnover returns the average turnover of AccountReceivable in days.
Format
FRAccRecTurnover(AccountReceivable, Sales, NumOfDays)
Arguments
AccountReceivable is a Number or formula. AccountReceivable is the total accounts receivable in a company's balance sheet.
Sales is a Number or formula. Sales is the total sales during the period that appears in a company's income statement.
NumOfDays is a Number or formula. In general, it is the number of days in a year. Some analysts use 360 and some use 365. The default is 360 for this function.
Action
FRAccRecTurnover returns the average turnover of AccountReceivable in days (for example, AccRecTurnover = (AccountReceivable / Sales) * 360).
Typical uses
This ratio measures the turnover of accounts receivable in days. A smaller ratio represents higher turnover which means that accounts receivable is paid shortly after they are incurred. A higher turnover is generally preferable over a lower turnover which might be an indication of doubtful accounts.
Examples
FRAccRecTurnover(100, 600, 360)
Returns 60.
FRAccRecTurnover(200, 300, 360)
Returns 240
None of the arguments can be negative; you may have to check for negative values before passing the arguments.
Comments
FRAccRecTurnover is one of the many financial analysis tools used in interpreting the financial position of a company. As in the case of all ratios, it has to be used with caution. It can just be used as a clue and not solid proof for forming a judgment on the financial status of a company.
Neither one of the ratios can be used alone for doing financial analysis and there are no fixed rules on the results of the ratios. Apart from differences between type of industries, result varies among different companies within the same industry and within different account periods. The results should only be used for relative comparison and trend analysis, rather than treating them as something absolute.