Question

*Calculate all liqudity, debt, activity, and profitability ratios that are found on the table showing a list of Industry Aver
Cross-sectional ratio analysis Use the financial statements below and on page 106 for Fox Manufacturing Company for the year
Fox Manufacturing Company Balance Sheet December 31, 2012 Assets Cash Marketable securities Accounts receivable Inventories T
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a. The ratios have been calculated below:

Formula Calculation Fox company Industry
Current ratio = Current asset/Current liabilities =138300/75000 1.84 2.35
Quick ratio = Current asset- inventories/Current liabilities =(138,300-82,000)/75,000 0.75 0.87
Inventory turnover =Total sales/Total inventory =600,000/82,000 7.32 4.55
Average collection period =Av revenue * 365 Days/Sales = (34,100*365)/600,000 20.74 35.8 days
Total assets turnover =Total sales/Total assets =600,000/408,300 1.47 1.09
Debt ratio =Total debt/Total assets = 225,000/408,300 0.55 0.3
Times interest earned ratio = Operating Profit/Interest =80,000/10,000 8.00 12.3
Gross profit margin =Gross Profit/Sales = 140,000/600,000 0.23 0.202
Operating profit margin = Operating Profit/Sales =80,000/600,000 0.13 0.135
Net profit margin = Net Profit/Sales = 43,000/600,000 0.07 0.091
ROA =Operating Profit/Total Assets = 80,000/408,300 0.20 0.099
ROE =Net Income/Shareholder's Equity =43,000/183,300 0.23 0.167
EPS $2.15 $3.10

The current & quick ratios are relatively weaker compared to the industry averages

Activity ratios: These ratios show that the turover of assets in case of Fox industries is faster compared to the industry average. However, this doesnt indicate the firm's position (weak/strong) compared to the industry. For example, high inventory turnover ratio could show efficient management of receivables, passionate credit department and also credit terms or policies that prohibit growth in sales.

Debt ratios: Debt ratios indicate that the firm uses more debt than the industry average. This results in high int. obligations which could possibly reduce the firm's ability to meet its financial commitments.

Profitability ratios: Profitability ratios indicate that Fox industries have high gross profit margin compared to the industry, showcasing either higher sales price than industry or lower COGS. The operating profit margin is neutral i.e. at par with the industry, but the net profit margin is on the lower end, showcasing that expenses other than COGS are higher than that of the industry.

b. The company should aim to improve its liquidity ratios by mostly reducing the total liabilities. Currently, the firm is highly leverage than the industry avergage, this exposes the Fox industry to more financial risk. Also, the profitability of the company is lower than the industry average but due to the use of debt in capital structure, the company has higher ROE

Image of page 13

Add a comment
Know the answer?
Add Answer to:
*Calculate all liqudity, debt, activity, and profitability ratios that are found on the table showing a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • all that is needed is a common size income statement. the pictures are just all the...

    all that is needed is a common size income statement. the pictures are just all the info provided in the book Prepare a common size income statement for Sterling Company and upload it. You may prepare this in excel or manually. 102 PART 2 Pinancial Tools LO P3-24 Integrative Complete ratio analysis Given the financial statements below and on the following page, historical ratios, and industry averages, calculate Sterling Company financial ratios for the most recent year. (Assume a 365...

  • Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the...

    Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the chapter. MARNI CORPORATION Balance Sheet December 31, 2018 Assets Current assets: Cash $50,000 Accounts receivable 100,000 Inventory 200,000 Total current assets $350,000 Net plant and equipment $650,000 Total assets $1,000,000 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $100,000 Accrued expenses 90,000 Total current liabilities $190,000 Long-term liabilities: Long-term debt: 250,000 Total liabilities $440,000 Stockholders' equity: Common stock 100,000 Capital paid in excess of...

  • $10,006,000 7505000 $2,501,000 Given the following financial statements Sterling Company Income Statement for the Year Ended...

    $10,006,000 7505000 $2,501,000 Given the following financial statements Sterling Company Income Statement for the Year Ended December 31, 2015 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate=40%) Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders Earnings per share (EPS) $293,000 635000 48200 192000 1168200 $1,332,800 212000...

  • Profitability ratios reflect the net result of all the firm's erect. B policies and operating decisions....

    Profitability ratios reflect the net result of all the firm's erect. B policies and operating decisions. The profitability ratios include the: (1) Operating profit margin, (2) Net profit margin, (3) Return on total assets (ROA), (4) Basic earning power (BEP) ratio, and (5) Return on common equity (ROE). The operating profit margin indicates what percentage of sales remain after et B are accounted for. It is a measure of the firm's operating effidency. Its equation is: B. It measures the...

  • Help on my Finance homework please! Integrative: Complete ratio analysis Given the following financial statements, historical...

    Help on my Finance homework please! Integrative: Complete ratio analysis Given the following financial statements, historical ratios, and industry averages, calculate Sterling Company’s financial ratios for the most recent year. (Assume a 365-day year.) Sterling Company Income Statement for the Year Ended December 31, 2019 Sales revenue $10,000,000 Less: Cost of goods sold 7,500,000       Gross profits $ 2,500,000 Less: Operating expenses        Selling expense $ 300,000        General and administrative expenses 650,000        Lease expense 50,000        Depreciation expense...

  • Actual 2019 Dana Dairy Products Key Ratios Industry Actual Average 2018 Current ratio 1.3 1.0 Quick...

    Actual 2019 Dana Dairy Products Key Ratios Industry Actual Average 2018 Current ratio 1.3 1.0 Quick ratio 0.8 0.75 Average collection period 23 days 30 days Inventory turnover 21.7 Debt ratio 64.7% Times interest eamed 4.8 5.5 Gross profit margin 13.6% 12.0% Net profit margin 1.0% 0.5% Return on total assets 2.9% 20% Retum on equity 8.2% 4.0% 19 50% Income Statement Dana Dairy Products For the Year Ended December 31, 2019 Sales revenue $100,000 Less: Cost of goods sold...

  • Dana Dairy Products Key Ratios Industry Actual Actual Average 2009 2010 Current Ratio 1.3 1.0 Quick...

    Dana Dairy Products Key Ratios Industry Actual Actual Average 2009 2010 Current Ratio 1.3 1.0 Quick Ratio 0.8 0.75 Average collection Period 23 days 30 days Inventory Turnover 21.7 19 Debt Ratio 64.7° 50% Times Interest Earned 4.8 5.5 Gross Profit Margin 13.6 12.0% Net Profit Margin 1.0% 0.5 Return on total assets 2.9% 2.0% Return on Equity 8.2 4.0% Income Statement Dana Dairy Products For the Year Ended December 31, 2010 Sales Revenue $100,000 Less: Cost of Goods Sold...

  • LG P3-23 Financial statement analysis The financial statements of Zach Industries for the year ended December...

    LG P3-23 Financial statement analysis The financial statements of Zach Industries for the year ended December 31, 2012, follow. Zach Industries Income Statement for the Year Ended December 31, 2012 $160,000 106,000 $ 54,000 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expens General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes Net profits after $ 16,000 10,000 1,000 10,000 $ 37,000...

  • Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the chapter SNIDER CO...

    Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the chapter SNIDER CORPORATION Balance Sheet December 31, 20X1 Assets Current assets Cash Marketable securitie $ 51,800 24,200 Accounts receivable (net Inventory Total current assets 174,000 227,000 $ 477,000 63,500 Investments Plant and equipment Less: Accumulated depreciation Net plant and equipment $646,000 246,000 400,000 $ 940,500 Total assets Liabilities and Stockholders' Equity Current liabilities Accounts payable Notes payable Accrued taxes $ 91,100 73,400 18,400 Total...

  • Use the attached Income Statement and Balance Sheet to compute the required financial ratios for Seward...

    Use the attached Income Statement and Balance Sheet to compute the required financial ratios for Seward Inc. and compare to the industry averages. After that, write a brief summary as to what each ratio is measuring and how Seward compares to the industry. For example, you may find that Seward's Inventory Turnover is not as high as the industry average, so they are either not managing their inventories or may be experiencing a decrease in sales. Seward Industries a. Compute...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT