您的当前位置:首页财务分析表模板1

财务分析表模板1

2021-03-15 来源:乌哈旅游
表B22 FIRR敏感性分析表 变化率变化因素建设投资经营成本销售收入-30%433.29%354.00%284.43%-20%401.49%353.65%308.65%-10%375.18%353.31%331.42%0%352.96%352.96%352.96%500.00%450.00%400.00%350.00%300.00%系列1系列2系列3250.00%200.00%150.00%100.00%50.00%0.00%1234567表 B9 项目投资现金流量表

序号11.1现金流入营业收入-30%-20%项 目12316000.0016000.0011200.0012800.00420000.0020000.0014000.0016000.00-10%10%20%30%销售价格产量1.2补贴收入1.3回收固定资产余值1.4回收流动资金2现金流出2.1建设投资-30%-20%-10%10%20%30%2.2流动资金2.3经营成本-30%-20%-10%10%20%30%2.4营业税金及附加2.5维持运营投资3所得税前净现金流量(1-2)建设投资(-30%)净现金流建设投资(-20%)净现金流建设投资(-10%)净现金流建设投资(10%)净现金流建设投资(20%)净现金流建设投资(30%)净现金流经营成本(-30%)净现金流经营成本(-20%)净现金流经营成本(-10%)净现金流经营成本(10%)净现金流

900.00900.00630.00720.00810.00990.001080.001170.00

-900.00-630.00-720.00-810.00-990.00-1080.00-1170.00-900.00-900.00-900.00-900.00

600.00600.00420.00480.00540.00660.00720.00780.00

-600.00-420.00-480.00-540.00-660.00-720.00-780.00-600.00-600.00-600.00-600.00

14400.0017600.0019200.0020800.00

20.00800.00

354.8530.00256.41179.49205.13230.77282.05307.69333.3368.4415645.1515645.1515645.1515645.1515645.1515645.1515645.1515722.0815696.4415670.7915619.51

18000.0022000.0024000.0026000.0020.001000.00

433.44

6.13341.88239.32273.50307.69376.07410.26444.4485.4419566.5619566.5619566.5619566.5619566.5619566.5619566.5619669.1219634.9319600.7519532.37

经营成本(20%)净现金流经营成本(30%)净现金流销售收入(-30%)净现金流销售收入(-20%)净现金流销售收入(-10%)净现金流销售收入(10%)净现金流销售收入(20%)净现金流销售收入(30%)净现金流

-900.00-900.00-900.00-900.00-900.00-900.00-900.00-900.00

-600.00-600.00-600.00-600.00-600.00-600.00-600.00-600.00

15623.8715568.2310845.1512445.1514045.1517245.1518845.1520445.15

19504.3119463.9913566.5615566.5617566.5621566.5623566.5625566.56

10%333.87%352.61%373.46%20%317.25%352.57%393.04%30%302.60%351.92%411.84%系列1系列2系列3人民币单位:万元

计 算 期520000.0020000.0014000.0016000.00

620000.0020000.0014000.0016000.00

720000.0020000.0014000.0016000.00

820000.0020000.0014000.0016000.00

920000.0020000.0014000.0016000.00

1020000.0020000.0014000.0016000.00

1120000.0020000.0014000.0016000.00

18000.0022000.0024000.0026000.00

20.001000.00

521.389.03427.35299.15341.88384.62470.09512.82555.5685.0019478.6219478.6219478.6219478.6219478.6219478.6219478.6219606.8219564.0919521.3519435.88

18000.0022000.0024000.0026000.0020.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35

427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

19402.1819350.4113478.6215478.6217478.6221478.6223478.6225478.62

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

1220000.0020000.0014000.0016000.00

1320000.0020000.0014000.0016000.00

1420000.0020000.0014000.0016000.00

1520000.0020000.0014000.0016000.00

1620000.0020000.0014000.0016000.00

1720000.0020000.0014000.0016000.00

1820000.0020000.0014000.0016000.00

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.0020.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.00

20.001000.00

512.35

427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

1920000.0020000.0014000.0016000.00

2020288.6220000.0014000.0016000.00

18000.0022000.0024000.0026000.00

20.001000.00

512.35427.35299.15341.88384.62470.09512.82555.5685.0019487.6519487.6519487.6519487.6519487.6519487.6519487.6519615.8519573.1219530.3819444.91

18000.0022000.0024000.0026000.0020.001000.00243.4645.16

512.35

427.35299.15341.88384.62470.09512.82555.5685.0019776.2719776.2719776.2719776.2719776.2719776.2719776.2719904.4819861.7419819.0119733.54

19402.1819359.4413487.6515487.6517487.6521487.6523487.6525487.65

19690.8019648.0713776.2715776.2717776.2721776.2723776.2725776.27

因篇幅问题不能全部显示,请点此查看更多更全内容