某五星级酒店资金预算表格

1、酒酒店店项项目目投投资资估估算算表表项 目单价（元/M2） 计算面积(M2)总价(元)比例一、开发成本(一)土地成本1、土地出让金165.8395006,549,1002、土地交易契税196,473小小计计：170.8395006,745,5731.59%(二)前期工程费1、勘测钻探费1.54750071,2502、规划设计费5.047500237,5003、建筑工程设计费15.047500712,5004、图纸审查费2.04750095,0005、配套工程设计费1.04750047,5006、占道费1.04750047,5007、三通一平准备费2.04750095,0008、招投标合同签证费

2、1.04750047,5009、招投标费2.04750095,00010、质量监督费2.04750095,00011、工程监理费6.047500285,000小小计计：38.51,543,7500.36%(三)建筑工程费1、桩基工程、基坑围护及支撑、地下室结构3000.0800024,000,0002、主体结构工程1200.03950047,400,0003、外墙玻璃幕墙1300.01510019,630,0004、给排水（含洁具，锅炉房管线）300.04750014,250,0005、喷淋、气体消防110.0475005,225,0006、污水处理（含管线）40.0475001,900,00

3、07、空调工程600.03950023,700,0008、地下室通风工程190.080001,520,0009、照明、防雷、动力、变配电800.04750038,000,00010、弱电(电话、有线、电脑网络等)300.04750014,250,00011、煤气工程50.0475002,375,00012、电梯、自动扶梯200.0475009,500,00013、室外总体120.0475005,700,00014、室内精装修连家具3500.039500138,250,00015、洗衣房设备30.0395001,185,00016、厨房设备100.0395003,950,00017、杂项工程20

4、0.0475009,500,000小小计计：912239500360,335,00084.90%(四)不可预见费用3,686,2430.87%(五)公用设施配套增容费及规费1、电源建设集资费40475001,900,0002、自来水建设1247500570,0003、污水建设费1047500475,0004、小配套费90475004,275,0005、白蚁预防费14750047,5006、墙改1047500475,0007、城市规划管理业务费14750023,7508、限袋费547500237,5009、城建档案保证金14750030,00010、人防工程建设费1547500712,50011

5、、建筑地方高等教育费1047500475,000小小计计：194475009,221,2502.17%二、开发费用1、管理费用161475007,630,6363、财务费用7424750035,264,986小小计计：90342,895,62210.11%投投资资成成本本费费用用总总计计：424,427,438100.00%每每平平方方米米投投资资(元元/平平米米)8935备备注注：建筑物20年每年折旧15,857,516设备7年每年折旧12,293,679贷款275,877,835表表34酒酒店店经经营营期期营营业业收收入入成成本本估估算算表表 年份2010201120122013 项目一一

6、、收收入入1、标准间套数5555房价（元/套）1191191191190.80.80.80.8标准客房收入（元）1713601713601713601713602、大床房套数2222房价（元/套）99999999出租率0.80.80.80.8套房收入570245702457024570243、豪华大床房套数6666房价（元/套）139139139139出租率0.80.80.80.8豪华大床房收入240192240192240192240192客客房房收收入入小小计计4685764685764685764685764、酒店商场收入400004000040000400005、酒店早餐收入54000

7、5400054000540006、酒店其它收入0000收收入入共共计计562576562576562576562576二二、成成本本费费用用1、营营业业成成本本4461725075952507595250759521、1商品进货成本00001、2餐饮进货成本243002430024300243001、3客房周转物品成本702867028670286702861、4会议、娱乐等周转物品成本00001、5燃料动力费2840764913856491385649138561、6人员薪金675096750967509675092、管管理理费费用用38985435389854353898543538985

8、4352、1保险费16881688168816882、2广告交际费56265626562656262、3折旧费281511942815119428151194281511942、4记提维修费108100501081005010810050108100502、5托管费112521125211252112522、6行政费用56265626562656263、财财务务费费用用19614914176133641561181413610264成成本本费费用用合合计计59046521616747505967320157671651三三、税税金金（元元）0营业税及附加（5.5%）30942309423094

9、230942企业所得税0009283小计30942309423094240224净收入-58514886-61143116-59141566-57149299201420152016201720182019202055555551191191191191191191190.80.80.80.80.80.80.81713601713601713601713601713601713601713602222222999999999999990.80.80.80.80.80.80.8570245702457024570245702457024570246666666139139139139139139

10、1390.80.80.80.80.80.80.8240192240192240192240192240192240192240192468576468576468576468576468576468576468576400004000040000400004000040000400005400054000540005400054000540005400000000005625765625765625765625765625765625765625765075952507595250759525075952507595250759525075952000000024300243002430024

11、300243002430024300702867028670286702867028670286702860000000491385649138564913856491385649138564913856491385667509675096750967509675096750967509389854353898543538985435266917572669175726691757266917571688168816881688168816881688562656265626562656265626562628151194281511942815119415857516158575161585

12、751615857516108100501081005010810050108100501081005010810050108100501125211252112521125211252112521125256265626562656265626562656261160871496071657605615560406544765953349126222165755670101536685515166700137371773362443043511683433989365309423094230942309423094230942309429283928392839283928392839283

13、40224402244022440224402244022440224-55147749-53146199-51144649-36849421-35721952-34594482(33467013)酒酒店店经经营营期期营营业业收收入入成成本本估估算算表表201920202021202220232024202555555551191191191191191191190.60.60.60.60.60.60.61285201285201285201285201285201285201285202222248489999999999127412740.60.60.60.60.60.60.6427684

14、2768427684276842768132088321320883266666661391391391391391391390.60.60.60.60.60.60.6180144180144180144180144180144180144180144351432351432351432351432351432135174961351749616537501653750165375016537501736438173643817364382108592108592108592108592108598110498811049833240633240633240633240634480935046

15、653504665254844725484472548447254844726435382686909626869096516228751622875162287516228751660501165428611654286000000094887948879488794887948873649724364972452715527155271552715527152027624202762449861498614986149861517215257005257004913856491385649138564913856491385649138564913856509695096950969509

16、695287153738253738226777149267771492677714926777149267812382782293727822937764576457645764579318060780607254842548425484254842643526869126869115857516158575161585751615857516158575161585751615857516108100501081005010810050108100501081005010810050108100505096950969509695096952871537382537382254842548

17、425484254842643526869126869110941870000003303362431939437319394373193943731947288394772233947722314016514016514016514016514539514778001477800420494204942049420494361844334044334018221418221418221418221418901319211401921140-30667390-29573203-29573203-29573203(29492763)-14529267-14529267酒酒店店经经营营期期营营业业

18、收收入入成成本本估估算算表表20262027202820292030203120325552522522522521191191191191191191190.60.60.60.60.60.60.612852012852012852064774086477408647740864774084848484848484812741274133813381338133813380.60.60.60.60.60.60.61320883213208832138723841387238413872384138723841387238466666661391391391391391391390.60.60.

19、60.60.60.60.618014418014418014418014418014418014418014413517496135174961418104820529936205299362052993620529936173643817364381823260182326018232601823260182326081104988110498850862912317962123179621231796212317962350466535046653676941520067452006745200674520067426869096268690962818987739871831398718

20、313987183139871831116542861165428611985235151139671511396715113967151139670000000364972436497243828883554308355430835543083554308320276242027624212715730794903079490307949030794905257005257005515417801017801017801017801014913856491385649138564913856491385649138564913856537382537382563798797437797437

21、797437797437278229372782293712022215125245391252453912524539125245398060780607845701196151196151196151196152686912686912818993987183987183987183987181585751615857516108100501081005010810050108100501081005010810050108100505373825373825637987974377974377974377974372686912686912818993987183987183987183

22、9871800000003947722339477223240074492763850627638506276385062763850614778001477800155044321929512192951219295121929514433404433404651336578856578856578856578851921140192114020155762850836285083628508362850836-14529267-1452926721668519382490938249093824909382490酒酒店店经经营营期期营营业业收收入入成成本本估估算算表表20332034203

23、520362037203820392522522522522522522521191191198958959409400.60.60.60.60.60.60.6647740864774086477408487166404871664051166080511660804848484848484814051405140514051405147514750.60.60.60.60.60.60.6145670401456704014567040145670401456704015292800152928006666662139139139139139139147420.60.60.60.60.60.6

24、0.6180144180144180144180144180144180144636854421224592212245922122459263463824634638246663902472827424191442319144231914423191442319144232010442010441273475512734755127347553807829438078294399834144369645453810665381066538106615518481155184811602352217508738412548364125483641254836118975023118975023

25、122847005134233661154604411546044115460441362759353627593537762715408123580000000573064057306405730640171352321713523217992536196634043183689318368931836899519574951957499958541092411480716080716080716023277722327772240352826263114913856491385649138564913856491385649138564913856825097825097825097237

26、950023795002456940268467312584008125840081258400815925976159259761609247116582097123765123765123765356925356925368541402701412548412548412548118975011897501228470134233710810050108100501081005010810050108100501081005010810050825097825097825097237950023795002456940268467341254841254841254811897501189

27、7501228470134233700000002804444928044449280444495220191152201911538551865739445522690162269016226901665436266543626675658573828516807056807056807051963088196308820269762214855294972129497212949721850671485067148783561959770710260666102606661026066658266398582663986020825867241499酒酒店店经经营营期期营营业业收收入入成成

28、本本估估算算表表204020412042204320442522522522522529409409409409400.60.60.60.60.651166080511660805116608051166080511660804848484848147514751475147514750.60.60.60.60.615292800152928001529280015292800152928002222214742147421474214742147420.60.60.60.60.6636854463685446368544636854463685447282742472827424728274

29、247282742472827424201044201044201044201044201044436964544369645443696454436964544369645417508738175087381750873817508738175087381342336611342336611342336611342336611342336614081235840812358408123584081235840812358000001966340419663404196634041966340419663404109241141092411410924114109241141092411426

30、263112626311262631126263112626311491385649138564913856491385649138562684673268467326846732684673268467316582097165820971658209716582097165820974027014027014027014027014027011342337134233713423371342337134233710810050108100501081005010810050108100502684673268467326846732684673268467313423371342337134

31、2337134233713423370000057394455573944555739445557394455573944557382851738285173828517382851738285122148552214855221485522148552214855959770795977079597707959770795977076724149967241499672414996724149967241499酒酒店店经经营营期期营营业业收收入入成成本本估估算算表表酒酒店店投投资资资资金金使使用用计计划划估估算算表表 年份2005200620072008合计项目(一)土地成本使用计划100%

32、 100%所需资金6,745,573 6,745,573(二)前期工程费使用计划80%20%100%所需资金1,235,000308,7501,543,750(三)建筑工程费使用计划25%45%30%100%所需资金90,083,750162,150,750108,100,500360,335,000(四)不可预见费用使用计划25%25%25%25%100%所需资金921,561921,561921,561921,5613,686,243(五)公用设施配套集资费、规费使用计划20%60%20%100%所需资金1,844,2505,532,7501,844,2509,221,250(六)开发费用

33、使用计划10%25%40%25%100%所需资金4,289,56210,723,90617,158,24910,723,90642,895,622合计13,191,696103,882,216185,763,310121,590,216424,427,438表表36酒酒店店贷贷款款还还款款表表项目名称合计200820092010年初贷款余额275,877,835247,726,641219,575,447本年贷款0000本年偿还本金275877835281511942815119428151194本年偿还利息19,614,91417,613,36415,611,814年末贷款余额247,726

34、,641219,575,447191,424,253本年利息利率7.11%201120122013201420152016191,424,253163,273,059135,121,865106,970,67178,819,47762,961,96100000028151194281511942815119428151194158575161585751613,610,26411,608,7149,607,1657,605,6155,604,0654,476,595163,273,059135,121,865106,970,67178,819,47762,961,96147,104,445酒酒

35、店店贷贷款款还还款款表表201720182019202047,104,44531,246,92915,389,413(0)15857516158575161538941303,349,1262,221,6571,094,18731,246,92915,389,41300酒酒店店贷贷款款还还款款表表表表37酒酒店店经经营营期期损损益益表表项目计算依据200520062007200820091、营业收入000562,576562,5762、成本费用59,046,52161,674,7503、营业税金及附加30,94230,9425、利润总额（123）(58,514,886)(61,143,116)

36、6、所得税营业税33000007、税后利润（56）(58,514,886)(61,143,116)8、盈余公积金710009、可分配利润（78）002010201120122013201420152016562,576562,576562,576562,576562,576562,576562,57659,673,20157,671,65155,670,10153,668,55151,667,00137,371,77336,244,30430,94230,94230,94230,94230,94230,94230,942(59,141,566)(57,140,016)(55,138,466)(

37、53,136,917)(51,135,367)(36,840,139)(35,712,669)09,2839,2839,2839,2839,2839,283(59,141,566)(57,149,299)(55,147,749)(53,146,199)(51,144,649)(36,849,421)(35,721,952)(5,914,157)(5,714,930)(5,514,775)(5,314,620)(5,114,465)(3,684,942)(3,572,195)(53,227,410)(51,434,369)(49,632,974)(47,831,579)(46,030,184)(

38、33,164,479)(32,149,757)酒酒店店经经营营期期损损益益表表2017201820192020202120222023562,576562,5762,548,4472,548,4472,548,4472,548,4472,643,53835,116,83433,989,36533,033,62431,939,43731,939,43731,939,43731,947,28830,94230,942140,165140,165140,165140,165145,395(34,585,200)(33,457,731)(30,625,341)(29,531,154)(29,531,1

39、54)(29,531,154)(29,449,144)9,2839,28342,04942,04942,04942,04943,618(34,594,482)(33,467,013)(30,667,390)(29,573,203)(29,573,203)(29,573,203)(29,492,763)(3,459,448)(3,346,701)(3,066,739)(2,957,320)(2,957,320)(2,957,320)(2,949,276)(31,135,034)(30,120,312)(27,600,651)(26,615,883)(26,615,883)(26,615,883)

40、(26,543,486)酒酒店店经经营营期期损损益益表表202420252026202720282029203026,869,09626,869,09626,869,09626,869,09628,189,87739,871,83139,871,83139,477,22339,477,22339,477,22339,477,22324,007,44927,638,50627,638,5061,477,8001,477,8001,477,8001,477,8001,550,4432,192,9512,192,951(14,085,927)(14,085,927)(14,085,927)(14,0

41、85,927)2,631,98410,040,37510,040,375443,340443,340443,340443,340465,133657,885657,885(14,529,267)(14,529,267)(14,529,267)(14,529,267)2,166,8519,382,4909,382,490(1,452,927)(1,452,927)(1,452,927)(1,452,927)216,685938,249938,249(13,076,340)(13,076,340)(13,076,340)(13,076,340)1,950,1668,444,2418,444,241

42、酒酒店店经经营营期期损损益益表表203120322033203420352036203739,871,83139,871,83141,254,83641,254,83641,254,836118,975,023118,975,02327,638,50627,638,50628,044,44928,044,44928,044,44952,201,91152,201,9112,192,9512,192,9512,269,0162,269,0162,269,0166,543,6266,543,62610,040,37510,040,37510,941,37110,941,37110,941,3716

43、0,229,48660,229,486657,885657,885680,705680,705680,7051,963,0881,963,0889,382,4909,382,49010,260,66610,260,66610,260,66658,266,39858,266,398938,249938,2491,026,0671,026,0671,026,0675,826,6405,826,6408,444,2418,444,2419,234,5999,234,5999,234,59952,439,75852,439,758酒酒店店经经营营期期损损益益表表20382039204020412042

44、20432044122,847,005134,233,661134,233,661134,233,661134,233,661134,233,661134,233,66153,855,18657,394,45557,394,45557,394,45557,394,45557,394,45557,394,4556,756,5857,382,8517,382,8517,382,8517,382,8517,382,8516,756,58562,235,23469,456,35469,456,35469,456,35469,456,35469,456,35470,082,6202,026,9762,2

45、14,8552,214,8552,214,8552,214,8552,214,8552,026,97660,208,25867,241,49967,241,49967,241,49967,241,49967,241,49968,055,6446,020,8266,724,1506,724,1506,724,1506,724,1506,724,1506,805,56454,187,43260,517,34960,517,34960,517,34960,517,34960,517,34961,250,080酒酒店店经经营营期期损损益益表表表表38酒酒店店全全部部投投资资现现金金流流量量表表项目名称

46、合计2005200620072008现现金金流流入入000562,576销售流入000562,576现现金金流流出出13,191,696103,882,216185,763,310152,516,484建设投资424,427,43813,191,696103,882,216185,763,310121,590,216营业成本费用30,895,326营业税及附加000030,942所得税00000净净现现金金流流量量-13,191,696-103,882,216-185,763,310-151,953,908财务内部收益率#DIV/0!200920102011201220132014201556

47、2,576562,576562,576562,576562,576562,576562,576562,576562,576562,576562,576562,576562,576562,57633,554,49831,552,94829,560,68127,559,13125,557,58123,556,03121,554,48133,523,55631,522,00729,520,45727,518,90725,517,35723,515,80721,514,25730,94230,94230,94230,94230,94230,94230,942009,2839,2839,2839,283

48、9,283-32,991,922-30,990,372-28,998,105-26,996,555-24,995,005-22,993,455-20,991,905酒酒店店全全部部投投资资现现金金流流量量表表2016201720182019202020212022562,576562,576562,5762,548,4472,548,4472,548,4472,548,447562,576562,576562,5762,548,4472,548,4472,548,4472,548,44720,427,01219,299,54218,172,07317,358,32216,264,13516,2

49、64,13516,264,13520,386,78819,259,31818,131,84917,176,10816,081,92116,081,92116,081,92130,94230,94230,942140,165140,165140,165140,1659,2839,2839,28342,04942,04942,04942,049-19,864,436-18,736,966-17,609,497-14,809,874-13,715,687-13,715,687-13,715,687酒酒店店全全部部投投资资现现金金流流量量表表20232024202520262027202820292,

50、643,53826,869,09626,869,09626,869,09626,869,09628,189,87739,871,8312,643,53826,869,09626,869,09626,869,09626,869,09628,189,87739,871,83116,278,78525,540,84725,540,84725,540,84725,540,84726,023,02630,489,34116,089,77223,619,70723,619,70723,619,70723,619,70724,007,44927,638,506145,3951,477,8001,477,8001,477,8001,477,8001,550,4432,192,95143,618443,340443,340443,340443,340465,133657,885-13,635,2471,328