Question: Using the template Excel Index Model posted on Canvas, find out Microsofts alpha, beta, and the fraction of its variance attributed to market risk. find

Using the template Excel Index Model posted on Canvas, find out Microsofts alpha, beta, and the fraction of its variance attributed to market risk. find R_M, R_IBM, R_MSFT? SHOW FORMULAS PLEASE.

Year Month r_f r_M R_M r_IBM R_IBM r_MSFT R_MSFT
1996 1 0.0048 0.0449 -0.0271 0.0277
1996 2 0.0048 0.0517 0.0554 0.0650
1996 3 0.0049 -0.0166 -0.0840 -0.0484
1996 4 0.0051 0.0110 0.0534 -0.0354
1996 5 0.0056 0.0004 0.0020 0.0642
1996 6 0.0056 0.0515 0.1322 0.1552
1996 7 0.0059 -0.0073 -0.0128 -0.1119
1996 8 0.0062 -0.0280 -0.1046 -0.1597
1996 9 0.0062 0.0372 0.0348 0.0450
1996 10 0.0063 0.0176 0.0628 -0.0622
1996 11 0.0067 -0.0164 -0.0247 -0.0357
1996 12 0.0069 0.0211 0.0285 0.1270
1997 1 0.0072 0.0661 0.0718 0.1197

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!

Q:

Using the template Excel Index Model posted on Canvas, find out Microsofts alpha, beta, and the fraction of its variance attributed to market risk. find R_M, R_IBM, R_MSFT? SHOW FORMULAS PLEASE. Year...

Q:

sing the template Excel Index Model posted on Canvas, find out Microsofts alpha, beta, and the fraction of its variance attributed to market risk. find R_M, R_IBM, R_MSFT? SHOW FORMULAS PLEASE.

Q:

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

Q:

Scenario: Tom Jones, the CFO for the firm PSUWC Energy, LLC, woke up with a start at 4:00 am on 04/27/2018, due to his phone ringing. It was his senior financial analyst, vacationing in Europe,...

Q:

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

Q:

Data Analysis: Using this template find out Microsoft's Alpha, Beta, and the fraction of its variance attributed to market risk. R_M R_IBM R_MSFT 0.0048 0.0048 0.0049 0.0051 0.0056 0.0056 0.0059...

Q:

Need help with finance investment homework. Deadline is in 15 hours. Thank you. 1 Investments - Finance 460AB Homework #4, Due Friday February 10, 2017 at 6 PM For all assignments: Please place your...

Q:

W AutoSave Case Study Assignment Rev 1 . Saved to this PC v Search X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing Share 12 ~ A" A Aa Ap Find 88 Normal...

Q:

Help needed! I have been really struggling with this project. AutoSave . Off) H Project 1_2020 Fall - Saved to this PC O Search Andrew Warren AW X File Home Insert Draw Design Layout References...

Q:

please provide step by step excel You have been assigned to construct an optimal portfolio comprising two risky assets (Portfolios A \& B) while considering your client's risk tolerance. The attached...

Q:

A company reports the following: Income before income tax .........$4,000,000 Interest expense ............. 5,00,000 Determine the number of times interest charges are earned.

Q:

Draw all the possible noncyclic structural isomers of C5H10. Name each compound.

Q:

What does weak form efficiency imply? Multiple Choice Portfollo diversification is ineffective as all prices are interrelated. Abnormal returns will disappear wetin streding dey. Investons cannot...

Q:

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...