Amazon.com Incorporated reported the following stock price at the beginning of each year since 2012. Using 2012 as the base year, develop a simple index for stock prices. Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Stock Price to Open Year $ 175.89 256.08 398.80 312.58 656.29 757.92 1,172.00 1,465.20 1,875.00 3,270.00 Click here for the Excel Data File What is the percentage increase in price over the 10-year period? Note: Round your answers to 2 decimal places.

Amazon.com Incorporated reported the following stock price at the beginning of each year since 2012. Using 2012 as the base year, develop a simple index for stock prices. Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Stock Price to Open Year $ 175.89 256.08 398.80 312.58 656.29 757.92 1,172.00 1,465.20 1,875.00 3,270.00 Click here for the Excel Data File What is the percentage increase in price over the 10-year period? Note: Round your answers to 2 decimal places.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

The following problem refers to the stock table for KIRED, Inc. (a computer company) given below Use the stock table to answer the following questions. Where necessary, round the dollar amounts to the nearest cent. 52-Week High 74.15 Yld Vol Net Low Stock SYM Div % PE 100s Hi Lo Close Chg 42.72 KIRED, Inc. KIR 3.11 4.1 22 7473 61.00 60.29 60.62 -1.52 a. What were the high and low prices for a share for the past 52 weeks? High price: $ Low price: S b. If you owned 700 shares of this stock last year, what dividend did you receive? %24 c. What is the annual return for the dividends alone? How does this compare to a bank offering a 3% interest rate? % O A. The %oyield is lower, than the bank rate O B. The bank rate is lower than the %yield. d. How many shares of this company's stock were traded yesterday? Click to select your answer(s). 1:56 PM P Type here to search 昂 A O D Q 24/2021 中0 (99+ 4/24/2021 DELL F11 PrtScr Insert Delete F7 F8 F9 F10 F12 F3 F4 F5 F6 Esc F1 F2 @ # $ % & Backspace…
The following returns reflect annual returns to ABC's stock and the S&P 500. 2017 2018 2019 2020 1.10 0.98 1.19 ABC 1.25 .11 -.11 .033 -.055 S&P 500 .1 What is the beta for ABC's stock. Please round to the nearest 100th (ex. X.XX) -.1 .05 -.05
You bought a stock on 1 January 2018 for $135.5 and below are the year-end price data and annual dividends for the stock: Date Closing Price Annual Dividend 31 December 2017 135.5 3.6 31 December 2018 138.2 3.65 31 December 2019 136.8 3.5 31 December 2020 140.7 3.7 What is the standard deviation of returns on this stock over the 2018-2020 period? 0.0173 0.0005 0.0009 0.0212 O 0.0303
Given the following price and dividend information, calculate the lower bound to the 95th confidence interval. (Enter percentages as decimals and round to 4 decimals) Stock: MSFT Year Price Dividend 2017 $ 64.65 2018 $ 95.01 $ 1.72 2019 $ 104.43 $ 1.89 2020 $ 107.23 $ 2.09 2021 $231.96 $ 2.30 2022 $310.98 $ 2.54 2023 $247.81 $ 3.00
Using the data from the following table,calculate the return for investing in this stock from January 1 to December 31. Prices are after the dividend has been paid. Stock Price Dividend Jan 1 $50.18 Mar 31 $51.11 $0.58 Jun 30 $49.56 $0.58 Sep 30 $51.93 $0.75 Dec 31 $52.53 $0.75 The return from January 1 to March 31 is enter your response here. (Round to five decimal places.) Part 2 The return from March 31 to June 30 is enter your response here. (Round to five decimal places.) Part 3 The return from June 30 to September 30 is enter your response here. (Round to five decimal places.) Part 4 The return from September 30 to December 31 is enter your response here. (Round to five decimal places.) Part 5 enter your response here%. (Round to two decimal places.)
cks A and B have the following historical returns: Year 2016 2017 2018 2019 2020 Stock A's Returns, ra (17.90%) 30.00 13.25 (3.50) 29.75 Stock B's Returns, ra (14.20%) 22.70 a. Calculate the average rate of return for each stock during the period 2016 through 2020. Round your answers to two decimal places. Stock A 39.50 (7.10) 10.70 Stock B b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock 8. What would the realized rate of return on the portfolio have been each year? Round your answers to two decimal places. Negative values should be indicated by a minus sign. Year 2016 2017 2018 2019 2020 What would the average return on the portfolio have been during this period? Round your answer to two decimal places. Portfolio CV e. Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? ele Calculate the standard deviation of returns for each stock and for the portfolio. Hound your answers to two decimal places.…
You've collected the following information from your favorite financial website. 52-Week Price Lo 10.43 Acevedo .36 33.42 69.70 13.95 Manta Energy .80 20.74 Winter Sports .32 Hi 77.40 55.81 130.97 50.24 35.00 Current stock price Stock (Dividend) Georgette, Incorporated 1.54 YBM 2.20 Stock currently Dividend Yield % 2.6 3.8 2.5 5.2 1.5 PE Ratio 6 10 10 6 28 Close Price 13.90 40.43 89.01 15.43 ?? According to analysts, the growth rate in dividends for YBM for the next five years is expected to be 19.5 percent. Suppose YBM meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 5 percent, indefinitely. Assume investors require a return of 15 percent on YBM stock. According to the dividend growth model, what should the stock price be today? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Net Change -.24 -.01 3.07 -.26 .18 Based on these assumptions, is the stock currently overvalued,…
o The following information is available concerning the price evolution of Microsoft stocks between 2016-2019 and the dividends paid by them. Date March 1, 2016 April 1, 2016 July 1, 2016 March 1, 2017 March 1, 2019 Close price 55.23 49.87 56.68 65.86 117.94 Total Dividends - 0.36 1.50 4.88 o Requirements: Considering that you bought Microsoft shares on March 1, 2016, compute the holding-period return for each maturity • Annualize the holding-period returns using EAR and APR • Comment on the results
Please stepwise all parts
None
Please give me the steps in excel :)
Demonstrate the impact of different values on a market value weighted stock index with a hypothetical example considering three stocks (stock A, B and C), no. of shares and price for base year 2020 and for the year 2021 with two different cases Case A and Case B ( base year index value as 100)

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

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 Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

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 Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS