Question

In: Finance

II. Below are the financial statements for Trust Inc. Use the statements to answer the questions...

II. Below are the financial statements for Trust Inc. Use the statements to answer the questions that follow (8 Points)

Balance Sheet (Millions of $)
Assets
Cash 1,050
Accounts receivable 4,830
Inventories 6,450
Net plant and equipment 8,670
Total assets 21,000

Liabilities and Equity
Accounts payable 4,000
Notes payable 2,950
Accruals 2,300
Long-term bonds 5450
Common stock 1,680
Retained earnings 4,620
Total liabilities and equity 21,000

Income Statement (Millions of $)
Net sales 29,400
Operating costs 27,500
Depreciation 515
Interest 520
Taxes 300
Net income 565


Use the financial statements above to:
a. Calculate the ratios given in the table below
b. Interpret the ratios that you calculate
c. Explain the significance of the calculated ratios compared to the industry average

Ratio                                                          Industry Average
Quick ratio                                                     1.25
Average collection period                            40
Debt-to-equity ratio                                       3
Return on equity                                  17%

Solutions

Expert Solution

a] RATIO Trust Inc Industry
Calculation Value
Quick Ratio [(Cash+Accounts receivble)/(Accounts payable+NP+Accruals] = (1050+4830)/(4000+2950+2300) = 0.64 1.25
Average collection period [AR*365/Sales] =4830*365/29400 = 60 40
Debt to equity ratio [Total debt/Total equity] = (4000+2950+2300+5450)/(1680+4620) = 2.33 3
Return on equity [NI/Equity] =(565/6300) = 8.97% 17%
b] The quick ratio tells how many times the quick assets [that is assets that can be realized without much delay, but
excluding inventory] is compared to the current liabilities. It tells us whether the firm will be able to meet its
immediate obligations if, there is a call to do so.
The average collection period tells how many days' sales is outstanding in the receivables or in other words how
many days' sales still remains to be collected. When compared with the credit period allowed, it tells how well
the firm is managing its receivables.
The debt to equity ratio reflectes the financial leverage; the proportion of borrowed capital to owners' capital. It
signifies the risk undertaken by the firm and its creditors.
ROE measures the return on the shareholders' funds. It is a measure of the operational efficiency and financial
management effectiveness of the management.
c] The acid test ratio is only half the industry average. It suggests a precarious postion and indicates that the
firm is moving towards bankruptcy. In contrast the industry is maintaining a safe position.
The ARO is very high and suggest inefficient management of receivables. The firm's ratio is 1.5 times the industry
average ratio.
The D/E ratio is comfortable as the ratio is less than that of the industry.
The ROE is very low compared to the industry. Partly the lower D/E may be the casue. But the major reasons may
be the lower gross and net margins, for which details are not available.

Related Solutions

II. Below are the financial statements for Trust Inc. Use the statements to answer the questions...
II. Below are the financial statements for Trust Inc. Use the statements to answer the questions that follow (8 Points) Balance Sheet (Millions of $) Assets Cash 1,050 Accounts receivable 4,830 Inventories 6,450 Net plant and equipment 8,670 Total assets 21,000 Liabilities and Equity Accounts payable 4,000 Notes payable 2,950 Accruals 2,300 Long-term bonds 5450 Common stock 1,680 Retained earnings 4,620 Total liabilities and equity 21,000 Income Statement (Millions of $) Net sales 29,400 Operating costs 27,500 Depreciation 515 Interest...
Use the pro forma financial statements to answer the questions below. Change the assumptions in the...
Use the pro forma financial statements to answer the questions below. Change the assumptions in the assumptions box as needed to answer the questions. In addition to the assumptions listed on the spreadsheet, also assume that all asset accounts will grow at the same rate as sales and that no new equity will be issued in 2018. 1. Enter a formula for external funding required in the first green box. How much external financing does Ottawa need in 2018? 2....
Use the financial data below from XYZ, Inc. to answer the questions below. Note that the...
Use the financial data below from XYZ, Inc. to answer the questions below. Note that the reported figures are in thousands of dollars: 2015 2014 Inventory $219,686.00 $241,154.00 Cost of Sales $54,661.00 $675,138.00 Net Income $31,185.00 $64,150.00 Tax Rate 37% 37% Note 1: If the first-in, first-out (FIFO) method of accounting for inventory had been used, inventory would have been approximately $26.9 million and $25.1 million higher than reported at 2015 and 2014, respectively. Required: What would the ending inventory...
Examine the financial statements below. Use this information to answer questions 1-7. Note: All figures are...
Examine the financial statements below. Use this information to answer questions 1-7. Note: All figures are in millions of dollars. The XXX Corporation: Balance Sheet, 2018 Cash & marketable securities                $200                Accounts payable                        100 Accounts receivable                              150                Notes payable                         100 Inventories                                           250                Total current liabilities               $200     Total current assets                              $600              Long-term debt                           400                                                                                     Total liabilities                          $600 Fixed assets                                          900                                                                                     Common stock                       50                                                                                     Retained earnings                     850                                                                                         Total...
You should answer all of the questions listed below as they relate to the financial statements...
You should answer all of the questions listed below as they relate to the financial statements of any U.S. public company of your choice in its latest annual report. Please use the Securities and Exchange Commission web site as your primary source for financial statements. All publicly traded U S companies have their annual reports called the 10-K available through the Securities and Exchange Commission web site. http://www.sec.gov/ COMPANY: Delta Airlines Inc. (DAL) Instructions for use of the site are...
Use the financial statements of Heifer Sports Inc. to find the information below for Heifer. (Use...
Use the financial statements of Heifer Sports Inc. to find the information below for Heifer. (Use 365 days a year. Round all answers to 2 decimal places except $ amounts.) Income Statement 2017 Sales $ 5,670,000 Cost of goods sold 2,967,000 Depreciation 293,200 Selling & admin. expenses 1,570,000 EBIT $ 839,800 Interest expense 151,000 Taxable income $ 688,800 Taxes 310,500 Net income $ 378,300 Balance Sheet, Year-End 2017 2016 Assets Cash $ 46,200 $ 67,000 Accounts receivable 632,000 1,159,200 Inventory...
Please answer the list of questions below: 1. Discuss the importance of financial statements and how...
Please answer the list of questions below: 1. Discuss the importance of financial statements and how they are used by businesses. 2. What is the basic format of the income statement and what is the relevance of the basic categories? 3. Cash flows for an organization come from operating activities and investment activities. Discuss the importance of each to the organization. 4. The Happy Auto Shop has the following annual information: Gross Sales $700,000 Net sales $696,000 Gross profit $448,000...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a Recent Year Total sales and revenues ...................................................................................... $55,184,000 Less: Cost of products sold ................................................................................... $40,391,000 Gross profit .......................................................................................,.................... $ 14,793,000 Less: Operating costs : Selling, general, and administrative expenses ................................................ $ 5,697,000 Research and development expenses ............................................................ $2,135,000 Other operating expenses ............................................................................... $1,633,000 Total operating costs ............................................................................................. $ 9,465,000 Operating profit ..................................................................................................... $ 5,328,000 Less: Other expenses ............................................................................................ 245,000 Consolidated profit before taxes .............................................................................
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a Recent Year Total sales and revenues ...................................................................................... $55,184,000 Less: Cost of products sold ................................................................................... $40,391,000 Gross profit .......................................................................................,.................... $ 14,793,000 Less: Operating costs : Selling, general, and administrative expenses ................................................ $ 5,697,000 Research and development expenses ............................................................ $2,135,000 Other operating expenses ............................................................................... $1,633,000 Total operating costs ............................................................................................. $ 9,465,000 Operating profit ..................................................................................................... $ 5,328,000 Less: Other expenses ............................................................................................ 245,000 Consolidated profit before taxes .............................................................................
Questions using the financial statements below: What is the Net Income Margin? State your answer as...
Questions using the financial statements below: What is the Net Income Margin? State your answer as a % and round to the nearest whole number What is the current ratio? Remember that a ratio is stated in reference to 1 (not as a percentage), and you should carry ratio out to two decimal places What is the exact amount that account receivables increased during the year? What is the total Cost of Sales for the year? What month does the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT