In-class Excel Activity

Calculate summary statistics for Microsoft:

·       Arithmetic and geometric average return.

·       Range, standard deviation.

·       5%, 2.5% and 0.5% VAR

Estimate today’s expected return for Microsoft according to the Capital Asset Pricing Model:

·       Plot security characteristic line.

·       Run regression of Microsoft excess returns on market excess returns: identify alpha, beta, systematic risk, idiosyncratic risk, “goodness of fit” measure (R 2) and standard deviation of the model residuals.

·       Calculate the Treynor Information Ratio.

·       Write-out the model’s CAPM equation and determine the expected return for today. According to the model, is MSFT over or undervalued? What would be your recommendation for a potential investor?

Estimate today’s expected return for Microsoft according to the Fama- French Three Factor Model

·       Run regression of Microsoft excess returns on market excess returns: identify alpha, beta, factor loads (i.e. coefficients for SMB and HML factors), systematic risk, idiosyncratic risk, “goodness of fit” measure (R 2) and standard deviation of the model residuals. Compare these results for those you obtained for the CAPM.

·       Calculate the Treynor Information Ratio.

·       Write-out the model’s equation and determine the expected return for today. According to the model, is MSFT over or undervalued? What would be your recommendation for a potential investor?

Estimate the Security Market Line for Google According to the Fama-French Five Factor Model

·       Run regression of Microsoft excess returns on market excess returns: identify alpha, beta, factor loads, systematic risk, idiosyncratic risk, “goodness of fit” measure (R 2) and standard deviation of the model residuals. Compare these results for those you obtained for the CAPM and the Fama-French three factor model.

·       Calculate the Treynor Information Ratio.

·       Write-out the model’s equation and determine the expected return for today. According to the model, is MSFT over or undervalued? What would be your recommendation for a potential investor?

## 1. What are blockchain's potential applicati...

1. What are blockchain's potential applications in organizational functions such as human resource management, accounting, and supply...

## Accidentes gramaticales...

DEFINICIN Y ACCIDENTES GRAMATICALES DEL VERBO Observa la siguiente situacin:Podemos definir el verbo teniendo en cuenta diferentescriterios de estudi...

## Discuss one personal strength and one weakness you...

Discuss one personal strength and one weakness you have regarding professional presentations. Name one method for improvement for each of these,...

## International Marketing...

Please provide an outline of a research projectTitle of the project (up to 25 words)A brief statement of the problem th...

## ECDB7...

Today we see a lot of activity within the international trade arena as the U.S. trade deficit has soared to a record high.Trade is desi...

## Business Finance : Saudi Mod 2 Operation Manageme...

Operations Management and Factors Affecting Productivity (100 points) Maduro Cleaning is a small organization that provides cleanin...

## Research Decisions...

Complete the following exercises:Chapter 12 – Discussion Questions (Making Research Decisions) # 5 ...

## DB VII...

Q1-After reviewing the reading regarding the investigations of fire deaths and injuries, discuss what you feel are the biggest challenges to invest...

## music and gender paper...

hi i need help writing a paper 250-500 words the topic is about gender and music ...

## Math help needed...

...

### Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
\$65
Order a paper. Study better. Sleep tight. Calculate Price!
Calculate Price
Approx. price
\$65