Answers
1 stock fund 2 expected return 3 standard deviation 4 variance 5 correlation 6 covariance 7 T-bill rate bond fund 0.14 0.07 0.43 0.37 0.1849 0.1369 0.0459 0.00730269 0.053 8 portfolio stock fund 9 a) 10 expected return 11 12 weights in portfolio 13 variance of portfolio 14 expected return of portfolio 15 standard deviation of portfolio 0.12 bond fund 0.7143 0.2857 0.108492935 0.1200 32.94% 16 stock fund stock fund 17 18 optimal risky portfolio 19 excess return 20 21 Portfolio weights 22 expected return 23 variance 24 standard deviation Bond fund 0.087 0.017 Bond fund 0.8245 0.1755 0.1277 0.1320 0.3634 25 optimal risky portfolio T-bill 0.896702621 0.10329738 26 27 % invested 28 b-1 29 % invested in T-bill 30 b-2 31 32 % invested 10.33% stock fund Bond fund 15.73% 73.94% 22
1 stock fund 0.14 0.43 =B3*B3 0.0459 =B5*B3*C3 0.053 bond fund 0.07 0.37 =C3*C3 2 expected return 3 standard deviation 4 variance 5 correlation 6 covariance 7 T-bill rate portfolio 0.12 stock fund =(B10-C2)/(B2-C2) =(B12*B12* B4)+(C12*C12* C4)+(2*B12*C12*B6) =(B12*B2)+(C12*C2) =SQRT(B13) bond fund =1-B12 15 9 a) 10 expected return 11 12 weights in portfolio 13 variance of portfolio 14 expected return of portfolio standard deviation of portfolio 16 17 18 optimal risky portfolio 19 excess return 20 21 Portfolio weights 22 expected return 23 variance 24 standard deviation 25 stock fund =B2-$B$ 7 stock fund =((B19*C4)-(C19*B6)/((B19*C4)+(C19*B4)-((B19+C19)* B6)) =(B21*B2)+(C21*C2) =(B21*B21*B4)+(C21*C21*C4)+(2*B21*C21*B6) =SQRT(B23) Bond fund =C2-$B$7 Bond fund =1-B21 26 optimal risky portfolio = (B10-B7)/(B22-B7) T-bill =1-B27 27 % invested 28 b-1 29 % invested in T-bill 30 b-2 =C27 31 stock fund =$B$27*B21 Bond fund =$B$27*C21 32 % invested 33
.
Similar Solved Questions
1 answer
2.1 What are the equilibrium price and quantity of Frisbees? quantity suppled quantity demanded. Equilibrium Price:dollars...
2.1 What are the equilibrium price and quantity of Frisbees? quantity suppled quantity demanded. Equilibrium Price:dollars Equ ilibrium Quantity:million 2.2 Frisbee manufactures persuade the government that Frisbe production amproves scientists understanding of aerodynamics and thus is important for...
1 answer
Problem 2 The Shaw Restaurant's balance sheets for 20x4 and 20x5 reveal the following amounts for...
Problem 2 The Shaw Restaurant's balance sheets for 20x4 and 20x5 reveal the following amounts for its current accounts: 2014 2015 Current Assets: Cash $ 510 $ 751) Accounts Recenable 12,400 14.612 Food Inventory 0,211 l'repaid Insurance 3422 1158 Total $22,573 $25,501 Current Liabilities: Ac...
1 answer
Simon Company's year-end balance sheets follow. Current Yr 1 Yr Ago 2 Yrs Ago At December...
Simon Company's year-end balance sheets follow. Current Yr 1 Yr Ago 2 Yrs Ago At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant as...
1 answer
1) Plot base current of a npn transistor versus base-emitter voltage 2) Plot Gate current of...
1) Plot base current of a npn transistor versus base-emitter voltage 2) Plot Gate current of a MOSFET transistor versus gate-source voltage...
1 answer
What is the F value associated with α = 0.05, numerator degrees of freedom (df1) equal...
What is the F value associated with α = 0.05, numerator degrees of freedom (df1) equal to 4, and denominator degrees of freedom (df2) equal to 8? a. 3.63 b. 6 c. 3.84 d. 0.6...
1 answer
How do you simplify #\frac { \sqrt { 72x ^ { 3} } } { \sqrt { 9x ^ { - 5} } }#?
How do you simplify #\frac { \sqrt { 72x ^ { 3} } } { \sqrt { 9x ^ { - 5} } }#?...
1 answer
3. Your economics professor is analyzing exam grades to determine whether her exams are too hard...
3. Your economics professor is analyzing exam grades to determine whether her exams are too hard are too ha or too easy. The stem-and-leaf plot below was made of the final exam grades of students in all of her courses. Answer the following questions about the data. the folowing questonya s made of t...
1 answer
Please help with steps thanks Select 'True False' or 'Cannot tell' for the following statements. True:...
please help with steps thanks Select 'True False' or 'Cannot tell' for the following statements. True: The current through the inductor always equals the current A charging/discharging the capacitor. True: Energy is dissipated in the resistor but not in either the capacitor or the i...
1 answer
Table 7-12 ne numbers reveal the opportunity costs of providing 10 piano lessons of equal quality,...
Table 7-12 ne numbers reveal the opportunity costs of providing 10 piano lessons of equal quality, Cost Seller Marcia $200 Jan $250 Cindy $350 Greg $400 Peter 5700 Bobby $800 Refer to Table 7-12. The equilibrium market price for 10 piano lessons is $300. What is the total producer surplus in the mar...
1 answer
[The following information applies to the questions displayed below.) Church Company completes these transactions and events...
[The following information applies to the questions displayed below.) Church Company completes these transactions and events during March of the current year (terms for all its credit sales are 2/10, n/30). Mar. 1 Purchased $37,000 of merchandise from Van Industries, invoice dated March 1, terms 2/1...
1 answer
4) If a mutation causes insertion of three nucleotide pairs, the following statement is true: A)Group...
4) If a mutation causes insertion of three nucleotide pairs, the following statement is true: A)Group of answer choices B) The mRNA transcript will be longer C) No transcription will occur D) No translation will occur E) The cell won’t be able to replicate its DNA...
1 answer
Anyone involved with American health care probably knows that our spending is out of control. We...
Anyone involved with American health care probably knows that our spending is out of control. We experience far greater medical spending than any other nation. Just how much do we spend on health care in America, and what are we spending all of that money on? Provide specific examples of the types o...
1 answer
7.47 M Express your answer using three significant figures View Awailable Hint(s) 362 Nm released from...
7.47 M Express your answer using three significant figures View Awailable Hint(s) 362 Nm released from rest? Rotation 17 cm rad 25°...
1 answer
Inventory system and the gross method. Oct. i Sold fair trade merchandise for $3,400, with credit...
inventory system and the gross method. Oct. i Sold fair trade merchandise for $3,400, with credit terms n/30, invoice dated October 1. The cost of the merchandise is $1,850. 6 The customer in the October 1 sale returned $340 of fair trade merchandise for full credit. The merchandise, which had cost ...
1 answer
3) Two long, straight carrying current wires are at 10 cm distance from each other, as...
3) Two long, straight carrying current wires are at 10 cm distance from each other, as shown in the figure. The arrows show the direction of the currents in the wires. 11 = 10 A PRo 12 = 20 A Find the magnitude of the magnetic field B1 and its direction due to 11 at point P at 2 cm from the current ...
1 answer
&8.3.10 that their scores improved the second time they took the test? Assume the samples are...
&8.3.10 that their scores improved the second time they took the test? Assume the samples are random and dependent and the population is normally distributed. Complete Score on first test 431357 433 468 591 522 572 556 523 563 411 568 562 Question Help The table below shows the critical reading ...
1 answer
The amounts of time per workout an athlete uses a stairclimber are normally distributed, with a...
The amounts of time per workout an athlete uses a stairclimber are normally distributed, with a mean of 21 minutes and a standard deviation of 7 minutes. Find the probability that a randomly selected athlete uses a stairclimber for (a) less than 16 minutes, (b) between 21 and 28 minutes, and (c) mor...