1、丁丁卯卯项项目目投投资资成成本本分分析析模模板板序号成本科目单价(元/平方米)总价(元)累计(元)一土地成本土地出让金2,479.7289,270,000.0096,620,800.00市政配套费105.003,780,000.00地契税99.193,570,800.00二前期费用勘查设计费30.001,080,000.002,196,000.00五通一平25.00900,000.00其他6.00216,000.00三规费设备维修基金25.00900,000.001,787,400.00散装水泥1.5054,000.00白蚁防治1.1541,400.00墙改费10.00360,000.00渣土2、费2.0072,000.00绿地费10.00360,000.00四建安费土建1,050.0037,800,000.0041,328,000.00安装45.001,620,000.00设备35.001,260,000.00质检监理10.00360,000.00其他8.00288,000.00五基础设施费室外工程120.004,320,000.009,360,000.00绿化环艺100.003,600,000.00小区配套40.001,440,000.00六营销费用120.004,320,000.004,320,000.00七管理费64.842,334,183.002,334,183.00八财务费3、用45.001,620,000.001,620,000.00九不可预见费38.041,369,440.001,369,440.00十合计4,470.44160,935,823.00160,935,823.00换算为美金$588.22$21,458,109.73$21,458,109.73现现金金流流营营销销策策略略下下的的主主要要财财务务指指标标表表序号指标项目数值（元）换算为美金1总销售收入189,350,000.00$25,246,666.672总投资160,935,823.00$21,458,109.733营业税及附加20,828,500.00$2,777,133.334销售利润（毛利）4、7,585,677.00$1,011,423.605销售利税率15%6投资利税率18%7销售利润率4%8投资利润率5%9销售净利润率3%10投资净利润率4%注注意意：本本模模板板已已经经设设定定了了函函数数关关系系，千千万万不不要要随随意意更更改改格格式式。敏敏感感性性分分析析价格敏感 初始价格（元/pfm）4000调整后价格投资净利润率总销售收入20%48001%总投资15%4600-2%营业税及附加10%4400-5%销售利润（毛利）5%4200-8%投资净利润率04000-11%-5%3800-14%-10%3600-18%-15%3400-21%-20%3200-24%成本敏感初始成本5、160,935,823.00调整后成本投资净利润率总投资20%193,122,987.60-5%总销售收入15%185,076,196.45-2%营业税及附加10%177,029,405.301%销售利润（毛利）5%168,982,614.155%投资净利润率0160,935,823.009%-5%152,889,031.8513%-10%144,842,240.7018%-15%136,795,449.5524%-20%128,748,658.4030%盈盈亏亏平平衡衡点点分分析析单位税金578.5694444单位：元/平方米均价平衡点总销售金额/建安费4581.639566单位：元/平方米6、面积平衡点总成本/均价平衡点35,126.25单位：平方米盈亏平衡率面积平衡点/总建筑面积0.975729204百分数投投资资成成本本固固定定时时投投资资净净利利润润率率与与销销售售收收入入增增减减关关系系图图X轴20%15%10%5%0%Y轴1%-2%-5%-8%-11%销销售售收收入入固固定定时时投投资资净净利利润润率率与与开开发发成成本本增增减减关关系系图图X轴20%15%10%5%0Y轴-5%-2%1%5%9%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系7、列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1备注占地面积:15,000.0036000容积率:2.4建筑面积:36,000.00土地总价:89,270,000.00含建筑、景观、管线等设计土地面积：22.6土建:1,250.00其他设计、验线、会审、会评土地单价:38、,950,000.00间接开发成本间接开发成本间接开发成本含建设费、道路等含公建配套前六项之和1.5%建安费、室外工程费的3%住宅建筑面积：27,500.00住宅均价：4,500.00商业建筑面积：8,200.00商业均价：8,000.004800460044004200172,800,000.00165,600,000.00158,400,000.00151,200,000.00160,935,823.00160,935,823.00160,935,823.00160,935,823.008,769,600.008,404,200.008,038,800.007,673,400.003,099、4,577.00-3,740,023.00-10,574,623.00-17,409,223.001%-2%-5%-8%193,122,987.60185,076,196.45177,029,405.30168,982,614.15189,350,000.00189,350,000.00189,350,000.00189,350,000.009,609,512.509,609,512.509,609,512.509,609,512.50-13,382,500.10-5,335,708.952,711,082.2010,757,873.35-5%-2%1%5%-5%-10%-15%-20%-1410、%-18%-21%-24%-5%-10%-15%-20%13%18%24%30%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%11、15%20%25%30%35%系列1单位(平方米)单位(平方米)单位(元)单位（亩）单位(元/平方米)单位(元/亩)单位(平方米)单位(元/平方米)单位(平方米)单位(元/平方米)40003800360034003200144,000,000.00136,800,000.00129,600,000.00122,400,000.00115,200,000.00160,935,823.00160,935,823.00160,935,823.00160,935,823.00160,935,823.007,308,000.006,942,600.006,577,200.006,211,800.005,12、846,400.00-24,243,823.00-31,078,423.00-37,913,023.00-44,747,623.00-51,582,223.00-11%-14%-18%-21%-24%160,935,823.00152,889,031.85144,842,240.70136,795,449.55128,748,658.40189,350,000.00189,350,000.00189,350,000.00189,350,000.00189,350,000.009,609,512.509,609,512.509,609,512.509,609,512.509,609,512.5013、18,804,664.5026,851,455.6534,898,246.8042,945,037.9550,991,829.109%13%18%24%30%拍卖面积15000容积率2.4住宅售价(元/m2)4500总建筑面积(万m2)36000商业售价(元/m2)8000住宅(万m2)27500商务售价(元/m2)商业(万m2)8500车库售价(元/m2)0商务（万m2）综合售价(元/m2)0车库（万m2）可售面积(万m2)36000土地底价(万元)2020万元变化值(元)20.00增价幅度（万元）土地总价（万元）土地成本(元/m2)直接成本(元/m2)总成本(元/m2)022001733.14、724134.094557.182022201753.724154.094577.184022401773.724174.094597.186022601793.724194.094617.188022801813.724214.094637.1810023001833.724234.094657.1812023201853.724254.094677.1814023401873.724274.094697.1816023601893.724294.094717.1818023801913.724314.094737.1820024001933.724334.094757.182202420115、953.724354.094777.1824024401973.724374.094797.1826024601993.724394.094817.1828024802013.724414.094837.1830025002033.724434.094857.1832025202053.724454.094877.1834025402073.724474.094897.1836025602093.724494.094917.1838025802113.724514.094937.1840026002133.724534.094957.1842026202153.724554.094977.1816、44026402173.724574.094997.1846026602193.724594.095017.1848026802213.724614.095037.1850027002233.724634.095057.1852027202253.724654.095077.1854027402273.724674.095097.1856027602293.724694.095117.1858027802313.724714.095137.1860028002333.724734.095157.1862028202353.724754.095177.1864028402373.724774.017、95197.1866028602393.724794.095217.1868028802413.724814.095237.1870029002433.724834.095257.1872029202453.724854.095277.1874029402473.724874.095297.1876029602493.724894.095317.1878029802513.724914.095337.1880030002533.724934.095357.1882030202553.724954.095377.1884030402573.724974.095397.1886030602593.18、724994.095417.1888030802613.725014.095437.1890031002633.725034.095457.1892031202653.725054.095477.1894031402673.725074.095497.1896031602693.725094.095517.1898031802713.725114.095537.18100032002733.725134.095557.18102032202753.725154.095577.18104032402773.725174.095597.18106032602793.725194.095617.1819、108032802813.725214.095637.18110033002833.725234.095657.18112033202853.725254.095677.18114033402873.725274.095697.18116033602893.725294.095717.18118033802913.725314.095737.18120034002933.725334.095757.18122034202953.725354.095777.18124034402973.725374.095797.18126034602993.725394.095817.18128034803020、13.725414.095837.18130035003033.725434.095857.18132035203053.725454.095877.18134035403073.725474.095897.18136035603093.725494.095917.18138035803113.725514.095937.18140036003133.725534.095957.18142036203153.725554.095977.18144036403173.725574.095997.18146036603193.725594.096017.18148036803213.725614.21、096037.18150037003233.725634.096057.18152037203253.725654.096077.18154037403273.725674.096097.18156037603293.725694.096117.18158037803313.725714.096137.18160038003333.725734.096157.18162038203353.725754.096177.18164038403373.725774.096197.18166038603393.725794.096217.18168038803413.725814.096237.18122、70039003433.725834.096257.18172039203453.725854.096277.18174039403473.725874.096297.18176039603493.725894.096317.18178039803513.725914.096337.18180040003533.725934.096357.18182040203553.725954.096377.18184040403573.725974.096397.18186040603593.725994.096417.18188040803613.726014.096437.181900410036323、3.726034.096457.18192041203653.726054.096477.18194041403673.726074.096497.18196041603693.726094.096517.18198041803713.726114.096537.18200042003733.726134.096557.18202042203753.726154.096577.18204042403773.726174.096597.18206042603793.726194.096617.18208042803813.726214.096637.18210043003833.726234.024、96657.18212043203853.726254.096677.18214043403873.726274.096697.18216043603893.726294.096717.18218043803913.726314.096737.18220044003933.726334.096757.18222044203953.726354.096777.18224044403973.726374.096797.18226044603993.726394.096817.18228044804013.726414.096837.18230045004033.726434.096857.182325、2045204053.726454.096877.18234045404073.726474.096897.18236045604093.726494.096917.18238045804113.726514.096937.18240046004133.726534.096957.18242046204153.726554.096977.18244046404173.726574.096997.18246046604193.726594.097017.18248046804213.726614.097037.18250047004233.726634.097057.1825204720425326、.726654.097077.18254047404273.726674.097097.18256047604293.726694.097117.18258047804313.726714.097137.18260048004333.726734.097157.18262048204353.726754.097177.18264048404373.726774.097197.18266048604393.726794.097217.18268048804413.726814.097237.18270049004433.726834.097257.18272049204453.726854.0927、7277.18274049404473.726874.097297.18276049604493.726894.097317.18278049804513.726914.097337.18280050004533.726934.097357.18282050204553.726954.097377.18284050404573.726974.097397.18286050604593.726994.097417.18288050804613.727014.097437.18290051004633.727034.097457.18292051204653.727054.097477.1829428、051404673.727074.097497.18296051604693.727094.097517.18298051804713.727114.097537.18300052004733.727134.097557.18302052204753.727154.097577.18304052404773.727174.097597.18306052604793.727194.097617.18308052804813.727214.097637.18310053004833.727234.097657.18312053204853.727254.097677.18314053404873.29、727274.097697.18316053604893.727294.097717.18318053804913.727314.097737.18320054004933.727334.097757.18322054204953.727354.097777.18324054404973.727374.097797.18326054604993.727394.097817.18328054805013.727414.097837.18330055005033.727434.097857.18332055205053.727454.097877.18334055405073.727474.09730、897.18336055605093.727494.097917.18338055805113.727514.097937.18340056005133.727534.097957.18342056205153.727554.097977.18344056405173.727574.097997.18346056605193.727594.098017.18348056805213.727614.098037.18350057005233.727634.098057.18352057205253.727654.098077.18354057405273.727674.098097.18356031、57605293.727694.098117.18358057805313.727714.098137.18360058005333.727734.098157.18362058205353.727754.098177.18364058405373.727774.098197.18366058605393.727794.098217.18368058805413.727814.098237.18370059005433.727834.098257.18372059205453.727854.098277.18374059405473.727874.098297.18376059605493.732、27894.098317.18378059805513.727914.098337.18380060005533.727934.098357.18382060205553.727954.098377.18384060405573.727974.098397.18386060605593.727994.098417.18388060805613.728014.098437.18390061005633.728034.098457.18392061205653.728054.098477.18394061405673.728074.098497.18396061605693.728094.098533、17.18398061805713.728114.098537.18400062005733.728134.098557.18402062205753.728154.098577.18404062405773.728174.098597.18406062605793.728194.098617.18408062805813.728214.098637.18410063005833.728234.098657.18412063205853.728254.098677.18414063405873.728274.098697.18416063605893.728294.098717.184180634、3805913.728314.098737.18420064005933.728334.098757.18422064205953.728354.098777.18424064405973.728374.098797.18426064605993.728394.098817.18428064806013.728414.098837.18430065006033.728434.098857.18432065206053.728454.098877.18434065406073.728474.098897.18436065606093.728494.098917.18438065806113.7235、8514.098937.18440066006133.728534.098957.18442066206153.728554.098977.18444066406173.728574.098997.18446066606193.728594.099017.18448066806213.728614.099037.18450067006233.728634.099057.18452067206253.728654.099077.18454067406273.728674.099097.18456067606293.728694.099117.18458067806313.728714.0991336、7.18460068006333.728734.099157.18462068206353.728754.099177.18464068406373.728774.099197.18466068606393.728794.099217.18468068806413.728814.099237.18470069006433.728834.099257.18472069206453.728854.099277.18474069406473.728874.099297.18476069606493.728894.099317.18478069806513.728914.099337.1848007037、006533.728934.099357.18482070206553.728954.099377.18484070406573.728974.099397.18486070606593.728994.099417.18488070806613.729014.099437.18490071006633.729034.099457.18492071206653.729054.099477.18494071406673.729074.099497.18496071606693.729094.099517.18498071806713.729114.099537.18500072006733.72938、134.099557.18502072206753.729154.099577.18504072406773.729174.099597.18506072606793.729194.099617.18508072806813.729214.099637.18510073006833.729234.099657.18512073206853.729254.099677.18514073406873.729274.099697.18516073606893.729294.099717.18518073806913.729314.099737.18520074006933.729334.09975739、.18522074206953.729354.099777.18524074406973.729374.099797.18526074606993.729394.099817.18528074807013.729414.099837.18530075007033.729434.099857.18532075207053.729454.099877.18534075407073.729474.099897.18536075607093.729494.099917.18538075807113.729514.099937.18540076007133.729534.099957.18542076240、07153.729554.099977.18544076407173.729574.099997.18546076607193.729594.0910017.18548076807213.729614.0910037.18利润(元/m2)毛利率(%)销售利润率(%)(4557.18)#DIV/0!#DIV/0!(4577.18)#DIV/0!#DIV/0!(4597.18)#DIV/0!#DIV/0!(4617.18)#DIV/0!#DIV/0!(4637.18)#DIV/0!#DIV/0!(4657.18)#DIV/0!#DIV/0!(4677.18)#DIV/0!#DIV/0!(4697.41、18)#DIV/0!#DIV/0!(4717.18)#DIV/0!#DIV/0!(4737.18)#DIV/0!#DIV/0!(4757.18)#DIV/0!#DIV/0!(4777.18)#DIV/0!#DIV/0!(4797.18)#DIV/0!#DIV/0!(4817.18)#DIV/0!#DIV/0!(4837.18)#DIV/0!#DIV/0!(4857.18)#DIV/0!#DIV/0!(4877.18)#DIV/0!#DIV/0!(4897.18)#DIV/0!#DIV/0!(4917.18)#DIV/0!#DIV/0!(4937.18)#DIV/0!#DIV/0!(4957.142、8)#DIV/0!#DIV/0!(4977.18)#DIV/0!#DIV/0!(4997.18)#DIV/0!#DIV/0!(5017.18)#DIV/0!#DIV/0!(5037.18)#DIV/0!#DIV/0!(5057.18)#DIV/0!#DIV/0!(5077.18)#DIV/0!#DIV/0!(5097.18)#DIV/0!#DIV/0!(5117.18)#DIV/0!#DIV/0!(5137.18)#DIV/0!#DIV/0!(5157.18)#DIV/0!#DIV/0!(5177.18)#DIV/0!#DIV/0!(5197.18)#DIV/0!#DIV/0!(5217.1843、)#DIV/0!#DIV/0!(5237.18)#DIV/0!#DIV/0!(5257.18)#DIV/0!#DIV/0!(5277.18)#DIV/0!#DIV/0!(5297.18)#DIV/0!#DIV/0!(5317.18)#DIV/0!#DIV/0!(5337.18)#DIV/0!#DIV/0!(5357.18)#DIV/0!#DIV/0!(5377.18)#DIV/0!#DIV/0!(5397.18)#DIV/0!#DIV/0!(5417.18)#DIV/0!#DIV/0!(5437.18)#DIV/0!#DIV/0!(5457.18)#DIV/0!#DIV/0!(5477.18)44、#DIV/0!#DIV/0!(5497.18)#DIV/0!#DIV/0!(5517.18)#DIV/0!#DIV/0!(5537.18)#DIV/0!#DIV/0!(5557.18)#DIV/0!#DIV/0!(5577.18)#DIV/0!#DIV/0!(5597.18)#DIV/0!#DIV/0!(5617.18)#DIV/0!#DIV/0!(5637.18)#DIV/0!#DIV/0!(5657.18)#DIV/0!#DIV/0!(5677.18)#DIV/0!#DIV/0!(5697.18)#DIV/0!#DIV/0!(5717.18)#DIV/0!#DIV/0!(5737.18)#45、DIV/0!#DIV/0!(5757.18)#DIV/0!#DIV/0!(5777.18)#DIV/0!#DIV/0!(5797.18)#DIV/0!#DIV/0!(5817.18)#DIV/0!#DIV/0!(5837.18)#DIV/0!#DIV/0!(5857.18)#DIV/0!#DIV/0!(5877.18)#DIV/0!#DIV/0!(5897.18)#DIV/0!#DIV/0!(5917.18)#DIV/0!#DIV/0!(5937.18)#DIV/0!#DIV/0!(5957.18)#DIV/0!#DIV/0!(5977.18)#DIV/0!#DIV/0!(5997.18)#D46、IV/0!#DIV/0!(6017.18)#DIV/0!#DIV/0!(6037.18)#DIV/0!#DIV/0!(6057.18)#DIV/0!#DIV/0!(6077.18)#DIV/0!#DIV/0!(6097.18)#DIV/0!#DIV/0!(6117.18)#DIV/0!#DIV/0!(6137.18)#DIV/0!#DIV/0!(6157.18)#DIV/0!#DIV/0!(6177.18)#DIV/0!#DIV/0!(6197.18)#DIV/0!#DIV/0!(6217.18)#DIV/0!#DIV/0!(6237.18)#DIV/0!#DIV/0!(6257.18)#DI47、V/0!#DIV/0!(6277.18)#DIV/0!#DIV/0!(6297.18)#DIV/0!#DIV/0!(6317.18)#DIV/0!#DIV/0!(6337.18)#DIV/0!#DIV/0!(6357.18)#DIV/0!#DIV/0!(6377.18)#DIV/0!#DIV/0!(6397.18)#DIV/0!#DIV/0!(6417.18)#DIV/0!#DIV/0!(6437.18)#DIV/0!#DIV/0!(6457.18)#DIV/0!#DIV/0!(6477.18)#DIV/0!#DIV/0!(6497.18)#DIV/0!#DIV/0!(6517.18)#DIV48、/0!#DIV/0!(6537.18)#DIV/0!#DIV/0!(6557.18)#DIV/0!#DIV/0!(6577.18)#DIV/0!#DIV/0!(6597.18)#DIV/0!#DIV/0!(6617.18)#DIV/0!#DIV/0!(6637.18)#DIV/0!#DIV/0!(6657.18)#DIV/0!#DIV/0!(6677.18)#DIV/0!#DIV/0!(6697.18)#DIV/0!#DIV/0!(6717.18)#DIV/0!#DIV/0!(6737.18)#DIV/0!#DIV/0!(6757.18)#DIV/0!#DIV/0!(6777.18)#DIV/49、0!#DIV/0!(6797.18)#DIV/0!#DIV/0!(6817.18)#DIV/0!#DIV/0!(6837.18)#DIV/0!#DIV/0!(6857.18)#DIV/0!#DIV/0!(6877.18)#DIV/0!#DIV/0!(6897.18)#DIV/0!#DIV/0!(6917.18)#DIV/0!#DIV/0!(6937.18)#DIV/0!#DIV/0!(6957.18)#DIV/0!#DIV/0!(6977.18)#DIV/0!#DIV/0!(6997.18)#DIV/0!#DIV/0!(7017.18)#DIV/0!#DIV/0!(7037.18)#DIV/050、!#DIV/0!(7057.18)#DIV/0!#DIV/0!(7077.18)#DIV/0!#DIV/0!(7097.18)#DIV/0!#DIV/0!(7117.18)#DIV/0!#DIV/0!(7137.18)#DIV/0!#DIV/0!(7157.18)#DIV/0!#DIV/0!(7177.18)#DIV/0!#DIV/0!(7197.18)#DIV/0!#DIV/0!(7217.18)#DIV/0!#DIV/0!(7237.18)#DIV/0!#DIV/0!(7257.18)#DIV/0!#DIV/0!(7277.18)#DIV/0!#DIV/0!(7297.18)#DIV/0!51、#DIV/0!(7317.18)#DIV/0!#DIV/0!(7337.18)#DIV/0!#DIV/0!(7357.18)#DIV/0!#DIV/0!(7377.18)#DIV/0!#DIV/0!(7397.18)#DIV/0!#DIV/0!(7417.18)#DIV/0!#DIV/0!(7437.18)#DIV/0!#DIV/0!(7457.18)#DIV/0!#DIV/0!(7477.18)#DIV/0!#DIV/0!(7497.18)#DIV/0!#DIV/0!(7517.18)#DIV/0!#DIV/0!(7537.18)#DIV/0!#DIV/0!(7557.18)#DIV/0!#52、DIV/0!(7577.18)#DIV/0!#DIV/0!(7597.18)#DIV/0!#DIV/0!(7617.18)#DIV/0!#DIV/0!(7637.18)#DIV/0!#DIV/0!(7657.18)#DIV/0!#DIV/0!(7677.18)#DIV/0!#DIV/0!(7697.18)#DIV/0!#DIV/0!(7717.18)#DIV/0!#DIV/0!(7737.18)#DIV/0!#DIV/0!(7757.18)#DIV/0!#DIV/0!(7777.18)#DIV/0!#DIV/0!(7797.18)#DIV/0!#DIV/0!(7817.18)#DIV/0!#D53、IV/0!(7837.18)#DIV/0!#DIV/0!(7857.18)#DIV/0!#DIV/0!(7877.18)#DIV/0!#DIV/0!(7897.18)#DIV/0!#DIV/0!(7917.18)#DIV/0!#DIV/0!(7937.18)#DIV/0!#DIV/0!(7957.18)#DIV/0!#DIV/0!(7977.18)#DIV/0!#DIV/0!(7997.18)#DIV/0!#DIV/0!(8017.18)#DIV/0!#DIV/0!(8037.18)#DIV/0!#DIV/0!(8057.18)#DIV/0!#DIV/0!(8077.18)#DIV/0!#DI54、V/0!(8097.18)#DIV/0!#DIV/0!(8117.18)#DIV/0!#DIV/0!(8137.18)#DIV/0!#DIV/0!(8157.18)#DIV/0!#DIV/0!(8177.18)#DIV/0!#DIV/0!(8197.18)#DIV/0!#DIV/0!(8217.18)#DIV/0!#DIV/0!(8237.18)#DIV/0!#DIV/0!(8257.18)#DIV/0!#DIV/0!(8277.18)#DIV/0!#DIV/0!(8297.18)#DIV/0!#DIV/0!(8317.18)#DIV/0!#DIV/0!(8337.18)#DIV/0!#DIV55、/0!(8357.18)#DIV/0!#DIV/0!(8377.18)#DIV/0!#DIV/0!(8397.18)#DIV/0!#DIV/0!(8417.18)#DIV/0!#DIV/0!(8437.18)#DIV/0!#DIV/0!(8457.18)#DIV/0!#DIV/0!(8477.18)#DIV/0!#DIV/0!(8497.18)#DIV/0!#DIV/0!(8517.18)#DIV/0!#DIV/0!(8537.18)#DIV/0!#DIV/0!(8557.18)#DIV/0!#DIV/0!(8577.18)#DIV/0!#DIV/0!(8597.18)#DIV/0!#DIV/56、0!(8617.18)#DIV/0!#DIV/0!(8637.18)#DIV/0!#DIV/0!(8657.18)#DIV/0!#DIV/0!(8677.18)#DIV/0!#DIV/0!(8697.18)#DIV/0!#DIV/0!(8717.18)#DIV/0!#DIV/0!(8737.18)#DIV/0!#DIV/0!(8757.18)#DIV/0!#DIV/0!(8777.18)#DIV/0!#DIV/0!(8797.18)#DIV/0!#DIV/0!(8817.18)#DIV/0!#DIV/0!(8837.18)#DIV/0!#DIV/0!(8857.18)#DIV/0!#DIV/057、!(8877.18)#DIV/0!#DIV/0!(8897.18)#DIV/0!#DIV/0!(8917.18)#DIV/0!#DIV/0!(8937.18)#DIV/0!#DIV/0!(8957.18)#DIV/0!#DIV/0!(8977.18)#DIV/0!#DIV/0!(8997.18)#DIV/0!#DIV/0!(9017.18)#DIV/0!#DIV/0!(9037.18)#DIV/0!#DIV/0!(9057.18)#DIV/0!#DIV/0!(9077.18)#DIV/0!#DIV/0!(9097.18)#DIV/0!#DIV/0!(9117.18)#DIV/0!#DIV/0!58、(9137.18)#DIV/0!#DIV/0!(9157.18)#DIV/0!#DIV/0!(9177.18)#DIV/0!#DIV/0!(9197.18)#DIV/0!#DIV/0!(9217.18)#DIV/0!#DIV/0!(9237.18)#DIV/0!#DIV/0!(9257.18)#DIV/0!#DIV/0!(9277.18)#DIV/0!#DIV/0!(9297.18)#DIV/0!#DIV/0!(9317.18)#DIV/0!#DIV/0!(9337.18)#DIV/0!#DIV/0!(9357.18)#DIV/0!#DIV/0!(9377.18)#DIV/0!#DIV/0!(59、9397.18)#DIV/0!#DIV/0!(9417.18)#DIV/0!#DIV/0!(9437.18)#DIV/0!#DIV/0!(9457.18)#DIV/0!#DIV/0!(9477.18)#DIV/0!#DIV/0!(9497.18)#DIV/0!#DIV/0!(9517.18)#DIV/0!#DIV/0!(9537.18)#DIV/0!#DIV/0!(9557.18)#DIV/0!#DIV/0!(9577.18)#DIV/0!#DIV/0!(9597.18)#DIV/0!#DIV/0!(9617.18)#DIV/0!#DIV/0!(9637.18)#DIV/0!#DIV/0!(960、657.18)#DIV/0!#DIV/0!(9677.18)#DIV/0!#DIV/0!(9697.18)#DIV/0!#DIV/0!(9717.18)#DIV/0!#DIV/0!(9737.18)#DIV/0!#DIV/0!(9757.18)#DIV/0!#DIV/0!(9777.18)#DIV/0!#DIV/0!(9797.18)#DIV/0!#DIV/0!(9817.18)#DIV/0!#DIV/0!(9837.18)#DIV/0!#DIV/0!(9857.18)#DIV/0!#DIV/0!(9877.18)#DIV/0!#DIV/0!(9897.18)#DIV/0!#DIV/0!(9961、17.18)#DIV/0!#DIV/0!(9937.18)#DIV/0!#DIV/0!(9957.18)#DIV/0!#DIV/0!(9977.18)#DIV/0!#DIV/0!(9997.18)#DIV/0!#DIV/0!(10017.18)#DIV/0!#DIV/0!(10037.18)#DIV/0!#DIV/0!占地面积建筑面积单价总建筑面积别墅X0.8X340087409小高层79463-X（79463-X）Y2500Y值X值为别墅建筑面积小高层建筑面积别墅总收入小高层总收入合计收入1.21986715893.671515.4 54,038,240.00178,788,500.002362、2,826,740.001.33178425427.261981.8 86,452,480.00154,954,500.00241,406,980.001.43973231785.655623.4 108,071,040.00139,058,500.00247,129,540.001.54540836326.451082.6 123,509,760.00127,706,500.00251,216,260.001.6496653973247677 135,088,800.00119,192,500.00254,281,300.00大大港港项项目目投投资资成成本本分分析析模模板板序号成本科目单价(63、元/平方米)总价(元)累计(元)一土地成本土地出让金625.0060,000,000.0070,080,000.00市政配套费80.007,680,000.00地契税25.002,400,000.00二前期费用勘查设计费30.002,880,000.005,856,000.00五通一平25.002,400,000.00其他6.00576,000.00三规费设备维修基金0.000.002,366,400.00散装水泥1.50144,000.00白蚁防治1.15110,400.00墙改费10.00960,000.00渣土费2.00192,000.00绿地费10.00960,000.00四建安费土建64、800.0076,800,000.0082,368,000.00安装20.001,920,000.00设备20.001,920,000.00质检监理10.00960,000.00其他8.00768,000.00五基础设施费室外工程120.0011,520,000.0024,960,000.00绿化环艺100.009,600,000.00小区配套40.003,840,000.00六营销费用120.0011,520,000.0011,520,000.00七管理费30.802,957,256.002,957,256.00八财务费用45.004,320,000.004,320,000.00九不可预见费65、29.342,816,640.002,816,640.00十合计2,158.79207,244,296.00207,244,296.00换算为美金$299.83$28,783,930.00$28,783,930.00现现金金流流营营销销策策略略下下的的主主要要财财务务指指标标表表序号指标项目数值（元）换算为美金1总销售收入288,000,000.00$40,000,000.002总投资207,244,296.00$28,783,930.003营业税及附加31,680,000.00$4,400,000.004销售利润（毛利）49,075,704.00$6,816,070.005销售利税率28%666、投资利税率39%7销售利润率17%8投资利润率24%9销售净利润率13%10投资净利润率18%注注意意：本本模模板板已已经经设设定定了了函函数数关关系系，千千万万不不要要随随意意更更改改格格式式。敏敏感感性性分分析析价格敏感 初始价格（元/pfm）3000调整后价格投资净利润率总销售收入20%360036%总投资15%345032%营业税及附加10%330027%销售利润（毛利）5%315022%投资净利润率0300018%-5%285013%-10%27008%-15%25504%-20%2400-1%成本敏感初始成本207,244,296.00调整后成本投资净利润率总投资20%248,6967、3,155.202%总销售收入15%238,330,940.406%营业税及附加10%227,968,725.609%销售利润（毛利）5%217,606,510.8013%投资净利润率0207,244,296.0018%-5%196,882,081.2023%-10%186,519,866.4028%-15%176,157,651.6034%-20%165,795,436.8041%盈盈亏亏平平衡衡点点分分析析单位税金330单位：元/平方米均价平衡点总销售金额/建安费3496.503497单位：元/平方米面积平衡点总成本/均价平衡点59,271.87单位：平方米盈亏平衡率面积平衡点/总建筑面积68、0.617415299百分数投投资资成成本本固固定定时时投投资资净净利利润润率率与与销销售售收收入入增增减减关关系系图图X轴20%15%10%5%0%Y轴36%32%27%22%18%销销售售收收入入固固定定时时投投资资净净利利润润率率与与开开发发成成本本增增减减关关系系图图X轴20%15%10%5%0Y轴2%6%9%13%18%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%69、5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1备注占地面积:80,000.0096000容积率:1.2建筑面积:96,000.00土地总价:60,000,000.00含建筑、景观、管线等设计土地面积：120土建:800.00其他设计、验线、会审、会评土地单价:500,000.00间接开发成本间接开发成本间接开发成本含建设费、道路等含公建配套前六项之和1.570、%建安费、室外工程费的3%住宅建筑面积：96,000.00住宅均价：3,000.00商业建筑面积：-商业均价：-3600345033003150345,600,000.00331,200,000.00316,800,000.00302,400,000.00207,244,296.00207,244,296.00207,244,296.00207,244,296.0038,016,000.0036,432,000.0034,848,000.0033,264,000.00100,339,704.0087,523,704.0074,707,704.0061,891,704.0036%32%27%2271、%248,693,155.20238,330,940.40227,968,725.60217,606,510.80288,000,000.00288,000,000.00288,000,000.00288,000,000.0031,680,000.0031,680,000.0031,680,000.0031,680,000.007,626,844.8017,989,059.6028,351,274.4038,713,489.202%6%9%13%-5%-10%-15%-20%13%8%4%-1%-5%-10%-15%-20%23%28%34%41%-5%-2%1%5%9%13%18%24%3072、%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1单位(平方米)单位(平方米)单位(元)单位（亩）单位(元/平方米)单位(元/亩)单位(平方73、米)单位(元/平方米)单位(平方米)单位(元/平方米)30002850270025502400288,000,000.00273,600,000.00259,200,000.00244,800,000.00230,400,000.00207,244,296.00207,244,296.00207,244,296.00207,244,296.00207,244,296.0031,680,000.0030,096,000.0028,512,000.0026,928,000.0025,344,000.0049,075,704.0036,259,704.0023,443,704.0010,627,7074、4.00-2,188,296.0018%13%8%4%-1%207,244,296.00196,882,081.20186,519,866.40176,157,651.60165,795,436.80288,000,000.00288,000,000.00288,000,000.00288,000,000.00288,000,000.0031,680,000.0031,680,000.0031,680,000.0031,680,000.0031,680,000.0049,075,704.0059,437,918.8069,800,133.6080,162,348.4090,524,563.2075、18%23%28%34%41%丹丹徒徒项项目目投投资资成成本本分分析析模模板板序号成本科目单价(元/平方米)总价(元)累计(元)一土地成本土地出让金555.5567,000,000.0079,328,048.24市政配套费80.009,648,048.24地契税22.222,680,000.00二前期费用勘查设计费30.003,618,018.097,356,636.78五通一平25.003,015,015.08其他6.00723,603.62三规费设备维修基金25.003,015,015.085,987,819.94散装水泥1.50180,900.90白蚁防治1.15138,690.69墙改76、费10.001,206,006.03渣土费2.00241,201.21绿地费10.001,206,006.03四建安费土建900.00108,540,542.70119,756,398.78安装40.004,824,024.12设备35.004,221,021.11质检监理10.001,206,006.03其他8.00964,804.82五基础设施费室外工程100.0012,060,060.3031,356,156.78绿化环艺120.0014,472,072.36小区配套40.004,824,024.12六营销费用120.0014,472,072.3614,472,072.36七管理费32.77、123,873,856.993,873,856.99八财务费用45.005,427,027.145,427,027.14九不可预见费32.793,954,493.773,954,493.77十合计2,251.34271,512,510.78271,512,510.78换算为美金$296.23$36,201,668.10$36,201,668.10现现金金流流营营销销策策略略下下的的主主要要财财务务指指标标表表序号指标项目数值（元）换算为美金1总销售收入482,402,400.00$64,320,320.002总投资271,512,510.78$36,201,668.103营业税及附加53,0678、4,264.00$7,075,235.204销售利润（毛利）157,825,625.22$21,043,416.705销售利税率44%6投资利税率78%7销售利润率33%8投资利润率58%9销售净利润率25%10投资净利润率44%注注意意：本本模模板板已已经经设设定定了了函函数数关关系系，千千万万不不要要随随意意更更改改格格式式。敏敏感感性性分分析析价格敏感 初始价格（元/pfm）4000调整后价格投资净利润率总销售收入20%480067%总投资15%460061%营业税及附加10%440055%销售利润（毛利）5%420050%投资净利润率0400044%-5%380038%-10%360079、32%-15%340026%-20%320020%成本敏感初始成本271,512,510.78调整后成本投资净利润率总投资20%325,815,012.9424%总销售收入15%312,239,387.4028%营业税及附加10%298,663,761.8633%销售利润（毛利）5%285,088,136.3238%投资净利润率0271,512,510.7844%-5%257,936,885.2450%-10%244,361,259.7057%-15%230,785,634.1665%-20%217,210,008.6373%盈盈亏亏平平衡衡点点分分析析单位税金439.9999891单位：元/80、平方米均价平衡点总销售金额/建安费4028.197281单位：元/平方米面积平衡点总成本/均价平衡点67,402.98单位：平方米盈亏平衡率面积平衡点/总建筑面积0.558894241百分数投投资资成成本本固固定定时时投投资资净净利利润润率率与与销销售售收收入入增增减减关关系系图图X轴20%15%10%5%0%Y轴67%61%55%50%44%销销售售收收入入固固定定时时投投资资净净利利润润率率与与开开发发成成本本增增减减关关系系图图X轴20%15%10%5%0Y轴24%28%33%38%44%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-1581、%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1备注占地面积:89,333.78120600.603容积率:1.35建筑面积:120,600.60土地总价:67,000,000.00含建筑、景82、观、管线等设计土地面积：134土建:900.00其他设计、验线、会审、会评土地单价:500,000.00间接开发成本间接开发成本间接开发成本含建设费、道路等含公建配套前六项之和1.5%建安费、室外工程费的3%住宅建筑面积：120,600.60住宅均价：4,000.00商业建筑面积：-商业均价：-4800460044004200578,882,894.40554,762,773.80530,642,653.20506,522,532.60271,512,510.78271,512,510.78271,512,510.78271,512,510.7863,677,118.3861,023,905.83、1258,370,691.8555,717,478.59243,693,265.23222,226,357.90200,759,450.57179,292,543.2367%61%55%50%325,815,012.94312,239,387.40298,663,761.86285,088,136.32482,402,400.00482,402,400.00482,402,400.00482,402,400.0053,064,264.0053,064,264.0053,064,264.0053,064,264.00103,523,123.06117,098,748.60130,674,374.84、14144,249,999.6824%28%33%38%-5%-10%-15%-20%38%32%26%20%-5%-10%-15%-20%50%57%65%73%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%185、5%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1单位(平方米)单位(平方米)单位(元)单位（亩）单位(元/平方米)单位(元/亩)单位(平方米)单位(元/平方米)单位(平方米)单位(元/平方米)40003800360034003200482,402,412.00458,282,291.40434,162,170.80410,042,050.20385,921,929.60271,512,510.78271,512,510.78271,512,510.78271,512,510.78271,512,510.7853,064,286、65.3250,411,052.0547,757,838.7945,104,625.5242,451,412.26157,825,635.90136,358,728.56114,891,821.2393,424,913.9071,958,006.5644%38%32%26%20%271,512,510.78257,936,885.24244,361,259.70230,785,634.16217,210,008.63482,402,400.00482,402,400.00482,402,400.00482,402,400.00482,402,400.0053,064,264.0053,064,87、264.0053,064,264.0053,064,264.0053,064,264.00157,825,625.22171,401,250.76184,976,876.30198,552,501.84212,128,127.3744%50%57%65%73%韦韦家家湾湾项项目目投投资资成成本本分分析析模模板板序号成本科目单价(元/平方米)总价(元)累计(元)一土地成本土地出让金2,472.2288,999,987.5096,339,987.00市政配套费105.003,780,000.00地契税98.893,559,999.50二前期费用勘查设计费25.00900,000.001,980,088、00.00五通一平25.00900,000.00其他5.00180,000.00三规费设备维修基金0.000.00887,400.00散装水泥1.5054,000.00白蚁防治1.1541,400.00墙改费10.00360,000.00渣土费2.0072,000.00绿地费10.00360,000.00四建安费土建1,050.0037,800,000.0039,960,000.00安装30.001,080,000.00设备15.00540,000.00质检监理10.00360,000.00其他5.00180,000.00五基础设施费室外工程80.002,880,000.005,760,00089、.00绿化环艺50.001,800,000.00小区配套30.001,080,000.00六营销费用120.004,320,000.004,320,000.00七管理费62.192,238,710.812,238,710.81八财务费用35.001,260,000.001,260,000.00九不可预见费35.701,285,200.001,285,200.00十合计4,278.65154,031,297.81154,031,297.81换算为美金$594.26$21,393,235.81$21,393,235.81现现金金流流营营销销策策略略下下的的主主要要财财务务指指标标表表序号指标项目数90、值（元）换算为美金1总销售收入200,700,000.00$27,875,000.002总投资154,031,297.81$21,393,235.813营业税及附加22,077,000.00$3,066,250.004销售利润（毛利）24,591,702.20$3,415,514.195销售利税率23%6投资利税率30%7销售利润率12%8投资利润率16%9销售净利润率9%10投资净利润率12%注注意意：本本模模板板已已经经设设定定了了函函数数关关系系，千千万万不不要要随随意意更更改改格格式式。敏敏感感性性分分析析价格敏感 初始价格（元/pfm）4000调整后价格投资净利润率总销售收入20%491、8000%总投资15%4600-3%营业税及附加10%4400-6%销售利润（毛利）5%4200-9%投资净利润率04000-13%-5%3800-16%-10%3600-19%-15%3400-22%-20%3200-25%成本敏感初始成本154,031,297.81调整后成本投资净利润率总投资20%184,837,557.37-3%总销售收入15%177,135,992.481%营业税及附加10%169,434,427.594%销售利润（毛利）5%161,732,862.708%投资净利润率0154,031,297.8112%-5%146,329,732.9117%-10%138,628,92、168.0222%-15%130,926,603.1327%-20%123,225,038.2434%盈盈亏亏平平衡衡点点分分析析单位税金613.25单位：元/平方米均价平衡点总销售金额/建安费5022.522523单位：元/平方米面积平衡点总成本/均价平衡点30,668.11单位：平方米盈亏平衡率面积平衡点/总建筑面积0.851892081百分数投投资资成成本本固固定定时时投投资资净净利利润润率率与与销销售售收收入入增增减减关关系系图图X轴20%15%10%5%0%Y轴0%-3%-6%-9%-13%销销售售收收入入固固定定时时投投资资净净利利润润率率与与开开发发成成本本增增减减关关系系图图X93、轴20%15%10%5%0Y轴-3%1%4%8%12%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%394、5%系列1备注占地面积:15,000.0036000容积率:2.4建筑面积:36,000.00土地总价:88,999,987.50含建筑、景观、管线等设计土地面积：22.5土建:1,050.00其他设计、验线、会审、会评土地单价:3,955,555.00间接开发成本间接开发成本间接开发成本含建设费、道路等含公建配套前六项之和1.5%建安费、室外工程费的3%住宅建筑面积：27,000.00住宅均价：4,600.00商业建筑面积：8,500.00商业均价：9,000.004800460044004200172,800,000.00165,600,000.00158,400,000.00151,2095、0,000.00154,031,297.81154,031,297.81154,031,297.81154,031,297.8119,008,000.0018,216,000.0017,424,000.0016,632,000.00-239,297.81-6,647,297.81-13,055,297.81-19,463,297.810%-3%-6%-9%184,837,557.37177,135,992.48169,434,427.59161,732,862.70200,700,000.00200,700,000.00200,700,000.00200,700,000.0022,077,0096、0.0022,077,000.0022,077,000.0022,077,000.00-6,214,557.371,487,007.529,188,572.4116,890,137.30-3%1%4%8%-5%-10%-15%-20%-16%-19%-22%-25%-5%-10%-15%-20%17%22%27%34%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-597、%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1单位(平方米)单位(平方米)单位(元)单位（亩）单位(元/平方米)单位(元/亩)单位(平方米)单位(元/平方米)单位(平方米)单位(元/平方米)40003800360034003200144,000,000.00136,800,000.00129,600,000.00122,400,000.00115,200,000.0098、154,031,297.81154,031,297.81154,031,297.81154,031,297.81154,031,297.8115,840,000.0015,048,000.0014,256,000.0013,464,000.0012,672,000.00-25,871,297.81-32,279,297.81-38,687,297.81-45,095,297.81-51,503,297.81-13%-16%-19%-22%-25%154,031,297.81146,329,732.91138,628,168.02130,926,603.13123,225,038.24200,799、00,000.00200,700,000.00200,700,000.00200,700,000.00200,700,000.0022,077,000.0022,077,000.0022,077,000.0022,077,000.0022,077,000.0024,591,702.2032,293,267.0939,994,831.9847,696,396.8755,397,961.7612%17%22%27%34%房地产开发成本土地成本1248.8前期工程费规划设计费25可研费5勘探费5八通一平费25建安工程费建筑工程费1200安装工程费30基础设施费200公共配套设施费110不可预见费35100、房地产开发费用管理费用45销售费用120财务费用453093.8张张许许村村项项目目投投资资成成本本分分析析模模板板序号成本科目单价(元/平方米)总价(元)累计(元)一土地成本土地出让金1,248.7260,600,000.0068,119,629.00市政配套费105.005,095,629.00地契税49.952,424,000.00二前期费用勘查设计费30.001,455,894.002,960,317.80五通一平25.001,213,245.00其他6.00291,178.80三规费设备维修基金0.000.001,196,259.57散装水泥1.5072,794.70白蚁防治1.15101、55,809.27墙改费10.00485,298.00渣土费2.0097,059.60绿地费10.00485,298.00四建安费土建1,000.0048,529,800.0051,732,766.80安装30.001,455,894.00设备20.00970,596.00质检监理10.00485,298.00其他6.00291,178.80五基础设施费室外工程80.003,882,384.009,705,960.00绿化环艺80.003,882,384.00小区配套40.001,941,192.00六营销费用120.005,823,576.005,823,576.00七管理费43.132,0102、93,077.642,093,077.64八财务费用45.002,183,841.002,183,841.00九不可预见费34.381,668,454.521,668,454.52十合计2,997.83145,483,882.33145,483,882.33换算为美金$416.36$20,206,094.77$20,206,094.77现现金金流流营营销销策策略略下下的的主主要要财财务务指指标标表表序号指标项目数值（元）换算为美金1总销售收入192,354,300.00$26,715,875.002总投资145,483,882.33$20,206,094.773营业税及附加21,158,973103、.00$2,938,746.254销售利润（毛利）25,711,444.67$3,571,033.985销售利税率24%6投资利税率32%7销售利润率13%8投资利润率18%9销售净利润率10%10投资净利润率13%注注意意：本本模模板板已已经经设设定定了了函函数数关关系系，千千万万不不要要随随意意更更改改格格式式。敏敏感感性性分分析析价格敏感 初始价格（元/pfm）4000调整后价格投资净利润率总销售收入20%480032%总投资15%460027%营业税及附加10%440023%销售利润（毛利）5%420019%投资净利润率0400014%-5%380010%-10%36005%-15%3104、4001%-20%3200-4%成本敏感初始成本145,483,882.33调整后成本投资净利润率总投资20%174,580,658.80-1%总销售收入15%167,306,464.682%营业税及附加10%160,032,270.565%销售利润（毛利）5%152,758,076.459%投资净利润率0145,483,882.3313%-5%138,209,688.2118%-10%130,935,494.1023%-15%123,661,299.9829%-20%116,387,105.8735%盈盈亏亏平平衡衡点点分分析析单位税金435.999592单位：元/平方米均价平衡点总销售金额105、/建安费3718.229507单位：元/平方米面积平衡点总成本/均价平衡点39,127.19单位：平方米盈亏平衡率面积平衡点/总建筑面积0.806250854百分数投投资资成成本本固固定定时时投投资资净净利利润润率率与与销销售售收收入入增增减减关关系系图图X轴20%15%10%5%0%Y轴32%27%23%19%14%销销售售收收入入固固定定时时投投资资净净利利润润率率与与开开发发成成本本增增减减关关系系图图X轴20%15%10%5%0Y轴-1%2%5%9%13%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%106、0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1备注占地面积:26,961.0048529.8容积率:1.8建筑面积:48,529.80土地总价:60,600,000.00含建筑、景观、管线等设计土地面积：40.4土建:1,107、000.00其他设计、验线、会审、会评土地单价:1,500,000.00间接开发成本间接开发成本间接开发成本含建设费、道路等含公建配套前六项之和1.5%建安费、室外工程费的3%住宅建筑面积：43,529.80住宅均价：3,500.00商业建筑面积：5,000.00商业均价：8,000.004800460044004200232,943,040.00223,237,080.00213,531,120.00203,825,160.00145,483,882.33145,483,882.33145,483,882.33145,483,882.3325,623,734.4024,556,078.802108、3,488,423.2022,420,767.6061,835,423.2753,197,118.8744,558,814.4735,920,510.0732%27%23%19%174,580,658.80167,306,464.68160,032,270.56152,758,076.45192,354,300.00192,354,300.00192,354,300.00192,354,300.0021,158,973.0021,158,973.0021,158,973.0021,158,973.00-3,385,331.803,888,862.3211,163,056.4418,437,25109、0.55-1%2%5%9%-5%-10%-15%-20%10%5%1%-4%-5%-10%-15%-20%18%23%29%35%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列11%-2%-5%-8%-11%-14%-18%-21%-24%25%20%15%10%5%0%-5%-10%-15%-20%-25%-30%-25%-20%-15%-10%-5%0%5%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-110、15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1单位(平方米)单位(平方米)单位(元)单位（亩）单位(元/平方米)单位(元/亩)单位(平方米)单位(元/平方米)单位(平方米)单位(元/平方米)40003800360034003200194,119,200.00184,413,240.00174,707,280.00165,001,320.00155,295,360.00145,483,882.33145,483,882.33145,483,882.33145,483,882.33145,483,882.3321,353,112.0020,285,456.4111、019,217,800.8018,150,145.2017,082,489.6027,282,205.6718,643,901.2710,005,596.871,367,292.47-7,271,011.9314%10%5%1%-4%145,483,882.33138,209,688.21130,935,494.10123,661,299.98116,387,105.87192,354,300.00192,354,300.00192,354,300.00192,354,300.00192,354,300.0021,158,973.0021,158,973.0021,158,973.0021,1112、58,973.0021,158,973.0025,711,444.6732,985,638.7940,259,832.9047,534,027.0254,808,221.1313%18%23%29%35%宏宏泰泰项项目目投投资资成成本本分分析析模模板板序号成本科目单价(元/平方米)总价(元)累计(元)一土地成本土地出让金1,051.69153,360,000.00174,805,815.00市政配套费105.0015,311,415.00地契税42.076,134,400.00二前期费用勘查设计费30.004,374,690.008,895,203.00五通一平25.003,645,575.0113、0其他6.00874,938.00三规费设备维修基金25.003,645,575.007,240,111.95散装水泥1.50218,734.50白蚁防治1.15167,696.45墙改费10.001,458,230.00渣土费2.00291,646.00绿地费10.001,458,230.00四建安费土建1,150.00167,696,450.00181,987,104.00安装45.006,562,035.00设备35.005,103,805.00质检监理10.001,458,230.00其他8.001,166,584.00五基础设施费室外工程120.0017,498,760.0037,9114、13,980.00绿化环艺100.0014,582,300.00小区配套40.005,832,920.00六营销费用120.0017,498,760.0017,498,760.00七管理费44.066,425,114.616,425,114.61八财务费用45.006,562,035.006,562,035.00九不可预见费41.045,984,575.925,984,575.92十合计3,067.50447,312,699.48447,312,699.48换算为美金$426.04$62,126,763.82$62,126,763.82现现金金流流营营销销策策略略下下的的主主要要财财务务指指标115、标表表序号指标项目数值（元）换算为美金1总销售收入701,701,000.00$93,560,133.332总投资447,312,699.48$59,641,693.263营业税及附加77,187,110.00$10,291,614.674销售利润（毛利）177,201,190.52$23,626,825.405销售利税率36%6投资利税率57%7销售利润率25%8投资利润率40%9销售净利润率19%10投资净利润率30%注注意意：本本模模板板已已经经设设定定了了函函数数关关系系，千千万万不不要要随随意意更更改改格格式式。敏敏感感性性分分析析价格敏感 初始价格（元/pfm）5605调整后价格投116、资净利润率总销售收入20%672651%总投资15%6445.7545%营业税及附加10%6165.540%销售利润（毛利）5%5885.2535%投资净利润率0560530%-5%5324.7524%-10%5044.519%-15%4764.2514%-20%44849%成本敏感初始成本447,312,699.48调整后成本投资净利润率总投资20%536,775,239.3812%总销售收入15%514,409,604.4016%营业税及附加10%492,043,969.4320%销售利润（毛利）5%469,678,334.4525%投资净利润率0447,312,699.4830%-5%4117、24,947,064.5135%-10%402,581,429.5341%-15%380,215,794.5648%-20%357,850,159.5856%盈盈亏亏平平衡衡点点分分析析单位税金529.3205461单位：元/平方米均价平衡点总销售金额/建安费3855.773209单位：元/平方米面积平衡点总成本/均价平衡点116,011.15单位：平方米盈亏平衡率面积平衡点/总建筑面积0.795561427百分数投投资资成成本本固固定定时时投投资资净净利利润润率率与与销销售售收收入入增增减减关关系系图图X轴20%15%10%5%0%Y轴51%45%40%35%30%销销售售收收入入固固定定时118、时投投资资净净利利润润率率与与开开发发成成本本增增减减关关系系图图X轴20%15%10%5%0Y轴12%16%20%25%30%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列151%45%40%35%30%24%19%14%9%25%20%15%10%5%0%-5%-10%-15%-20%-25%0%10%20%30%40%50%60%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-1119、0%-5%0%5%10%15%20%25%30%35%系列1备注占地面积:56,800.00145823容积率:2.2建筑面积:145,823.00土地总价:153,360,000.00含建筑、景观、管线等设计土地面积：85.2土建:1,250.00其他设计、验线、会审、会评土地单价:1,800,000.00间接开发成本间接开发成本间接开发成本含建设费、道路等含公建配套前六项之和1.5%建安费、室外工程费的3%住宅建筑面积：114,365.00住宅均价：5,000.00商业建筑面积：10,823.00商业均价：12,000.0067266445.756165.55885.25842,014,4120、88.00806,930,551.00771,846,614.00736,762,677.00447,312,699.48447,312,699.48447,312,699.48447,312,699.4892,621,593.6888,762,360.6184,903,127.5481,043,894.47302,080,194.84270,855,490.91239,630,786.98208,406,083.0551%45%40%35%536,775,239.38514,409,604.40492,043,969.43469,678,334.45701,701,000.00701,701121、,000.00701,701,000.00701,701,000.0077,187,110.0077,187,110.0077,187,110.0077,187,110.0087,738,650.62110,104,285.60132,469,920.57154,835,555.5512%16%20%25%-5%-10%-15%-20%24%19%14%9%-5%-10%-15%-20%35%41%48%56%-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列151122、%45%40%35%30%24%19%14%9%25%20%15%10%5%0%-5%-10%-15%-20%-25%0%10%20%30%40%50%60%系列1-5%-2%1%5%9%13%18%24%30%25%20%15%10%5%0%-5%-10%-15%-20%-25%-10%-5%0%5%10%15%20%25%30%35%系列1单位(平方米)单位(平方米)单位(元)单位（亩）单位(元/平方米)单位(元/亩)单位(平方米)单位(元/平方米)单位(平方米)单位(元/平方米)56055324.755044.54764.254484701,678,740.00666,594,803.0123、0631,510,866.00596,426,929.00561,342,992.00447,312,699.48447,312,699.48447,312,699.48447,312,699.48447,312,699.4877,184,661.4073,325,428.3369,466,195.2665,606,962.1961,747,729.12177,181,379.12145,956,675.19114,731,971.2683,507,267.3352,282,563.4030%24%19%14%9%447,312,699.48424,947,064.51402,581,429.53380,215,794.56357,850,159.58701,701,000.00701,701,000.00701,701,000.00701,701,000.00701,701,000.0077,187,110.0077,187,110.0077,187,110.0077,187,110.0077,187,110.00177,201,190.52199,566,825.49221,932,460.47244,298,095.44266,663,730.4230%35%41%48%56%