Ratio Analysis of Renata Limited (Part 5)

http://www.reportbd.com/articles/1185/1/Ratio-Analysis-of-Renata-Limited-Part-5/Page1.html

Abu Zafour

NAME : Abu Zafour
Fathers Name : M. Fazlur Rahman
Mothers Name : Mrs. Kohinur Begum
Date of Birth : 1st January, 1988
Nationality : Bangladeshi by birth
Birth Place : Bauphal, Patuakhali
Marital Status : Single
Religion : Islam (Sunni)
Weight : 60 Kg.
Height : 5’ 4”
Health : Fit

By Abu Zafour

Published on 6 April 2012

Current ratio, Acid-Test Ratio, Inventory Turnover, Account Receivable Turnover, Return on Assets (ROA), Total Assets Turnover Ratio, Debt to Total Assets Ratio, Debt to Total Equity Ratio, Return on Common Shareholders’ Equity, Net Profit Margin, Earning Per Share, Price-Earnings Ratio, Dividend Yield Ratio, Time Interest Earned Ratio, Dividend per Share and Dividend Payout Ratio.

Ratio Analysis of Renata Limited

Current ratio

The current ratio is a widely used measure for evaluating company’s liquidities & short-term debt- paying ability:

Current ratio = Current assets / Current liabilities

Year: 2005

Current ratio =1.75

Year: 2006

Current ratio = 1.49

Comment

The ideal current ratio of an organization is 1.2 times. The current ratio of Renata Ltd. in 2005 is 1.75 times and in 2006 is 1.49 times, which is lower than the previous year 2005. So liquidity and short-term debt paying ability is worse than the previous year. But the Renata Ltd. has liquidity ability 1.49 to pay the short term debt for 1 which is higher from the probable ideal ratio.

Acid-Test Ratio

The acid-test ratio is a measure of a company’s immediate short-term liquidity.

Acid test ratio = (Current assets – Inventories) / Current liabilities

Year: 2005

Current assets - Inventories = 672,355,277 – 388.384.007

Current liabilities = 384,140,329

Acid test ratio = 0.74

Year: 2006

Current assets - Inventories = 979,254,859 – 638,784,952

Current liabilities = 658,881,691

Acid test ratio = 0.52

Comment

The ideal of Acid-Test Ratio an organization is 0.8 times. The Acid-Test Ratio of Renata Ltd. in 2005 is 0.74 times and in 2006 is 0.52 times, which is less than the previous year. Our evaluations of the liquidity ratios suggest that Renata’s liquidity position currently is poor.

Inventory Turnover

The total inventory turnover ratio measures the liquidity of inventories of a firm. It is calculated by dividing cost of goods sold by inventories.

Inventory turnover = Cost of goods sold / Average inventories

Year: 2005

Cost of goods sold = 829,197,436

Average inventories = 388,384,007

Inventory turnover = 2.14

Year: 2006

Cost of goods sold = 978,390,209

Average inventories = (638,784,952 + 388,384,007) / 2

Inventory turnover = 1.91

Inventory Turnover in Days

Inventory turnover in day’s measure the average days to sale the inventories.

Inventory Turnover in Days = Days in the year / Inventory turnover

Year: 2005

Days in the year = 360

Inventory turnover = 2.14

Inventory turnover in days = 168

Year: 2006

Days in the year = 360

Inventory turnover = 1.91

Inventory turnover in days = 188

Comment

Inventory turnover ratio of Renata Ltd. in 2005 is 2.14 times and in 2006 is 1.91 times, which is lower than the previous year 2005. The average selling time of inventories in 2005 is 168 days and in 2006 is 188 days. The ideal industry average of inventory selling time is 92 days. Our evaluations of the inventory turnover suggest that Renata’s average days to sale the inventories in days currently are lower than the industry average.

Account Receivable Turnover

Account receivable turnover measures the liquidity of receivables.

Account receivable turnover = Net credit sales / Average net receivables.

Year: 2005

Net credit sales = 1,608,555,839

Average net receivables = 162,224,078

Account receivable turnover = 9.91

Year: 2006

Net credit sales = 1,927,731,885

Average net receivables = (198,626,085+162,224,078) / 2

Account receivable turnover = 10.68

Account Receivable Turnover in Days (DSO)

Account receivables turnover in days (DSO) is used to evaluate the firm’s ability to collect its credit sale in a timely manner.

DSO = Days in the year / Account receivable turnover

Year: 2005

Days in the year = 360

Account receivable turnover = 9.91

Account receivable turnover in days = 36

Year: 2006

Days in the year = 360

Account receivable turnover = 10.68

Account receivable turnover in days = 34

Comment

Accounts receivables turnover ratio of Renata Ltd. in 2005 is 9.91 times and in 2006 is 10.68 times, which is grater than the previous year 2005. The firm’s ability to collect its credit sales is occurred in 36 days in 2005 and in 2006 is 34 days which is lower than the previous year 2005.

The ideal industry average of account receivable turnover in days (DSO) is 116.1 days. Our evaluations of the account receivables turnover suggest that Renata’s average days to collect its credit sale currently are lower but it is better for the company.

Return on Assets

Return on Assets indicates the overall measure of profitability is return on assets.

Return on Assets = Net income / Average total assets

Comment

Return on Assets ratio of Renata Ltd. in 2005 is 15.11% and in 2006 is 15.87%, which is grater than the previous year 2005. But the ideal industry average of return on assets is 10.9%. Our evaluations of the return on assets suggest that Renata’s profitability on assets currently is higher than the industry average. So we think the return on assets of this company is maintaining a good standard.

Total Assets Turnover Ratio

Total assets turnover ratio measures how effectively the firm uses its plant and equipment to help generate sales.

Total assets turnover ratio = Sales / Average total assets

Comment

Total assets turnover ratio of Renata Ltd. in 2005 is 1.26 times and in 2006 is 1.26 times, which is similar with the previous year 2005. But the ideal industry average of total assets turnover ratio is 0.6 times. Our evaluations of the total assets turnover ratio suggest that Renata’s plant and equipment to help generate sales is higher than the industry average. So we think the total assets turnover of this company is maintaining a good standard.

Debt to Total Assets Ratio

Debt to total assets ratio measures the percentage of total assets provided by the creditors.

Debt to total assets ratio = Total debt / Average total assets.

Comment

Debt to total assets ratio of Renata Ltd. in 2005 is 39.26% and in 2006 is 52.06%, which is grater than the previous year 2005. But the ideal industry average of debt to total assets is 62%. Our evaluations of the debt to total assets suggest that Renata’s debt to total assets currently is lower than the industry average. So they have the opportunity to expand their business by increasing their debt.

Debt to Total Equity Ratio

Debt to total equity ratio measures the percentage of total equity provided by the creditors.

Debt to total equity ratio = Total debt / Total stockholder equity.

Comment

Debt to total equity ratio of Renata Ltd. in 2005 is 64.64% and in 2006 is 80.85%, which is grater than the previous year 2005. Our evaluations of the debt to total equity ratio suggest that Renata’s debt to total equity currently is higher than the previous year.

Return on Common Shareholders’ Equity

This ratio shows how many taka of net income were earned for each taka invested by the owners.

Return on common shareholders’ equity = (Net income – Preferred dividend) Average common equity

Comment

Return on common shareholders’ equity of Renata Ltd. in 2005 is 24.88% and in 2006 is 24.65%, which is less than the previous year 2005. But the ideal industry average of return on common shareholders’ equity is 14.6%. Our evaluations of the return on common shareholders’ equity suggest that Renata’s net income were earned for each taka invested by the owners is higher than the industry average. So we think the return on common shareholders’ equity of this company is maintaining a good standard.

Net Profit Margin

Net profit margin measures the income per taka of sales.

Net profit margin = Net income / Net sales

Comment

Net profit margin of Renata Ltd. in 2005 is 11.97% and in 2006 is 12.56%, which is grater than the previous year 2005. But the ideal industry average of net profit margin is 15.4%. Our evaluations of the net profit margin suggest that Renata’s net income were earned for each taka of sales is lower than the industry average. So they should decrease their expense to increase the profit.

Earning Per Share

Earning per share measures of the net income earned on share of common stock.

Earning per share = (Net income – Preferred dividend) / Number of common share outstanding.

Comment

The Earning per Share of Renata Ltd. in 2005 is 239.71 and in 2006 is 301.41 which is greater than the previous year.

Price-Earnings Ratio

Price-earnings ratio measures the market price of each share of common stock to the earnings per share.

Price-earnings ratio = Market price per share / Earning per share

Comment

Price-earnings ratio of Renata Ltd. in 2005 is 12.52 times and in 2006 is 10.28 times, which is less than the previous year 2005. But the ideal industry average of price-earnings ratio is 13 times. Our evaluations of the price earning ratio suggest that Renata’s price of each share of common stock to earning per share is lower than the industry average.

Dividend Yield Ratio

It is measured by dividing dividend per share by market price per share.

Dividend Yield Ratio = Dividend per Share / Market price per share

Comment

Dividend yield ratio of Renata Ltd. in 2005 is 1.94% and in 2006 is 2.26%, which is greater than the previous year 2005. Our evaluations of dividend yield ratio suggest that Renata’s dividend yield ratio is higher than previous year.

Time Interest Earned Ratio

Time interest earned ratio measures the ability of the firms to meet its annual interest payment.

Time interest earned ratio = Net operating profit / Interest expense

Comment

Time interest earned ratio of Renata Ltd. in 2005 is 13.77 times and in 2006 is 10.17 times, which is less than the previous year 2005. But the ideal industry average of time interest earned ratio is 4.9 times. Our evaluations of the time interest earned ratio suggest that Renata’s annual interest payment is higher than the industry average. So we think the time interest earned ratio of this company is maintaining a goods standard.

Dividend per Share

It measures the company’s dividend on each share. It is calculated b y dividing common divided by number of shares outstanding.

Dividend per Share = Common divided / Number of shares

Comment

Dividend per share of Renata Ltd. in 2005 is 58.33 and in 2006 is 70, which is greater than the previous year 2005. Our evaluations of dividend per share suggest that Renata’s try to increase its dividend per share.

Dividend Payout Ratio

Dividend payout ratio measures the percentages of earnings distributed in the form of cash dividends.

Dividend Payout Ratio = Cash dividend / Net income

Comment

Dividend payout ratio of Renata Ltd. in 2005 is 24.33% and in 2006 is 23.22%, which is less than the previous year 2005. But the ideal industry average of dividend payout ratio is 16%. Our evaluations of the dividend payout ratio suggest that Renata’s earnings distributed in the form of cash dividends is higher than the industry average. So we think the time dividend payout ratio of this company is maintaining a goods standard.

** These financial statements data is considered as Bangladeshi taka. All financial information presented in taka has been rounded off to the nearest taka.

The current ratio is a widely used measure for evaluating company’s liquidities & short-term debt- paying ability:

Current ratio = Current assets / Current liabilities

Year: 2005

Current ratio =1.75

Year: 2006

Current ratio = 1.49

Comment

The ideal current ratio of an organization is 1.2 times. The current ratio of Renata Ltd. in 2005 is 1.75 times and in 2006 is 1.49 times, which is lower than the previous year 2005. So liquidity and short-term debt paying ability is worse than the previous year. But the Renata Ltd. has liquidity ability 1.49 to pay the short term debt for 1 which is higher from the probable ideal ratio.

Acid-Test Ratio

The acid-test ratio is a measure of a company’s immediate short-term liquidity.

Acid test ratio = (Current assets – Inventories) / Current liabilities

Year: 2005

Current assets - Inventories = 672,355,277 – 388.384.007

Current liabilities = 384,140,329

Acid test ratio = 0.74

Year: 2006

Current assets - Inventories = 979,254,859 – 638,784,952

Current liabilities = 658,881,691

Acid test ratio = 0.52

Comment

The ideal of Acid-Test Ratio an organization is 0.8 times. The Acid-Test Ratio of Renata Ltd. in 2005 is 0.74 times and in 2006 is 0.52 times, which is less than the previous year. Our evaluations of the liquidity ratios suggest that Renata’s liquidity position currently is poor.

Inventory Turnover

The total inventory turnover ratio measures the liquidity of inventories of a firm. It is calculated by dividing cost of goods sold by inventories.

Inventory turnover = Cost of goods sold / Average inventories

Year: 2005

Cost of goods sold = 829,197,436

Average inventories = 388,384,007

Inventory turnover = 2.14

Year: 2006

Cost of goods sold = 978,390,209

Average inventories = (638,784,952 + 388,384,007) / 2

Inventory turnover = 1.91

Inventory Turnover in Days

Inventory turnover in day’s measure the average days to sale the inventories.

Inventory Turnover in Days = Days in the year / Inventory turnover

Year: 2005

Days in the year = 360

Inventory turnover = 2.14

Inventory turnover in days = 168

Year: 2006

Days in the year = 360

Inventory turnover = 1.91

Inventory turnover in days = 188

Comment

Inventory turnover ratio of Renata Ltd. in 2005 is 2.14 times and in 2006 is 1.91 times, which is lower than the previous year 2005. The average selling time of inventories in 2005 is 168 days and in 2006 is 188 days. The ideal industry average of inventory selling time is 92 days. Our evaluations of the inventory turnover suggest that Renata’s average days to sale the inventories in days currently are lower than the industry average.

Account Receivable Turnover

Account receivable turnover measures the liquidity of receivables.

Account receivable turnover = Net credit sales / Average net receivables.

Year: 2005

Net credit sales = 1,608,555,839

Average net receivables = 162,224,078

Account receivable turnover = 9.91

Year: 2006

Net credit sales = 1,927,731,885

Average net receivables = (198,626,085+162,224,078) / 2

Account receivable turnover = 10.68

Account Receivable Turnover in Days (DSO)

Account receivables turnover in days (DSO) is used to evaluate the firm’s ability to collect its credit sale in a timely manner.

DSO = Days in the year / Account receivable turnover

Year: 2005

Days in the year = 360

Account receivable turnover = 9.91

Account receivable turnover in days = 36

Year: 2006

Days in the year = 360

Account receivable turnover = 10.68

Account receivable turnover in days = 34

Comment

Accounts receivables turnover ratio of Renata Ltd. in 2005 is 9.91 times and in 2006 is 10.68 times, which is grater than the previous year 2005. The firm’s ability to collect its credit sales is occurred in 36 days in 2005 and in 2006 is 34 days which is lower than the previous year 2005.

The ideal industry average of account receivable turnover in days (DSO) is 116.1 days. Our evaluations of the account receivables turnover suggest that Renata’s average days to collect its credit sale currently are lower but it is better for the company.

Return on Assets

Return on Assets indicates the overall measure of profitability is return on assets.

Return on Assets = Net income / Average total assets

Comment

Return on Assets ratio of Renata Ltd. in 2005 is 15.11% and in 2006 is 15.87%, which is grater than the previous year 2005. But the ideal industry average of return on assets is 10.9%. Our evaluations of the return on assets suggest that Renata’s profitability on assets currently is higher than the industry average. So we think the return on assets of this company is maintaining a good standard.

Total Assets Turnover Ratio

Total assets turnover ratio measures how effectively the firm uses its plant and equipment to help generate sales.

Total assets turnover ratio = Sales / Average total assets

Comment

Total assets turnover ratio of Renata Ltd. in 2005 is 1.26 times and in 2006 is 1.26 times, which is similar with the previous year 2005. But the ideal industry average of total assets turnover ratio is 0.6 times. Our evaluations of the total assets turnover ratio suggest that Renata’s plant and equipment to help generate sales is higher than the industry average. So we think the total assets turnover of this company is maintaining a good standard.

Debt to Total Assets Ratio

Debt to total assets ratio measures the percentage of total assets provided by the creditors.

Debt to total assets ratio = Total debt / Average total assets.

Comment

Debt to total assets ratio of Renata Ltd. in 2005 is 39.26% and in 2006 is 52.06%, which is grater than the previous year 2005. But the ideal industry average of debt to total assets is 62%. Our evaluations of the debt to total assets suggest that Renata’s debt to total assets currently is lower than the industry average. So they have the opportunity to expand their business by increasing their debt.

Debt to Total Equity Ratio

Debt to total equity ratio measures the percentage of total equity provided by the creditors.

Debt to total equity ratio = Total debt / Total stockholder equity.

Comment

Debt to total equity ratio of Renata Ltd. in 2005 is 64.64% and in 2006 is 80.85%, which is grater than the previous year 2005. Our evaluations of the debt to total equity ratio suggest that Renata’s debt to total equity currently is higher than the previous year.

Return on Common Shareholders’ Equity

This ratio shows how many taka of net income were earned for each taka invested by the owners.

Return on common shareholders’ equity = (Net income – Preferred dividend) Average common equity

Comment

Return on common shareholders’ equity of Renata Ltd. in 2005 is 24.88% and in 2006 is 24.65%, which is less than the previous year 2005. But the ideal industry average of return on common shareholders’ equity is 14.6%. Our evaluations of the return on common shareholders’ equity suggest that Renata’s net income were earned for each taka invested by the owners is higher than the industry average. So we think the return on common shareholders’ equity of this company is maintaining a good standard.

Net Profit Margin

Net profit margin measures the income per taka of sales.

Net profit margin = Net income / Net sales

Comment

Net profit margin of Renata Ltd. in 2005 is 11.97% and in 2006 is 12.56%, which is grater than the previous year 2005. But the ideal industry average of net profit margin is 15.4%. Our evaluations of the net profit margin suggest that Renata’s net income were earned for each taka of sales is lower than the industry average. So they should decrease their expense to increase the profit.

Earning Per Share

Earning per share measures of the net income earned on share of common stock.

Earning per share = (Net income – Preferred dividend) / Number of common share outstanding.

Comment

The Earning per Share of Renata Ltd. in 2005 is 239.71 and in 2006 is 301.41 which is greater than the previous year.

Price-Earnings Ratio

Price-earnings ratio measures the market price of each share of common stock to the earnings per share.

Price-earnings ratio = Market price per share / Earning per share

Comment

Price-earnings ratio of Renata Ltd. in 2005 is 12.52 times and in 2006 is 10.28 times, which is less than the previous year 2005. But the ideal industry average of price-earnings ratio is 13 times. Our evaluations of the price earning ratio suggest that Renata’s price of each share of common stock to earning per share is lower than the industry average.

Dividend Yield Ratio

It is measured by dividing dividend per share by market price per share.

Dividend Yield Ratio = Dividend per Share / Market price per share

Comment

Dividend yield ratio of Renata Ltd. in 2005 is 1.94% and in 2006 is 2.26%, which is greater than the previous year 2005. Our evaluations of dividend yield ratio suggest that Renata’s dividend yield ratio is higher than previous year.

Time Interest Earned Ratio

Time interest earned ratio measures the ability of the firms to meet its annual interest payment.

Time interest earned ratio = Net operating profit / Interest expense

Comment

Time interest earned ratio of Renata Ltd. in 2005 is 13.77 times and in 2006 is 10.17 times, which is less than the previous year 2005. But the ideal industry average of time interest earned ratio is 4.9 times. Our evaluations of the time interest earned ratio suggest that Renata’s annual interest payment is higher than the industry average. So we think the time interest earned ratio of this company is maintaining a goods standard.

Dividend per Share

It measures the company’s dividend on each share. It is calculated b y dividing common divided by number of shares outstanding.

Dividend per Share = Common divided / Number of shares

Comment

Dividend per share of Renata Ltd. in 2005 is 58.33 and in 2006 is 70, which is greater than the previous year 2005. Our evaluations of dividend per share suggest that Renata’s try to increase its dividend per share.

Dividend Payout Ratio

Dividend payout ratio measures the percentages of earnings distributed in the form of cash dividends.

Dividend Payout Ratio = Cash dividend / Net income

Comment

Dividend payout ratio of Renata Ltd. in 2005 is 24.33% and in 2006 is 23.22%, which is less than the previous year 2005. But the ideal industry average of dividend payout ratio is 16%. Our evaluations of the dividend payout ratio suggest that Renata’s earnings distributed in the form of cash dividends is higher than the industry average. So we think the time dividend payout ratio of this company is maintaining a goods standard.

** These financial statements data is considered as Bangladeshi taka. All financial information presented in taka has been rounded off to the nearest taka.