Target Corporation need help with the following questions below

Select five (5) financial ratios, then analyze the past three (3) years of financial data for the investment (please obtain data from the financial statements or the equivalent).

Analyze the price of the investment to its market index for the past five (5) years.

Create a trend line that depicts the price movement for the investment against the market index movement using elements of Microsoft Office, such asExcel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice, as appropriate. Note: The graphically depicted solution is not included in the required page length.

Determine the type of person who would be the best candidate for the chosen investment (e.g., the risk adverse investor, an aggressive investor, etc.). Provide a rationale for why this investment is a solid one, and support the assertion that someone should invest in this stock.