QuestionQuestion

Transcribed TextTranscribed Text

Financial Statement Analysis Worksheet Part 1. Identify Ratios Identify the ratio that corresponds with the following descriptions. Enter your answers in the shaded boxes. Description Ratio Measures a company’s ability to make and collect sales Provides information on how well a company manages its inventory Measures the return to each share of stocked owned by an investor Shows the ability of a company to generate profits from sales Measures a companys’ ability to generate profits from equity Measures a company’s capital structure by showing the percentage of assets provided by creditors Measures a company’s capital structure and financial leverage using liabilities and equity Show the ability to pay current liabilities immediately by measuring the difference between quick assets and current liabilities Measures the ability to pay interest out of current earnings Measures the ability to pay current obligations by comparing current assets to current liabilities Provides an indication of investor perceptions of the company by comparing net income to stock price Measures a company’s ability to generate profits from its entire resource base Page 2 ` Part 2. Horizontal Analysis Foothills Company’s income statements for 2012 and 2011 are shown below: Foothills Company Income Statements For the Years ending December 31 2012 2011 Sales $ 825,000 $ 700,000 Cost of goods sold 390,000 350,000 Gross profit $ 435,000 $ 350,000 Operating expenses 200,000 130,000 Operating income $235,000 $220,000 Interest expense 80,000 50,000 Income before taxes $ 155,000 $ 170,000 Income tax expense 59,000 64,000 Net income $ 96,000 $ 106,000 a. Prepare a horizontal analysis of Foothill’s income statements, rounding the percentages to one decimal point. Enter your answers in the shaded boxes. $ Change % Change Sales Cost of goods sold Gross profit Operating expenses Operating income Interest expense Income before taxes Income tax expense Net income b. Based on your calculations, write a brief interpretation of this analysis. Page 3 ` Part 3. Vertical Analysis Blue Cloud Inc.’s income statements for 2012 and 2011 are shown below: Blue Cloud Inc. Income Statements For the Years ending December 31 2012 2011 Sales $1,500,000 $1,900,000 Cost of goods sold 800,000 950,000 Gross profit $ 700,000 $ 950,000 Operating expenses 330,000 420,000 Operating income $370,000 $530,000 Interest expense 95,000 100,000 Income before taxes $ 275,000 $ 430,000 Income tax expense 96,000 115,000 Net income $ 179,000 $ 315,000 a. Prepare a vertical analysis of Blue Cloud’s income statements, rounding the percentages to one decimal point. Enter your answers in the shaded boxes. 2012 % 2011 % Sales $1,500,000 $1,900,000 Cost of goods sold 800,000 950,000 Gross profit 700,000 950,000 Operating expenses 330,000 420,000 Operating income 370,000 530,000 Interest expense 95,000 100,000 Income before taxes 275,000 430,000 Income tax expense 96,000 115,000 Net income $ 179,000 $ 315,000 b. Based on your calculations, write a brief interpretation of this analysis. Page 4 ` Part 4. Ratio Analysis Blue Cloud Inc.’s 2012 Income Statement and Comparative Balance Sheet follow. Blue Cloud Inc. Income Statement For the Year ending December 31 2012 Sales $1,500,000 Cost of goods sold 800,000 Gross profit $ 700,000 Operating expenses 330,000 Operating income $370,000 Interest expense 95,000 Income before taxes $ 275,000 Income tax expense 96,000 Net income $ 179,000 Comparative Balance Sheet 2012 2011 Cash $ 60,000 $ 75,000 Accounts receivable 190,000 230,000 Inventory 180,000 210,000 Prepaid insurance 70,000 100,000 Total current assets $ 500,000 $ 615,000 Property & equipment 1,020,000 1,130,000 Accumulated depreciation 550,000 600,000 Total property and equipment 470,000 530,000 Total assets $ 970,000 $1,145,000 Accounts payable $ 65,000 $ 110,000 Notes payable 55,000 130,000 Total current liabilities 120,000 240,000 Bonds payable 120,000 60,000 Total liabilities 240,000 300,000 Common stock 620,000 685,000 Retained earnings 110,000 160,000 Total stockholders’ equity 730,000 845,000 Total liability & stockholders’ equity $970,000 $1,145,000 Page 5 ` a. Use Blue Cloud’s 2012 Income Statement and Comparative Balance sheet to calculate the ratios below. Enter your answers in the shaded boxes under column a. b. Note if the ratio is a Profitability, Liquidity, or Solvency Ratio. Enter your answers in the shaded boxes under column b. Ratio a. Calculation Answer b. Profitability, Liquidity, or Solvency ratio? Profit margin Debt to assets ratio Current ratio Quick ratio Return on assets Times interest earned Inventory turnover ratio Receivables turnover ratio Debt to equity ratio c. Based on your calculations, write a brief interpretation of this analysis.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Accounting Questions
    $18.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Accounting Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats