Question: What are the excel functions for the orange cells? Benchmark Weekly Return Portfolio Value SCL Predicted 3.73% $ $ $ $ Portfolio Weekly Benchmark Value
What are the excel functions for the orange cells?



Benchmark Weekly Return Portfolio Value SCL Predicted 3.73% $ $ $ $ Portfolio Weekly Benchmark Value Return (S&P) 500 3,225.52 1.10% 3,345.78 0.45% 3,373.94 0.97% 3,373.23 - 10.23% 2,978.76 0.07% $ 3,023.94 -16.30% $ 2,480.64 -0.62% $ 2,409.39 6.75% $ 2,630.07 -2.87% $ 2,526.90 8.22% $ 2,811.64 1,000,000.00 1,011,035.98 1,015,599.25 1,025,449.41 920,520.04 921,155.22 770,999.93 766,217.63 817,966.91 794,481.46 859,777.93 $ 0.84% -0.02% -11.69% 1.52% -17.97% -2.87% 9.16% -3.92% 11.27% 2.76% 0.36% -0.36% -10.05% 0.92% -15.25% -2.72% 7.26% -3.60% 9.02% $ $ $ Performance Measures Portfolio Weekly Benchmark Weekly Yrly Yrly 0.00% 0.00% 0.00% 0.00% Risk Free Rate Expected Return (Arith) Standard Deviation Sharpe Ratio M-Square Beta Alpha Specific Risk (Std Dev) Treynor Index Information Ratio 0.830 -0.003 0.013 0.830 -0.176 0.093 beta alpha 0.830174688 -0.003390872 0.055619022 0.004480278 0.969537171 0.012851573 222.7882469 Benchmark Weekly Return Portfolio Value SCL Predicted 3.73% $ $ $ $ Portfolio Weekly Benchmark Value Return (S&P) 500 3,225.52 1.10% 3,345.78 0.45% 3,373.94 0.97% 3,373.23 - 10.23% 2,978.76 0.07% $ 3,023.94 -16.30% $ 2,480.64 -0.62% $ 2,409.39 6.75% $ 2,630.07 -2.87% $ 2,526.90 8.22% $ 2,811.64 1,000,000.00 1,011,035.98 1,015,599.25 1,025,449.41 920,520.04 921,155.22 770,999.93 766,217.63 817,966.91 794,481.46 859,777.93 $ 0.84% -0.02% -11.69% 1.52% -17.97% -2.87% 9.16% -3.92% 11.27% 2.76% 0.36% -0.36% -10.05% 0.92% -15.25% -2.72% 7.26% -3.60% 9.02% $ $ $ Performance Measures Portfolio Weekly Benchmark Weekly Yrly Yrly 0.00% 0.00% 0.00% 0.00% Risk Free Rate Expected Return (Arith) Standard Deviation Sharpe Ratio M-Square Beta Alpha Specific Risk (Std Dev) Treynor Index Information Ratio 0.830 -0.003 0.013 0.830 -0.176 0.093 beta alpha 0.830174688 -0.003390872 0.055619022 0.004480278 0.969537171 0.012851573 222.7882469
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
