參考模板_集團(tuán)財務(wù)預(yù)算模型

1、金金地地集集團(tuán)團(tuán)預(yù)預(yù)算算管管理理編編制制模模型型編編制制單單位位：深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司預(yù)預(yù)算算期期：編編制制日日期期：2009年2月25日預(yù)預(yù)算算管管理理編編制制模模型型財財務(wù)務(wù)預(yù)預(yù)算算項項目目收收入入預(yù)預(yù)算算項項目目成成本本預(yù)預(yù)算算資資金金收收支支預(yù)預(yù)算算日日常常管管理理預(yù)預(yù)算算全全面面預(yù)預(yù)算算表表樣樣索索引引編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司預(yù)預(yù)算算期期：18991899年年1212月月編編制制日日期期：預(yù)預(yù)算算類類型型預(yù)預(yù)算算表表樣樣名名稱稱科科目目編編碼碼F F 財財務(wù)務(wù)預(yù)預(yù)算算F2預(yù)計利潤表P/LF4稅金及附加

2、預(yù)算221/229C C資資金金收收支支預(yù)預(yù)算算C1資金收支預(yù)算 101C2借款預(yù)算201/241C4財務(wù)費用預(yù)算 522R R 項項目目收收入入預(yù)預(yù)算算R1主營業(yè)務(wù)收入預(yù)算 501R2開發(fā)產(chǎn)品銷售預(yù)測501R4其他業(yè)務(wù)收支預(yù)算511/512PUDPUD 項項目目成成本本預(yù)預(yù)算算PUD3項目開發(fā)面積預(yù)測表PUD4主營業(yè)務(wù)成本預(yù)算502PUD7開發(fā)成本預(yù)算匯總表401PUD8土地征用、拆遷補償費及出讓金預(yù)算40101PUD9前期工程費預(yù)算40102PUD10基礎(chǔ)設(shè)施配套費預(yù)算40103PUD11建筑安裝工程費預(yù)算40104PUD12公共配套設(shè)施費預(yù)算40105PUD13工程物資(甲供材料)預(yù)算4

3、0106PUD14開發(fā)間接費用預(yù)算匯總40107匯總PUD15開發(fā)間接費用部門預(yù)算40107部門PUD16部門開發(fā)間接費用預(yù)算編報說明40107編報說明PUD17出租產(chǎn)品經(jīng)營成本預(yù)算50202PUD18材料設(shè)備采購及領(lǐng)用預(yù)算124/125PUD19材料設(shè)備采購計劃124/125M M日日常常管管理理預(yù)預(yù)算算M1銷售費用預(yù)算 503M3廣告及展覽計劃503M4管理費用預(yù)算匯總 521匯總M5部門管理費用預(yù)算 521部門M7固定資產(chǎn)預(yù)算 151M8折舊費用預(yù)算 155M9固定資產(chǎn)購置及處置計劃 151M10薪酬福利預(yù)算 211M11用人需求計劃 211# 標(biāo)識黃色的單元格為不可以修改，有*號的單元

4、格無須填列2預(yù)預(yù)計計利利潤潤表表表表格格編編號號：F2編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司編編制制部部門門: : 財財務(wù)務(wù)部部業(yè)業(yè)務(wù)務(wù)類類型型科科目目編編碼碼上上年年實實際際數(shù)數(shù)據(jù)據(jù)預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)20092009年年度度一一、主主營營業(yè)業(yè)務(wù)務(wù)收收入入501501-211,200,000 減：主營業(yè)務(wù)成本502-100,940,000 減：主營業(yè)務(wù)稅金及附加504-11,616,000二二、主主營營業(yè)業(yè)務(wù)務(wù)利利潤潤-98,644,000 加：其他業(yè)務(wù)利潤511/512- 減：銷售費用503-16,552,400 減：管理費用521205,0009

5、,100,600 減：財務(wù)費用522-三三、營營業(yè)業(yè)利利潤潤(205,000)72,991,000 加：投資收益531 加：補貼收入 加：營業(yè)外收入541 減：營業(yè)外支出542四四、利利潤潤總總額額(205,000)72,991,000 減：所得稅-#REF! 少數(shù)股東損益五五、凈凈利利潤潤(205,000)#REF!編制人：編制日期：部門負(fù)責(zé)人：4稅稅金金及及附附加加預(yù)預(yù)算算表表格格編編號號：F4營業(yè)稅稅率5.00%編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司城建稅稅率7.00%編編制制部部門門: : 財財務(wù)務(wù)部部教育費附加費率3.00%所得稅預(yù)繳比例4.95

6、%所得稅稅率33.00%堤圍防洪費率增值稅稅率4.00%工程營業(yè)稅稅率3.00%業(yè)業(yè)務(wù)務(wù)類類型型科科目目編編碼碼上上年年實實際際數(shù)數(shù)據(jù)據(jù)預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)20092009年年度度計計算算依依據(jù)據(jù)*本期收到預(yù)收款*-3,500,000主營業(yè)務(wù)收入*-211,200,000-現(xiàn)金確認(rèn)收入*-109,900,000-應(yīng)收確認(rèn)收入*-97,830,000-預(yù)收結(jié)轉(zhuǎn)收入*-3,470,000其他業(yè)務(wù)收入(不包含材料銷售)*-計計入入損損益益*所得稅#REF!主營業(yè)務(wù)稅金及附加50311,616,000其他業(yè)務(wù)支出-稅金512-應(yīng)應(yīng)交交稅稅金金*營業(yè)稅期初余額22101-本期計提2210110,56

7、1,500本期支付22101#REF!期末余額22101-#REF!增值稅期初余額22101-本期計提22101-本期支付22101期末余額22101-城建稅期初余額22102-本期計提22102753,585本期支付22102#REF!期末余額22102-#REF!土地增值稅期初余額221031,134,400本期計提221031,134,4004,224,600本期支付22103#REF!期末余額221031,134,400#REF!所得稅期初余額221045,803,956本期計提221045,803,956#REF!本期支付22104#REF!期末余額221045,803,956#RE

8、F!個人所得稅期初余額22105-本期計提22105#REF!本期支付22105#REF!期末余額22105-#REF!應(yīng)交代扣工程營業(yè)稅及附加期初余額22109-本期計提22109204,000本期支付22109#REF!期末余額22109-#REF!應(yīng)應(yīng)交交稅稅金金期期初初余余額額221221-6,938,356本本期期計計提提2212216,938,356#REF!本本期期支支付付221221-#REF!期期末末余余額額2212216,938,356#REF!貸貸：其其他他應(yīng)應(yīng)交交款款*教育費附加期初余額22901-本期計提22901322,965本期支付22901#REF!期末余額22

9、901-#REF!堤圍防洪費期初余額22904-本期計提22904-本期支付22904期末余額22904-現(xiàn)現(xiàn)金金流流量量*現(xiàn)金支付稅金*-#REF!編報說明：1、本表填報依據(jù)為項目收入預(yù)算主營業(yè)務(wù)收入預(yù)算、應(yīng)收及預(yù)收賬款預(yù)算。2、本表為財務(wù)預(yù)算預(yù)計利潤表、資金預(yù)算資金收支預(yù)算提供依據(jù)。3、在本預(yù)算中，遞延稅款主要是指按預(yù)收賬款計算的應(yīng)交稅金，主要包含營業(yè)稅、城建稅、教育費附加、堤圍防洪費以及預(yù)繳所得稅。4、在本預(yù)算中，營業(yè)稅金及附加包括營業(yè)稅、城建稅、教育費附加、堤圍防洪費等,相關(guān)適用稅率在表頭輸入。5、在本預(yù)算中，城鎮(zhèn)土地使用稅、印花稅、車船使用稅視同本期計提本期支付，在管理費用直接列示，

10、不在此列示。6、在本預(yù)算中，代扣工程營業(yè)稅為工程領(lǐng)用的甲供材料設(shè)備所對應(yīng)的營業(yè)稅金及附加。編制人：編制日期：部門負(fù)責(zé)人：5主主營營業(yè)業(yè)務(wù)務(wù)收收入入預(yù)預(yù)算算表表格格編編號號：R1R1編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司預(yù)算日期：1899年12月編編制制部部門門: : 市市場場部部、財財務(wù)務(wù)部部金額單位：人民幣元業(yè)業(yè)務(wù)務(wù)類類型型科科目目編編碼碼工工程程項項目目進(jìn)進(jìn)度度備備注注編編制制說說明明以以前前年年度度累累計計發(fā)發(fā)生生上上年年實實際際數(shù)數(shù)據(jù)據(jù)預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)一一月月二二月月三三月月一一季季度度四四月月五五月月六六月月二二季季度度七七月月八八月月九

11、九月月三三季季度度十十月月十十一一月月十十二二月月四四季季度度以以后后年年度度預(yù)預(yù)算算開開發(fā)發(fā)產(chǎn)產(chǎn)品品銷銷售售收收入入5010150101- - -2 20 01 1, ,2 20 00 0, ,0 00 00 01 12 2, ,8 80 00 0, ,0 00 00 02 26 6, ,0 00 00 0, ,0 00 00 01 12 2, ,8 80 00 0, ,0 00 00 05 51 1, ,6 60 00 0, ,0 00 00 01 12 2, ,8 80 00 0, ,0 00 00 02 26 6, ,0 00 00 0, ,0 00 00 01 12 2, ,8 80

12、 00 0, ,0 00 00 05 51 1, ,6 60 00 0, ,0 00 00 01 13 3, ,6 60 00 0, ,0 00 00 01 13 3, ,6 60 00 0, ,0 00 00 01 13 3, ,6 60 00 0, ,0 00 00 04 40 0, ,8 80 00 0, ,0 00 00 02 28 8, ,8 80 00 0, ,0 00 00 01 14 4, ,2 20 00 0, ,0 00 00 01 14 4, ,2 20 00 0, ,0 00 00 05 57 7, ,2 20 00 0, ,0 00 00 0- -轉(zhuǎn)讓、銷售商品房，在

13、商品房已經(jīng)移交，已將發(fā)票結(jié)算賬單提交買主時，作為銷售實現(xiàn)；對采取分期收款銷售辦法的，可按合同規(guī)定的收款時間分次轉(zhuǎn)入收入獨立別墅5010101-131,800,0008,000,00018,000,0008,000,00034,000,0008,000,00018,000,0008,000,00034,000,0008,800,0008,800,0008,800,00026,400,00019,800,0008,800,0008,800,00037,400,000-聯(lián)排別墅5010102-洋房5010103-豪華莊園5010104-莊園5010105-商鋪5010106-69,400,0004,

14、800,0008,000,0004,800,00017,600,0004,800,0008,000,0004,800,00017,600,0004,800,0004,800,0004,800,00014,400,0009,000,0005,400,0005,400,00019,800,000-賣場5010107-車位5010108-其他5010199-出出租租產(chǎn)產(chǎn)品品租租金金收收入入5010250102- - -1 10 0, ,0 00 00 0, ,0 00 00 0- - -1 1, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 01 1

15、, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 03 3, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 03 3, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 01 1, ,0 00 00 0, ,0 00 00 03 3, ,

16、0 00 00 0, ,0 00 00 0- -在出租合同(或協(xié)議)規(guī)定日期收取租金后作為收入實現(xiàn)；合同規(guī)定的收款日期已到，租用方未付租金的，仍應(yīng)視為經(jīng)營收入實現(xiàn)。商品房5010201商鋪501020210,000,0001,000,0001,000,0001,000,0001,000,0001,000,0003,000,0001,000,0001,000,0001,000,0003,000,0001,000,0001,000,0001,000,0003,000,000賣場5010203經(jīng)營場所(會所、網(wǎng)球場)5010204場地出租5010205其他5010299代代建建工工程程結(jié)結(jié)算算收收入

17、入50103代建的房屋和工程，應(yīng)在房屋和工程竣工驗收，辦妥財產(chǎn)交接手續(xù)，并已將代建的房屋和工程的工程價款結(jié)算賬單提交委托單位時，作為銷售實現(xiàn)配配套套設(shè)設(shè)施施銷銷售售收收入入 50104同商品房銷售收入確認(rèn)原則土土地地轉(zhuǎn)轉(zhuǎn)讓讓收收入入50105轉(zhuǎn)讓、銷售土地，應(yīng)在土地已經(jīng)移交，已將發(fā)票結(jié)算賬單提交買主時，作為銷售實現(xiàn)；對采取分期收款銷售辦法的，可按合同規(guī)定的收款時間分次轉(zhuǎn)入收入改改造造工工程程收收入入50106按客戶要求進(jìn)行工程改造，并結(jié)轉(zhuǎn)收入物物業(yè)業(yè)收收入入50106物業(yè)管理收入5010601物業(yè)經(jīng)營收入5010602其其他他收收入入50199主主營營業(yè)業(yè)務(wù)務(wù)收收入入合合計計A=B+C+D-2

18、11,200,00012,800,00026,000,00013,800,00052,600,00013,800,00027,000,00013,800,00054,600,00014,600,00014,600,00014,600,00043,800,00029,800,00015,200,00015,200,00060,200,000-A=B+C+D現(xiàn)款結(jié)算確認(rèn)收入B109,900,0006,240,00013,200,0007,240,00026,680,0007,240,00014,200,0007,240,00028,680,0007,720,0007,720,0007,720,00

19、023,160,00015,580,0007,900,0007,900,00031,380,000B: 本期收款本期確認(rèn)收入應(yīng)收房款確認(rèn)收入C97,830,0006,320,00012,400,0006,320,00025,040,0006,320,00012,400,0006,320,00025,040,0006,640,0006,640,0006,640,00019,920,00013,770,0007,030,0007,030,00027,830,000C: 確認(rèn)收入，但款項尚未收回(應(yīng)收賬款借方)預(yù)收房款結(jié)轉(zhuǎn)收入D3,470,000240,000400,000240,000880,00

20、0240,000400,000240,000880,000240,000240,000240,000720,000450,000270,000270,000990,000D: 以預(yù)收款結(jié)轉(zhuǎn)收入(預(yù)收賬款貸方)現(xiàn)現(xiàn)金金回回款款預(yù)預(yù)計計E=F+G+H-208,160,00015,640,00019,760,00015,880,00051,280,00013,960,00024,760,00015,880,00054,600,00014,280,00018,280,00014,490,00047,050,00022,490,00017,540,00015,200,00055,230,000-E=F+

21、G+H當(dāng)期收入當(dāng)期收款F=B-109,900,0006,240,00013,200,0007,240,00026,680,0007,240,00014,200,0007,240,00028,680,0007,720,0007,720,0007,720,00023,160,00015,580,0007,900,0007,900,00031,380,000-F=B: 本期財務(wù)確認(rèn)收入且本期收回款項收回應(yīng)收款項G94,760,0009,000,0006,320,0008,400,00023,720,0006,320,00010,320,0008,400,00025,040,0006,320,0001

22、0,320,0006,320,00022,960,0006,640,0009,370,0007,030,00023,040,000G: 上期財務(wù)確認(rèn)收入，但于本期收回款項本期預(yù)收款H3,500,000400,000240,000240,000880,000400,000240,000240,000880,000240,000240,000450,000930,000270,000270,000270,000810,000H: 本期收到的預(yù)收款項編報說明：1、本表體現(xiàn)主營業(yè)務(wù)收入確認(rèn)及現(xiàn)金流入預(yù)計情況，其中“商品房銷售收入”數(shù)據(jù)由項目收入預(yù)算開發(fā)產(chǎn)品銷售預(yù)測鏈接生成，其余收入項目視預(yù)計發(fā)生情況直

23、接填列。2、本表為財務(wù)預(yù)算預(yù)計利潤表、項目收入預(yù)算應(yīng)收/預(yù)收賬款預(yù)算及資金預(yù)算資金收支預(yù)算提供依據(jù)。3、本表主營業(yè)務(wù)收入A是指按會計制度和公司會計政策規(guī)定于本期應(yīng)確認(rèn)的收入，包含三種確認(rèn)收入的方式：B現(xiàn)款結(jié)算確認(rèn)收入、C應(yīng)收房款確認(rèn)收入、D預(yù)收房款確認(rèn)收入。 4、商品銷售的確認(rèn)原則，公司已將商品所有權(quán)上的重要風(fēng)險和報酬轉(zhuǎn)移給買方，公司不再對該商品實施與所有權(quán)相關(guān)的繼續(xù)管理權(quán)和實際控制權(quán)，相關(guān)的收入已經(jīng)收到或取得了收款的證據(jù)，并且與銷售該商品有關(guān)的成本能夠可靠地計量時，確認(rèn)營業(yè)收入的實現(xiàn)。收入實現(xiàn)的具體條件：工程已經(jīng)竣工并通過有關(guān)部門驗收；具有經(jīng)購買方確認(rèn)的結(jié)算通知書；履行了合同規(guī)定的義務(wù)，且價

24、款取得或確信可以取得；成本能夠可靠地計量。編制人：編制日期：部門負(fù)責(zé)人：6開開發(fā)發(fā)產(chǎn)產(chǎn)品品銷銷售售預(yù)預(yù)測測表表格格編編號號：R2編編制制單單位位：ABCABC項項目目公公司司預(yù)算日期：2004年3月編編制制部部門門：市市場場部部、財財務(wù)務(wù)部部金額單位：人民幣元業(yè)業(yè)務(wù)務(wù)類類型型科科目目編編碼碼以以前前年年度度累累計計發(fā)發(fā)生生上上年年實實際際數(shù)數(shù)據(jù)據(jù)商商品品房房銷銷售售預(yù)預(yù)測測 以以后后年年度度預(yù)預(yù)算算數(shù)數(shù)據(jù)據(jù)備備注注預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)一一月月二二月月三三月月一一季季度度四四月月五五月月六六月月二二季季度度七七月月八八月月九九月月三三季季度度十十月月十十一一月月十十二二月月四四季季度度開開發(fā)

25、發(fā)產(chǎn)產(chǎn)品品銷銷售售5010150101* * * * * * * * * * * * * * * * * * * * *獨獨立立別別墅墅50101015010101* * * * * * * * * * * * * * * * * * * * *預(yù)計銷售單價10,46010,00010,00010,00010,00010,00010,00010,00010,00011,00011,00011,00011,00011,00011,00011,00011,000預(yù)計銷售面積-12,6008001,8008003,4008001,8008003,4008008008002,4001,80080080

26、03,400(12,600)預(yù)計銷售總額131,800,0008,000,00018,000,0008,000,00034,000,0008,000,00018,000,0008,000,00034,000,0008,800,0008,800,0008,800,00026,400,00019,800,0008,800,0008,800,00037,400,000-預(yù)計現(xiàn)金收款129,240,00010,800,00014,000,0008,000,00032,800,0008,000,00018,000,0008,000,00034,000,0008,480,00012,480,0008,48

27、0,00029,440,00015,400,0008,800,0008,800,00033,000,000-當(dāng)期收入當(dāng)期收款79,080,0004,800,00010,800,0004,800,00020,400,0004,800,00010,800,0004,800,00020,400,0005,280,0005,280,0005,280,00015,840,00011,880,0005,280,0005,280,00022,440,000收回應(yīng)收款項50,160,0006,000,0003,200,0003,200,00012,400,0003,200,0007,200,0003,200,

28、00013,600,0003,200,0007,200,0003,200,00013,600,0003,520,0003,520,0003,520,00010,560,000本期預(yù)收款-預(yù)計確認(rèn)收入-131,800,0008,000,00018,000,0008,000,00034,000,0008,000,00018,000,0008,000,00034,000,0008,800,0008,800,0008,800,00026,400,00019,800,0008,800,0008,800,00037,400,000-現(xiàn)款結(jié)算確認(rèn)收入-79,080,0004,800,00010,800,00

29、04,800,00020,400,0004,800,00010,800,0004,800,00020,400,0005,280,0005,280,0005,280,00015,840,00011,880,0005,280,0005,280,00022,440,000-應(yīng)收房款確認(rèn)收入52,720,0003,200,0007,200,0003,200,00013,600,0003,200,0007,200,0003,200,00013,600,0003,520,0003,520,0003,520,00010,560,0007,920,0003,520,0003,520,00014,960,000

30、預(yù)收房款結(jié)轉(zhuǎn)收入-聯(lián)聯(lián)排排別別墅墅50101025010102* * * * * * * * * * * * * * * * * * * * *預(yù)計銷售單價預(yù)計銷售面積-預(yù)計銷售總額-預(yù)計現(xiàn)金收款-當(dāng)期收入當(dāng)期收款收回應(yīng)收款項本期預(yù)收款預(yù)計確認(rèn)收入-現(xiàn)款結(jié)算確認(rèn)收入-應(yīng)收房款確認(rèn)收入預(yù)收房款結(jié)轉(zhuǎn)收入洋洋房房50101035010103* * * * * * * * * * * * * * * * * * * * *預(yù)計銷售單價預(yù)計銷售面積-預(yù)計銷售總額-預(yù)計現(xiàn)金收款-當(dāng)期收入當(dāng)期收款收回應(yīng)收款項本期預(yù)收款預(yù)計確認(rèn)收入-現(xiàn)款結(jié)算確認(rèn)收入-應(yīng)收房款確認(rèn)收入預(yù)收房款結(jié)轉(zhuǎn)收入豪豪華華莊莊園園50101

31、045010104* * * * * * * * * * * * * * * * * * * * *預(yù)計銷售單價預(yù)計銷售面積-預(yù)計銷售總額-預(yù)計現(xiàn)金收款-當(dāng)期收入當(dāng)期收款收回應(yīng)收款項本期預(yù)收款預(yù)計確認(rèn)收入-現(xiàn)款結(jié)算確認(rèn)收入-應(yīng)收房款確認(rèn)收入預(yù)收房款結(jié)轉(zhuǎn)收入莊莊園園50101055010105* * * * * * * * * * * * * * * * * * * * *預(yù)計銷售單價預(yù)計銷售面積-預(yù)計銷售總額-預(yù)計現(xiàn)金收款-當(dāng)期收入當(dāng)期收款收回應(yīng)收款項本期預(yù)收款預(yù)計確認(rèn)收入-現(xiàn)款結(jié)算確認(rèn)收入-應(yīng)收房款確認(rèn)收入預(yù)收房款結(jié)轉(zhuǎn)收入商商鋪鋪50101065010106* * * * * * * * *

32、 * * * * * * * * * * * *預(yù)計銷售單價8,2628,0008,0008,0008,0008,0008,0008,0008,0008,0008,0008,0008,0009,0009,0009,0009,000預(yù)計銷售面積-8,4006001,0006002,2006001,0006002,2006006006001,8001,0006006002,200(8,400)預(yù)計銷售總額69,400,0004,800,0008,000,0004,800,00017,600,0004,800,0008,000,0004,800,00017,600,0004,800,0004,800

33、,0004,800,00014,400,0009,000,0005,400,0005,400,00019,800,000-預(yù)計現(xiàn)金收款68,920,0004,840,0005,760,0006,880,00017,480,0004,960,0005,760,0006,880,00017,600,0004,800,0004,800,0005,010,00014,610,0006,090,0007,740,0005,400,00019,230,000-當(dāng)期收入當(dāng)期收款20,820,0001,440,0002,400,0001,440,0005,280,0001,440,0002,400,0001,

34、440,0005,280,0001,440,0001,440,0001,440,0004,320,0002,700,0001,620,0001,620,0005,940,000收回應(yīng)收款項44,600,0003,000,0003,120,0005,200,00011,320,0003,120,0003,120,0005,200,00011,440,0003,120,0003,120,0003,120,0009,360,0003,120,0005,850,0003,510,00012,480,000本期預(yù)收款3,500,000400,000240,000240,000880,000400,000

35、240,000240,000880,000240,000240,000450,000930,000270,000270,000270,000810,000預(yù)計確認(rèn)收入-69,400,0004,800,0008,000,0004,800,00017,600,0004,800,0008,000,0004,800,00017,600,0004,800,0004,800,0004,800,00014,400,0009,000,0005,400,0005,400,00019,800,000-現(xiàn)款結(jié)算確認(rèn)收入-20,820,0001,440,0002,400,0001,440,0005,280,0001,

36、440,0002,400,0001,440,0005,280,0001,440,0001,440,0001,440,0004,320,0002,700,0001,620,0001,620,0005,940,000-應(yīng)收房款確認(rèn)收入45,110,0003,120,0005,200,0003,120,00011,440,0003,120,0005,200,0003,120,00011,440,0003,120,0003,120,0003,120,0009,360,0005,850,0003,510,0003,510,00012,870,000預(yù)收房款結(jié)轉(zhuǎn)收入3,470,000240,000400,

37、000240,000880,000240,000400,000240,000880,000240,000240,000240,000720,000450,000270,000270,000990,000賣賣場場50101075010107* * * * * * * * * * * * * * * * * * * *預(yù)計銷售單價預(yù)計銷售面積-預(yù)計銷售總額-預(yù)計現(xiàn)金收款-當(dāng)期收入當(dāng)期收款收回應(yīng)收款項本期預(yù)收款預(yù)計確認(rèn)收入-現(xiàn)款結(jié)算確認(rèn)收入-應(yīng)收房款確認(rèn)收入預(yù)收房款結(jié)轉(zhuǎn)收入車車位位50101085010108* * * * * * * * * * * * * * * * * * * * *預(yù)計銷售單

38、價預(yù)計銷售面積-預(yù)計銷售總額-預(yù)計現(xiàn)金收款-當(dāng)期收入當(dāng)期收款收回應(yīng)收款項本期預(yù)收款預(yù)計確認(rèn)收入-現(xiàn)款結(jié)算確認(rèn)收入-應(yīng)收房款確認(rèn)收入預(yù)收房款結(jié)轉(zhuǎn)收入其其他他50101995010199* * * * * * * * * * * * * * * * * * * * *預(yù)計銷售單價預(yù)計銷售面積-預(yù)計銷售總額-預(yù)計現(xiàn)金收款-當(dāng)期收入當(dāng)期收款收回應(yīng)收款項本期預(yù)收款預(yù)計確認(rèn)收入-現(xiàn)款結(jié)算確認(rèn)收入-應(yīng)收房款確認(rèn)收入預(yù)收房款結(jié)轉(zhuǎn)收入開開發(fā)發(fā)產(chǎn)產(chǎn)品品銷銷售售收收入入合合計計A=B+C+D-201,200,00012,800,00026,000,00012,800,00051,600,00012,800,0002

39、6,000,00012,800,00051,600,00013,600,00013,600,00013,600,00040,800,00028,800,00014,200,00014,200,00057,200,000-現(xiàn)款結(jié)算確認(rèn)收入B-99,900,0006,240,00013,200,0006,240,00025,680,0006,240,00013,200,0006,240,00025,680,0006,720,0006,720,0006,720,00020,160,00014,580,0006,900,0006,900,00028,380,000-應(yīng)收房款確認(rèn)收入C-97,830,0

40、006,320,00012,400,0006,320,00025,040,0006,320,00012,400,0006,320,00025,040,0006,640,0006,640,0006,640,00019,920,00013,770,0007,030,0007,030,00027,830,000-預(yù)收房款結(jié)轉(zhuǎn)收入D-3,470,000240,000400,000240,000880,000240,000400,000240,000880,000240,000240,000240,000720,000450,000270,000270,000990,000-現(xiàn)現(xiàn)金金回回款款預(yù)預(yù)計計E=

41、F+G+H-198,160,00015,640,00019,760,00014,880,00050,280,00012,960,00023,760,00014,880,00051,600,00013,280,00017,280,00013,490,00044,050,00021,490,00016,540,00014,200,00052,230,000-當(dāng)期收入當(dāng)期收款F=B-99,900,0006,240,00013,200,0006,240,00025,680,0006,240,00013,200,0006,240,00025,680,0006,720,0006,720,0006,720,

42、00020,160,00014,580,0006,900,0006,900,00028,380,000-收回應(yīng)收款項G-94,760,0009,000,0006,320,0008,400,00023,720,0006,320,00010,320,0008,400,00025,040,0006,320,00010,320,0006,320,00022,960,0006,640,0009,370,0007,030,00023,040,000-本期預(yù)收款H-3,500,000400,000240,000240,000880,000400,000240,000240,000880,000240,000

43、240,000450,000930,000270,000270,000270,000810,000-編報說明：1、本表為對開發(fā)產(chǎn)品（商品房）銷售收入和現(xiàn)金回款情況的預(yù)測，為項目收入預(yù)算主營業(yè)務(wù)收入預(yù)算提供依據(jù)。2、本表中預(yù)計銷售單價根據(jù)項目收入預(yù)算商品房售價預(yù)測的結(jié)果，結(jié)合季度波動的特點填制；預(yù)計確認(rèn)收入部分由財務(wù)部填列，其余項目由市場部填列。編制人：編制日期：部門負(fù)責(zé)人：7其其他他業(yè)業(yè)務(wù)務(wù)收收支支預(yù)預(yù)算算表表格格編編號號：R4編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司預(yù)算日期：1899年12月編編制制部部門門: : 財財務(wù)務(wù)部部金額單位：人民幣元業(yè)業(yè)務(wù)務(wù)類類

44、型型科科目目編編碼碼 協(xié)協(xié)助助部部門門上上年年實實際際數(shù)數(shù)據(jù)據(jù)預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)一一月月二二月月三三月月一一季季度度二二季季度度三三季季度度四四季季度度以以后后年年度度預(yù)預(yù)算算數(shù)數(shù)據(jù)據(jù)備備注注編編制制說說明明其其他他業(yè)業(yè)務(wù)務(wù)收收入入511511*文體娛樂收入51102市場部核算區(qū)內(nèi)文體娛樂項目的收入材料銷售收入51103材料部銷售材料應(yīng)確認(rèn)的收入固定資產(chǎn)出租收入51104行政部出租固定資產(chǎn)產(chǎn)生的收入其他51199相關(guān)部門-此科目核算年累計發(fā)生額不足10000元的項目，例如轉(zhuǎn)名手續(xù)費，交易服務(wù)費(變更)等轉(zhuǎn)名手續(xù)費5119901市場部交易服務(wù)費(變更)5119902市場部其他5119903

45、合合計計* *-*其其他他業(yè)業(yè)務(wù)務(wù)支支出出( (含含相相應(yīng)應(yīng)稅稅金金及及附附加加) )512512*文體娛樂成本51202市場部對應(yīng)上述其他業(yè)務(wù)收入內(nèi)容所涉及的相關(guān)成本費用支出材料銷售成本51203材料部-對應(yīng)上述其他業(yè)務(wù)收入內(nèi)容所涉及的相關(guān)成本費用支出材料銷售相關(guān)稅金51203材料部-#REF!#REF!#REF!#REF!#REF!#REF!#REF!-對應(yīng)上述其他業(yè)務(wù)收入內(nèi)容所涉及的相關(guān)成本費用支出固定資產(chǎn)出租成本 51204行政部對應(yīng)上述其他業(yè)務(wù)收入內(nèi)容所涉及的相關(guān)成本費用支出其他51299相關(guān)部門-對應(yīng)上述其他業(yè)務(wù)收入內(nèi)容所涉及的相關(guān)成本費用支出轉(zhuǎn)名手續(xù)費5119901市場部對應(yīng)上述

46、其他業(yè)務(wù)收入內(nèi)容所涉及的相關(guān)成本費用支出交易服務(wù)費(變更)5119902市場部對應(yīng)上述其他業(yè)務(wù)收入內(nèi)容所涉及的相關(guān)成本費用支出其他5119903對應(yīng)上述其他業(yè)務(wù)收入內(nèi)容所涉及的相關(guān)成本費用支出合合 計計* *-#REF!#REF!#REF!#REF!#REF!#REF!#REF!-*其其他他業(yè)業(yè)務(wù)務(wù)利利潤潤*-#REF!#REF!#REF!#REF!#REF!#REF!#REF!-*編報說明：1、本表為財務(wù)預(yù)算利潤表、稅金及附加預(yù)算和資金預(yù)算資金收支預(yù)算提供依據(jù)。2、本表涉及的收支業(yè)務(wù)視同當(dāng)期收回或當(dāng)期支付。3、其他業(yè)務(wù)收入視同全部為營業(yè)稅應(yīng)稅項目，相關(guān)稅金及附加在其他業(yè)務(wù)支出核算。編制人：編

47、制日期：部門負(fù)責(zé)人：13項項目目開開發(fā)發(fā)面面積積預(yù)預(yù)測測表表表表格格編編號號：PUD3編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司預(yù)算日期：1899年12月編編制制部部門門: : 預(yù)預(yù)算算部部、市市場場部部金額單位：人民幣元業(yè)業(yè)務(wù)務(wù)類類型型預(yù)預(yù)計計總總面面積積以以前前年年度度累累計計發(fā)發(fā)生生數(shù)數(shù)上上年年實實際際數(shù)數(shù)據(jù)據(jù)預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)一一月月二二月月三三月月一一季季度度四四月月五五月月六六月月二二季季度度七七月月八八月月九九月月三三季季度度十十月月十十一一月月十十二二月月四四季季度度以以后后年年度度預(yù)預(yù)算算數(shù)數(shù)據(jù)據(jù)備備注注建建筑筑面面積積-41,000-

48、獨立別墅-聯(lián)排別墅-洋房-豪華莊園-莊園-商鋪37,000-賣場-車位4,000-其他-累累計計建建筑筑面面積積-41,00041,00041,00041,00041,00041,000-獨立別墅-聯(lián)排別墅-洋房-豪華莊園-莊園-商鋪-37,00037,00037,00037,00037,00037,000-賣場-車位-4,0004,0004,0004,0004,0004,000-其他-完完工工面面積積-7,000-獨立別墅-聯(lián)排別墅-洋房-豪華莊園-莊園-商鋪7,000-賣場-車位-其他-累累計計完完工工面面積積-7,0007,0007,0007,0007,0007,0007,0007,00

49、07,0007,0007,0007,000-獨立別墅-聯(lián)排別墅-洋房-豪華莊園-莊園-商鋪-7,0007,0007,0007,0007,0007,0007,0007,0007,0007,0007,0007,000-賣場-車位-其他-銷銷售售面面積積-21,0001,4002,8001,4005,6001,4002,8001,4005,6001,4001,4001,4004,2002,8001,4001,4005,600(21,000)獨立別墅12,6008001,8008003,4008001,8008003,4008008008002,4001,8008008003,400(12,600)聯(lián)

50、排別墅-洋房-豪華莊園-莊園-商鋪8,4006001,0006002,2006001,0006002,2006006006001,8001,0006006002,200(8,400)賣場-車位-其他-累累計計銷銷售售面面積積-21,0001,4004,2005,6005,6007,0009,80011,20011,20012,60014,00015,40015,40018,20019,60021,00021,000(21,000)獨立別墅-12,6008002,6003,4003,4004,2006,0006,8006,8007,6008,4009,2009,20011,00011,80012

51、,60012,600(12,600)聯(lián)排別墅-洋房-豪華莊園-莊園-商鋪-8,4006001,6002,2002,2002,8003,8004,4004,4005,0005,6006,2006,2007,2007,8008,4008,400(8,400)賣場-車位-其他-編報說明：1、本表為預(yù)算部、市場部根據(jù)項目開發(fā)計劃和進(jìn)度計劃作進(jìn)一步分解編制，為項目收入預(yù)算-商品樓銷售預(yù)測提供依據(jù)，預(yù)算部負(fù)責(zé)匯總。編制人：編制日期：部門負(fù)責(zé)人：9主主營營業(yè)業(yè)務(wù)務(wù)成成本本預(yù)預(yù)算算表表格格編編號號：PUD4編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司預(yù)算日期：1899年12月編

52、編制制部部門門: : 財財務(wù)務(wù)部部金額單位：人民幣元業(yè)業(yè)務(wù)務(wù)類類型型科科目目編編碼碼項項目目進(jìn)進(jìn)度度備備注注上上年年實實際際金金額額預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)以以后后年年度度預(yù)預(yù)算算金金額額銷銷售售面面積積單單位位成成本本總總成成本本一一季季度度二二季季度度三三季季度度四四季季度度開發(fā)產(chǎn)品銷售成本5020121,000*96,600,000.0025,800,00025,800,00019,200,00025,800,000*獨立別墅502010112,6005,00063,000,000.0017,000,00017,000,00012,000,00017,000,000*聯(lián)排別墅502010

53、2-*洋房5020103-*豪華莊園5020104-*莊園5020105-*商鋪50201068,4004,00033,600,000.008,800,0008,800,0007,200,0008,800,000*賣場5020107-*車位5020108-*其他5020199-*出租產(chǎn)品經(jīng)營成本50202-*4,340,000.00434,0001,302,0001,302,0001,302,000-主要為結(jié)轉(zhuǎn)成本，未在此考慮現(xiàn)金流代建工程結(jié)算成本50203主要為結(jié)轉(zhuǎn)成本，未在此考慮現(xiàn)金流配套設(shè)施銷售成本50204主要為結(jié)轉(zhuǎn)成本，未在此考慮現(xiàn)金流土地轉(zhuǎn)讓成本50205主要為結(jié)轉(zhuǎn)成本，未在此考慮

54、現(xiàn)金流物業(yè)管理成本50206合合 計計502502- -*1 10 00 0, ,9 94 40 0, ,0 00 00 0. .0 00 02 26 6, ,2 23 34 4, ,0 00 00 02 27 7, ,1 10 02 2, ,0 00 00 02 20 0, ,5 50 02 2, ,0 00 00 02 27 7, ,1 10 02 2, ,0 00 00 0- -編報說明：1、本表填報依據(jù)為項目開發(fā)面積預(yù)測,單位成本由各公司根據(jù)匯總的開發(fā)產(chǎn)品成本和完工面積計算。2、本表為財務(wù)預(yù)算預(yù)計利潤表提供依據(jù)。編制人：編制日期：部門負(fù)責(zé)人：10開開發(fā)發(fā)成成本本預(yù)預(yù)算算匯匯總總表表表表

55、格格編編號號：PUD7編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司預(yù)算日期：1899年12月編編制制部部門門: : 預(yù)預(yù)算算部部、財財務(wù)務(wù)部部金額單位：人民幣元業(yè)業(yè)務(wù)務(wù)類類型型科科目目編編碼碼預(yù)預(yù)計計總總支支出出以以前前年年度度累累計計發(fā)發(fā)生生數(shù)數(shù)上上年年實實際際數(shù)數(shù)據(jù)據(jù)預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)一一月月二二月月三三月月一一季季度度二二季季度度三三季季度度四四季季度度以以后后年年度度預(yù)預(yù)算算數(shù)數(shù)據(jù)據(jù)備備注注土地征用及拆遷補償費預(yù)算40101-60,000,000-20,000,00040,000,000-(10,000,000)前期工程費預(yù)算40102-800,0

56、00-300,000300,000-500,000-(800,000)基礎(chǔ)設(shè)施配套費預(yù)算40103-8,200,000900,000400,000600,0001,900,0001,900,0001,900,0002,500,000(8,200,000)建筑安裝工程費預(yù)算40104-104,000,0009,000,0007,000,0007,000,00023,000,00023,000,00029,000,00029,000,000(104,000,000)公共配套設(shè)施費預(yù)算編40105-600,000100,000100,000100,000300,000300,000-(600,000

57、)工程物資預(yù)算(甲供材料)40106-7,024,400723,100516,500516,5001,756,1001,756,1001,756,1001,756,100-開發(fā)間接費用預(yù)算40107*-8,146,0001,168,000598,000598,0002,364,0001,894,0002,094,0001,794,000-合合計計*-188,770,40011,891,1008,614,5009,114,50029,620,10048,850,10075,250,10035,050,100(123,600,000)編報說明：1、本表填報依據(jù)為各單項開發(fā)成本預(yù)算。2、本表為項目成

58、本預(yù)算存貨預(yù)算、開發(fā)成本分配表提供依據(jù)。編制人：編制日期：部門負(fù)責(zé)人：11土土地地征征用用、拆拆遷遷補補償償費費及及出出讓讓金金預(yù)預(yù)算算表表格格編編號號：PUD8編編制制單單位位: : 深深圳圳金金地地房房地地產(chǎn)產(chǎn)開開發(fā)發(fā)有有限限公公司司預(yù)算日期：1899年12月編編制制部部門門: : 開開發(fā)發(fā)部部金額單位：人民幣元業(yè)業(yè)務(wù)務(wù)類類型型科科目目編編碼碼協(xié)協(xié)助助部部門門編編制制依依據(jù)據(jù)預(yù)預(yù)計計總總支支出出以以前前年年度度累累計計發(fā)發(fā)生生數(shù)數(shù)上上年年實實際際數(shù)數(shù)據(jù)據(jù)預(yù)預(yù)算算年年度度數(shù)數(shù)據(jù)據(jù)一一季季度度二二季季度度三三季季度度四四季季度度以以后后年年度度預(yù)預(yù)算算備備注注土土地地征征用用及及拆拆遷遷補補償

59、償費費40101*土地出讓金4010101集團(tuán)拓展部40,000,000-土地轉(zhuǎn)讓費4010102集團(tuán)拓展部-土地征用及拆遷補償費4010103集團(tuán)拓展部-10,000,000-20,000,000-(10,000,000)作價補償費401010301集團(tuán)拓展部10,000,00020,000,000(10,000,000)臨遷房租金401010302集團(tuán)拓展部-臨遷費401010303集團(tuán)拓展部-搬家費401010304集團(tuán)拓展部-交通費401010305集團(tuán)拓展部-停業(yè)補償費401010306集團(tuán)拓展部-仲裁訴訟費401010307集團(tuán)拓展部-動遷費401010308集團(tuán)拓展部-征審確權(quán)費

60、401010309集團(tuán)拓展部-轉(zhuǎn)學(xué)轉(zhuǎn)托補償費401010310集團(tuán)拓展部-電話、電視、管道煤氣遷移報停費401010311集團(tuán)拓展部-永遷房交易費401010312集團(tuán)拓展部-公證費401010313集團(tuán)拓展部-房屋評估、房屋查丈費401010314集團(tuán)拓展部-原拆遷房屋租金401010315集團(tuán)拓展部-青苗補償費401010316集團(tuán)拓展部-土地補償費401010318集團(tuán)拓展部-勞動力安置401010319集團(tuán)拓展部-其他401010399集團(tuán)拓展部土地相關(guān)規(guī)費4010104開發(fā)部-征地管理費401010401開發(fā)部-拆遷管理費401010402開發(fā)部-用地加、改名手續(xù)費401010403