Question
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 -
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 HYPERLINK "\\\\mugen2\\muhome\\eguo\\341 Summer\\ba341.computer exercise 1 2014.xlsx" 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started