Question

In: Finance

You have been hired as an analyst for Bank WA and your team is working on...

  1. You have been hired as an analyst for Bank WA and your team is working on an independent assessment of Duck Food Inc. (DF Inc.). DF Inc. is a firm that specializes in the production of freshly imported farm products from New Zealand. Your assistant has provided you with the following data about the company and its industry.

Ratio

2018

2017

2016

2018-

Industry Average

Long-term debt

0.45

0.40

0.35

0.35

Inventory Turnover

62.65

42.42

32.25

53.25

Depreciation/Total Assets

0.25

0.014

0.018

0.015

Days’ sales in receivables

113

98

94

130.25

Debt to Equity

0.75

0.85

0.90

0.88

Profit Margin

0.082

0.07

0.06

0.12

Total Asset Turnover

0.54

0.65

0.70

0.40

Quick Ratio

1.028

1.03

1.029

1.031

Current Ratio

1.33

1.21

1.15

1.25

Interest coverage Ratio

0.9

4.375

4.45

4.65

  1. What can you say about the firm's overall management in terms of the following?

(Be as complete as possible given the above information, but do not use any irrelevant information).

  1. Liquidity                                                                                                      [2 marks]
  2. Efficiency (operational efficiency)                                                                 [2 marks]
  3. Performance (profitability, margins)                                                               [2 marks]
  4. Leverage                                                                                                    [2 marks]

  1. If current liabilities of the company was 2.75 million in 2018 and daily cash expenditure was 0.013million, using the data provided in the table, calculate the defensive interval ratio.           

[2 marks]

Solutions

Expert Solution

Answer -

1. - Liquidity can be analysed by using Qucik and current ratio

Explanation: Quick ratio is in line with industry average for 2018 and current ratio is better than industry average in 2018. However, company improved its current ratio over the last 3 years.

2. Efficiency can be analysed by Total asset turnover, Inventory Turnover, Days’ sales in receivables

Explanation:

Total asset turnover is better than industry level in 2018 (higher the better). However, ratio is coming down over the last 3 years. Company efficicency is degrading

Inventory turnover is deteriorating over the last three years and much higher the industry average in 2018 (Lower the better) , Company efficicency is degrading

Day's sales in receivable is better than industry in 2018. However, days are increasing over the last three years (lower the better). Overall, company is prforming good in comparision to industry

Performance ratios: Profitabiltiy can be analysed by profit margin

Explanation:

Profit margin ratio is much below the industry ratio in 2018. Howver, company is improving in last three years. company management should match the industry levels.

Leverage ratio's: Levarege can be analysed by Long-term debt , Debt to Equity, Interest coverage ratio:

Explanation:

Company's debt is increasing over the three years and above the industry average measured by long term debt ratio. It means company is acquiring more debts to fund their operations. Company should lower the debt

Debt to equity: Ratio is better than the industry and decreasing over the last three years which is better for the company

Interest coverage ratio: This is ratio is deterorating from the last three years and much below the industry average. Management should improve the EBIT or reduce the interest payments to improve the ratio.

Please note that we are allowed to 4 parts of the same question. To get the answer of other question, please post it seperately.


Related Solutions

You have been hired as an analyst for Bank WA and your team is working on...
You have been hired as an analyst for Bank WA and your team is working on an independent assessment of a firm that specializes in the production of freshly imported farm products from New Zealand. Your assistant has provided you with the following data about the company and its industry. Ratio 2019 2018 2017 2019- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25 0.014 0.018 0.015 Days’ sales in receivables 113...
You have been hired as an analyst for Bank WA and your team is working on...
You have been hired as an analyst for Bank WA and your team is working on an independent assessment of Duck Food Inc. (DF Inc.). DF Inc. is a firm that specializes in the production of freshly imported farm products from New Zealand.  Your assistant has provided you with the following data about the company and its industry. Ratio 2018 2017 2016 2018- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25 0.014...
You have been hired as an analyst for Bank WA and your team is working on...
You have been hired as an analyst for Bank WA and your team is working on an independent assessment of Duck Food Inc. (DF Inc.). DF Inc. is a firm that specializes in the production of freshly imported farm products from New Zealand. Your assistant has provided you with the following data about the company and its industry. Ratio 2018 2017 2016 2018- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25...
You have been hired as an analyst for Melvin Bank and your team is working on...
You have been hired as an analyst for Melvin Bank and your team is working on an independent assessment of TWINKY, which is a firm that specializes in the production and distribution of ice and glass products in Sweden. Your assistant has provided you with the following data about the company and its industry. You analysis should include intra-company, inter-company, and industry benchmark comparisons. What can you say about the firm's overall management in terms of the following? (Be as...
You have been hired as an analyst for Mellon Bank and your team is working on...
You have been hired as an analyst for Mellon Bank and your team is working on an independent assessment of Daffy Duck Food Inc. (DDF Inc.) DDF Inc. is a firm that specializes in the production of freshly imported farm products from France. Your assistant has provided you with the following data for Flipper Inc and their industry. Ratio 1999 1998 1997 1999- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25...
You have been hired as an analyst for sterling professional consult and your team is working...
You have been hired as an analyst for sterling professional consult and your team is working on an independent assessment of DD food inc. (DDF Inc). DDF Inc is a firm that specializes in the production of freshly imported farm products from France. Your assistant has provided you with the following data for DDF Inc and their industry. Ratio 2017 2016 2015 industry average Long term debt 0.45 0.4 0.35 0.35 inventory turnover 62.65 42.42 32.25 53.25 depreciation/total asstes 0.25...
1. You have been hired as an analyst for an advisory company and your team is...
1. You have been hired as an analyst for an advisory company and your team is working on an independent assessment of G-Aviation. G-Aviation is a firm that specializes in the production of aviation material. Your assistant has provided you with the following data for G-Aviation and their industry. Ratio 2019 2018 2017 2019- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25 0.014 0.018 0.015 Days’ sales in receivables 113 98...
You have been recently hired by Bank of Wealth Investment Brokers as a Portfolio Analyst. On...
You have been recently hired by Bank of Wealth Investment Brokers as a Portfolio Analyst. On your first day in the position, the Portfolio Manager requested that you design a short in-service training session for the new research interns in your department on the mechanics of the primary and secondary markets, including the various types of security regulators and a brief history of the stock market. You will need to develop an Information Sheet that explains the similarities and differences...
You have been hired by Amazon to serve as their international financial analyst. Your first task...
You have been hired by Amazon to serve as their international financial analyst. Your first task is to support Amazon’s M&A prospecting efforts by create a country risk rating for three countries: Algeria, Hungary, and Laos. To do so, you must select and use a method to assess these country’s risks. Name and describe a method (or methods) that you would use to gather information to evaluate these three countries’ risks. Name at least three steps Amazon can take to...
Congratulations, you have been hired as an analyst at the Procter and Gamble Co. (PG).  Your first...
Congratulations, you have been hired as an analyst at the Procter and Gamble Co. (PG).  Your first assignment is to estimate the appropriate rate that a new 30-year bond would need in order to be issued competitively to the public.  It is April 1, 2020 (ignore actual current market rates).  PG just made a coupon payment (semi-annual) on its "8% 2045" bonds that mature on April 1, 2045. The bonds currently sell for 104 with a par value of 100.  Kimberly-Clark Corp. (KMB) has...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT