资本金与投资现金流量表.xls

资本金现金流量表 序号项 目计算期123456789101 1现现金金流流入入0 00 0380038004320432054005400540054005400540054005400540054005861.0825861.0821.1产品销售收入380043205400540054005400540054001.2回收固定资产余值161.0821.3回收流动资金3001.4补贴收入2 2现现金金流流出出9309306206203641.7253641.7253480.53480.53784.4753784.4753769.853769.853755.21753755.21753740.59253740.59253447.35753447.35753447.35753447.35752.1资本金9306203002.2借款本金偿还278.61278.61278.61278.61278.61278.612.3借款利息利息偿还117.0197.5178.0158.513919.52.4经营成本260026002600260026002600260026002.5销售税金及附加6%228259.23243243243243243242.6所得税25%118.105245.18503.855508.73513.6075518.4825523.3575523.35752.7维持运营投资00000000003 3净净现现金金流流量量（1-2）-930.00-930.00-620.00-620.00158.28158.28839.50839.501615.531615.531630.151630.151644.781644.781659.411659.411952.641952.642413.722413.724 4累累计计净净现现金金流流量量-930.00-930.00-1550.00-1550.00-1391.73-1391.73-552.23-552.231063.301063.302693.452693.454338.234338.235997.645997.647950287950.2810364.0110364.015 5折折现现系系数数ic=10%0.910.910.830.830.750.750.680.680.620.620.560.560.510.510.470.470.420.420.390.396 6折折现现净净现现金金流流量量=3*53*5-845.45-845.45-512.40-512.40118.91118.91573.39573.391003.111003.11920.18920.18844.03844.03774.13774.13828.11828.11930.60930.607 7累累计计折折现现净净现现金金流流量量-845.45-845.45-1357.85-1357.85-1238.94-1238.94-665.55-665.55337.57337.571257.741257.742101.782101.782875.902875.903704.013704.014634.614634.61 项项目目投投资资现现金金流流量量表表单位：万元序号 项目计算期（注5）项 目计算期1234567891011121现金流入1.1销售收入1.2补贴收入1.3回收固定资产余值（注6）1.4回收流动资金（注6）2现金流出2.1建设资产投资2.2流动资金投资2.3经营成本2.4销售税金及附加（6%计算）2.5维持运营投资2.6调整所得税（25%）3所得税前净现金流量4累计所得税前净现金流量5基准收益率（10%）6折现后现金流量7累计所得税后净现金流量资本金现金流量表投资现金流量表序号项 目建设期运营期序号 项目计算期（注5）项 目建设期运营期12121 1现现金金流流入入9109101现金流入1.1产品销售收入9101.1销售收入1.2补贴收入01.2补贴收入1.3回收固定资产余值01.3回收固定资产余值（注6）1.4回收流动资金01.4回收流动资金（注6）2 2现现金金流流出出1034.271034.272现金流出2.1资本金2002.1建设资产投资2.2借款本金偿还316.422.2流动资金投资2.3借款利息利息偿还75.942.3维持运营2.4经营成本367.52.4经营成本2.5销售税金及附加6%54.62.5 销售税金及附加（6%计算）2.6所得税25%19.812.6调整所得税（25%）3 3净净现现金金流流量量（1-2）-124.27-124.273所得税前净现金流量4 4累累计计净净现现金金流流量量4累计所得税前净现金流量5 5折折现现系系数数ic=10%5基准收益率（10%）6 6折折现现净净现现金金流流量量=3*5=3*56折现后现金流量7 7累累计计折折现现净净现现金金流流量量7累计所得税后净现金流量总总成成本本费费用用=经经营营成成本本+折折旧旧+摊摊销销+营营业业税税金金及及附附加加+运运营营维维持持投投资资息息税税前前利利润润=营营业业收收入入+补补贴贴收收入入+利利息息-总总成成本本费费用用-营营业业税税及及附附加加