# 1.- You are trying to value a firm's equity. They pay quarterly dividends, with the nextdividend payment of \$1.50 due later today. They will increase this dividend by \$0.12every quarter for the next year. After that, they will increase dividends by 4.4% APR,compounded quarterly into perpetuity. The discount rate for this stock is 16.4% APR,compounded quarterly.a. What should be the price of this stock?b.You purchase the stock at the price above. But right after you purchase the stock(and before they are supposed to pay their dividend), they announce that they areincreasing the dividend today to \$1.75. They also announce that they will increasetheir dividends by \$0.16 each quarter for the next year, and then dividends will growby 4.8% APR, compounded quarterly, into perpetuity. If you decide to sellimmediately after this news (and before the dividend is paid later today), what returnwould you have earned during the few moments that you owned this stock?T

Question
Asked Nov 24, 2019
37 views

I need help with this problem and how to set it up in excel with formulas.

check_circle

## Expert Answer

Step 1

a) Since dividends are paid quarterly and both the growth rate and required rate of return are compounded quarterly, price of the stock can be calculated as below. Note: answer is highlighted in yellow, with all the workings shown separately.

Excel workings:

Step 2

Answer: Price of the stock today is \$63.32

Step 3

b) When the first dividend is \$1.75 and is expected to grow at 4.8% compounded qu...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in