Home Paste H49 9 A Insert Page Layout Formulas Data Review View Calibri (Body) 11 ' ' B I U B fx CAL 0% Share Wrap Text General Merge & Center $ %9 .00 0 Conditional Format Formatting as Table Cell Styles Insert Delete Format Sort & Filter Find & Select Sensitivity D E F G H J K L M N P Q 10 Effienct Frontier: 11 12 VNQ SPY E(VNQ,SPY) SD(VNQ,Spy) 13 0% 100% 1.53% 4.51% 14 5.00% 95% 1.50% 4.47% Efficent Frontier Curve 15 10.00% 90% 1.47% 4.44% 1.80% 16 15.00% 85% 1.45% 4.42% 17 20% 80% 1.42% 4.40% 1.60% 18 25% 75% 1.39% 4.39% 1.40% 19 30% 70% 1.36% 4.38% 1.20% 20 35% 65% 1.33% 4.38% 21 40% 60% 1.30% 4.38% 22 45% 55% 1.27% 4.39% 23 50% 50% 1.24% 4.41% Mean Returns 1.00% 0.80% 24 55% 45% 1.21% 4.43% 0.60% 25 60% 40% 1.18% 4.46% 0.40% 26 65% 35% 1.15% 4.49% 0.20% 27 70% 30% 1.12% 4.52% 28 75% 25% 1.09% 4.57% 0.00% 4.30% 4.40% 4.50% 4.60% 4.70% 4.80% 4.90% 29 80% 20% 1.06% 4.61% Standard Deviation 30 85% 15% 1.04% 4.67% 31 90% 10% 1.01% 4.72% 32 95% 5% 0.98% 4.78% 33 100% 0% 0.95% 4.85% 34 35 36 37 38 39 40 VNQ SPY Mean STDEV 0.95% 4.85% 1.53% 4.51% SPY VNQ Correalation Coffeation SPY VNQ 1 0.7756475 SPY 1 VNQ Covariance SPY VNQ 0.0023134 0.0016679 0.0019987 41 42 43 44 45 46 47 Tresury Bill SPY VNQ 48 1 0 (SPY) *STD)^2 (VNQ*STD)^2 0.00203401 2*(Spy*STD)*(VNQ*STD) *Correlation 0 49 0.9 0.1 0.001647548 50 0.8 0.2 0.001301766 2.35225E-05 0.00009409 0 0.00030539 0.000542916 51 0.7 0.3 0.000996665 0.000211703 0.000712578 SPY and VNQ Sheet1 + Ready A + 99% Home Paste H49 35 Insert Page Layout Formulas Data Review View Calibri (Body) 11 ' ' B I U A B fx Wrap Text Merge & Center D E F G 36 37 38 39 40 VNQ SPY Mean STDEV 0.95% 4.85% 1.53% 4.51% 41 42 43 44 45 46 47 Tresury Bill SPY VNQ (SPY) *STD)^2 (VNQ*STD)^2 2*(Spy*STD)*(VNQ*STD)*Correlation 48 1 0 0.00203401 0 0 49 0.9 0.1 0.001647548 50 0.8 0.2 0.001301766 51 0.7 0.3 0.000996665 2.35225E-05 0.00009409 0.000211703 0.00030539 0.000542916 0.000712578 52 0.6 0.4 0.000732244 0.00037636 0.000814375 53 0.5 0.5 0.000508503 0.000588063 0.000848307 54 0.4 0.6 0.000325442 0.00084681 0.000814375 55 0.3 0.7 0.000183061 0.001152603 0.000712578 56 0.2 0.8 8.13604E-05 0.00150544 0.000542916 57 0.1 0.9 2.03401E-05 0.001905323 0.00030539 58 0 1 0 0.00235225 0 59 60 61 62 63 Optimal Risky Portfolio mix 64 Risk-Free Rate 65 66 Numerator Denomentator 67 68 Spy VNQ 72.33% 69 70 71 72 Complete Breakdown 73 SPY VNQ Expected Return Standard Deviation 72.33% 74 75 76 77 78 SPY and VNQ Sheet1 Ready + CAL General $ % 0% Share .00 Conditional 0