Finance-How would I set these problems up using Excel

| January 30, 2017

Question
How would I set these problems up using Excel?

Value a Constant Growth Stock; Financial Analyst forecast Safeco Corp’s (SAF) growth rate for the future to be 8%. Safeco’s recent dividend was 0.88. What is the value of Safeco stock when the required return is 12%? (LG8-5)

Variable Growth 8-33 Finance

A fast growing firm recently paid a dividend of .40 per share. The dividend is expected to increase at a 20% rate for the next 3 years. Afterwards, a more stable 12% growth rate can be assumed. If a 13% discount rate is appropriate for this stock, what is it’s value? (LG8-6) How would I calculate this question using Excel??

Get a 30 % discount on an order above $ 50
Use the following coupon code:
COCONUT
Order your essay today and save 30% with the discount code: COCONUTOrder Now
Positive SSL