ImageVerifierCode 换一换
格式:XLS , 页数:13 ,大小:104.50KB ,
资源ID:2977894      下载积分:1 金币
快捷下载
登录下载
邮箱/手机:
温馨提示:
快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。 如填写123,账号就是123,密码也是123。
特别说明:
请自助下载,系统不会自动发送文件的哦; 如果您已付费,想二次下载,请登录后访问:我的下载记录
支付方式: 支付宝    微信支付   
验证码:   换一换

加入VIP,免费下载
 

温馨提示:由于个人手机设置不同,如果发现不能下载,请复制以下地址【https://www.bingdoc.com/d-2977894.html】到电脑端继续下载(重复下载不扣费)。

已注册用户请登录:
账号:
密码:
验证码:   换一换
  忘记密码?
三方登录: 微信登录   QQ登录  

下载须知

1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。
2: 试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。
3: 文件的所有权益归上传用户所有。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 本站仅提供交流平台,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

版权提示 | 免责声明

本文(房地产项目投资估算及财务分析(模板)表格文件下载.xls)为本站会员(wj)主动上传,冰点文库仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知冰点文库(发送邮件至service@bingdoc.com或直接QQ联系客服),我们立即给予删除!

房地产项目投资估算及财务分析(模板)表格文件下载.xls

1、投投资资计计划划表表单位:万元序号 项目名称投资总额第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第6 6季季第第7 7季季第第8 8季季第第9季季一土地成本28979.9728979.97二前期费用1884.44376.89376.89376.89376.89三基础工程费2422.85575.43575.43575.43四主体工程费20190.412271.422523.802271.422523.80五水电安装2692.05302.86336.51302.86336.51六消防工程1615.23181.71201.90181.71201.90七电梯工程2153.64242

2、.28269.21242.28269.21八通迅工程403.8145.4350.4845.4350.48九煤气工程538.4160.5767.3060.5767.30十对讲系统403.8145.4350.4845.4350.48十一 公用天线134.6015.1416.8315.1416.83十二 室外配套4307.29484.57538.41484.57538.41十三 不可预见费1837.33122.49122.49122.49122.49122.49122.49122.49122.49122.49十四 管理费1102.4073.4973.4973.4973.4973.4973.4973.

3、4973.4973.49十五 其他费用820.81234.52234.5227.0627.0627.0627.0627.0627.0627.06十六 合计69487.0429787.35807.39798.472494.464501.732329.572494.464501.732329.57注:1.土地成本按计算初期一次性投入计。2.按照通常情况,工程费用中5%留取保修金及滞留金,竣工验收后一年付出。3.工程款的支付与工程进度表相对应,不考虑工程队大额垫资,按工程进度付款,竣工验收后支付率达95%,其它部分在工程建设过程中平均投入。投投资资计计划划表表(续续表表)单位:万元第第10季季第第1

4、111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季376.8930.29575.4330.2930.2930.292523.802523.802523.802523.80252.38252.3833.65302.86336.5133.65302.86336.5133.6533.6520.19181.71201.9020.19181.71201.9020.1920.1926.92242.28269.2126.92242.28269.2126.9226.925.0545.4350.485.0545.4350.485.055

5、.056.7360.5767.306.7360.5767.306.736.735.0545.4350.485.0545.4350.485.055.051.6815.1416.831.6815.1416.831.681.6853.84484.57538.4153.84484.57538.4153.8453.84122.49122.49122.49122.49122.49122.4973.4973.4973.4973.4973.4973.4927.0627.0627.0627.0627.0627.062930.244501.732329.572930.244124.841754.15435.784

6、35.78附附表表3:序号 项目名称一土地成本二前期费用三基础工程费四主体工程费五水电安装六消防工程七电梯工程八通迅工程九煤气工程十对讲系统十一 公用天线十二 室外配套十三 不可预见费十四 管理费十五 其他费用十六 合计附附表表4:项项目目销销售售回回款款计计划划表表项目内容销销售售建建筑筑面面积积(m2)销销售售价价格格(元元/m2)总总价价(万万元元)备备注注住宅215364.463,30071,070.27商业53841.0010,00053,841.00合计269205.46124,911.27住宅销售率95%商铺销售率100%销售收入121,357.76计算期(季度)销销售售比比例例

7、回回款款比比例例回回款款金金额额合合计计住住宅宅商商业业住住宅宅商商业业住住宅宅商商业业123455.00%3.33%2,369.012,369.0167.50%6.67%4,738.024,738.0277.50%10.00%7.50%6.67%5,330.273,589.408,919.6787.50%10.00%7.50%10.00%5,330.275,384.1010,714.3798.75%10.00%8.33%10.00%5,922.525,384.1011,306.62107.50%10.00%7.92%10.00%5,626.405,384.1011,010.50117.50%

8、10.00%7.50%10.00%5,330.275,384.1010,714.37128.75%10.00%8.33%10.00%5,922.525,384.1011,306.62137.50%10.00%7.92%10.00%5,626.405,384.1011,010.50147.50%10.00%7.50%10.00%5,330.275,384.1010,714.37158.75%10.00%8.33%10.00%5,922.525,384.1011,306.62167.50%10.00%7.92%10.00%5,626.405,384.1011,010.50172.50%4.17%3

9、.33%2,961.261,794.704,755.96181.25%1.67%1,184.501,184.50190.42%296.13296.13合计95.00%100%95.00%100%67,516.7653,841.00121,357.76注:剩余5%住宅作为企业留存资产,销售回款计划综合考虑银行按揭放款时间。附附表表5:资资金金来来源源与与运运用用表表单位:万元序序号号 季季度度项项目目1 12 23 34 45 56 67 78 89 9一资金来源30,000.001,000.00900.002,300.004,369.014,738.028,919.6710,714.3719,

10、306.621经营活动产生的现金来源2,369.014,738.028,919.6710,714.3711,306.621.1销售收入2,369.014,738.028,919.6710,714.3711,306.622 筹资活动产生的现金来源30,000.001,000.00900.001,300.001,000.005,000.002.1自有资金1,000.001,000.00900.001,300.001,000.005,000.002.2银行借款29,000.003其它来源1,000.001,000.003,000.00二资金运用30,225.221,245.261,236.342,9

11、32.335,131.493,151.224,027.866,298.5322,332.941建设期开发成本29,787.35807.39798.472,494.464,501.732,329.572,494.464,501.732,329.572经营期当期发生营业成本3销售费用71.07142.14267.59321.43339.204销售税费120.82241.64454.90546.43576.645所得税373.03491.07587.536盈余公积7应付利润8借款本金偿还18,500.009借款利息支付437.87437.87437.87437.87437.87437.87437.8

12、7437.87三盈余资金-225.22-245.26-336.34-632.33-762.481,586.794,891.814,415.84-3,026.31四累计盈余资金-225.22-470.48-806.82-1,439.15-2,201.63-614.844,276.988,692.825,666.50101011,010.5011,010.5011,010.504,394.232,930.24330.31561.54572.146,616.2712,282.77附附表表5:序序号号 季季度度项项目目一资金来源1经营活动产生的现金来源1.1销售收入2 筹资活动产生的现金来源2.1自有

13、资金2.2银行借款3其它来源二资金运用1建设期开发成本2经营期当期发生营业成本3销售费用4销售税费5所得税6盈余公积7应付利润8借款本金偿还9借款利息支付三盈余资金四累计盈余资金资资金金来来源源与与运运用用表表(续续表表)单位:万元11111212131314141515161617171818191910,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.1310,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.5029

14、6.1310,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.135,926.343,832.944,394.235,549.453,257.511,899.76632.37157.50475.154,501.732,329.572,930.244,124.841,754.15435.78435.78321.43339.20330.31321.43339.20330.31142.6835.548.88546.43576.64561.54546.43576.64561.54242.5560.4115.1

15、0556.75587.53572.14556.75587.53572.14247.1361.5515.394,788.037,473.696,616.275,164.928,049.119,110.734,123.591,027.01-179.0217,070.8024,544.4931,160.7636,325.6844,374.7953,485.5257,609.1258,636.1358,457.10附附表表5:序序号号 季季度度项项目目一资金来源1经营活动产生的现金来源1.1销售收入2 筹资活动产生的现金来源2.1自有资金2.2银行借款3其它来源二资金运用1建设期开发成本2经营期当期发

16、生营业成本3销售费用4销售税费5所得税6盈余公积7应付利润8借款本金偿还9借款利息支付三盈余资金四累计盈余资金附附表表6:损损益益及及利利润润表表单位:万元序序号号项项目目合合计计第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第6 6季季第第7 7季季第第8 8季季第第9季季1销售收入121,357.762,369.014,738.028,919.67 10,714.37 11,306.622开发成本69,487.041,356.452,712.905,107.236,134.846,473.953销售费用3,640.7371.07142.14267.59321.43339.

17、204财务费用3,502.97437.87437.87437.87437.87437.87437.87437.87437.870.005销售税费6,189.25120.82241.64454.90546.43576.646利润总额38,537.77-437.87-437.87-437.87-437.87382.801,203.472,652.083,273.803,916.847补前期亏损382.801,203.47165.218所得税5,780.670.00373.03491.07587.539税后利润32,757.10-437.87-437.87-437.87-437.870.000.00

18、2,113.842,782.733,329.31成本利润率42.7%损损益益及及利利润润表表(续续表表)单位:万元第第10季季第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季11,010.50 10,714.37 11,306.62 11,010.50 10,714.37 11,306.62 11,010.504,755.961,184.50296.136,304.396,134.846,473.956,304.396,134.846,473.956,304.392,723.17678.22169.56330.

19、31321.43339.20330.31321.43339.20330.31142.6835.548.880.000.000.000.000.000.000.00561.54546.43576.64561.54546.43576.64561.54242.5560.4115.103,814.253,711.673,916.843,814.253,711.673,916.843,814.251,647.56410.34102.58572.14556.75587.53572.14556.75587.53572.14247.1361.5515.393,242.123,154.923,329.313,2

20、42.123,154.923,329.313,242.121,400.43348.7987.20附附表表6:序序号号项项目目1销售收入2开发成本3销售费用4财务费用5销售税费6利润总额7补前期亏损8所得税9税后利润附附表表7:现现金金流流量量表表(全全部部投投资资)单位:万元序序号号 季季度度项项目目合合计计1234567891现金流入121,357.762,369.014,738.028,919.6710,714.3711,306.621.1销售收入121,357.762,369.014,738.028,919.6710,714.3711,306.621.2出租收入1.3 其他收入2现金流出

21、85,097.6929,787.35807.39798.472,494.464,693.622,713.353,589.995,860.663,832.942.1建设期开发成本69,487.0429,787.35807.39798.472,494.464,501.732,329.572,494.464,501.732,329.572.2经营期当期成本2.3销售费用3,640.7371.07142.14267.59321.43339.202.4销售税费6,189.25120.82241.64454.90546.43576.642.5所得税5,780.67373.03491.07587.533净现

22、金流量36,260.07-29,787.35-807.39-798.47-2,494.46-2,324.612,024.665,329.684,853.717,473.694累计净现金流量-29,787.35-30,594.74-31,393.21-33,887.67-36,212.28-34,187.61-28,857.93-24,004.21-16,530.535净现值22,839.10-29,787.35-792.00-768.33-2,354.56-2,152.411,838.964,748.604,242.116,407.486累计净现值-29,787.35-30,579.35-31

23、,347.68-33,702.24-35,854.65-34,015.68-29,267.08-25,024.97-18,617.49计算指标:财务内部收益率=31.19%财务净现值(I=8%)=22,839动态投资回收期(年)=3.75现现金金流流量量表表(全全部部投投资资)(续续表表)单位:万元1011121314151617181911,010.5010,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.1311,010.5010,714.3711,306.6211,010.5010,714.37

24、11,306.6211,010.504,755.961,184.50296.134,394.235,926.343,832.944,394.235,549.453,257.511,899.76632.37157.50475.152,930.244,501.732,329.572,930.244,124.841,754.15435.78435.78330.31321.43339.20330.31321.43339.20330.31142.6835.548.88561.54546.43576.64561.54546.43576.64561.54242.5560.4115.10572.14556.7

25、5587.53572.14556.75587.53572.14247.1361.5515.396,616.274,788.037,473.696,616.275,164.928,049.119,110.734,123.591,027.01-179.02-9,914.26-5,126.232,347.468,963.7314,128.6522,177.7631,288.4935,412.0936,439.0936,260.075,564.293,950.006,048.115,252.214,021.956,148.446,826.753,030.97740.50-126.62-13,053.2

26、0-9,103.19-3,055.082,197.126,219.0712,367.5119,194.2622,225.2322,965.7222,839.10附附表表7:序序号号 季季度度项项目目1现金流入1.1销售收入1.2出租收入1.3 其他收入2现金流出2.1建设期开发成本2.2经营期当期成本2.3销售费用2.4销售税费2.5所得税3净现金流量4累计净现金流量5净现值6累计净现值附附表表8:敏敏感感性性分分析析表表因因素素变变化化情情况况相相关关指指标标变变化化情情况况敏敏感感性性分分析析结结果果总总建建筑筑面面积积(m2)销销售售价价格格(元元/m2)销销售售收收入入(万万元元)总总

27、投投资资(万万元元)税税后后利利润润(万万元元)投投资资利利润润率率财财务务净净现现值值(万万元元)内内部部收收益益率率动动态态投投资资回回收收期期(年年)基基本本方方案案(容容积积率率=4.18)269,205269,205住住宅宅33003300121,358121,35876,63176,63132,75732,75742.7%42.7%22,83922,83931.19%31.19%3.753.75商商业业1000010000销售价格变化价价格格下下降降10%10%220,000住宅2970297068,07655,9707,33913.10%3,33313.57%3.94商业90009000价价格格上上升升10%10%220,000住宅3630363083,20556,42419,15734.00%13,03528.57%3.28商业1100011000工程造价变化工工程程造造价价增增加加10%10%220,000住宅330075,64159,51810,42517.50%5,74317.22%3.81商业10000工工程程造造价价减减少少10%10%220,000住宅330075,64152,87616,07130.40%10,62525.39%3.46商业10000

copyright@ 2008-2023 冰点文库 网站版权所有

经营许可证编号:鄂ICP备19020893号-2