Answer the following in Excel. Show your work UL Company (“ULC”) paid a common stock dividend...

Answer the following in Excel. Show your work

UL Company (“ULC”) paid a common stock dividend of $2.50 per share just now. ULC plans to reduce its common stock dividend to $2.00 next year, then pay dividends of $3.00 the following three years, and finally settle on a dividend growth rate of 5% for the rest of the company’s life. If investors in companies of similar risk require a 9.75% rate of return, what is the value of LC common stock today?

Solutions

Expert Solution

Price of STock = PV of Cfs from it.

D5 = D4 ( 1 + g)

D5 - Div after 5 Years

D4 - Div after 4 Years

g - Growth Rate

D5 = D4 ( 1 + g)

= $ 3.00 ( 1 + 0.05)

= $ 3.00 * 1.05

= $ 3.15

P4 = D5 / [ Ke - g ]

P4 - Price after 4 Years

D5 - Div after 5 Years

Ke - Required Ret

g - Growth Rate

P4 = D5 / [ Ke - g ]

= $ 3.15 / [ 9.75% - 5% ]

= $ 3.15 / 4.75%

= $ 66.32

Price Today:

Year	Particulars	Cash Flow	PVF @9.75%	PV of CFs
1	D1	$ 2.00	0.9112	$ 1.82
2	D2	$ 3.00	0.8302	$ 2.49
3	D3	$ 3.00	0.7565	$ 2.27
4	D4	$ 3.00	0.6893	$ 2.07
4	P4	$ 66.32	0.6893	$ 45.71
Price Today				$ 54.36

Price of stock today is $ 54.36

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

Answer the following in Excel. Show your work Beryl Corporation (“BC”) recently paid a dividend of...

Answer the following in Excel. Show your work Beryl Corporation (“BC”) recently paid a dividend of $2.75 per share. BC expects to grow its dividend at a current rate of 4.4% indefinitely. BC’s common stock is currently selling for $28.00 per share and your required rate of return is 9.25%. i. Given your required return, what is the value of one share of BC common stock to you? ii. Given the market price, what is the expected rate of return...

Please show your work A company just paid a dividend of $6 and expects the dividend...

Please show your work A company just paid a dividend of $6 and expects the dividend to decrease 10% this year, decrease 20% next year and then grow at a constant rate of 5% thereafter. If your required rate of return for the company is 10%, what is the per share value today? A. $74.50 B. $76.25 C. $78.22 D. $80.14 E. $83.45

Answer the following questions and use Excel to show your work. The mean time required to...

Answer the following questions and use Excel to show your work. The mean time required to complete a certain type of construction project is 52 weeks with a standard deviation of 3 weeks. Answer questions 4–7 using the preceding information and modeling this situation as a normal distribution. 4. What is the probability of the completing the project in no more than 52 weeks? a) 0.25 b) 0.50 c) 0.75 d) 0.05 5. What is the probability of the completing...

Answer the following questions and use Excel to show your work. A student has an important...

Answer the following questions and use Excel to show your work. A student has an important exam coming up and is contemplating not studying for the exam in order to attend a party with his friends. The student must earn a minimum score of 70% on the exam in order to successfully maintain his desired GPA. Suppose the student knows in advance that the exam will consist of 20 multiple-choice questions with 4 possible answers for each question. Answer questions...

Answer the following questions and use Excel to show your work. Customers arrive at a supermarket...

Answer the following questions and use Excel to show your work. Customers arrive at a supermarket check-out counter with an average arrival rate of 9 customers per hour. Answer questions 8–10 using the preceding information and modeling this situation as a Poisson distribution. 8. What is the probability of less than 5 customers arriving at the supermarket check-out counter in a given 1-hour period? a) 0.054 b) 0.446 c) 0.359 d) 0.612 9. What is the probability of exactly 12...

Answer the following questions and use Excel or this document to show your work. 1. Consider...

Answer the following questions and use Excel or this document to show your work. 1. Consider the following results for two samples randomly taken from two normal populations with equal variances. Sample I Sample II Sample Size 28 35 Sample Mean 48 44 Population Standard Deviation 9 10 a. Develop a 95% confidence interval for the difference between the two population means. b. Is there conclusive evidence that one population has a larger mean? Explain.

Company XYZ common stock just paid a dividend of $2.00 per share and its dividend is...

Company XYZ common stock just paid a dividend of $2.00 per share and its dividend is expected to grow at 10 percent per year for three years and then grow at 4 percent per year forever. XYZ stocks have a 13 percent required return. You should you be willing to pay?

Company A common stock 1,800,000 shares, B= 1.5. Company A just paid a dividend of $.80,...

Company A common stock 1,800,000 shares, B= 1.5. Company A just paid a dividend of $.80, with expected dividends growth at 5% per year. The ERM is 12%, and TB =yielding 3.5%. The most recent stock price for Company A is $61. B= beta, ERM = expected return on market, TB = Treasury Bills Company A has 40,000 semi-annual-coupon bonds with CR= 7%, PV= $1000, CPQ=119.80%; the bonds have 25 years to maturity. It also has 100,000 shares of 4%...

Monsters Inc. is a utility company that recently paid a common stock dividend of $5.45 per share.

Monsters Inc. is a utility company that recently paid a common stock dividend of $5.45 per share. If its divided growth rate is expected to remain at 4 percent per year indefinitely and its equity cost of capital is 9 percent, the current price of a share of Monsters' common stock is closest to $________.

Company X is calculating its WACC. The firm’s common stock just paid a dividend of $4.5...

Company X is calculating its WACC. The firm’s common stock just paid a dividend of $4.5 per share and now is selling for $80. The firm’s financial staff estimates the company’s new product will generate a dividend growth rate of 7%. Today the firm issued 7000 bonds that will mature in 15 years with $1,000 face value. These bonds will pay a 9% coupon rate quarterly and are currently selling for $970. The firm has 100K preferred shares of stock...

Subjects