產(chǎn)業(yè)園投資估算及財(cái)務(wù)分析模型

1、項(xiàng)項(xiàng)目目總總投投資資估估算算表表項(xiàng)項(xiàng)目目收收益益估估算算表表序序號(hào)號(hào)項(xiàng)項(xiàng)目目名名稱稱總總額額（萬萬元元）占占總總投投資資比比例例項(xiàng)項(xiàng)目目1地 價(jià)82,80019.7%總建筑面積（m2)2前期工程費(fèi)23,9205.7%銷售面積（m2)3建安工程150,32835.8%自持面積（m2)銷售收入(萬元）4不可預(yù)見費(fèi)8,7122.1%租金收入(萬元/年）5管理費(fèi)8,7122.1%6其他費(fèi)用30,9127.4%稅后利潤（萬元）7財(cái)務(wù)費(fèi)用100,75924.0%投資利潤率8銷售費(fèi)用13,2483.2%財(cái)務(wù)凈現(xiàn)值 （萬元）9合 計(jì)419,392100.0%內(nèi)部收益率備備注注: :1.1.第第9 9季季度度開

2、開售售，開開盤盤銷銷售售率率30%30%，項(xiàng)項(xiàng)目目竣竣工工后后一一年年半半銷銷售售率率達(dá)達(dá)到到80%80%。（假假定定條條件件）2.2.開開盤盤銷銷售售時(shí)時(shí)，收收取取30%30%定定金金，項(xiàng)項(xiàng)目目竣竣工工后后一一年年收收取取銷銷售售尾尾款款。3.3.以以上上數(shù)數(shù)據(jù)據(jù)未未計(jì)計(jì)算算企企業(yè)業(yè)所所得得稅稅。4.4.建建安安工工程程費(fèi)費(fèi)用用包包含含土土建建，安安裝裝，園園林林，配配套套。5.5.項(xiàng)項(xiàng)目目竣竣工工一一年年后后，即即從從收收取取尾尾款款開開始始，將將陸陸續(xù)續(xù)償償還還借借款款本本金金。重要程度變量數(shù)值數(shù)數(shù)額額容積率2368000自持比例0.5184000銷售單價(jià)3萬元/m2184000借款利率

3、10%土地價(jià)格300萬元/畝441600租金單價(jià)3元/m2天16118-9,751-2.3%2555712.11%項(xiàng)項(xiàng)目目收收益益估估算算表表附附表表2：項(xiàng)項(xiàng)目目開開發(fā)發(fā)總總成成本本估估算算表表計(jì)入容積率建筑面積(m2)368000序序號(hào)號(hào)項(xiàng)項(xiàng)目目名名稱稱計(jì)計(jì)算算程程式式單單價(jià)價(jià)（元元/m2）金金額額(萬萬元元）備備注注一土地成本2,25082,800.00二前期工程費(fèi)2.1勘察測量費(fèi)501,840.002.2規(guī)劃設(shè)計(jì)費(fèi)30011,040.002.3臨時(shí)供水供電1003,680.002.4場地平整及道路1003,680.002.5其它費(fèi)用1003,680.00前期工程小計(jì)2.12.565023

4、,920三建筑安裝工程費(fèi)3.1基礎(chǔ)工程費(fèi)30011,040.003.2土建工程費(fèi)1,60058,880.003.3安裝工程費(fèi)1,38550,9683.3.1 水電安裝30011,040.003.3.2 電梯工程1204,416.003.3.3 空調(diào)工程30011,040.003.3.4 消防工程1806,624.003.3.5 通訊工程1003,680.003.3.6 公共裝修32011,776.003.3.7 燃?xì)夤こ?.3.8 對講系統(tǒng)501,840.003.3.9 公用天線15552.003.4園林綠化30011,040.003.5室外配套50018,400.00建安工程小計(jì)3.13.5

5、4,085150,328.00四不可預(yù)見費(fèi)2378,712.40五管理費(fèi)用2378,712.40六其它費(fèi)用6.1工程監(jiān)理費(fèi)602,208.006.2熱力配套1605,888.006.3電力配套30011,040.006.4代征道路1003,680.006.5墻改基金20736.006.6管網(wǎng)配套2007,360.00其他費(fèi)用小計(jì)6.16.784030,912.00七合計(jì)(二)(六)6,049222,584.80八總開發(fā)成本(一)+(七)8,299305,384.80附附表表3：投投資資計(jì)計(jì)劃劃表表單位：萬元序號(hào) 項(xiàng)目名稱投資總額第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第

6、6 6季季第第7 7季季第第8 8季季第第9季季一土地成本82800.0082800.00二前期費(fèi)用23920.0011960.0011960.00三基礎(chǔ)工程費(fèi)11040.003312.005520.001656.00四土建工程費(fèi)58880.0017664.0011776.0011776.008832.00五安裝工程費(fèi)50968.0015290.40六園林綠化11040.003312.00七室外配套18400.005520.00八不可預(yù)見費(fèi)8712.40726.03726.03726.03726.03726.03726.03726.03726.03726.03九管理費(fèi)8712.40726.03

7、726.03726.03726.03726.03726.03726.03726.03726.03十其它費(fèi)用30912.003091.203091.203091.203091.203091.203091.203091.20十一 合計(jì)305384.8096212.0713412.077855.2710063.2722207.2716319.2716319.2715031.2728665.67注：1.土地成本按計(jì)算初期一次性投入計(jì)。 2.按照通常情況,工程費(fèi)用中5%留取保修金及滯留金，竣工驗(yàn)收后一年付出。 3.工程款的支付與工程進(jìn)度表相對應(yīng)，不考慮工程隊(duì)大額墊資，按工程進(jìn)度付款， 竣工驗(yàn)收后支付率達(dá)

8、95%，其它部分在工程建設(shè)過程中平均投入。附附表表3：序號(hào) 項(xiàng)目名稱一土地成本二前期費(fèi)用三基礎(chǔ)工程費(fèi)四土建工程費(fèi)五安裝工程費(fèi)六園林綠化七室外配套八不可預(yù)見費(fèi)九管理費(fèi)十其它費(fèi)用十一 合計(jì)投投資資計(jì)計(jì)劃劃表表（續(xù)續(xù)表表）單位：萬元第第10季季第第1111季季第第1212季季第第1313季季第第1414季季第第1515季季第第1616季季552.002944.0010193.6010193.6015290.402548.402208.002208.003312.00552.003680.003680.005520.00920.00726.03726.03726.03726.03726.03726.0

9、33091.203091.203091.2020624.8720624.8732161.674020.40附附表表4：項(xiàng)項(xiàng)目目銷銷售售回回款款計(jì)計(jì)劃劃表表項(xiàng)目內(nèi)容銷銷售售建建筑筑面面積積(m2）銷銷售售價(jià)價(jià)格格（元元/m2）總總價(jià)價(jià)（萬萬元元）備備注注銷售184000.0030,000552,000.00自持184000.00合計(jì)368000.00552,000.00銷售率100%銷售收入552,000.00計(jì)算期（季度）銷銷售售比比例例回回款款比比例例回回款款金金額額合合計(jì)計(jì)銷銷售售自自持持銷銷售售自自持持銷銷售售自自持持12345678930.00%10.00%55,200.0055,20

10、0.00105.00%1.67%9,200.009,200.00115.00%1.67%9,200.009,200.00125.00%1.67%9,200.009,200.00135.00%1.67%9,200.009,200.00145.00%1.67%9,200.009,200.00155.00%1.67%9,200.009,200.00165.00%45.00%248,400.00248,400.00175.00%5.00%27,600.0027,600.00185.00%5.00%27,600.0027,600.00195.00%5.00%27,600.0027,600.00合計(jì)80.

11、00%80.00%441,600.00441,600.00注：銷售考慮開盤去化可售部分50%，竣工后完成整體物業(yè)50T%銷售，銷售回款計(jì)劃綜合考慮銀行按揭放款時(shí)間。辦公樓出租按每季度10%遞增測算，竣工后兩年內(nèi)達(dá)到80%入住率。附表5:資資金金來來源源與與運(yùn)運(yùn)用用表表單單位位：萬萬元元序號(hào) 季度項(xiàng)目12345678910一一資資金金來來源源120,586.55120,586.5519,710.3919,710.3990,840.1990,840.19147,069.36147,069.369,200.009,200.001 1經(jīng)經(jīng)營營活活動(dòng)動(dòng)產(chǎn)產(chǎn)生生的的現(xiàn)現(xiàn)金金來來源源55,200.0055,

12、200.009,200.009,200.001.11.1銷銷售售收收入入55,200.0055,200.009,200.009,200.002 2 籌籌資資活活動(dòng)動(dòng)產(chǎn)產(chǎn)生生的的現(xiàn)現(xiàn)金金來來源源120,586.55120,586.5519,710.3919,710.3990,840.1990,840.1991,869.3691,869.362.12.1自自有有資資金金2.22.2銀銀行行借借款款1205871205871971019710908409084091869918693 3其其它它來來源源二二資資金金運(yùn)運(yùn)用用102,241.39102,241.3913,412.0713,412.071

13、4,870.1114,870.1110,063.2710,063.2745,320.9845,320.9816,319.2716,319.2716,319.2716,319.2715,031.2715,031.2765,437.5165,437.5121,600.2521,600.251 1建建設(shè)設(shè)期期開開發(fā)發(fā)成成本本96,212.0796,212.0713,412.0713,412.077,855.277,855.2710,063.2710,063.2722,207.2722,207.2716,319.2716,319.2716,319.2716,319.2715,031.2715,031.

14、2728,665.6728,665.6720,624.8720,624.872 2經(jīng)經(jīng)營營期期當(dāng)當(dāng)期期發(fā)發(fā)生生營營業(yè)業(yè)成成本本3 3銷銷售售費(fèi)費(fèi)用用1,656.001,656.00276.00276.004 4銷銷售售稅稅費(fèi)費(fèi)2,815.202,815.20469.20469.205 5增增值值稅稅230.19230.196 6盈盈余余公公積積7 7應(yīng)應(yīng)付付利利潤潤8 8借借款款本本金金償償還還9 9借借款款利利息息支支付付6,029.336,029.337,014.857,014.8523,113.7123,113.7132,300.6532,300.65三三盈盈余余資資金金18,345.1

15、518,345.15-13,412.07-13,412.074,840.274,840.27-10,063.27-10,063.2745,519.2145,519.21-16,319.27-16,319.27-16,319.27-16,319.27-15,031.27-15,031.2781,631.8581,631.85-12,400.25-12,400.25四四累累計(jì)計(jì)盈盈余余資資金金18,345.1518,345.154,933.094,933.099,773.369,773.36-289.91-289.9145,229.3045,229.3028,910.0328,910.0312,5

16、90.7712,590.77-2,440.50-2,440.5079,191.3579,191.3566,791.0966,791.09附表5:序號(hào) 季度項(xiàng)目一一資資金金來來源源1 1經(jīng)經(jīng)營營活活動(dòng)動(dòng)產(chǎn)產(chǎn)生生的的現(xiàn)現(xiàn)金金來來源源1.11.1銷銷售售收收入入2 2 籌籌資資活活動(dòng)動(dòng)產(chǎn)產(chǎn)生生的的現(xiàn)現(xiàn)金金來來源源2.12.1自自有有資資金金2.22.2銀銀行行借借款款3 3其其它它來來源源二二資資金金運(yùn)運(yùn)用用1 1建建設(shè)設(shè)期期開開發(fā)發(fā)成成本本2 2經(jīng)經(jīng)營營期期當(dāng)當(dāng)期期發(fā)發(fā)生生營營業(yè)業(yè)成成本本3 3銷銷售售費(fèi)費(fèi)用用4 4銷銷售售稅稅費(fèi)費(fèi)5 5增增值值稅稅6 6盈盈余余公公積積7 7應(yīng)應(yīng)付付利利潤潤8

17、8借借款款本本金金償償還還9 9借借款款利利息息支支付付三三盈盈余余資資金金四四累累計(jì)計(jì)盈盈余余資資金金資資金金來來源源與與運(yùn)運(yùn)用用表表（續(xù)續(xù)表表）單單位位：萬萬元元1112131415161718199,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.00248,400.00248,400.0027,600.0027,600.0027,600.0027,600.0027,600.0027,600.009,200.009,200.009,200.009,200.009,200.009,200

18、.009,200.009,200.009,200.009,200.00248,400.00248,400.0027,600.0027,600.0027,600.0027,600.0027,600.0027,600.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.00248,400.00248,400.0027,600.0027,600.0027,600.0027,600.0027,600.0027,600.0021,600.2521,600.2533,137.0533,137.053

19、3,045.8533,045.85975.39975.39975.39975.39150,942.42150,942.4222,636.5522,636.552,926.162,926.16185,635.71185,635.7120,624.8720,624.8732,161.6732,161.674,020.404,020.40276.00276.00276.00276.00276.00276.00276.00276.00276.00276.007,452.007,452.00828.00828.00828.00828.00828.00828.00469.20469.20469.20469

20、.20469.20469.20469.20469.20469.20469.2012,668.4012,668.401,407.601,407.601,407.601,407.601,407.601,407.60230.19230.19230.19230.19230.19230.19230.19230.196,215.076,215.07690.56690.56690.56690.56690.56690.56120,586.55120,586.5519,710.3919,710.39182,709.55182,709.5532,300.6532,300.65-12,400.25-12,400.2

21、5-23,937.05-23,937.05-23,845.85-23,845.858,224.618,224.618,224.618,224.6197,457.5897,457.584,963.454,963.4524,673.8424,673.84-158,035.71-158,035.7154,390.8454,390.8430,453.7830,453.786,607.936,607.9314,832.5514,832.5523,057.1623,057.16120,514.74120,514.74125,478.19125,478.19150,152.03150,152.03-7,88

22、3.68-7,883.68附附表表6:損損益益及及利利潤潤表表單位：萬元序序號(hào)號(hào)項(xiàng)項(xiàng)目目合合計(jì)計(jì)第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第6 6季季第第7 7季季第第8 8季季第第9季季第第10季季1銷售收入441,600.000.000.000.000.0055,200.009,200.002開發(fā)成本305,384.800.000.000.000.000.000.000.000.0038,173.106,362.183銷售費(fèi)用13,248.000.000.000.000.001,656.00276.004財(cái)務(wù)費(fèi)用100,759.186,029.330.007,014.

23、850.0023,113.710.000.000.0032,300.650.005銷售稅費(fèi)22,521.602,815.20469.206利潤總額-313.58-6,029.330.00-7,014.850.00 -23,113.710.000.000.00-19,744.952,092.627補(bǔ)前期虧損8增值稅9,437.700.00230.199稅后利潤-9,751.28-6,029.330.00-7,014.850.00 -23,113.710.000.000.00-19,744.951,862.43成本利潤率-2.3%附附表表6:序序號(hào)號(hào)項(xiàng)項(xiàng)目目1銷售收入2開發(fā)成本3銷售費(fèi)用4財(cái)務(wù)費(fèi)用

24、5銷售稅費(fèi)6利潤總額7補(bǔ)前期虧損8增值稅9稅后利潤損損益益及及利利潤潤表表（續(xù)續(xù)表表）單位：萬元第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季9,200.009,200.009,200.009,200.009,200.00248,400.0027,600.0027,600.0027,600.006,362.186,362.186,362.186,362.186,362.18171,778.9519,086.5519,086.5519,086.55276.00276.00276.00276.00276.007,

25、452.00828.00828.00828.000.000.0032,300.650.000.000.00469.20469.20469.20469.20469.2012,668.401,407.601,407.601,407.602,092.622,092.62-30,208.032,092.622,092.6256,500.656,277.856,277.856,277.85230.19230.190.00230.19230.196,215.07690.56690.56690.561,862.431,862.43-30,208.031,862.431,862.4350,285.585,58

26、7.295,587.295,587.29附附表表7:現(xiàn)現(xiàn)金金流流量量表表（全全部部投投資資）單位：萬元序序號(hào)號(hào) 季季度度項(xiàng)項(xiàng)目目合合計(jì)計(jì)1234567891現(xiàn)金流入441,600.0055,200.001.1銷售收入82,800.0055,200.001.2出租收入358,800.001.3 其他收入2現(xiàn)金流出348,724.5096,212.0713,412.077,855.2710,063.2722,207.2716,319.2716,319.2715,031.2733,136.872.1建設(shè)期開發(fā)成本303,517.2096,212.0713,412.077,855.2710,063.2

27、722,207.2716,319.2716,319.2715,031.2728,665.672.2經(jīng)營期當(dāng)期成本2.3銷售費(fèi)用13,248.001,656.002.4銷售稅費(fèi)22,521.602,815.202.5增值稅9,437.703凈現(xiàn)金流量92,875.50-96,212.07-13,412.07-7,855.27-10,063.27-22,207.27-16,319.27-16,319.27-15,031.2722,063.134累計(jì)凈現(xiàn)金流量-96,212.07-109,624.13-117,479.40-127,542.67-149,749.93-166,069.20-182,3

28、88.47-197,419.73-175,356.605凈現(xiàn)值25,556.69-96,212.07-13,156.48-7,558.73-9,498.85-20,562.28-14,822.48-14,540.02-13,137.2418,915.586累計(jì)凈現(xiàn)值-96,212.07-109,368.55-116,927.28-126,426.14-146,988.42-161,810.90-176,350.92-189,488.16-170,572.58計(jì)算指標(biāo)：財(cái)務(wù)內(nèi)部收益率=12.11%備注：銷售稅費(fèi)率5.1%財(cái)務(wù)凈現(xiàn)值（I=8%)=25,557增值稅費(fèi)11%動(dòng)態(tài)投資回收期（年）=3.

29、03附附表表7:序序號(hào)號(hào) 季季度度項(xiàng)項(xiàng)目目1現(xiàn)金流入1.1銷售收入1.2出租收入1.3 其他收入2現(xiàn)金流出2.1建設(shè)期開發(fā)成本2.2經(jīng)營期當(dāng)期成本2.3銷售費(fèi)用2.4銷售稅費(fèi)2.5增值稅3凈現(xiàn)金流量4累計(jì)凈現(xiàn)金流量5凈現(xiàn)值6累計(jì)凈現(xiàn)值現(xiàn)現(xiàn)金金流流量量表表（全全部部投投資資）（續(xù)續(xù)表表）單位：萬元101112131415161718199,200.009,200.009,200.009,200.009,200.009,200.00248,400.0027,600.0027,600.0027,600.009,200.009,200.009,200.009,200.009,200.009,200.00248,400.0027,600.0027,600.0027,600.0021,600.2521,600.2533,137.05745.20975.39975.3930,355.872,926.162,926.162,926.1620,624.8720,624.8732,161.674