Question 3 with each company, multiply the degree of financial leverage times the degree of operating leverage
Question:
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. Target 2013 23.89 x 1.61 = 38.36% 2012 0.18 x 2.60 = 0.47% Walmart 2013 0.93 x 1.77 = 1.65% 2012 0.67 x 1.06 = 0.71% question 4 compare the leverage ratios. Did the degrees of leverage stay the same? Explain the differences between the two periods. Wal-Mart target 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 firm’s activities. write down each firm’s p/e ratio. calculate the peg ratio (the p/e ratio divided by annual growth). a.) which firm’s ratios are higher? b.) is the stock of each company up or down from the prior day? (See “change” on the home page.) c.) what is each company’s 52-week range? d.) scroll down and click on “analyst’s opinion.” what is the mean target, the high target, and the low target? How many brokers follow each firm? Wal-Mart target
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank