Question #1 As a newly appointed long/short portfolio manager with 1MM AUM in cash, you are presented with a list of 8 stocks that your analysts are recommending that you take a position in. Six stocks (MSFT, CAT, UNH, UPS, VZ and MRK) are recommended as long investments and two (F, INTC) as short investments with net weights and current prices shown in Table 2. The portfolio can trade on a margin requirement of 50% meaning, with 1MM USD equity, you can borrow and/or short sell up to an additional 2MM USD for a gross account value of 3MM USD. There is no need to log transform returns in this problem and there are no costs to borrow. Table 1. Asset Returns Date 3/31/2024 MSFT VZ 3/30/2024 3/29/2024 3/28/2024 1 Assuming you maximize the gross account value and invest at the net weights given, calculate the gross weights, dollar value, and number of shares invested in each position. (3pts) Gross ($): $ 3,000,000 Table 2. Asset Net Weights and Prices MSFT Net Weight 38% CAT 35% UNH 15% UPS VZ MRK -47% 23% -47% F 35% INTC 47% Current Price $ Gross Weight 308.31 $ 13% 222.82 $ 12% 509.97 5% S 49.56 $ 16% 214.46 $ 8% 50.33 $ 82.05 $ 16.91 Dollar Value $399,768.25 $365,005.79 $156,431.05 $490,150.64 $243,337.20 16% $490,150.64 Shares 1297 1638 307 9890 1135 9739 12% $365,005.79 4449 16% $490,150.64 28986 57440 3/25/2024 3/24/2024 3/23/2024 3/22/2024 3/21/2024 3/18/2024 100% 3/17/2024 288% 3/16/2024 3/15/2024 3/14/2024 3/11/2024 3/10/2024 2) Based on the dollar values invested long or short in each position, calculate the net dollar amount invested in the portfolio. (2pts) 3/9/2024 3/8/2024 Net ($): $ 1,039,397 3/7/2024 3) Using the historical returns provided in Table 1, calculate the 1-year trailing, annualized beta and alpha for each stock using SPY as the benchmark and assuming a daily r = 0.01%. (3pts) MSFT CAT UNH UPS VZ MRK F INTC Beta: Alpha: 1.26 11% 0.61 -8% 0.69 27% 1.06 -30% 0.87 17% 0.19 -10% 0.20 15% 1.42 0.01% 3/4/2024 3/3/2024 3/2/2024 3/1/2024 2/28/2024 2/25/2024 CAT UNH UPS MRK INTC SPY -1.77% -0.12% -2.08% -3.64% -2.61% -1.30% -0.42% -2.08% -1.54% -0.49% 0.92% 1.98% -1.57% -1.01% 0.70% 1.02% -2.70% -0.62% 1.52% -0.37% -0.48% 1.44% 1.32% 0.16% 0.44% 6.48% 1.24% 2.31% -0.68% 0.03% -0.62% 1.95% -0.21% -0.16% 1.21% 0.71% -0.14% 0.52% -0.08% 0.41% 0.32% 0.55% 1.16% -2.14% 0.49% 1.54% 0.02% 2.03% 6.94% 0.04% 0.06% 0.85% 0.90% 1.51% -1.50% -0.24% -0.41% -0.25% -1.76% -0.06% 0.54% -2.40% -1.29% 1.64% -0.45% -0.46% 2.11% -0.06% -0.20% 0.30% 3.70% 1.17% -0.42% 1.27% 0.30% -0.13% -0.56% 0.59% -0.06% -2.25% -0.03% 1.76% -0.36% -0.18% 0.66% -1.14% -2.98% 0.22% 1.69% 1.10% 0.28% 2.60% 1.76% 1.09% 2.03% -0.25% 1.05% 0.00% 1.25% 2.52% -0.18% 0.07% 4.06% 3.50% -0.51% -0.66% 3.24% 2.22% 3.87% 0.47% 2.05% 0.92% 3.05% 0.50% 1.11% 2.03% 2.20% -1.30% 0.28% 1.05% -3.12% 0.20% -1.02% 0.27% -1.87% -0.73% -1.93% 1.44% -1.45% -1.78% -1.58% -0.36% 0.48% -1.78% -1.27% -1.01% 0.96% 1.21% -2.04% 0.19% 0.28% 0.13% -0.24% -0.45% 4.59% -0.10% 2.56% 0.27% 1.66% -0.32% 1.09% 2.12% 2.68% -1.10% 6.76% -2.75% -0.38% 1.11% -2.62% -1.00% 0.38% -0.76% -3.78% 0.53% -2.36% -0.81% -4.38% -0.78% -0.13% -5.22% -2.95% -2.05% 0.42% 2.48% 0.29% -0.96% 0.82% 0.88% -4.26% -0.81% -1.42% 1.16% 0.25% -1.92% 0.46% 0.96% 0.63% -2.76% -0.50% 1.78% 5.35% 1.92% 4.38% 2.86% 0.99% 0.43% 8.38% 1.84% -1.29% -2.53% 0.08% -1.84% -2.30% -0.11% -0.31% -4.90% -1.52% 0.50% 0.28% 0.03% -0.02% 0.22% -0.83% 0.34% -1.51% -0.26% 24% 2/24/2024 2/23/2024 4) Based on your beta calculations and the forecast alpha for each stock (your analysts' estimates of alpha going forward), calculate the alpha and beta of your long/short portfolio using the net weights provided in Table 2, the expected portfolio annualized excess return (above the risk free rate) and the portfolio beta return if the benchmark were to return 10% or -10% above the risk free rate over the next year. Finally, calculate the ROIC for your 1MM USD investment assuming both a -10% and 10% return of the benchmark. (4pts) 2/22/2024 2/18/2024 2/17/2024 2/16/2024 2/15/2024 MSFT CAT UNH UPS VZ MRK Forecast Alpha 10% 5% 15% -10% 5% -4% F 5% INTC -10% 2/14/2024 2/11/2024 - 43% 0.92% 1.28% 4.36% 2.12% 2.21% 5.11% -1.06% -0.81% 4.64% 1.33% -1.54% -3.07% 1.18% 1.50% -2.59% -2.37% -0.62% -0.09% -2.15% -0.91% -0.14% -1.97% -1.77% -0.07% -0.39% -1.13% -0.78% -0.19% 0.13% -0.55% -4.16% -1.07% -0.96% -1.43% -0.54% -5.32% 0.08% 0.47% 0.01% 2.85% -0.65% -2.93% -4.37% -2.02% -1.37% -2.14% 0.34% -1.11% -2.61% -2.14% -0.12% 0.11% 0.38% -0.43% -0.90% 0.07% -0.76% -0.39% 0.11% 1.85% 1.76% 0.81% 1.81% 1.53% 0.17% 1.75% 3.55% 1.61% -0.01% -0.67% -0.78% -0.10% 0.23% -0.09% -0.22% -0.51% -0.33% -0.90% -1.76% -2.52% -3.26% 053% 0.10% -293% -1.97% 1.33% 2.91% 3.82% 3.97% Question #1 As a newly appointed long/short portfolio manager with 1MM AUM in cash, you are presented with a list of 8 stocks that your analysts are recommending that you take a position in. Six stocks (MSFT, CAT, UNH, UPS, VZ and MRK) are recommended as long investments and two (F, INTC) as short investments with net weights and current prices shown in Table 2. The portfolio can trade on a margin requirement of 50% meaning, with 1MM USD equity, you can borrow and/or short sell up to an additional 2MM USD for a gross account value of 3MM USD. There is no need to log transform returns in this problem and there are no costs to borrow. Table 1. Asset Returns Date 3/31/2024 MSFT VZ 3/30/2024 3/29/2024 3/28/2024 1 Assuming you maximize the gross account value and invest at the net weights given, calculate the gross weights, dollar value, and number of shares invested in each position. (3pts) Gross ($): $ 3,000,000 Table 2. Asset Net Weights and Prices MSFT Net Weight 38% CAT 35% UNH 15% UPS VZ MRK -47% 23% -47% F 35% INTC 47% Current Price $ Gross Weight 308.31 $ 13% 222.82 $ 12% 509.97 5% S 49.56 $ 16% 214.46 $ 8% 50.33 $ 82.05 $ 16.91 Dollar Value $399,768.25 $365,005.79 $156,431.05 $490,150.64 $243,337.20 16% $490,150.64 Shares 1297 1638 307 9890 1135 9739 12% $365,005.79 4449 16% $490,150.64 28986 57440 3/25/2024 3/24/2024 3/23/2024 3/22/2024 3/21/2024 3/18/2024 100% 3/17/2024 288% 3/16/2024 3/15/2024 3/14/2024 3/11/2024 3/10/2024 2) Based on the dollar values invested long or short in each position, calculate the net dollar amount invested in the portfolio. (2pts) 3/9/2024 Net ($): $ 1,039,397 3/8/2024 3/7/2024 3) Using the historical returns provided in Table 1, calculate the 1-year trailing, annualized beta and alpha for each stock using SPY as the benchmark and assuming a daily r = 0.01%. (3pts) MSFT CAT UNH UPS VZ MRK F INTC Beta: Alpha: 1.26 11% 0.61 -8% 0.69 27% 1.06 -30% 0.87 17% 0.19 -10% 0.20 15% 1.42 0.01% 3/4/2024 3/3/2024 3/2/2024 3/1/2024 2/28/2024 2/25/2024 CAT UNH UPS MRK INTC SPY -1.77% -0.12% -2.08% -3.64% -2.61% -1.30% -0.42% -2.08% -1.54% -0.49% 0.92% 1.98% -1.57% -1.01% 0.70% 1.02% -2.70% -0.62% 1.52% -0.37% -0.48% 1.44% 1.32% 0.16% 0.44% 6.48% 1.24% 2.31% -0.68% 0.03% -0.62% 1.95% -0.21% -0.16% 1.21% 0.71% -0.14% 0.52% -0.08% 0.41% 0.32% 0.55% 1.16% -2.14% 0.49% 1.54% 0.02% 2.03% 6.94% 0.04% 0.06% 0.85% 0.90% 1.51% -1.50% -0.24% -0.41% -0.25% -1.76% -0.06% 0.54% -2.40% -1.29% 1.64% -0.45% -0.46% 2.11% -0.06% -0.20% 0.30% 3.70% 1.17% -0.42% 1.27% 0.30% -0.13% -0.56% 0.59% -0.06% -2.25% -0.03% 1.76% -0.36% -0.18% 0.66% -1.14% -2.98% 0.22% 1.69% 1.10% 0.28% 2.60% 1.76% 1.09% 2.03% -0.25% 1.05% 0.00% 1.25% 2.52% -0.18% 0.07% 4.06% 3.50% -0.51% -0.66% 3.24% 2.22% 3.87% 0.47% 2.05% 0.92% 3.05% 0.50% 1.11% 2.03% 2.20% -1.30% 0.28% 1.05% -3.12% 0.20% -1.02% 0.27% -1.87% -0.73% -1.93% 1.44% -1.45% -1.78% -1.58% -0.36% 0.48% -1.78% -1.27% -1.01% 0.96% 1.21% -2.04% 0.19% 0.28% 0.13% -0.24% -0.45% 4.59% -0.10% 2.56% 0.27% 1.66% -0.32% 1.09% 2.12% 2.68% -1.10% 6.76% -2.75% -0.38% 1.11% -2.62% -1.00% 0.38% -0.76% -3.78% 0.53% -2.36% -0.81% -4.38% -0.78% -0.13% -5.22% -2.95% -2.05% 0.42% 2.48% 0.29% -0.96% 0.82% 0.88% -4.26% -0.81% -1.42% 1.16% 0.25% -1.92% 0.46% 0.96% 0.63% -2.76% -0.50% 1.78% 5.35% 1.92% 4.38% 2.86% 0.99% 0.43% 8.38% 1.84% -1.29% -2.53% 0.08% -1.84% -2.30% -0.11% -0.31% -4.90% -1.52% 0.50% 0.28% 0.03% -0.02% 0.22% -0.83% 0.34% -1.51% -0.26% 24% 2/24/2024 2/23/2024 4) Based on your beta calculations and the forecast alpha for each stock (your analysts' estimates of alpha going forward), calculate the alpha and beta of your long/short portfolio using the net weights provided in Table 2, the expected portfolio annualized excess return (above the risk free rate) and the portfolio beta return if the benchmark were to return 10% or -10% above the risk free rate over the next year. Finally, calculate the ROIC for your 1MM USD investment assuming both a -10% and 10% return of the benchmark. (4pts) 2/22/2024 2/18/2024 2/17/2024 2/16/2024 2/15/2024 MSFT CAT UNH UPS VZ MRK Forecast Alpha 10% 5% 15% -10% 5% -4% F 5% INTC -10% 2/14/2024 2/11/2024 - 43% 0.92% 1.28% 4.36% 2.12% 2.21% 5.11% -1.06% -0.81% 4.64% 1.33% -1.54% -3.07% 1.18% 1.50% -2.59% -2.37% -0.62% -0.09% -2.15% -0.91% -0.14% -1.97% -1.77% -0.07% -0.39% -1.13% -0.78% -0.19% 0.13% -0.55% -4.16% -1.07% -0.96% -1.43% -0.54% -5.32% 0.08% 0.47% 0.01% 2.85% -0.65% -2.93% -4.37% -2.02% -1.37% -2.14% 0.34% -1.11% -2.61% -2.14% -0.12% 0.11% 0.38% -0.43% -0.90% 0.07% -0.76% -0.39% 0.11% 1.85% 1.76% 0.81% 1.81% 1.53% 0.17% 1.75% 3.55% 1.61% -0.01% -0.67% -0.78% -0.10% 0.23% -0.09% -0.22% -0.51% -0.33% -0.90% -1.76% -2.52% -3.26% 053% 0.10% -293% -1.97% 1.33% 2.91% 3.82% 3.97%