Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how do you write the variance of a two-asset portfolio in excel (CELLS C58 and E58) Estimated one-year return distributions: State ofthe Econom poor Below
how do you write the variance of a two-asset portfolio in excel (CELLS C58 and E58)
Estimated one-year return distributions: State ofthe Econom poor Below average Average Above average 2 Excellent Probabili 4 Historical return distributions: 8 Yearl s Year 2 o Year 3 Year 4 2 Year 5 Stand-alone return and risk' Expected return Variance (Var) s Standard deviation (SD) Coefficient of variation (CV) Portfolio return and risk: I-Year T-8iII I-Year T-8iII I-Year T-Bill 0.0% HealthcarE Fund Healthcarf Fund HealthcarE Fund 135% 117% 86 Inverse ETF 18% Inverse ETF Inverse 083% 1033% Pontolio Biotech Fund 13% 31% Biotech Fund 13% 31% Biotech Fund 145% 336% 183% 1264% 500 -15% 15% 500 -15% 45% 15 164% log a State of the Econom poor Below average Average Above average 2 Excellent Expected return 8 Variance O/ar) s Standard deviation (SD) Pontolio Healthcare Fund/ Inverse ETF 125% 105% 11 175% P oftfolio Healthcare Fund/ Inverse ETF 11 2% Healthcare Fund/ Biotech Fund -135% 135% 28 41 P oftfolio Healthcare Fund / Biotech Fund 14.0% o Coefficient of variation (CV) Correlation coefficient Market characteristic lines.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started