申報稿年產3000噸松香840噸松節油項目可行性研究報告excel表格財務分析軟件帶計算公式word.xls
下載文檔
上傳人:正***
編號:850754
2023-12-20
9頁
97.50KB
1、附件1項項目目投投資資現現金金流流量量表表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元序號費用名稱建設期投產期達產期0123456789101現金流入2,106.002,808.003,510.003,510.003,510.003,510.003,510.003,510.003,510.004,710.141.1營業收入2,106.002,808.003,510.003,510.003,510.003,510.003,510.003,510.003,510.003,510.001.2補貼收入1.3回收固定資產余值498.141.4回收全部流動資金702.002現金流2、出1,189.522,373.742,543.932,619.972,619.972,619.972,619.972,619.972,619.972,619.972,619.972.1建設投資1,189.522.2流動資金561.60140.402.3經營成本1,654.932,170.902,329.182,329.182,329.182,329.182,329.182,329.182,329.182,329.182.4營業稅及附加157.21232.63290.79290.79290.79290.79290.79290.79290.79290.792.5維持運營投資3所得稅前凈現金流量(13、2)-1,189.52-267.74264.07890.03890.03890.03890.03890.03890.03890.032,090.174累計所得稅前凈現金流量-1,189.52-1,457.26-1,193.19-303.16586.881,476.912,366.943,256.984,147.015,037.057,127.225調整所得稅33.3955.51154.98157.33159.68163.95163.95163.95163.95163.956所得稅后凈現金流量(35)-1,189.52-301.13208.56735.06732.70730.35726.08724、6.08726.08726.081,926.227累計所得稅后凈現金流量-1,189.52-1,490.65-1,282.09-547.03185.67916.021,642.102,368.183,094.253,820.335,746.55第51頁共59頁附件2借借款款還還本本付付息息計計劃劃表表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元序序號號年年 份份0123451 1期初借款余額400.74822.34762.74562.74362.742 2當年借款389.52561.60140.403 3當年還本付息196.64256.66244.89233.12385、4.094 4其中:本金140.00200.00200.00200.00362.745 5利息11.2256.6456.6644.8933.1221.356 6期末余額400.74822.34762.74562.74362.74-0.00第52頁共59頁附件3財財務務計計劃劃現現金金流流量量表表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元序號項目合計計算期0123456789101 經營活動凈現金流量(1.1-1.2)6,421.49-16.44260.47348.96735.06732.70730.35726.08726.08726.08726.08726.081.6、1 現金流入32,994.00-2,106.002,808.003,510.003,510.003,510.003,510.003,510.003,510.003,510.003,510.001.1.1營業收入28,200.001,800.002,400.003,000.003,000.003,000.003,000.003,000.003,000.003,000.003,000.001.1.2增值稅銷項稅額4,794.00306.00408.00510.00510.00510.00510.00510.00510.00510.00510.001.1.3補貼收入-1.1.4其他流入-1.2 現金7、流出26,572.5116.441,845.532,459.042,774.942,777.302,779.652,783.922,783.922,783.922,783.922,783.921.2.1經營成本20,268.501,515.091,984.452,096.122,096.122,096.122,096.122,096.122,096.122,096.122,096.121.2.2增值稅進項稅額2,207.2116.44139.84186.45233.06233.06233.06233.06233.06233.06233.06233.061.2.3營業稅金及附加129.347.48、911.0813.8513.8513.8513.8513.8513.8513.8513.851.2.4增值稅2,586.79149.72221.55276.94276.94276.94276.94276.94276.94276.94276.941.2.5所得稅1,380.6733.3955.51154.98157.33159.68163.95163.95163.95163.95163.951.2.6其他流出-2 投資活動凈現金流量(2.1-2.2)-674.94-1,173.08-561.60-140.40-1,200.142.1 現金流入1,200.141,200.142.2 現金流出1,89、75.081,173.08561.60140.40-2.2.1建設投資1,173.081,173.082.2.2維持運營投資-2.2.3流動資金702.00561.60140.402.2.4其他流出-3 籌資活動凈現金流量(3.1-3.2)576.121,189.52364.96-116.26-244.89-233.12-384.09-3.1 現金流入1,891.521,189.52561.60140.40-3.1.1項目資本金投入800.00800.003.1.2建設投資借款389.52389.523.1.3流動資金借款702.00561.60140.40-3.1.4債券-3.1.5短期借款10、-3.1.6其他流入-3.2 現金流出1,315.40-196.64256.66244.89233.12384.09-3.2.1各種利息支出212.6656.6456.6644.8933.1221.35-3.2.2償還債務本金1,102.74140.00200.00200.00200.00362.74-3.2.3應付利潤(股利分配)-3.2.4其他流出-4 凈現金流量(1+2+3)6,322.67-63.8392.30490.17499.58346.26726.08726.08726.08726.081,926.225 累計盈余資金6,322.67-63.83156.13646.291,14511、.871,492.132,218.212,944.293,670.374,396.456,322.67第53頁共59頁附件4投投資資各各方方現現金金流流量量表表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元序號項目合計計算期0123456789101現金流入6,804.02-179.77513.04703.811,294.05590.24590.24590.242,342.651.1實分利潤5,051.61179.77513.04703.811,294.05590.24590.24590.24590.241.2資產處置收益分配1,752.411,752.411.3租賃費12、收入-1.4技術轉讓或適用收入-1.5其他現金流入-2現金流出800.00800.00-2.1實繳資本800.00800.002.2租賃資產支出-2.3其他現金流出-3凈現金流量(1-2)6,004.02-800.00-179.77513.04703.811,294.05590.24590.24590.242,342.65第54頁共59頁附件5資資產產負負債債表表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元序號項 目合計計算期0123456789101資產25,123.041,200.741,755.911,841.921,842.411,907.791,895.5813、2,196.422,566.082,935.743,305.393,675.061.1流動資產總額16,277.34-625.43781.70852.45988.091,046.141,417.241,857.162,297.082,736.993,675.061.1.1貨幣資金10,099.7463.8379.70150.45286.09344.14715.241,155.161,595.082,034.993,675.061.1.2應收賬款-1.1.3預付賬款-1.1.4存貨6,177.60561.60702.00702.00702.00702.00702.00702.00702.007014、2.00-1.1.5其他-1.2在建工程1,200.741,200.741.3固定資產凈值7,644.961,130.481,060.22989.96919.70849.44779.18708.92638.66568.401.4無形及其他資產凈值-2負債及所有者權益(2.4+2.5)25,123.041,200.741,755.911,841.921,842.411,907.791,895.582,196.422,566.082,935.743,305.393,675.062.1流動負債總額-2.1.1短期借款-2.1.2應付賬款-2.1.3預收賬款-2.1.4其他-2.2建設投資借款722.15、22400.74260.7460.742.3流動資金借款2,189.08561.60702.00562.74362.74-2.4負債小計(2.1+2.2+2.3)2,911.30400.74822.34762.74562.74362.74-2.5所有者權益22,211.74800.00933.571,079.181,279.671,545.051,895.582,196.422,566.082,935.743,305.393,675.062.5.1資本金8,800.00800.00800.00800.00800.00800.00800.00800.00800.00800.00800.0080016、.002.5.2資本公積-2.5.3累計盈余公積金1,606.6613.3635.5668.94103.25138.51175.48212.44249.41286.37323.342.5.4累計未分配利潤11,805.08120.21243.62410.73641.80957.071,220.941,553.641,886.332,219.022,551.72第55頁共59頁附件6利利潤潤與與利利潤潤分分配配表表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元序序號號年年份份123456789101營業收入2,106.002,808.003,510.003,510.00317、,510.003,510.003,510.003,510.003,510.003,510.002總成本費用1,781.832,297.822,444.332,432.562,420.792,399.442,399.442,399.442,399.442,399.443營業稅金及附加157.21232.63290.79290.79290.79290.79290.79290.79290.79290.794利潤總額-166.96277.55774.88786.65798.42819.77819.77819.77819.77819.775彌補以前年度虧損6應納稅所得額166.96277.55774.818、8786.65798.42819.77819.77819.77819.77819.777所得稅20%33.3955.51154.98157.33159.68163.95163.95163.95163.95163.958凈利潤-133.57222.04619.91629.32638.74655.82655.82655.82655.82655.829期初未分配利潤(或期初未彌補的虧損)-76.43-133.26179.77513.04703.81-10可供分配利潤(或)133.57145.61486.65809.091,151.781,359.63655.82655.82655.82655.82119、1法定盈余公積金10%13.3622.2061.9962.9363.8765.5865.5865.5865.5865.5812可供投資者分配利潤120.21123.41424.66746.161,087.901,294.05590.24590.24590.24590.2413應付投資者各方利潤-76.43-133.26179.77513.04703.811,294.05590.24590.24590.24590.2414未分配利潤196.64256.66244.89233.12384.09-15息稅前利潤(年利息支出)223.60334.21819.77819.77819.77819.778120、9.77819.77819.77819.7716息稅折舊攤銷前利潤折舊攤銷293.86404.47890.03890.03890.03890.03890.03890.03890.03890.03第56頁共59頁附件7稅金計算表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元項目12345678910增值稅-銷項稅306.00408.00510.00510.00510.00510.00510.00510.00510.00510.00增值稅-進項稅156.28186.45233.06233.06233.06233.06233.06233.06233.06233.06原料13621、.66182.21227.76227.76227.76227.76227.76227.76227.76227.76電0.520.700.870.870.870.870.870.870.870.87水0.040.060.070.070.070.070.070.070.070.07煤2.623.494.364.364.364.364.364.364.364.36購進設備16.44應交增值稅149.72221.55276.94276.94276.94276.94276.94276.94276.94276.94附加稅7.4911.0813.8513.8513.8513.8513.8513.8513.822、513.85稅金合計157.21232.63290.79290.79290.79290.79290.79290.79290.79290.79第57頁共59頁附件8項項目目資資本本金金現現金金流流量量表表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元序號項 目合計計算期0123456789101現金流入34,194.142,106.002,808.003,510.003,510.003,510.003,510.003,510.003,510.003,510.004,710.141.1營業收入32,994.002,106.002,808.003,510.003,510.0023、3,510.003,510.003,510.003,510.003,510.003,510.001.2補貼收入-1.3回收固定資產余值498.14-498.141.4回收流動資金702.00-702.002現金流出28,671.47800.002,042.172,715.703,019.833,010.423,163.742,783.922,783.922,783.922,783.922,783.922.1項目資本金800.00800.002.2借款本金償還1,102.74140.00200.00200.00200.00362.74-2.3借款利息支付212.6656.6456.6644.8924、33.1221.35-2.4經營成本22,459.271,654.932,170.902,329.182,329.182,329.182,329.182,329.182,329.182,329.182,329.182.5營業稅金及附加2,716.13157.21232.63290.79290.79290.79290.79290.79290.79290.79290.792.6所得稅1,380.6733.3955.51154.98157.33159.68163.95163.95163.95163.95163.952.7維持運營投資-3凈現金流量(1-2)5,522.67-800.0063.839225、.30490.17499.58346.26726.08726.08726.08726.081,926.22第58頁共59頁附件9總總成成本本費費用用表表項目實施單位:*林業化工有限公司 2009年4月 金額單位:人民幣萬元序號費用名稱合計計算期12345678910生產負荷60%80%100%100%100%100%100%100%100%100%1原材料、燃料動力13,950.111,073.091,430.781,430.781,430.781,430.781,430.781,430.781,430.781,430.781,430.782工資及福利費2,820.00180.00240.0026、300.00300.00300.00300.00300.00300.00300.00300.003制造費用3,092.36261.50289.58317.66317.66317.66317.66317.66317.66317.66317.663.1折舊費702.6070.2670.2670.2670.2670.2670.2670.2670.2670.2670.263.2工資及福利費1,070.00107.00107.00107.00107.00107.00107.00107.00107.00107.00107.003.3修理費659.8842.1256.1670.2070.2070.2070.27、2070.2070.2070.2070.203.4其他制造費用659.8842.1256.1670.2070.2070.2070.2070.2070.2070.2070.204產品制造成本(1+2+3)19,862.471,514.591,960.362,048.442,048.442,048.442,048.442,048.442,048.442,048.442,048.445管理費用1,649.70105.30140.40175.50175.50175.50175.50175.50175.50175.50175.506財務費用212.6656.6456.6644.8933.1221.35628、.1其中:利息支出212.6656.6456.6644.8933.1221.357營業費用1,649.70105.30140.40175.50175.50175.50175.50175.50175.50175.50175.508期間費用合計(5+6+7)3,512.06267.24337.46395.89384.12372.35351.00351.00351.00351.00351.009總成本費用(4+8)23,374.531,781.832,297.822,444.332,432.562,420.792,399.442,399.442,399.442,399.442,399.449.1其中:(1)固定成本6,604.42528.74627.04713.55701.78690.01668.66668.66668.66668.66668.669.2其中:(2)可變成本16,770.111,253.091,670.781,730.781,730.781,730.781,730.781,730.781,730.781,730.781,730.7810經營成本(9-3.1-6.1)22,459.271,654.932,170.902,329.182,329.182,329.182,329.182,329.182,329.182,329.182,329.18第59頁共59頁
地產規劃
上傳時間:2024-10-10
163份