Can someone please explain (or include the formulas on) how to get the yellow and green cells based on the data? The yellow are cells I need to input, and the greens I need to calculate. Thank you!
Mutual of Chicago Insurance Company Stock Valuation Robert Balik and Carol Kiefer are senior vice presidents of the Mutual of Chicago Insurance Company. They are codirectors of the company's pension fund management division, with Balik having responsibility for fixed-income securities (primarily bonds) and Kiefer being responsible for equity investments. A major new client, the California League of Cities, has requested that Mutual of Chicago present an investment seminar to the mayors of the represented cities; Balik and Kiefer, who will make the actual presentation, have asked vou to helo them. To illustrate the common stock valuation process, Balik and Kiefer have asked you to analyze the Home Depot Company (HD). They picked this company because it is an established, mature company that the audience knows. You recently joined the firm as an equity analyst. Your job is to help Balik and Kiefer evaluate investment opportunities. The Home DepOt, InC. (HD) NySE - Nyst. Delayed Price. Currency in USD 324.260.10(0.03%)324.140.12(0.04%) After hours: Mar 4, 07:599M Es Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options 4. You have a current portfolio of 100% of Tesla (TSLA) which you want to diversify by buying HD. TSLA had a return of 61.33% in 2021. What would have been your return on the portfolio if you had invested 25% of it in HD and kept 75% in TSLA? You have to create the inputs and formulas for this one on your own. 0.00% Weight of HD Expected return for HD Mutual of Chicago Insurance Company Stock Valuation Robert Balik and Carol Kiefer are senior vice presidents of the Mutual of Chicago Insurance Company. They are codirectors of the company's pension fund management division, with Balik having responsibility for fixed-income securities (primarily bonds) and Kiefer being responsible for equity investments. A major new client, the California League of Cities, has requested that Mutual of Chicago present an investment seminar to the mayors of the represented cities; Balik and Kiefer, who will make the actual presentation, have asked vou to helo them. To illustrate the common stock valuation process, Balik and Kiefer have asked you to analyze the Home Depot Company (HD). They picked this company because it is an established, mature company that the audience knows. You recently joined the firm as an equity analyst. Your job is to help Balik and Kiefer evaluate investment opportunities. The Home DepOt, InC. (HD) NySE - Nyst. Delayed Price. Currency in USD 324.260.10(0.03%)324.140.12(0.04%) After hours: Mar 4, 07:599M Es Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options 4. You have a current portfolio of 100% of Tesla (TSLA) which you want to diversify by buying HD. TSLA had a return of 61.33% in 2021. What would have been your return on the portfolio if you had invested 25% of it in HD and kept 75% in TSLA? You have to create the inputs and formulas for this one on your own. 0.00% Weight of HD Expected return for HD
