Question

Assignment:
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.

Instructions:
Analyze Target Corporation and Costco Wholesale.
Select the 10 most important financial ratios for these two companies and calculate each for the last 2 fiscal years using Excel.
Create a single Excel file for your entire assignment.
You may obtain financial information and the companies' latest annual reports on the web directly from MSN Money or Yahoo Finance or Morningstar.
For additional information, look for the SEC Form10-K link from one of the MSN Money, or Morningstar, or Yahoo Finance financial sites.
You should calculate, and comment upon, all 10 financial ratios for the last 2 fiscal years.
All calculations should be shown, and all answers should be thoroughly explained.
It is useful to compare financial ratios for a company with financial ratios of its industry.
Industry financial ratios can be found on Morningstar.com, Yahoo Finance and MSN Money.
When using 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.

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

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Answer:
What can you tell from your analysis?
What are the strengths and weaknesses of each company?   
Which is the stronger competitor?
Give your reasons.
According to analysis of financial ratios and management key statistics, Costco Incorporated is a better stock compared to Target Corporation. In the world of retail, the industry is dominated by Walmart, but Costco Inc. with a lower Market Cap compared to Walmart could compete in the market in terms of growth and returns....

This is only a preview of the solution. Please use the purchase button to see the entire solution

Related Homework Solutions

Accounting Questions
Homework Solution
$20.00
Business
Accounting
Finance
Administration
Economy
Tax
Life Insurance
Adjusted Gross Income
Deductions
Expenses
Utilities
Accounting Questions
Homework Solution
$20.00
Business
Accounting
Company
Journal
Proceeds
Sale
Cost
Depletion
Stock
Value
Share
Business Questions
Homework Solution
$63.00
Accounting
Business
Finance
Economy
Cash Conversion Cycle
Inventory Turnover
Investments
Payments
Sales
Monthly Fee
Annual Fee
Accounting Questions
Homework Solution
$20.00
Business
Accounting
Asset
Cost
Ledger
Account
Purchase
Bond
Yield
Interest
Amortization
P&L and Balance Sheet
Homework Solution
$20.00
Business
Accounting
P&L
Balance
Sheet
Team
Debt
Expenses
Payroll
Cost
Money
Get help from a qualified tutor
Live Chats