could you please help me with this chart

Managerial Finance I

Spring 2017

Computer Exercise 1

Drawing Charts

This exercise is designed to learn drawing charts by Excel. Financial data is commonly presented by chart in research papers and you will use charts to report the research data in your term paper.

The assignment requires you to draw two charts: 1. Tandy Corporation 10-Year Stock Price Trend, 2. Tandy Corporation EBIT, EPS, and Cash Dividend (2006 - 2015). Both charts should be in the format of XY Scatter. The following is the information for the charts.

Tandy Corporation

1. 10 year historical summary of stock price: high vs. low

Year High Low

2006 $12.10 $8.10

2007 $9.90 $2.80

2008 $5.10 $1.50

2009 $7.10 $2.30

2010 $7.60 $5.40

2011 $9.00 $5.80

2012 $15.30 $7.50

2013 $19.90 $11.60

2014 $37.00 $17.90

2015 $50.70 $31.70

2. 10 year historical summary of EBIT, EPS and cash dividend

Year EPS Cash Dividend EBIT ($ in Millions)

2006 $0.30 $0.15 $173

2007 $0.35 $0.15 $223

2008 $0.45 $0.20 $298

2009 $0.59 $0.25 $393

2010 $0.71 $0.40 $506

2011 $0.86 $0.40 $627

2012 $1.05 $0.50 $797

2013 $1.34 $0.60 $1,043

2014 $1.73 $0.80 $1,429

2015 $2.23 $1.10 $2,406

Your hand-in should include a cover sheet and two charts,