You want to create a portfolio equally as risky as the market, and you have $1,000,000...

Question

Question

You want to create a portfolio equally as risky as the market, and you have $1,000,000 to invest. Given this information, fill in the rest of the following table:

Asset Investment Beta StockA .80 $185,000 $320,000 1.13 Stock B Stock C Risk-free asset 1.29

Please answer using excel

Portfolio beta Total investment Investment Beta Asset Stock A Stock B Stock C Risk-free asset Output area: Investment Beta As

business finance

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Formula used in cell B12: =((1-((B10/B14)*C10)+((B11/B14)*C11))/C12)*B14

Formula used in cell B13: =B14-B12+B11+B10

Add a comment

Answer 2

Similar Homework Help Questions

You want to create a portfolio equally as risky as the market, and you have $1,000,000...

You want to create a portfolio equally as risky as the market, and you have $1,000,000 to invest. Given this information, fill in the rest of the following table: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) You want to create a portfolio equally as risky as the market, and you have $1,000,000 to invest. Given this information, fill in the rest of the following table: (Do not round intermediate calculations and round...
Problem 13-24 Analyzing a Portfolio (LO2] You want to create a portfolio equally as risky as...

Problem 13-24 Analyzing a Portfolio (LO2] You want to create a portfolio equally as risky as the market, and you have $1,000,000 to invest. Given this information, fill in the rest of the following table: (Do not round intermediate calculations. Round your answers to the nearest whole number, e.g., 32.) Asset Stock A Stock B Stock C Risk-free asset Investment $ 195,000 $ 340,000 Beta .90 1.15 1.29
You want to create a portfolio equally as risky as the market, and you have $1,000,000...

You want to create a portfolio equally as risky as the market, and you have $1,000,000 to Invest. Consider the following information: Investment $200,000 $250,000 Beta 0.70 1.25 1.55 Asset Stock A Stock E Stock C Risk-free asset Required (a) What is the Investment In Stock C? (Do not round your Intermediate calculatlons.) o select) v (b) What is the Investment In risk-free asset? (Do not round your Intermedlate calculatlons.) o select)

You want to create a portfolio equally as risky as the market and you have $1,300,000...

You want to create a portfolio equally as risky as the market and you have $1,300,000 to invest. Given this information, fill in the rest of the following table: Shows all the step and formula. Don't round off until you get the answer. Asset Investment Beta Stock A 184000 0.81 Stock B 437000 1.22 Stock C 1.65 Risk-free asset
You want to create a portfolio equally as risky as the market, and you have $2,600,000...

You want to create a portfolio equally as risky as the market, and you have $2,600,000 to invest. Given this information, fill in the rest of the following table: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Asset Investment Beta Stock A $494,000 1.40 Stock B $936,000 1.50 Stock C 1.60 Risk-free asset
You want to create a portfolio equally as risky as the market, and you have $1,600,000...

You want to create a portfolio equally as risky as the market, and you have $1,600,000 to invest. Given this information, fill in the rest of the following table: (Leave no cells blank - be certain to enter "O" wherever required. Do not round intermediate calculations.) Asset Beta Stock A $ $ Investment 288,000 512,000 Stock B 0.80 1.00 1.25 Stock C Risk-free asset

You want to create a portfolio equally as risky as the market, and you have $2,600,000...

You want to create a portfolio equally as risky as the market, and you have $2,600,000 to invest. Given this information, fill in the rest of the following table: (Do not round Intermedlate calculations and round your answers to the nearest whole number, e.g., 32) Asset Investment Beta Stock A 404,000 1.40 936,000 Stock B 1.50 Stock C 1.80 Risk-free asset
You want to create a portfolio equally as risky as the market, and you have $1,800,000...

You want to create a portfolio equally as risky as the market, and you have $1,800,000 to invest. Given this information, fill in the rest of the following table: (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations.) asset investment beta stock A $396,000 1.20 stock B $504,000 1.40 stock C 1.60 risk free asset
You want to create a portfolio equally as risky as the market, and you have $1,300,000...

You want to create a portfolio equally as risky as the market, and you have $1,300,000 to invest. Given this information, fill in the rest of the following table: (Do not round intermediate calculations. Round your answers to the nearest whole number, e.g., 32.) Asset Investment Beta Stock A $ 156,000 1.30 Stock B $ 247,000 1.60 Stock C $ 1.60 Risk-free asset $

You want to create a portfolio equally as risky as the market, and you have $1,600,000...

You want to create a portfolio equally as risky as the market, and you have $1,600,000 to invest. Consider the following information: Asset/ Investment /Beta Stock A/ $560,000 / 0.75 Stock B/ $320,000/ 1.20 Stock C/. / 1.50 Risk-free asset Required: (a) What is the investment in Stock C? (Do not round your intermediate calculations.) ans: $404,445 / $530,667 / $551,894 / $504,134 / $509,440 (b) What is the investment in risk-free asset? (Do not round your intermediate calculations.) ans:...

You want to create a portfolio equally as risky as the market, and you have $1,000,000...

Homework Answers

Add Answer to:
You want to create a portfolio equally as risky as the market, and you have $1,000,000...

Post as a guest

Earn Coins