FINANCIAL STATEMENT ANALYSIS PARTI DATA XYZ.COM mer To VECAMY M. pi Ted Tool T Cure FINANCIAL STATEMENT ANALYSIS OLLENAME PARTOESTROS ANTERS FINANCIAL STATEMENT ANALYSIS PARTI DATA XYZ.COM mer To VECAMY M. pi Ted Tool T Cure FINANCIAL STATEMENT ANALYSIS OLLENAME PARTOESTROS ANTERS FINANCIAL STATEMENT ANALYSIS QUIZ PART I. DATA XYZ COMPANY Income Statement For the Years Ending December 31, 2013 & 2012 2013 2012 Sales 4,938,750 4,410,000 Sales retums and allowances 220,500 276,750 Net sales 4,718,250 4,133,250 Cost of goods sold 2.882,250 2.565,000 Gross profit 1.836,000 1.568.250 Selling expenses 569,250 475,875 Administrative expenses 612.450 556,875 Total operating expenses 1,181,700 1.032.750 Income from operations 654,300 535,500 Interest expense 60,750 66,375 Net income 593,550 469.125 2012 XYZ COMPANY Statement of Financial Position As of December 31, 2013 & 2012 2013 Assets Intangible assets 33,750 Equipment 1.912,500 Accumulated depreciation -112,500 Prepaid expenses 112,500 Inventory 1,395,000 Accounts receivable 517,500 Short-term investments 45,000 Cash 225,000 Total current assets 2,295,000 Total Assets 4,128,750 Equity & Liabilities Share capital 619,650 Retained earings 1.637.100 Total Equity 2.256,750 Noncurrent liabilities 1,096,875 Current liabilities 775,125 Total liabilities 1.872,000 Total Equity & Liabilities 4,128,750 39,375 1,513.125 -90,000 90,000 1,125.000 405,000 157.500 348,750 2.126,250 3,588,750 607.500 1,181,250 1,788,750 1.118,250 681.750 1,800,000 3.588,750 ANSWERS 1 FINANCIAL STATEMENT ANALYSIS QUIZ NAME PART 2. QUESTIONS & ANSWERS ID What was the percentage change (horizontal analysis) of Sales? What was the percenage change in Inventory? What was the percentage change in Total Equity? What was the percentage change in Current Liabilities? 2 3 4 5 6 What is the vertical percentage for Cost of Goods Sold? (2013 only) What is the vertical percentage for Income from Operations? (2013 only) What is the vertical percentage for Equipment? (2013 only) What is the vertical percentage for Noncurrent Liabilities? (2013 only) 7 8 Calculate the following ratios: 9 Current Ratio 10 Acid Test or Quick Ratio 11 Receivables Turnover Ratio 12 Inventory Turnover Ratio 13 Gross Profit Ratio 14 Profit Margin 15 Return on Assets 16 Return on Equity 17 Asset Turnover 18 Debt-to-Total-Assets Ratio 19 Debt-to-Equity Ratio 20 Times interest earned ratio FINANCIAL STATEMENT ANALYSIS PARTI DATA XYZ.COM mer To VECAMY M. pi Ted Tool T Cure FINANCIAL STATEMENT ANALYSIS OLLENAME PARTOESTROS ANTERS FINANCIAL STATEMENT ANALYSIS PARTI DATA XYZ.COM mer To VECAMY M. pi Ted Tool T Cure FINANCIAL STATEMENT ANALYSIS OLLENAME PARTOESTROS ANTERS FINANCIAL STATEMENT ANALYSIS QUIZ PART I. DATA XYZ COMPANY Income Statement For the Years Ending December 31, 2013 & 2012 2013 2012 Sales 4,938,750 4,410,000 Sales retums and allowances 220,500 276,750 Net sales 4,718,250 4,133,250 Cost of goods sold 2.882,250 2.565,000 Gross profit 1.836,000 1.568.250 Selling expenses 569,250 475,875 Administrative expenses 612.450 556,875 Total operating expenses 1,181,700 1.032.750 Income from operations 654,300 535,500 Interest expense 60,750 66,375 Net income 593,550 469.125 2012 XYZ COMPANY Statement of Financial Position As of December 31, 2013 & 2012 2013 Assets Intangible assets 33,750 Equipment 1.912,500 Accumulated depreciation -112,500 Prepaid expenses 112,500 Inventory 1,395,000 Accounts receivable 517,500 Short-term investments 45,000 Cash 225,000 Total current assets 2,295,000 Total Assets 4,128,750 Equity & Liabilities Share capital 619,650 Retained earings 1.637.100 Total Equity 2.256,750 Noncurrent liabilities 1,096,875 Current liabilities 775,125 Total liabilities 1.872,000 Total Equity & Liabilities 4,128,750 39,375 1,513.125 -90,000 90,000 1,125.000 405,000 157.500 348,750 2.126,250 3,588,750 607.500 1,181,250 1,788,750 1.118,250 681.750 1,800,000 3.588,750 ANSWERS 1 FINANCIAL STATEMENT ANALYSIS QUIZ NAME PART 2. QUESTIONS & ANSWERS ID What was the percentage change (horizontal analysis) of Sales? What was the percenage change in Inventory? What was the percentage change in Total Equity? What was the percentage change in Current Liabilities? 2 3 4 5 6 What is the vertical percentage for Cost of Goods Sold? (2013 only) What is the vertical percentage for Income from Operations? (2013 only) What is the vertical percentage for Equipment? (2013 only) What is the vertical percentage for Noncurrent Liabilities? (2013 only) 7 8 Calculate the following ratios: 9 Current Ratio 10 Acid Test or Quick Ratio 11 Receivables Turnover Ratio 12 Inventory Turnover Ratio 13 Gross Profit Ratio 14 Profit Margin 15 Return on Assets 16 Return on Equity 17 Asset Turnover 18 Debt-to-Total-Assets Ratio 19 Debt-to-Equity Ratio 20 Times interest earned ratio