建安工程费敏感性分析.xls

序号项目计算期20142015201620171现金流入00539001566001.1销售收入00539001566002现金流出75422.5454630376.077543597.851547696.552922.1建设投资75422.5454630376.077533764.577522613.484172.2销售税金及附加001387.2883968.103752.3土地增值税8445.98621114.9653税前净现金流量-75422.54546-30376.077510302.1485108903.44714累计税前净现金流量-75422.54546-75422.54546-65120.3969643783.050125所得税002575.53712527225.861776税后净现金流-75422.54546-30376.07757726.61137581677.585317累计税后净现金流-72367.43083-102743.5083-95016.89696-13339.31165810%10.9090909090.8264462810.7513148019税前净现金流量现值-75422.54546-27614.615918514.17231481820.77166910累计税前净现金流量现值-75422.54546-103037.1614-94522.98906-12702.2173911税后净现金流量现值-75422.54546-27614.615916385.62923661365.5787512累计税后净现金流量现值-75422.54546-103037.1614-96651.53213-35285.953392018983509835019460.94754380.142411.828512668.97978889.0525122672.102619722.2631259166.7893745827.477730.68301345553882.2843441180.0669440411.713255125.759866 序号项目计算期20142015201620171现金流入00539001566001.1销售收入00539001566002现金流出74404.1739230376.077543597.851547696.552922.1建设投资74404.1739230376.077533764.577522613.484172.2销售税金及附加001387.2883968.103752.3土地增值税8445.98621114.9653税前净现金流量-74404.17392-30376.077510302.1485108903.44714累计税前净现金流量-74404.17392-74404.17392-64102.0254244801.421665所得税002575.53712527225.861776税后净现金流-74404.17392-30376.07757726.61137581677.585317累计税后净现金流-72367.43083-102743.5083-95016.89696-13339.31165810%10.9090909090.8264462810.7513148019税前净现金流量现值-74404.17392-27614.615918514.17231481820.77166910累计税前净现金流量现值-74404.17392-102018.7898-93504.61752-11683.8458511税后净现金流量现值-74404.17392-27614.615916385.62923661365.5787512累计税后净现金流量现值-74404.17392-102018.7898-95633.16059-34267.581852018983509835019460.94754380.142411.828512668.97978889.0525123690.474219722.2631259166.7893745827.477730.68301345553882.2843442198.4384840411.713256144.131406 序号项目计算期20142015201620171现金流入00539001566001.1销售收入00539001566002现金流出73385.8023830376.077543597.851547696.552922.1建设投资73385.8023830376.077533764.577522613.484172.2销售税金及附加001387.2883968.103752.3土地增值税8445.98621114.9653税前净现金流量-73385.80238-30376.077510302.1485108903.44714累计税前净现金流量-73385.80238-73385.80238-63083.6538845819.79325所得税002575.53712527225.861776税后净现金流-73385.80238-30376.07757726.61137581677.585317累计税后净现金流-72367.43083-102743.5083-95016.89696-13339.31165810%10.9090909090.8264462810.7513148019税前净现金流量现值-73385.80238-27614.615918514.17231481820.77166910累计税前净现金流量现值-73385.80238-101000.4183-92486.24598-10665.4743111税后净现金流量现值-73385.80238-27614.615916385.62923661365.5787512累计税后净现金流量现值-73385.80238-101000.4183-94614.78905-33249.210312018983509835019460.94754380.142411.828512668.97978889.0525124708.845719722.2631259166.7893745827.477730.68301345553882.2843443216.8100240411.713257162.502946 序号项目计算期20142015201620171现金流入00539001566001.1销售收入00539001566002现金流出71349.0592930376.077543597.851547696.552922.1建设投资71349.0592930376.077533764.577522613.484172.2销售税金及附加001387.2883968.103752.3土地增值税8445.98621114.9653税前净现金流量-71349.05929-30376.077510302.1485108903.44714累计税前净现金流量-71349.05929-71349.05929-61046.9107947856.536295所得税002575.53712527225.861776税后净现金流-71349.05929-30376.07757726.61137581677.585317累计税后净现金流-72367.43083-102743.5083-95016.89696-13339.31165810%10.9090909090.8264462810.7513148019税前净现金流量现值-71349.05929-27614.615918514.17231481820.77166910累计税前净现金流量现值-71349.05929-98963.6752-90449.50289-8628.73122511税后净现金流量现值-71349.05929-27614.615916385.62923661365.5787512累计税后净现金流量现值-71349.05929-98963.6752-92578.04596-31212.467222018983509835019460.94754380.142411.828512668.97978889.0525126745.588819722.2631259166.7893745827.477730.68301345553882.2843445253.5531140411.713259199.246036 序号项目计算期20142015201620171现金流入00539001566001.1销售收入00539001566002现金流出72367.4308330376.077542720.601546819.302922.1建设投资72367.4308330376.077532887.327521736.234172.2销售税金及附加001387.2883968.103752.3土地增值税8445.98621114.9653税前净现金流量-72367.43083-30376.077511179.3985109780.69714累计税前净现金流量-72367.43083-72367.43083-61188.0323348592.664755所得税002794.84962527445.174276税后净现金流-72367.43083-30376.07758384.54887582335.522817累计税后净现金流-72367.43083-102743.5083-94358.95946-12023.43665810%10.9090909090.8264462810.7513148019税前净现金流量现值-72367.43083-27614.615919239.17231482479.86257910累计税前净现金流量现值-72367.43083-99982.04674-90742.87443-8263.01185611税后净现金流量现值-72367.43083-27614.615916929.37923661859.8969312累计税后净现金流量现值-72367.43083-99982.04674-93052.6675-31192.770582018983509835018583.69753502.892411.828512668.97979766.3025128358.967319941.5756359824.7268847801.290230.68301345554481.4578946218.4460440861.093429668.322843 序号项目计算期20142015201620171现金流入00539001566001.1销售收入00539001566002现金流出72367.4308330376.077542720.601546819.302922.1建设投资72367.4308330376.077532887.327521736.234172.2销售税金及附加001387.2883968.103752.3土地增值税8445.98621114.9653税前净现金流量-72367.43083-30376.077511179.3985109780.69714累计税前净现金流量-72367.43083-72367.43083-61188.0323348592.664755所得税002794.84962527445.174276税后净现金流-72367.43083-30376.07758384.54887582335.522817累计税后净现金流-72367.43083-102743.5083-94358.95946-12023.43665810%10.9090909090.8264462810.7513148019税前净现金流量现值-72367.43083-27614.615919239.17231482479.86257910累计税前净现金流量现值-72367.43083-99982.04674-90742.87443-8263.01185611税后净现金流量现值-72367.43083-27614.615916929.37923661859.8969312累计税后净现金流量现值-72367.43083-99982.04674-93052.6675-31192.770582018983509835018583.69753502.892411.828512668.97979766.3025128358.967319941.5756359824.7268847801.290230.68301345554481.4578946218.4460440861.093429668.322843序号项目名称总投资20142015201620171总投资160869.9678864.6412740066.0462244535.4777229827.185621.1土地费用52000520000001.2前期工程费5048.565048.560001.3建筑安装工程费66906.5611151.0933322302.1866722302.1866711151.093331.4管理费用4958.2991.64991.64991.64991.641.5财务费用11718.3403906.1133333906.1133333906.1133331.6销售费用10165.5003388.53388.51.7开发期间税费2367.82591.955591.955591.955591.9551.8其他费用2676.26669.065669.065669.065669.0651.9不可预见费7660.471915.11751915.11751915.11751915.117520185777.40466000991.6403388.5000