Question

In: Finance

Label each section Below is selected balance sheet and income statement information from aldo Company. (in...

Label each section

Below is selected balance sheet and income statement information from aldo Company.

(in millions)

2014

2012

Cash

$ 1,483.36

$   1,536.73

Accounts receivable

735.30

1,097.16

Current assets

2,918.33

3,913.56

Current liabilities

6,157.95

3,385.39

Long-term debt

3,611.63

17,620.81

Short-term debt

4,568.83

1,033.96

Total liabilities

26,363.17

23,218.42

Interest expense

1,338.29

1,566.90

Capital expenditures

211.50

1,545.48

Equity

-7,152.90

4,587.67

Cash from operations

185.98

110.89

Earnings before interest and taxes

1,902.84

1,594.84

a. Compute the following liquidity, solvency and coverage ratios for both years.

  • Current ratio (2014, 2012)
  • Liabilities-to-equity (2014, 2012)  
  • Times interest earned (2014, 2012)
  • Cash from operations to total debt (2014, 2012)
  • Free operating cash flow to total debt (2014, 2012)

b.  What is your overall assessment of the company’s credit risk? Explain. What differences do you observe between the two years? Please be brief.

Solutions

Expert Solution

Ratios 2014 2012 Calculations 2014 Calculations 2012
Current ratio 0.47 1.16 2918.33/6157.95 3913.56/3385.39
Liabilities to equity -3.69 5.06 26363.17/-7152.9 23218.42/4587.67
Times interest earned 1.42 1.02 1902.84/1338.29 1594.84/1566.9
Cash from operations to total debt 0.02 0.01 185.98/(3611.63+4568.83) 110.89/(17620.81+1033.96)
Free operating cash flow to total debt 0.00 -0.08 (185.98-211.5)/(3611.63+4568.83) (110.89-1545.48)/(17620.81+1033.96)

b) The company has high credit risk. It is not generating enough cash to meet its future requirements. Though some of the ratios such as times interest earned, cash from operations to total debt and free operating cash flow to debt has improved but the numbers are not convincing. The company is at high credit risk and its main focus should be to generate more operating cash flows. Moreover, the company has negative equity balance which suggests that the company has high leverage which could pose problems in repaying them with decreased available cash flows.

Its short term liquidity is a concern too, as the current ratio of the company has come down in the past two years.

In the past two years, ratios like times interest earned, cash from operations to total debt and free operating cash flow to total debt has improved marginally indicating the management is working towards improving its credit profile. However, its short term liquidity is still a concern as the current ratio has decreased drastically. Thus, as I have discussed before the company's credit profile is at risk and it has high leverage which is a concern.


Related Solutions

Below is selected balance sheet and income statement information from O'Reilly (in millions) 2019 2017 Cash...
Below is selected balance sheet and income statement information from O'Reilly (in millions) 2019 2017 Cash $   1,600.00 $ 1,500.00 Accounts receivable 1,197.16 835.30 Current assets 4,013.56 3,018.33 Current liabilities 3,485.39 6,257.95 Long-term debt 17,620.81 3,611.63 Short-term debt 1,133.96 4,668.83 Total liabilities 23,318.42 26,463.17 Interest expense 1,666.90 1,438.29 Capital expenditures 1,645.48 1,211.50 Equity 4,600.00 -7,200.00 Cash from operations 610.89 685.98 Earnings before interest and taxes 1,594.84 2,002.84 Compute the following liquidity, solvency and coverage ratios for both years. (Round each...
Below is selected balance sheet and income statement information from Fuller Enterprises. 2017 2016 Current assets...
Below is selected balance sheet and income statement information from Fuller Enterprises. 2017 2016 Current assets $ 26,148 $   29,879 Current liabilities 38,063 36,129 Total debt 123,896 125,545 Total Liabilities 206,493 209,242 Equity 76,434 72,613 Earnings before interest and taxes 27,777 27,476 Interest expense 3,180 3,384 Net cash flow from operating activities 18,812 18,620 Compute the current ratio for each year and discuss any trend in liquidity. Compute times interest earned, liabilities-to-equity, and cash from operations to total debt ratios...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
The income statement and selected balance sheet information for Direct Products Company for the year ended...
The income statement and selected balance sheet information for Direct Products Company for the year ended December 31 are presented below. Income Statement Sales Revenue $ 51,600 Expenses: Cost of Goods Sold 22,500 Depreciation Expense 2,300 Salaries and Wages Expense 9,300 Rent Expense 4,800 Insurance Expense 2,050 Interest Expense 1,950 Utilities Expense 1,550 Net Income $ 7,150 Selected Balance Sheet Accounts Ending Balances Beginning Balances Accounts Receivable $ 575 $ 610 Inventory 960 755 Accounts Payable 435 490 Prepaid Rent...
From the information below prepare, in proper accounting form the, Income Statement, Balance Sheet, and Statement...
From the information below prepare, in proper accounting form the, Income Statement, Balance Sheet, and Statement of Changes in Owners’ Equity, and Statement of Cash Flows for 2016 and 2017. In your Income Statement Calculation, include Subtotals for EBITDA, EBIT, and EBT in addition to Net Income. You must submit your answers in either a MS Word or an MS Excel file. TANDY COMPANY Year Ending 6/30/2017 6/30/2016 6/30/2015 Common Stock 100,000 shares outstanding $460,000 $460,000 $460,000 Net Receivables 632,160...
Using the information presented below, prepare an income statement and the balance sheet from the adjusted...
Using the information presented below, prepare an income statement and the balance sheet from the adjusted trial balance of McTangy Spices. McTangy Spices. Adjusted Trial Balance December 31 Cash %bodyamp;nbsp; 3,050 Accounts receivable 400 Prepaid insurance 830 Office supplies 80 Office equipment 4,200 Accumulated depreciation–office equipment $ 1,100 Buildings 98,000 Accumulated depreciation–buildings 28,000 Land 115,000 Wages Payable 880 Property taxes payable 1,400 Interest payable 2,200 Unearned rent 460 Notes payable 150,000 McTangy Spices, Capital Stock 40,340 McTangy Spices, Dividends 21,000...
Selected balance sheet information and the income statement for Fountainhead Corporation for the current year are...
Selected balance sheet information and the income statement for Fountainhead Corporation for the current year are presented below. Selected Balance Sheet Accounts Prior Year Current Year Accounts Receivable $ 26,200 $ 18,000 Merchandise Inventory 36,000 39,600 Prepaid Rent 2,600 0 Accounts Payable 20,600 26,800 Salaries and Wages Payable 5,200 7,800 Income Statement Sales Revenue $ 540,000 Expenses: Cost of Goods Sold 308,000 Depreciation Expense 36,000 Salaries Expense 54,000 Rent Expense 21,600 Insurance Expense 21,600 Interest Expense 19,800 Utilities Expense 18,000...
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 $31,042 $26,250 $10,338 $1,058 $57,628 $36,834 2015 29,158 23,169 9,454 838 55,234 37,203 2014 25,983 19,027 8,799 600 36,224 37,963 a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information from...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information from Verizon Communications follows. ($ millions) 2005 2004 Current assets $ 16,448 $ 19,479 Current liabilities 25,063 23,129 Total debt 39,010 39,267 Total liabilities 101,696 103,345 Equity 66,434 62,613 Earnings before interest and taxes 12,787 12,496 Interest expense 2,180 2,384 Net cash flow from operating activities $ 22,012 $ 21,820 (a) Compute the current ratio for each year and discuss any trend in liquidity. (Round...
1. The following is selected financial information from Tilly’s, Inc. Prepare the Income Statement, Balance Sheet...
1. The following is selected financial information from Tilly’s, Inc. Prepare the Income Statement, Balance Sheet and Cash Flow for February 2014 and 2013 using the below info. Tillys info ($thousands) Feb 1 2014 Feb 2 2013 Cash and cash equlvalents 25412 17315 Cash flow from operations 43794 41730 Cost of goods sold 343542 317096 Total liabilities 91484 88085 Total assets 232407 205381 Cash flow from financing 1834 22819 Sales revenue 495837 467291 Cash flow from investing (37530) (72326) Other...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT