Reference no: EM1357218
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.
|
What present sources need to be used
: assignment is to be a minimum of five pages long and in APA format. A good variety of objective, high quality, present sources need to be used.
|
|
Explain the ethic of care is
: Explain The Ethic of Care is and The best example of a source for virtue ethics for a business is
|
|
Show socialization vs biological predisposition
: Explain what is a role that you currently hold and how have the agents of socialization, specific to you, placed you in the identified role?
|
|
Compare time complexity of convolution with kernel
: Compare the time complexity of convolution with a n x n kernel when using: direct convolution with the 2-D mask, and separable kernel.
|
|
Create a line chart showing the stock price
: Assume that at the starting of January 2000, you buy shares in Advanced Micro Devices. It is now 5-years later, and you decide to evaluate your holdings to see if you have done well with this investment.
|
|
Detailed description of journal entry
: The Mars Corporation issued 2,000 shares of its $10 par value common stock for $70,000. The Mars Corporation also incurred $1,500 of costs associated with issuing the stock.
|
|
Compute book value at the beginning of year
: abc company owns a crane with an original cost of 500,000$,with an estimate salvage value of 200000.its life is estimated to be 15years.using straight line method, Compute book value at the beginning of year 9.
|
|
Show management decision making
: How would you decide whether to agree with the request or not and how would you decide who should receive laptops and who should not?
|
|
Describe career development stage
: Explain what career development stage (early, midcareer, and/or preretirement for instance) would you say you are in at present and what concerns are associated with this stage?
|