Question
QUESTIONS Prepare required ratio analysis and then complete the horizontal and vertical analysis using the Excel file. Based on your horizontal and vertical analysis, identify
QUESTIONS Prepare required ratio analysis and then complete the horizontal and vertical analysis using the Excel file. Based on your horizontal and vertical analysis, identify at least three possible red flags and indicate if a reasonable explanation exists in 12 sentences for the areas of concern you choose. Based on the ratio analysis, indicate at least three areas where you can identify revenue fraud may have occurred. Provide specific details in your paragraph explanation of each.
ABC COMPANY BALANCE SHEET AS OF DECEMBER 31, 2014 ASSETS 2014 2013 2012 Current assets Cash $ 501,992 $ 434,215 $ 375,141 Accounts Receivable 335,272 302,514 241,764 Inventory 515,174 505,321 310,885 Prepaid Expenses 251,874 231,100 136,388 Total current assets $ 1,604,312 $ 1,473,150 $ 1,064,178 Property, plant and equipment 765,215 735,531 705,132 Accumulated depreciation (218,284) (196,842) (175,400) TOTAL ASSETS $ 2,151,243 $ 2,011,839 $ 1,593,910 LIABILITIES Current liabilities Accounts payable $ 248,494 $ 366,864 $ 322,156 Accrued liabilities 122,192 216,533 215,474 Income taxes payable 10,645 25,698 22,349 Current portion of long-term debt 42,200 42,200 42,200 Total current liabilities $ 423,531 $ 651,295 $ 602,179 Long-term liabilities Long-term debt 425,311 400,311 375,100 TOTAL LIABILITIES $ 848,842 $ 1,051,606 $ 977,279 STOCKHOLDERS' EQUITY Common Stock $ 370,124 $ 356,758 $ 320,841 Additional paid-in-capital 29,546 24,881 21,910 Retained earnings 902,731 578,594 273,880 Total stockholders' equity $ 1,302,401 $ 960,233 $ 616,631 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ 2,151,243 $ 2,011,839 $ 1,593,910
ABC COMPANY BALANCE SHEET AS OF DECEMBER 31, 2014 ASSETS 2014 2013 2012 Current assets Cash $ 501,992 $ 434,215 $ 375,141 Accounts Receivable 335,272 302,514 241,764 Inventory 515,174 505,321 310,885 Prepaid Expenses 251,874 231,100 136,388 Total current assets $ 1,604,312 $ 1,473,150 $ 1,064,178 Property, plant and equipment 765,215 735,531 705,132 Accumulated depreciation (218,284) (196,842) (175,400) TOTAL ASSETS $ 2,151,243 $ 2,011,839 $ 1,593,910 LIABILITIES Current liabilities Accounts payable $ 248,494 $ 366,864 $ 322,156 Accrued liabilities 122,192 216,533 215,474 Income taxes payable 10,645 25,698 22,349 Current portion of long-term debt 42,200 42,200 42,200 Total current liabilities $ 423,531 $ 651,295 $ 602,179 Long-term liabilities Long-term debt 425,311 400,311 375,100 TOTAL LIABILITIES $ 848,842 $ 1,051,606 $ 977,279 STOCKHOLDERS' EQUITY Common Stock $ 370,124 $ 356,758 $ 320,841 Additional paid-in-capital 29,546 24,881 21,910 Retained earnings 902,731 578,594 273,880 Total stockholders' equity $ 1,302,401 $ 960,233 $ 616,631 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ 2,151,243 $ 2,011,839 $ 1,593,910
RATIO ANALYSIS December 31, 2014 LIQUIDITY RATIOS: 12/31/14 12/31/13 CHANGE % CHANGE Current ratio Current assets/Current liabilities Quick Ratio (Current assets - Inventory) / Current liabilities Accounts receivable turnover Sales/Average accounts receivable Days' sales in accounts receivable 365/Accounts receivable turnover Inventory turnover Cost of goods sold/Average inventory PROFITABILITY/ PERFORMANCE RATIOS: Profit margin Net income/Net sales Gross profit margin (%) Gross profit/Sales Earnings per share Net income/Number of shares of stock Total asset turnover Sales/Total assets Working capital turnover Sales/(Current assets - Current liabilities) EQUITY POSITION RATIOS: Stockholders' equity ratio Total stockholders' equity/ Total assets Current debt to equity Current liabilities/ Total stockholders' equity Debt to equity Total liabilities/ Total stockholders equity
ABC COMPANY INCOME STATEMENT FOR THE PERIOD ENDED DECEMBER 31, 2014 2014 2013 CHANGE % CHANGE Sales $ 1,572,134 $ 1,413,581 Cost of goods sold 601,215 556,721 Gross profit $ 970,919 $ 856,860 EXPENSES Advertising $ 55,153 $ 50,531 Depreciation 21,442 21,442 Bad debts 20,151 18,934 Legal 17,261 10,207 Miscellaneous 91,014 31,214 Rent 148,321 142,078 Repairs and maintenance 14,315 13,642 Salaries and wages 47,121 45,312 Utilities 15,912 15,643 Total expenses $ 430,690 $ 349,003 Net income before income tax $ 540,229 $ 507,857 Income tax expense 216,092 203,143 NET INCOME $ 324,137 $ 304,714
ABC COMPANY INCOME STATEMENT FOR THE PERIOD ENDED DECEMBER 31, 2014 2014 % of Sales 2013 % of Sales 2012 % of Sales Sales $ 1,572,134 $ 1,413,581 $ 1,158,417 Cost of goods sold 601,215 556,721 500,702 Gross profit $ 970,919 $ 856,860 $ 657,715 EXPENSES Advertising $ 55,153 $ 50,531 $ 42,150 Depreciation 21,442 21,442 21,442 Bad debts 20,151 18,934 17,943 Legal 17,261 10,207 9,701 Miscellaneous 91,014 31,214 29,104 Rent 148,321 142,078 141,143 Repairs and maintenance 14,315 13,642 11,932 Salaries and wages 47,121 45,312 39,142 Utilities 15,912 15,643 14,217 Total expenses $ 430,690 $ 349,003 $ 326,774 Net income before income tax $ 540,229 $ 507,857 $ 330,941 Income tax expense 216,092 203,143 132,376 NET INCOME $ 324,137 $ 304,714 $ 198,565 Number of shares of stock outstanding 35,913 26,786 23,712
ABC COMPANY BALANCE SHEET AS OF DECEMBER 31, 2014 ASSETS 2014 2013 CHANGE % CHANGE Current assets Cash $ 501,992 $ 434,215 Accounts Receivable 335,272 302,514 Inventory 515,174 505,321 Prepaid Expenses 251,874 231,100 Total current assets $ 1,604,312 $ 1,473,150 Property, plant and equipment 765,215 735,531 Accumulated depreciation (218,284) (196,842) TOTAL ASSETS $ 2,151,243 $ 2,011,839 LIABILITIES Current liabilities Accounts payable $ 248,494 $ 366,864 Accrued liabilities 122,192 216,533 Income taxes payable 10,645 25,698 Current portion of long-term debt 42,200 42,200 Total current liabilities $ 423,531 $ 651,295 Long-term liabilities Long-term debt 425,311 400,311 TOTAL LIABILITIES $ 848,842 $ 1,051,606 STOCKHOLDERS' EQUITY Common Stock $ 370,124 $ 356,758 Additional paid-in-capital 29,546 24,881 Retained earnings 902,731 578,594 Total stockholders' equity $ 1,302,401 $ 960,233 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ 2,151,243 $ 2,011,839
ABC COMPANY BALANCE SHEET AS OF DECEMBER 31, 2014 ASSETS 2014 % TOTAL ASSETS 2013 % TOTAL ASSETS 2012 % TOTAL ASSETS Current assets Cash $ 501,992 $ 434,215 $ 375,141 Accounts Receivable 335,272 302,514 241,764 Inventory 515,174 505,321 310,885 Prepaid Expenses 251,874 231,100 136,388 Total current assets $ 1,604,312 $ 1,473,150 $ 1,064,178 Property, plant and equipment 765,215 735,531 705,132 Accumulated depreciation (218,284) (196,842) (175,400) TOTAL ASSETS $ 2,151,243 $ 2,011,839 $ 1,593,910 LIABILITIES Current liabilities Accounts payable $ 248,494 $ 366,864 $ 322,156 Accrued liabilities 122,192 216,533 215,474 Income taxes payable 10,645 25,698 22,349 Current portion of long-term debt 42,200 42,200 42,200 Total current liabilities $ 423,531 $ 651,295 $ 602,179 Long-term liabilities Long-term debt 425,311 400,311 375,100 TOTAL LIABILITIES $ 848,842 $ 1,051,606 $ 977,279 STOCKHOLDERS' EQUITY Common Stock $ 370,124 $ 356,758 $ 320,841 Additional paid-in-capital 29,546 24,881 21,910 Retained earnings 902,731 578,594 273,880 Total stockholders' equity $ 1,302,401 $ 960,233 $ 616,631 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ 2,151,243 $ 2,011,839 $ 1,593,910
Financial Statement Analysis to Detect Possible Fraud - Case Study 4, Chapter 6
Download the Excel file for ABC Company found in Case Project files. Then, complete the following:
Prepare required ratio analysis and then complete the horizontal and vertical analysis using the Excel file.
Based on your horizontal and vertical analysis, identify at least three possible red flags and indicate if a reasonable explanation exists in 12 sentences for the areas of concern you choose.
Based on the ratio analysis, indicate at least three areas where you can identify revenue fraud may have occurred. Provide specific details in your paragraph explanation of each.
Based on the ratio analysis, indicate at least three areas where you can identify inventory fraud may have occurred. Provide specific details in your paragraph explanation of each.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started