Question

In: Finance

Using the stocks in your initial portfolio, prepare a valuation of each stock and the initial...

Using the stocks in your initial portfolio, prepare 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?

Prepare 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.

Stock

Initial Investment - 01/11/17

3/12/18

Number of shares

Beta

Total Investment

Portfolio Allocation

Return

Dividend

AAPL

$       175.28

$ 181.72

2,000

1.31

$     350,560.00

35%

3.67%

17.53

COST

$       189.38

$ 189.37

1500

1.05

$      284,070.00

28%

-0.01%

18.94

KO

$         46.04

$  44.53

900

0.56

$       41,436.00

4%

-3.28%

4.60

JPM

$       110.84

$ 117.66

2000

1.33

$     221,680.00

22%

6.15%

11.08

BAC

$         30.66

$  32.84

1000

1.77

$        30,660.00

3%

7.11%

3.07

Total Investment

$     928,406.00

93%

Cash Position

$       71,594.00

7%

Total Amount

$  1,000,000.00

Solutions

Expert Solution

An answer to part a

To justify whether a stock of each of these companies over or undervalued, current market will be compared against an intrinsic value of a stock of these companies, for that more information is needed to a claculate intrinsic value of a stock.

An answer to part b

An answer to part d

Events that may have caused the stocks’ prices to increase or decrease:

1. Earnings,

2. Company Specific events

3. Dividend

4. Stock Split and buybacks

5. Business regulations,

6. Federal Policy Reviews

7. Any litigation positive or negative outcome.


Related Solutions

Select Stock Portfolio has 5 stocks in it (each with the same amount of initial investment),...
Select Stock Portfolio has 5 stocks in it (each with the same amount of initial investment), which you have selected randomly from the S&P 500 list. Broad Stock Portfolio has 100 stocks in it (each with the same amount of initial investment), which you have selected randomly from the S&P 500 list. Which portfolio would have a greater expected average return or would it be the same? Explain.
There are 2 stocks in your portfolio. You own 65% of Stock A and 35% of...
There are 2 stocks in your portfolio. You own 65% of Stock A and 35% of stock B. The expected returns on each stock with the probability of those returns are: State of the Economy Probability Stock A Stock B Recession 30% -15 -6 Normal 45% +12 + 8 Boom 25% +30 +19 What is the variance of each stock? What is the standard deviation of each stock? What is the expected return of each stock and the expected return...
Compare and contrast the valuation of stocks using the residual income valuation model and the abnormal...
Compare and contrast the valuation of stocks using the residual income valuation model and the abnormal earnings growth model
Elle holds a $5,000 portfolio that consists of four stocks. Her investment in each stock, as...
Elle holds a $5,000 portfolio that consists of four stocks. Her investment in each stock, as well as each stock’s beta, is listed in the following table: Stock Investment Beta Standard Deviation Omni Consumer Products Co. (OCP) $1,750 0.90 18.00% Zaxatti Enterprises (ZE) $1,000 1.50 11.00% Western Gas & Electric Co. (WGC) $750 1.10 18.00% Mainway Toys Co. (MTC) $1,500 0.60 22.50% Suppose all stocks in Elle’s portfolio were equally weighted. Which of these stocks would contribute the least market...
Cheyenne holds a $10,000 portfolio that consists of four stocks. Her investment in each stock, as...
Cheyenne holds a $10,000 portfolio that consists of four stocks. Her investment in each stock, as well as each stock’s beta, is listed in the following table: Stock Investment Beta Standard Deviation Omni Consumer Products Co. (OCP) $3,500 0.80 15.00% Kulatsu Motors Co. (KMC) $2,000 1.90 11.00% Western Gas & Electric Co. (WGC) $1,500 1.10 16.00% Mainway Toys Co. (MTC) $3,000 0.50 28.50% Suppose all stocks in Cheyenne’s portfolio were equally weighted. Which of these stocks would contribute the least...
Your portfolio contains Stocks X and Y with the following dollaramount of investments: Stock X...
Your portfolio contains Stocks X and Y with the following dollar amount of investments: Stock X Y Investment $5,000 $15,000 The portfolio has a beta of 1.2. If you add Stock Z into your portfolio with an investment of $10,000, what is the beta of your new portfolio if Stock Z has a beta equal to 3?
Q1:Assume that your portfolio has three stocks. You have $300,000 invested in stock A that is...
Q1:Assume that your portfolio has three stocks. You have $300,000 invested in stock A that is returning 17%, $300, 000 invested in stock B that is returning 16%, and $400,000 invested in stock C that is returning 18%. What is the expected return of your portfolio? Q2: A beta coefficient for a stock of 0.8 implies A. the stock is more risky than the market because an 1% decrease in the stock return will cause the market return to decrease...
Your investment club has only two stocks in its portfolio. $30,000 is invested in a stock...
Your investment club has only two stocks in its portfolio. $30,000 is invested in a stock with a beta of 0.4, and $60,000 is invested in a stock with a beta of 2.2. What is the portfolio's beta? Round your answer to two decimal places. AA Corporation’s stock has a beta of 1.3. The risk-free rate is 7% and the expected return on the market is 11%. What is the required rate of return on AA's stock? Round your answer...
Your investment club has only two stocks in its portfolio. $10,000 is invested in a stock...
Your investment club has only two stocks in its portfolio. $10,000 is invested in a stock with a beta of 0.5, and $75,000 is invested in a stock with a beta of 1.5. What is the portfolio's beta? Round your answer to two decimal places. Required Rate of Return AA Corporation’s stock has a beta of 1.1. The risk-free rate is 2.5% and the expected return on the market is 11%. What is the required rate of return on AA's...
Why is stock valuation more challenging than bond valuation? Are dividend paying stocks easier to value...
Why is stock valuation more challenging than bond valuation? Are dividend paying stocks easier to value than non-dividend paying stocks? Why or why not?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT