2015 265.41 18.71 18.71

Financial Analysis with Microsoft Excel, 9e Timothy Mayes

(Solutions Manual All Chapter)

(For Complete File Download link at the end of this File)

• / 3

Tesla Inc.DATE CLOSE Return Cum. Return

2014223.57

2015265.41 18.71% 18.71%

2016229.51 -13.53% 2.66%

2017343.85 49.82% 53.80%

2018306.65 -10.82% 37.16%

2019228.04 -25.64% 2.00%

Total Return2.00% 2.00% 2.00% Compound Annual Return 0.40% 0.40% 0.40% One possible alternative chart

200.00

400.00

-

100.00

200.00

300.00

400.00

d)The two charts line chart are aligned in the center of the X The reason for this is that the label on the line chart is just that, a label. Excel doesn't treat it as a number and it migh are numbers, the XY Scatter chart is slightly more appropriate in this case. However, it doesn't matter too much here. In oth make a great deal of difference. One of the most common questions that I get is "Why doesn't my chart display properly?" In m is that a Line chart was used when a Scatter chart was the correct choice. Remember, Line charts are for categorical data and showing relationships in numerical data.e)The above chart is a 3D Line chart that has been slightly rotated and has a marble backround any practical purpose, and actually makes the data slightly more difficult to understand. This is an example of the type of chart that data visualization experts recommend against. Much better are the simple charts above.This is Excel files solutions manual, PDF is converted only for a short review, complete solutions manual is in excel files.ignore this PDF bad formatting, when you will download excel files, it will be perfect and complete solutions manual in excel. 2 / 3

Tesla Inc. (line chart)Tesla Inc. (XY Scatter Chart) One possible alternative chart CLOSE -

200.00

400.00

Tesla Inc.

CLOSE

201420152016201720182019

Tesla Inc.(line chart) CLOSE -

100.00

200.00

300.00

400.00

Tesla Inc.(XY Scatter Chart) The two chartsare created above. They appear to be very similar, but a close look will reveal a key difference. Notice that the data points line chart are aligned in the center of the X-axis label. In the XY chart they are aligned directly above the data point on the The reason for this is that the label on the line chart is just that, a label. Excel doesn't treat it as a number and it migh are numbers, the XY Scatter chart is slightly more appropriate in this case. However, it doesn't matter too much here. In oth make a great deal of difference. One of the most common questions that I get is "Why doesn't my chart display properly?" In m is that a Line chart was used when a Scatter chart was the correct choice. Remember, Line charts are for categorical data and showing relationships in numerical data.The above chart is a 3D Line chart that has been slightly rotated and has a marble backroundadded. Note that the "eye candy" doesn't serve any practical purpose, and actually makes the data slightly more difficult to understand. This is an example of the type of chart that data visualization experts recommend against. Much better are the simple charts above.

• / 3