ipl-logo

Wesfarmers Industry Averages: Using Dupont Analysis, Questions And Answers

851 Words4 Pages

calculations for Wesfarmers.
Current Ratio
Formula - Current Ratio = Current assets___ Current Liabilities
Table I
Wesfarmers
2015 2016

9,093,000 = 0.9 times
9,726,000
9,684,000 = 0.9 times
10,424,000

A ratio in excess of one (1) should be expected but should not go below zero (0). Explain why
For the year ended 30 June 2015 and 2016, Wesfarmers’ current assets were consistently at 0.9 times larger than it current liabilities, this is 1.125 times higher than the industry average of 0.88 as shown in Appendix V – Wesfarmers Ltd Industry Averages. This indicates that Wesfarmers is a health company and should not have any trouble paying its debts for the next twelve (12) months, as it’s currently liabilities are let than its current …show more content…

The analysis provides a view on the strengths and weaknesses of the company. The Return on Equity is composed of three ratios: profit margin, asset turnover, equity multiplier which reflects the impact of change in key figures in both the income statement and the balance sheet. Not to mention, the Return on Equity (ROE) for Wesfarmers Limited decreased in 2016 by 9% compared to 2015. The Return on Equity decreased for these reasons:
Firstly, as seen above in Table V, the DuPont Analysis for Wesfarmers for the year 2016, the profit margin has decreased to almost 4%. Profit Margins measures how much out of every dollar of sales a company actually keeps in earnings (Investopedia, 2017). Therefore Wesfarmers 5.6% profit margin for the year 2015, means that the company had a net income of AUD $0.05 for each dollar of total revenue earned. As for the year 2016, the 1.6% profit margin shows a decrease of AUD $0.04 down from its AUD $0.05 net income for

Show More
Related
2018 Words | 9 Pages

Return on Equity From the Cash Flow Statement we can see that, ROE projected for the following years are 1996 - 42%; 1997 - 45%; 1998 - 48.13%; 1999 -

Read More
512 Words | 3 Pages

The return on assets of Dick’s Sporting Goods is 11%. Another ratio to look at is the return on equity to see what the investors are getting back for the money and faith they have in the company. The return on equity

Read More
730 Words | 3 Pages

= 1.47 Big Lots have a current ratio of 1.47 which is larger than 1 and indicates that they would have adequate funds available to pay their short-term obligations. With Big Lots having a current ratio of $1.47 for each dollar in current liabilities would indicate that they are maintaining their total current assets favorably to cover their current liabilities that are due

Read More
930 Words | 4 Pages

5% The net profit margin lets investors and creditors know exactly how much profit was made from every dollar of sales. Lowe’s reported on February 3, 2017 that for every $1.00 of sales that were made at their stores, just five cents of net profit were realized. This seems to be the industry norm because it is within a few percentage points of their year over year, as well as consistent with Home Depot’s net profit margin (Bethel University, 2017). Return on Assets

Read More
461 Words | 2 Pages

In addition, the company’s debt ratio has been increasing over the past three years and now stands at 57.0%, which is more than double the industry average of 24.5%. This reliance on borrowed funds will increase debt repayment and interest expenses.

Read More
150 Words | 1 Pages

In analyzing the net profit margin ratio, Lockheed Martin’s 11.22% is above the industry average of 8.65% and the aerospace and defense sector average of 8.11%, and exceeds all competitors (Lockheed Martin Corp. (LMT) | Financial Analysis and Stock Valuation. n.d.). This net profit margin ratio shows that Lockheed Martin’s significant defense sector contracts, most notably the F-35 Lightning II fighter, and diverse revenue streams, strengthen the company’s overall flexibility to withstand downturns in different market sectors (Lockheed Martin Corporation SWOT Analysis. 2016). The second profitability ratio to examine is the return on assets ratio. Lockheed Martin’s return on assets ratio is 11.09% (Lockheed Martin Corp. (LMT) | Financial

Read More
1790 Words | 8 Pages

For investors or potential investors, it is important to measure the rate of income earned on the stockholder’s investments and the next two ratios address that. The first, return on stockholders’ equity, addresses the income earned rate for all stockholders’ equity while the second, return on common stockholders’ equity, focuses specifically on the profits earned by the common stockholders. For Dick’s the first ratio came out to 17.14% while the second was only 16.44%. For Nike the first ratio is 34.04% and the second is only 15.38%. This would mean that on average common stockholder’s only make a slightly lower percentage on their

Read More
1141 Words | 5 Pages

The long-term liabilities had a more than doubling in the year 2011, which the company has steadily shed. While the company had steadily increased its short term borrowings over the years, indicating cash strapping over the years although the company has drastically brought down the long term loans and advances given. While the trade payables remained constant, while the other current liabilities gradually increased. The short term provisions have steeply increased indicating that company is expecting bad weather. Though the non-current liabilities have decreased over the years the total liabilities remained more or less constant as the company had to boost the funding through the current

Read More
616 Words | 3 Pages

Current ratio The current ratio is normally ,used to indicate the ability of the company to pay its short term liabilities such as payables and debts using its short term assets like inventory, cash and receivables. If the current ratio is high, the company is more capable of paying the obligations (Brigham, 2013). If the ratio is below one, it indicates that the company cannot be able to pay its debts if they become due at that point Current ratio = current assets / current liabilities Apix Printing = 852,608 / 734,760 =

Read More
99 Words | 1 Pages

Return on equity measures the overall profitability of the financial institution per dollar of equity. Generally shareholders of financial institutions prefer the high ROE. But, higher ROE means an increase in risk. 2014 2013 2012 2011 2010

Read More
664 Words | 3 Pages

O’Reilly’s Automotive collected its outstanding credit 35.65 times during the year. Even though AutoZone has collected more of its outstanding debt owed to them, both companies have a decent Receivables Turnover, which means that they are able to collect most of the debt owed to them. According to the days’ sales in receivables ratio, it takes AutoZone 8.03 days to collect its debt while it takes O’Reilly’s Automotive 10.23 days. In terms of this ratio, AutoZone is better at collecting the debt that is owed to them.

Read More
639 Words | 3 Pages

The Return on Equity (ROE) for Wesfarmers Limited decreased in 2016 by almost 8% compared to 2015 and it may have decreased for these reasons: Firstly, as seen above in Table V, the DuPont Analysis for Wesfarmers for the year 2016, the profit margin has decreased to almost 8%. Profit Margins measures how much out of every dollar of sales a company actually keeps in earnings (Investopedia, 2017). Therefore Wesfarmers 3.9% profit margin for the year 2015, means that the company had a net income of AUD $0.03 for each dollar of total revenue earned. As for the year 2016, the 0.6% profit margin shows that Wesfarmers net profit after tax (NPAT) reduced by over two (2) Million compared to 2015 net profit after tax (NPAT).

Read More
775 Words | 4 Pages

Analysis Profit margin Profit margin is an accounting measure of how well the company manages expenses financially and its profitability. Profit margin as it reveals the amount of revenue returned to the company once it has covered fixed and variable expenses except for tax and interest. This data gathered were calculated by using the equation total comprehensive income divided by the total revenue. From the data conducted in 2016, the 22% profit margin means that Telstra has a net income of $0.22 for each dollar of total revenue earned (Telstra,2016). Whereas in 2015, there was difference of 4% profit margin in comparison to 2016, which means that Telstra shows an increase of 4% profit with a net income increase of $0.04 for each dollar of total revenue, earned (Telstra,2015).

Read More
3289 Words | 14 Pages

Total Liabilities- This ratio evaluates the company's ability to generate enough cash flow to pay off all its liabilities. A higher ratio denotes a stronger cash flow situation and a higher ability to pay debts. We may assess Coles Group's cash flow status by using these ratios, looking at the data from the Consolidated Statement of Cash Flows, and looking at the reconciliation in the financial statements. The Coles Group exhibits a favourable cash flow situation in 2022 based on the facts currently available.

Read More
1162 Words | 5 Pages

Equity (£ M) =1,303.4 Debt-to-Equity Ratio (D/E) = Debt / Shareholders Equity = Debt /( T.A – T.L )  706.4/( 2,009.4-706.4)  706.4/1,303.4 Thus the Debt-to-Equity Ratio is 0.54, which translates to 54% 2012 Total Assets (£ M) = 2,258.4 Total Liabilities (£ M) = 781.1 Equity (£ M) =1,477.3 Debt-to-Equity Ratio (D/E) =

Read More

More about Wesfarmers Industry Averages: Using Dupont Analysis, Questions And Answers

Related Topics

Open Document