营业收入敏感性分析.xls

序号项目计算期20142015201620171现金流入0.000.0061985.00180090.001.1销售收入0.000.0053900.00156600.002现金流出72367.4330376.0842720.6046819.302.1建设投资72367.4330376.0832887.3321736.232.2销售税金及附加0.000.001387.293968.102.3土地增值税8445.9921114.973税前净现金流量-72367.43-30376.0819264.40133270.704累计税前净现金流量-72367.43-72367.43-53103.0380167.665所得税0.000.004816.1033317.676税后净现金流-72367.43-30376.0814448.3099953.027累计税后净现金流-72367.43-102743.51-88295.2111657.81810%1.000.910.830.759税前净现金流量现值-72367.43-27614.6215920.99100128.25910累计税前净现金流量现值-72367.43-99982.05-84061.0616067.1911税后净现金流量现值-72367.43-27614.6211940.7475096.1912累计税后净现金流量现值-72367.43-99982.05-88041.30-12945.122018113102.5098350.0018583.703502.892411.8312668.9894518.80174686.4723629.7070889.1082546.920.6864557.6180624.8048418.2135473.09 序号项目计算期20142015201620171现金流入0.000.0053900.00156600.001.1销售收入0.000.0053900.00156600.002现金流出72367.4330376.0842720.6046819.302.1建设投资72367.4330376.0832887.3321736.232.2销售税金及附加0.000.001387.293968.102.3土地增值税8445.9921114.973税前净现金流量-72367.43-30376.0811179.40109780.704累计税前净现金流量-72367.43-72367.43-61188.0348592.665所得税0.000.007859.3624301.556税后净现金流-72367.43-30376.083320.0485479.157累计税后净现金流-72367.43-102743.51-99423.47-13944.32810%1.000.910.830.759税前净现金流量现值-72367.43-27614.629239.1782479.86910累计税前净现金流量现值-72367.43-99982.05-90742.87-8263.0111税后净现金流量现值-72367.43-27614.622743.8364221.7512累计税后净现金流量现值-72367.43-99982.05-97238.21-33016.46201898350.0098350.0018583.703502.892411.8312668.9879766.30128358.9715290.6964475.6150531.290.6854481.4646218.4544037.7111021.25 序号项目计算期20142015201620171现金流入0.000.0051450.00149887.501.1销售收入0.000.0049000.00142750.002现金流出72367.4330376.0841653.2744150.972.1建设投资72367.4330376.0832887.3321736.232.2销售税金及附加0.000.001387.293968.102.3土地增值税0.000.007378.6518446.633税前净现金流量-72367.43-30376.089796.73105736.534累计税前净现金流量-72367.43-72367.43-62570.7043165.845所得税0.000.007859.3624301.556税后净现金流-72367.43-30376.081937.3781434.987累计税后净现金流-72367.43-102743.51-100806.13-19371.158折现系数i=8%1.000.930.860.799税前净现金流量现值-72367.43-28128.258395.8083933.66910累计税前净现金流量现值-72367.43-100495.68-92099.88-8166.2211税后净现金流量现值-72367.43-28128.251660.3364643.0912累计税后净现金流量现值-72367.43-100495.68-98835.35-34192.26201894710.0090200.0016982.703502.892411.8311067.9877727.30120893.1415290.6962436.6143065.460.7457129.5748963.3545890.9111698.65 序号项目计算期20142015201620171现金流入0046550135612.51.1销售收入00490001427502现金流出72367.4308330376.077541653.265544150.967922.1建设投资72367.4308330376.077532887.327521736.234172.2销售税金及附加001387.2883968.103752.3土地增值税007378.6518446.633税前净现金流量-72367.43083-30376.07754896.734591461.532084累计税前净现金流量-72367.43083-72367.43083-67470.6963323990.835755所得税007859.3624301.556税后净现金流-72367.43083-30376.0775-2962.625567159.982087累计税后净现金流-72367.43083-102743.5083-105706.1338-38546.151758折现系数i=8%10.9260.8570.79389税前净现金流量现值-72367.43083-28128.247774196.50146672602.16417910累计税前净现金流量现值-72367.43083-100495.6786-96299.17713-23697.0129611税后净现金流量现值-72367.43083-28128.24777-2538.97005453311.5937812累计税后净现金流量现值-72367.43083-100495.6786-103034.6486-49723.054872018856909020016982.69853502.892411.828511067.9868707.301592698.1372515290.6953416.611514870.459750.73550499.866626802.8536439261.20945-10461.84542 序号项目计算期20142015201620171现金流入00441001284751.1销售收入00490001427502现金流出72367.4308330376.077541653.265544150.967922.1建设投资72367.4308330376.077532887.327521736.234172.2销售税金及附加001387.2883968.103752.3土地增值税007378.6518446.633税前净现金流量-72367.43083-30376.07752446.734584324.032084累计税前净现金流量-72367.43083-72367.43083-69920.6963314403.335755所得税007859.3624301.556税后净现金流-72367.43083-30376.0775-5412.625560022.482087累计税后净现金流-72367.43083-102743.5083-108156.1338-48133.651758折现系数i=8%10.9260.8570.79389税前净现金流量现值-72367.43083-28128.247772096.85146666936.41667910累计税前净现金流量现值-72367.43083-100495.6786-98398.82713-31462.4104611税后净现金流量现值-72367.43083-28128.24777-4638.62005447645.8462812累计税后净现金流量现值-72367.43083-100495.6786-105134.2986-57488.452372018811809020016982.69853502.892411.828511067.9864197.301578600.6372515290.6948906.6115772.959750.73547185.016615722.6061435946.35945-21542.09292 序号项目计算期20142015201620171现金流入0041650121337.51.1销售收入00490001427502现金流出72367.4308330376.077541653.265544150.967922.1建设投资72367.4308330376.077532887.327521736.234172.2销售税金及附加001387.2883968.103752.3土地增值税007378.6518446.633税前净现金流量-72367.43083-30376.0775-3.265577186.532084累计税前净现金流量-72367.43083-72367.43083-72370.696334815.835755所得税007859.3624301.556税后净现金流-72367.43083-30376.0775-7862.625552884.982087累计税后净现金流-72367.43083-102743.5083-110606.1338-57721.151758折现系数i=8%10.9260.8570.79389税前净现金流量现值-72367.43083-28128.24777-2.798533561270.66917910累计税前净现金流量现值-72367.43083-100495.6786-100498.4771-39227.8079611税后净现金流量现值-72367.43083-28128.24777-6738.27005441980.0987812累计税后净现金流量现值-72367.43083-100495.6786-107233.9486-65253.849872018766709020016982.69853502.892411.828511067.9859687.301564503.1372515290.6944396.6115-13324.540250.73543870.16664642.35863932631.50945-32622.34042