投资项目评估财务基础数据估算表.xls

101012011001郑培101012011024林鸿琴101012011028荀名莹101012011029李露 建建设设投投资资估估算算表表单单位位:万万元元,万万欧欧元元序序号号工工程程或或费费用用名名称称建建筑筑工工程程设设备备购购置置安安装装工工程程其其他他费费用用总总值值一一固固定定资资产产投投资资4148.54148.531415.1631415.161343.651343.652363.002363.0039270.3039270.30（一一）工工程程费费用用 4148.54148.531415.1631415.161343.651343.652363.002363.0039270.3039270.300101厂厂区区工工程程822.00822.00135.00135.00957.00957.0001-1总平面布置及运输400.0080.00480.0001-2厂区给排水60.0060.0001-3厂区热力管道25.0025.0001-4厂区供电线路200.0050.00250.0001-5厂区通讯线路10.005.0015.0001-6厂区绿化50.0050.0001-7厂区辅助设施77.0077.000202原原料料收收购购管管理理工工程程327.00327.00215.00215.00542.00542.0002-1地磅房23.0035.0058.0002-2堆场304.00180.00484.000303中中密密度度纤纤维维板板工工程程2210.502210.5030305.1630305.161259.6533775.3033775.3003-1削片间94.5094.5003-2木片库35.0035.0003-3中密度纤维板车间2081.002081.0003-3-103-3-1土土建建1992.001992.001992.001992.0003-3-203-3-2设设备备30305.1630305.1630305.1630305.1603-3-2-1进口设备28782.6628782.6603-3-2-1-103-3-2-1-1进进口口设设备备到到岸岸价价28132.9028132.9028132.9028132.9003-3-2-1-203-3-2-1-2银银行行手手续续费费140.00140.00140.00140.0003-3-2-1-303-3-2-1-3外外贸贸手手续续费费84.4084.4084.4084.4003-3-2-1-403-3-2-1-4 国国内内运运费费425.36425.36425.36425.3603-3-2-2国产设备1522.501522.5003-3-2-2-103-3-2-2-1国国产产设设备备原原价价1450.001450.001450.001450.0003-3-2-2-203-3-2-2-2 运运杂杂费费72.5072.5072.5072.5003-3-303-3-3安安装装1259.651259.651259.651259.6503-3-3-1国产设备安装及材料费692.50692.5003-3-3-2进口设备安装费567.15567.1503-4废料棚50.0050.0003-5热能中心39.0039.000404制制胶胶工工程程143.00336.0050.00529.00529.000505水水源源工工程程38.0045.005.0088.0088.000606中中心心配配电电所所60.00268.0021.00349.00349.000707污污水水处处理理站站60.0075.007.00142.00142.000808化化工工原原料料库库110.00 110.00110.000909综综合合楼楼108.00 108.00108.001010办办公公楼楼及及倒倒班班宿宿舍舍 270.0036.001.00307.00307.00（二）固固定定资资产产其其他他费费用用2363.002363.002363.002363.0001勘察设计费233.00233.00233.0002地质钻探费25.0025.0025.0003可研编制费20.0020.0020.0004建设单位管理费204.00204.00204.0005联合试运转费388.00388.00388.0006环保评估费20.0020.0020.0007预算编制费23.0023.0023.0008拆迁及土地补偿费60.0060.0060.0009设计联络培训技服费979.00979.00979.0010进口设备临时维护费30.0030.0030.0011工程监理费181.00181.00181.0012外国专家接待费80.0080.0080.0013翻译费50.0050.0050.0014场外拉线70.0070.0070.00二二无无形形资资产产80.0080.0080.0080.0001技术转让费80.0080.0080.00三三其其他他资资产产178.00178.00178.00178.0001办公、生活家具购置费80.0080.0080.0002生产准备费98.0098.0098.00四预预备备费费1976.421976.421976.421976.42五建建设设期期利利息息1981.381981.381981.381981.3801第第一一年年599.04599.04599.04599.0402第第二二年年1382.341382.341382.341382.34总总 计计4148.54148.531415.231415.21343.61343.66578.806578.8043486.1043486.10 流流动动资资金金估估算算表表序号项目最低周 周转 投产期达到设计生产能力 转天数 次数3456789一流动资产4040494749474947494749474947（一）应收帐款30121806219921992199219921992199（二）存货20862584258425842584258425841 原材料301212721590159015901590159015902 燃料1524911141141141141141143 在产品31201611971971971971971974 产成品1036562683683683683683683（三）现金1524149164164164164164164二流动负债14531817181718171817181718171 应付帐款30121453181718171817181718171817三流动资金2587313031303130313031303130四流动资金本年增加额2587543五流动资金借款1682203520352035203520352035六利息84102102102102102102 101112131415494749474947494749474947219921992199219921992199258425842584258425842584159015901590159015901590114114114114114114197197197197197197683683683683683683164164164164164164181718171817181718171817181718171817181718171817313031303130313031303130203520352035203520352035102102102102102102达到设计生产能力 原原材材料料、燃燃料料动动力力消消耗耗表表序号项 目单位单价（元）年耗量年费用（万元）1原材料1.1木材 280420000117601.2尿素t1400140081961.121.3甲醛t1200244802937.601.4烧碱(片状)t22009.12.001.5甲酸（含量85%）t52005.22.701.6氯化铵t200019539.001.7石蜡t45001620729.001.8三聚氰胺t64001450928.001.9特种润滑油l8512000102.001.10包装费600.001.11污水处理药剂费12.77小小 计计19074.1919074.192燃料动力2.1电kWh0.46518000002382.802.2水m31.120160022.182.3木废料及农作物秸秆t10032120321.20小小 计计2726.182726.18合合 计计21800.3721800.37单位变动成本元/m31090.02总总成成本本费费用用估估算算表表表14-3单位：万元序号项目投产期达产期34567891011一外购原材料152591907419074190741907419074190741907419074二外购燃料及动力218127262726272627262726272627262726三工资及福利560560560560560560560560560四折旧332533253325332533253325332533253325五修理费665665665665665665665665665六摊销费2626262626262626261 无形资产摊销8888888882 其他资产摊销181818181818181818七其他费用3008336833683368336833683368336833681 其它管理费用8968968968968968968968968962 其他制造费用6726726726726726726726726723 其他营业费用144018001800180018001800180018001800八财务费用1696150511988945782491021021021 长期借款利息1612140310977924761472 流动资金利息84102102102102102102102102九总成本费用267203125030943306383032229994298462984629846其中：固定成本94499449944994499449944994499449 可变成本2180021800218002180021800218002180021800十经营成本216732639326393263932639326393263932639326393十一 单位可变成本121314151907419074190741907427262726272627265605605605603325332533253325665665665665260008 18336833683368336889689689689667267267267218001800180018001021021021021021021021022984629820298202982094499449944994492180021800218002180026393263932639326393单位：万元损损益益表表序号项 目投产期达产期34567891011一产品销售收入288003600036000360003600036000360003600036000二销售税金及附加1733216621662166216621662166216621661增值税1651206320632063206320632063206320632城建税及教育附加83103103103103103103103103三总成本费用267203125030943306383032229994298462984629846四利润总额 34725842891319535123840398739873987五所得税00361399439480498498997六税后利润34725842530279630733360348934892991七盈余公积金35258253280307336349349299八法定公积金17129126140154168174174150九应付股利29220215238261286297297254十十未未分分配配利利润润2652651977197719351935213921392351235125702570266926692669266922882288十一累计未分配利润26522424177631686671123713906165751886312131415360003600036000360002166216621662166206320632063206310310310310329846298202982029820398740134013401399710031003100329913010301030102993013013011501501501502542562562562288228823032303230323032303230321151234542575628059长长期期借借款款还还本本付付息息计计算算表表序号项 目利率建设期投产期达产期123456789一期初借款余额5.76%2139927981243651903713751826125601本本金金208005200260002建建设设期期利利息息59913821981二当期还本付息1还还本本3616532852865490570225602付付息息161214031097792476147三期末借款余额243651903713751826125600四还款来源合计3616532852865490570259211利利润润265197719352139235125702折折旧旧费费3325332533253325332533253摊摊销销费费262626262626 10财务现金流量表(全部投资)序号项 目建设期投产期达产期年 份12345678一现金流入002880036000360003600036000360001产品销售 收入2880036000360003600036000360002回收固定资产余值3回收流动资金二现金 流出3320483012599429103289212895928999290401建设投资3320483012流动资金258754300003经营成本2167326393263932639326393263934销售税金及附加1733216621662166216621665所得税00361399439480三净现金流量-33204-8301280668977079704170016960四累计净现金流量-33204-41505-38698-31801-24722-17681-10680-3720计算指标：内部收益率10%净现值(R=8%)6121.30投资回收期8.54 单位:万元910111213141536000360003600036000360003600039130360003600036000360003600036000360000313029058290582955729557295632956329563000000026393263932639326393263932639326393216621662166216621662166216649849899799710031003100369426942644364436437643795673222101641660723050294873592445491达产期财财务务评评价价指指标标表表表14-1序号项目单位指标备注1总投资万元1.1 其中：固定资产万元1.2建设期贷款利息万元1.3 流动资金万元2销售收入万元/年3销售成本万元/年4销售利润万元/年5销售税金万元/年6投资利润率%7投资利税率%8内部收益率%9净现值万元10投资回收期年11盈亏平衡点%