Skip to main content

How to calculate DuPont's analysis ?


Example: A furniture manufacturing company total revenue in 2017 is Rs. 55, 65, 000 and in 2018 Rs. 75, 70, 000. The gross profit of 2017 is Rs. 6, 45, 900 and Rs. 3, 58, 000. The total operating income in 2017 is Rs. 1, 79, 860 and in 2018 is Rs. 88, 640. The total shareholder’s equity is Rs. 8, 00,500. The total asset of a company is Rs. 4, 30,000 and in 2018 is Rs. 5, 00, 000. Find out the return on equity of 2017 year.

Solution: Return on equity (ROE) of 2017 year = total assets / shareholders equity
= 4, 30, 000 / 8, 00, 500
= 0.53 or 53.71%
Return on equity (ROE) of 2018 year = total assets / shareholders equity
= 5, 00, 000 / 8, 00, 500
= 0.62 or 62.47%

Example: There are 2 companies Company PQR and ABC Company. The company PQR is manufacturing soaps and Company ABC deodorant. The market share of both the company is equal.  The revenue of Company PQR is Rs. 15, 26, 000 and Rs. 18, 23, 000 of company ABC. The debenture of company ABC is Rs. 6, 00, 000 and shareholders equity is Rs. 3, 20, 000. Company PQR has Rs. 2, 20, 000 Debenture and Rs. 1, 00, 000 Preference Share capitals and Rs. 4, 00,000 Share capitals. An investor wants to know which company has more ability to increase his profit or improve his earnings level with the help of DuPont’s analysis. Other information is given below:

Particulars
Company PQR Amount (in Rs.)
Company ABC Amount (in Rs.)
Gross profit
3, 80, 000
2, 70, 000
Total operating expenses
45, 000
62, 000
Interest on debenture
6%
6.2%
Tax
30%
30%
Total assets
3, 90,600
2, 85, 000

Solution:
Particulars
Company PQR Amount (in Rs.)
Company ABC Amount (in Rs.)
Gross profit
3,80, 000
2, 70, 000
Less: total operating expenses
45, 000
62, 000
Earnings before interest and tax
3, 35, 000
2, 08, 000
Less: Interest on debenture
36, 000
13, 640
Earnings before tax
2, 99, 000
1, 94, 360
Less: Tax
89, 700
58, 308
Net income
2, 09, 300
1, 36, 052
Total assets
30, 90,600
32, 85, 000


Company PQR:
Net Profit Margin = (Net income / Total revenue) * 100
= (2, 09, 300 / 10, 26, 000)* 100
= 13.7%
Total assets turnover = total revenue / total assets
= 10, 26, 000 / 15, 45, 300
= 0.66 or 66.39%
Financial leverage = total assets / Shareholders equity
= 15, 45, 300 / 4, 00, 000
= 3.86
Return on equity = net profit margin*asset turnover*financial leverage
= 0.33
Company ABC:
Net Profit Margin = (Net income / Total revenue) * 100
= (1, 36, 052 / 18, 23, 000)* 100
= 7.46% or 0.0746
Total assets turnover = total revenue / total assets
= 18, 23, 000 / 32, 85, 000
= 0.55 or 55.49%
Financial leverage = total assets / Shareholders equity
= 32, 85, 000/ 3, 20, 000
= 10.26
Return on Equity = net profit margin*asset turnover*financial leverage
= 0.41
The return on equity of ABC Company is more than PQR Company. But Net profit margin and Asset turnover of PQR Company is more than ABC Company. If Company PQR decreases its equity capital then the ROE is more than company ABC.

Comments

Post a Comment

Popular posts from this blog

How to calculate Cost of Preference Share Capital?

Cost of Preference Share Capital:  An amount paid by company as dividend to preference shareholder is known as Cost of Preference Share Capital. Preference share is a small unit of a company’s capital which bears fixed rate of dividend and holder of it gets dividend when company earn profit. Dividend payable is not a tax deductible amount. So, there is no tax adjustments required for comparing with cost of debt. Formula for Cost of Preference Share: Irredeemable Preference Share Redeemable Preference Share K p  = Dp/NP K p  = D p +((RV-NP)/n )/ (RV+NP)/2 Where, K p  = Cost of Preference Share D p  = Dividend on preference share NP = Net proceeds from issue of preference share (Issue price – Flotation cost) RV = Redemption Value N = Period of preference share Example:  A company issues 20,000 irredeemable preference share at 8% whose face value is Rs.50 each at 4% discount. Find out the Cost of ...
88 comments
Read more

What is the difference between Cheque book and Pass book?

 Cheque book is issued by bank in customers / account holder request. With the help of this book account holder can withdraw cash from his/her account. Bank does not charge any fee to issued cheque book to its customer. But afterward bank charges some amount for using bank facility like cheque book, Debit card etc.So, Automatic some definite amount deducted from customer bank account. Pass book is  also issued by bank to its customer. It helps to record all the bank related activity according to date that is withdrawal and deposit. It is recorded by bank but the book is kept by customer to know the current balance of  his /her account.  Point of difference Pass book Cheque book What is the meaning of pass book and cheque book? Passbook is a book in which all withdrawal and deposit against customer account is recorded.   Cheque book is a book of cheques which are used to withdrawal the money to b...
Post a Comment
Read more

Numericals with solutions of Net income Approach

Net income approach questions and answers:   Questions:  Find out the value of the firm with the help of given information: Particulars Amount Earnings before interest and tax 3, 50, 000 Cost of equity 10% Cost of debt 7.2% Debenture 1,00,000 Find out the overall cost of capital with the help of net income approach. (Assume tax rate-10%) Solution: Particulars Amount Earnings before interest and tax 3, 50, 000 Less: Interest @7.2% 7, 200 Earnings before tax 3, 42, 800 Less: Tax@10% 34, 280 Net income 3, 08, 520 Cost of equity 10% Market value of equity (S =net income/ cost of equity) 30, 85, 200 Market value of debt (B) 1, 00, 000 Value of the firm (S+B) 31, 85, 200 Questions:  Find out the overall cost of capital if the equity capitalisation rate is 12...
Post a Comment
Read more