a.
To show: The data in tabular form in new worksheet.
Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.
a.
Explanation of Solution
The date have been shown in ‘column A’ while price of stock has been represented in ‘column’ B. The tabular presentation of the given data has been shown below:
b.
To compute:
Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.
b.
Explanation of Solution
Rate of return for each year has been computed using the following formula:
Thus, the calculated rate of return has been shown below:
c.
To compute: Cumulative total return since 2011.
Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.
c.
Explanation of Solution
Cumulative rate of return can be computed by adding each year’s rate of return. It can be computed on excel using following formula:
Thus, the calculated cumulative rate of return has been shown below:
d.
To compute: Rate of return for holding period and compound average rate of return.
Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.
d.
Explanation of Solution
The rate of return for the holding period can be computed as:
The calculated answer has been shown below:
Now, compound annual average of return can be computed using:
e.
To prepare: Line chart and scattered chart. Also, state the difference between the two charts and suggest the most suitable.
Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.
e.
Explanation of Solution
The line chart has been prepared for FAST stock prices:
The scattered chart has been prepared for FAST stock prices:
Following are the differences between line and scatter chart:
Line chart: The values ??are plotted only on the y-axis i.e., the vertical axis. While, on the x-axis i.e., the horizontal axis the sequence number of the value is shown. Exceptions: graphs with the date on the X-axis.
Scatter chart: The relationship between two values is represented using the scatter chart. Scatter charts is often known as XY chart.
Here, two different values are not given which means there is no need to find the relationship between two values. So, in order to find trend of stock prices a line chart is more appropriate.
f.
To prepare: 3-D line chart and discuss if it helps in better understanding.
Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.
f.
Explanation of Solution
The line chart has been prepared for FAST stock prices:
The 3-D line chart has been prepared:
The comparison between the two charts can be seen easily. Thus, yes the enhancements will make data more attractive for the reader.
Want to see more full solutions like this?
Chapter 1 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
- (Computing rates of return) From the following price data, compute the annual rates of return for Asman and Salinas. Time Asman Salinas 1 $10 $30 2 12 27 3 11 32 4 13 34 (Click on the icon in order to copy its contents into a spreadsheet.) How would you interpret the meaning of the annual rates of return? Question content area bottom Part 1 The rate of return you would have earned on Asman stock from time 1 to time 2 is enter your response here%. (Round to two decimal places.)arrow_forwardYou are considering buying stock of a particular company. Your plan is to buy the stock today, receive dividend payments exactly one year from now, receive dividend payments again exactly two years from now, and immediately after receiving dividends in the second year, you would sell the stock. You paid a professional to perform fundamental analysis on the company, and you receive the following information based on that analysis: 1. expected dividend payment for one share one year from now: $21 2. expected dividend payment for one share two years from now: $34 3. expected sale price of one share of stock two years from now: $340 You may assume there is no inflation. If the prevailing interest rate is 7%, at what price would you consider a share of this company to be fairly valued today? (If necessary, round your answer to the nearest integer)arrow_forwardFrom the following price data, compute the annual rates of return for Asman and Salinas. Time Asman Salinas 1 $ 10 $ 31 2 13 27 3 12 33 4 14 35 (Click on the icon in order to copy its contents into a spreadsheet.) How would you interpret the meaning of the annual rates of return? Question content area bottom Part 1 The rate of return you would have earned on Asman stock from time 1 to time 2 is enter your response here %. (Round to two decimal places.) Part 2 The rate of return you would have earned on Asman stock from time 2 to time 3 is enter your response here %. (Round to two decimal places.) Part 3 The rate of return you would have earned on Asman stock from time 3 to time 4 is enter your response here %. (Round to two decimal places.) Part 4 The rate of return you would have earned on Salinas stock from time 1 to time 2 is enter your response here %. (Round to two decimal places.) Part 5…arrow_forward
- Please correct answer and step by step solutionarrow_forwardhello, I need help pleasearrow_forwardUse the end of year price, dividend data (dividend paid during year), and annual returns provided below for the common stocks of Norvell and Napier to respond to questions 1 through 6. It is okay to use your calculator when generating the answers. Just include the equations that you use, and make sure that you are able to do these calculations on the exam. Norvell Napier Date Close Price Dividend Annual Return (%) Annual 12/31/2018 24.00 Close Price 26.00 Dividend Return (%) 12/31/2019 31.63 0.92 35.63 28.14 0.86 11.54 12/31/2020 26.88 1.12 -11.48 34.47 0.98 25.98 12/31/2021 35.26 1.32 36.09 44.25 1.10 31.56 12/31/2022 32.65 1.52 -3.09 39.07 1.22 -8.95 12/31/2023 36.84 1.72 18.10 40.56 1.34 7.24 Estimated = Norvell - 21.84% Estimated = 16.04% Napier 3. Compute the covariance between the returns of Norvell stock and Napier stock. 4. Now compute the correlation between the Norvell and Napier stocks and indicate how this relates to the covariance in question 2. 5. You must now compute the…arrow_forward
- Please use Excel to solve: You have just purchased a share of stock for $20. The company is expected to pay a dividend of $0.50 per share in exactly one year. If you want to earn a 10% return on your investment, what price do you need if you expect to sell the share immediately after it pays the dividend?arrow_forwardhello, I need help pleasearrow_forwardNeed help with these questions. Best answer please. Construct the answers properly and follows the instructions in each question.arrow_forward
- kindly refer to the photos below.arrow_forward(Calculating rates of return) Blaxo Balloons manufactures and distributes birthday balloons. At the beginning of the year Blaxo's common stock was selling for $17.95 but by year end it was only $16.91. If the firm paid a total cash dividend of $1.76 during the year, what rate of return would you have earned if you had purchased the stock exactly one year ago? What would your rate of return have been if the firm had paid no cash dividend? The rate of return you would have earned is %. (Round to two decimal places.)arrow_forwardIn doing a five-year analysis of future dividends, the Dawson Corporation is considering the following two plans. The values represent dividends per share. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. Year Plan A Plan B 1 $ 1.30 $ 0.30 2 1.30 1.60 3 1.30 0.20 4 1.50 4.00 5 1.50 1.80 a. How much in total dividends per share will be paid under each plan over five years? (Do not round intermediate calculations and round your answers to 2 decimal places.) b-1. Mr. Bright, the Vice-President of Finance, suggests that stockholders often prefer a stable dividend policy to a highly variable one. He will assume that stockholders apply a lower discount rate to dividends that are stable. The discount rate to be used for Plan A is 11 percent; the discount rate for Plan B is 14 percent. Compute the present value of future dividends.…arrow_forward
Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education