Share
Explore BrainMass

Target and Walmart- Financial Analysis

You are the assistant to the CEO of a major company. Your CEO keeps an eye on the competition, and asks you to do the following. Using ratio analysis, compare two major competitors in the same industry.
Pick any two U.S. public companies in the same industry (except Walgreen's or CVS Drugstores).

Please use Target and Walmart.

You may obtain financial information and the companies' latest annual reports on the web directly from MSN Money or Yahoo Finance.

In fact, you can use the DrugstoreChains example as a template: just copy the financial statement data for your two chosen companies right on top of the existing financial statement data for the two drugstore chains.

For additional information, look for the SEC Form10-K link from one of the MSN Money or Yahoo Finance financial sites.

Instructions:

Create a single Excel file for the entire assignment. There are three separate financial statements to analyze:

a. the income statement,
b. the balance sheet, and
c. the cash flow statement.

You should calculate, and comment upon, all relevant financial ratios for the last 2 fiscal years, including market ratios (such as PE ratios and market to book value of equity) and a full DuPont analysis.

All financial statements used should be shown. All calculations should be shown, and all answers should be thoroughly explained.

Whenever you use balance sheet items to calculate ratios, for each year be sure to average the beginning-of-year and end-of-year amounts to get the average for that year.

What can you tell from your analysis? What are the strengths and weaknesses of each company? Which is the stronger competitor? Give your reasons.

The financial statements should be a 5 yr span ( 08, 07, 06, 05 and 04).
The comments for the financial ratios, including market ratio and all other analysis should be for the last 2 fiscal years...08 and 07. Pls let me know if you have any questions. Thanks!

Hello,
I need help with an assignment for my Financial Mgmt class. Please see attched for instructions and template to use for this assignment.
The example used is for Walgreens and CVS Drugstore, but I would like you to compare Target and Walmart for this assignment using ratio analysis. Please see attached documents for more detailed instrustions and template to use.

Please let me know if you need further clarification. I would like to have this by Monday. Please forward the rate as well.

Thanks,
Yomi

Attachments

Solution Preview

Please follow the same format as the Drugstore Chains Excel example.

You are the assistant to the CEO of a major company. Your CEO keeps an eye on the competition, and asks you to do the following. Using ratio analysis, compare two major competitors in the same industry.
Pick any two U.S. public companies in the same industry (except Walgreen's or CVS Drugstores).

Please use Target and Walmart.

You may obtain financial information and the companies' latest annual reports on the web directly from MSN Money or Yahoo Finance.

In fact, you can use the Drugstore Chains example as a template: just copy the financial statement data for your two chosen companies right on top of the existing financial statement data for the two drugstore chains.

For additional information, look for the SEC Form10-K link from one of the MSN Money or Yahoo Finance financial sites.

Instructions:
the financial statements should be a 5 yr span ( 08, 07, 06, 05 and 04).
The comments for the financial ratios, including market ratio and all other analysis should be for the last 2 fiscal years...08 and 07. Pls let me know if you have any questions. Thanks!

Hello,
I need help with an assignment for my Financial Mgmt class. Please see attched for instructions and ...

Solution Summary

Response provide guidance of financial analysis of Target and Walmart

$2.19