Once the ratio analysis is completed answer the following questions. 1. Does the
ID: 2463594 • Letter: O
Question
Once the ratio analysis is completed answer
the following questions.
1.
Does the firm have any problem areas that you would investigate further if you were a
manager?
2.
Are there any other specific pieces of information that you would request from your
management team with regards to this firm? If so, why?
3.
Would you invest money in this firm based on your analysis?
Liquidity Ratios
Current ratio = Current assets / Current liabilities
Year 2015
89378 / 80610 = 1.11
Year 2014
68531 / 63448 = 1.08
Year 2013
73286 / 43658 = 1.68
Quick ratio = (Current assets – Inventory) / Current liabilities
Year 2015
(89378 – 2349) / 80610 = 1.08
Year 2014
(68531 – 2111) / 63448 = 1.05
Year 2013
(73286 - 1764) / 43658 = 1.64
*All ratios rounded to two decimal places.*
Profitability Ratios
Return on Equity = Net income after taxes / Common stock holders’ equity
Year 2015
53394 / 119355 = 0.4474 = 44.74%
Year 2014
39510 / 111547 = 0.3542 = 35.42%
Year 2013
37037 / 123549 = 0.2998 = 29.98%
Return on Assets = Net income after taxes / Total assets
Year 2015
53394 / 290479 = 0.1838 = 18.38%
Year 2014
39510 / 231839 = 0.1704 = 17.04%
Year 2013
37037 / 207000 = 0.1789 = 17.89%
Gross Profit Margin = Gross profits / Sales
Year 2015
93626 / 233715 = 0.4006 = 40.06%
Year 2014
70537 / 182795 = 0.3859 = 38.59%
Year 2013
64304 / 170910 = 0.3762 = 37.62%
Operating Profit Margin = Operating profits / Sales
Year 2015
71230 / 233715 = 0.3048 = 30.48%
Year 2014
52503 / 182795 = 0.2872 = 28.72%
Year 2013
48999 / 170910 = 0.2867 = 28.67%
Net Profit Margin = Net income / Sales
Year 2015
53394 / 233715 = 0.2285 = 22.85%
Year 2014
39510 / 182795 = 0.2161 = 21.61%
Year 2013
37037 / 170910 = 0.2167 = 21.67%
*All ratios rounded to two decimal places.*
Activity Ratios
Inventory Turnover = Cost of goods sold / Inventory
Year 2015
140089 / 2349 = 59.64
Year 2014
112258 / 2111 = 53.18
Year 2013
106606 / 1764 = 60.43
Account Receivable Turnover = Sales / Accounts receivable
Year 2015
233715 / 16849 =13.87
Year 2014
182795 / 17460 = 10.47
Year 2013
170910 / 13102 = 13.04
Total Asset Turnover = Sales / Total assets
Year 2015
233715 / 290479 = 0.80
Year 2014
182795 / 231839 = 0.79
Year 2013
170910 / 207000 = 0.83
Average Collection Period = Sales / Accounts receivable = 365 / Receivable turnover
Year 2015
233715 / 16849 = 13.87 = 365 / 13.87 = 26.32
Year 2014
182795 / 17460 = 10.47 = 365 / 10.47 = 34.86
Year 2013
170910 / 13102 = 13.04 = 365 / 13.04 = 27.99
*All ratios rounded to two decimal places.*
Market Ratios
Earnings per Share = Net income available to common stockholders / Shares outstanding
Earnings per Share = (Net profits after taxes – Preferred stock) / Shares outstanding
Year 2015
(53394000 – 12600000) / 5578753 = 7.31
Year 2014
(39510000 - 1260000) / 5866161= 4.59
Year 2013
(37037000 - 12600000) / 6294494 = 3.89
Price Earnings = Market price of common stock / Earnings per share
Year 2015
117.63 / 7.31 = 16.09
Year 2014
108.53 / 4.59 = 23.64
Year 2013
77.18 / 3.89 = 19.84
Market to Book = Market value per share / Book value per share
Market to Book = Market value per share / (Total stock holders’ equity / Shares outstanding)
Year 2015
117.63 / (119355000 / 5578753) = 117.63 / 21.39 = 5.50
Year 2014
108.53 / (111547000 / 5866161) = 108.53 / 19.02 = 5.71
Year 2013
77.18 / (123549000 / 6294494) = 77.18 / 19.63 = 3.93
*All ratios rounded to two decimal places.*
Explanation / Answer
1- Like management of current asset is also a problem because company is good in Quick ratio but underperforming in current ratio so that analyst would require more information regarding management of inventory and receiables.
ii company's Inventory turnover ratio is increasing so further details of Inventory management would be required.
iii comapny EPS is increasing and Book to market ratio is constant while PE ratio is decreasing so further information would be needed to further investigate the issue.
2- some important information would be required
(1) details of income statement and sales value would be required for further investigate the things
(2) details regarding expenditure would also be required so that expenditure management would be done.
(3) details of formation of total assets and liabilties would also be required to check the financial health of company
3-Analysis of Liquidity Ratio
2- Profitability ratio
Operating Profit ratio is also increasing
So overall Profitability ratio are postive so it is a good sign of company's profitability
3- Turnover ratio
debtors collection period is increasing so its a sign of worry about the collection of recivables
So overall turnover ratio are postive and constant so it is a good sign of company's working
4- Market Ratio
PE ratio is decreasing this means market price of the share is not performing well
Market to book value ratio is almost constant that means book value of share is almost equal to market value. its a good sign.
market ratio: all market ratio's are performing well so its a good sign of good financial health of company
Overall conclusion: Investor should opt for the shares of this firm for investment because company is performing in all the areas of like profitablity, working capital management, utilisation of resources and market performance of the comapny.
Year 15 14 13 Comment current ratio 1.11 1.08 1.68 Ideal ratio is 2:1 but company is operating below the ideal ratio. company should focus on working capital management. so its alarming signal to company to work on working capital Management Overall conclusion is that comapny is having excess investment in Inventory Quick Ratio 1.08 1.05 1.04 Ideal ratio is 1:1 and company is having quick ratio around nearby ideal ratio so comapny is managing its core current assets to a great extent. It is okRelated Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.