兗州項目投資估算及財務報表.xls
下載文檔
上傳人:正***
編號:857624
2023-12-22
32頁
102KB
1、項項目目總總投投資資估估算算表表序序號號項項目目名名稱稱總總額額(元元)占占總總投投資資比比例例1地 價40,000,000.008.0%2前期工程費27,480,840.005.5%3建安工程238,800,000.0047.8%4配套費用13,200,000.002.6%5稅費108,730,000.0021.8%6營銷費用33,200,000.006.7%7管理費用24,900,000.005.0%8不可預見費用12,779,233.602.6%9合 計499,090,073.60100.0%總建築成本名稱項目名稱面積/單價元/一、土地成本總用地成本120000333333二、前期費用12、規劃技術服務費1368032、建筑設計費120000283、景觀綠化設計費154、勘探費136801.55、建筑安審圖費1200001.26、防雷審圖費1200000.57、工程質量監督費(總造價6)238,800,0000.00068、白蟻防止費1200002.39、檔案寄存費(200-10000)10、墻改辦發展基金費120000811、定位費撥地訂樁12、工程交易綜合服務費1200000.113、土地開發管理費120000214、城市政策設施配套費1200007515、散裝水泥專項預收120000216、維修基金12000010017、雇主責任費18、工程定額測定費19、檢測費(總造價3、6)40,000,0000.000620、招投標代理費21、測量釘樁放線費22、預售證費用(住宅5/商業10)1200008合合計計平均/229229三、建安費用1、寫字樓(12000)2、商業(60000)6000012003、住宅(60000)6000015004、地下室(30000)3000022005、樁基12000090合合計計平均/19901990四、配套費用1、小區景觀綠化費120000202、小區智能化費(含設計費)120000303、電梯/部(20萬)150,000404、外水費用12000005、外電費用12000006、外燃氣費用1200007、有線電視(住宅21/商業14、4)12000010.008、通信120000合合計計平均/110110五、商業裝修費用1、空調12000002、全裝修費用1200000合合計計平均/0 0六、稅金1、地稅(5.95-6.5%)830,000,0006.5%2、國稅(*20%*33%)830,000,000總銷*20%*33%合合計計平均/906七、管銷費用人事費用830,000,0001.00%代銷費用(含廣告費用)830,000,0003.00%合合計計平均/277八、不可預見費用不不可可預預見見費費用用120000.00106合合計計120000.00157九、管理費用管管理理費費用用120000.00208合合計計15、20000.00208平均成本總總計計費費用用(含含稅稅金金)平均/4210利潤利潤所得平均/2758銷售住宅200005500商業4000018000小計60000總費用(元)百分比40,000,00040,000,000#DIV/0!41,0400.01%3,360,0000.67%00.00%205200.00%1440000.03%600000.01%1432800.03%2760000.06%00.00%9600000.19%00.00%120000.00%2400000.05%90000001.80%2400000.05%120000002.40%00.00%00.00%240006、0.00%00.00%00.00%960,0000.19%27,480,84027,480,8405.51%72,000,00014.43%90,000,00018.03%66,000,00013.22%10,800,0002.16%238,800,000238,800,00047.85%2,400,0000.48%3,600,0000.72%6,000,0001.20%00.00%00.00%0.00%1,200,0000.24%0.00%0.00%13,200,00013,200,0002.64%00.00%00.00%0 00.00%53,950,00010.81%54,780,00017、0.98%108,730,000108,730,00021.79%8,300,0008,300,0001.66%24,900,00024,900,0004.99%33,200,00033,200,0006.65%12,779,23412,779,23412,779,23412,779,23424,900,00024,900,00024,900,00024,900,000499,090,074499,090,074100.00%0.025605330,909,926330,909,92666.30%4159.084110000000720000000830000000附附表表3:序號項目名稱投資8、總額第第1 1月月第第2 2月月一土地成本40000000.0020000000.00二前期費用27480840.005496168.005496168.00三建安費用238800000.00四配套費用13200000.00五商業裝修費用0.00六不可預見費用12779233.60672591.24672591.24七管理費用24900000.001310526.321310526.32八銷售費用33200000.001310526.321310526.32九稅金費用108730000.00十十一十二十三十四十五0.000.00十六0.000.00十七0.000.00十八合計4990900739、.6028789811.878789811.87注:1.土地成本按計算初期一次性投入計。2.按照通常情況,工程費用中5%留取保修金及滯留金,竣工驗收后一年付出。3.工程款的支付與工程進度表相對應,不考慮工程隊大額墊資,按工程進度付款,竣工驗收后支付率達95%,其它部分在工程建設過程中平均投入。279480840.00398409233.60#REF!431609233.60投投資資計計劃劃表表第第3 3月月第第4月月第第5 5月月第第6 6月月第第7 7月月20000000.005496168.005496168.005496168.00672591.24672591.24672591.24610、72591.24672591.241310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.322718250.005436500.005436500.008154750.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.008789811.8711508061.8734226311.878730143.8711448393.87 2.按照通常情況,工程費用中5%留取保修金11、及滯留金,竣工驗收后一年付出。3.工程款的支付與工程進度表相對應,不考慮工程隊大額墊資,按工程進度付款,竣工驗收后支付率達95%,其它部分在工程建設過程中平均投入。單位:萬元第第8 8月月第第9 9月月第第1010月月第第1111月月第第1212月月113430000.004180000.000.00672591.24672591.24672591.24672591.24672591.241310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.32815412、750.0010873000.00108730001087300010873000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00129058393.8714166643.8714166643.8714166643.8714166643.87投投資資計計劃劃表表(續續表表)第第1313月月第第1414月月第第1515月月第第1616月月第第1717月月113430000.008360000.000.00672591.24672591.24672513、91.24672591.24672591.241310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.3210873000.008154750.008154750.005436500.002718250.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0014166643.8711448393.87133238393.878730143.876011893.87單位:萬14、元第第1818月月第第1919月月400000002748084011940000.00238800000660000.00132000000.000672591.24672591.24127792341310526.321310526.3224900000.001310526.321310526.3224900000.000.000.001087300000.0000.0000.0000.0000.0000003293643.8715893643.87490790074490790074附附表表4:項項目目銷銷售售回回款款計計劃劃表表項目內容 銷銷售售建建筑筑面面積積(m2)銷銷售售價價格格15、(元元/m2)總總價價住宅20000.005,500110,000,000.00商業40000.0018,000720,000,000.00合計60000.00830,000,000.00住宅銷售率100%商鋪銷售率100%銷售收入830,000,000.00計算期(季度)銷銷售售比比例例回回款款比比例例回回款款金金額額住住宅宅商商業業住住宅宅商商業業住住宅宅12345%0%3%55%5%1.67%5%1,833,333.3365%5%5.00%5%5,500,000.0075%10%5.00%7.50%5,500,000.0085%10%5.00%10.00%5,500,000.00910%16、10%6.67%10.00%7,333,333.331010%10%10.00%10.00%11,000,000.001110%10%10.00%10.00%11,000,000.001210%10%10.00%10.00%11,000,000.001310%10%10.00%10.00%11,000,000.001410%5%10.00%7.50%11,000,000.001510%5%10.00%5.00%11,000,000.00165%5%8.33%5.00%9,166,666.67175%0.00%5.00%2.50%5,500,000.00180.00%0.00%3.33%0.0017、%3,666,666.67190.00%0.00%0.00%0.00%-合計100.00%100%100.00%100%110,000,000.00注:剩余5%住宅作為企業留存資產,銷售回款計劃綜合考慮銀行按揭放款時間。備備注注敏感性分析測算成本變化率100.00%總投資499,090,074收入變化率100.00%銷售收入830,000,000FNPV369,123,069FIRR379.51%回收期6.59合合計計利潤33,200,000商商業業利潤率#REF!0018,000,000.0018,000,000.00總值7899036,000,000.0037,833,333.33收入8318、000000036,000,000.0041,500,000.00比例1050765.92%54,000,000.0059,500,000.0072,000,000.0077,500,000.0072,000,000.0079,333,333.3372,000,000.0083,000,000.0072,000,000.0083,000,000.0072,000,000.0083,000,000.0072,000,000.0083,000,000.0054,000,000.0065,000,000.0036,000,000.0047,000,000.0036,000,000.0045,166,19、666.6718,000,000.0023,500,000.003,666,666.67-720,000,000.00830,000,000.00717086000635%總總價價110,000,000.00720,000,000.00830,000,000.00100%100%830,000,000.00回回款款金金額額注:剩余5%住宅作為企業留存資產,銷售回款計劃綜合考慮銀行按揭放款時間。時間住宅商業總體銷售率銷售面積10%0%0.00%-20%0%0.00%-30%0%0.00%-40%5%2.50%1,50055%5%5.00%3,00065%5%5.00%3,00075%10%7.520、0%4,50085%10%7.50%4,500910%10%10.00%6,0001010%10%10.00%6,0001110%10%10.00%6,0001210%10%10.00%6,0001310%10%10.00%6,0001410%5%7.50%4,5001510%5%7.50%4,500165%5%5.00%3,000175%2.50%1,500180.00%-190.00%合計100%100%100.00%60,000附附表表5:序序號號 季季度度項項目目第第1 1月月第第2 2月月一資金來源0.000.001經營活動產生的現金來源0.000.001.1銷售收入1.2出租收入021、.001.3 其他收入2 籌資活動產生的現金來源0.000.002.1自有資金0.002.2銀行借款0.002.3其他負債3其它來源0.00二資金運用37,579,623.7517,579,623.751土地成本28,789,811.878,789,811.872前期費用5,496,168.005,496,168.003建安費用0.000.004配套費用0.000.005商業裝修0.000.006稅金費用7營銷費用1,310,526.321,310,526.328不可預見費用672,591.24672,591.249管理費用1,310,526.321,310,526.32三盈余資金-37,5722、9,623.75-17,579,623.75四累計盈余資金-37,579,623.75-55,159,247.49資資金金來來源源與與運運用用表表第第3 3月月第第4月月第第5 5月月第第6 6月月0.0018,000,000.0037,833,333.3341,500,000.000.0018,000,000.0037,833,333.3341,500,000.0018,000,000.0037,833,333.3341,500,000.000.000.000.000.000.000.000.000.000.000.000.0017,579,623.7523,016,123.7548,45223、,623.7517,460,287.758,789,811.8711,508,061.8734,226,311.878,730,143.875,496,168.005,496,168.005,496,168.000.000.000.000.000.000.000.000.000.000.000.000.002,718,250.005,436,500.005,436,500.001,310,526.321,310,526.321,310,526.321,310,526.32672,591.24672,591.24672,591.24672,591.241,310,526.321,310,526.24、321,310,526.321,310,526.32-17,579,623.75-5,016,123.75-10,619,290.4124,039,712.25-72,738,871.24-77,754,994.99-88,374,285.40-64,334,573.15單位:萬元第第7 7月月第第8 8月月第第9 9月月第第1010月月59,500,000.0077,500,000.0079,333,333.3383,000,000.0059,500,000.0077,500,000.0079,333,333.3383,000,000.0059,500,000.0077,500,000.0025、79,333,333.3383,000,000.000.000.000.000.000.000.000.000.000.000.0022,896,787.75148,866,787.7527,022,761.4327,022,761.4311,448,393.87129,058,393.8714,166,643.8714,166,643.870.000.000.000.004,180,000.000.000.004,180,000.000.000.000.000.000.000.008,154,750.008,154,750.0010,873,000.0010,873,000.001,310,26、526.321,310,526.321,310,526.321,310,526.32672,591.24672,591.24672,591.24672,591.241,310,526.321,310,526.3236,603,212.25-71,366,787.7552,310,571.9055,977,238.57-27,731,360.90-99,098,148.65-46,787,576.749,189,661.82資資金金來來源源與與運運用用表表(續續表表)第第1111月月第第1212月月第第1313月月第第1414月月83,000,000.0083,000,000.0083,000,27、000.0065,000,000.0083,000,000.0083,000,000.0083,000,000.0065,000,000.0083,000,000.0083,000,000.0083,000,000.0065,000,000.000.000.000.000.000.00-0.00-27,022,761.4327,022,761.4327,022,761.4321,586,261.4314,166,643.8714,166,643.8714,166,643.8711,448,393.870.000.000.000.000.000.000.000.000.000.000.000.028、010,873,000.0010,873,000.0010,873,000.008,154,750.001,310,526.321,310,526.321,310,526.321,310,526.32672,591.24672,591.24672,591.24672,591.2455,977,238.5755,977,238.5755,977,238.5743,413,738.5765,166,900.39121,144,138.96177,121,377.53220,535,116.10單位:萬元第第1515月月第第1616月月第第1717月月第第1818月月47,000,000.0045,29、166,666.6723,500,000.003,666,666.6747,000,000.0045,166,666.6723,500,000.003,666,666.6747,000,000.0045,166,666.6723,500,000.003,666,666.670.000.000.000.00-265,166,261.4316,149,761.4310,713,261.435,276,761.43133,238,393.878,730,143.876,011,893.873,293,643.87113,430,000.000.000.000.008,360,000.000.000.30、000.000.000.000.000.008,154,750.005,436,500.002,718,250.00-1,310,526.321,310,526.321,310,526.321,310,526.32672,591.24672,591.24672,591.24672,591.240.000.00-218,166,261.4329,016,905.2412,786,738.57-1,610,094.762,368,854.6731,385,759.9044,172,498.4742,562,403.71資資金金來來源源與與運運用用表表(續續表表)第第1919月月0.000.000.31、00830,000,000.000.00-30,476,761.4315,893,643.87490,790,073.6011,940,000.00660,000.000.00-1,310,526.32672,591.24-30,476,761.4312,085,642.27339,209,926.40附附表表6:序序號號項項目目合合計計第第1 1月月第第2 2月月1銷售收入830,000,000.002土地費用40,000,000.0020000000.003前期費用27,480,840.005496168.005496168.004建安費用238,800,000.005配套費用13,20032、,000.006商業裝修費用0.007不可預見費用12,779,233.60672591.24672591.248管理費用24,900,000.001310526.321310526.329銷售費用33,200,000.001310526.321310526.3210稅金費用108,730,000.00011前期虧損012當期盈利-28,789,811.87-8,789,811.8713積累盈利-28,789,811.87-37,579,623.7514稅后利潤330,909,926.40損損益益及及利利潤潤表表第第3 3月月第第4月月第第5 5月月第第6 6月月第第7 7月月18,000,033、00.0037,833,333.33 41,500,000.0059,500,000.0020000000.005496168.005496168.005496168.00672591.24672591.24672591.24672591.24672591.241310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.322718250.005436500.005436500.008154750.00-8,789,811.876,491,938.133,6034、7,021.46 32,769,856.1348,051,606.13-46,369,435.62-39,877,497.49-36,270,476.04-3,500,619.9144,550,986.22單位:萬元第第8 8月月第第9 9月月第第1010月月第第1111月月第第1212月月77,500,000.0079,333,333.3383,000,000.0083,000,000.0083,000,000.00113430000.004180000.000.00672591.24672591.24672591.24672591.24672591.241310526.321310526.35、321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.328154750.0010873000.00108730001087300010873000.00-51,558,393.8765,166,689.4668,833,356.1368,833,356.1368,833,356.13-7,007,407.6658,159,281.80 126,992,637.93195,825,994.06264,659,350.18損損益益及及利利潤潤表表(續續表表)第第1313月月第第1414月月第36、第1515月月第第1616月月第第1717月月83,000,000.0065,000,000.0047,000,000.0045,166,666.6723,500,000.00113430000.008360000.000.00672591.24672591.24672591.24672591.24672591.241310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.321310526.3210873000.008154750.008154750.005436500.0037、2718250.0068,833,356.1353,551,606.13-86,238,393.8736,436,522.7917,488,106.13333,492,706.31387,044,312.44 300,805,918.56337,242,441.35 354,730,547.48單位:萬元第第1818月月第第1919月月3,666,666.670.00830,000,000.0040,000,000.0027,480,840.0011940000.00238,800,000.00660000.0013,200,000.000.000.00672591.24672591.241238、,779,233.601310526.321310526.3224,900,000.001310526.321310526.3237,679,233.600.000.00373,022.79-15,893,643.87355,103,570.27 339,209,926.40附附表表7:序序號號 季季度度項項目目合合計計1 11現金流入830,000,000.000.001.1銷售收入830,000,000.000.001.2出租收入0.001.3 其他收入0.002現金流出423,560,073.605,496,168.002.1土地成本40,000,000.005,496,168.002.39、2前期成本27,480,840.002.3建安費用238,800,000.000.002.4配套費用13,200,000.000.002.5裝修費用0.002.6不可預見費用12,779,233.602.7營銷費用33,200,000.002.8稅金稅用33,200,000.000.002.9管理費用24,900,000.003凈現金流量480,713,622.25-5,496,168.004累計凈現金流量3,779,452,750.63-5,496,168.005凈現值369,123,068.78-5,496,168.006累計凈現值-5,496,168.00計算指標:財務內部收益率=財務凈40、現值(I=10%)=動態投資回收期(月)=季度折現率I=凈現值出現正值的月份現現金金流流量量表表(全全部部投投資資)2 23 34 45 50.000.000.003,333,333.330.000.000.003,333,333.335,496,168.005,496,168.005,496,168.005,829,501.335,496,168.005,496,168.005,496,168.005,496,168.000.000.000.000.000.000.000.00166,666.670.000.000.00166,666.67-5,496,168.00-5,496,168.0041、-5,496,168.00-2,496,168.00-10,992,336.00-16,488,504.00-21,984,672.00-24,480,840.00-5,366,755.72-5,240,390.57-5,117,000.81-2,269,243.64-10,862,923.72-16,103,314.29-21,220,315.10-23,489,558.74379.51%369,123,0696.590.081.052.411%0.0840.0241136897單位:萬元6 67 78 89 96,666,666.6739,500,000.0055,500,000.005642、,333,333.336,666,666.6739,500,000.0055,500,000.0056,333,333.33666,666.673,950,000.005,550,000.005,633,333.330.000.000.000.00333,333.331,975,000.002,775,000.002,816,666.67333,333.331,975,000.002,775,000.002,816,666.676,000,000.0035,550,000.0049,950,000.0050,700,000.00-18,480,840.0017,069,160.0067,01943、,160.00117,719,160.005,326,113.2230,814,177.3242,276,428.7441,900,826.45-18,163,445.5212,650,731.8054,927,160.5396,827,986.98101011111212131355,916,666.6755,500,000.0056,333,333.3355,916,666.6755,916,666.6755,500,000.0056,333,333.3355,916,666.670.000.005,591,666.675,550,000.005,633,333.335,591,666.644、70.000.000.000.000.002,795,833.332,775,000.002,816,666.672,795,833.332,795,833.332,775,000.002,816,666.672,795,833.3350,325,000.0049,950,000.0050,700,000.0050,325,000.00168,044,160.00217,994,160.00268,694,160.00319,019,160.0040,611,613.2839,359,881.2739,010,190.8637,809,917.36137,439,600.25176,799,445、81.52215,809,672.38253,619,589.74現現金金流流量量表表(全全部部投投資資)(續續表表)141415151616171755,500,000.0056,333,333.3355,916,666.6720,166,666.6755,500,000.0056,333,333.3355,916,666.6720,166,666.670.000.000.000.005,550,000.005,633,333.335,591,666.678,028,560.546,011,893.870.000.000.000.000.000.002,775,000.002,816,66646、.672,795,833.331,008,333.332,775,000.002,816,666.672,795,833.331,008,333.3349,950,000.0050,700,000.0050,325,000.0012,138,106.13368,969,160.00419,669,160.00469,994,160.00482,132,266.1336,644,539.2836,318,973.1635,201,503.598,290,489.81290,264,129.02326,583,102.17361,784,605.76370,075,095.57單位:萬元1818147、9191,666,666.67416,666.671,666,666.67416,666.670.000.003,460,310.5441,666.673,293,643.870.000.000.0083,333.3320,833.3383,333.3320,833.33-1,793,643.87375,000.00480,338,622.25480,713,622.25-1,196,237.21244,210.42368,878,858.36369,123,068.78附附表表8:敏敏感感性性分分析析表表因因素素變變化化情情況況相相關關指指標標變變化化情情況況總總建建筑筑面面積積(m2)銷銷48、售售價價格格(元元/m2)銷銷售售收收入入(萬萬元元)基基本本方方案案(容容積積率率=7)120,000120,000住住宅宅50005000830,000,000830,000,000商商業業1000010000銷售價格變化價價格格下下降降10%10%120,000120,000住宅4500450068,076商業90009000價價格格上上升升10%10%120,000120,000住宅5500550083,205商業1100011000工程造價變化工工程程造造價價增增加加10%10%1,200,0301,200,030住宅350075,641商業3500工工程程造造價價減減少少10%1049、%120,000120,000住宅315075,641商業3150敏敏感感性性分分析析結結果果總總投投資資(萬萬元元)稅稅后后利利潤潤(萬萬元元)投投資資利利潤潤率率財財務務凈凈現現值值(萬萬元元)內內部部收收益益率率動動態態投投資資回回收收期期(月月)40,000,00040,000,000330,909,926330,909,92666.3%66.3%369,123,069369,123,069379.51%379.51%6.596.5955,9707,33913.10%3,33313.57%3.9456,42419,15734.00%13,03528.57%3.2859,51810,42517.50%5,74317.22%3.8152,87616,07130.40%10,62525.39%3.46敏敏感感性性分分析析表表
CAD圖紙
上傳時間:2023-10-25
13份