1. Calculate the 2008 and 2007 liquidity ratios identified in the table below. Also calculate the change and the percentage change for the ratios and complete this table. (Formulas are given to shorten the time spent on the assignment.)
2. Analyze Chipmunk Company's ratios for both years and compare the figures with the given industry ratios. Based on the ratios identified, where do you think fraud may have occurred?
You are a fraud investigator who has been hired to detect financial statement fraud for Chipmunk Company. You have been provided with the following
financial statements.
align="center">
Financial Statements
Financial statements are the standardized formats to present the financial information related to a business or an organization for its users. Financial statements contain the historical information as well as current period’s financial...
Transcribed Image Text:
CHIPMUNK COMPANY Balance Sheet December 31, 2008 and 2007 ASSETS Current assets 2008 2007 Cash Accounts receivable: net (Notes 2 and 5) Inventories [Notes I(a)3, and 5) Prepaid expenses Deposits $1,320,096 1,646,046 I5,524,349 7,720 7.916 $16,516,12 $1,089,978 1,285,593 12,356,400 15,826 5.484 $14,753,281 Total current assets Property, plant, and equipment [Notes (b) and 4 at cost, less accumulated depredation 596,517 $17,1 12,644 61 2,480 TOTAL ASSETS $15,365,76 LIA BILITIES Notes payable Bank (Note 5) $ 5,100,000 Federal income taxes payable Current portion of long-term debt (Note 6) Total current liabilities TOTAL LIABILITIES STOCKHOLDERS' EQUITY Common stock (Note 7) tal Total stodkholders' equity TOTAL LIABILITIES AND 9,553,263 $17,1 12,644 EQUITY $15,365,761 CHIPMUNK COMPANY Statement of Income and Retained Earnings For the Years Ended December 31, 2008 and 2007 2008 2007 $22,889,060 Sales $26,456,647 Sales returns and allowances 37,557 27,740 Net sales $26,419,090 19,133,299 $7,285,791 $22,861,320 16,530,1 14 $ 6,331,206 Cost of sales Gross profit EXPENSES Accounting Advertising Depreciation Bad debts Business publications Cleaning services Fuel Garbage collection Insurance Interest Legal Licensing and certification fees Linen service Medical benefits Miscellaneous Office supplies Payroll benefits Pension expense Postage and courier $46,750 27,947 46,578 162,344 872 2,809 53,566 4,674 16,303 364,312 29,914 27,142 1,939 4,624 $ 48,253 28,624 46.415 148,252 1,23 15,817 64,161 4,870 6.415 427,362 69,752 33,580 3,044 4,178 47,739 26,390 569,1 10 40,770 8,623 16,63 23,289 461,214 37.263 20,962 Property taxes Repairs and maintenance Salaries and wages Travel and entertainment Total expenses Net income before income tax Income tax expense $6316,336 NET INCOME $ 624,850 Retained earnings at beginning of year Retained earnings at end of year $7,043,263 Ratio Analysis 12/31/2008 Ratio Analysis December 31, 2008 PERCENT CHANGE INDUSTRY CHANGE LIQUIDITY RATIOS: Current ratio [current assets/current liabilities] Quick ratio (current assets - inventory)/current liabilities] Sales/Receivables [net sales/net ending receivables] Number of days sales in A/R [net ending receivables/(net sales/365)] nventory turnover [cost of sales/average inventory] 12/31/08 2/3 1/07 AVERAGE 1.21 0.35 23.42 15.58 1.29