公寓項目的財務模型分析

附表3,公寓區(qū)月度現(xiàn)金流量表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

序號,項目,合計,1,2,3,4,5,6,7,8,9,10,11,12,小計,13,14,15,16,17,18,19,20,21,22,23,24,小計,25,26,27,28,29,30,31,32,33,34,35,36,小計,36-48

一,土地費用,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

1,土地轉讓費,"25,000",25000,,,,,,,,,,,,"25,000",,,,,,,,,,,,,,,,,,,,,,,,,,,

2,地價款,"6,380",,2552,,,3828,,,,,,,,"6,380",,,,,,,,,,,,,,,,,,,,,,,,,,,

二,前期工程費用,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

1,開辦費用,"1,380",,50,50,50,,50,,,100,,,100,400,,,100,,150,150,150,150,150,150,100,50,"1,150",20,,,,,,,,,,,,20,

2,設計費,"1,380",,315,315,315,315,120,,,,,,,"1,380",,,,,,,,,,,,,0,,,,,,,,,,,,,0,

三,建安費用小計,"41,678",,,,,,,,,,,,,"10,829",,,,,,,,,,,,,"20,191",,,,,,,,,,,,,"10,520",138

1,樁基/基礎,"5,320",,,,,,1064,1064,1064,,,1862,,"5,054",,,,,,,,,266,,,,266,,,,,,,,,,,,,0,

2,地下結構,"4,750",,,,,,,,950,475,475,475,,"2,375",,,2138,,,,,,,,,,"2,138",,,237,,,,,,,,,,237,

3,地上結構,"10,000",,,,,,,,,,2000,,1000,"3,000",,1000,,1000,,,,4500,,,,,"6,500",,,,,,,,500,,,,,500,

4,外立面及裝飾,"2,365",,,,,,,,,,,,,0,,,,,473,237,237,237,,,,1064,"2,248",,,,,,,,,,,,117,117,

5,給排水工程,"2,070",,,,,,,,,,,,,0,,414,,207,,207,,207,,,,932,"1,967",,,,,,,,,,,,103,103,

6,強電工程,"3,450",,,,,,,,,,,,,0,,690,,345,,345,,345,,,,1553,"3,278",,,,,,,,,,,,172,172,

7,弱電工程,"2,760",,,,,,,,,,,,,0,,,552,,276,,276,,276,,,,"1,380",1242,,,,,,,,,,,,"1,242",138

8,扶梯/電梯,"2,000",,,,,,,,,,,400,,400,,,,800,,,,,,,700,,"1,500",,,,,,,,,,,100,,100,

9,室內精裝修,"8,000",,,,,,,,,,,,,,,,,,,,,,,,,,,1000,1500,1500,1500,1500,1000,,,,,,,"8,000",

10,公共區(qū)域精裝修,963,,,,,,,,,,,,,0,,,,193,96,96,96,,,,433,,914,,,,,,,,,,,49,,49,

四,管理費用,"1,895",625,73,9,9,104,31,27,50,14,62,68,28,"1,100",0,53,70,64,25,26,19,136,17,4,31,90,534,57,38,43,38,38,25,0,13,0,0,4,10,264,3

五,不可預見費,"1,554",513,60,7,7,85,25,22,41,12,51,56,23,902,0,43,57,52,20,21,16,111,14,3,25,74,437,46,31,36,31,31,21,0,10,0,0,3,8,216,3

六,總計,"79,267",26138,3050,382,382,4332,1290,1112,2106,601,2588,2862,1150,45990,0,2200,2917,2661,1040,1082,794,5686,723,157,1289,3763,22312,2365,1568,1816,1568,1568,1046,0,523,0,0,156,410,11020,144

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,