开发者:上海品职教育科技有限公司 隐私政策详情

应用版本:4.2.11(IOS)|3.2.5(安卓)APP下载

erin_hi1990 · 2023年07月04日

可以介绍下spread sheet模型吗?谢谢

NO.PZ2023032701000029

问题如下:

Eckhart tells Barton that he has heard rumors that ZTL is contemplating selling one of its major manufacturing facilities. He believes that if that should happen, the company would pay a series of special dividends in each of the three years following the sale. Barton asks him how she could best incorporate such a possibility into the valuation of the shares.

Eckhart’s best response to Barton’s question about the valuation of ZTL consid­ering the potential sale of its manufacturing facility would be to use:

选项:

A.

the H-model to reflect the change in dividends

B.

the Gordon growth model to incorporate the decrease in firm value after the sale

C.

a spreadsheet model that incorporates the special dividends

解释:

Dividend discount models assume stylized patterns of dividend growth, while a spreadsheet allows any assumed dividend pattern therefore, a spreadsheet model would be best suited for these anticipated special dividends.

可以介绍下spread sheet模型吗?谢谢

1 个答案

王园圆_品职助教 · 2023年07月04日

同学你好,首先,spread sheet模型在原版书上并没有介绍,所以助教也没法就这些内容给出太多信息

本题最好的解题方法是排除法

其次,你可以简单把spread sheet模型理解成将公司各期的现金流都放在一个excel模型里的一种估值方式

由于可以将各期的现金流分别计算和列示,整个模型就相比GGM和Hmodel更加灵活(因为本题这样只是有几年的分红会特别的增加的情况,显然不符合GGM的永续稳定增长和H model的增长稳定下降的模型,这些现金流也无法在这两个模型中体现),因而spread sheet 模型就能解决这种有几期现金流不稳定或和整体不一致的情况了

  • 1

    回答
  • 0

    关注
  • 356

    浏览
相关问题