Homework answers / question archive / 1

1

Finance

Share With

1.A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file.

B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute the price changes using the current week prices minus the previous week's prices. Create a new column for each stock which takes the value of one if the price changes are positive, zero otherwise.

C. Use another sheet to stack up all info of price changes (1/0), ticker, and industry. This table should include three columns (stock’s ticker, price changes, industry). Create pivot table to get the price change information across stocks and industry.

2.3. At a rate of interest (i) where i>0, a 36-year annuity-immediate with annual payments of $4 has the same present value as an eighteen-year annuity- immediate with annual payments of $5. In how many years does money double at the rate of interest i?

3.What is the cost of equity capital for PCP based on the CAPM (Capital Asset Pricing Model), and the information given here:

Berkshire Hathaway’s cost of equity was 9.2%, which reflected a beta of 0.90, an expected market return of 9.90%, and a risk-free rate of 2.89%. The yield on corporate bonds rated AA was 3.95%—and after a 39% expected marginal tax rate, the cost of debt would be 2.3%. Weights of capital were 16.9% for debt and 83.1% for equity. In contrast, the beta for PCP was 0.38. Analysts expected that PCP’s cash flows would grow indefinitely at about the long-term expected real growth rate of the U.S. economy, 2.5%.

1. 5.55%
2. 6.65%
3. 9.20%
4. 11.80%

4.Imagine that 50 years ago, your aunt made an investment of $10 into an account that earned 12% each year. What is the effect of compounding? (Round to 2 decimal places, do not include dollar signs in your response.)