1.- You are trying to value a firm's equity. They pay quarterly dividends, with the next dividend payment of $1.50 due later today. They will increase this dividend by $0.12 every 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 are increasing the dividend today to $1.75. They also announce that they will increase their dividends by $0.16 each quarter for the next year, and then dividends will grow by 4.8% APR, compounded quarterly, into perpetuity. If you decide to sell immediately after this news (and before the dividend is paid later today), what return would you have earned during the few moments that you owned this stock?T

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

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

1.- You are trying to value a firm's equity. They pay quarterly dividends, with the next
dividend payment of $1.50 due later today. They will increase this dividend by $0.12
every 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 are
increasing the dividend today to $1.75. They also announce that they will increase
their dividends by $0.16 each quarter for the next year, and then dividends will grow
by 4.8% APR, compounded quarterly, into perpetuity. If you decide to sell
immediately after this news (and before the dividend is paid later today), what return
would you have earned during the few moments that you owned this stock?T
Transcribed Image Text:1.- You are trying to value a firm's equity. They pay quarterly dividends, with the next dividend payment of $1.50 due later today. They will increase this dividend by $0.12 every 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 are increasing the dividend today to $1.75. They also announce that they will increase their dividends by $0.16 each quarter for the next year, and then dividends will grow by 4.8% APR, compounded quarterly, into perpetuity. If you decide to sell immediately after this news (and before the dividend is paid later today), what return would you have earned during the few moments that you owned this stock?T
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 5 images

Blurred answer
Knowledge Booster
Value Chain Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education