Question

Selected balance sheet and income statement ($millions) 2013 2012 2011 Net sales $3,794 $3,643 $3,085 Interest...

Selected balance sheet and income statement

($millions)

2013

2012

2011

Net sales

$3,794

$3,643

$3,085

Interest expense

59

49

54

Pretax income

644

665

547

Net income

416

439

368

Current assets

3,152

2,890

2,685

Total assets

4,631

4,159

3,736

Current liabilities

587

627

480

Required

  1. Compute the current ratio for each year and discuss any trends.  Do you feel that the company is sufficiently liquid?  Explain.  What additional information might be helpful in analyzing the liquidity?
  2. Compute times interest earned for each year and discuss any trends.  Do you have any concerns about its level of financial leverage and its ability to meet interest obligations?  Explain.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. Current Ratio = Current Assets / Current Liabilites

In 2011

Current Ratio            =           2685/ 480                        
                                    =            5.59375

In 2012                      

Current Ratio            =           2890/ 627                        
                                    =            4.61

In 2013

Current Ratio            =           3152/ 587                        
                                    =            5.37

In 2011, the company's current assets exceeded its current liabilities by 5.59 times. In 2012, the company's current assets exceeded its current liabilities by 4.62 times and In 2013, the company's current assets exceeded its current liabilities by 5.37 times, Hence in 2011 & 2013 the company has the ability to use it current assets (resources) to pay for its short-term debt (current liabilities) but in 2012 current ratio is lower than 2011 & 2013, therefore; the company is less capable to use it current assets (resources) to pay for its short-term debt as compare to other years.

the company reduced its liquidity position from 2011 to 2012, as indicated in metrics. The current ratio positions is not improved. But the company improved its liquidity position from 2012 to 2013, as indicated in metrics. The current ratio positions is improved.

If we have information of inventory than we can calculate quick ration and analysis that the company has to sell inventory to meet its current debt obligations.

2. Time Interest Earned Ratio         =    Income Before Interest and tax (EBIT) / Interest Expense

In 2011

Time Interest Earned Ratio                 =            547 / 54

                                                                 =            10.13

In 2012

Time Interest Earned Ratio                 =            665 / 49

                                                                 =            13.57

In 2013

Time Interest Earned Ratio                 =            644 / 59

                                                                 =            10.92

In 2012, Company is better at paying off its interest expense as indicated by its times interest earned ratio of 13.57 (as compared to 10.13 in 2011 and 10.92 in 2013), which means that the Company can bear an interest expense 13.57 times its current interest expense.

Add a comment
Know the answer?
Add Answer to:
Selected balance sheet and income statement ($millions) 2013 2012 2011 Net sales $3,794 $3,643 $3,085 Interest...
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
  • E4-38. Compute and Interpret Liquidity and Solvency Ratios Selected balance sheet and income statement information from...

    E4-38. Compute and Interpret Liquidity and Solvency Ratios Selected balance sheet and income statement information from Verizon Communications Inc. for 2012 and 2011 follows ($ millions). Total Current Assets - Total Current Liabilities - Income Before Interest and Taxes - Interest Expense, Gross - Total Liabilities - Stockholders’ Equity 2015. . . . . . $22,280 $35,052 $32,974 $4,920 $226,798 $17,842 2014. . . . . . 29,499 27,987 21,379 4,915 218,940 13,676 a. Compute the current ratio for each...

  • 1. Below is selected balance sheet and income statement information from Diamond Company Current assets Current...

    1. Below is selected balance sheet and income statement information from Diamond Company Current assets Current liabilities Total debt Total Liabilities Equity Earnings before interest and taxes Interest expense Net cash flow from operating activities 2019 $ 46,000 37,000 130,500 216,500 85,000 28,200 4,250 19,000 2018 $ 42,000 36.000 125,000 210,000 82,100 26.400 4,120 15,000 (Required) a) Compute the current ratio for each year. b) Compute times interest earned. c) Compute liabilities-to-equity. d) Compute cash from operations to total debt...

  • E4-37. Compute and Interpret Liquidity and Solvency Ratios Selected balance sheet and income statement information from...

    E4-37. Compute and Interpret Liquidity and Solvency Ratios Selected balance sheet and income statement information from Comcast Corporation for 2015 and 2014 follows ($ millions). Total Income Before Interest and Taxes Total Current Liabilities Current Assets Interest Expense Total Liabilities* Stockholders' Equity 2015. .... $12,303 2014..... 13,531 $18,178 17,410 $15,673 15,001 $2,702 2,617 $112,596 106,118 $53,978 53,068 *Includes redeemable noncontrolling interests a. Compute the current ratio for each year and discuss any trend in liquidity. Do you believe the com-...

  • Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from...

    Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from CVS Health Corp. for 2014 through 2016 follows ($ millions). Total Current Assets Total Current Liabilities EBIT (Operating income) Interest Expense, Gross Total Liabilities Equity 2016 $30,931 $26,250 $10,282 $1,058 $57,628 $36,723 2015 29,047 23,169 9,398 838 55,234 37,092 2014 25,872 19,027 8,743 600 36,224 37,852 a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to...

  • Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic...

    Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. April 26, 2019 $30,557 9,155 2,330 10,418 1,764 Consolidated Statement of Income, 12 Months Ended ($ millions) Net Sales Costs and expenses Cost of products sold Research and development expense Selling, general, and administrative expense Amortization of intangible assets Restructuring charges, net Certain litigation charges Other operating expense, net Operating profit Other nonoperating income, net Interest expense Income before income taxes Income tax...

  • Selected balance sheet and income statement information from Amazon for 2016 through 2018 follows. $ millions...

    Selected balance sheet and income statement information from Amazon for 2016 through 2018 follows. $ millions 2018 2017 2016 Net operating profit after tax (NOPAT) $11,307 $3,319 $2,633 Net income 10,375 3,124 2,442 Operating profit 12,794 4,229 4,312 Interest expense 1,332 797 455 Cash from operating activities 31,645 18,916 17,719 Current assets 77,354 62,003 47,154 Current liabilities 64,288 54,410 41,187 Cash and cash equivalents 32,703 21,138 19,914 Marketable securities 9,785 10,778 6,846 Total debt 22,085 23,258 7,232 Assets 167,527 135,249...

  • Selected are recent balance sheet and income statement information: ($ millions) Ann Taylor Coach Inc Sales...

    Selected are recent balance sheet and income statement information: ($ millions) Ann Taylor Coach Inc Sales $2,212 $4,763 Cost of goods sold 1,004 1,297 Average accounts receivable 19 159 Average inventory 204 463 Average total assets 907 2,870 Required For each company, compute the following: Accounts receivable turnover Inventory turnover Asset turnover Interpret and comment on any differences you observe between the turnover rates for these two companies, i.e. for each ratio, which company has the better result.  

  • Selected balance sheet and income statement information from Amazon for 2016 through 2018 follows. $ millions...

    Selected balance sheet and income statement information from Amazon for 2016 through 2018 follows. $ millions 2018 2017 2016 Net operating profit after tax (NOPAT) $11,307 $3,319 $2,633 Net income 10,375 3,124 2,442 Operating profit 12,794 4,229 4,312 Interest expense 1,332 797 455 Cash from operating activities 31,645 18,916 17,719 Current assets 77,354 62,003 47,154 Current liabilities 64,288 54,410 41,187 Cash and cash equivalents 32,703 21,138 19,914 Marketable securities 9,785 10,778 6,846 Total debt 22,085 23,258 7,232 Assets 167,527 135,249...

  • Please generate an income statement and balance sheet. 2007 is projected to have net sales of...

    Please generate an income statement and balance sheet. 2007 is projected to have net sales of 2.7 million. Please please show your work on how everything was calculated Exhibit 2 Balance Sheet at December 31, 2004-2006, and March 31, 2007 (thousands of dollars) Cash Accounts receivable Inventory Total current assets Property & equipment 2004 S 45 S 187 $.243 $1475 First Quarter 2007 $ 32 $ 290 $ 432 $ 755 Accumulated depreciation Total PP&E, net Total assets $ 187...

  • i Data Table - X Selected income statement data for the current year Net Sales Revenue...

    i Data Table - X Selected income statement data for the current year Net Sales Revenue (all on credit) Cost of Goods Sold Interest Expense Net Income Best Digital 416,830 $ 210,000 Very Network 493,115 258,000 19,000 66,000 49,000 Print Done Clear All Data Table Selected balance sheet and market price data at the end of the current year Best Digital Very Network Current Assets Cash Short-term Investments Accounts Receivables, Net Merchandise Inventory 28,000 $ 39,000 39,000 66,000 19,000 191,000...

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