Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

if the dividend growth rate begins declining immediately from the current level to its long-term rate over 20 years (15-year transition plus the initial five

image text in transcribed

if the dividend growth rate begins declining immediately from the current level to its long-term rate over 20 years (15-year transition plus the initial five years), what is the value of the stock according to the H-Model? What is the value using the three-stage model? Use the same assumption as in part D.

F G H 1 J J K L M Year 2017 2020 B DPS 1.079 2018 1.2 11.2% 2019 1.26 5.0% 1.32 4.8% 2021 1.392 5.5% growth Annulaized Div Groth rate 6.6% $ 106.58 Intrinsic Value Based on Constant growth rate DO C 1.392 D1 1.484 8 8% Ke G 6.6% A B D E 1 Current Price Beta 2 INTEL CORPORATION (XNAS:INTC) $ 43.08 0.60 3 Date Dividends % change 1+%change 4 2/3/2017 0.26 - 5 5/3/2017 0.273 5.00% 105.00% 6 6. 8/3/2017 0.273 0.00% 100.00% 7 11/6/2017 0.273 0.00% 100.00% 8 2/6/2018 0.3 9.89% 109.89% 9 5/4/2018 0.3 0.00% 100.00% 10 8/6/2018 0.3 0.00% 100.00% 11 11/6/2018 0.3 0.00% 100.00% 12 2/6/2019 0.315 5.00% 105.00% 13 5/6/2019 0.315 0.00% 100.00% 14 8/6/2019 0.315 0.00% 100.00% 15 11/6/2019 0.315 0.00% 100.00% 16 2/6/2020 0.33 4.76% 104.76% 17 5/6/2020 0.33 0.00% 100.00% 18 8/6/2020 0.33 0.00% 100.00% 19 11/5/2020 0.33 0.00% 100.00% 20 2/4/2021 0.348 5.45% 105.45% 21 5/6/2021 0.348 0.00% 100.00% 22 8/5/2021 0.348 0.00% 100.00% 23 11/4/2021 0.348 0.00% 100.00% 24 A Geomean 1.55% 25 26 27 D Intrinsic Value Based on Two-stage growth rate $ G1 27.59 6.6% 1.7% G2 Year 0 1 2 DPS Discount r PV 2021 1.392 1.0000 2022 1.48 0.9259 2023 1.58 0.8573 2024 1.69 0.7938 2025 1.80 0.7350 2026 1.92 0.6806 1.37 1.36 1.34 3 1.32 4 5 5 2026-Inf. 1.30 30.69 0.6806 20.89 Intrinsic Value Based on Two-stage growth rate 27.59 28 29 30 31 32 F G H 1 J J K L M Year 2017 2020 B DPS 1.079 2018 1.2 11.2% 2019 1.26 5.0% 1.32 4.8% 2021 1.392 5.5% growth Annulaized Div Groth rate 6.6% $ 106.58 Intrinsic Value Based on Constant growth rate DO C 1.392 D1 1.484 8 8% Ke G 6.6% A B D E 1 Current Price Beta 2 INTEL CORPORATION (XNAS:INTC) $ 43.08 0.60 3 Date Dividends % change 1+%change 4 2/3/2017 0.26 - 5 5/3/2017 0.273 5.00% 105.00% 6 6. 8/3/2017 0.273 0.00% 100.00% 7 11/6/2017 0.273 0.00% 100.00% 8 2/6/2018 0.3 9.89% 109.89% 9 5/4/2018 0.3 0.00% 100.00% 10 8/6/2018 0.3 0.00% 100.00% 11 11/6/2018 0.3 0.00% 100.00% 12 2/6/2019 0.315 5.00% 105.00% 13 5/6/2019 0.315 0.00% 100.00% 14 8/6/2019 0.315 0.00% 100.00% 15 11/6/2019 0.315 0.00% 100.00% 16 2/6/2020 0.33 4.76% 104.76% 17 5/6/2020 0.33 0.00% 100.00% 18 8/6/2020 0.33 0.00% 100.00% 19 11/5/2020 0.33 0.00% 100.00% 20 2/4/2021 0.348 5.45% 105.45% 21 5/6/2021 0.348 0.00% 100.00% 22 8/5/2021 0.348 0.00% 100.00% 23 11/4/2021 0.348 0.00% 100.00% 24 A Geomean 1.55% 25 26 27 D Intrinsic Value Based on Two-stage growth rate $ G1 27.59 6.6% 1.7% G2 Year 0 1 2 DPS Discount r PV 2021 1.392 1.0000 2022 1.48 0.9259 2023 1.58 0.8573 2024 1.69 0.7938 2025 1.80 0.7350 2026 1.92 0.6806 1.37 1.36 1.34 3 1.32 4 5 5 2026-Inf. 1.30 30.69 0.6806 20.89 Intrinsic Value Based on Two-stage growth rate 27.59 28 29 30 31 32

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The ABCs Of Personal Finance

Authors: Bukiie Smart

1st Edition

198092614X, 978-1980926146

More Books

Students also viewed these Finance questions