here are the rest of the questions

Company Basics and Financial Ratios Part 2

Question 1

Using the most recent three years of available data, compute Wal-Marts and Targets degree of operating leverage. You will have to use the formula, percentage change in pretax income divided by percentage change in revenues. Show your work.

DOL = %Change in EBIT / % Change in sales

2015 = 17.88% / 1.9% = 9.41% Wal-Mart

2014 = 17.7% / 1.6% = 11.06% Wal-Mart

2013 = 16.9% / 5% = 3.38% Wal-Mart

2014 = 6.6% / 1.3% = 5.07% Target

2013 = 7% / -.4% = 17% Target

2012 = 7.8% / 2.7% = 2.88% Target

Question 2

Using the last three years of available data, compute Wal-Marts and Targets degree of financial leverage. You will have to use the formula, percentage change in net income divided by percentage change in pretax income (EBIT). Show your work.

Change of net income / EBIT = DOFL

2015 = 19.4% / 17.88% = 1.085% Wal-Mart

2014 = 19.3% / 17.7% = 1.09% Wal-Mart

2013 = 19.0% / 16.9% = 1.12% Wal-Mart

2014 = 29.4% / 6.6% = 4.45% Target

2013 = 29.8% / 7% = 4.26% Target

2012 = 29.7% / 7.8% = 3.8% Target

Question 3

With each company, multiply the degree of financial leverage times the degree of operating leverage to determine the degree of combined leverage for the two periods.

Question 4

Compare the leverage ratios. Did the degrees of leverage stay the same? Explain the differences between the two periods.

Question 5

Go to finance.yahoo.com and get the quotes of Target and Wal-Mart. (Type into the Get Quotes box. Click on the Profile section on the home page and write a few sentences of each firms activities.

Write down each firms P/E ratio. Calculate the PEG ratio (the P/E ratio divided by annual growth).

1. Which firms ratios are higher?
2. Is the stock of each company up or down from the prior day? (See change on the home page.)
3. What is each companys 52-week range?

Scroll down and click on Analysts Opinion. What is the Mean Target, the High Target, and the Low Target? How many brokers follow each firm?

Question 6

a.)With each company, compute the $ change in Total Assets over the last two years.

b.) Do the same computation for Stockholders Equity.

c.) Do the same computation for Long-Term Debt.

d.) In a brief paragraph describe the changes in total assets, stockholders equity and long-term obligations. Do these changes appear to affect the firm? Describe.

Question 7

Find the long-term debt and total common equity for the last 2 years. Add the two together to get total capital.

a.) Calculate the weights between long term debt and equity that you would use in a weighted average cost of capital calculation.

b.) What are the weights for long term debt and equity for the last five years? Have they remained stable? Comment on the stability or lack of stability and how it would affect the companys cost of capital