Part 1		Table 1
Required	Selection 1	Selection 2	Selection 3	Selection 4
Company Name	Apple Inc. (AAPL)	Microsoft Corporation (MSFT)	Coca-Cola Consolidated, Inc. (COKE)	Johnson & Johnson (JNJ)
Company Symbol (Ticker)	AAPL	MSFT	COKE	JNJ
Website Visited	https://finance.yahoo.com	https://finance.yahoo.com	https://finance.yahoo.com	https://finance.yahoo.com
Date Visited	8-Feb-23	8-Feb-23	8-Feb-23	8-Feb-23
Stock Features
Price to Earnings Ratio (P/E Ratio)	26.26	29.73	14.56	24.28
Current Dividend ($)	0.92 (0.61%)	2.72	2.00	4.52
Dividend Yield (%)	0.0061	1.06%	0.38%	2.77%
Earnings per Share (EPS)	5.89	9	35.19	6.73
Beta	Beta (5Y Monthly) 1.28	Beta (5Y Monthly) 0.92	Beta (5Y Monthly) 0.95	Beta (5Y Monthly) 0.54
Market Capitalization:	2.447T	1.992T	4.802B	427.206B

From the table above answer the followings:

Stock Valuation: Assume each company stock has an expected (constant) dividend growth rate of 1.35% and a required rate of return of 10.7%.

You are required to complete the tasks below:

(a) Calculate the intrinsic value of each company stock you purchased. (b) Determine whether the price you paid for the stock was just right, overvalued or undervalued

• Intrinsic value in this method means the value of the stock is based solely on the expected rate of growth of the dividend the company pays.

Note: If the price you paid was more than the value you calculated the stock was overvalued. If the price you paid was equal to the value you calculated the price was just right. If the price you paid was less than the value you calculated the stock was undervalued.

Formula: P = D₀(1 + g)/ (R - g); where:

P = stock price; D₀ = current dividend; R = Required rate of return; g = constant growth rate

Variables	Company 1	Company 2	Company 3	Company 4
Dividend when you purchased the stock (D0)
Dividend Growth Rate (g)	1.35%	1.35%	1.35%	1.35%
Required Rate of Return (R)	10.70%	10.70%	10.70%	10.70%
Intrinsic Value (P)
Purchase Price (price you paid)