Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Target is my company. How does your company stack up against its competiton? ANALYZE (Walmart,Costco)k 1.) IS your company in an attractive industry? (Yes or

Target is my company. How does your company stack up against its competiton? ANALYZE (Walmart,Costco)k 1.) IS your company in an attractive industry? (Yes or No) ANALYZE Explain 2.) What metrics determine superior companies for your industry?ANALYZE

3.)

3.) Analyze how your company ranks in the industry using Dupont analysis and industry specific ratios.

DuPont Analysis of ROE = ROS x Asset turnover = ROA x Financial LEVerage = ROE
Return on Sales (ROS), also known as Net Profit Margin 4.19% 4.09% 2.77% -2.25% 4.56%
Asset Turnover 1.60 1.57 1.48 1.63 1.79
Return on Assets (ROA) 6.70% 6.43% 4.09% -3.67% 8.17%
Financial LEVerage 2.82 2.95 2.91 2.74 2.94
Return on Equity (ROE) 18.91% 18.96% 11.90% -10.08% 24.03%

f.) State your investment thesis

a.) Sustainablity economic moat? profitability explain ANALYZE

your company pass or fail

Profitability 2007-01 2008-01 2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 TTM
Tax Rate % 38.03 38.40 37.39 35.74 35.04 34.27 34.93 36.48 32.96 32.54 31.55
Net Margin % 4.68 4.50 3.41 3.81 4.33 4.19 4.09 2.72 -2.25 4.56 4.75
Asset Turnover (Average) 1.64 1.55 1.47 1.47 1.53 1.55 1.55 1.57 1.69 1.80 1.75
Return on Assets % 7.70 6.96 4.99 5.61 6.62 6.48 6.33 4.25 -3.81 8.24 8.33
Financial Leverage (Average) 2.39 2.91 3.22 2.90 2.82 2.95 2.91 2.74 2.96 3.11 3.49
Return on Equity % 18.68 18.42 15.26 17.12 18.94 18.71 18.52 12.02 -10.82 24.95 27.51
Return on Invested Capital % 12.63 11.19 8.50 9.29 10.77 11.02 10.51 8.37 -5.76 12.81 13.40
Interest Coverage 5.82 6.91 6.13 7.05 3.76

b.) growth?Stable? dividends? explain ANALYZE

Growth Rate (%)

Company

Industry

Sales (Revenue)

Q/Q (Last Year)

-6.70

1.14

Net Income

YTD/YTD (Last Year)

35.60

-0.97

Net Income

Q/Q (Last Year)

27.70

-1.21

Sales (Revenue)

5-Year Annual Average

1.83

12.83

Net Income

5-Year Annual Average

2.60

3.26

Dividends USD 0.44 0.52 0.60 0.66 0.84 1.10 1.32 1.58 1.90

2.16 2.28

your company pass or fail

c.) financial health? financial risk explain ANALYZE

iquidity/Financial Health 2007-01 2008-01 2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 Latest Qtr
Current Ratio 1.32 1.60 1.66 1.63 1.71 1.15 1.16 0.91 1.20 1.12 1.02
Quick Ratio 0.68 0.94 0.91 0.81 0.78 0.47 0.06 0.16 0.28 0.38 0.10
Financial Leverage 2.39 2.91 3.22 2.90 2.82 2.95 2.91 2.74 2.96 3.11 3.49
Debt/Equity 0.55 0.99 1.28 0.99 1.01 0.85 0.89 0.78 0.91 0.92 1.09

your company pass or fail

d.) quality of income explain ANALYZE

-1.86 -1.78 -3.31 -2.71 1.74

your company pass or fail

e.) good value? buy now? explain aNALYZE

your test pass or fail

Price Ratios

Company

Industry

Current P/E Ratio

14.41

17.33

P/E Ratio 5-Year High

15.86

45.22

P/E Ratio 5-Year Low

8.73

2.96

Price/Sales Ratio

0.66

0.53

Price/Book Value

3.96

3.41

investment decisions ANALYZE

overall,the company is long term buy (buy/review again at lower price /Bust)

why give five good reason?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Health Care Finance And The Mechanics Of Insurance And Reimbursement

Authors: Michael K. Harrington

2nd Edition

1284169030, 978-1284169034

More Books

Students also viewed these Finance questions