Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show work through excel 1. Asset Allocation Your client is considering three mutual funds: a stock fund, a real estate fund and a T-bill

Please show work through excel

image text in transcribedimage text in transcribed

1. Asset Allocation Your client is considering three mutual funds: a stock fund, a real estate fund and a T-bill money market fund. The sure return of the T-bill fund is 6%. The expected return and standard deviation for the stock fund and the real estate fund are given in the following table. The correlation between the stock fund and the real estate fund returns is 0.2 (i.e., p=0.2) Risky Assets Stock Fund (S) Real Estate Fund (R) Expected Return 15% 10% Standard Deviation 20% 15% (3) A portfolio that invests 60% in the stock fund and 40% in the real estate fund is the optimal risky portfolio. Compute the expected return and risk (standard deviation) of this portfolio. Show why your client should be interested in the optimal risky portfolio as compared to an investment in the stock fund alone. 1. Asset Allocation Your client is considering three mutual funds: a stock fund, a real estate fund and a T-bill money market fund. The sure return of the T-bill fund is 6%. The expected return and standard deviation for the stock fund and the real estate fund are given in the following table. The correlation between the stock fund and the real estate fund returns is 0.2 (i.e., p=0.2) Risky Assets Stock Fund (S) Real Estate Fund (R) Expected Return 15% 10% Standard Deviation 20% 15% (3) A portfolio that invests 60% in the stock fund and 40% in the real estate fund is the optimal risky portfolio. Compute the expected return and risk (standard deviation) of this portfolio. Show why your client should be interested in the optimal risky portfolio as compared to an investment in the stock fund alone

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

Mergers Acquisitions And Other Restructuring Activities

Authors: Donald DePamphilis

11th Edition

012819782X, 978-0128197820

More Books

Students also viewed these Finance questions

Question

Are there any disadvantages to this tactic?

Answered: 1 week ago

Question

Who is the assigned manager for each tactic?

Answered: 1 week ago