房地产公司项目测算表.xlsx

1、测算数据准确性检验表查查阅阅表表数数据据=查阅表名查阅项查查阅阅值值=（总表）表二、非土地成本扣进项税后非土地成本总额（万元）+非土地成本进项税（万元）9237892378=（总表）表四、增值税和附加费表土地成本分摊的销项税合计（含安置房）352352=（总表）表五、土地成本(万元)算土增用可计入土地成本合计(含公建)42734273=成本拆分表成本拆分表各业态进项税(万元)+进项支出(万元)9237892378=土地增值税测算表普通住宅、商业和其他收入总额140270140270=土地增值税测算表普通住宅、商业和其他土地成本总额42734273=土地增值税测算表3、税金727727=销售分期

2、表总销售回款额(万元)155699155699=销售分期表各业态实现当季度销售额(万元)155699155699=成本投资计划表累积总成本104233104233=成本投资计划表累积非土地成本8403084030=全投资现金流量表企业所得税前净现金流量3384533845=全投资现金流量表开发成本投资104233104233=自有资金现金流量表企业所得税前净现金流量3189631896=对对应应表表数数据据备备注注（可可能能存存在在的的出出错错原原因因）对应表名对应项对对应应数数值值（总表）表二、非土地成本表非土地成本总额9237892378若两者不等，检查成本拆分表，检查是否有漏加的业态，再

3、检查各业态是否有错误（总表）表五、土地成本(万元)土地出让金拟分摊的增值税(实际不扣除)352352若两者不等，检查表五土地成本分摊的销项税额是否有漏加的业态表六、土地增值税计算用土地成本各业态土地成本合计42734273若两者不等，检查表六各业态与公式是否完整，若表六没问题则检查表三可售业态是否与表一相符成本拆分表各业态总成本(万元)9237892378若两者不等，检查成本拆分表各业态进项税+进项支出是否等于各业态总成本，若哪一业态不相等，则检查此业态的数据及公式知否正确（总表）表四、增值税和附加费表右侧数据各业态表销售收入（万元）-销售收入含土地成本分摊的销项税额140270140270若

4、两者不等，检查土地增值税表的收入总额是否漏加了哪个业态表五、土地成本整体土地成交价格(含公建、保障房和学校成本)42734273若两者不等，检查土地增值税表的土地成本是否漏加了哪个业态（总表）表四、增值税和附加费表附加费合计(含安置房)727727若两者不等，检查土地增值税表的税金是否漏加了哪个业态（总表）表三、销售数据表表销售收入总额（万元）（含安置房）155699155699若两者不等，分别检查销售分期表和（总表）销售数据表此值公式的准确性销售分期表各业态实际当季销售回款(万元)155699155699若两者不等，检查销售分期表各业态两项值是否相等（总表）表七、投资指标总成本1042331

5、04233若两者不等，主要检查成本投资计划表非土地成本和土地成本的准确性（总表）表二、非土地成本扣进项税后非土地成本总额（万元）（含公建成本）8403084030若两者不等，检查成本投资计划表非土地成本各业态投资计划的准确性，各列投资比例是否有漏加的分期（总表）表七、投资指标增值税和土地增值税后全投资利润3384533845若两者不等，主要检查全投资现金流量表及成本投资计划表（总表）表七、投资指标总成本104233104233若两者不等，主要检查全投资现金流量表及成本投资计划表（总表）表七、投资指标增值税、财务费用和土地增值税后利润3189631896若两者不等，调整贷款还期表的还本金比例测算

6、数据准确性检验表00000000000000备备注注（可可能能存存在在的的出出错错原原因因）若两者不等，检查成本拆分表，检查是否有漏加的业态，再检查各业态是否有错误若两者不等，检查表五土地成本分摊的销项税额是否有漏加的业态若两者不等，检查表六各业态与公式是否完整，若表六没问题则检查表三可售业态是否与表一相符若两者不等，检查成本拆分表各业态进项税+进项支出是否等于各业态总成本，若哪一业态不相等，则检查此业态的数据及公式知否正确若两者不等，检查土地增值税表的收入总额是否漏加了哪个业态若两者不等，检查土地增值税表的土地成本是否漏加了哪个业态若两者不等，检查土地增值税表的税金是否漏加了哪个业态若两者不

7、等，分别检查销售分期表和（总表）销售数据表此值公式的准确性若两者不等，检查销售分期表各业态两项值是否相等若两者不等，主要检查成本投资计划表非土地成本和土地成本的准确性若两者不等，检查成本投资计划表非土地成本各业态投资计划的准确性，各列投资比例是否有漏加的分期若两者不等，主要检查全投资现金流量表及成本投资计划表若两者不等，主要检查全投资现金流量表及成本投资计划表若两者不等，调整贷款还期表的还本金比例备备注注：此此表表仅仅在在计计算算招招拍拍挂挂项项目目时时使使用用，收收并并购购项项目目无无须须看看此此表表最小加价幅度(万元)表表八八、招招拍拍挂挂项项目目敏敏感感性性分分析析表表高层售价洋房售价别

8、墅售价底商售价集中商业售价写字楼售价公寓售价300 纯土地出让金亩单价（万元）加价幅度(万元/亩)加价幅度(万元)仅土地出让金楼面价(元/)溢价率输入土地出让金（万元）含公建和契税等可售楼面价(元/)增值税和财务费用后土地增值税前利润地价比增值税和财务费用后土地增值税前销售利润率增值税和财务费用后土地增值税前利润财务费用得分230011703554.95690163%163%21.74%21.74%33712337121949127127987511823506333%333%15378.001647263%263%43.99%43.99%433914339196525225298751187

9、3508334%334%15428.001652262%262%43.94%43.94%4334143341969251251987611923509335%335%15478.001657261%261%43.89%43.89%4329143291973250250997611973511337%337%15528.001662260%260%43.84%43.84%4324143241976249249997612023513338%338%15578.001667259%259%43.79%43.79%4319143191980248248997712073514340%340%1562

10、8.001672257%257%43.74%43.74%43141431419832482481007712123516341%341%15678.001678256%256%43.69%43.69%43091430919872472471007712173517342%342%15728.001683255%255%43.63%43.63%43041430419912462461007812223519344%344%15778.001688254%254%43.58%43.58%42991429919942452451007812273521345%345%15828.001693253%

11、253%43.53%43.53%42941429419982452451017812323522347%347%15878.001698252%252%43.48%43.48%428914289110012442441017912373524348%348%15928.001704251%251%43.43%43.43%428414284110052432431017912423526349%349%15978.001709250%250%43.38%43.38%427914279110082422421027912473527351%351%16028.001714249%249%43.33

12、%43.33%427414274110122422421028012523529352%352%16078.001719248%248%43.28%43.28%426914269110162412411028012573531354%354%16128.001724247%247%43.23%43.23%426414264110192402401038012623532355%355%16178.001730246%246%43.18%43.18%425914259110232392391038012673534356%356%16228.001735245%245%43.13%43.13%4

13、25404254010262392391038112723536358%358%16278.001740244%244%43.08%43.08%424904249010302382381048112773537359%359%16328.001745243%243%43.03%43.03%424404244010342372371048112823539361%361%16378.001750242%242%42.98%42.98%423904239010372372371048212873540362%362%16428.001756241%241%42.92%42.92%423404234

14、010412362361058212923542364%364%16478.001761240%240%42.87%42.87%422904229010442352351058212973544365%365%16528.001766239%239%42.82%42.82%422404224010482342341058313023545366%366%16578.001771238%238%42.77%42.77%421904219010522342341068313073547368%368%16628.001776237%237%42.72%42.72%42140421401055233

15、2331068313123549369%369%16678.001781236%236%42.67%42.67%420904209010592322321068413173550371%371%16728.001787235%235%42.62%42.62%420404204010622322321078413223552372%372%16778.001792234%234%42.57%42.57%419904199010662312311078413273554373%373%16828.001797233%233%42.52%42.52%4194041940106923023010785

16、13323555375%375%16878.001802232%232%42.47%42.47%418904189010732302301078513373557376%376%16928.001807231%231%42.42%42.42%418404184010772292291088513423559378%378%16978.001813230%230%42.37%42.37%417904179010802282281088613473560379%379%17028.001818229%229%42.32%42.32%417404174010842282281088613523562

17、380%380%17078.001823228%228%42.26%42.26%416904169010872272271098613573564382%382%17128.001828227%227%42.21%42.21%416404164010912262261098613623565383%383%17178.001833226%226%42.16%42.16%415904159010952262261098713673567385%385%17228.001839226%226%42.11%42.11%415394153910992252251108713723568386%386%

18、17278.001844225%225%42.06%42.06%414894148911022242241108713773570387%387%17328.001849224%224%42.01%42.01%414394143911062242241108813823572389%389%17378.001854223%223%41.96%41.96%413884138811102232231118813873573390%390%17428.001859222%222%41.91%41.91%413384133811142222221118813923575392%392%17478.00

19、1865221%221%41.86%41.86%412884128811182222221118913973577393%393%17528.001870220%220%41.81%41.81%412374123711222212211128914023578394%394%17578.001875219%219%41.76%41.76%411874118711262212211128914073580396%396%17628.001880218%218%41.70%41.70%411374113711302202201129014123582397%397%17678.001885218%

20、218%41.65%41.65%410864108611332192191139014173583399%399%17728.001890217%217%41.60%41.60%410364103611372192191139014223585400%400%17778.001896216%216%41.55%41.55%409864098611412182181139114273587401%401%17828.001901215%215%41.50%41.50%409354093511452172171149114323588403%403%17878.001906214%214%41.4

21、5%41.45%408854088511492172171149114373590404%404%17928.001911213%213%41.40%41.40%408354083511532162161149214423591406%406%17978.001916212%212%41.35%41.35%407844078411572162161149214473593407%407%18028.001922212%212%41.30%41.30%407344073411612152151159214523595409%409%18078.001927211%211%41.24%41.24%

22、406844068411642142141159314573596410%410%18128.001932210%210%41.19%41.19%406334063311682142141159314623598411%411%18178.001937209%209%41.14%41.14%405834058311722132131169314673600413%413%18228.001942208%208%41.09%41.09%405334053311762132131169314723601414%414%18278.001948207%207%41.04%41.04%40482404

23、8211802122121169414773603416%416%18328.001953207%207%40.99%40.99%404324043211842122121179414823605417%417%18378.001958206%206%40.94%40.94%403824038211882112111179414873606418%418%18428.001963205%205%40.89%40.89%403324033211922102101179514923608420%420%18478.001968204%204%40.84%40.84%4028140281119521

24、02101189514973610421%421%18528.001974203%203%40.79%40.79%402314023111992092091189515023611423%423%18578.001979203%203%40.73%40.73%401814018112032092091189615073613424%424%18628.001984202%202%40.68%40.68%401304013012072082081199615123615425%425%18678.001989201%201%40.63%40.63%400804008012112082081199

25、615173616427%427%18728.001994200%200%40.58%40.58%400304003012152072071199715223618428%428%18778.001999200%200%40.53%40.53%399793997912192062061209715273619430%430%18828.002005199%199%40.48%40.48%399293992912232062061209715323621431%431%18878.002010198%198%40.43%40.43%39879398791226205205120981537362

26、3432%432%18928.002015197%197%40.38%40.38%398283982812302052051209815423624434%434%18978.002020197%197%40.33%40.33%397783977812342042041219815473626435%435%19028.002025196%196%40.28%40.28%397283972812382042041219915523628437%437%19078.002031195%195%40.22%40.22%396773967712422032031219915573629438%438

27、%19128.002036194%194%40.17%40.17%396273962712462032031229915623631439%439%19178.002041194%194%40.12%40.12%3957639576125020220212210015673633441%441%19228.002046193%193%40.07%40.07%3952639526125420120112210015723634442%442%19278.002051192%192%40.02%40.02%3947539475125820120112310015773636444%444%1932

28、8.002057191%191%39.97%39.97%3942439424126320020012310015823638445%445%19378.002062191%191%39.92%39.92%3937439374126720020012310115873639447%447%19428.002067190%190%39.87%39.87%3932339323127119919912410115923641448%448%19478.002072189%189%39.81%39.81%3927339273127519919912410115973642449%449%19528.00

29、2077188%188%39.76%39.76%3922239222127919819812410216023644451%451%19578.002083188%188%39.71%39.71%3917139171128319819812510216073646452%452%19628.002088187%187%39.66%39.66%3912139121128719719712510216123647454%454%19678.002093186%186%39.61%39.61%3907039070129219719712510316173649455%455%19728.002098

30、186%186%39.56%39.56%3902039020129619619612610316223651456%456%19778.002103185%185%39.51%39.51%3896938969130019619612610316273652458%458%19828.002108184%184%39.46%39.46%3891838918130419519512610416323654459%459%19878.002114184%184%39.40%39.40%3886838868130819519512710416373656461%461%19928.002119183%

31、183%39.35%39.35%3881738817131219419412710416423657462%462%19978.002124182%182%39.30%39.30%3876638766131719419412710516473659463%463%20028.002129181%181%39.25%39.25%3871638716132119319312710516523661465%465%20078.002134181%181%39.20%39.20%3866538665132519319312810516573662466%466%20128.002140180%180%

32、39.15%39.15%3861538615132919219212810616623664468%468%20178.002145179%179%39.10%39.10%3856438564133319219212810616673666469%469%20228.002150179%179%39.04%39.04%3851338513133719119112910616723667470%470%20278.002155178%178%38.99%38.99%3846338463134219119112910616773669472%472%20328.002160177%177%38.9

33、4%38.94%3841238412134619019012910716823670473%473%20378.002166177%177%38.89%38.89%3836238362135019019013010716873672475%475%20428.002171176%176%38.84%38.84%3831138311135418918913010716923674476%476%20478.002176176%176%38.79%38.79%3826038260135818918913010816973675477%477%20528.002181175%175%38.74%38

34、.74%3821038210136218818813110817023677479%479%20578.002186174%174%38.69%38.69%3815938159136718818813110817073679480%480%20628.002192174%174%38.63%38.63%3810938109137118718713110917123680482%482%20678.002197173%173%38.58%38.58%3805838058137518718713210917173682483%483%20728.002202172%172%38.53%38.53%

35、3800738007137918618613210917223684484%484%20778.002207172%172%38.48%38.48%3795737957138318618613211017273685486%486%20828.002212171%171%38.43%38.43%3790637906138718518513311017323687487%487%20878.002217170%170%38.38%38.38%3785537855139218518513311017373689489%489%20928.002223170%170%38.33%38.33%3780

36、537805139618418413311117423690490%490%20978.002228169%169%38.27%38.27%3775437754140018418413411117473692492%492%21028.002233169%169%38.22%38.22%3770437704140418318313411117523693493%493%21078.002238168%168%38.17%38.17%3765337653140818318313411217573695494%494%21128.002243167%167%38.12%38.12%37602376

37、02141218318313411217623697496%496%21178.002249167%167%38.07%38.07%3755237552141618218213511217673698497%497%21228.002254166%166%38.02%38.02%3750137501142118218213511317723700499%499%21278.002259165%165%37.97%37.97%3745137451142518118113511317773702500%500%21328.002264165%165%37.92%37.92%374003740014

38、2918118113611317823703501%501%21378.002269164%164%37.86%37.86%3734937349143318018013611317873705503%503%21428.002275164%164%37.81%37.81%3729937299143718018013611417923707504%504%21478.002280163%163%37.76%37.76%3724837248144117917913711417973708506%506%21528.002285162%162%37.71%37.71%3719837198144617

39、917913711418023710507%507%21578.002290162%162%37.66%37.66%3714737147145017817813711518073712508%508%21628.002295161%161%37.61%37.61%3709637096145417817813811518123713510%510%21678.002301161%161%37.56%37.56%3704637046145817817813811518173715511%511%21728.002306160%160%37.50%37.50%36995369951463177177

40、13811618223716513%513%21778.002311160%160%37.45%37.45%3694436944146717717713911618273718514%514%21828.002316159%159%37.40%37.40%3689336893147217617613911618323720515%515%21878.002321158%158%37.35%37.35%3684236842147617617613911718373721517%517%21928.002326158%158%37.30%37.30%367913679114801751751401

41、1718423723518%518%21978.002332157%157%37.25%37.25%3674036740148517517514011718473725520%520%22028.002337157%157%37.20%37.20%3668936689148917517514011818523726521%521%22078.002342156%156%37.14%37.14%3663836638149417417414011818573728522%522%22128.002347156%156%37.09%37.09%3658736587149817417414111818

42、623730524%524%22178.002352155%155%37.04%37.04%3653736537150317317314111918673731525%525%22228.002358154%154%36.99%36.99%3648636486150717317314111918723733527%527%22278.002363154%154%36.94%36.94%3643536435151217217214211918773735528%528%22328.002368153%153%36.89%36.89%36384363841516172172142120188237

43、36529%529%22378.002373153%153%36.83%36.83%3633336333152017217214212018873738531%531%22428.002378152%152%36.78%36.78%3628236282152517117114312018923740532%532%22478.002384152%152%36.73%36.73%3623136231153017117114312018973741534%534%22528.002389151%151%36.68%36.68%361803618015351701701431211902374353

44、5%535%22578.002394151%151%36.63%36.63%36128361281539170170纯土地出让金亩单价（万元）加价幅度(万元/亩)加价幅度(万元)仅土地出让金楼面价(元/)溢价率输入土地出让金（万元）含公建和契税等可售楼面价(元/)增值税和财务费用后土地增值税前利润地价比增值税和财务费用后土地增值税前销售利润率增值税和财务费用后土地增值税前利润财务费用得分14412119073744537%537%22628.002399150%150%36.57%36.57%3607736077154416916914412119123746538%538%22678.002

45、404150%150%36.52%36.52%3602636026154916916914412219173748539%539%22728.002410149%149%36.47%36.47%3597535975155416916914512219223749541%541%22778.002415148%148%36.42%36.42%3592435924155816816814512219273751542%542%22828.002420148%148%36.37%36.37%3587235872156316816814512319323753544%544%22878.0024251

46、47%147%36.32%36.32%3582135821156816716714612319373754545%545%22928.002430147%147%36.26%36.26%3577035770157216716714612319423756546%546%22978.002435146%146%36.21%36.21%3571935719157716716714612419473758548%548%23028.002441146%146%36.16%36.16%3566735667158216616614712419523759549%549%23078.002446145%1

47、45%36.11%36.11%3561635616158716616614712419573761551%551%23128.002451145%145%36.05%36.05%3556435564159216516514712519623763552%552%23178.002456144%144%36.00%36.00%3551335513159716516514712519673764553%553%23228.002461144%144%35.95%35.95%3546135461160316516514812519723766555%555%23278.002467143%143%3

48、5.90%35.90%3541035410160816416414812619773767556%556%23328.002472143%143%35.85%35.85%3535835358161316416414812619823769558%558%23378.002477142%142%35.79%35.79%3530735307161816316314912619873771559%559%23428.002482142%142%35.74%35.74%3525535255162316316314912619923772560%560%23478.002487141%141%35.69

49、%35.69%3520435204162816316314912719973774562%562%23528.002493141%141%35.64%35.64%3515235152163316216215012720023776563%563%23578.002498140%140%35.58%35.58%3510035100163816216215012720073777565%565%23628.002503140%140%35.53%35.53%3504935049164316116115012820123779566%566%23678.002508139%139%35.48%35.

50、48%3499734997164916116115112820173781567%567%23728.002513139%139%35.43%35.43%3494534945165416116115112820223782569%569%23778.002518138%138%35.37%35.37%3489334893165916016015112920273784570%570%23828.002524138%138%35.32%35.32%3484234842166516016015212920323786572%572%23878.002529137%137%35.27%35.27%3