. .. .. .
3、第142页第3题 此题为上题的延续，估值模型如图10-7，其中G62 =H61/($B$60-$B$15),G61 =G59/(1+$C$60)^G51 B63 =SUM(C61:G61)+G62 敏感性分析，建立数据表来进行分析。如图10-8所示 图10-7 .下载可编辑.
. .. .. .
图10-8 实验结果：如图10-9和10-10所示 年自由现金流量加权资本成本现值6年以后现值合计企业价值评估模型0123456232.92248.09263.87280.24297.12314.4615 2.54187.59173.50160.23147.72135.952718.963590.54 图10-9 .下载可编辑.
. .. .. .
敏感性分析资本成本增长率3590.548%9 %1158.322770.5832469.5982229.2612032.9681869.6561731.671613.5481511.2871421.8891343.0631273.031210.38826034909599'1610$2119!8568933133.2591698.0161582.2341481.9941394.3571317.0811248.4213B26.6913529.8483033.0122661.072372.3022141.6841953.3011796.5451664.0811550.671452.4761366.6241290.9164Q61.4734137.2253455.5432969.4782605.5692323.0142097.341912.981759.561629.9051518.8911422.7651338.7165g19.4455048.2934047.0883380.692905.4862549.6782273.3892052.7021872.3991722.3451595.5241486.9281392.896?35.4376566.7754934.4323956.413305.3942841.1192493.4662223.4872007.821831.6051684.9391560.9721454.8127183.619603.8416413.4124820.0463865.3123229.7492776.4572436.9992173.3611962.7421790.6351647.3781526.2818%#DIV/0!18715.359371.5386259.5564705.2793773.9033153.8412711.572380.3372123.0631917.511749.531609.6949%-18210.1#DIV/0!18246.379138.816105.3874590.263682.2823077.7522646.5232323.5322072.6391872.1661708.32210%-8862.01-17732.1#DIV/0!17777.188905.9145951.0684475.1063590.5393001.5512581.3752266.6362022.1311826.74511%-5746.21-8620.72-17254.8#DIV/0!17308.278673.085796.7484359.9253498.7562925.3062516.1812209.6931971.57712%-4188.49-5583.87-8380.14-16778.7#DIV/0!16840.068440.5175642.5624244.8133407.0092849.0752450.9892152.74513%-3254.04-4065.67-5422.24-8140.46-16304.1#DIV/0!16372.958208.4125488.6294129.8583315.3652772.9152385.84414%-2631.25-3154.98-3943.58-5261.45-7901.87-15831.4#DIV/0!15907.297976.9355335.064015.1413223.8852696.87315%-2186.57-2548.06-3056.65-3822.29-5101.62-7664.56-15360.9#DIV/0!15443.397746.2385181.9543900.7323132.62616%-1853.22-2114.75-2465.61-2959.11-3701.89-4942.84-7428.65-14893#DIV/0!14981.527516.4595029.3993786.69817%-1594.12-1789.96-2043.68-2383.94-2862.41-3582.44-4785.2-7194.29-14427.8#DIV/0!14521.957287.7214877.47718%-1387-1537.54-1727.46-1973.38-2303.1-2766.61-3463.99-4628.77-6961.59-13965.7#DIV/0!14064.887060.13319%-1217.7-1335.81-1481.74-1665.73-1903.9-2223.1-2671.73-3346.6-4473.63-6730.64-13506.8#DIV/0!13610.5320%-1076.79-1170.94-1285.39-1426.71-1604.8-1835.24-2143.98-2577.82-3230.31-4319.83-6501.54-13051.3#DIV/0!图10-10 六、实验结果与讨论 .下载可编辑.
. .. .. .
七、实验报告成绩（请按优，良，中，及格，不及格五级评定） .下载可编辑.
. .. .. .
教师签字__________
.下载可编辑.