a. Calculate the expected IRR of the project. b. Calculate the standard deviation of the project. c. Calculate the coefficient of variation. d. Calculate the expected IRR of the new portfolio with the new project. The current portfolio has an expected IRR of 9% and a standard deviation of 3% and will represent 60% of the total portfolio. Please show in excel

Transcribed Image Text:

E30 A Possible IRR Value fx Expected IRR of New Project Standard Deviation of New Project CV of New Project Expected IRR (Current Portfolio) Standard Deviation Current Project New Project Expected IRR Combined Portfolio Probability c. Calculate the coefficient of variation. 0.00% 0.00% #DIV/0! 0.00% a. Calculate the expected IRR of the project. b. Calculate the standard deviation of the project. C You have estimated the IRR for a new project with the following probabilities: Possible IRR Value 7% 10% 11% d. Calculate the expected IRR of the new portfolio with the new project. The current portfolio has an expected IRR of 9% and a standard deviation of 3% and will represent 60% of the total portfolio. Probability 5% 15% 15% 50% E30 A Possible IRR Value fx Expected IRR of New Project Standard Deviation of New Project CV of New Project Expected IRR (Current Portfolio) Standard Deviation Current Project New Project Expected IRR Combined Portfolio Probability c. Calculate the coefficient of variation. 0.00% 0.00% #DIV/0! 0.00% a. Calculate the expected IRR of the project. b. Calculate the standard deviation of the project. C You have estimated the IRR for a new project with the following probabilities: Possible IRR Value 7% 10% 11% d. Calculate the expected IRR of the new portfolio with the new project. The current portfolio has an expected IRR of 9% and a standard deviation of 3% and will represent 60% of the total portfolio. Probability 5% 15% 15% 50%

Answer rating: 100% (QA)

Answer Explanation aThe expected IRR of the project Expected IRR of the project PossibleIRRProbabili... View the full answer