FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show work in Excel using formula's, thanks! 13. (Regression, Sharpe, Jensen's alpha, Treynor for portfolio) Consider the data of another stock-3M Corporation. a. Graph

image text in transcribed Please show work in Excel using formula's, thanks!

13. (Regression, Sharpe, Jensen's alpha, Treynor for portfolio) Consider the data of another stock-3M Corporation. a. Graph the excess returns of 3M against those of the S\&P 500. Use Excel to compute the regression line and the R2. b. Calculate the Sharpe ratio, Jensen's alpha, and Treynor ratio for 3M. c. Does 3M have excess performance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Managerial Finance

Principles Of Managerial Finance

Authors: Chad Zutter, Scott Smart

16th Global Edition

1292400641, 978-1292400648

More Books

Students also viewed these Finance questions

Question

★★★★★
Should non-compete agreements in employment contracts be illegal altogether? Is there equality of bargaining power between the company and the employee? Should non-competes be limited to top officers...

Answered: 1 week ago

Question

★★★★★
What is the form of (a) a 100 (1 ????)% confidence interval for a regression coefficient. (b) the test statistic for testing a regression coefficient is equal to 0? (c) the test statistic for...

Answered: 1 week ago

Question

★★★★★
On March 31, 2014, Kornet Investments paid $4,480,000 for a tract of land and two buildings on it. The plan was to demolish Building 1 and build a new store (Building 3) in its place. Building 2 was...

Answered: 1 week ago

Question

★★★★★
instruction: 1. Make it jurnal 2. Make worksheet 3.Make final statement CUONO COMPANY SPA Trial Balance June 30, 2017 Credit Account Number 101 112 126 130 157 Debit 6,078 5,991 2,085 4,044 14,880...

Answered: 1 week ago

Question

★★★★★
Swifty Company estimates that unit sales will be 10,100 in quarter 1, 12,200 in quarter 2, 14,700 in quarter 3, and 18,600 in quarter 4. Using a sales price of $83 per unit. Prepare the sales budget...

Answered: 1 week ago

Question

★★★★★
Captain Jack Sparrow has been marooned on an island in the Atlantic by his crew, and decides to build a raft to escape. The wind seems quite steady, and first blows him due east for 18 km, and then...

Answered: 1 week ago

Question

★★★★★
Compute the Gross Profit Given; Show your answer as a number only, no Dollar signs, decimals, or commas. Sales Revenues = $180,000 Office Expense = $33,000 Rent Expenses $10,000 Cost of Good...

Answered: 1 week ago

Question

★★★★★
angley has a debt ratio of 0.3 and its competitor, Appleton, has a debt ratio equal to 0.7. Determine the statement below that is correct . Multiple Choice Higher financial leverage involves lower...

Answered: 1 week ago

Question

★★★★★
A potential buyer signs a contract with a seller but then decides not to buy. The seller may sue the potential buyer for specific performance or damages unless the contract was A. a bilateral...

Answered: 1 week ago

Question

★★★★★
Kristin us a distributor of brass picture frames. For 2020, the company plans to purchase for P30 each and sell them for P45 each. The company's fixed costs are expected to be P240,000. Its only...

Answered: 1 week ago

Question

★★★★★
Why do mergers and other affiliations often lead to the consolidation of positions and reduction of the work force?

Answered: 1 week ago

Question

★★★★★
Assuming that a significant number of skilled employees are designated for layoff, how can an organization assist these workers following dismissal? Can an organization protect selected skilled...

Answered: 1 week ago

Question

★★★★★
Should a manager be able to use a reduction-in-force to rid the department of its less effective employees? Why or why not?

Answered: 1 week ago

Previous Question Next Question