楼主: 5099985619
145 0

[金融学] 大额悬赏求excel解决问题{股票} [分享]

  • 0关注
  • 0粉丝

博士生

63%

还不是VIP/贵宾

-

威望
0
论坛币
217 个
通用积分
75.0046
学术水平
0 点
热心指数
0 点
信用等级
0 点
经验
165 点
帖子
266
精华
0
在线时间
10 小时
注册时间
2019-10-4
最后登录
2020-5-27

5099985619 发表于 2020-5-23 09:14:08 |显示全部楼层
400论坛币
请说明用哪个函数谢谢![tr] [/tr]
[tr] [/tr]
[tr] [/tr]
[tr] [/tr]
[tr] [/tr]
[tr] [/tr]
[tr] [/tr]
[tr] [/tr]
[tr] [/tr]
[tr] [/tr]

You  are interested in purchasing the common stock of Azure Corporation. The firm  recently paid a dividend of $2.80 per share. It expects its earnings—and  hence its dividends—to grow at a rate of 6.8% for the foreseeable future.  Currently, similar-risk stocks have required returns of 7.2%.

To Do:

a. Given the data above, calculate  the present value of this security. Use the constant-growth model to find the  stock value.
    b. One year later,  your broker offers to sell you additional shares of Azure at $84.
    The most recent dividend paid was $2.92, and the expected growth rate for  earnings remains at 6.8%. If you determine that the appropriate risk premium  is 7.02% and you observe that the risk-free rate, RF, is currently 4.98%,  what is the firm’s current required return, rAzure?
    c. Applying  constant-growth model, determine the value of the stock using the new  dividend and required return from part b.
    d. Given your  calculation in part c, would you buy the additional shares from your broker  at $73 per share? Explain.


您需要登录后才可以回帖 登录 | 我要注册

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2020-5-27 22:37