Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need this answered on excel ASAP QUESTION 24 Problem 4 (15 points): You are considering investing $1,000 in a complete portfolio The complete portfolio

i need this answered on excel ASAP image text in transcribed
QUESTION 24 Problem 4 (15 points): You are considering investing $1,000 in a complete portfolio The complete portfolio is composed of treasury bills that pay 5% and a risky portfolio, P (which is constructed with 2 risky securities X and Y). The optimal weights of X and Y in Pare 60% and 40% respectively. X has an expected rate of return of 14% and Y has an expected rate of return of 10% a. To form a complete portfolio with an expected rate of return of 11%, you should invest % of your complete portfolio in treasury bills b. To form a complete portfolio with an expected rate of return of 8%, you should invest approximately % in the risky portfolio. This will mcan you will also invest approximately % and _% of your complete portfolio in security X and Y respectively c. If you decide to hold 30% of your complete portfolio in the risky portfolio and 70% in the treasury bills then the dollar values of your positions in X and Y respectively would be $ and $

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 Applications And Theory

Authors: Marcia Cornett, Troy Adair, John Nofsinger

1st Edition

0073382256, 9780073382258

More Books

Students also viewed these Finance questions