Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started