The Board of Directors were worried over the dwindling financial performance and precarious financial position of the Company. The company products were ageing; the economic depression biting harder as a result of the fluctuating exchange rate due to Brexit. The Company imports 60% of the goods sold in Garden City. The fluctuating exchange rate had affected the company’s importation. Consequently, the revenue of the Company dropped significantly. You are required to: A) Calculate the following ratios for the year ended September 30, 2015 and 2016 in Columnar form: i) Return on Capital Employed ii) Total Assets Turnover iii) Quick ratio iv) Debt Equity Ratio v) Fixed Interest cover vi) Earnings Yield vii) Price Earnings Ratio Viii) Dividend Yield The first 3 has been calculated : Return on capital employed for 2016 is 40.32% and for 2015 is 86.84%. 2016 2015 Capital employed = 96500-43800 =52 700 Capital employed = 107500-60000 = 47500 Return on capital employed = 21250/52700 x 100 Return on capital employed = 41250/47500 x 100 = 40.32% = 86.84 Total asset turnover for 2016 is 1.036 and for 2015 is 1.488. 2016 2015 Total assets turnover = Revenue/Current Liabilities Total assets turnover = Revenue/Current Liabilities 100000/43800 = 1.036 160000/60000 = 1.488 Quick ratio for 2016 is 0.548 and for 2015 is 0.708. 2016 2015 Quick assets = 20000 + 4000 = 24 000 Quick assets = 37500+5000 = 42500 Quick ratio = 24000/43 800 = 0.548 Quick ratio = 60000/42500 = 0.708
The Board of Directors were worried over the dwindling financial performance and precarious
financial position of the Company. The company products were ageing; the economic
depression biting harder as a result of the fluctuating exchange rate due to Brexit. The
Company imports 60% of the goods sold in Garden City. The fluctuating exchange rate had
affected the company’s importation. Consequently, the revenue of the Company dropped
significantly.
You are required to:
A) Calculate the following ratios for the year ended September 30, 2015 and 2016 in Columnar
form:
i) Return on Capital Employed
ii) Total Assets Turnover
iii) Quick ratio
iv) Debt Equity Ratio
v) Fixed Interest cover
vi) Earnings Yield
vii) Price Earnings Ratio
Viii) Dividend Yield
The first 3 has been calculated :
- Return on capital employed for 2016 is 40.32% and for 2015 is 86.84%.
2016 |
2015 |
Capital employed = 96500-43800 =52 700 |
Capital employed = 107500-60000 = 47500 |
Return on capital employed = 21250/52700 x 100 |
Return on capital employed = 41250/47500 x 100 |
= 40.32% |
= 86.84 |
- Total asset turnover for 2016 is 1.036 and for 2015 is 1.488.
2016 |
2015 |
Total assets turnover = Revenue/Current Liabilities |
Total assets turnover = Revenue/Current Liabilities |
100000/43800 = 1.036 |
160000/60000 = 1.488 |
- Quick ratio for 2016 is 0.548 and for 2015 is 0.708.
2016 |
2015 |
Quick assets = 20000 + 4000 = 24 000 |
Quick assets = 37500+5000 = 42500 |
Quick ratio = 24000/43 800 = 0.548 |
Quick ratio = 60000/42500 = 0.708 |
Step by step
Solved in 2 steps