一般项目-可行性研究报告的各种财务分析(含计算公式)

上传人：A*** IP属地：辽宁上传时间：2024-04-17 格式：XLS 页数：32 大小：460.50KB 积分：15 举报 版权申诉

已阅读5页，还剩27页未读，继续免费阅读

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

表14-6,,,,,,,,,,,,,,,,,

项目投资现金流量表,,,,,,,,,,,,,,,,,

序号,项目,合计,建设期,经营期,,,,,,,,,,,,,

,,,1,2,3,4,5,6,7,8,9,10,11,12,,,

1,现金流入,89542,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

1.1,营业收入,86395,,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,8554,,,

1.2,补贴收入,0,0,0,0,0,0,0,0,0,0,0,0,0,,,

1.3,回收固定资产余值,1079,,,,,,,,,,,,1079,,,

1.4,回收流动资金,2067,,,,,,,,,,,,2067,,,

1.5,土地摊余价值,0,,,,,,,,,,,,0,,,

2,现金流出,81429,3500,1044,7689,7688,7688,7688,7688,7688,7688,7688,7688,7688,,,

2.1,建设投资,3500,3500,,,,,,,,,,,,,,

2.2,流动资金,8370,,270,810,810,810,810,810,810,810,810,810,810,,,

2.3,经营成本,65228,,731,6450,6450,6450,6450,6450,6450,6450,6450,6450,6450,,,

2.4,营业税金及附加,4331,,43,429,429,429,429,429,429,429,429,429,429,,,

2.5,维持运营投资,,,,,,,,,,,,,,,,

3,所得税前净现金流量（1-2）,8113,-3500,-188,865,866,866,866,866,866,866,866,866,4012,,,

4,累计所得税前净现金流量,8113,-3500,-3688,-2823,-1958,-1092,-227,639,1504,2370,3235,4101,8113,,,

5,调整所得税,2235,,0,223,223,223,223,223,223,223,223,223,223,,,

6,所得税后净现金流量（3-5）,5878,-3500,-188,642,642,642,642,642,642,642,642,642,3788,,,

7,累计所得税后净现金流量,5878,-3500,-3688,-3047,-2405,-1763,-1121,-479,163,806,1448,2090,5878,,,

计算指标：,,,,,,,,,,,,,,,,,

项目投资财务内部收益率（所得税前）,,,,18.8%,,,,,,,,,,,,,

项目投资财务内部收益率（所得税后）,,,,14.1%,,,,,,,,,,,,,

项目投资财务净现值（所得税前）（ic=12%),,,,"1,430.7",,,,,,,,,,,,,

项目投资财务净现值（所得税后）（ic=12%),,,,424.1,,,,,,,,,,,,,

项目投资回收期（年）（所得税前）=,,,,5.3,,,,,,,,,,,,,

项目投资回收期（年）（所得税后）=,,,,6.7,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

,,,-3500,-3500,865,866,866,866,866,866,866,866,866,4012,,,

,,,-3500,-3500,642,642,642,642,642,642,642,642,642,3788,,,

,,,,,,,,,,,,,,,内部收益率,财务净现值,投资回收期

,营业收入,15%,,,,,,,,,,,,,,,

,,营业收入,,,9837.1,9837.1,9837.1,9837.1,9837.1,9837.1,9837.1,9837.1,9837.1,9837.1,,,

,,现金流入,0,0,9837,9837,9837,9837,9837,9837,9837,9837,9837,12983,,,

,,现金流出,3500,1001,8404,8399,8399,8399,8399,8399,8399,8399,8399,8399,,,

,,所得税,,,685.783896,687.5329587,687.5329587,687.5329587,687.5329587,687.5329587,687.5329587,687.5329587,687.5329587,687.5329587,,,

,,销售税金,,,458.6794788,451.6832278,451.6832278,451.6832278,451.6832278,451.6832278,451.6832278,451.6832278,451.6832278,451.6832278,,,

,,净现金流量,-3500,-1001,1433,1438,1438,1438,1438,1438,1438,1438,1438,4584,25.43%,4292.97,5.13

,,累计,-3500,-4501,-3068,-1630,-192,1247,2685,4123,5561,7000,8438,13022,,,

,,10%,,,,,,,,,,,,,,,

,,营业收入,,,9409.4,9409.4,9409.4,9409.4,9409.4,9409.4,9409.4,9409.4,9409.4,9409.4,,,

,,现金流入,0,0,9409,9409,9409,9409,9409,9409,9409,9409,9409,12556,,,

,,现金流出,3500,1001,8252,8247,8247,8247,8247,8247,8247,8247,8247,8247,,,

,,所得税,,,593.871166,595.6202287,595.6202287,595.6202287,595.6202287,595.6202287,595.6202287,595.6202287,595.6202287,595.6202287,,,

,,销售税金,,,398.6303988,391.6341478,391.6341478,391.6341478,391.6341478,391.6341478,391.6341478,391.6341478,391.6341478,391.6341478,,,

,,净现金流量,-3500,-1001,1157,1162,1162,1162,1162,1162,1162,1162,1162,4309,20.74%,2892.73,5.88

,,累计,-3500,-4501,-3344,-2181,-1019,144,1306,2469,3631,4794,5956,10265,,,

,,5%,,,,,,,,,,,,,,,

,,营业收入,,,8981.7,8981.7,8981.7,8981.7,8981.7,8981.7,8981.7,8981.7,8981.7,8981.7,,,

,,现金流入,0,0,8982,8982,8982,8982,8982,8982,8982,8982,8982,12128,,,

,,现金流出,3500,1001,8100,8095,8095,8095,8095,8095,8095,8095,8095,8095,,,

,,所得税,,,501.958436,503.7074987,503.7074987,503.7074987,503.7074987,503.7074987,503.7074987,503.7074987,503.7074987,503.7074987,,,

,,销售税金,,,338.5813188,331.5850678,331.5850678,331.5850678,331.5850678,331.5850678,331.5850678,331.5850678,331.5850678,331.5850678,,,

,,净现金流量,-3500,-4544,881,887,887,887,887,887,887,887,887,4033,6.05%,1920.79,11.08

,,累计,-3500,-8044,-7163,-6276,-5389,-4502,-3616,-2729,-1842,-955,-69,3964,,,

,,-5%,,,,,,,,,,,,,,,

,,营业收入,,,8126.3,8126.3,8126.3,8126.3,8126.3,8126.3,8126.3,8126.3,8126.3,8126.3,,,

,,现金流入,0,0,8126,8126,8126,8126,8126,8126,8126,8126,8126,11273,,,

,,现金流出,3500,1001,7796,7791,7791,7791,7791,7791,7791,7791,7791,7791,,,

,,所得税,,,318.132976,319.8820387,319.8820387,319.8820387,319.8820387,319.8820387,319.8820387,319.8820387,319.8820387,319.8820387,,,

,,销售税金,,,218.4831588,211.4869078,211.4869078,211.4869078,211.4869078,211.4869078,211.4869078,211.4869078,211.4869078,211.4869078,,,

,,净现金流量,-3500,-1001,330,335,335,335,335,335,335,335,335,3481,4.54%,-1308.00,-7.44

,,累计,-3500,-4501,-4171,-3836,-3500,-3165,-2830,-2495,-2159,-1824,-1489,1993,,,

,,-10%,,,,,,,,,,,,,,,

,,营业收入,,,7698.6,7698.6,7698.6,7698.6,7698.6,7698.6,7698.6,7698.6,7698.6,7698.6,,,

,,现金流入,0,0,7699,7699,7699,7699,7699,7699,7699,7699,7699,10845,,,

,,现金流出,3500,1001,7644,7639,7639,7639,7639,7639,7639,7639,7639,7639,,,

,,所得税,,,226.220246,227.9693087,227.9693087,227.9693087,227.9693087,227.9693087,227.9693087,227.9693087,227.9693087,227.9693087,,,

,,销售税金,,,158.4340788,151.4378278,151.4378278,151.4378278,151.4378278,151.4378278,151.4378278,151.4378278,151.4378278,151.4378278,,,

,,净现金流量,-3500,-1001,54,60,60,60,60,60,60,60,60,3206,-1.83%,-2708.24,

,,累计,-3500,-4501,-4447,-4387,-4328,-4268,-4209,-4149,-4090,-4030,-3970,-765,,,

,,-15%,,,,,,,,,,,,,,,

,,营业收入,,,7270.9,7270.9,7270.9,7270.9,7270.9,7270.9,7270.9,7270.9,7270.9,7270.9,,,

,,现金流入,0,0,7271,7271,7271,7271,7271,7271,7271,7271,7271,10417,,,

,,现金流出,3500,1001,7492,7487,7487,7487,7487,7487,7487,7487,7487,7487,,,

,,所得税,,,134.307516,136.0565787,136.0565787,136.0565787,136.0565787,136.0565787,136.0565787,136.0565787,136.0565787,136.0565787,,,

,,销售税金,,,98.38499878,91.38874782,91.38874782,91.38874782,91.38874782,91.38874782,91.38874782,91.38874782,91.38874782,91.38874782,,,

,,净现金流量,-3500,-1001,-221,-216,-216,-216,-216,-216,-216,-216,-216,2930,-8.82%,-4108.48,

,,累计,-3500,-4501,-4722,-4939,-5155,-5371,-5587,-5803,-6020,-6236,-6452,-3522,,,

,建设投资,15%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,4025,1044,7912,7912,7912,7912,7912,7912,7912,7912,7912,7912,,,

,,建设投资,4025,0,,,,,,,,,,,,,

,,净现金流量,-4025,-188,642,642,642,642,642,642,642,642,642,3788,11.80%,447.79,8.56

,,累计,-4025,-4213,-3572,-2930,-2288,-1646,-1004,-362,281,923,1565,5353,,,

,,10%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3850,1044,7912,7912,7912,7912,7912,7912,7912,7912,7912,7912,,,

,,建设投资,3850,0,,,,,,,,,,,,,

,,净现金流量,-3850,-188,642,642,642,642,642,642,642,642,642,3788,12.51%,606.88,8.29

,,累计,-3850,-4038,-3397,-2755,-2113,-1471,-829,-187,456,1098,1740,5528,,,

,,5%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3675,1044,7912,7912,7912,7912,7912,7912,7912,7912,7912,7912,,,

,,建设投资,3675,0,,,,,,,,,,,,,

,,净现金流量,-3675,-188,642,642,642,642,642,642,642,642,642,3788,13.27%,765.97,8.02

,,累计,-3675,-3863,-3222,-2580,-1938,-1296,-654,-12,631,1273,1915,5703,,,

,,-5%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3325,1044,7912,7912,7912,7912,7912,7912,7912,7912,7912,7912,,,

,,建设投资,3325,0,,,,,,,,,,,,,

,,净现金流量,-3325,-188,642,642,642,642,642,642,642,642,642,3788,14.94%,1084.16,7.47

,,累计,-3325,-3513,-2872,-2230,-1588,-946,-304,338,981,1623,2265,6053,,,

,,-10%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3150,1044,7912,7912,7912,7912,7912,7912,7912,7912,7912,7912,,,

,,建设投资,3150,0,,,,,,,,,,,,,

,,净现金流量,-3150,-188,642,642,642,642,642,642,642,642,642,3788,15.87%,1243.25,7.20

,,累计,-3150,-3338,-2697,-2055,-1413,-771,-129,513,1156,1798,2440,6228,,,

,,-15%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,2975,1044,7912,7912,7912,7912,7912,7912,7912,7912,7912,7912,,,

,,建设投资,2975,0,,,,,,,,,,,,,

,,净现金流量,-2975,-188,642,642,642,642,642,642,642,642,642,3788,16.88%,1402.34,6.93

,,累计,-2975,-3163,-2522,-1880,-1238,-596,46,688,1331,1973,2615,6403,,,

,,,,,,,,,,,,,,,,,,

,经营成本,15%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3500,313,8880,8879,8879,8879,8879,8879,8879,8879,8879,8879,,,

,,经营成本,,,7417.11697,7417.11697,7417.11697,7417.11697,7417.11697,7417.11697,7417.11697,7417.11697,7417.11697,7417.11697,,,

,,净现金流量,-3500,542,-326,-325,-325,-325,-325,-325,-325,-325,-325,2821,-9.42%,-3383.70,

,,累计,-3500,-2958,-3283,-3609,-3934,-4260,-4585,-4910,-5236,-5561,-5886,-3066,,,

,,10%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3500,313,8557,8557,8557,8557,8557,8557,8557,8557,8557,8557,,,

,,经营成本,,,7094.633624,7094.633624,7094.633624,7094.633624,7094.633624,7094.633624,7094.633624,7094.633624,7094.633624,7094.633624,,,

,,净现金流量,-3500,542,-3,-3,-3,-3,-3,-3,-3,-3,-3,3143,0.47%,-1746.08,

,,累计,-3500,-2958,-2961,-2964,-2967,-2970,-2972,-2975,-2978,-2981,-2984,159,,,

,,5%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3500,313,8235,8234,8234,8234,8234,8234,8234,8234,8234,8234,,,

,,经营成本,,,6772.150277,6772.150277,6772.150277,6772.150277,6772.150277,6772.150277,6772.150277,6772.150277,6772.150277,6772.150277,,,

,,净现金流量,-3500,542,319,320,320,320,320,320,320,320,320,3466,9.44%,-108.46,-5.26

,,累计,-3500,-2958,-2638,-2319,-1999,-1680,-1360,-1040,-721,-401,-82,3384,,,

,,-5%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3500,313,7590,7589,7589,7589,7589,7589,7589,7589,7589,7589,,,

,,经营成本,,,6127.183584,6127.183584,6127.183584,6127.183584,6127.183584,6127.183584,6127.183584,6127.183584,6127.183584,6127.183584,,,

,,净现金流量,-3500,542,964,965,965,965,965,965,965,965,965,4111,24.70%,3166.78,5.07

,,累计,-3500,-2958,-1993,-1029,-64,900,1865,2829,3794,4758,5723,9834,,,

,,-10%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3500,313,7267,7267,7267,7267,7267,7267,7267,7267,7267,7267,,,

,,经营成本,,,5804.700237,5804.700237,5804.700237,5804.700237,5804.700237,5804.700237,5804.700237,5804.700237,5804.700237,5804.700237,,,

,,净现金流量,-3500,542,1287,1287,1287,1287,1287,1287,1287,1287,1287,4433,31.27%,4804.40,4.30

,,累计,-3500,-2958,-1671,-384,903,2190,3477,4764,6051,7338,8625,13059,,,

,,-15%,,,,,,,,,,,,,,,

,,现金流入,0,855,8554,8554,8554,8554,8554,8554,8554,8554,8554,11700,,,

,,现金流出,3500,313,6945,6944,6944,6944,6944,6944,6944,6944,6944,6944,,,

,,经营成本,,,5482.216891,5482.216891,5482.216891,5482.216891,5482.216891,5482.216891,5482.216891,5482.216891,5482.216891,5482.216891,,,

,,净现金流量,-3500,542,1609,1610,1610,1610,1610,1610,1610,1610,1610,4756,37.32%,6442.02,3.84

,,累计,-3500,-2958,-1348,261,1871,3480,5090,6699,8309,9918,11528,16283,,,

,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,

人人文库> 全部分类> 应用文书 > 研究报告

温馨提示

1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

一般项目-可行性研究报告的各种财务分析(含计算公式)

文档简介

温馨提示

最新文档

评论

一般项目-可行性研究报告的各种财务分析(含计算公式)

文档简介

温馨提示

最新文档

评论

相关文档