风机整机制造部分的投资建设数据模型

风机整机制造部分的投资建设数据模型以下是对于风机整机制造部分的数据假设：1．投资元年：从第一年开始建设，从第二年开始投入运营生产。（注：如从第一年开始投入生产，计算结果将有轻微影响）2．投资金额：假设投资包括两阶段，投资共计1.5亿元人民币，用于基础建设和设备添置。3．分期贷款情况：应根据具体情况再安排。4．预期生产能力的设置，将根据对未来市场的估计，以500MW为标准生产能力，将可以满足8－10年的生产能力的需求。 （注，风机销售和风机生产的标准不同。风机销售以MW计算，风机生产以套计算。风机生产以每套为标准计算，在2010年以前，主要生产为1.3，1.5MW风机，500MW约为330－350套；2010年后，生产将转移到以2.5，3.5，5MW为主，500MW约为150套－250套。表中228％的生产量估计为400－450套。考虑到随着技术的不断更新和效率的不断提高，在不追加大量设备的情况下，被提高的生产率应该可以满足生产要求）5．投资成本，参照Nordex公司的历史数据标准和行业标准。6．燃料成本，参照一般加工，装配工业的成本结构。7．工资，参照Nordex的工资结构。德国和中国的工资结构和福利结构不同，实际执行标准可能低于该标准。8．研发成本，远高于国内一般标准（1.5%-2.5%）参照国际标准，更符合高科技行业标准，定在5％的收入比。9．管理费，销售费，等其他运营费，参照一般行业标准。10．营业收入，按500MW，￥6.9/每W计算。价格的波动应该被考虑，但由于原材料的变化和技术的升级，在没有特殊的原因（政策，国际环境等）原料采购价格将等于或大于产品销售价格的下降。11．流贷比，利率，流动资金等为假设数据，没有合适参考模型。附表一至九，分别为该投资评价的各部分。投资假设数据一、财务投资费用（万元）(不含建设期利息)第一年第二年第三年第四年第五年合计10000500015000二、分期贷款安排（万元）第一年第二年第三年第四年第五年合计贷款利息0000.00三、项目建成后达产情况（%）投资100％产能按500MW计算第一年第二年第三年第四年第五年第六年第七年第八年第九年第十年011.83658901151401661922280.00%11.80%36.00%58.00%90.00%115.00%140.00%166.00%192.00%228.00%四、流动资金安排计划（万元）第一年第二年第三年第四年第五年第六年第七年第八年第九年第十年合计0五、正常生产期总成本分项费用（万元）(每500MW的成本）(原材料占75％，科研占5％）原材料燃料动力工资福利修理费折旧费摊销费开发费管理费销售费土地费分项成本1001380015015831111172501502000100六、其他基础资料（万元）、（%）营业收入税金附加所得税率盈余公积固贷利率流贷利率流贷比例应付利润残值率效益下降费用增加投资增加折现率铺底流资税率1507615153.95.85005555153017.51507615.0%15.0%3.9%5.8%50.0%0.0%5.0%5.0%5.0%5.0%15.0%30.0%17.5%七、计算指标简述(100%产出）1.投资利润率（%）196.457.年均税前利润+年均营业税（万元）173682.投资利税率（%）115.798.投资总额（万元）(含利息及流动资金）150003.盈亏平衡点（%）2.539.无形资产（万元）100004.借款偿还期（年）10.递延资产（万元）10005.正常生产期总成本（万元）668,718其中：可变成本.00固定成本4091.44经营成本.006.年平均利润总额（万元）29467.97总成本费用估算表（附表一）单位：万元序号项目年份2.03.04.05.06.07.08.09.010.0合计生产负荷（%）11.836.058.090.0115.0140.0166.0192.0228.01.0外购原材料30532.593150.0.0.0.5.0.0.0.0.02.0外购燃料动力11.836.058.090.0115.0140.0166.0192.0228.01036.83.0工资及福利费1628.44968.08004.012420.015870.019320.022908.026496.031464.0.44.0修理费150.0150.0150.0150.0150.0150.0150.0150.0150.01350.05.0折旧费1583.31583.31583.31583.31583.31583.31583.31583.31583.314250.06.0摊销费1111.11111.11111.11111.11111.11111.11111.11111.11111.110000.07.0利息支出0.00.00.00.00.00.00.00.00.00.08.0技术开发研究费2035.56210.010005.015525.019837.524150.028635.033120.039330.0.09.0管理费17.754.087.0135.0172.5210.0249.0288.0342.01555.210.0销售费236.0720.01160.01800.02300.02800.03320.03840.04560.020736.011.0总成本费用37306.3.4.4.4.9.4.4.4.4.411.1固定成本3098.13618.44091.44779.45316.95854.46413.46972.47746.447891.211.2可变成本34208.2.0.0.0.0.0.0.0.0.212.0经营成本34611.9.0.0.0.5.0.0.0.0.4损益表（附表二）单位：万元序号项目年份2345678910合计生产负荷（%）11.83658901151401661922281销售收入40,710.00124,200.00200,100.00310,500.00396,750.00483,000.00572,700.00662,400.00786,600.003,576,960.002销售税金及附加1,779.005,427.458,744.2313,568.6317,337.6921,106.7525,026.5828,946.4034,373.85156,310.563总成本费用37,306.34107,982.44172,233.44265,689.44338,701.94411,714.44487,647.44563,580.44668,718.443,053,574.404利润总额1,624.6610,790.1119,122.3331,241.9340,710.3750,178.8160,025.9869,873.1683,507.71367,075.045弥补以前年度亏损6应纳所得税额1,624.6610,790.1119,122.3331,241.9340,710.3750,178.8160,025.9869,873.1683,507.71367,075.047所得税243.701,618.522,868.354,686.296,106.567,526.829,003.9010,480.9712,526.1655,061.268税后利润1,380.969,171.5916,253.9826,555.6434,603.8142,651.9851,022.0859,392.1870,981.55312,013.789可供分配利润1,380.969,171.5916,253.9826,555.6434,603.8142,651.9851,022.0859,392.1870,981.55312,013.7810盈余公积金207.141,375.742,438.103,983.355,190.576,397.807,653.318,908.8310,647.2346,802.0711应付利润----------12未分配利润1,173.827,795.8513,815.8822,572.2929,413.2436,254.1943,368.7750,483.3560,334.32265,211.7213累计未分配利润1,173.827,795.8513,815.8822,572.2929,413.2436,254.1943,368.7750,483.3560,334.32265,211.72借款还本付息计算表（附表三）单位：万元序号项目年份12345678910合计生产负荷（%）011.83658901151401661922281036.81借款及还本付息1.1年初借款本息累计----1.1.1本金----1.1.2建设期利息-----1.2本年借款------1.3本年应计利息------1.4本年还本----1.5本年付息-----2偿还能力3,868.2610,490.3016,510.3325,266.7432,107.6938,948.6346,063.2253,177.8063,028.76289,461.722.1未分配利润1,173.827,795.8513,815.8822,572.2929,413.2436,254.1943,368.7750,483.3560,334.32265,211.722.2折旧1,583.331,583.331,583.331,583.331,583.331,583.331,583.331,583.331,583.3314,250.002.3摊销1,111.111,111.111,111.111,111.111,111.111,111.111,111.111,111.111,111.1110,000.002.4其他资金3本年节余资金3,868.2610,490.3016,510.3325,266.7432,107.6938,948.6346,063.2253,177.8063,028.76289,461.724累计节余资金3,868.2614,358.5630,868.8856,135.6288,243.31127,191.94173,255.16226,432.95289,461.72289,461.72财务现金流量表(全部投资部分）（附表四）单位：万元项目年份12345678910合计生产负荷（%）011.8365890115140166192228现金流入-40,710.00124,200.00200,100.00310,500.00396,750.00483,000.00572,700.00662,400.001,078,715.463,869,075.46产品销售收入-40,710.00124,200.00200,100.00310,500.00396,750.00483,000.00572,700.00662,400.00786,600.003,576,960.00回收固定资产余值--回收流动资金292,115.46292,115.46现金流出10,000.0056,813.81143,332.38209,331.95322,239.55391,474.90469,676.73552,287.55633,617.45759,037.353,547,811.67固定资产投资10,000.005,000.0015,000.00流动资金15,179.2130,998.4128,180.3840,989.6432,023.1532,023.1533,304.0833,304.0846,113.34292,115.46经营成本34,611.90105,288.00169,539.00262,995.00336,007.50409,020.00484,953.00560,886.00666,024.003,029,324.40销售税金及附加1,779.005,427.458,744.2313,568.6317,337.6921,106.7525,026.5828,946.4034,373.85156,310.56所得税243.701,618.522,868.354,686.296,106.567,526.829,003.9010,480.9712,526.1655,061.26所得税后净现金流量-10,000.00-16,103.81-19,132.38-9,231.95-11,739.555,275.1013,323.2720,412.4528,782.55319,678.11321,263.78所得税后累计净现金流量-10,000.00-26,103.81-45,236.19-54,468.14-66,207.69-60,932.59-47,609.32-27,196.871,585.68321,263.78321,263.78所得税前净现金流量-10,000.00-15,860.11-17,513.86-6,363.60-7,053.2611,381.6620,850.1029,416.3439,263.52332,204.26376,325.04所得税前累计净现金流量-10,000.00-25,860.11-43,373.98-49,737.58-56,790.84-45,409.18-24,559.094,857.2644,120.78376,325.04376,325.04指标计算所得税后所得税前IRRNPV(万元)(Ic=10%)N(年)(静态)动态回收资金来源与运用表（附表五）单位：万元序号项目年份12345678910合计生产负荷（%）011.83658901151401661922281资金来源10,000.0024,498.3244,482.9649,997.1574,926.0175,427.9784,896.4096,024.51105,871.68132,315.49698,440.501.1利润总额1,624.6610,790.1119,122.3331,241.9340,710.3750,178.8160,025.9869,873.1683,507.71367,075.041.2折旧费1,583.331,583.331,583.331,583.331,583.331,583.331,583.331,583.331,583.3314,250.001.3摊销费1,111.111,111.111,111.111,111.111,111.111,111.111,111.111,111.111,111.1110,000.001.4长期借款0.000.000.000.000.000.000.000.000.000.000.001.5流动资金借款0.007,589.6115,499.2114,090.1920,494.8216,011.5816,011.5816,652.0416,652.0423,056.67146,057.731.6其他短期借款0.000.000.000.000.000.000.000.000.000.000.001.7自有资金10,000.0012,589.6115,499.2114,090.1920,494.8216,011.5816,011.5816,652.0416,652.0423,056.67161,057.731.8其他0.001.9回收固定资产余值0.000.001.10回收流动资金0.000.002资金运用10,000.0020,422.9132,616.9331,048.7345,675.9338,129.7139,549.9842,307.9843,785.05204,697.23508,234.442.1固定资产投资10,000.005,000.000.000.000.000.000.000.000.000.0015,000.002.2建设期利息0.000.000.000.000.000.000.000.000.000.000.002.3流动资金0.0015,179.2130,998.4128,180.3840,989.6432,023.1532,023.1533,304.0833,304.0846,113.34292,115.462.4所得税243.701,618.522,868.354,686.296,106.567,526.829,003.9010,480.9712,526.1655,061.262.5应付利润0.000.000.000.000.000.000.000.000.000.002.6长期借款本金偿还0.000.000.000.000.000.000.000.000.000.002.7流动资金借款本金偿还146,057.73146,057.732.8其他短期借款本金偿还0.003盈余资金0.004,075.4011,866.0318,948.4329,250.0937,298.2645,346.4353,716.5362,086.63-72,381.73190,206.064累计盈余资金0.004,075.4015,941.4434,889.8664,139.95101,438.21146,784.64200,501.16262,587.79190,206.06190,206.06投资计划与资金筹措表（附表六）单位：万元项目年份12345678910合计生产负荷（%）011.8365890115140166192228总投资10,000.0020,179.2130,998.4128,180.3840,989.6432,023.1532,023.1533,304.0833,304.0846,113.34307,115.46固定资产投资10,000.005,000.00---15,000.00建设期利息---流动资金-15,179.2130,998.4128,180.3840,989.6432,023.1532,023.1533,304.0833,304.0846,113.34292,115.46资金筹措10,000.0020,179.2130,998.4128,180.3840,989.6432,023.1532,023.1533,304.0833,304.0846,113.34307,115.46自有资金10,000.0012,589.6115,499.2114,090.1920,494.8216,011.5816,011.5816,652.0416,652.0423,056.67161,057.73用于流动资金-7,589.6115,499.2114,090.1920,494.8216,011.5816,011.5816,652.0416,652.0423,056.67146,057.73借款-7,589.6115,499.2114,090.1920,494.8216,011.5816,011.5816,652.0416,652.0423,056.67146,057.73长期借款（本金及建设期利息）-----------流动资金借款-7,589.6115,499.2114,090.1920,494.8216,011.5816,011.5816,652.0416,652.0423,056.67146,057.73其他短期借款-流动资金估算表（附表七）单位：万元序号项目年份周转次数2345678910合计生产负荷（%）11.83658901151401661922281流动资产19,542.6959,489.9195,805.58148,628.36189,896.15231,163.95274,082.46317,000.97376,426.601,712,036.671.1应收帐款74,944.5615,041.1424,219.8637,570.7148,001.0758,431.4369,279.0080,126.5795,146.29432,760.631.2存货14,218.1743,289.5769,718.12108,159.64138,192.08168,224.52199,458.26230,692.00273,938.711,245,891.091.2.1原材料74,361.7913,307.1421,439.2933,267.8642,508.9351,750.0061,360.7170,971.4384,278.57383,245.711.2.2燃料120.983.004.837.509.5811.6713.8316.0019.0086.401.2.3在产品74,910.8414,938.2924,054.1437,313.5747,672.5058,031.4368,804.7179,578.0094,494.86429,798.341.2.4产成品74,944.5615,041.1424,219.8637,570.7148,001.0758,431.4369,279.0080,126.5795,146.29432,760.631.2.5其他-1.3现金10379.961,159.201,867.602,898.003,703.004,508.005,345.206,182.407,341.6033,384.962流动负债4,363.4713,312.2921,447.5733,280.7142,525.3651,770.0061,384.4370,998.8684,311.14383,393.832.1应付帐款74,363.4713,312.2921,447.5733,280.7142,525.3651,770.0061,384.4370,998.8684,311.14383,393.833流动资金15,179.2146,177.6374,358.00115,347.64147,370.80179,393.95212,698.03246,002.11292,115.461,328,642.854自有流动资金7,589.6115,499.2114,090.1920,494.8216,011.5816,011.5816,652.0416,652.0423,056.67146,057.735流动资金本年度增加额15,179.2130,998.4128,180.3840,989.6432,023.1532,023.1533,304.0833,304.0846,113.34292,115.466流动资金偿还--7利息440.20898.95817.231,188.70928.67928.67965.82965.821,337.298,471.35资产负债表（附表八）单位：万元序号项目年份12345678910生产负荷（%）011.83658901151401661922281资产10,000.0065,861.79124,909.45173,841.55264,887.72330,876.74413,880.41508,153.62609,516.00605,404.401.1流动资产总额23,238.1374,272.15128,827.84209,870.31287,631.36373,440.59469,238.43573,406.36559,291.061.1.1应收帐款4,944.5615,041.1424,219.8637,570.7148,001.0758,431.4369,279.0080,126.5795,146.291.1.2存货14,218.1743,289.5769,718.12108,159.64138,192.08168,224.52199,458.26230,692.00273,938.711.1.3现金379.961,159.201,867.602,898.003,703.004,508.005,345.206,182.407,341.601.1.4累计盈余资金4,075.4015,941.4434,889.8664,139.95101,438.21146,784.64200,501.16262,587.79190,206.061.2在建工程10,000.0020,179.2130,998.4128,180.3840,989.6432,023.1532,023.1533,304.0833,304.0846,113.341.3固定资产净值12,666.6711,083.339,500.007,916.676,333.334,750.003,166.671,583.33-1.4无形资产及递延资产净值9,777.788,555.567,333.336,111.114,888.893,666.672,444.441,222.22-2负债及所有者权益2.1流动负债总额11,953.0828,811.4935,537.7653,775.5358,536.9367,781.5878,036.4787,650.90107,367.812.1.1应付帐款4,363.4713,312.2921,447.5733,280.7142,525.3651,770.0061,384.4370,998.8684,311.142.1.2流动资金借款7,589.6115,499.2114,090.1920,494.8216,011.5816,011.5816,652.0416,652.0423,056.672.1.3其他短期借款----------2.2长期借款----------负债小计-11,953.0828,811.4935,537.7653,775.5358,536.9367,781.5878,036.4787,650.90107,367.812.3所有者权益10,000.0023,970.5747,260.4068,432.9899,229.46123,289.21147,348.96172,371.10197,393.24232,039.282.3.1资本金