Question: Formatting Table Styles Clipboard Font Alignment Number Styles G7 A F G . 1 Use the historical returns for Stocks X, Y and the market

Formatting Table Styles Clipboard Font Alignment Number Styles G7 A F G . 1 Use the historical returns for Stocks X, Y and the market to answer the following questions. 2 3 Historical Returns: 4 Year Stock X Stock Y Market 5 2016 1200 14.00 13.00 6 2017 15.00 7.00 - 13.00 7 2018 -13.00 -3.00 11.00 8 2019 5.00 4.00 3.00 9 2020 22.00 10.00 12.00 10 11 a. Find the average rate of return for each during the 5 year period. 12 b. Calculate the standard deviation for each 13 c. Find the Beta for each stock 14 d. Using your betas and the following information find the required rate of return on ths stocks 15 Risk-free rate, 4.00% 16 Market risk premium, RPM 5.00% 17 (Market risk Risk Free rate) 18 e. Your portfolio consists of 19 % of Stock X in Portfolio 80% 20 % of Stock Y in Portfolio 20% 21 Find the portfolio beta Sheet1 Reachy Formatting Table Styles Clipboard Font Alignment Number Styles G7 A F G . 1 Use the historical returns for Stocks X, Y and the market to answer the following questions. 2 3 Historical Returns: 4 Year Stock X Stock Y Market 5 2016 1200 14.00 13.00 6 2017 15.00 7.00 - 13.00 7 2018 -13.00 -3.00 11.00 8 2019 5.00 4.00 3.00 9 2020 22.00 10.00 12.00 10 11 a. Find the average rate of return for each during the 5 year period. 12 b. Calculate the standard deviation for each 13 c. Find the Beta for each stock 14 d. Using your betas and the following information find the required rate of return on ths stocks 15 Risk-free rate, 4.00% 16 Market risk premium, RPM 5.00% 17 (Market risk Risk Free rate) 18 e. Your portfolio consists of 19 % of Stock X in Portfolio 80% 20 % of Stock Y in Portfolio 20% 21 Find the portfolio beta Sheet1 Reachy

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The formulas above are the formulas to find the ratios needed. SOLVE FOR THE FOLLOWING RATIOS BELOW: Calculate all of the following ratios EXCEPT FOR the liquidity ratios 2 X Cut Le Copy ~ Calibri 11...

ABC Company makes steel tool cabinets for offices. They are in the process of preparing a Master Budget including the Operating budget, Cash Statement, Income Statement and Balance Sheet for 2020....

Job Order costing project ACCT-2302 Project Excel Template Please do the excel template so I can put it correctly. Half of it has been answer please answer the remaining ones. Thanks THIS is the...

BS Assignment 1A Group 3 - Excel Gursimran Kaur GK File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share > Ayo HH FA 4.0 .00 .00 0 Insert Delete Format...

File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do X Cut Arial - 10 A A E ab Wrap Text General Copy - Paste Format Painter BIU . IDA . BEE Merge & Center - $- % "...

FILL OUT ENTRY FOR 8-B-6 Brandon Rickman BR Share Comments Autosum AutoSave C - Copy of City of Corvallis mod 5(1001) (1) (2) - Excel File Home Insert Draw Page Layout Formulas Data Review View Help...

Questions are based on the following mini-case: CGX Transmitters is developing a 3 rd generation optical transmitter. Somebody in your department worked on it and prepared a pro-forma analysis but...

Laptop Sales at a London Computer Chain: Interactive Visualization. The next exercises are designed for using an interactive visualization tool. The file LaptopSales.txt is a comma-separated file...

ers ans Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns. Stock Y has a...

BS UVO182-XLS-ENG [Compatibility Mode] - Excel Sign in 0 x File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do If I WE HH 4.0 .00 .00 0 Insert Delete Format X...

K&W Co. has identified an investment project with the following cash flows. If the discount rate is 10 percent, what is the present value of these cash flows? What is the present value at 18 percent?...

What is the MIRR for Grady Enterprises in Problem 11? What is the MIRR when you adjust for the unequal lives? Does the adjusted MIRR for unequal lives change the decision based onMIRR? Year...

Which of the following is a fixed cost for a tire manufacturing business? Multiple select question. Material costs of $ 3 5 / tire Labor costs of $ 8 / hour Manager's salary of $ 9 8 , 0 0 0 / year...

Question: Who's liable for what because if debs the owner did they really trespass? Then who would be responsible as well for the propane line if they did/didn't trespass? Prompt The Rogers family...

=+1. Explain the difference between debt fi nance and equity fi nance.

=+5. Explain how a fi nancial crisis reduces the aggregate demand for goods and services.

=+ 6. What does it mean for a central bank to act as lender of last resort?