Using the stocks in your initial portfolio, prep a valuation of each stock and the initial portfolio using zero, constant or variable growth models with a market return at 8 and at 12 Note that the growth rate must be less than the required rate of return Make sure you list the date of the valuation and the closing share price of your firm's stock Each firm's required rate of return will depend on its beta Is the stock of each of these companies over or undervalued What is the expected return using the CAPM model Prep a time series ratio analysis (liquidity, activity, debt, and profitability) Identify any events during the period that may have caused the stocks' prices to increase or decrease, explaining how these events affect the stocks' prices Price Stock 9 16 19 9 17 19 No of Shares Total investment Portfolio Allocation Apple Inc 218 75 220 21 2500 546875 Exxon Mobil 54 72 64 73 5 1500 108960 BP 11 00 39 95 38 91 2000 79900 Bestbuy Co 8 00 68 91 67 57 1000 68910 7 00 Walmart Inc 115 57 116 35 1000 115570 12 18000 920215 Cash Position 79785 8 Total Amount 1000000 BETA PAYOUT PROFIT MARGIN OPERATING MARGIN Apple P E (Forward) 1 08 25 13 21 50 P E ( Trailing EV EBITDA analyst Rating 24 87 Exxon 1 21 17 31 18 7 80 24 13 1 BUY 6 53 6 63 15 94 17 71 BP 0 61 BUY 93 71 9 97 3 03 5 74 Bestbuy Cp 10 14 14 81 5 77 1 67 BUY 34 67 3 52 4 71 Walmart Inc 11 26 12 21 0 65 47 51 7 12 HOLD 2 48 4 20 22 73 26 32 12 35 BUY

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 24, 2024

Using the stocks in your initial portfolio, prep a valuation of each stock and the initial portfolio using zero, constant or variable growth models with

Using the stocks in your initial portfolio, prep a valuation of each stock and the initial portfolio using zero, constant or variable growth models with a market return at 8% and at 12%.[Note that the growth rate must be less than the required rate of return.]Make sure you list the date of the valuation and the closing share price of your firm's stock.Each firm's required rate of return will depend on its beta.
Is the stock of each of these companies over or undervalued?
What is the expected return using the CAPM model?
Prep a time series ratio analysis (liquidity, activity, debt, and profitability).Identify any events during the period that may have caused the stocks' prices to increase or decrease, explaining how these events affect the stocks' prices.

Price Stock 9/16/19 9/17/19 No. of Shares Total investment Portfolio Allocation Apple Inc 218.75 220.21 2500 546875 Exxon Mobil 54% 72.64 73.5 1500 108960 BP 11.00% 39.95 38.91 2000 79900 Bestbuy Co 8.00% 68.91 67.57 1000 68910 7.00% Walmart Inc 115.57 116.35 1000 115570 12% 18000 920215 Cash Position 79785 8% Total Amount 1000000 BETA PAYOUT PROFIT MARGIN OPERATING MARGIN Apple P/E (Forward) 1.08 25.13% 21.50% P/E ( Trailing EV/EBITDA analyst Rating 24.87% Exxon 1.21 17.31 18.7 80.24% 13.1 BUY 6.53% 6.63% 15.94 17.71 BP 0.61 BUY 93.71% 9.97 3.03% 5.74% Bestbuy Cp. 10.14 14.81 5.77 1.67 BUY 34.67% 3.52% 4.71% Walmart Inc 11.26 12.21 0.65 47.51% 7.12 HOLD 2.48% 4.20% 22.73 26.32 12.35 BUY