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

1. Quick ratio= (Cash + Marketable securities+ receivables)/ Current liabilities

= (1050 + 4830)/ (4000+ 2950+ 2300)

= 5880/9250 =0.635= 0.64

the quick ratio is the liquidity ration which measures the current assets available per current liabilities. Higher the ratio, more liquidable is the company. Here the company's quick ratio is below industry average which depicts that the Current liabilities are more than current assets.

2. Average Collection period = accounts receivable

net sales/365

= 4250   

29400/365

=4250/ 80.6 = 52.72 = 53 approx

Average collection period is known as the time taken by the business to receive payments owed by its clients (account receivables).Less the number, the more efficient is the company in recieving their money.

Here the company takes more time collect the account receivable than the industry average.

3. Debt- eqity ratio = debt/ equity

= Total liability / total shareholder's equity

Total debts = long term bonds + notes payable

=2950+5450=8400

Total shareholder's equity= 4620+1680

debt-equity ratio = 8400/6300 = 1.33

debt to equity ratio calculates the leverage of total debt to total equity. This ratio highlights the company's capital structure. Here the company's debt-equity ratio is below the industry average, which shows that the company has more debts and less equity.

4. Return to equity = Net income/ shareholder's equity

= 565/6300= 0.089 = 8.9%

The return to equity shows how the company is utilising the shareholder's money efficiently. It measures the profitability of the organsation in terms of the shareholder's equity. Higher the ROE, higher the efficiency.

Here the ROE is below the industry average of 17% which shows that the company is not efficiently utilising the shareholder's equity.


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