全部
搜索
稻壳儿首页 >

表格模板

 >当前作品

财务系统（预测分析）

收藏
  • 财务系统（预测分析）-表格模板,,等额还款计划表,返回#借款付息!A1,1061.5万元36.0月,贷款期限年首期适用月利率‰月利率=当年年利率/12，注意月利率后面是千分号，年利率是百分号,首期还本付息,累计归还利息总额1036429.11,累计归还本息总额11651429.11,备注,期数后续期数适用利率期初余额归还本息归还利息归还本金期末余额,万元,35.010615000.054401.88269248.9310345751.07332.363461,34.010345751.0753021.97270628.8410075122.2356.017511,33.010075122.2351635.0272015.819803106.42,4.032.09803106.4250240.92273409.899529696.53353.389932,5.031.09529696.5348839.69274811.129254885.4134.99104,6.030.09254885.4147431.29276219.528978665.89,7.029.08978665.8946015.66277635.158701030.74375.746607,8.028.08701030.7444592.78279058.038421972.7112.63436,9.027.08421972.7143162.61280488.28141484.51,26.08141484.5141725.11281925.77859558.81,11.025.07859558.8140280.24283370.577576188.24,12.024.07576188.2438827.96284822.857291365.39,13.023.07291365.3937368.25286282.567005082.83,14.022.07005082.8335901.05287749.766717333.07,15.021.06717333.0734426.33289224.486428108.59,16.020.06428108.5932944.06290706.756137401.84,17.019.06137401.8431454.18292196.635845205.21,18.018.05845205.2129956.68293694.135551511.08,19.017.05551511.0828451.49295199.325256311.76,20.016.05256311.7626938.6296712.214959599.55,21.015.04959599.5525417.95298232.864661366.69,22.014.04661366.6923889.5299761.314361605.38,23.013.04361605.3822353.23301297.584060307.8,24.012.04060307.820809.08302841.733757466.07,25.011.03757466.0719257.01304393.83453072.27,26.03453072.2717697.0305953.813147118.46,27.09.03147118.4616128.98307521.832839596.63,28.08.02839596.6314552.93309097.882530498.75,29.07.02530498.7512968.81310682.02219816.75,30.06.02219816.7511376.56312274.251907542.5,31.05.01907542.59776.16313874.651593667.85,32.04.01593667.858167.55315483.261278184.59,33.01278184.596550.7317100.11961084.48,34.0961084.484925.56318725.25642359.23,35.0642359.233292.09320358.72,36.0323650.761650.25,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0,180.0,181.0,182.0,183.0,184.0,185.0,186.0,187.0,188.0,189.0,190.0,191.0,192.0,193.0,194.0,195.0,196.0,197.0,198.0,199.0,200.0,201.0,202.0,203.0,204.0,205.0,206.0,207.0,208.0,209.0,210.0,211.0,212.0,213.0,214.0,215.0,216.0,217.0,218.0,219.0,220.0,221.0,222.0,223.0,224.0,225.0,226.0,227.0,228.0,229.0,230.0,231.0,232.0,233.0,234.0,235.0,236.0,237.0,238.0,239.0,240.0,241.0,242.0,243.0,244.0,245.0,246.0,247.0,248.0,249.0,250.0,251.0,252.0,253.0,254.0,255.0,256.0,257.0,258.0,259.0,260.0,261.0,262.0,263.0,264.0,265.0,266.0,267.0,268.0,269.0,270.0,271.0,272.0,273.0,274.0,275.0,276.0,277.0,278.0,279.0,280.0,281.0,282.0,283.0,284.0,285.0,286.0,287.0,288.0,289.0,290.0,291.0,292.0,293.0,294.0,295.0,296.0,297.0,298.0,299.0,300.0,301.0,302.0,303.0,304.0,305.0,306.0,307.0,308.0,309.0,310.0,311.0,312.0,313.0,314.0,315.0,316.0,317.0,318.0,319.0,320.0,321.0,322.0,323.0,324.0,325.0,326.0,327.0,328.0,329.0,330.0,331.0,332.0,333.0,334.0,335.0,336.0,337.0,338.0,339.0,340.0,341.0,342.0,343.0,344.0,345.0,346.0,347.0,348.0,349.0,350.0,351.0,352.0,353.0,354.0,355.0,356.0,357.0,358.0,359.0,360.0,,等本还款计划表,返回#借款付息!A1,贷款额度1061.5万元贷款月数36.0月,年首期适用月利率‰,每期归还本金,累计归还利息总额1006434.7,累计归还本息总额11621434.7,备注,期数后续期数适用利率期初余额归还本息归还利息归还本金期末余额,万元,35.010615000.0349262.9954401.8810320138.89353.833332,34.010320138.89347751.8252890.7110025277.7855.308574,33.010025277.78346240.6651379.559730416.67,4.032.09730416.67344729.549868.399435555.56353.833332,5.031.09435555.56343218.3348357.229140694.4533.547822,6.030.09140694.45341707.1746846.068845833.34,7.029.08845833.34340196.0145334.98550972.23353.833336,8.028.08550972.23338684.8443823.738256111.1211.787074,9.027.08256111.12337173.6842312.577961250.01,10.026.07961250.01335662.5240801.417666388.9,11.025.07666388.9334151.3539290.247371527.79,12.024.07371527.79332640.1937779.087076666.68,13.023.07076666.68331129.0336267.926781805.57,14.022.06781805.57329617.8634756.756486944.46,15.021.06486944.46328106.733245.596192083.35,16.020.06192083.35326595.5431734.435897222.24,17.019.05897222.24325084.3730223.265602361.13,18.018.05602361.13323573.2128712.15307500.02,19.017.05307500.02322062.0527200.945012638.91,20.016.05012638.91320550.8825689.774717777.8,21.015.04717777.8319039.7224178.614422916.69,22.014.04422916.69317528.5622667.454128055.58,23.013.04128055.58316017.3921156.283833194.47,24.012.03833194.47314506.2319645.123538333.36,25.011.03538333.36312995.0718133.963243472.25,26.010.03243472.25311483.9116622.82948611.14,27.09.02948611.14309972.7415111.632653750.03,28.08.02653750.03308461.5813600.472358888.92,29.07.02358888.92306950.4212089.312064027.81,30.06.02064027.81305439.2510578.141769166.7,31.05.01769166.7303928.099066.981474305.59,32.04.01474305.59302416.937555.821179444.48,33.01179444.48300905.766044.65884583.37,34.0884583.37299394.64533.49589722.26,35.0589722.26297883.443022.33,36.0296372.311511.16,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0,180.0,181.0,182.0,183.0,184.0,185.0,186.0,187.0,188.0,189.0,190.0,191.0,192.0,193.0,194.0,195.0,196.0,197.0,198.0,199.0,200.0,201.0,202.0,203.0,204.0,205.0,206.0,207.0,208.0,209.0,210.0,211.0,212.0,213.0,214.0,215.0,216.0,217.0,218.0,219.0,220.0,221.0,222.0,223.0,224.0,225.0,226.0,227.0,228.0,229.0,230.0,231.0,232.0,233.0,234.0,235.0,236.0,237.0,238.0,239.0,240.0,241.0,242.0,243.0,244.0,245.0,246.0,247.0,248.0,249.0,250.0,251.0,252.0,253.0,254.0,255.0,256.0,257.0,258.0,259.0,260.0,261.0,262.0,263.0,264.0,265.0,266.0,267.0,268.0,269.0,270.0,271.0,272.0,273.0,274.0,275.0,276.0,277.0,278.0,279.0,280.0,281.0,282.0,283.0,284.0,285.0,286.0,287.0,288.0,289.0,290.0,291.0,292.0,293.0,294.0,295.0,296.0,297.0,298.0,299.0,300.0,301.0,302.0,303.0,304.0,305.0,306.0,307.0,308.0,309.0,310.0,311.0,312.0,313.0,314.0,315.0,316.0,317.0,318.0,319.0,320.0,321.0,322.0,323.0,324.0,325.0,326.0,327.0,328.0,329.0,330.0,331.0,332.0,333.0,334.0,335.0,336.0,337.0,338.0,339.0,340.0,341.0,342.0,343.0,344.0,345.0,346.0,347.0,348.0,349.0,350.0,351.0,352.0,353.0,354.0,355.0,356.0,357.0,358.0,359.0,360.0,,中国部分行业建设项目资本金税后财务基准收益率取值表返回,1-农业67化工新型材料,种植业68专用化学品制造（含精细化工）铁矿采选业（大中型）仪表元件表面处理行业,畜牧业-信息产业大型钢铁联合企业仪表材料工模具行业,13渔业71固定通信中型钢铁联合企业石油化工机械汽车,14农副食品加工72移动通信特殊钢厂印刷机械改装汽车,-林业73邮政通信普通钢厂冷冻机械汽车配件,21林产加工-电力钢压延加工业工业泵机械工业其他行业,22森林工业-电源工程铝合金冶炼业风机硫酸,23林纸林化811火力发电大中型耐火制品行业气体压缩机磷肥,24营造林812天然气发电炼焦制气高中压阀门纯碱,-建材813核能发电露天开采低压阀门烧碱,31水泥制造业814风力发电矿井（井工）开采重型机械4.0氮肥,32玻璃制造业815垃圾发电矿区采洗矿山机械,-石油816其他能源发电（潮汐、地热等）矿井采洗起重运输机械石油加工,陆上油田开采-热电站铜矿山工程机械有机化工原料制造,陆上气田开采818抽水蓄能电站铜冶炼机床塑料制造,43国家原油存储设施82-电网工程铜联合企业锻压设备合成纤维单体,44长距离输油管道821送电工程铜锌矿山锻造设备（聚合物）制造,45长距离输气管道822联网工程铜锌冶炼机床附件石油化工联合企业,-石化823城网工程锡矿山量具刃具棉纺织,51原油加工及石油制品制造824农网工程锡冶炼磨料磨具毛纺织,52初级形态的塑料及合成树脂制造825区内或省内电网工程锡联合企业工业锅炉23.0麻纺织,53合成纤维单（聚合）体制造-水利钨矿山3.0电站设备黏胶长丝,54乙烯联合装置91水库发电工程铝矿山及氧化铝电机黏胶短纤维,55纤维素纤维原料及纤维制造92调水、供水工程4.00%铝电解微电机、分电机合成纤维,-化工-铁路铜加工电动工具制浆造纸,61氯碱及氯化物制造101铁路网既有线改造铝加工变压器制浆造纸（重点支持的产品）,62无机化学原料制造102铁路网新线建设有色金属工业部门高压电器,63有机化学原料及中间体制造-民航天然原油开采业低压电器日用机械,64化肥111大中型（干线）机场建设天然气开采业电力电容器日用硅酸,65112小型（支线）机场建设1.00%邮政业电焊机电光源及照明器具,66橡胶制品制造市内电话业电线、电缆21.0日用化学制品,长途电信业电瓷洗涤剂原料,大中型拖拉机绝缘材料21.0制盐,内燃机蓄电池海盐,中国部分行业建设项目资本金税后财务基准收益率取值表收获机械液压、液力件食品,拖内配件气动元件24.0制糖,行     业自动化仪表密封件塑料制品,1.0-农业67化工新型材料电工仪器仪表链条家用电器26.0,种植业68专用化学品制造（含精细化工）成分分析仪器粉末冶金及制品衡器,畜牧业-信息产业光学仪器轴承烟草,13渔业71固定通信电影机械包装机械轻工装备,14农副食品加工72移动通信照相机械铸造行业水泥,-林业73邮政通信科研办公机械24.0锻压行业平板玻璃,21林产加工-电力,22森林工业-电源工程,23林纸林化811火力发电,24营造林812天然气发电银行基准利率,-建材813核能发电贷款贷款基准利率基准贷款上浮10%基准利率上浮15%,31水泥制造业814风力发电年限等额本金（首月）,32玻璃制造业815垃圾发电1.0860.66883.336.6863.426.9864.81,-石油816其他能源发电（潮汐、地热等）2.06.15443.88467.926.77446.667.0725448.05,陆上油田开采817热电站3.06.15304.9329.036.77307.77.0725309.1,陆上气田开采818抽水蓄能电站4.06.4236.69261.677.04239.657.36241.14,43国家原油存储设施82-电网工程6.4195.19220.07.04198.27.36199.71,44长距离输油管道821送电工程168.34193.47171.48173.06,45长距离输气管道822联网工程148.74173.63151.93153.54,-石化823城网工程134.11158.75137.36139.0,51原油加工及石油制品制造824农网工程122.8147.18126.1127.78,52初级形态的塑料及合成树脂制造825区内或省内电网工程113.8137.92117.17118.87,53合成纤维单（聚合）体制造16.00%-水利106.5130.34109.92111.65,54乙烯联合装置91水库发电工程100.45124.03103.93105.7,55纤维素纤维原料及纤维制造16.00%92调水、供水工程95.39118.6998.92100.72,-化工-铁路91.08114.1194.6796.5,61氯碱及氯化物制造101铁路网既有线改造87.39110.1491.0392.89,62无机化学原料制造102铁路网新线建设84.19106.6787.8989.77,63有机化学原料及中间体制造-民航81.4103.685.1587.06,64化肥111大中型（干线）机场建设4.00%78.94100.8882.7584.69,65112小型（支线）机场建设76.7898.4480.6482.6,66橡胶制品制造74.8596.2578.7780.76,备注：速算数以1万元为单位；等额本金速算结果为客户首月还款额！,城市基础设施项目全部投资税前财务基准收益率,行     业,1供水项目6%垃圾焚烧项目,污水处理项目垃圾填埋项目,供热项目垃圾堆肥项目,燃气项目6%垃圾综合处理项目,天然气项目8%轨道交通项目3%,液化石油气项目8%,,大型项目财务分析表格, 2019年12月10日返回综合经济指标表,序号名称单位指标说明,项目总投资(含全部流动资金)7024.3617098,基础数据项目规模总投资(含铺底流动资金)4711.17551294,序号名称合计第1年第2年第3年第4年第5年已完成,项目总投资7024.3617098建设投资,项目规模总投资4711.175512942199.51375.46354848615.90196446流动资金,已完成投资新增,3.1 建设投资新增项目总投资(含全部流动资金)5504.0617098,3.2 流动资金新增规模总投资(含铺底流动资金)3190.87551294,新增投资5504.06170982199.511251.54516162053.00654823.1建设投资,4.1 新增建设投资 其中：基本预备费101.81,4.3 建设期利息3.2建设期利息,4.4 新增流动资金3304.55170981251.54516162053.00654823.3流动资金3304.5517098,4.4.1 铺底流动资金991.36551294375.46354848615.90196446铺底流动资金991.36551294,项目银行贷款营业收入(不含税)19440.0,企业自筹资金5024.3617098营业税金及附加105.063264,申请财政补贴增值税1313.2908,项目建设期时长个月项目执行期一般跨3个年度采用3年计算总成本费用15972.5076,银行贷款期增值税率0.17注意企业实际增值税纳税比例利润总额3362.42913596,银行年利率0.0615所得税率0.25注意是否为高新技术企业所得税840.607283989,贷款方式等额本息3年偿还城市建设税0.05税后利润2521.82185197,行业基准利率0.12最低工资标准1070.0财务盈利能力分析,各表链接ic=12%10.1财务内部收益率,#建设投资!A1全部投资所得税前0.519977516787,#折旧估算表!A1全部投资所得税后0.401737266356,#摊销估算表!A1需手动输入自有资金0.556021737513,#营业收入!A1自动生成10.2财务净现值,#外购原辅材料!A1取外表数据全部投资所得税前12466.7415526ic=12%,#营业税及附加、增值税!A1全部投资所得税后8523.8804395,#工资及福利!A110.3项目投资回收期含建设期,#总成本费用!A1静态投资所得税前3.76120477259,#流动资金!A1静态投资所得税后4.3459091044,#借款付息!A1动态投资所得税前4.14349774325预期利率,#全投资现金流量表!A1动态投资所得税后4.91379911063预期利率,#资金筹措表!A110.4总投资收益率（ROI）0.454617439345,13.0#利润分配表!A110.5项目资本金净利润率(ROE)0.641010238658,14.0#资本金现金流量表!A1清偿能力分析,15.0#财务计划现金流量表!A111.1财务比率,16.0#资产负债表!A1资产负债率0.342017976588,17.0#内部收益率!A1流动比率5.43724990689,18.0#投资回收期!A1速动比率3.55674681617,19.0#盈亏平衡分析!A111.2最大还款期3.18166300616不含建设期,20.0#安全性检验!A1盈亏平衡点0.466863464105,21.0#敏感性分析!A113.0累计指标项目期年（含建设期）,13.1累计销售收入23760.0,13.2累计净利润2650.45117551,13.3累计缴税2617.02758117,13.4累计工业增加值7851.46598186,,建设投资估算表,返回,单位：万元,序号名称折旧年限残值率已完成投资新增投资第 1年第 2年一般建设期为1-2年#原始数据!D11,固定资产,1.1 建筑工程费20.00.1680.41260.01260.0,1.2 设备购置费338.3615.0615.0,1.3 安装工程费416.0,1.4 其他费用104.0104.0,－1434.71979.01979.0,2.0无形资产,2.1 技术85.6,2.2 土地使用权,－85.6,－－资产总计2036.22036.2,3.0预备费,3.1基本预备费项目基本预备费采用固定资产与无形资产的5%计算,3.1.1 基本预备费金额,-,4.0建设投资合计,比对值,需手动输入,自动生成,取外表数据,,固定资产折旧估算表,返回,单位：万元,序号名称合计第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,1.0厂房建设,当年折旧在下年计算,785.862年折旧费用=原值*（1-残值率）/折旧年限,1853.0821765.7641678.4461591.1281503.811416.4921329.1741241.8561154.538,2.0设备购置费,815.0715#建设投资!E6:F9,862.7365772.173681.6095591.046500.4825409.919319.3555228.792138.2285#总成本费用!C11：K11,3.0办公楼装修,355.68,376.48336.96297.44257.92218.4178.88139.3699.8460.32,4.0其他费用,88.92,94.1284.2474.3664.4854.644.7234.8424.9615.08,需手动输入,自动生成,取外表数据,,无形资产及递延资产摊销估算表,返回,单位：万元,序号名称合计第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,1.0合计,摊销=原值*1/待摊年限,114.2499.9685.6871.457.1242.8428.56,2.0无形资产,#建设投资!E12：F13,#总成本费用!C17：K17,114.2499.9685.6871.457.1242.8428.56,3.0其他资产,需手动输入,自动生成,取外表数据,,营业收入测算表,返回,单位：万元,序号名称单位第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,－营业收入合计6480.017280.0,达产率0.30.8注意单位：如出现万元或者万吨的时候，需对单价或产量公式中*1000或者变化的倍数。,灯箱门式变电站,1.1产品单价元/台,1.2产品产量台360.0960.0,1.3销售比例一般为100%销售,1.4营业收入6480.017280.0,2.0变电站,2.1产品单价元/台,2.2产品产量台,2.3销售比例,2.4营业收入多个产品此表需附加,需手动输入,自动生成,取外表数据,营业税及附加、增值税!A1,利润分配表!A1,全投资现金流量表!A1,财务计划现金流量表!A1,,外购原辅材料、燃料动力费估算表,返回,单位：万元,序号名称第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,－外购原材料合计3663.09768.0营业税及附加、增值税!A1,外购辅助材料合计237.6633.6总成本费用!A1,外购燃料动力合计4.3211.52,外购进项税额合计663.83641770.2304,1.0灯箱门式变电站进项,1.1外购原材料3663.09768.0增值税率,外购原材料进项税622.711660.560.17,1.2外购辅助材料237.6633.6,外购辅助材料进项40.392107.712,1.3外购燃料动力4.3211.52,外购燃料动力进项税0.73441.9584,2.0变电站,2.1外购原材料,外购原材料进项税,2.2外购辅助材料,外购辅助材料进项,3.3外购燃料动力,外购燃料动力进项税多个产品此表需附加,需手动输入,自动生成,取外表数据,产品1,表外计算数据原材料成本此数据可作为控制数据,辅助材料,燃料动力一般情况外购成本为销售售价的50%左右,产品2,原材料成本,辅助材料,燃料动力,,营业收入、营业税金及附加和增值税估算表返回,单位：万元,序名称第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年销项,号增值税率#营业收入!A1,1.0营业收入6480.017280.00.17#外购原辅材料!A1,产品销项税额1101.62937.6,2.0营业税金及附加35.02108893.389568,2.1营业税城建税率教育附加税取三税的3%计算,2.2消费税0.05,2.3城市维护建设税21.8881858.36848城市建设税计算比例备注：县镇：三税*5%；市区：三税*7%；,其他乡村等地：三税*1%,2.4教育费附加13.13290835.021088,3.0增值税437.76361167.3696,3.1销项税额1101.62937.6,3.2进项税额663.83641770.2304,三税：营业税、消费税、增值税,需手动输入,自动生成,取外表数据,,工资及福利估算表返回,名称单位第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,-127.0,工资总额330.4961.9福利按工资总额的14%估算总成本费用!A1,福利46.256134.666,合计376.6561096.566,注意达产期工资，此表即可做第四年达产计算，也可做第五年达产计算，做第五年达产时需调整工资标准,1.61.8,100.8302.4,14.0,2.42.6,36.4,27.071.0,4.85.2,129.6369.2,31.0,4.5,48.0139.5,营销人员,20.0,2.2,40.0114.4,生产工资部分114.912344.736,制造费用部分13.6841.496,管理费用部分202.464579.918,营业费用部分45.6130.416人数调整往下：,需手动输入,自动生成,取外表数据,项目劳动定员（人数）此数据可作为控制数据,工种第1年第2年第3年第4年第5年第6年第7年第8年第9年第10年,0.3,14.00.2941176470590.823529411765,27.071.00.3033707865170.797752808989,31.00.3076923076920.794871794872,销售人员20.00.307692307692,总人数127.00.302380952381,0.3,工资标准,工种工资标准（万元/年薪）定员人数按达产率大概确定每年人数，尽量不要把所有年份人数做得相同,建设期投产期达产期,1.61.80.95.113.6,2.42.60.86666666666726.771.2,4.85.20.86666666666711.731.2,4.50.919.5,销售人员2.20.88126.0,定工资标准的时候参考可用附属表中，江西省最低工资标准，项目年工资最低标准不得低于当地最低工资标准,,总成本费用估算表（生产成本加费用法）,返回, 单位：万元计入各成本比例,序号名称第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年变动成本固定成本,生产成本4397.341511163.1815,1.1外购原材料费3663.09768.0,1.2外购辅助材料费237.6633.6,1.3外购燃料动力费4.3211.52,1.4工人工资及福利114.912344.736,1.5制造费用377.5095405.3255,1.5.1折旧费,1.5.2修理费用按固定资产原值3%进行估算,1.5.313.6841.496,1.5.4其他制造费用0.4用按固定资产原值1%进行估算,2.0管理费用717.5461681930.820754,2.1202.464579.918,2.2无形资产摊销运营期0.06,2.3其他管理费500.8021681336.622754达产期0.05,2.3.1技术开发费388.81036.8按销售收入的8%估算，可酌情降低,2.3.2工会经费7.5331221.93132最低工资标准按职工工资的2%估算,2.3.3职工教育经费5.6498416.44849按职工工资的1.5%估算,2.3.4劳动保险费97.8408258.85441070.0按当地最低工资标准的60%估算（参考可用附属表格江西省各地工资标准）,2.3.5其他费0.9784082.588544按劳动保险费的1%估算，数额大的可自行确定,3.0营业费用434.41167.216,3.145.6130.416,3.2其他营业费用388.81036.80.7以销售收入的6%估算，可酌情降低,4.0财务费用109.896530207177.251991107186.890229583运营期0.06,5.0总成本费用合计5659.1841982114438.470245117675.8171596达产期0.05,5.1其中：可变成本4334.6121611493.628386,5.2固定成本1324.572038212944.841859113357.84852958,5.3经营成本5307.72616814019.656754,总成本占销售比例0.8733308947850.8355596206660.818324868499成本呈下降趋势,需手动输入,自动生成,取外表数据,管理费用占销售比例0.1107324333330.111737312153,折旧估算表!A1可用附属表格!A1,摊销估算表!A1,外购原辅材料!A1,工资及福利!A1,借款付息!A1,盈亏平衡分析!A1,敏感性分析!A1,,流动资金估算表返回, 单位：万元,序号名称最低需周转第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,要天数次数#总成本费用!A1,1.0流动资产1902.36516165040.0717098#原始数据!A1,1.1应收账款530.77261681401.9656754#借款付息!A1,1.2存货1241.5530283287.693459#全投资现金流量表!A1,1.2.1原材料366.3976.8#资金筹措表!A1,1.2.2辅助材料40.09.026.470.4#资本金现金流量表!A1,1.2.3动力0.4321.152#财务计划现金流量表!A1,1.2.4在产品30.012.0406.1105141071.0367295#资产负债表!A1,1.2.5产成品30.012.0442.3105141168.3047295,1.3现金130.0395168350.4125754原则上最低需要天数和周转次数需按该行业数据确定，由于本表该数据还无法确定，故本表尽量不要放入项目中。,2.0流动负债650.821735.52,2.1应付帐款60.06.0650.821735.52,3.0流动资金1251.54516163304.5517098,3.1已完成投入,3.2本年增加额1251.54516162053.0065482743.2036812本年增加额流动资金为当年需要增加的全流动资金,3.3借款876.081613121437.10458374520.24257684此处借款为当年需增加流动资金借款额,4.0自有资金375.46354848615.90196446222.96110436自有资金即铺底流动资金，按当年增加额的30%计算,需手动输入360.0,自动生成,取外表数据,,借款还本付息计划表,返回, 单位：万元,序号名称第 1年第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年年利率,1.0建设投资借款0.0615参考可用附属表格中银行基准利率确定,1.11061.5729.136539,1.2当期还本付息388.380972388.380972388.380967建设期长期借款,其中:还本332.363461353.389932还本付息采用前表等额还款或等息还款方式计算而得，因每年余额不同，每年需单独计算然后将数据代入本表。因项目分三年还完，故第三年需还完本金和利息。本表默认“等额还款”，如采用“等本还款”需切换公式。,付息56.01751134.9910412.63436,1.3729.136539,2.0建设期利息,2.1,2.2当期借款1000.0,2.3当期应计利息61.5投产期流动资金贷款,2.41061.5流动资金贷款采用期末还款、期初再借的方式,3.0流动资金借款,3.1876.081613122313.18619686,3.2当期还本付息53.8790192069142.2609511073007.68464328利息备付率=息税前利润/当期应付利息100%=（利润总额+当期应付利息）/当期应付利息*100%,其中:还本偿债备付率=可用于还本付息的资金/当期应还本付息的金额*100%,付息53.8790192069142.260951107 可用于还本付息的资金=息税前利润加折旧和摊销-企业所得税,3.3876.081613122313.18619686借款偿还期=偿清债务年份数-1+偿清债务当年应付本息/当年可用于偿债的资金总额,计算指标（长期）利息备付率8.1503141392516.504142829321.3726320467,偿债备付率2.127264695564.673431410695.836866565371.09083163264,贷款偿还期3.18166300616以下为表链接,#等额还款!A1,偿还清贷款年限4.0#等本还款!A1,#原始数据!A1,需手动输入#流动资金!A1,自动生成#总成本费用!A1,取外表数据#资本金现金流量表!A1,#财务计划现金流量表!A1,#资产负债表!A1,,项目全投资现金流量表返回, 单位：万元,序号名称第 1年第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,1.0现金流入6480.017280.027015.921891,1.1营业收入6480.017280.0,1.2回收固定资产1368.1665回收固定资产为最后一年回收固定资产净额,1.3回收流动资金4047.755391回收流动资金为各年流动资金投资增加额的合计数。,2.0现金流出3658.316594.292417616166.052870218107.3060712,2.1建设投资3658.31,2.2流动资金1251.54516162053.0065482743.2036812营业收入!A1,2.3经营成本5307.72616814019.656754流动资金!A1,2.4营业税金及附加35.02108893.389568总成本费用!A1,3.0税前净现金流量-114.29241761113.94712983492.69392889651.819501利润分配表!A1,4.0累计税前净现金流量-3772.6024176-2658.6552878834.0386415069.9362519305.83386113541.73147117777.62908122013.52669131665.346192,5.0调整所得税223.922811731.3480445调整所得税为息税前利润乘以所得税率得出,6.0税后净现金流量-338.2152286382.59908532494.10990138653.2354735,7.0累计税后净现金流量-3996.5252286-3613.9261433-1119.8162422117.49734055354.8109238592.124505511829.43808815066.751670523719.987144,计算指标税前静态回收期(年)3.76120477259税后静态回收期(年)4.3459091044行业基准利率,税前内部收益率(%)0.519977516787税后内部收益率(%)0.401737266356税前净现值(ic=12%)12466.7415526税后净现值(ic=12%)8523.88043950.12,计算用年数1.02.03.04.05.06.07.08.09.010.0,折现率0.12静态回收期,需手动输入计算公式为：累计净现值最后出现负值的那一年+（-该负值/下年年净现金流量值）,自动生成动态回收期,取外表数据计算公式为：（累计净现金流量现值出现正值的年数-1）+上一年累计净现金流量现值的绝对值/出现正值年份净现金流量的现值,第1年第2年第3年第4年第5年第6年第7年第8年第9年第10年,税前净现值-91.1132155612792.88556412219.670134092403.562061992146.037555351916.104960131710.808000121527.507142963107.62756373,税前累计净现值-3357.46142985-2564.57586575-344.905731662058.656330334204.693885686120.798845817831.606845929359.1139888812466.7415526,税后净现值-269.623109534272.3264717481585.05193181836.938667091640.12380991464.396258841307.496659681167.407731862786.11023238,税后累计净现值-3535.97132382-3263.64485207-1678.59292027158.3457468261798.469556733262.865815574570.362475265737.770207118523.8804395,税前动态回收期(年)4.14349774325,税后动态回收期(年)4.91379911063,量税前),=LOOKUP(0,累计现金流量税后,年份)+ABS(LOOKUP(LOOKUP(0,累计现金流量税后,年份),年份,累计现金流量税后))/LOOKUP(LOOKUP(0,累计现金流量税后,年份)+1,年份,现金流,量税后),,项目投资使用计划与资金筹措表返回, 单位：万元,序号名称合计已完成第 1年第 2年第 3年第 4年第 5年#原始数据!A1,1.0总投资7767.5653912199.51,1.1建设投资3658.312138.01,1.2建设期利息,1.3流动资金4047.755391#流动资金!A1,2.0资金筹措7767.5653912199.51,2.1 项目资本金3934.13661731199.51375.46354848615.90196446222.96110436,2.1.1用于建设投资2658.311138.01,2.1.2用于流动资金1214.3266173375.46354848615.90196446222.96110436,2.1.3用于建设期利息注意：此处由于流动投资到第四年达产还需增加流动投资，故整个项目的资金筹措比执行期内的投资要高,2.2债务资金3833.4287737876.081613121437.10458374520.24257684,2.2.1用于建设投资,2.2.2流动资金借款2833.4287737876.081613121437.10458374520.24257684,2.2.3短期借款对于验收来算，是三年时间内的投资,对于整个项目达成情况来算，是四年的投资,需手动输入,自动生成,取外表数据,,利润与利润分配表返回, 单位：万元,序名称第2年第3年第4年第5年第6年第7年第8年第9年第10年,号,1.0营业收入6480.017280.0#营业收入!A1,2.0营业税金及附加35.02108893.389568#营业税及附加、增值税!A1,3.0总成本费用5659.1841982114438.470245117675.8171596#总成本费用!A1,4.0利润总额785.7947137932748.140186893807.44588042,5.0弥补以前年度亏损,6.0应纳税所得额785.7947137932748.140186893807.44588042所得税率注意企业是否是高新技术企业，高企所得税率为15%,7.0所得税196.448678448687.035046723951.8614701040.25,8.0净利润589.3460353452061.105140172855.58441031,9.0期初未分配利润2385.406057964955.432027247533.9861895310112.540351812691.094514115269.648676417848.2028387,10.0可供分配的利润589.3460353452061.105140172855.58441031,11.0提取法定盈余公积金58.9346035345206.110514017285.558441031法定盈余金按可供分配的利润的10%计提,12.0可供投资者分配利润1854.994626152570.02596928,13.0各投资方利润分配,14.0期末累计未分配利润2385.406057964955.432027247533.9861895310112.540351812691.094514115269.648676417848.202838720426.7570009,15.0息税前利润895.6912442925.392178息税前利润=利润总额+当年利息,16.0息税折旧摊销前利润1137.2527443166.953678息税折旧摊销前利润=息税前利润+折旧费用+摊销费用,销售利润率0.1212646163260.1590358904450.176270642612净利润率参考行业基准利润率,净利润率0.09094846224460.1192769178340.132202981959利润呈上升趋势,需手动输入,自动生成达产年纳税总计2527.8104301,取外表数据,,项目资本金现金流量表返回, 单位：万元,序号名称第 1年第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,1.0现金流入6480.017280.027015.921891#营业收入!A1,1.1营业收入6480.017280.0#资金筹措表!A1,1.2补贴收入#借款付息!A1,1.3回收固定资产1368.1665#总成本费用!A1,1.4回收流动资金4047.755391#利润分配表!A1,2.0现金流出2719.816356.9194741415946.625256319101.56180121326.8070934,2.1项目资本金2719.81375.46354848615.90196446222.96110436,2.2借款本金偿还332.363461353.389932375.7466072833.4287737,2.3借款利息支付109.896530207177.251991107186.890229583,2.4经营成本5307.72616814019.656754,2.5税金及附加35.02108893.389568,2.6所得税196.448678448687.035046723951.861470104,2.7维持运营投资,3.0净现金流量-2719.81123.0805258651333.374743712498.438198955689.11479761,计算指标,内部收益率(%)0.556021737513净现值 (ic=12%)9155.29339987,基准收益率0.12,需手动输入,自动生成,取外表数据,,财务计划现金流量表返回, 单位：万元,序名称第 1年第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年,号#营业收入!A1,1.0经营活动净现金流940.8040655522479.918631283284.0361399#营业税及附加、增值税!A1,1.17581.620217.6#总成本费用!A1,1.1.1营业收入6480.017280.0#利润分配表!A1,1.1.2增值税销项税1101.62937.6#流动资金!A1,1.1.3补贴收入#资金筹措表!A1,1.1.4其他流入#借款付息!A1,1.26640.7959344517737.681368721987.9638601,1.2.1经营成本5307.72616814019.656754,1.2.2增值税进项税663.83641770.2304,1.2.3税金及附加35.02108893.389568,1.2.4增值税437.76361167.3696,1.2.4所得税196.448678448687.035046723951.861470104,2.0投资活动净现金流-3658.31-1251.5451616-2053.0065482-743.2036812,2.1,2.23658.31,2.2.1建设投资3658.31,2.2.2维持运营投资,2.2.3流动资金,2.2.4其他流出,3.0筹资活动净现金流3719.81809.2851703931522.36462509180.566844617-3007.68464328,3.13719.81 ,3.1.1资本金投入2719.81375.46354848615.90196446222.96110436,3.1.2建设投资借款1000.0,3.1.3流动资金借款876.081613121437.10458374520.24257684,3.1.4债券,3.1.5短期借款,3.1.6其他流入,3.2442.259991207530.641923107562.6368365833007.68464328,3.2.1各种利息支出109.896530207177.251991107186.890229583,3.2.2偿还债务本金332.363461353.389932375.7466072833.4287737,3.2.3应付利润,3.2.4其他流出,4.0净现金流量61.5498.5440743451949.276708172721.39930331273.192906613,5.0累计盈余资金61.5560.0440743452509.320782515230.720085838337.3417661411443.963446514550.585126817657.206807120763.828487421037.021394,需手动输入,自动生成,取外表数据,,资产负债表返回, 单位：万元,序号名称第 1年第 2年第 3年第 4年第 5年第 6年第 7年第 8年第 9年第 10年#原始数据!A1,1.0资产5741.364144810785.916134414627.38544817674.21394820721.04244823767.87094826814.69944829861.52794830549.996448#建设投资!A1,1.1 流动资产总额2426.42564487712.539134411795.56994815083.95994818372.34994821660.73994824949.12994828237.51994829167.549948#流动资金!A1,1.1.1 货币资金654.13022.885991.279279.6612568.0515856.4419144.8322433.2223363.25,1.1.2 应收账款530.77261681401.9656754,1.1.3 存货1241.5530283287.693459,1.2 在建工程,1.3 固定资产净值3186.41852959.1372731.85552504.5742277.29252050.0111822.72951595.4481368.1665,1.4 无形资产净值128.52114.2499.9685.6871.457.1242.8428.5614.28,2.0负债及所有者权益5348.746304138339.173434359426.068949589712.574967619999.0809856510285.587003710572.093021710858.59903978311.67628407货币资金与流动资产借款无法定，资产负债表不平衡,2.1 流动负债总额650.821735.52,2.1.1短期借款,2.1.2应付账款650.821735.52,2.2 建设投资借款1000.0729.136539375.746607,2.3 流动资金借款876.081613122313.18619686,2.4 负债小计1000.02256.038152124424.45280386,2.5 所有者权益2658.313092.708152013914.720630494423.240175884709.746193914996.252211955282.758229985569.264248015855.770266046142.27628407,2.5.1 资本金2658.313033.773548483649.67551294项目资本金=项目固定投资+铺底流动资金,2.5.2 资本公积,2.5.3 累计盈余公积金58.9346035345265.045117551550.603558583837.1095766141123.615594651410.121612681696.627630711983.133648742269.63966677,2.5.4累计未分配利润530.411431812385.406057964955.432027247533.9861895310112.540351812691.094514115269.648676417848.202838720426.7570009,资产负债率0.2733502628260.3929446199930.4102064904570.3420179765880.2830580634830.241437118150.2104870387690.1865703840310.1675342528490.0710114648849,流动比例3.72825918814.443935612615.437249906896.953056120598.468862334299.9846685479911.500474761713.016280975413.4449847645,速动比例1.820584211922.549579189753.556746816175.072553029876.588359243578.104165457279.6199716709711.135777884711.5644816737,需手动输入,自动生成,取外表数据, , ,,税前财务内部收益率（FIRR）测算表返回,年年净现金流量,份0.520.53#全投资现金流量表!A1,1.0-3658.310.657894736842-2406.782894740.653594771242-2391.05228758,2.0-114.29241760.432825484765-49.46867105260.427186124995-48.8241349908excel自动法为保持内容一致性，填入项目时采用excel自动法算出的数据,3.01113.94712980.284753608398317.2004647750.279206617644311.0214103450.519977516787,4.03492.69392880.187337900262654.3139468780.182487985388637.374678643,5.00.123248618593522.0685289350.119273193064505.229033437,6.00.0810846174955343.4661374570.077956335336330.215054534本表可作为材料内部表格采用，不用作为附表,7.00.0533451430892225.9645641160.0509518531608215.826833029,8.00.0350954888744148.6608974450.033301864811141.063289561,9.00.023089137417497.80322200330.02176592471392.1982284714差值法内部收益率计算须知：,1、设A=得出的前一个折现系数，B=得出的后一个折现系数，C=前一个折现系数得出的净现值中由负值开始变为正值时的该正值，D=后一个折现系数得出的净现值中由负值开始变为正值时的该负值。,2、计算公式, 内部收益率=A+(B-A)*C/(C-D),10.09651.8195010.0151902219851146.6132807810.0142260945837137.307697126,合计-0.160523399315-69.6401974256,税前内部收益率0.528666096896,税后财务内部收益率（FIRR）测算表,年年净现金流量,份0.40.41,1.0-3658.310.714285714286-2613.078571430.709219858156-2594.54609929,2.0-338.21522860.510204081633-172.5587901020.502992807203-170.119827272excel自动法,3.0382.59908530.36443148688139.4311535350.356732487378136.4855233680.401737266356,4.02494.10990130.260308204915649.2372712670.253001764098631.014204883,5.00.185934432082601.9280624330.179433875247580.883721497,6.00.13281030863429.9486160240.127258067551411.974270565,7.00.0948645061642307.1061543030.0902539486176292.180333734,8.00.0677603615459219.3615387880.0640098926366207.220094847,9.00.0484002582471156.686813420.0453970869763146.964606274,10.08653.23547350.0345716130336299.1563082790.032196515586278.604030792,合计17.2185565166-79.3391406036,税后内部收益率0.4045043034,需手动输入,自动生成,取外表数据,,税后投资回收期测算表(静态),返回,年份年净现金流量(万元)累计净现金流量,1.0-2658.6552878,2.0-114.2924176-3772.6024176计算公式为：累计净现金流量最后出现负值的那一年+（-该负值/下年年净现金流量值）,3.01113.9471298-2658.6552878,4.03492.6939288834.038641本表可作为材料内部表格采用，不用作为附表,5.05069.936251,6.09305.833861,7.013541.731471数据需与全投资现金流量表中的回收期一致,8.017777.629081,9.022013.526691,10.09651.81950131665.346192#全投资现金流量表!A1,税前投资回收期3.76120477259,税后投资回收期测算表(静态),年份年净现金流量(万元)累计净现金流量,1.0-1119.816242,2.0-338.2152286-3996.5252286,3.0382.5990853-3613.9261433,4.02494.1099013-1119.816242,5.02117.4973405,6.05354.810923,7.08592.1245055,8.011829.438088,9.015066.7516705,10.08653.235473523719.987144,税后投资回收期4.3459091044,需手动输入,自动生成,取外表数据,,正常年达产百分比0.20.40.60.81.0盈亏临界点销售额,固定成本固定成本10084.2508247,变动成本14317.96863总成本费用6208.807895589072.4016215811935.995347614799.589073617663.1827996盈亏平衡点,销售收入（已扣税金）21483.26304销售收入（已扣税金）4296.6526088593.30521612889.95782417186.61043221483.263040.466863464105,营业税金及附加116.73696安全边际率,销售收入21600.0可变成本2863.5937265727.1874528590.78117811454.37490414317.968630.533136535895很安全,返回,盈亏临界点销售额=固定成本÷边际贡献率=固定成本×销售收入÷（销售收入-销售税金-变动成本）,#总成本费用!A1,#营业税及附加、增值税!A1,盈亏平衡点=固定成本÷（销售收入-销售税金-变动成本）×100%,安全边际率=（1-盈亏平衡点）*100%,需手动输入,自动生成,取外表数据,,返回,安全边际率,安全边际率40%以上30%-40%20-30%10-20%10%以下,安全等级安全较安全值得注意危险,IF(AND(F9>1000000,F9<=5000000),10000+0.007*(F9-1000000),0),危险,值得注意,较安全,安全,总投资收益率=运营期内平均息前利润（达产期正常年份的年息税前利润）÷项目总投资×100%0.454617439345,项目资本金利润率=运营期内平均净利润÷项目资本金投入×100%0.641010238658,,敏感性分析表敏感度系数和临界点分析表,返回,行业基准收益率,序不确定因素变化率内部收益率投资回收期财务净现值,号序号不确定因素变化率内部收益率敏感度系数敏感度次序临界点(%),基本方案基本方案,0.2408701438165.783306335138.638600665083529.29925969-19.27574211127.03006382624-9.97450690706,0.7774914692143.050003642753.2927930592521404.183845517067.03662116.37801746501,0.4851961991483.87758453484.4714696590210893.43257597344.857574120.683264374915-105.848395146,0.5527251345543.665984967154.2431777415414040.05052939702.903304880.637510744698,0.750501407553.072145979723.3107877311419830.874868815888.0137557-5.9051139860411.6222118002,0.2855181476935.301357443397.468965140535102.608236381159.74712327-6.04379046324,5.00.7422395481963.003165833493.2258064178315620.48907611677.62796295.0-5.1266921667721.7873540341,0.4028694538334.426787201735.1619763346710463.74606526520.88495205-2.51135490493,次序：敏感度系数绝对值小的排前面，大的排后面；敏感度系数绝对值越大，对项目的影响越大，就越敏感。,敏感性分析（税后内部收益率）敏感性分析（税前内部收益率）,需手动输入,自动生成0.2408701438160.777491469214,取外表数据0.4851961991480.552725134554,0.750501407550.285518147693,0.7422395481960.402869453833#全投资现金流量表!A1,基准收益率基准收益率,敏感性分析（税后投资回收期）敏感性分析（税前投资回收期）,8.638600665083.292793059255.783306335133.05000364275,4.471469659024.243177741543.87758453483.66598496715,3.310787731147.468965140533.072145979725.30135744339,3.225806417835.161976334673.003165833494.42678720173,敏感性分析（税后财务净现值）敏感性分析（税前财务净现值）,-19.275742111217067.03662113529.2992596921404.1838455,7344.857574129702.9033048810893.432575914040.0505293,15888.01375571159.7471232719830.87486885102.60823638,11677.62796296520.8849520515620.48907610463.7460652,,敏感性分析数据,所得税 前返回,项目年份第1年第2年第3年第4年第5年第6年第7年第8年第9年第10年,现金流量,现金流入（正常情况）6480.017280.027015.921891,现金流出（正常情况）6594.292417616166.0528702,0.1现金流入（收入减少）5832.015552.024314.3297019,0.1现金流入（收入增加）7128.019008.029717.5140801,现金流出（经营费用增加）,现金流入（产量增加）7128.019008.029717.5140801,需手动输入现金流出（产量增加）,自动生成现金流出（投资增加）,取外表数据现金流入（产量减少）5832.015552.024314.3297019,现金流出（产量减少）,现金流出（成本增加）,现金流出（成本减少）,现金流出（投资减少）3292.479,净 现金流量,基准收益率0.12-114.29241761113.94712983492.6939288,-762.2924176-614.05287021332.69392886950.2273119,533.70758242841.94712985652.693928812353.4116901,1681.963321687915.409262,#原始数据!A1-1421.72165936-2230.65815722-478.036678325213.8170729,#全投资现金流量表!A1-125.721659361225.341842783841.9633216810617.0014511,#营业收入!A13492.6939288,-102.863175841002.552416823143.424535928686.6375509,1681.963321687915.409262,545.136824162730.552416825303.4245359211388.22974,545.136824162730.552416825303.42453592,1.02.03.04.05.06.07.08.09.010.0,累计 净 现金流量,-3772.6024176-2658.6552878834.0386415069.9362519305.83386113541.73147117777.62908122013.52669131665.346192,-4420.6024176-5034.6552878-3701.961359-1626.063749449.8338612525.7314714601.6290816677.52669113627.7540029,-3124.6024176-282.65528785370.03864111765.93625118161.83386124557.73147130953.62908137349.52669149702.9383811,-4797.86265936-5300.52081658-3618.5574949-1119.07012391380.41724713879.90461816379.39198918878.879360116794.2886221,-5445.86265936-7676.52081658-8154.5574949-7815.0701239-7475.5827529-7136.0953819-6796.6080109-6457.1206399-1243.303567,-3784.03165936-2558.689816581283.27350515942.760876110602.248247115261.735618119921.222989124580.710360135197.7118112,-4797.86265936-5300.52081658-1807.826887782428.070722226663.9683322210899.865942215135.763552219371.661162229023.4806632,-3761.17317584-2758.62075902384.80377694197.11162598009.419474911821.727323915634.035172919446.343021928132.9805728,-4432.03165936-4934.68981658-3252.7264949-753.23912391746.24824714245.73561816745.22298919244.710360117160.1196221,-3113.17317584-382.620759024920.803776910893.111625916865.419474922837.727323928810.035172934782.343021946170.5727619,-2747.34217584-16.789759025286.63477699522.532386913758.429996917994.327606922230.225216926466.122826936117.9423279,效益评价指标5FIRR5NPV10 FIRR 10 NPVN,0.2984541894782058.656330330.51997751678712466.74155263.76120477259,-0.114842173595-1626.0637490.2408701438163529.299259695.78330633513,0.62194717430911765.9362510.77749146921421404.18384553.05000364275,-0.0702570768168-1119.07012390.2675915032254775.973414955.44771985523,36-7815.0701239-0.0221707223261-4161.4688779710.2384632122,0.3368712906935942.76087610.55272513455414040.05052933.66598496715,0.1242099557182428.070722220.40286945383310463.74606524.42678720173,0.2574269202564197.11162590.48519619914810893.43257593.8775845348,-0.04995561857-753.23912390.2855181476935102.608236385.30135744339,0.5928845516610893.11162590.7505014075519830.87486883.07214597972,0.6101413112819522.53238690.74223954819615620.4890763.00316583349,所得税 后,项目年份第1年第2年第3年第4年第5年第6年第7年第8年第9年第10年,现金流量,现金流入（正常情况）6256.07718916548.651955526017.3378635,现金流出（正常情况）6594.292417616166.0528702,现金流入（收入减少）5630.469470114893.7867623415.6040771,现金流入（收入增加）6881.684907918203.517151128619.0716499,现金流出（经营费用增加）,现金流入（产量增加）6881.684907918203.517151128619.0716499,现金流出（产量增加）,现金流出（投资增加）,现金流入（产量减少）5630.469470114893.7867623415.6040771,现金流出（产量减少）,现金流出（成本增加）,现金流出（成本减少）,现金流出（投资减少）3292.479,净 现金流量,-338.2152286382.59908532494.1099013,-963.8229475-1272.26611025433.968304056051.50168715,287.39249032037.464280854554.2514985511254.9692599,683.379294186916.8252345,-1623.25218926-2888.87139727-1376.762303074315.09144815,-372.03675146420.858993832743.520891439518.55902085,2494.1099013,-304.39370574344.339176772244.698911177787.91192615,683.379294186916.8252345,321.214013161999.204372324304.8405084210389.6457125,321.214013161999.204372324304.84050842,1.02.03.04.05.06.07.08.09.010.0,累计 净 现金流量,-3996.5252286-3613.9261433-1119.8162422117.49734055354.8109238592.124505511829.43808815066.751670523719.987144,-4622.1329475-5894.39905775-5460.4307537-4283.25876845-3106.0867832-1928.91479795-751.7428127425.429172556476.9308597,-3370.9175097-1333.453228853220.79826978518.2534494513815.708629219113.16380924410.618988729708.074168540963.0434283,-5021.78547036-6255.79167208-5572.4123779-4071.5090344-2570.6056909-1069.7023474431.20099611932.10433968848.9295741,-5647.39318926-8536.26458653-9913.0268896-10472.2651434-11031.5033971-11590.7416508-12149.9799046-12709.2181583-8394.1267102,-4030.34675146-3609.48775763-865.96686622695.078074556256.12301539817.1679560513378.212896816939.257837626457.8168584,-5021.78547036-6255.79167208-3761.68177078-524.368188282712.945394225950.258976729187.5725592212424.886141721078.1216152,-3962.70370574-3618.36452897-1373.66561781539.916606454453.49883077367.0810549510280.663279213194.245503520982.1574296,-4655.95447036-5889.96067208-5206.5813779-3705.6780344-2204.7746909-703.8713474797.03199612297.93533969214.7605741,-3337.09598684-1337.891614522966.94889397940.672715412914.396536917888.120358422861.844179927835.568001438225.2137139,-2971.26498684-972.060614523332.77989396570.09347649807.407058913044.720641416282.034223919519.347806428172.5832799,效益评价指标5 FIRR5 NPV10 FIRR 10 NPVN,0.134763808273158.3457468260.4017372663568523.88043954.3459091044,-0.349381895642-3996.522153410.11931340397-19.27574211128.63860066508,0.4765598121434313.213647060.65796599647317067.03662113.29279305925,-0.291880915527-3980.687578720.14674233964833.1123018397.71270568623,36-8135.55547895-0.158941207397-7710.0438797711.9452952066,0.165065427796500.8151429370.4273484487419702.903304884.24317774154,-0.0287124048343-1844.649740620.300846780926520.884952055.16197633467,0.102161285841-184.1236492860.3742879901387344.857574124.47146965902,-0.280280167289-3654.052757290.1589356804431159.747123277.46896514053,0.4569174089953970.744250950.63896770138415888.01375573.31078773114,0.4538163519773312.093270220.60769559600911677.62796293.22580641783
  • 财务系统（预测分析）-表格模板
  • 财务系统（预测分析）-表格模板
  • 财务系统（预测分析）-表格模板
模板介绍：
这个模板还没有相关介绍

关注稻壳领福利

相关推荐 查看更多
财务收支记账系统（一键汇总）.xlsm
财务收支记账系统（一键汇总）.xlsm

财务收支记账系统（一键汇总）

财务收支系统.xlsx
财务收支系统.xlsx

财务收支系统

财务报表-收支账单表.xls
财务报表-收支账单表.xls

财务报表-收支账单表

财务收支折现分析图.xlsx
财务收支折现分析图.xlsx

财务收支折现分析图

财务记账表（可按月查询）.xls
财务记账表（可按月查询）.xls

财务记账表（可按月查询）

财务收款发票报表.xls
财务收款发票报表.xls

财务收款发票报表

财务管理系统-应收应付款.xls
财务管理系统-应收应付款.xls

财务管理系统-应收应付款

财务收支记账表（自动查询汇总）.xls
财务收支记账表（自动查询汇总）.xls

财务收支记账表（自动查询汇总）

财务收支利润表（自动）.xlsx
财务收支利润表（自动）.xlsx

财务收支利润表（自动）

财务收支分析表（条形图）.xlsx
财务收支分析表（条形图）.xlsx

财务收支分析表（条形图）

财务收支明细表.xls
财务收支明细表.xls

财务收支明细表

财务记账表(自动统计）.xls
财务记账表(自动统计）.xls

财务记账表(自动统计）

模板单价：￥24.99
开通会员可免费下载任意模板与19项权益包
登录后使用
以24.99元购买此模板
  • 页数：27页
  • 时间：2020-01-02
  • 编号：20282416
  • 类型：VIP模板
  • 格式：et
  • 提示：数字产品不支持退货
    数字产品本身（包括但不限于文字模板、表格模板、演示模板等）及其包含的全部素材 （包括但不限于字体、图片、图标、文本框、艺术字等）均不支持商用，仅能为个人学习、研究或欣赏目的使用。

Office办公之家

设计作品1462 独家高品质原创文档

举报

猜你在找

    我的

    关注稻壳领福利

    福利

    反馈

    微信咨询在线客服

    客服