Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Integrated Audit Practice Case

Authors: David S. Kerr, Randal J. Elder, Alvin A. Arena

6th Edition

0912503564, 9780912503561

More Books

Students also viewed these Accounting questions

Question

What is Larmors formula? Explain with a suitable example.

Answered: 1 week ago

Question

5. Understand how cultural values influence conflict behavior.

Answered: 1 week ago

Question

e. What do you know about your ethnic background?

Answered: 1 week ago