宏酷财税-投资评估表.xlsx

1、650型中温整套线价格50万。厂房占地面积500平方米。用人14人。8小时9吨。面粉重量等于挂面重量。装机容量1.1kw1台。0.75kw1台。15kw 2台。4kw 1台。11kw 1台。0.75kw 1台。3kw 1台。1.5kw 1台。注：厂房面积是设备的占地面积。用人：设备用人和包面用人在内。2、厂房是租赁，每平方600元/年650型中温设备价格50万。厂房占地面积500平方米。设备共用人14人（拌面2人，看主机1人，烧炉子和看烘房1人，剩余人为包面人员）。用水量：100斤面用水29斤。总装机容量：52.1kw。8小时计算。9吨面耗电45kw。650设备整套50万，厂房占地面积500平方米。设备共用人14人(拌面2人，看主机1人，烧炉子和烘房1人。）剩余的人为包面用人。用水量100斤面加水29斤。水价地方差价不等。装机总容量共计52.1kw。8小时计算。9吨面耗电45kw，因不会同时使用工人一般1800元挂面均价暂定2.6元参参数数表表设设立立期期第第1 1年年第第2 2年年第第3 3年年第第4 4年年第第5 5年年第第6 6年年第第7 7年年第第8 8年年第第9 9年年第第1010年年投投入入主主要要参参数数单单位位2019年11月-12月2012201320142015201620172018201920202021设备650型中温整套线500,000人民币 元500,0000000000000电45千瓦/每天45454545454545454545451.1kw1台0.75kw1台15kw2台4kw1台11kw1台0.75kw1台3kw1台1.5kw1台电单价1.0元/千瓦1.01.01.11.11.21.21.31.31.41.51.6厂房占地面积500平方米500500500500500500500500500500500租金600.0平方米/年150.0600.0618.0636.5655.6675.3695.6716.4737.9760.1782.9租金年涨幅3%0%3%3%3%3%3%3%3%3%3%3%运行杂费（损耗维修清洁等）50,000.0元/年12,500.050,000.051,500.053,045.054,636.456,275.457,963.759,702.661,493.763,338.565,238.7运行杂费年涨幅3%0%3%3%3%3%3%3%3%3%3%3%人工全部工人14人1414141414141414141414拌面2人看主机1人烧炉子和烘房1人其他用人（包面，发货等）10人月平均工资/人-元1,800.0元/人月1,800.01,800.01,890.01,984.52,083.72,187.92,297.32,412.22,532.82,659.42,792.4发薪月数12月212121212121212121212原材料面9吨/每天99999999999面单价3000.0元/吨3,000.03,000.03,150.03,307.53,472.93,646.53,828.84,020.34,221.34,432.44,654.0水=0.29x面重吨/每天2.612.612.612.612.612.612.612.612.612.612.61水单价4.0元/吨4.04.04.24.44.64.95.15.45.65.96.2产产出出利用率87%87.0%87.0%87.0%87.0%87.0%87.0%87.0%87.0%87.0%87.0%87.0%开工天数26天/月52312312312312312312312312312312销销售售敏敏感感性性分分析析点点单位产能9吨/每天99999999999销量=产量(8小时9吨面)吨/每天99999999999销售单价5,200.0元/吨5,200.05,200.05,460.05,733.06,019.76,320.66,636.76,968.57,316.97,682.88,066.9宏宏观观经经济济参参数数物价上涨幅度5%0%5%5%5%5%5%5%5%5%5%5%涨薪率5%0%5%5%5%5%5%5%5%5%5%5%税率10%10%10%10%10%10%10%10%10%10%10%10%损损益益表表设设立立期期第第1 1年年第第2 2年年第第3 3年年第第4 4年年第第5 5年年第第6 6年年第第7 7年年第第8 8年年第第9 9年年第第1010年年不不含含机机器器成成本本的的单单日日损损益益2011年10月-12月2012201320142015201620172018201920202021收入46,8002,433,69414,602,16215,332,27016,098,88316,903,82717,749,01918,636,47019,568,29320,546,70821,574,04322,652,745成本29,5322,044,8379,094,0229,541,72310,011,59910,504,75311,022,34111,565,58012,135,74412,734,17313,362,27214,021,519机器500,0000000000000厂房96275,000300,000309,000318,270327,818337,653347,782358,216368,962380,031391,432原材料-面27,0001,404,0548,424,3248,845,5409,287,8179,752,20810,239,81810,751,80911,289,40011,853,87012,446,56313,068,892水365433,2573,4203,5913,7713,9594,1574,3654,5834,8135,053电4052,34014,04114,74315,48016,25417,06617,92018,81619,75620,74421,781人工96950,400302,400317,520333,396350,066367,569385,948405,245425,507446,783469,122杂费16012,50050,00051,50053,04554,63656,27557,96459,70361,49463,33965,239净利17,268388,8575,508,1405,790,5476,087,2846,399,0746,726,6777,070,8907,432,5497,812,5358,211,7718,631,227净净利利率率37%37%16.0%16.0%37.7%37.7%37.8%37.8%37.8%37.8%37.9%37.9%37.9%37.9%37.9%37.9%38.0%38.0%38.0%38.0%38.1%38.1%38.1%38.1%所得税1,727589,700579,055608,728639,907672,668707,089743,255781,253821,177863,123税后净利15,541388,8574,918,4405,211,4925,478,5565,759,1676,054,0106,363,8016,689,2947,031,2817,390,5947,768,104机器投入人民币 500,000约约等等于于3232天天收收回回投投资资单单位位损损益益计计算算第第一一年年每每日日单位：元/斤单单价价2.6002.600单单位位成成本本1.7021.702原材料-面1.500水0.001电0.003人工0.054杂费0.009机器0.030厂房0.107税税前前净净利利0.8980.898所得税0.090税税后后净净利利0.8080.808利润率31.1%2.6元/斤1.5元/斤水用量=0.29x面重；水 4元/吨9吨面耗电45kw;电单价1元/千瓦设备共用人14人;工资1800元/月运行杂费5万/年50万，3年摊销。总产能为26天*12个月*18000斤/天*3年60万/年，对应产量26天*12个月*18000斤/天盈盈亏亏平平衡衡点点分分析析销销量量定定价价决决策策第第一一年年每每日日单位：元/斤单单价价2.6002.600单单价价变变动动成成本本1.5661.5662.6002.600原材料-面1.5002.5002.500水0.0012.4002.400电0.0032.3002.300人工0.0542.2002.200杂费0.0092.1002.100单单位位边边际际贡贡献献1.0341.0342.0002.0001.9001.900日日固固定定成成本本2,4572,4571.8001.800机器5341.7001.700厂房1,923盈盈亏亏平平衡衡点点产产量量(斤斤）2,3762,376第第一一年年每每日日销销量量(斤)2,3762,3763,0003,0004,0004,0005,0005,0006,0006,000增/降幅26%33%25%20%06451,6792,7143,748-3.8%(238)3451,2792,2143,148-4.0%(475)458791,7142,548-4.2%(713)(255)4791,2141,948-4.3%(950)(555)797141,348-4.5%(1,188)(855)(321)214748-4.8%(1,426)(1,155)(721)(286)148-5.0%(1,663)(1,455)(1,121)(786)(452)-5.3%(1,901)(1,755)(1,521)(1,286)(1,052)-5.6%(2,138)(2,055)(1,921)(1,786)(1,652)8,0008,00010,00010,00012,00012,00015,00015,00018,00018,00033%25%20%25%20%5,8167,8849,95313,05516,1585,0166,8848,75311,55514,3584,2165,8847,55310,05512,5583,4164,8846,3538,55510,7582,6163,8845,1537,0558,9581,8162,8843,9535,5557,1581,0161,8842,7534,0555,3582168841,5532,5553,558(584)(116)3531,0551,758(1,384)(1,116)(847)(445)(42)第第一一年年每每日日