14【成本】萬科拿地測算表格

1、項(xiàng)目財(cái)務(wù)現(xiàn)金流量表（資本金現(xiàn)金流量表）,序號,項(xiàng)目,合計(jì),一,投資年限,1,2,3,4,5,6,7,8,9,10,11,12,13,14二,現(xiàn)金流入,72130.11 ,7300.00 ,13853.81 ,11659.47 ,13557.53 ,25759.30 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 1,銷售流入,54230.11 ,0.00 ,3253.81 ,11659.47 ,13557.53 ,25759.30 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.0

2、0 2,經(jīng)營流入,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 3,處置收入,0.00 ,0.00 ,0.00 ,0.00 4,融資流入,17900.00 ,7300.00 ,10600.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 三,現(xiàn)金流出,65176.78 ,24461.60 ,13836.89 ,11623.42 ,11532.42 ,3722.46

3、,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 1.1,開發(fā)成本,33634.65 ,23489.83 ,10144.82 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 1.2,開發(fā)費(fèi)用,8268.99 ,971.77 ,3080.99 ,2259.58 ,1468.58 ,488.07 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 1.3,運(yùn)營費(fèi)用,0.00 ,0.00 ,0

4、.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 1.4,營業(yè)稅及附加,715.84 ,0.00 ,143.17 ,178.96 ,178.96 ,214.75 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 1.5,土地增值稅,2339.52 ,0.00 ,467.90 ,584.88 ,584.88 ,701.86 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 1.6,

5、處置成本,0.00 ,0.00 ,0.00 ,0.00 2,償還本金,17900.00 ,0.00 ,8600.00 ,9300.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 3,所得稅,2317.78 ,0.00 ,0.00 ,0.00 ,0.00 ,2317.78 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 四,稅后凈現(xiàn)金流量,6953.33 ,(17161.60),16.92 ,36.06 ,2025.11 ,22036.85 ,0.00 ,0.

6、00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,累計(jì)稅后凈現(xiàn)金流量,6953.33 ,(17161.60),(17144.68),(17108.62),(15083.51),6953.33 ,6953.33 ,6953.33 ,6953.33 ,6953.33 ,6953.33 ,6953.33 ,6953.33 ,6953.33 ,6953.33 五,折現(xiàn)系數(shù),7%,1.00 ,0.93 ,0.87 ,0.82 ,0.76 ,0.71 ,0.67 ,0.62 ,0.58 ,0.54 ,0.51 ,0.48 ,0.44 ,0.41 ,稅后凈現(xiàn)值,13

7、50.60 ,(17161.60),15.81 ,31.49 ,1653.09 ,16811.80 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,稅后累計(jì)凈現(xiàn)值,1350.60 ,(17161.60),(17145.79),(17114.29),(15461.20),1350.60 ,1350.60 ,1350.60 ,1350.60 ,1350.60 ,1350.60 ,1350.60 ,1350.60 ,1350.60 ,1350.60 六,財(cái)務(wù)內(nèi)部收益率,2%,財(cái)務(wù)凈現(xiàn)值,1350.60 , ,靜態(tài)投資回收期 年,4.68

8、,累計(jì)凈現(xiàn)金流等于或大于項(xiàng)目總投的那一年,動態(tài)投資回收期 年,4.92 ,累計(jì)凈現(xiàn)值等于或大于項(xiàng)目總投的那一年,備注說明：資本金現(xiàn)金流量表中包含融資的流入及流出。,敏感性分析,-20%,-15%,-10%,-5%,0%,5%,10%,15%,20%,銷售產(chǎn)品售價(jià)（元）,水岸家園,14400,15300,16200,17100,18000,18900,19800,20700,21600,-,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,銷售收入(萬元）,43384 ,46096 ,48807 ,51

9、519 ,54230 ,56942 ,59653 ,62365 ,65076 ,自持產(chǎn)品租金（元）,-,0,0,0,0,0,0,0,0,0,-,0,0,0,0,0,0,0,0,0,自持收入（萬元）,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,處置收入（萬元）,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,總收入（萬元）,43384 ,46096 ,48807 ,51519 ,54230 ,56942 ,59653 ,62365 ,65076 ,土地單價(jià)（萬/畝）,349 ,371 ,393 ,415 ,437 ,458 ,480 ,502 ,524 ,土地總價(jià)（萬元）,129

10、39 ,13747 ,14556 ,15365 ,16173 ,16982 ,17791 ,18599 ,19408 ,前期費(fèi)用（萬元）,1660 ,1660 ,1660 ,1660 ,1660 ,1660 ,1660 ,1660 ,1660 ,工程費(fèi)用（萬元）,15049 ,15049 ,15049 ,15049 ,15049 ,15801 ,16554 ,17306 ,18059 ,非工程類物資（萬元）,0,0,0,0,0,0,0,0,0,預(yù)備費(fèi)用,752 ,752 ,752 ,752 ,752 ,790 ,828 ,865 ,903 ,開發(fā)成本總額,17461 ,17461 ,17461

11、 ,17461 ,17461 ,18251 ,19042 ,19832 ,20622 ,銷售費(fèi)用,1302 ,1383 ,1464 ,1546 ,1627 ,1708 ,1790 ,1871 ,1952 ,管理費(fèi)用,501 ,501 ,501 ,501 ,501 ,524 ,546 ,569 ,592 ,財(cái)務(wù)費(fèi)用(建設(shè)期）,3871 ,3710 ,3549 ,3387 ,3226 ,3065 ,2903 ,2742 ,2581 ,開發(fā)費(fèi)用總額,5674 ,5594 ,5514 ,5434 ,5354 ,5297 ,5240 ,5182 ,5125 ,投資總額,36074 ,36803 ,375

12、32 ,38260 ,38989 ,40530 ,42072 ,43613 ,45154 ,土地增值稅,1872 ,1989 ,2106 ,2223 ,2340 ,2456 ,2573 ,2690 ,2807 ,稅金及附加,573 ,608 ,644 ,680 ,716 ,752 ,787 ,823 ,859 ,財(cái)務(wù)費(fèi)用(經(jīng)營期）,3498 ,3352 ,3206 ,3060 ,2915 ,2769 ,2623 ,2477 ,2332 ,經(jīng)營成本,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,處置成本,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,稅金及其它,5942 ,5949 ,5956 ,5963 ,5970 ,5977 ,5984 ,5991 ,5998 ,稅前利潤,1368 ,3344 ,5320 ,7295 ,9271 ,10434 ,11597 ,12761