{"id":991,"date":"2007-09-18T11:20:06","date_gmt":"2007-09-18T16:20:06","guid":{"rendered":"http:\/\/www.sequence-inc.com\/fraudfiles\/2007\/09\/18\/finding-fraud-by-looking-at-ratios\/"},"modified":"2007-09-18T11:20:49","modified_gmt":"2007-09-18T16:20:49","slug":"finding-fraud-by-looking-at-ratios","status":"publish","type":"post","link":"https:\/\/www.sequenceinc.com\/fraudfiles\/finding-fraud-by-looking-at-ratios\/","title":{"rendered":"Finding fraud by looking at ratios"},"content":{"rendered":"<p>While doing some research, I came across an old article written by Joe Wells on analyzing ratios to find fraud. The article <a href=\"http:\/\/www.buec.udel.edu\/jenkinsd\/Articles\/Irrational%20Ratios.htm\">Irrational Ratios<\/a> was published in the Journal of Accountancy, and used the ZZZZ Best case to illustrate the point.<\/p>\n<p>I&#8217;m a believer that today&#8217;s really good fraudsters manipulate the financial statements so that the ratios are in line with expectations. Executives who are committing fraud know what the financial statements <strong>should<\/strong> look like.  So we can&#8217;t always assume that normal-looking financial statements are free from fraud.<\/p>\n<p>Yet sometimes there&#8217;s too much to keep track of, and flaws in the financial statements are revealed with ratio analysis. The longer a fraud goes on, the greater the likelihood that a clue may turn up.<!--more--><\/p>\n<p>Wells uses this illustration to show where ZZZZ Best&#8217;s numbers went wrong. A simple comparison of ratios between years reveals something is going on. (Yoo hoo! Auditors????)<\/p>\n<p align=\"center\">&nbsp;<\/p>\n<p><center><\/p>\n<table border=\"0\" cellpadding=\"6\" cellspacing=\"0\" width=\"410\">\n<tr>\n<td bgcolor=\"#003399\"><font color=\"#ffffff\" face=\"Arial\" size=\"3\"><strong>Exhibit 1: Selected Ratios From ZZZZ              Best<\/strong><\/font><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#a6caf0\">\n<p align=\"center\">&nbsp;<\/p>\n<p><center><\/p>\n<table bgcolor=\"#ffffcc\" border=\"0\" cellpadding=\"3\" cellspacing=\"0\" width=\"400\">\n<tr>\n<td align=\"center\" bgcolor=\"#ff0000\">&nbsp;<\/td>\n<td align=\"center\" bgcolor=\"#ff0000\"><font color=\"#ffffff\" face=\"Arial\"><strong>1985 <\/strong><\/font><\/td>\n<td align=\"center\" bgcolor=\"#ff0000\"><font color=\"#ffffff\" face=\"Arial\"><strong>1986<\/strong><\/font><\/td>\n<\/tr>\n<tr>\n<td><font face=\"Arial\" size=\"2\">Current ratio of assets to                    liabilities<\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">36.552<\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">.0977<\/font><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">Working capital:                    Total assets <\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">0.5851<\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">(0.0080)<\/font><\/td>\n<\/tr>\n<tr>\n<td><font face=\"Arial\" size=\"2\">Collection ratio <\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">N\/A<\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">26.131<\/font><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">Asset turnover                    <\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">.144<\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">1.041<\/font><\/td>\n<\/tr>\n<tr>\n<td><font face=\"Arial\" size=\"2\">Debt to equity ratio <\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">.017<\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">1.486<\/font><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">Receivables                    turnover<\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">N\/A<\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">6.984<\/font><\/td>\n<\/tr>\n<tr>\n<td><font face=\"Arial\" size=\"2\">Times interest earned<\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">N\/A<\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">43.136<\/font><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">Cost of sales:                    Sales <\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">.465<\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">.423<\/font><\/td>\n<\/tr>\n<tr>\n<td><font face=\"Arial\" size=\"2\">Gross margin percentage<\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">53.51%<\/font><\/td>\n<td align=\"right\"><font face=\"Arial\" size=\"2\">57.68%<\/font><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">Return on equity                    <\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">183.75%<\/font><\/td>\n<td align=\"right\" bgcolor=\"#ffcccc\"><font face=\"Arial\" size=\"2\">46.58%<\/font><\/td>\n<\/tr>\n<\/table>\n<p><\/center><\/td>\n<\/tr>\n<\/table>\n<p><\/center>Wells notes:<\/p>\n<blockquote><p>These numbers make no sense at all\u2014they are all over the place. Particularly revealing are the current ratio and the debt to equity and return on equity ratios. The current ratio shows a company with no cash in 1986 despite record \u201crevenues.\u201d The 1986 debt to equity ratio is up 8600% from the prior year; return on equity has dropped by more than 75%. These are not indicators of a legitimate business.<\/p><\/blockquote>\n<p>Other clues to the fraud at ZZZZ Best:<\/p>\n<ul>\n<li>Days&#8217; Sales in Receivables &#8211; Compares receivables to sales from year-to-year to see what&#8217;s happening. At ZZZZ Best, this ratio was 177,622, compared to a normal ratio of around 1 for other companies. The fact was that between years, ZZZZ Best&#8217;s receivables went from $0 to $700,000. The $700,000 balance was fictitious.<\/li>\n<li>Gross Margin Index &#8211; Compares a company&#8217;s gross margin between periods. In the case of ZZZZ Best, this comparison wasn&#8217;t useful. For other companies, it may be.<\/li>\n<li>Asset Quality Index &#8211; Compares non-current assets to total assets. The higher the non-current assets compared to the total, the lower the quality of assets because the long-term value of such assets is uncertain. This index at ZZZZ Best showed an increase of 97% between years, as compared to a 21% increase between years for companies not engaged in financial statement fraud. This ratio doesn&#8217;t prove fraud, but definitely raises a red flag about the ZZZZ Best numbers.<\/li>\n<li>Sales Growth Index &#8211; Companies without financial statement frauds had an index 1.134. ZZZZ Best had an index of 3.905. This could indicate falsification of sales, leading to an unusual amount of &#8220;sales growth&#8221; per the financial statements.<\/li>\n<li>Total Accruals to Total Assets &#8211; This measures changes in working capital and accruals. In the case of ZZZZ Best, the cash was unusually low and the accruals unusually high. Another clue about fraud.<\/li>\n<\/ul>\n<p>Ratio analysis isn&#8217;t the end all that beats all, but it can definitely be a tool to point an investigator in the general direction of a financial statement manipulation.  <a href=\"http:\/\/technorati.com\/tag\/tracy\" rel=\"tag\"><\/a> <a href=\"http:\/\/technorati.com\/tag\/coenen\" rel=\"tag\"><\/a> <a href=\"http:\/\/technorati.com\/tag\/tracy+coenen\" rel=\"tag\"><\/a><a href=\"http:\/\/technorati.com\/tag\/tracy+l+coenen\" rel=\"tag\"><\/a><a href=\"http:\/\/technorati.com\/tag\/sequence\" rel=\"tag\"><\/a> <a href=\"http:\/\/technorati.com\/tag\/sequence+inc\" rel=\"tag\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While doing some research, I came across an old article written by Joe Wells on analyzing ratios to find fraud. The article Irrational Ratios was published in the Journal of Accountancy, and used the ZZZZ Best case to illustrate the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[],"class_list":["post-991","post","type-post","status-publish","format-standard","hentry","category-fraud-news-stories"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6Z0e-fZ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/posts\/991","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/comments?post=991"}],"version-history":[{"count":0,"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/posts\/991\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/media?parent=991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/categories?post=991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sequenceinc.com\/fraudfiles\/wp-json\/wp\/v2\/tags?post=991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}