Question

Select WALMART for analysis. Go to the Yahoo! Finance Web site. Enter the stock ticker symbol or name of the company you wish to analyze in the input field next to Get Quotes at the top of the page and click Get Quotes to open the stock's overview/main page. Review the price graph provided on the overview page. Click on 6m or 1y at the bottom of the chart to get prices on the stock for the past 6 months or one year, respectively. For either the 6-month chart or the one-year chart, click on the Compare tab at the top of the chart and check the box(es) for one or more of the indices (S&P 500, Nasdaq, and Dow Jones Industrial Average) and click on Draw to generate comparisons of the price movements of the stock with those of one or more of these indices. Write a paragraph discussing ONE stock's price performance relative to that of the market as a whole, e.g., the S&P 500, over the past several months. Your comments are to include statements as to whether the stock's price seems to move up and down with the market or against it, and whether it moves more or less vigorously than the market. Go back to the overview page for the company you have selected and click on Key Statistics under the heading "Company" on the left-hand side of the page. On the "Key Statistics" page under "Financial Highlights" review the stated profit margin for the past or trailing 12 months (ttm). Note: The profit margin or net profit margin is also known as the return on sales (ROS), that is, net income (profits) as a percent of sales. See Chapter 3 of the textbook for a discussion. Go back again to the overview page for the company you have selected and click on Income Statement under the heading "Financials" on the left-hand side of the page. On the "Income Statement" page look at the profitability for the previous three years. Write a paragraph discussing how profitable the company has been recently. Your paragraph is to include a description of the trend in sales and profitability for the last three years. Under the heading "Analyst Coverage" on the left-hand side of the overview page click on Analyst Opinion. On the Analyst Opinion page there is a section entitled "Recommendation Summary" that averages this and last weeks' opinions of professional analysts about the stock on a scale that ranges from 1.0 (Strong Buy) to 5.0 (Sell). Sell means the analysts don't like the stock's prospects and advise investors to sell if they own the stock and otherwise to not invest in it. A strong buy means just the opposite: buy the stock because analysts expect it to make money for investors. In the section entitled "Upgrades & Downgrades History" you can review chronologically recent changes in professional analysts' recommendations about the stock. Under the heading "Analyst Coverage" on the left-hand side of the page click on Analyst Estimates to get estimates of the firm's future earnings, revenues, and growth. Note: We will return to these growth estimates in Assignment 4-2: Financial Analyst Exercise III. Write a paragraph explaining what the professional analysts are saying about investing in the stock. Is there a clear recommendation? Your responses are to demonstrate that you have reviewed the sections: Analyst Opinion and Analyst Estimates. Write 1-2 paragraphs in response to the following questions. What was the stock's most recent closing price? (Provide the date.) Is the price moving up or down (See percent change in parentheses on the overview/main page for the stock)? Look again at the six-month or one-year "Price Chart" graph. Does the stock seem volatile to you? Think in terms of the range of price movement over the last several months as a percent of an average of the high and low prices. Combine the paragraphs you have written into one paper.

Answer 1

Answer:

1.         Chevron:

a. Current ratio = 0.95x

b. Sales/total assets = 110.215/260.078 = 42.37%

c. Times interest earned = EBIT / interest expense = -1959/201 = -9.74x

d. Total debt/equity = 29.08%

e. Net income/sales = 4.99%

d. Return on assets = 0.28%

e. Return on equity = 3.99%

f. Trailing P/E = 37.95, Forward P/E = 24.28

2.         Eaton

a. Current ratio = 1.19x

b. Sales/total assets = 19.747/30.419 = 64.91%

c. Times interest earned = EBIT / interest expense = 2257/233 = 9.68x

d. Total debt/equity = 55.25%

e. Net income/sales = 9.95%

d. Return on assets = 4.60%

e. Return on equity = 12.78%

f. Trailing P/E = 17.82, Forward P/E = 15.28

3.         Kroger

a. Current ratio = 0.87x

b. Sales/total assets = 115.337/36.505 = 315.95%

c. Times interest earned = EBIT / interest expense = 3436/522 = 6.58x

d. Total debt/equity = 228.65%

e. Net income/sales = 1.32%

d. Return on assets = 5.4%

e. Return on equity = 24.04%

f. Trailing P/E = 12.42, Forward P/E = 10.47

4.         Walmart

a. Current ratio = 0.78x

b. Sales/total assets = 485.873/198.825 = 244.37%

c. Times interest earned = EBIT / interest expense = 22864/2367 = 9.66x

d. Total debt/equity = 60.72%

e. Net income/sales = 2.60%

d. Return on assets = 7.05%

e. Return on equity = 17%

f. Trailing P/E = 18.98, Forward P/E = 17.10