地产项目现金流测算表1-曾云墨原创

期数,,,去化率100%总收入/万元,预售面积（㎡/个）,预售单价/元,去化率合计,,,,2013年,,,,2014年,,,,2015年,,,,2016年,,,,2017年,,,,2018年,,,,2019年,,,,2020年,,,,2021年,,,,2022年,,,,2023年,,,,2024年,,,,2025年,,,

,,,,,,四年,三年,两年,一年,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q,1Q,2Q,3Q,4Q

第1期,进度,普通住宅,"372,772.05","355,021.00","10,500",,100%,77%,43%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,18%,9%,11%,5%,10%,10%,9%,5%,8%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,372772.05,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,67099,33549,41005,18639,37277,37277,33549,18639,29822,18639,18639,18639,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,公寓,"188,404.70","171,277.00","11,000",100%,95%,75%,46%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,16%,10%,11%,9%,11%,6%,6%,6%,5%,5%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,188404.70,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30145,18840,20725,16956,20725,11304,11304,11304,9420,9420,9420,9420,9420,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,保障房,0.00,0.00,,,,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,办公,0.00,0.00,,,,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,底商,"44,569.40","19,378.00","23,000",100%,90%,69%,39%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,15%,10%,8%,6%,10%,10%,5%,5%,5%,6%,5%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,44569.40,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,6685,4457,3566,2674,4457,4457,2228,2228,2228,2674,2228,2228,2228,2228,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,集中商业,"19,062.00","12,708.00","15,000",100%,90%,69%,38%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,15%,10%,8%,5%,10%,10%,6%,5%,5%,6%,5%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,19062.00,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2859,1906,1525,953,1906,1906,1144,953,953,1144,953,953,953,953,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,可售车位/个,"166,368.21","11,091.21","150,000",81%,61%,32%,6%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,1%,1%,2%,3%,3%,5%,9%,9%,9%,7%,7%,6%,5%,5%,5%,5%,4%,3%,2%,2%,1%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,153000.00,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1500,1500,3000,4500,4500,7500,15000,15000,15000,12000,12000,10500,9000,7500,9000,7500,6000,4500,3000,3000,1500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

第2期,进度,普通住宅,"106,033.45","92,203.00","11,500",,100%,82%,45%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,20%,9%,11%,5%,10%,10%,9%,8%,5%,5%,5%,3%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,"106,033.45",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,21207,9543,11664,5302,10603,10603,9543,8483,5302,5302,5302,3181,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,公寓,"129,513.60","107,928.00","12,000",,100%,76%,44%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,15%,10%,10%,9%,10%,6%,8%,8%,8%,6%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,"129,513.60",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19427,12951,12951,11656,12951,7771,10361,10361,10361,7771,6476,6476,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,保障房,0.00,0.00,,,,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,办公,0.00,0.00,,,,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,底商,"12,240.20","4,996.00","24,500",100%,85%,63%,33%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,15%,8%,5%,5%,10%,10%,5%,5%,6%,6%,5%,5%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,"12,240.20",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1836,979,612,612,1224,1224,612,612,734,734,612,612,612,612,612,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,集中商业,"51,201.60","32,001.00","16,000",100%,85%,63%,33%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,15%,8%,5%,5%,10%,10%,5%,5%,6%,6%,5%,5%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,"51,201.60",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7680,4096,2560,2560,5120,5120,2560,2560,3072,3072,2560,2560,2560,2560,2560,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,可售车位/个,"65,247.86","4,349.86","150,000",67%,61%,32%,6%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,1%,1%,2%,3%,3%,5%,9%,9%,9%,7%,7%,6%,5%,5%,5%,5%,4%,3%,2%,2%,1%,0%,0%,0%,0%,0%,0%,0%,0%

,,,"60,004.98",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,588,588,1177,1765,1765,2941,5883,5883,5883,4706,4706,4118,3530,2941,3530,2941,2353,1765,1177,1177,588,0,0,0,0,0,0,0,0

第3期,进度,普通住宅,0.00,0.00,"5,304",,,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,公寓,"245,700.00","189,000.00","13,000",100%,90%,69%,33%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,15%,8%,5%,5%,10%,10%,5%,5%,6%,6%,5%,5%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,"245,700.00",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,36855,19656,12285,12285,24570,24570,12285,12285,14742,14742,12285,12285,12285,12285,12285,0,0,0,0,0,0,0,0,0,0,0

,,保障房,0.00,0.00,,,,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,办公,0.00,0.00,"10,000",,,0%,,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,底商,"12,575.00","5,000.00","25,150",100%,90%,69%,33%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,15%,8%,5%,5%,10%,10%,5%,5%,6%,6%,5%,5%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,"12,575.00",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1886,1006,629,629,1258,1258,629,629,755,755,629,629,629,629,629,0,0,0,0,0,0,0,0,0,0,0

,,集中商业,"126,650.00","74,500.00","17,000",100%,75%,63%,33%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,15%,8%,5%,5%,10%,10%,5%,5%,6%,6%,5%,5%,5%,5%,5%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,"126,650.00",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18998,10132,6333,6333,12665,12665,6333,6333,7599,7599,6333,6333,6333,6333,6333,0,0,0,0,0,0,0,0,0,0,0

,,可售车位/个,"41,235.00","2,749.00","150,000",81%,61%,32%,6%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,1%,1%,2%,3%,3%,5%,9%,9%,9%,7%,7%,6%,5%,5%,5%,5%,4%,3%,2%,2%,0%,0%,0%,0%

,,,"37,549.86",,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,372,372,744,1115,1115,1859,3718,3718,3718,2974,2974,2602,2231,1859,2231,1859,1487,1115,744,744,0,0,0,0

合计,,普通住宅,"478,805.50","447,224",1.0706,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,"67,099","33,549","41,005","18,639","37,277","37,277","33,549","18,639","51,028","28,182","30,302","23,940","10,603","10,603","9,543","8,483","5,302","5,302","5,302","3,181",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,公寓,"563,618.30","468,205",1.2038,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"30,145","18,840","20,725","16,956","20,725","11,304","30,731","24,256","22,372","21,076","22,372","54,046","39,437","22,646","22,646","32,341","31,046","18,761","12,285","14,742","14,742","12,285","12,285","12,285","12,285","12,285",0,0,0,0,0,0,0,0,0,0,0

,,保障房,-,-,#DIV/0!,,,,,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-

,,办公,-,-,#DIV/0!,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,底商,"69,384.60","29,374",2.3621,,,,,-,-,-,-,-,-,-,-,-,-,-,-,-,"6,685.41","4,456.94","3,565.55","2,674.16","4,456.94","4,456.94","2,228.47","2,228.47","4,064.50","3,653.38","2,840.48","2,840.48","3,452.49","5,338.74","1,618.01","1,240.76","1,363.16","1,991.91","1,869.51","1,240.76","1,240.76","1,366.51","1,366.51",628.75,628.75,628.75,628.75,628.75,-,-,-,-,-,-,-,-,-,-,-

,,集中商业,"196,913.60","119,209",1.6518,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2,859","1,906","1,525",953,"1,906","1,906","8,824","5,049","3,513","3,704","6,073","25,071","13,645","9,846","9,405","15,737","15,225","8,893","8,893","10,159","10,159","6,333","6,333","6,333","6,333","6,333",0,0,0,0,0,0,0,0,0,0,0

,,可售车位/个,"272,851.07","18,190",15.0000,,,,,-,-,-,-,-