TARGET	INDUSTRY AVERAGE
Return on Equity	17.50%	16.90%
Price/earnings	263.25	21.7
Market Cap	842.8B	891B
Price / Book	65.05	4.6
Net Profit Margin	6.59%	2.60%
Debt to Equity	1.95	63.3

List of competitors: Walmart, costco, amazon

Financial statements of Target are available at: http://www.annualreports.com/Company/target-corp

Financial Analysis: For this part of the assessment, you will prepare spreadsheets and analysis to be included in your financial analysis paper.

A. Prepare an Excel spreadsheet to compare financial ratios for Target Corporation to the industry averages.

B. Compose a summation as to how Target Corporation is performing in relation to its competitors. Be sure to base your answer on the spreadsheet you previously prepared.

List of competitors: Walmart, costco, amazon

When answering the questions, consider the following:

The financial ratios that are compared to competitors should be presented in Excel. You will want to calculate these ratios. In the summation that should be located in your paper you will want to present your findings and provide insight into how Target Corporation is performing in comparison. Make sure you refer to the Excel Spreadsheet in your summation.