Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need correct answer please (excel sheet) Check my work The following is part of the computer output from a regression of monthly returns on

image text in transcribedimage text in transcribed i need correct answer please (excel sheet)

Check my work The following is part of the computer output from a regression of monthly returns on Waterworks stock against the S&P 500 index. A. hedge fund manager believes that Waterworks is underpriced, with an alpha of 2.5% over the coming month. Beta 0.75 R-square 0.65 Standard Deviation of Residuals 0.08 (i.e., 8% monthly) a-1. If he holds a $3 million portfolio of Waterworks stock, and wishes to hedge market exposure for the next month using 1-month maturity S&P 500 futures contracts, how many contracts should he enter? The S&P 500 currently is at 1,000 and the contract multiplier is $250. Number of contracts b. What is the standard deviation of the monthly return of the hedged portfolio? Standard deviation olo c. Assuming that monthly returns are approximately normally distributed, what is the probability that this market-neutral strategy will lose money over the next month? Assume the risk-free rate is 0.3% per month. (Do not round intermediate calculations. Enter your answer as percent rounded to 2 decimal places.) Probability 31.11 % Check my work The following is part of the computer output from a regression of monthly returns on Waterworks stock against the S&P 500 index. A. hedge fund manager believes that Waterworks is underpriced, with an alpha of 2.5% over the coming month. Beta 0.75 R-square 0.65 Standard Deviation of Residuals 0.08 (i.e., 8% monthly) a-1. If he holds a $3 million portfolio of Waterworks stock, and wishes to hedge market exposure for the next month using 1-month maturity S&P 500 futures contracts, how many contracts should he enter? The S&P 500 currently is at 1,000 and the contract multiplier is $250. Number of contracts b. What is the standard deviation of the monthly return of the hedged portfolio? Standard deviation olo c. Assuming that monthly returns are approximately normally distributed, what is the probability that this market-neutral strategy will lose money over the next month? Assume the risk-free rate is 0.3% per month. (Do not round intermediate calculations. Enter your answer as percent rounded to 2 decimal places.) Probability 31.11 %

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

The Meaningful Money Handbook

Authors: Pete Matthew

1st Edition

0857196510, 978-0857196514

More Books

Students also viewed these Finance questions

Question

What is the formula to calculate the mth Fibonacci number?

Answered: 1 week ago

Question

Analyse the various techniques of training and learning.

Answered: 1 week ago