Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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% 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%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding financial statements

Authors: Lyn M. Fraser, Aileen Ormiston

9th Edition

136086241, 978-0136086246

More Books

Students also viewed these Finance questions

Question

Be honest, starting with your application and rsum.

Answered: 1 week ago

Question

In Exercises find dy/dx by implicit differentiation. xy - y = x

Answered: 1 week ago

Question

What are the various objectives for which meetings can be held?

Answered: 1 week ago

Question

Why do we need meetings? What are the characteristics of meetings?

Answered: 1 week ago

Question

Explain in detail the process of conducting a group discussion.

Answered: 1 week ago