Discussion and 2 replies

 

Results of the Research Project Part 1

As an initial response to the discussion topic please create a Power Point presentation consisting of 5-6 slides, plus the title slide, that contains the main results of all the topics from Part 1 of the Research Project.  What are some of your main takeaways regarding the company's financial performance, your recommendations for the company's financial stability, and what steps should be taken if any to improve the company financially? Please use any graphs or charts you feel are helpful and make the presentation pleasant by using appropriate formatting and slide designs.

In your responses to other students please present your opinion, with supporting rationale, regarding the company's financial performance and stability based on the information presented and any additional information you may have to add. Please do not just repeat the information presented on the students' slides but complete a bit of research and present your own findings and suggestions regarding this company.

Post by classmate 1

 

Good evening everyone,

              Attached is a short PowerPoint summarizing my finding for Home Depot.  Let me know what you think.

              I hope everyone has a great week.

Post by classmate 2

 

Please see attached Powerpoint for information on Wells Fargo's Financial performance over the last 3 years. 

The research has shown that WF is a very stable company and their years of experience shine through. Every aspect of the data compiled is in favor of Wells Fargo. Raising stockholder interests and reducing Liabilities through a economic downturn has cemented them in being successful not only in the near future but years down the road also.

WALMART INC

Running Head: Walmart Inc 4

Having Trouble Meeting Your Deadline?

Get your assignment on Discussion and 2 replies completed on time. avoid delay and – ORDER NOW

WALMART INC

DeAndre Birton

FINC 330

February 15, 2022

Introduction

Walmart Inc. is a major multinational retail corporation that has been in the business for several years now. The multinational company has a lot of branches in other continents like Asia and Africa. The company aims at building a better world through the services that it offers by helping better the lives of people as they work harmoniously in renewing the planet while establishing a thriving and resilient community. The company work by creating opportunities, continuing the work of diversity, sustainable future, inclusion, and unit the community.

Size Analysis

The financial statement and figures of a period of three working years of WalmartInc. are as shown in figure 1 below. Various trends can be analyzed from the data and realized what has been formed over the past years that shall be instrumental for us in understanding both characteristics and the performance of the company. From the data in the table, we can say that the year 2019 was the peak year for the company as all the attributes of the business were at the peak level. The attributes we concentrate on are profit and revenue, income before tax, and after taxation has been accounted for as the year that the company began posting better performance (Ta, 2020).

In general, other attributes can be witnessed to follow the suit and score the highest in the year 2019. In the years, the operational cost has been witnessed to be rising and it can be attributed to the fact that the price of kinds of seafood has been on the rise because of factors like the fluctuating market price, changing climatic conditions, anddisrupted weather patterns. Currency prices have also been fluctuating leading to an increase in operational costs because a lot of commodities are all bought in American dollars. Once the price of the dollar is on a fluctuating mode, it means it shall be difficult to acquire it and when it becomes available it shall be expensive hence increasing the costs of operation.

From the data as shown in table 1 below, we cannot at once conclude that the company has been maintaining a certain path because the figures indicate the ups and downs the company has been experiencing. Through the years, there is no steady performance that might have been determined by some factors. 2019 was the year the company experienced a massive boom after a lower performance in the year 2020 and then recovered from it in 2021 as it is impressing for a company to swing back to business. The company has not been on a stable trend but spikes have been witnessed especially at the end of the year 2020 and the beginning of the year 2021.

There were no shady fluctuations but they are the indicators that in the course the company is in operations, there shall be changes and by considering the volatility of the industry the changes shall not be that steep. Every few years, the food industries have been experiencing price fluctuations and shocks.

Statements As at Dec. Currency in Millions AUD

2019

2020

2021

TTM

Revenue

100.00%

100.00%

100.00%

100.00%

Cost of revenue

90.47%

91.30%

91.02%

91.02%

Gross profit

9.53%

8.70%

8.98%

8.98%

Operating expenses

Sales, General and administrative

5.99%

5.66%

5.97%

5.97%

Other operating expenses

0.08%

0.08%

Total operating expenses

5.99%

5.66%

6.05%

6.05%

Operating income

3.53%

3.04%

2.94%

2.94%

Interest Expense

0.45%

0.33%

0.24%

0.24%

Other income (expense)

1.82%

1.39%

0.93%

0.93%

Income before taxes

4.90%

4.10%

3.62%

3.62%

Provision for income taxes

1.44%

1.15%

1.02%

1.02%

Net income from continuing operations

3.46%

2.95%

2.61%

2.61%

Other

0.00%

-0.01%

-0.01%

-0.01%

Net income

3.46%

2.94%

2.60%

2.60%

Net income available to common shareholders

3.46%

2.94%

2.60%

2.60%

Earnings per share

Basic

2.31

2.37

2.15

2.15

Diluted

2.31

2.37

2.15

2.15

Basic

263

261

261

261

Diluted

263

261

261

261

EBITDA

5.35%

4.43%

3.87%

3.87%

Analysis of trends

The fiscal year ends in Dec. Currency in AUD

2014-12

2015-12

2016-12

2017-12

2018-12

TTM

Revenue

23878

19692

17619

21072

21542

21542

Gross profit

1149

1654

1678

1834

1935

1935

Total operating expenses

1340

1175

1056

1193

1303

1303

Net income

20

522

610

619

560

560

Table 2

From the figures we have in Table 2 we can opt to do a trend analysis since the data in the table is a display of revenue, gross profit, net income, and expenses of all the operations. When we make a comparison from the shall indicate if the operations of the company are optimal, something that we can ascertain from the case. Beginning in 2018, there was an increase in operating expenses. The reason behind the changes is the exactly the explanations we gave earlier that the price fluctuations or might also be due to the fluctuations we experience in the foreign markets (Roberts & Berg, 2020).

Other factors notable mentioning are other food products that have been flooded in the market especially after summer when a majority of the agricultural productive areas are harvesting. In turn, these have increased the costs of business operations and unfortunately, the revenue amount was also on the increasing trend making it impossible for the company to cover the costs of operations. The two conservative years of 2019 and 2020 experienced an increase in net income with a smaller depreciation in the year 2021. Several factors automatically caused it. The major being the Corvid 19 restrictions that the government imposed due to the second and third waves of Corvid 19 viruses. The food supply was much affected as the majority of the produces were asked to work from home while others were forced to stay away so that they could reduce human congestions in workplaces.

Tread Summary

Walmart Inc. has been operating in the seafood industry for many years and has therefore gained gain and has been through both recessions and booms in the areas they are dealing with. There are several challenging factors that the industry is facing. The factors range from currency fluctuations that generally the company has no control over, the changing climatic conditions, and unpredictable weather patterns that affect fishing activities. Also, competition is experienced from other agricultural products that are easy to find than kinds of seafood that are only obtained from sees(Directory of chain restaurant operators 2020).

Giving a clear projection of the company’s performance would be quite difficult given the number of variables at hand because most of the variables at play cannot be controlled internally by the company. The company's business strategy has gotten them this far; however, it would be difficult to predict if they would be enough to get them through the next few years with the advent of technological advancements such as the increasing popularity of electric vehicles, and solar-powered devices. This is negatively impacting the demand for petroleum products. The government also is playing its role and is increasing taxes for them, to discourage the use of petrol and petroleum products. It may increase the taxes directly or indirectly. It could raise the taxes levied on emissions that they produce at the factory, which will increase their running costs.

As we have already observed, the returns on investment are already declining gradually year to year, which unfortunately may be the new trend here given all the variables at play. In my thoughts, investing here would be a massive risk for the investor, as oil depends on too many variables. Most oil-producing countries at the moment are not politically stable, and in case anything happens in the sector it means that the price of oil will skyrocket, placing a further strain on the company (Koeller et al., 2019).

The company could be financially stable for the next few years for sure, but beyond the next few years is quite a stretch given the kind of policy and financial advancements that are going around. Their best bet to improve their financial stability would be to diversify their portfolio, and stop dealing majorly in petroleum. The company could venture into new grounds, and it has already done that in several ways by opening convenience stores in its stations. This will work to increase their profit margins. They could also venture into the new technology that is coming up and embrace it before it becomes too late for them, for as sure as rain the use of fossil fuels will decline rapidly over the years(Slater, 2020).

The current ratio can be referred to as the proportionality of the current assets divided by the current liability. There has been a fluctuation of the current ratio since the year 2019, making it hard to conclude. The ratio was high that year later there was a decline of 1.427 to 1.156 then 1.309 in 2021. It helps to measure how a company is capable to cover its liabilities. This shows the highest being in 2019 then decline in 2020 then rise in 2021.

Another way of compacting the current ratio can be using the cash ratio which shows the proportion between the company's current assets and the liquid assets. There has been a decline in the company's reserve ratio since 2019. The year 2019 was a successful year for Walmart Inc as it had the highest record of profit after tax in three years of 621 million. Then later there was a decline which can be as a result of demand decline, most people have preferred using another type of foods .also more restaurants have arisen with different ideas posing completion in the market. There is an improvement since the company is considered to be flexible and adaptive to the environment, this results in the improvement in the year 2021. However, it was not so in all the fonts since there were fluctuations in share dividends. It, therefore, caused the business to be multi-fated.The profitability ratio is grouped into two gross profit margins and return on assets. Return on assets is obtained from the number of returns a company acquires after utilizing all the assets is calculated as total assets. Profit margins have been improving yearly. This indicates a high asset utilization.

The efficiency ratio will determine how a company utilizes its assets and liability. Calculated by the division of all the revenue from total assets. The company has experienced improved efficiency over the years. The fixed turnover and inventory have been impressive( Directory of chain restaurant operators 2020).

Returns on Equity

Profitability

2019-12

2020-12

2021-12

TTM

Tax Rate %

29.32

28.11

28.08

28.08

Net Margin %

3.46

2.94

2.6

2.6

Asset Turnover (Average)

3.39

3.62

3.29

3.29

Return on Assets %

11.72

10.62

8.57

8.57

Financial Leverage (Average)

1.9

2.05

1.99

1.99

Return on Equity %

21.89

21.02

17.32

17.32

Return on Invested Capital %

18.98

17.91

14.37

14.37

Interest Coverage

11.88

13.32

16.05

16.05

Summary

In my opinion, as seen from the company assessment it shows that every company can experience a decline despite having successful growth. The business world needs flexibility and v open-minded to accept new ideas, empress change, and have strategies of overcoming difficulties. Firms should be prepared to face some natural calamities which they have no control over. Above all how we treat and present ourselves to customers sells a lot of our business. Customers are to be treated like kings for without them there is no business.

References

Directory of chain restaurant operators. (2020).

Koeller, K., France, R. L., & Mayer, K. (2019). Gluten free dining in steak and seafood restaurants: Part of the award-winning let's eat out! Series. R & R Publishing.

Roberts, B., & Berg, N. (2020). Walmart: Key insights and practical lessons from the world's largest retailer. Kogan Page Publishers.

Slater, R. (2020). The Wal-Mart triumph: Inside the world's #1 company.

Ta, T. V. (2020). Price-forecasting models for Walmart Inc WMT stock.

,

Home Depot Financial Health

Darryl Ellis

Business Finance 330

Professor Ann Laramy

This Presentation Has 9 Slides

Click to edit Master title style

‹#›

Company Overview

Financial Trends

Financial Ratios

Operating Performance

DuPont Analysis

Recommendations

2

Agenda

Click to edit Master title style

‹#›

Home Depot’s Company History

2021 Fortune 500 Rank: 18/500

Headquarters: Atlanta, Georgia

State of incorporation: Delaware

Publicly traded since 1981

~1.04 billion shares outstanding

Market cap in excess of $365 billion

415,000 full-time employees

3

Click to edit Master title style

‹#›

4

Financial Trends

Net Income Growth

Positive trend overall, especially considering the difficult economic conditions brought on by the COVID-19 pandemic

Sales Growth

Between 2017 and 2020, sales increased by more than 71%; this positive trend for Home Depot reinforces the organization’s financial stability moving forward.

Interest Expense Growth

Neutral trend; Home Depot has the opportunity to leverage increased sales to pay off outstanding debt and lower its interest expense growth rate.

Net Income Growth
  2017 2018 2019 2020 2021
Net Income (in billions) $7.96 $8.63 $11.12 $11.24 $12.87
Net Income Growth 8.46% 28.86% 1.09% 14.45%

Derived from https://www.marketwatch.com/investing/stock/hd/financials

Derived from https://www.marketwatch.com/investing/stock/hd/financials

Interest Expense Growth
  2017 2018 2019 2020 2021
Interest Expense (in billions) $972 $1.06 $1.05 $1.2 $1.35
Interest Expense Growth +8.74% -0.57% +14.27 +12.16

Derived from https://www.marketwatch.com/investing/stock/hd/financials

Sales/Sales Growth
  2017 2018 2019 2020 2021
Sales (in billions) $94.6 $100.9 $108.2 $110.23 $132.11
Sales Growth +6.67% +7.23% +1.87% +19.85%

Click to edit Master title style

‹#›

5

Financial ratio analysis

Liquidity

Home Depot meet dept obligations, overall low quick ratio highlights the substantial impact of inventory.

Profitability

Slight decreases in all three profitability ratios, but deviations are not outside the standard range.

Return on Investment

Shareholder equity has experienced wild fluctuations, resulting in a drastic change in return on equity over the last three years.

Liquidity
  2017 2018 2019 2020 2021
Current ratio 1.30 1.09 1.08 1.36 1.13
Quick ratio 0.39 0.28 0.28 0.72 0.37

Derived from https://www.macrotrends.net/stocks/charts/HD/home-depot/quick-ratio

Profitability
  2017 2018 2019 2020 2021
Gross Profit Margin 34.16% 34.04% 34.34% 34.09% 33.95%
Operating Profit Margin 14.19% 14.55% 14.58% 14.37% 13.84%
Net Profit Margin 8.41% 8.55% 10.28% 10.20% 9.75%

Derived from https://www.morningstar.com/stocks/xnys/hd/performance

Return on Investment
  2017 2018 2019 2020 2021
ROA 18.61% 19.73% 25.12% 23.61% 21.12%
ROE 149.44% 298.25% -709.24% -910.85% 782.14%

Derived from https://www.macrotrends.net/stocks/charts/HD/home-depot/roe

Click to edit Master title style

‹#›

6

Operating Performance

Operating performance
  2017 2018 2019 2020 2021
Days of Sales in Inventory 71.37 69.37 68.52 71.48 65.17
Receivables Turnover 48.28 55.55 66.71 65.26 61.62
Inventory Turnover 5.11 5.26 5.33 5.11 5.60 
Total Assets Turnover 2.21 2.31 2.44 2.31 2.17 

Derived from https://www.morningstar.com/stocks/xnys/hd/performance

Home Depot’s operating performance ratios are all trending in a positive direction.

Inventory turnover increased.

Days of Sales in Inventory decreased.

Total assets turnover also decreased.

Reduced the timeline for receivables.

Click to edit Master title style

‹#›

Days of Sales in Inventory 2017 2018 2019 2020 2021 71.37 69.37 68.52 71.48 65.17 Receivables Turnover 2017 2018 2019 2020 2021 48.28 55.55 66.709999999999994 65.260000000000005 61.62 Inventory Turnover 2017 201 8 2019 2020 2021 5.1100000000000003 5.26 5.33 5.1100000000000003 0 Total Assets Turnover 2017 2018 2019 2020 2021 2.21 2.31 2.44 2.31 0

7

DuPont Analysis

Home Depot and Lowe’s both experiencing extraordinarily high ROE.

Home Depot has a dramatic shift reporting in ROE; in 2019, ROE was -709.24%, growing to over 782% in 2021.

Lowe’s experienced an increase in ROE from 67.59% in 2019 to 483.11% in 2021

Debt/equity ratio stabilizing for Home Depot, but Lowe’s remains relatively unstable.

Net Profit Margin trending positively for both companies.

Home Depot DuPont analysis
  2019 2020 2021
ROE -709.24% -910.85% 782.14%
Net Profit Margin 10.28% 10.20% 9.75%
Asset Turnover 2.44 2.31 2.17 
Debt/equity ratio -49.35 42.60 69.56
Lowe’s DuPont analysis
  2019 2020 2021
ROE 67.59% 217.25% 483.11%
Net Profit Margin 3.51% 7.10% 7.38%
Asset Turnover 2.04 1.95 2.08
Debt/equity ratio 14.42 10.88 -238.31

Derived from https://www.macrotrends.net/stocks/charts/HD/home-depot/roe

Derived from https://www.macrotrends.net/stocks/charts/HD/home-depot/roe

Click to edit Master title style

‹#›

8

Recommendation

Overall, Home Depot is a financially stable organization. Three recommended actions would increase stability over the next two to three years.

Home Depot’s Interest Expense grew almost every year from 2017 through 2021. As this non-operating expense continues to climb, the organization hemorrhages funds that could be applied to other vital areas. It is recommended that further analysis be conducted to reduce the organization’s debt, reducing or stabilizing its Interest Expense.

The organization’s quick ratio portrays a low ability to meet short-term obligations. Decrease current liabilities would increase Home Depot’s Quick ratio. This should signal lower overall risk and attract new investors.

Home Depot’s ROE is too volatile. The organization’s Shareholders’ equity was negative in 2019 and 2020, further adding to the unpredictability. To improve ROE, the organization should either buy back shares (increasing treasury stock) or decrease liabilities. While both have inherent risks, stabilizing ROE would increase financial stability over the next three years.

Click to edit Master title style

‹#›

References

Home Depot performance. (2022). Morningstar. https://www.morningstar.com/s tocks/xnys/hd/performance

Home Depot. (2022). Macrotrends. https://www.macrotrends.net/stocks/charts/HD/home-depot/quick-ratio

Home Depot. (2021, July 30). Fortune. https://fortune.com/company/home-depot/fortune500/

Home Depot. (2021) Form 10-K: Annual report for year ending January 31, 2021. https://www.sec.gov/ix?doc=/Archives/edgar/data/0000354950/000035495021000089/hd -20210131.htm

Lowes Companies Inc. (2021). Form 10-k: Annual report for year ending January 29, 2021. https://www.sec.gov/ix?doc=/Archives/edgar/data/60667/000006066721000026/low-20210129.htm

9

Click to edit Master title style

‹#›

,

Wells Fargo (WF) Research Analysis

James O’neil

17 Feb 2022

Getty Images. (n.d.). San Francisco, Ca Scenic USA [Photograph]. Getty Images. https://www.gettyimages.com/detail/news-photo/the-entrance-to-a-wells-fargo-bank-in-san-francisco-news-photo/1042692884?adppopup=true

Common Size Analysis

For the past three years, the income statement for WF's revenue has been at 100%, with a Cost of Services growing in the computation.

The total cash has fluctuated over the years, with a gain of—twelve percent from 2019 to 2020 and a large reduction of Seventy-seven percent from 2020 to 2021.

The total stockholder's Equity has also increased over the last three years.

Trend Analysis

Trend analysis is used to examine the relationship between change's cause and effect.

Over the last five years, net income has declined by 39.23 percent, sales have decreased by 7.88 percent, total current assets have decreased by 47.23 percent, and shareholder equity has reduced by 9.76 percent.

This bear market trend analysis is defined as a market that is declining due to its inability to generate large profits.

When there is a net loss, it signifies that the stockholders' Equity will be reduced as a result of expenses incurred as a result of decreased assets or higher liabilities.

Financial Ratio Analysis

This study of the ratio results will determine how liquid the company is, whether management is profiting significantly from the WF's assets, and whether or not the company's financial performance needs to be improved.

Even though there were fluctuations over the years, WF remained a liquid firm. Liquidity is showing a declining trend in percentage rate, which could be attributed to the increase in interest rates.

From 2019 to 2021, the networking capital-to-sale ratio decreased by.44 percent. The networking capital-to-sale ratio is less than one, indicating that WF has little working capital and is properly spending its extra cash.

Evaluating Return

The Return on Equity is a tool for determining the worth of a company.

After all expenses have been met, the profit margin shows how much money is leftover. The net margin has fallen in percentage over the last three years.

The asset turnover ratio displays how much money was spent on each amount of assets. Over the last three years, there has been an increase, indicating they are more efficient with the available assets.

Recommendations

The present financial performance patterns and results for WF show that the company has adequate financial power and will be financially sustainable in the next 2 – to 3 years. WF's revenue and debt-to-equity ratio are two measures of its strong financial position.

The primary goal of financial leverage is to demonstrate how much of a business's assets are backed by Equity and how long the company can continue to grow profitably without a major debt burden.

When financial leverage's equity value drops, the company's value drops as well.

Year 2021 2020 2019

Net profit margin 0.18 0.19 0.1

Asset turnover 0.75 0.61 0.56

Financial leverage 1.48 1.77 1.49

ROE 21.14 18.75 15.7

Debt 0.17 0.18 0.22

Order Solution Now

Similar Posts