xx项目可研财务分析模板

附 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 1投资估算表单位：万元序号项目1234合计1建设投资18082180821.1土地480048001.2基建900090001.3设备及安装378237821.4筹建费5005002建设期利息4004003流动资金31405282084215总计1848231405282026903附表2流动资金估算表单位:万元序号项目最低周周转年份转天数次数23456789101流动资产848321779217792177921779217792177921779217791.1应收账款904636216334163341633416334163341633416334163341.2存货1781445344534453445344534453445344531.2.1原辅 材料 关于××同志的政审材料调查表环保先进个人材料国家普通话测试材料农民专业合作社注销四查四问剖析材料 30121781445344534453445344534453445344531.2.2备品备件9041.2.3在产品20181.2.4产成品15241.3周转现金30123409929929929929929929929922流动负债3012534313358133581335813358133581335813358133582.1应付账款904534313358133581335813358133581335813358133583流动资金(1－2)3140842184218421842184218421842184214流动资金增加额314052820附表3投资 计划 项目进度计划表范例计划下载计划下载计划下载课程教学计划下载 与资金筹措表单位：万元序号项目年份合计12341投资总额18482314052821.1建设投资180821.2流动资金0314052821.3建设期利息4002资金筹措18482314052822.1自有资金84822000010482.0011903.52.2长期借款1000010000.002.3流动资金借款0114038605000.0038602.4项目盈余资金01422 说明 关于失联党员情况说明岗位说明总经理岗位说明书会计岗位说明书行政主管岗位说明书 ：第2年的建设投资与流动资金投入使用500万元长期借款和300万元流动资金借款，不足部分使用自有资金。第3年增加的流动资金使用第2年提取的折旧费与摊销费。附表4借款还本付息表单位：万元序号年份123456789101借款与还本付息1.1年初欠款累计010000914090005000500050005000500050001.1.1长期借款010000800040000000001.1.2流动资金00114050005000500050005000500050001.2本年借款100001140386000000001.2.1长期借款10000000000001.2.2流动资金01140386000001.3本年付息400828.5793.55702502502502502502501.3.1长期借款4008006403200000001.3.2流动资金借款028.5153.52502502502502502502501.4本年还本02000400040000000050001.4.1长期借款02000400040001.4.2流动资金借款050001.5本年还本付息合计4001.5.1长期借款4002800464043200000001.5.2流动资金借款02915425025025025025025052502还本资金来源4002000400040000000050002.1折旧费与摊销费1144114411442.2流动资金回收2.3资本金（仅限于建设期贷款）40050002.4未分配利润85628562856长期借款利率流动资金借款利率8%长期借款利率流动资金借款利率5%说明：长期借款在借款当年计半年利息，建设期利息并入本金，全部本金从第3年起分5年等额归还。流动资金借款在借款当年计全年利息，本金在项目期末归还。附表5固定资产折旧费/无形资产摊销估算表单位:万元序号项目折旧年份合计残值年限23456789101房屋及建筑物201.1原值94009400893084607990752070506580611056401.2折旧费4704704704704704704704704701.3净值8930846079907520705065806110564051702机器设备102.1原值3782378234043026264722691891151311357562.2折旧费3783783783783783783783783782.3净值34043026264722691891151311357563783土地203.1原值48004800456043204080384036003360312028803.2摊销费2402402402402402402402402403.3净值4560432040803840360033603120288026403开办费93.1原值500500444389333278222167111563.2摊销费5656565656565656563.3净值4443893332782221671115604固定资产合计4.1原值184821733816194150511390712763116191047693324.2折旧费+摊销1144114411441144114411441144114411444.3净值1733816194150511390712763116191047693328188房屋建筑物净残值率：0机器设备净残值率：0运输工具净残值率：0附表8总成本费用估算表单位：万元序号项目年份2345678910产能利用率40%100%100%100%100%100%100%100%100%1生产成本2419260480604806048060480604806048060480604801.1原辅材料213725343053430534305343053430534305343053430材料53431.2动力1.3工资240060006000600060006000600060006000工资6001.4制造费用42010501050105010501050105010501050制造费用105其中:物料消耗2销售费用150037503750375037503750375037503750销售费用率5%3管理费用90022502250225022502250225022502250管理费用率3%4利息支出828.5793.55702502502502502502505总成本费用27420.567273.567050667306673066730667306673066730其中:折旧费+摊销114411441144114411441144114411441144利息支出828.5793.55702502502502502502506经营成本2544865336653366533665336653366533665336653367固定成本8可变成本附表9预计损益表单位：万元序号项目年份合计2345678910产能利用率40%100%100%100%100%100%100%100%100%销售价7500元/套700001销售收入300007500075000750007500075000750007500075000630000.00套数10万套7002销售税金及附加3007507507507507507507507506300.00售价7500062458.22222222223总成本费用274216727467050667306673066730667306673066730562124.006841.77777777784销售利润22806977720075207520752075207520752061576.001710.44444444445所得税(25%)5701744180018801880188018801880188015394.005131.33333333336税后利润17105232540056405640564056405640564046182.00513.13333333337盈余公积金[(6)×10%]1715235405645645645645645644618.20256.56666666678公益金[(6)×5%]852622702822822822822822822309.104361.63333333339可供分配利润14534448459047944794479447944794479439254.702150.726666666710股利分配29189091828762876287628762876287619356.542210.906666666711未分配利润11633558367219181918191819181918191819898.160累计未分配利润1163472183931031012228141451606317981198980累计盈余公积金1716941234179823622926349040544618说明：如果销售利润为负值，则不计所得税，也不提盈余公积金和公益金，亏损额冲减下年可分配利润。82702630附表10资金来源及运用表单位:万元序号项目年份合计123456789101资金来源1848265631198083448664866486648664866486641.1销售利润2280697772007520752075207520752075201.2折旧费+摊销1144114411441144114411441144114411441.3长期借款100000000000001.4流动资金借款1140386000000001.5自有资金8482200002资金运用18482608612177698850385038503850385038100382.1建设投资184822.2流动资金314052822.3所得税570174418001880188018801880188018802.4职工福利费(公益金)852622702822822822822822822.5借款还本02000400040000000050002.6利润分配2918909182876287628762876287628763盈余资金(1-2)0478(196)135636253625362536253625(1375)4累计盈余资金047828116375262888712513161381976418389附表11预计资产负债表单位:万元序号项目年份123456789101资产184822629938254384664094843429459114839350874483561.1流动资产0896022060234162704130666342923791741542401681.1.1应收账款636216334163341633416334163341633416334163341.1.2存货1781445344534453445344534453445344531.1.3周转现金3409929929929929929929929921.1.4累计盈余资金478281163752628887125131613819764183891.2在建 工程 路基工程安全技术交底工程项目施工成本控制工程量增项单年度零星工程技术标正投影法基本原理 184821.3固定资产净值17338161941505113907127631161910476933281881.4无形资产净值2负债及投资人权益合计184822629938254384664094843429459114839350874483562.1长期借款余额100008000400000000002.2流动负债总额0648318358183581835818358183581835818358133582.2.1应付账款534313358133581335813358133581335813358133582.2.2流动资金借款余额01140500050005000500050005000500002.3投资人权益84821181615897201092259025072275543003532517349982.3.1资本金84821048210482104821048210482104821048210482104822.3.4累计盈余公积金17169412341798236229263490405446182.3.5累计未分配利润116347218393103101222814145160631798119898计算1.资产负债率结果2.流动比率3.速动比率0000000000流动资金总额-流动资金借款附表12预计财务现金流量表（全部投资）单位:万元序号项目年份123456789101现金流入03000075000750007500075000750007500075000916091.1产品销售收入3000075000750007500075000750007500075000750001.2固定资产余值回收81881.3流动资金回收84212现金流出184822954373373681566824868248682486824868248682482.1建设投资184822.2流动资金3140528202.3经营成本2544865336653366533665336653366533665336653362.4销售税金3007507507507507507507507502.5所得税570174418001880188018801880188018802.6职工福利费支出852622702822822822822822823净现金流量-184824571627684467526752675267526752233614累计净现金流量-18482-18025-16399-9555-28033948107001745224204475655折现系数6净现金流量现值7.40848040297累计净现金流现值计算结果：i0=0NPV＝12359IRR＝18.70%Pb=年Pb*=年附表13财务现金流量表（自有资金）单位:万元序号项目年份123456789101现金流入03000075000750007500075000750007500075000916091.1产品销售收入03000075000750007500075000750007500075000750001.2固定资产余值回收00000000081881.3流动资金回收00000000084212现金流出84823123272885727266849868498684986849868498734982.1建设投资(自有资金)84822.2流动资金(自有资金)20002.3流动资金(占用折旧)2.4经营成本2544865336653366533665336653366533665336653362.5销售税金3007507507507507507507507502.6所得税570174418001880188018801880188018802.7职工福利费支出852622702822822822822822822.8借款本金偿还2000400040000000050002.9借款利息支出8297945702502502502502502503净现金流量-8482-12322115227465026502650265026502181114累计净现金流量-8482-9714-7600-532611767678141792068127183452945折现系数6净现金流量现值7累计净现金流现值计算结果：i0=12%NPV＝15120.84IRR＝34.36%Pb=年Pb*=年附表14财务现金流量表（甲方投资）单位:万元序号项目年份123456789101现金流入1.1股利1.2资产清理分配1.2.1固定资产余值1.2.2无形资产余值1.2.3自有流动资金1.2.4盈余公积金1.2.5折旧和摊销2现金流出2.1甲方投资3净现金流量4累计净现金流量5折现系数6净现金流量现值7累计净现金流现值计算结果：i0=NPV＝0.00IRR＝Pb=年Pb*=年