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

Question

Question

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

business finance

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

ALL MATHEMATICAL CALCULATIONS WITH FORMULA

NO EXCEL FUNCTION IS USED. JUST WRITTEN IN EXCEL.

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,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,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...
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: Please answer using excel Asset Investment Beta StockA .80 $185,000 $320,000 1.13 Stock B Stock C Risk-free asset 1.29 Portfolio beta Total investment Investment Beta Asset Stock A Stock B Stock C Risk-free asset Output area: Investment Beta Asset Stock A Stock B Stock C Risk-free asset

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 calcul...

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 $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 $500,000...

You want to create a portfolio equally as risky as the market, and you have $500,000 to invest Information about the possible investments is given below: Asset Investment Beta $142.000 $138,000 Stock A 87 Stock B Stock C 1.32 1.47 Risk-free asset How much will you invest in Stock C? How much will you invest in the risk-free asset? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Investment in Stock C Investment in...

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

You want to create a portfolio equally as risky as the market, and you have $500,000 to invest. Information about the possible investments is given below: Beta 76 Asset Investment Stock A $ 131,000 Stock B $149,000 Stock C Risk-free asset 1.21 1.36 How much will you invest in Stock C? How much will you invest in the risk-free asset? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Investment in Stock C Investment...

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

Homework Answers

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

Post as a guest

Earn Coins

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,000,000...

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,300,000 to invest. Given this information, fill in the rest of the following table: (Do not round intermediate calcul...

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 $1,600,000...

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 $1,800,000...

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

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

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

Homework Answers

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

Post as a guest

Earn Coins

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