Purchase Solution

Financial analysis of Wal-Mart compared to Target

Not what you're looking for?

Ask Custom Question

Prepare a report on the financial analysis of these two companies. Perform the structured analysis steps 1-4 as laid out in Chapter 2 Data Case, on pages 45-46 in the textbook.

Analyze the performance of the stocks of the two case companies relative to the price/earnings ratios. Calculate these ratios for the past three years and tell why you think these differences have occurred, supporting your reasoning.
Data Case from 45-46 states:

1. Download the annual income statements, balance sheets, and cash flow statements for the four years from MarketWatch.com.

2. Find historical stock prices for each firm from Yahoo! Finance. Use the closing stock; calculate the firm's market capitalization for each date to cover the last day of the month by the firm's historic stock price.

3. For each of the four years statements compute:
a. Valuation Ratios
i. Price-earnings
ii. Market to Book Ratio
iii. Enterprise
b. Profitability Ratios
i. Operating Margin
ii. Net Profit
iii. Return on Equity
c. Financial Strength Ratios
i. Current Ratio
ii. Book Debt- Equity Ratio
iii. Market Debt- Equity Ratio
iv. Interest Coverage Ratio ( EBIT Divided by interest expense)

4. Obtain industry averages for each from firm from Reuters.com and co

Purchase this Solution

Solution Summary

Response provide the steps to compute the financial analysis of Wal-Mart compared to Target

Solution Preview

Data Case from 45-46 states:

1. Download the annual income statements, balance sheets, and cash flow statements for the four years from MarketWatch.com.
Attached in the excel file
2. Find historical stock prices for each firm from Yahoo! Finance. Use the closing stock; calculate the firm's market capitalization for each date to cover the last day of the month by the firm's historic stock price.
Price to earning ratio is taken from the source www.moneycentral.com

3. For each of the four years statements compute:
a. Valuation Ratios
i. Price-earnings
ii. Market to Book Ratio
iii. Enterprise
b. Profitability Ratios
i. Operating Margin
ii. Net Profit
iii. Return on Equity
c. Financial Strength Ratios
i. Current Ratio
ii. Book Debt- Equity Ratio
iii. Market Debt- Equity Ratio
iv. Interest Coverage Ratio ( EBIT Divided by interest expense)

4. Attached in the excel file

4. Obtain industry averages for each from firm from Reuters.com and ...

Purchase this Solution


Free BrainMass Quizzes
Motivation

This tests some key elements of major motivation theories.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.