Financial Analysis using Excel
Not what you're looking for?
Please see attached document.
Financial Analysis with Microsoft Excel
1) Suppose that at the beginning of January 2000, you purchased shares in Advanced Micro Devices, Inc. (NYSE: AMD). It is now five years later, and you decide to evaluate your holdings to see if you have done well with this investment. The table below shows the market prices of AMD.
Date Price
2000 13.81
2001 15.86
2002 6.46
2003 14.90
2004 22.02
2005 30.60
a) Enter the data, as shown, into a worksheet and format the table as shown.
b) Create a formula to calculate your rate of return for each year. Format the results as percentages with two decimal places.
c) Calculate the total return for the entire holding period. What is the compound average annual rate of return?
d) Create a line chart showing the stock price from January 2000 to January 2005. Make sure to title the chart and label the axes.
e) Experiment with the formatting possibilities of the chart. For example, you might try changing the line to a three dimensional line and filling the plot area with a marble background.
Purchase this Solution
Solution Summary
The solution creates a financial analysis using excel.
Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Learning Lean
This quiz will help you understand the basic concepts of Lean.