Question

In: Accounting

Question: Based upon the financial ratio analysis you will have performed on Milan Fashions, would do...

Question: Based upon the financial ratio analysis you will have performed on Milan Fashions, would do you recommend that there should be an approval of the loan request? I want you to state your analysis in a detailed memorandum to me by Monday of next week. I would like to discuss your analysis and hear your ideas on Milan Fashions in a meeting on Tuesday. The clients will be in our offices next Friday to discuss their loan request. Please feel free to contact me if there are any questions on this matter.

Industry Financial Radio Standards

Ratio

Industry Norm

Milan Fashions Ratios 2015

Evaluation*

Current ratio

4.5 times

13.25

Good

Long-term debt-to-Equity ratio

12%

5.36%

Good

Debt-to-Equity ratio

30%

10.08%

Good

Total Debt ratio

20%

9.16%

Good

Financial leverage ratio

1.10

1.1

Fair

Inventory turnover

7 times

6 times

Poor

Fixed asset turnover

1.8 times

2.99 times

Good

Debt-to-Capital ratio

43.4%

10.32%

Good

Interest coverage ratio

5.0 times

18 times

Good

Return on Assets

8.4%

2.15%

Poor

Ratio

Industry Norm

Milan Fashions Ratios 2016

Evaluation*

Current ratio

4.5 times

21.54

Good

Long-term debt-to-Equity ratio

12%

6.92%

Good

Debt-to-Equity ratio

30%

9.86%

Good

Total Debt ratio

20%

8.97%

Good

Financial leverage ratio

1.10

1.1

Fair

Inventory turnover

7 times

6 times

Poor

Fixed asset turnover

1.8 times

2.6 times

Good

Debt-to-Capital ratio

43.4%

10.17%

Good

Interest coverage ratio

5.0 times

20 times

Good

Return on Assets

8.4%

2.22%

Poor

Solutions

Expert Solution

Answer: I have presented the comparison as per below picture which will make analysis more easy:

Now based on ratio, we can say that as the ratio related to Loans seems good and are appropriately covered, the loan approval can be taken into consideration.

First, we need to more focus on Interest Coverage ratio first which shows the company interest payment capacity or how easily company can pay interest on outstanding Loan. The ratio is calculated by dividing a company's earnings before interest and taxes (EBIT) by the company's interest expenses for the same period which is good in the given scenario.

Secondly, we need to look for Debt related ratio and let's start as below:

Long-term debt-to-Equity ratio: This ratio is calculated by taking the company's long-term debt and dividing it by the book value of common equity. The greater a company's leverage, the higher the ratio. as this is lower as compared to Industry then it's a good symbol. However it has increased as compared to previous year but still holds good.

Debt-to-Equity ratio: The formula for the debt to equity ratio is total liabilities divided by total equity. This is also good in the given situation.

Total Debt ratio: This is calculated by dividing total liabilities by total assets. which is again good in given situation.

Debt-to-Capital ratio: This is calculated by taking the company's interest-bearing debt, both short- and long-term liabilities and dividing it by the total capital and seems again good for Milan Fashion.

However being it's a fashion industry, we have to look for Inventory turnover and return on asset ratio too.

Inventory turnover ratio is not good which is calculated by dividing the cost of goods sold for a period by the average inventory for that period. Which means inventory is not moving as per industry standard. Being a fashion industry, it s necessary to have this ration good otherwise, repayment capacity may become threat in Long term.

Return on asset ratio is calculated by dividing net income by average total assets. This ratio can also be represented as a product of the profit margin and the total asset turnover. This is very poor in given case.

Conclusion: As a conclusion, it can be said that short term loan can be considered however it is recommended to avoid long term loans. As mainly all debts related ratios are good but profitability and inventory turnover ratio are poor.


Related Solutions

Question: Based upon your financial ratio analysis, what questions would you like to propose to management...
Question: Based upon your financial ratio analysis, what questions would you like to propose to management to gain clarity on the business operations? Industry Financial Ratio Standards: Ratio Industry Norm Milan Fashions Ratios 2015 Evaluation* Current ratio 4.5 times 13.25 Good Long-term debt-to-Equity ratio 12% 5.36% Good Debt-to-Equity ratio 30% 10.08% Good Total Debt ratio 20% 9.16% Good Financial leverage ratio 1.10 1.1 Fair Inventory turnover 7 times 6 times Poor Fixed asset turnover 1.8 times 2.99 times Good Debt-to-Capital...
Financial Statement Analysis, specifically Ratio Analysis is often performed by managers, investors, and creditors.
Financial Statement Analysis, specifically Ratio Analysis is often performed by managers, investors, and creditors. What is the primary goal of each of these groups when evaluating ratios?
Which of the 3 analysis techniques (pie chart, financial statement, ratio analysis) would you as a...
Which of the 3 analysis techniques (pie chart, financial statement, ratio analysis) would you as a planner use, and with that in mind, what would be important … and how would you present those findings to your client.
How would you do a horizontal analysis, vertical analysis and ratio analysis for IBM? Can someone...
How would you do a horizontal analysis, vertical analysis and ratio analysis for IBM? Can someone an example of this? Can it be done for years 2016 and 2017?
How would you do a horizontal analysis, vertical analysis and ratio analysis for Apple? Can someone...
How would you do a horizontal analysis, vertical analysis and ratio analysis for Apple? Can someone an example of this?
Q4 You have performed the common sizing and horizontal analysis to the financial statement of X...
Q4 You have performed the common sizing and horizontal analysis to the financial statement of X co. You have selectively considered the current (Year 0) parameters as mentioned in the table below. Based on the value's, you have calculated the Year 1 ratios and growth rates Particulars Year 0 Year 1 Growth rate in Sales revunes (y-o-y) N/A 4% Gross Profit Margin 33% 34% SG& A expenses/ Saled revenue 25% 25% Depreciation Net PPEt-1 10% 10% Net working Capital Turnover...
How would you do a ratio analysis for IBM for years 2016 and 2017?
How would you do a ratio analysis for IBM for years 2016 and 2017?
Briefly describe how you would have performed the heart dissection as if you were to do...
Briefly describe how you would have performed the heart dissection as if you were to do it in class. What are the major structures you can see?
Common tools of financial statement analysis such as horizontal analysis, vertical analysis and ratio analysis have...
Common tools of financial statement analysis such as horizontal analysis, vertical analysis and ratio analysis have helped to uncover fraud by identifying amounts that are out of line with expectations. Discuss how these tools can help to identify fraud schemes early and whether they are useful in preventing frauds overall.
Common tools of financial statement analysis such as horizontal analysis, vertical analysis and ratio analysis have...
Common tools of financial statement analysis such as horizontal analysis, vertical analysis and ratio analysis have helped to uncover fraud by identifying amounts that are out of line with expectations. Discuss how these tools can help to identify fraud schemes early and whether they are useful in preventing frauds overall.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT