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. 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.
Selected balance sheet and income statement ($millions) 2013 2012 2011 Net sales $3,794 $3,643 $3,085 Interest...
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 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 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 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 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 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 $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 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 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 (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...