Home Paste B78 44 Insert Page Layout Formulas Data Review View Calibri (Body) 11 A A B I U B fx I am willing to take on more risk since I am young. C D E F CAL 0% Share Wrap Text General Merge & Center $ % 9 .00 0 Conditional Format Cell Formatting as Table Styles Insert Delete Format Sort & Filter Find & Select Sensitivity G H | J K L SPY VNQ 1 0 (SPY) *STD)^2 (VNQ*STD)^2 0.00203401 2*(Spy*STD)*(VNQ*STD)*Correlation 1.80% 1.60% 0 0 0.9 0.1 0.001647548 0.8 0.7 0.2 0.001301766 0.3 0.000996665 2.35225E-05 0.00009409 0.000211703 0.00030539 1.40% 0.000542916 1.20% 0.000712578 0.6 0.4 0.000732244 0.00037636 0.000814375 0.5 0.5 0.000508503 0.000588063 0.000848307 0.4 0.6 0.000325442 0.00084681 0.000814375 Mean Returns 1.00% 0.809 0.3 0.7 0.000183061 0.001152603 0.000712578 0.60% 0.2 0.1 0.8 8.13604E-05 0.9 0.00150544 0.000542916 2.03401E-05 0 1 0 0.001905323 0.00235225 0.00030539 0.40% 0 0.20% 45 46 47 Tresury Bill 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 Optimal Risky Portfolio mix 64 Risk-Free Rate 65 66 Numerator Denomentator 0.07% 1.00E-05 1.13E-05 67 68 Spy VNQ 72.33% 24.23% 69 70 71 72 73 74 75 76 77 78 I am willing to take on more risk since I am young] 79 80 81 82 83 84 85 86 87 SPY and VNQ Sheet1 + Ready Rf 0.07% rho 0.7756 E(R) VNQ 0.59% E(R) SPY 1.53% Var SPY 0.20% Spy VNQ Var VNQ 0.24% 72.33% 24.23% st dev SPY 4.51% st dev VNQ 4.85% Excess SPY 1.46% Excess VNQ 0.52% M N Efficent Frontier Curve P 0.00% 4.30% 4.40% 4.50% 4.60% 4.70% 4.80% Standard Deviation A + 99%