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

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

学习体验
App下载
手机上的品职教育

随时随地学习课程，支持音视频下载！
- 扫码下载品职教育APP
进入课程
登录 | 注册

Fannie. · 2024年04月18日

关于sensitivity analysis的定义

NO.PZ2018103102000118

问题如下：

Matt is conducting a FCFF sensitivity analysis for Company M`s value. The most recent FCFF of Company M is $100 million. Assuming the tax rate is 35% and a stable capital structure of 40% debt and 60% equity, the company`s value is least sensitive to:

选项：

A.

cost of equity

B.

growth rate

C.

after-tax cost of debt

解释：

C is correct.

考点：Sensitivity Analysis in FCFF and FCFE

解析：1. Cost of equity敏感性分析：保持r_d = 5.5%，g = 5.0%

当r_e = 8.0%时，WACC = 0.4*5.5% + 0.6*8.0% = 7%

$Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{7\%-5\%}=5250$

当r_e = 12.0%时，WACC = 0.4*5.5% + 0.6*12.0% = 9.4%

$Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{9.4\%-5\%}=2386.36$

Range = 5250 – 2386.36 = 2863.64

2. After-tax cost of debt敏感性分析：保持r_e = 10%，g = 5%

当r_d = 5.0%时，WACC = 0.4*5.0% + 0.6*10.0% = 8%

$Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8\%-5\%}=3500$

当r_d = 6.0%时，WACC = 0.4*6.0% + 0.6*10.0% = 8.4%

$Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8.4\%-5\%}=3088.24$

Range = 3500 – 3088.24 = 411.76

3. Growth rate敏感性分析：保持r_e = 10%，r_d = 5.5%

WACC = 0.4*5.5% + 0.6*10.0% = 8.2%

当g = 4%时,

$Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+4\%\right)}{8.2\%-4\%}=2476.2$

当g = 6%时,

$Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+6\%\right)}{8.2\%-6\%}=4818.2$

Range =4818.2 - 2476.2 = 2342

三者相比，敏感性最弱的是after-tax cost of debt。

印象中，sensitivity analysis是某个因素单位变化所引起的结果变化分析。这题中，三个因素的变化幅度不同，high和low的结果直接相减就OK吗？不用考虑每个因素的变化幅度？

添加评论

0
0

1 个答案

已采纳答案

王园圆_品职助教 · 2024年04月18日

同学你好，不用的哦

这个题目本身的计算量已经超级大了，如果还要剔除每个变量的变化幅度的影响，这个计算难度就远超CFA考试范围了

其次，现实生活中的sensitivity analysis也不可能是按住每个变量变动幅度相同（即要求不同的变量变动幅度一致）来看最终结果的变化大小的

以下是网上助教搜到的sensitivity analysis 的一个样例，同学可以参考一下。由于横轴和纵轴的变量本身变动的底层逻辑就不同，横纵轴的变量的变动幅度是不可能一样的。

所以题目给的变量也没有是每个变量变化幅度一致,这是和现实应用高度一致的

SENSITIVITY ANALYSIS with Data Table in Excel | ExcelJunction.com - YouTube

添加评论

0
0

1
回答
0
关注
237
浏览

我要回答关注问题

相关问题

NO.PZ2018103102000118 问题如下 Matt is concting a FCFF sensitivity analysis for Company M`s value. The most recent FCFF of Company M is $100 million. Assuming the trate is 35% ana stable capitstructure of 40% an60% equity, the company`s value is least sensitive to: A.cost of equity B.growth rate C.after-tcost of C is correct.考点Sensitivity Analysis in FCFF anFCFE解析1. Cost of equity敏感性分析保持r= 5.5%，g = 5.0%当re = 8.0%时，WA= 0.4*5.5% + 0.6*8.0% = 7%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)7%−5%=5250Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{7\%-5\%}=5250FirmValue=WACC−gFCFF0×(1+g)=7%−5%100×(1+5%)=5250当re = 12.0%时，WA= 0.4*5.5% + 0.6*12.0% = 9.4%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)9.4%−5%=2386.36Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{9.4\%-5\%}=2386.36FirmValue=WACC−gFCFF0×(1+g)=9.4%−5%100×(1+5%)=2386.36Range = 5250 – 2386.36 = 2863.642. After-tcost of bt敏感性分析保持re = 10%，g = 5%当r= 5.0%时，WA= 0.4*5.0% + 0.6*10.0% = 8%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)8%−5%=3500Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8\%-5\%}=3500FirmValue=WACC−gFCFF0×(1+g)=8%−5%100×(1+5%)=3500当r= 6.0%时，WA= 0.4*6.0% + 0.6*10.0% = 8.4%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)8.4%−5%=3088.24Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8.4\%-5\%}=3088.24FirmValue=WACC−gFCFF0×(1+g)=8.4%−5%100×(1+5%)=3088.24Range = 3500 – 3088.24 = 411.763. Growth rate敏感性分析保持re = 10%，r= 5.5%WA= 0.4*5.5% + 0.6*10.0% = 8.2%当g = 4%时, Firm Value=FCFF0×(1+g)WACC−g=100×(1+4%)8.2%−4%=2476.2Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+4\%\right)}{8.2\%-4\%}=2476.2FirmValue=WACC−gFCFF0×(1+g)=8.2%−4%100×(1+4%)=2476.2当g = 6%时, Firm Value=FCFF0×(1+g)WACC−g=100×(1+6%)8.2%−6%=4818.2Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+6\%\right)}{8.2\%-6\%}=4818.2FirmValue=WACC−gFCFF0×(1+g)=8.2%−6%100×(1+6%)=4818.2Range =4818.2 - 2476.2 = 2342三者相比，敏感性最弱的是after-tcost of bt。虽然计算结果对选择答案也是一样，但是给了35%这个条件总得要用吧

2023-08-15 01:25 1 · 回答

NO.PZ2018103102000118问题如下 Matt is concting a FCFF sensitivity analysis for Company M`s value. The most recent FCFF of Company M is $100 million. Assuming the trate is 35% ana stable capitstructure of 40% an60% equity, the company`s value is least sensitive to: A.cost of equityB.growth rateC.after-tcost of btC is correct.考点Sensitivity Analysis in FCFF anFCFE解析1. Cost of equity敏感性分析保持r= 5.5%，g = 5.0%当re = 8.0%时，WA= 0.4*5.5% + 0.6*8.0% = 7%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)7%−5%=5250Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{7\%-5\%}=5250FirmValue=WACC−gFCFF0×(1+g)=7%−5%100×(1+5%)=5250当re = 12.0%时，WA= 0.4*5.5% + 0.6*12.0% = 9.4%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)9.4%−5%=2386.36Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{9.4\%-5\%}=2386.36FirmValue=WACC−gFCFF0×(1+g)=9.4%−5%100×(1+5%)=2386.36Range = 5250 – 2386.36 = 2863.642. After-tcost of bt敏感性分析保持re = 10%，g = 5%当r= 5.0%时，WA= 0.4*5.0% + 0.6*10.0% = 8%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)8%−5%=3500Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8\%-5\%}=3500FirmValue=WACC−gFCFF0×(1+g)=8%−5%100×(1+5%)=3500当r= 6.0%时，WA= 0.4*6.0% + 0.6*10.0% = 8.4%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)8.4%−5%=3088.24Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8.4\%-5\%}=3088.24FirmValue=WACC−gFCFF0×(1+g)=8.4%−5%100×(1+5%)=3088.24Range = 3500 – 3088.24 = 411.763. Growth rate敏感性分析保持re = 10%，r= 5.5%WA= 0.4*5.5% + 0.6*10.0% = 8.2%当g = 4%时, Firm Value=FCFF0×(1+g)WACC−g=100×(1+4%)8.2%−4%=2476.2Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+4\%\right)}{8.2\%-4\%}=2476.2FirmValue=WACC−gFCFF0×(1+g)=8.2%−4%100×(1+4%)=2476.2当g = 6%时, Firm Value=FCFF0×(1+g)WACC−g=100×(1+6%)8.2%−6%=4818.2Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+6\%\right)}{8.2\%-6\%}=4818.2FirmValue=WACC−gFCFF0×(1+g)=8.2%−6%100×(1+6%)=4818.2Range =4818.2 - 2476.2 = 2342三者相比，敏感性最弱的是after-tcost of bt。能否求导数来做，这计算量…没心情算了😐

2023-04-24 07:37 1 · 回答

NO.PZ2018103102000118问题如下 Matt is concting a FCFF sensitivity analysis for Company M`s value. The most recent FCFF of Company M is $100 million. Assuming the trate is 35% ana stable capitstructure of 40% an60% equity, the company`s value is least sensitive to: A.cost of equityB.growth rateC.after-tcost of btC is correct.考点Sensitivity Analysis in FCFF anFCFE解析1. Cost of equity敏感性分析保持r= 5.5%，g = 5.0%当re = 8.0%时，WA= 0.4*5.5% + 0.6*8.0% = 7%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)7%−5%=5250Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{7\%-5\%}=5250FirmValue=WACC−gFCFF0×(1+g)=7%−5%100×(1+5%)=5250当re = 12.0%时，WA= 0.4*5.5% + 0.6*12.0% = 9.4%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)9.4%−5%=2386.36Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{9.4\%-5\%}=2386.36FirmValue=WACC−gFCFF0×(1+g)=9.4%−5%100×(1+5%)=2386.36Range = 5250 – 2386.36 = 2863.642. After-tcost of bt敏感性分析保持re = 10%，g = 5%当r= 5.0%时，WA= 0.4*5.0% + 0.6*10.0% = 8%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)8%−5%=3500Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8\%-5\%}=3500FirmValue=WACC−gFCFF0×(1+g)=8%−5%100×(1+5%)=3500当r= 6.0%时，WA= 0.4*6.0% + 0.6*10.0% = 8.4%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)8.4%−5%=3088.24Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8.4\%-5\%}=3088.24FirmValue=WACC−gFCFF0×(1+g)=8.4%−5%100×(1+5%)=3088.24Range = 3500 – 3088.24 = 411.763. Growth rate敏感性分析保持re = 10%，r= 5.5%WA= 0.4*5.5% + 0.6*10.0% = 8.2%当g = 4%时, Firm Value=FCFF0×(1+g)WACC−g=100×(1+4%)8.2%−4%=2476.2Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+4\%\right)}{8.2\%-4\%}=2476.2FirmValue=WACC−gFCFF0×(1+g)=8.2%−4%100×(1+4%)=2476.2当g = 6%时, Firm Value=FCFF0×(1+g)WACC−g=100×(1+6%)8.2%−6%=4818.2Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+6\%\right)}{8.2\%-6\%}=4818.2FirmValue=WACC−gFCFF0×(1+g)=8.2%−6%100×(1+6%)=4818.2Range =4818.2 - 2476.2 = 2342三者相比，敏感性最弱的是after-tcost of bt。考试时都要这样计算么还是可以有简便方法

2023-01-27 17:09 3 · 回答

NO.PZ2018103102000118 问题如下 Matt is concting a FCFF sensitivity analysis for Company M`s value. The most recent FCFF of Company M is $100 million. Assuming the trate is 35% ana stable capitstructure of 40% an60% equity, the company`s value is least sensitive to: A.cost of equity B.growth rate C.after-tcost of C is correct.考点Sensitivity Analysis in FCFF anFCFE解析1. Cost of equity敏感性分析保持r= 5.5%，g = 5.0%当re = 8.0%时，WA= 0.4*5.5% + 0.6*8.0% = 7%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)7%−5%=5250Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{7\%-5\%}=5250FirmValue=WACC−gFCFF0×(1+g)=7%−5%100×(1+5%)=5250当re = 12.0%时，WA= 0.4*5.5% + 0.6*12.0% = 9.4%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)9.4%−5%=2386.36Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{9.4\%-5\%}=2386.36FirmValue=WACC−gFCFF0×(1+g)=9.4%−5%100×(1+5%)=2386.36Range = 5250 – 2386.36 = 2863.642. After-tcost of bt敏感性分析保持re = 10%，g = 5%当r= 5.0%时，WA= 0.4*5.0% + 0.6*10.0% = 8%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)8%−5%=3500Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8\%-5\%}=3500FirmValue=WACC−gFCFF0×(1+g)=8%−5%100×(1+5%)=3500当r= 6.0%时，WA= 0.4*6.0% + 0.6*10.0% = 8.4%Firm Value=FCFF0×(1+g)WACC−g=100×(1+5%)8.4%−5%=3088.24Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+5\%\right)}{8.4\%-5\%}=3088.24FirmValue=WACC−gFCFF0×(1+g)=8.4%−5%100×(1+5%)=3088.24Range = 3500 – 3088.24 = 411.763. Growth rate敏感性分析保持re = 10%，r= 5.5%WA= 0.4*5.5% + 0.6*10.0% = 8.2%当g = 4%时, Firm Value=FCFF0×(1+g)WACC−g=100×(1+4%)8.2%−4%=2476.2Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+4\%\right)}{8.2\%-4\%}=2476.2FirmValue=WACC−gFCFF0×(1+g)=8.2%−4%100×(1+4%)=2476.2当g = 6%时, Firm Value=FCFF0×(1+g)WACC−g=100×(1+6%)8.2%−6%=4818.2Firm\;Value=\frac{FCFF_0\times\left(1+g\right)}{WACC-g}=\frac{100\times\left(1+6\%\right)}{8.2\%-6\%}=4818.2FirmValue=WACC−gFCFF0×(1+g)=8.2%−6%100×(1+6%)=4818.2Range =4818.2 - 2476.2 = 2342三者相比，敏感性最弱的是after-tcost of bt。 re是波动了（-2%，+2%）， r（1-T）波动了（-0.5%，+0.5%），g波动了（-1%，+1%）如果把算出来的波动结果标准化，针对re（5250-2386.3626）/4针对r（1-T)（3500-3088.2353)/1针对g（4818.1818-2476.1905）/2

2022-08-08 01:59 1 · 回答