? ??

??

Assume that Alpha and Omega compete in the same four-digit SIC code industry and offer comparable products and services. The following table contains their reported financial performance and condition for the last two years: Balance Sheet Assets-Cash Assets-Accounts Receivable Assets-Long-Term Assets Liabilities-Current Liabilities-Long-Term Liabilities Stockholders' Equity 400 Liabilities and Stockholders' Equity 1,000 Income Statement Revenues Costs of Goods Sold Gross Profit Operating Expenses Operating Income Statement of Cash Flows Operating Income Alpha Company Year 1 Year 2 Analysis Year 1 Year 2 250 480 250 330 500 900 1,000 1,710 400 750 200 375 600 1,125 585 Depreciation Operating Cash Operating Cash Flows 1,200 500 700 600 100 100 25 125 1,710 2,200 925 1,275 1,090 92% 250 480 32% 250 530 80% 900 1,910 185 45 230 500 71% 1,000 88% 750 88% 375 88% 600 1,125 46% 400 785 71% 1,000 1,910 83% 1,200 2,400 85% 500 925 82% 700 1,475 82% 600 1,090 185 85% 100 385 400 200 85% 80% 84% 100 25 125 385 -155 230 Omega Company Analysis 92% 112% 80% 91% 88% 88% 88% 96% 91% 100% 85% 111% 82% 285% 285% -720% 84% 1. Using the financial statement data provided, complete the following assignments: a. Describe any symptoms of fraud b. Draw a conclusion about fraud predication and recommend next steps. 2. Assume that industry ratios were derived from a reputable source. Compute the year 1 and year 2 ratios for Alpha and Omega: Ratios Current Ratio Debt-to-Assets Ratio Return on Assets Gross Margin Operating Cash Flow/Income Dupont Expression Ratios Risk-Assets-to-Equity Alpha Company Year 1 Year 2 Industry Year 1 Year 2 0.63 0.64 0.600 0.658 11% 10% 58% 58% 125% 124% 2.50 2.92 1.29 8% 1.15 0.63 0.64 0.625 0.600 0.589 10% 58% 125% 10% 20% 58% 61% 125% 60% 2.50 2.43 1.20 1.26 8% 16% Omega Company Industry 1.15 0.625 10% 58% 125% 2.75 1.25 8% 27% 2.75 Revenue Generation-Asset Turn 1.20 1.25 Profits-Profit Margin 8% 8% Return on Equity 25% 32% 27% 25% 49% 3. Using your calculated ratios from assignment 2 in concert with the metrics calculated in assignment 1, complete the following assignments: a. Describe any symptoms of fraud b. Combine the findings in the ratio analysis with the metrics calculated in assignment 1 and draw a conclusion about fraud predication and recommend next steps. EXTRE, fo Alaha and 4. Assume that nonfinancial metrics were derived from reliable public and internal sources. Complete the analysis of NFMs for Alpha and Omega: Alpha Company Omega Company Analysis Analysis of Nonfinancial Metrics Year 1 Year 2 Analysis Year 1 Year 2 Retail Square Footage 57,000 105,000 84% 57,000 105,000 84% # Employees 1,140 82% 1,140 2,075 82% #Store Locations 95 79% 95 170 79% 5. Using your calculated metrics from assignments 1 an 2 in concert with the metrics calculated in assignment 4, complete the following assignments: 2,075 170 a. Describe any symptoms of fraud b. Combine the findings in the NFMs with the ratio analysis computed in assignment 2 and percentages calculated in assignment 1 and draw a conclusion about fraud predication and recommend next steps.