Please show equations in excel you used to fill in the green highlighted boxes, thank you!
Today's (Fair-Value) Valuation of APPL Stock Apple Inc. (AAPL) NasdaqGs - Nasdaq GS Real Time Price. Currency in USD Add to watchlist 29 Visitors trend 2w1 10W T 9MT 117.90 1.93 (+1.67%) et open. Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options Previous Close 115.97 Market Cap 2.004T 1D 5D 1M 6M YTD 14 5Y Max * Full screen 150.00 Open 115.55 Beta (5Y Monthly) 1.35 117.78 Bid 116.65 x 3100 PE Ratio (TTM) 35.93 Ask 116.68 x 1100 EPS (TTM) 3.28 76.67 Day's Range 116.44 - 118.00 Earnings Date Jan 26, 2021 - Feb 01, 2021 40.00 52 Week Range 53.15 - 137.98 Forward Dividend & Yield 0.82 (0.71%) Volume 12,883,006 Ex-Dividend Date Nov 06, 2020 Jan 1, 20 Jun 10, 20 Trade prices are not sourced from all markets Avg. Volume 162,108,573 1y Target Est 123.11 Overvalued Performance Outlook Fair Value A XX.XX -13% Est. Return View details Related Research Weekly Stock List Analyst Report: Apple Inc. Chart Events & Bearish pattern detected Momentum 100 View all chart patterns Short Term 2W-6W Mid 1 Term 6W - 9M Long Term 9M- View more Apple Inc. (AAPL) NasdaqGs - Nasdaq GS Real Time Price. Currency in USD Add to watchlist 88 Visitors trend 2w1 10W 1 9M 1 117.90 +1.93 (+1.67%) ASSASS. VI et open. Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options Currency in USD Revenue Estimate Current Qtr. (Dec 2020) Next Qtr. (Mar 2021) Current Year (2021) Next Year (2022) No. of Analysts 25 25 32 29 Avg. Estimate 101.88B 72.3B 14.24B 329.76B Treasury Yield 10 Years (^TNX) NYBOT - NYBOT Real Time Price. Currency in USD Add to watchlist WSJ MARKETS English Edition - Print Edition Video Podcasts Latest Headlines 0.958 -5.014 (-1.4403%) 11/06/20 arket open. P/E RATIO YEAR AGO 41.98 ESTIMATE 82.63 Summary Chart Conversations Historical Data Options 31.33 25.45 24.02 25.15 Russell 2000 Index n.a. NASDAQ 100 Index 36.81 S&P 500 Index 39.81 Trailing 12 months Forward 12 months from Birinyi Associates, updated weekly on Friday, P/E data based on as-reported earnings: estimate data based on operating earnings. Source: Birinyi Associates Previous Close 0.9720 Day's Range 0.9580 - 0.9580 Open 0.9580 52 Week Range 0.3980 - 1.9490 According to the AAPL Data Summary provided: (1) Please calculate the Ri and the Intrinsic Value of AAPL Stock Please calculate the Fair Value of the AAPL stock as its Revenue Growth Rate for the coming year = (329.76-314.24)/314.24 = 4.94% The current Risk Free Rate = 0.958% The current YTD market return = 8.63% The D1 forward dividend = $0.82 $117.90 CAPM Equation: Ri Rf + Beta(Rm - Rf) Today's AAPL Stock Price Risk-Free Rate 0.958% 8.63% = Market Return Rate = Ri RE Rm Beta Expected Return on this Invested Asset Risk-free Rate (from Government Bonds) Market Rate of Return Beta of Security; Sensitivity of Expected Asset Return to the Expected Market Return = Beta 1.35 = 35.93 P/E of AAPL P/E of S&P 500 = 39.81 Ri = Forward Dividend D1 Company's Revenue Growth Rate $0.82 4.94% = Dividend Growth Model: = (D.*(1+g))/(k-g) Stock Valuation (Intrinsic Value) = (2) Based on the today's price of AAPL stock of $117.90 and your calculated Intrinsic value of AAPL stock: Amount Dollars AAPL Over-valued? Why is it that AAPL so over-valued? = Today's (Fair-Value) Valuation of APPL Stock Apple Inc. (AAPL) NasdaqGs - Nasdaq GS Real Time Price. Currency in USD Add to watchlist 29 Visitors trend 2w1 10W T 9MT 117.90 1.93 (+1.67%) et open. Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options Previous Close 115.97 Market Cap 2.004T 1D 5D 1M 6M YTD 14 5Y Max * Full screen 150.00 Open 115.55 Beta (5Y Monthly) 1.35 117.78 Bid 116.65 x 3100 PE Ratio (TTM) 35.93 Ask 116.68 x 1100 EPS (TTM) 3.28 76.67 Day's Range 116.44 - 118.00 Earnings Date Jan 26, 2021 - Feb 01, 2021 40.00 52 Week Range 53.15 - 137.98 Forward Dividend & Yield 0.82 (0.71%) Volume 12,883,006 Ex-Dividend Date Nov 06, 2020 Jan 1, 20 Jun 10, 20 Trade prices are not sourced from all markets Avg. Volume 162,108,573 1y Target Est 123.11 Overvalued Performance Outlook Fair Value A XX.XX -13% Est. Return View details Related Research Weekly Stock List Analyst Report: Apple Inc. Chart Events & Bearish pattern detected Momentum 100 View all chart patterns Short Term 2W-6W Mid 1 Term 6W - 9M Long Term 9M- View more Apple Inc. (AAPL) NasdaqGs - Nasdaq GS Real Time Price. Currency in USD Add to watchlist 88 Visitors trend 2w1 10W 1 9M 1 117.90 +1.93 (+1.67%) ASSASS. VI et open. Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options Currency in USD Revenue Estimate Current Qtr. (Dec 2020) Next Qtr. (Mar 2021) Current Year (2021) Next Year (2022) No. of Analysts 25 25 32 29 Avg. Estimate 101.88B 72.3B 14.24B 329.76B Treasury Yield 10 Years (^TNX) NYBOT - NYBOT Real Time Price. Currency in USD Add to watchlist WSJ MARKETS English Edition - Print Edition Video Podcasts Latest Headlines 0.958 -5.014 (-1.4403%) 11/06/20 arket open. P/E RATIO YEAR AGO 41.98 ESTIMATE 82.63 Summary Chart Conversations Historical Data Options 31.33 25.45 24.02 25.15 Russell 2000 Index n.a. NASDAQ 100 Index 36.81 S&P 500 Index 39.81 Trailing 12 months Forward 12 months from Birinyi Associates, updated weekly on Friday, P/E data based on as-reported earnings: estimate data based on operating earnings. Source: Birinyi Associates Previous Close 0.9720 Day's Range 0.9580 - 0.9580 Open 0.9580 52 Week Range 0.3980 - 1.9490 According to the AAPL Data Summary provided: (1) Please calculate the Ri and the Intrinsic Value of AAPL Stock Please calculate the Fair Value of the AAPL stock as its Revenue Growth Rate for the coming year = (329.76-314.24)/314.24 = 4.94% The current Risk Free Rate = 0.958% The current YTD market return = 8.63% The D1 forward dividend = $0.82 $117.90 CAPM Equation: Ri Rf + Beta(Rm - Rf) Today's AAPL Stock Price Risk-Free Rate 0.958% 8.63% = Market Return Rate = Ri RE Rm Beta Expected Return on this Invested Asset Risk-free Rate (from Government Bonds) Market Rate of Return Beta of Security; Sensitivity of Expected Asset Return to the Expected Market Return = Beta 1.35 = 35.93 P/E of AAPL P/E of S&P 500 = 39.81 Ri = Forward Dividend D1 Company's Revenue Growth Rate $0.82 4.94% = Dividend Growth Model: = (D.*(1+g))/(k-g) Stock Valuation (Intrinsic Value) = (2) Based on the today's price of AAPL stock of $117.90 and your calculated Intrinsic value of AAPL stock: Amount Dollars AAPL Over-valued? Why is it that AAPL so over-valued? =
