how would I solve this in excel? i Manipulating...
60.1K
Verified Solution
Link Copied!
Question
Accounting
how would I solve this in excel?
i Manipulating the basic constant-growth dividend discount model What is the exected annual dividend for a stock currently selling for $ 51.00 that has 13.0% expected return and a 7.1% expected capital gain? Current price= $ 51.00 E(r= 13.0% Expected growth rate=g= 7.1% Expected annual dividendo 4.3% i Calculating the expected rate of return, assuming market efficiency What is the required rate of return for a firm whose stock price is $ 41.00 and whose expected annual dividend is $ 1.75 given a expected sustainable growth rate of Stock price: $ 41.00 Expected dividend= $ 1.75 Expected sustainable growth rate (g)= 4.3% Expected required rate of return=
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
