Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Month Asset A returns Asset B returns Asset C returns 1 -4.0% 11.0% 15.5% 2 1.5% 6.0% 14.5% 3 -1.5% -7.0% -9.5% 4 7.0% 7.5%

Month Asset A returns Asset B returns Asset C returns
1 -4.0% 11.0% 15.5%
2 1.5% 6.0% 14.5%
3 -1.5% -7.0% -9.5%
4 7.0% 7.5% 12.5%
5 2.0% -3.5% 22.5%
6 6.5% -6.5% -11.0%
7 -2.5% 13.5% 19.0%
8 3.5% 9.0% 20.0%
9 4.5% 9.0% -24.0%
10 1.5% 11.5% 13.0%
11 -4.5% -4.5% 17.0%
12 5.0% -2.5% -15.5%

1) In Excel, calculate the expected standard deviation of a portfolio consisting of 25% asset A, 50% asset B, and 25% asset C. (DO NOT Use of the Excel stdev or related function )

2) Given a risk free rate of 3.5% and a market portfolio with a return of 9% and s of 15%, what combination of assets would a risk averse investor hold if he wanted to maximize returns but have no more than 8% volatility?

3) Given a risk free rate of 3% and a market portfolio with a return of 8% and s of 13%, what combination of assets would a less risk averse investor hold if she wanted to maximize returns but have no more than 15% volatility?

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

Finance Theory And Practice

Authors: Anne Marie Ward

3rd Edition

1908199482, 978-1908199485

More Books

Students also viewed these Finance questions