Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...

Please solve A, B, and C. Please use excel. Please show work. Thank you.

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.

Solutions

Expert Solution

1) The adjusted price data for the index and Apple,SAP,IBM,Oracle and Amazon was downloaded from the Yahoo Finance site

The binary compuation was done using an IF statement

IF(price this week-price prev week>0,1,0)

The PIVOT table is inserted selecting industry as row and stock ticker and price change as columns

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Please solve in Excel and show your work. Thank you. Calculate the value of Apples’ stocks...

Please solve in Excel and show your work. Thank you. Calculate the value of Apples’ stocks given These following inputs are from Yahoo finance to see how close the model will match the current mkt price. These are 2019 figures: FCF’s = 60 billion growth= 5% wacc = 7.5% Treasury securities = 51 billion debt = 92 billion #shares= 4.6 billion Assume the growth rate listed is for the first 4 years and then FCF’s will grow at 3.5% thereafter....

Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is...

Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is depreciated straight line to a zero salvage value over a 10 year life. The asset will be worthless in 10 years. The project will generate, annually, revenues of $800,000, cash operating expenses of $500,000, and depreciation of $100,000. The tax rate is 30%, and the cost of capital is 10%. a. what are the annual cash flow and the NPV? b. what would be...

Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a...

Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a project with the after-tax cash flows shown below. The required return (cost of capital) on the investment is 10%. Compute the: Year 0 1 2 3 4 Cash flow -70,000 30,000 30,000 30,000 20,000 Payback Discounted payback NPV Profitability index IRR MIRR

Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with...

Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with a coupon rate of 8% from a bank as a mortgage against your newly renovated plant. The loan is paid off in 7 years. You will pay an equal amount every year until the loan is fully paid off. What are the interest and principal payments for each year of the loan.

Please use Excel and show the formula you used. Thank you :) A manufacturing process produces...

Please use Excel and show the formula you used. Thank you :) A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?

Please solve the questions below and show your work. Thank you. The town of Utopia has...

Please solve the questions below and show your work. Thank you. The town of Utopia has three equal-size groups of people: (i) type A people consistently prefer larger public parks to smaller; type B people prefer small public parks to large public parks, and they prefer large size to medium size parks; type C people most prefer medium size to small size public parks, which they in turn prefer by a modest amount to large levels. a. Draw on a...

Formulate the problem as a linear programming model use excel and show your excel work. Thank...

Formulate the problem as a linear programming model use excel and show your excel work. Thank you. To (cost, in 100's) From New york Philadelphia Chicago Boston Supply Tampa $9 $14 $12 $17 200 Miami 11 10 6 10 200 Fresno 12 8 15 7 200 Demand 130 170 100 50

Solve in excel please, thank you It gives the data on the lifetime in hours of...

Solve in excel please, thank you It gives the data on the lifetime in hours of a sample of 100 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. a. Identify the null and the alternate hypotheses for this study. b. Can this lightbulb manufacturer claim at a significance level of 5% that its lightbulbs typically last more than 1000 hours?...

Please show work step by step, no excel. Thank you! The three alternative projects shown below...

Please show work step by step, no excel. Thank you! The three alternative projects shown below have the expected cash flows that are given, and the cost of capital is 10%. Calculate the paybacks for all three projects. Rank the projects from best to worst based on their paybacks. Calculate the NPVs for all three projects. Rank the projects from best to worst based on their NPVs. Why are these two sets of rankings different? year 0 1 2 3...

PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and...

PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2015 $ 106 $ 5 2016 101 5 2017 89 5 2018 94 5 An investor buys three shares of XYZ at the beginning of 2015, buys another two shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all four remaining shares at the beginning...

Subjects