I completed Portion 6A, 6B, and 6C and they can be found below the question. I just need to answer D and E.

Problem
1.)	COLM	90.1
2.)	DPS	0.96
3.)
4.)	5-yr Growth	10%
5A)	ROE	13.38%
5B)	Avg Div PO Rate	24.67%

WACC = 10%

Cost of Equity = 10%

A and B

Dividends Discount Model	2019	2020	2021	2022	2023	2024
	0.96	1.056	1.1616	1.27776	1.405536	1.5460896

C = LT g: 10.08%

D:

a. 6. To determine the stock value based on the dividend-discount model: Create a timeline in Excel for five years. b. Forecast the next five annual dividends based on the current dividend amount (from 2) and the five-year growth rate (from 4). C. Determine the long-term dividend growth rate using Eq. 9.12., and Columbia's retention rate (1-average payout rate) and expected return on new investments (use average ROE). d. Use the long-term growth rate to determine the stock price for year four using Eq. 9.13. Determine the current stock price using Eq. 9.14. e. (9.13) Diun+1 PN TE-9 (9.14) Dividend-Discount Model with Constant Long-Term Growth Divi Dive Divn 1 Divn+1 P. + + ... + + 1+re (1+re) (1+re)" (1+re)" E-9