172b number 6 b

172b number 6 b - PORTFOLIO OPTIMIZATION Input data in Blue...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Input data in Blue cells only. ONE PLUS INPUTS EXPECTED STANDARD EXP RATE RETURN DEVIATION {1+E®} Riskless Rate ® 5.00% 0.00% 105.00% SPX 14.72% 15.49% 114.72% Sml-Cap 15.25% 20.75% 115.25% Value 14.55% 16.23% 114.55% Growth 14.31% 20.52% 114.31% Eafe 13.97% 25.50% 113.97% Emrg 13.92% 31.80% 113.92% CORRELATIONS SPX SML-CAP Value Growth 100.00% 58.00% 93.00% 96.00% IA Small Stock 58.00% 100.00% 72.00% 54.00% IA All Value 93.00% 72.00% 100.00% 82.00% IA All Growth 96.00% 54.00% 82.00% 100.00% MSCI EAFE 56.00% 34.00% 55.00% 52.00% 32.00% 52.00% 39.00% 31.00% STANDARD DEVIATION RISKY ASSETS 1 2 3 4 15.49% 20.75% 16.23% 20.52% 1 2 3 4 1 2.40% 1.86% 2.34% 3.05% 2 1.86% 4.31% 2.42% 2.30% 3 2.34% 2.42% 2.63% 2.73% 4 3.05% 2.30% 2.73% 4.21% 5 2.21% 1.80% 2.28% 2.72% 6 1.58% 3.43% 2.01% 2.02% A 128.73 B 149.67 C 174.03 DELTA 2.66 GAMMA 0.07 INDEX RISKY ASSET 1 15.49% RISKY ASSET 2 20.75% RISKY ASSET 3 16.23% EFFICIENT
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

172b number 6 b - PORTFOLIO OPTIMIZATION Input data in Blue...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online