{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["预计资金流量表","主营成本支出现金预算表","管理费用现金预算表"," 销售费用现金预算表","税费支出现金预算表 ","投资收回现金预算表","  购置非流动资产支出现金预算表","投资支出","财务费用"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"预计资金流量表","index":0,"n_rows":55,"n_cols":19,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,18]]}
["预   计  资  金  流  量   表"]
["编制单位：",null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,"制表人："]
["项目","内容","1季度","1月","2月","3月","2季度","4月","5月","6月","3季度","7月","8月","9月","4季度","10月","11月","12月","全年合计"]
["一、经营活动现金流量"]
["现金流入"]
["主营业务现金收入",null,{"$f":"SUM(D6:F6)","v":0},null,null,null,{"$f":"SUM(H6:J6)","v":0},null,null,null,{"$f":"SUM(L6:N6)","v":0},null,null,null,{"$f":"SUM(P6:R6)","v":0},null,null,null,{"$f":"O6+K6+G6+C6","v":0}]
["房屋开发收入",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["其他业务现金收入",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["收到的税费返还",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["收到的其他与经营活动有关的现金",null,{"$f":"SUM(D10:F10)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["经营活动产生现金流入小计",null,0,{"$f":"D6+D8+D10","v":0},0,0,{"$f":"SUM(H11:J11)","v":0},{"$f":"H6+H8+H10","v":0},0,0,{"$f":"SUM(L11:N11)","v":0},{"$f":"L6+L8+L10","v":0},0,0,{"$f":"SUM(P11:R11)","v":0},{"$f":"P6+P8+P10","v":0},0,0,0]
["现金流出"]
["１、主营业务成本现金支出",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["其中：商品房开发成本支出",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["２、其他业务支出现金支出",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["（一）成本现金支出小计",null,0,{"$f":"D13+D15","v":0},0,0,0,{"$f":"H13+H15","v":0},0,0,0,{"$f":"L13+L15","v":0},0,0,0,{"$f":"P13+P15","v":0},0,0,0]
["1、管理费用现金支出",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["2、销售费用现金支出",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["（二）期间费用支出小计",null,0,{"$f":"SUM(D17:D18)","v":0},0,0,0,{"$f":"SUM(H17:H18)","v":0},0,0,0,{"$f":"SUM(L17:L18)","v":0},0,0,0,{"$f":"SUM(P17:P18)","v":0},0,0,0]
["（三）各项税费支出小计",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["（四）支付的其他与经营活动有关的现金",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["经营活动产生现金流出小计",null,0,{"$f":"D16+D19+D20+D21","v":0},0,0,0,{"$f":"H16+H19+H20+H21","v":0},0,0,0,{"$f":"L16+L19+L20+L21","v":0},0,0,0,{"$f":"P16+P19+P20+P21","v":0},0,0,0]
["经营活动产生的现金流量净额",null,0,{"$f":"D11-D22","v":0},0,0,0,{"$f":"H11-H22","v":0},0,0,0,{"$f":"L11-L22","v":0},0,0,0,{"$f":"P11-P22","v":0},0,0,0]
["二、投资活动现金流量"]
["现金流入"]
["收回投资本金所收到的现金",null,{"$f":"SUM(D26:F26)","v":0},null,null,null,{"$f":"SUM(H26:J26)","v":0},null,null,null,{"$f":"SUM(L26:N26)","v":0},null,null,null,{"$f":"SUM(P26:R26)","v":0},null,null,null,{"$f":"O26+K26+G26+C26","v":0}]
["取得投资收益所收到的现金",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["处置非流动资产收到的现金净额",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["处置子公司及其他营业单位收到的现金净额",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["收到的其他与投资活动有关的现金",null,{"$f":"SUM(D30:F30)","v":0},null,null,null,{"$f":"SUM(H30:J30)","v":0},null,null,null,{"$f":"SUM(L30:N30)","v":0},null,null,null,{"$f":"SUM(P30:R30)","v":0},null,null,null,0]
["（二）投资活动产生现金流入小计",null,0,{"$f":"SUM(D26:D30)","v":0},0,0,0,{"$f":"SUM(H26:H30)","v":0},0,0,0,{"$f":"SUM(L26:L30)","v":0},0,0,0,{"$f":"SUM(P26:P30)","v":0},0,0,0]
["现金流出"]
["1、购置非流动资产支出现金",null,{"$f":"SUM(D33:F33)","v":0},null,null,null,{"$f":"SUM(H33:J33)","v":0},null,null,null,0,null,null,null,{"$f":"SUM(P33:R33)","v":0},null,null,null,{"$f":"O33+K33+G33+C33","v":0}]
["2、长期股权投资",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["3、股票投资",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["3、债券投资",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["4、支付的其他与投资活动有关的现金",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["投资活动产生现金流出小计",null,0,{"$f":"SUM(D33:D37)","v":0},0,0,0,{"$f":"SUM(H33:H37)","v":0},0,0,0,{"$f":"SUM(L33:L37)","v":0},0,0,0,{"$f":"SUM(P33:P37)","v":0},0,0,0]
["投资活动产生的现金流量净额",null,0,{"$f":"D31-D38","v":0},0,0,0,{"$f":"H31-H38","v":0},0,0,0,{"$f":"L31-L38","v":0},0,0,0,{"$f":"P31-P38","v":0},0,0,0]
["三、筹资活动现金流量"]
["吸收投资所收到的现金",null,{"$f":"SUM(D41:F41)","v":0},null,null,null,{"$f":"SUM(H41:J41)","v":0},null,null,null,{"$f":"SUM(L41:N41)","v":0},null,null,null,{"$f":"SUM(P41:R41)","v":0},null,null,null,{"$f":"O41+K41+G41+C41","v":0}]
["借款收到的现金",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["收到的其他与筹资活动有关的现金",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["（三）筹资活动产生现金流入小计",null,0,{"$f":"SUM(D41:D43)","v":0},0,0,0,{"$f":"SUM(H41:H43)","v":0},0,0,0,{"$f":"SUM(L41:L43)","v":0},0,0,0,{"$f":"SUM(P41:P43)","v":0},0,0,0]
["1、偿还债务所支付的现金",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["3、财务费用现金支出",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["2、分配股利或利润付现",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["3、支付的其他与筹资活动有关的现金",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["筹资活动产生现金流出小计",null,0,{"$f":"SUM(D45:D48)","v":0},0,0,0,{"$f":"SUM(H45:H48)","v":0},0,0,0,{"$f":"SUM(L45:L48)","v":0},0,0,0,{"$f":"SUM(P45:P48)","v":0},0,0,0]
["筹资活动产生的现金流量净额",null,0,{"$f":"D44-D49","v":0},0,0,0,{"$f":"H44-H49","v":0},0,0,0,{"$f":"L44-L49","v":0},0,0,0,{"$f":"P44-P49","v":0},0,0,0]
["现金流出合计",null,0,{"$f":"D22+D38+D49","v":0},0,0,0,{"$f":"H22+H38+H49","v":0},0,0,0,{"$f":"L22+L38+L49","v":0},0,0,0,{"$f":"P22+P38+P49","v":0},0,0,0]
["现金流入合计",null,0,{"$f":"D11+D31+D44","v":0},0,0,0,{"$f":"H11+H31+H44","v":0},0,0,0,{"$f":"L11+L31+L44","v":0},0,0,0,{"$f":"P11+P31+P44","v":0},0,0,0]
["三、现金净流量",null,0,{"$f":"D52-D51","v":0},0,0,0,{"$f":"H52-H51","v":0},0,0,0,{"$f":"L52-L51","v":0},0,0,0,{"$f":"P52-P51","v":0},0,0,0]
["四、期初余额",null,0,{"$f":"C54","v":0},{"$f":"D55","v":0},0,{"$f":"J54","v":0},{"$f":"F55","v":0},0,0,{"$f":"N54","v":0},{"$f":"J55","v":0},{"$f":"L55","v":0},0,{"$f":"R54","v":0},{"$f":"N55","v":0},0,0,{"$f":"D54","v":0}]
["五、期末余额",null,{"$f":"F55","v":0},{"$f":"D53+D54","v":0},0,0,{"$f":"J55","v":0},{"$f":"H53+H54","v":0},0,0,{"$f":"N55","v":0},{"$f":"L53+L54","v":0},0,0,{"$f":"R55","v":0},{"$f":"P53+P54","v":0},0,0,0]

{"sheet":"主营成本支出现金预算表","index":1,"n_rows":32,"n_cols":25,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,24],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,19],[2,20,2,21],[2,22,3,22],[2,23,3,23],[2,24,3,24]]}
["主营成本支出现金预算表"]
["编制单位：",null,null,null,null,null,null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,null,"制表人："]
["项目名称","项目预算总额","上年余额","本年预计现金流出量",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"本年结转额",null,"本年余额","应付帐款","预算责任人"]
[null,null,null,"１季度","1月","2月","3月","２季度","4月","5月","6月","３季度","7月","8月","9月","４季度","10月","11月","12月","合计","转入完工产品","转入销售成本"]
["一、项目1"]
["土地费",{"$f":"T6","v":0},null,{"$f":"SUM(E6:G6)","v":0},null,null,null,{"$f":"SUM(I6:K6)","v":0},null,null,null,{"$f":"SUM(M6:O6)","v":0},null,null,null,{"$f":"SUM(Q6:S6)","v":0},null,null,null,{"$f":"P6+L6+H6+D6","v":0},{"$f":"B6-V6","v":0},{"$f":"B6*100%","v":0},{"$f":"B6-V6-U6","v":0},{"$f":"B6-C6-T6","v":0}]
["前期工程费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["建安及装修工程费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["基础设施费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["配套设施费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["开发间接费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["预提结算成本",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["小计",{"$f":"SUM(B6:B12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["二、项目2"]
["土地费",{"$f":"T15","v":0},null,{"$f":"SUM(E15:G15)","v":0},null,null,null,{"$f":"SUM(I15:K15)","v":0},null,null,null,{"$f":"SUM(M15:O15)","v":0},null,null,null,{"$f":"SUM(Q15:S15)","v":0},null,null,null,{"$f":"P15+L15+H15+D15","v":0},{"$f":"B15-V15","v":0},{"$f":"B15*100%","v":0},{"$f":"C15+T15-V15-U15","v":0},{"$f":"B15-C15-T15","v":0}]
["前期工程费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["建安及装修工程费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["基础设施费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["配套设施费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["开发间接费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["预提结算成本",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["小计",{"$f":"SUM(B15:B21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["三、项目3"]
["土地费",{"$f":"T24","v":0},null,{"$f":"SUM(E24:G24)","v":0},null,null,null,{"$f":"SUM(I24:K24)","v":0},null,null,null,{"$f":"SUM(M24:O24)","v":0},null,null,null,{"$f":"SUM(Q24:S24)","v":0},null,null,null,{"$f":"P24+L24+H24+D24","v":0},{"$f":"B24-V24","v":0},{"$f":"B24*100%","v":0},{"$f":"C24+T24-V24-U24","v":0},{"$f":"B24-C24-T24","v":0}]
["前期工程费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["建安及装修工程费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["基础设施费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["配套设施费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["开发间接费",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["预提结算成本",0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0,0,0,0]
["小计",{"$f":"SUM(B24:B30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["合   计",{"$f":"B13+B22","v":0},{"$f":"C13+C22","v":0},{"$f":"SUM(D13,D22,D31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"管理费用现金预算表","index":2,"n_rows":98,"n_cols":25,"rows_kept":98,"cut":false,"hidden":false,"merged":[[0,0,0,24],[94,23,94,24]]}
["管理费用现金预算表      "]
["编制单位：",null,null,null,null,null,null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,null,"制表人："]
["项    目","计划时间","上年","1季度","2013-01-01","2013-02-01","2013-03-01","2季度","2013-04-01","2013-05-01","2013-06-01","3季度","2013-07-01","2013-08-01","2013-09-01","4季度","2013-10-01","2013-11-01","2013-12-01","全年","本年未付","上年实际","增减数","增减（％）","预算责任人"]
["现金支付项目",null,null,{"$f":"SUM(E4:G4)","v":0},null,null,null,{"$f":"SUM(I4:K4)","v":0},null,null,null,{"$f":"SUM(M4:O4)","v":0},null,null,null,{"$f":"SUM(Q4:S4)","v":0},null,null,null,{"$f":"D4+H4+L4+P4","v":0},null,null,{"$f":"T4-V4","v":0},{"$f":"W4/T4","v":{"$error":"#DIV/0!"}}]
["薪酬费用",null,null,{"$f":"SUM(E5:G5)","v":0},null,null,null,0,null,null,null,{"$f":"SUM(M5:O5)","v":0},null,null,null,{"$f":"SUM(Q5:S5)","v":0},null,null,null,{"$f":"D5+H5+L5+P5","v":0},null,null,{"$f":"T5-V5","v":0},{"$f":"W5/T5","v":{"$error":"#DIV/0!"}}]
["工资",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,{"$f":"T6-V6","v":0},{"$f":"W6/T6","v":{"$error":"#DIV/0!"}}]
["奖金",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,{"$f":"T7-V7","v":0},{"$error":"#DIV/0!"}]
["福利费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["伙食费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["收温费",null,null,0,null,null,null,{"$f":"SUM(I10:K10)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["房租水电费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["体检费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["节日补贴",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["个人补贴",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["住房补贴",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["交通补贴",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["通讯补贴",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["活动经费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["其他",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["工会经费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["职工教育经费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["职工五险",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["住房公积金",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["企业年金",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["商业保险",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["辞退福利",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["服装费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["午餐费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["旅游费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["其他",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["电话费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["办公水费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["办公电费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["办公用品",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["差旅费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["车辆交通费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["业务招待费",null,null,{"$f":"SUM(E37:G37)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["劳动保护费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["书刊费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["修理费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["财产保险费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["招聘费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["管理税费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["印花税",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["土地使用税",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["房产税",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["车船税",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["契税",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["其他",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["中介费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["审计费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["绿色费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["咨询费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["验资费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["评估费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["会员费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["其他",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["环境费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["清洁费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["绿化费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["消杀费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["节日布置",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["物业管理费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["其他",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["租金",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["总部管理费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["会议费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["董事会费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["党团活动费用",null,null,0,null,null,null,0,null,null,null,{"$f":"SUM(M69:O69)","v":0},null,null,null,{"$f":"SUM(Q69:S69)","v":0},null,null,null,{"$f":"D69+H69+L69+P69","v":0},null,null,0,{"$error":"#DIV/0!"}]
["品牌管理费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$f":"W70/T70","v":{"$error":"#DIV/0!"}}]
["捐赠费",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,{"$f":"T71-V71","v":0},{"$error":"#DIV/0!"}]
["专项费用",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["其他",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["非现金支出项目",null,null,0,null,null,null,{"$f":"SUM(I74:K74)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["固定资产折扣",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["无形资产摊销",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["递延资产摊销",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["长期待摊费用摊销",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["资产减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["坏账损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["存货跌价损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["合同预计损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["长期投资减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["固定资产减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["无形资产减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["在建工程减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["工程物资减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["持有至到期投资减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["商誉减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["投资性房地产减值损失",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["其他",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,{"$error":"#DIV/0!"}]
["小计",null,{"$f":"SUM(C4:C91)","v":0},{"$f":"SUM(D4:D91)","v":0},{"$f":"SUM(E4:E91)","v":0},{"$f":"SUM(F4:F91)","v":0},{"$f":"SUM(G4:G91)","v":0},{"$f":"SUM(H4:H91)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
["其他非现金支出项目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"}]
["    合      计",null,{"$f":"SUM(C92:C93)","v":0},{"$f":"SUM(D92:D93)","v":0},{"$f":"SUM(E92:E93)","v":0},{"$f":"SUM(F92:F93)","v":0},{"$f":"SUM(G92:G93)","v":0},{"$f":"SUM(H92:H93)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
["编制说明："]
["1、费用项目应按“重大支出优先”原则列示，列入“其他”的支出不应超过总额的5％。"]
["2、录入“现金流量表”的数据按照本表的“现金支付项目”小计数填列。"]
["3、低值易耗品摊销：假设当年发生，当年全额结转，如有金额较大支出，在资产负债表“存货”项目中列示，并在“附注”中说明。"]

{"sheet":" 销售费用现金预算表","index":3,"n_rows":67,"n_cols":22,"rows_kept":67,"cut":false,"hidden":false,"merged":[[64,0,64,19],[0,0,0,21],[2,0,3,0],[2,1,2,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21]]}
[" 销售费用现金预算表"]
["编制单位：",null,null,null,null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,"制表人："]
["项    目","全年预计现金流出量",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"全年","上年实际","增减数","增减（％）","预算责任人"]
[null,"一季度","1月","2月","3月","二季度","4月","5月","6月","三季度","7月","8月","9月","四季度","10月","11月","12月"]
["现金支付项目"]
["销售费用",{"$f":"SUM(C6:E6)","v":0},null,null,null,{"$f":"SUM(G6:I6)","v":0},null,null,null,{"$f":"SUM(K6:M6)","v":0},null,null,null,{"$f":"SUM(O6:Q6)","v":0},null,null,null,{"$f":"B6+F6+J6+N6","v":0},null,{"$f":"R6-S6","v":0},{"$f":"T6/R6","v":{"$error":"#DIV/0!"}}]
["营销费用",{"$f":"SUM(C7:E7)","v":0},null,null,null,{"$f":"SUM(G7:I7)","v":0},null,null,null,{"$f":"SUM(K7:M7)","v":0},null,null,null,{"$f":"SUM(O7:Q7)","v":0},null,null,null,{"$f":"B7+F7+J7+N7","v":0},null,{"$f":"R7-S7","v":0},{"$f":"T7/R7","v":{"$error":"#DIV/0!"}}]
["广告费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["报纸广告",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["电视广告",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["户外广告",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["网络广告",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["短信广告",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其他广告(道旗)",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["活动推广费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["开盘活动费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["促销活动费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["展销会费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["入伙活动费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其它活动推广费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["卖场包装费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["售楼处包装费　",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["样板房包装费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["场景包装费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["道具购置费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其它卖场包装费\n（围墙及导视牌）",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["销售管理费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["营销人员薪酬",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["卖场物管费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["差旅费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["销售办公费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["销售电话费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["销售水电费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["销售业务费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["样板房费用（管理费）",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其它销售管理费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["配套设施费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["车辆费",{"$f":"SUM(C38:E38)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其它配套设施费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["咨询代理费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["策划咨询费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["代理佣金",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其它咨询代理费(广告\n公司费用)",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["签约律师代理费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其它营销费(固定分摊、\n不可预见费用)",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["售后服务费用",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["售后维修费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["业主索赔损失",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其它售后服务费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["物业补偿费用",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["空置物业管理费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["物业管理开支补贴",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["物业专项补贴",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其它物业补偿费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其他销售费用",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["小计",0,{"$f":"SUM(C6:C55)","v":0},{"$f":"SUM(D6:D55)","v":0},{"$f":"SUM(E6:E55)","v":0},0,{"$f":"SUM(G6:G55)","v":0},{"$f":"SUM(H6:H55)","v":0},{"$f":"SUM(I6:I55)","v":0},0,{"$f":"SUM(K6:K55)","v":0},{"$f":"SUM(L6:L55)","v":0},{"$f":"SUM(M6:M55)","v":0},0,{"$f":"SUM(O6:O55)","v":0},{"$f":"SUM(P6:P55)","v":0},{"$f":"SUM(Q6:Q55)","v":0},{"$f":"SUM(R6:R55)","v":0},null,{"$f":"SUM(T6:T55)","v":0},{"$error":"#DIV/0!"}]
["非现金支出项目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B57+F57+J57+N57","v":0},null,{"$f":"R57-S57","v":0},{"$error":"#DIV/0!"}]
["固定资产折旧",{"$f":"SUM(C58:E58)","v":0},null,null,null,{"$f":"SUM(G58:I58)","v":0},null,null,null,{"$f":"SUM(K58:M58)","v":0},null,null,null,{"$f":"SUM(O58:Q58)","v":0},null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["月销售收入",{"$f":"SUM(C59:E59)","v":0},null,null,null,{"$f":"SUM(G59:I59)","v":0},null,null,null,{"$f":"SUM(K59:M59)","v":0},null,null,null,{"$f":"SUM(O59:Q59)","v":0},null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["月营销费用（不含广告与代理费）占月销售收入比例",{"$f":"SUM(C60:E60)","v":0},null,null,null,{"$f":"SUM(G60:I60)","v":0},null,null,null,{"$f":"SUM(K60:M60)","v":0},null,null,null,{"$f":"SUM(O60:Q60)","v":0},null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["月营销费用（含广告与代理费）占月销售收入比例",{"$f":"SUM(C61:E61)","v":0},null,null,null,{"$f":"SUM(G61:I61)","v":0},null,null,null,{"$f":"SUM(K61:M61)","v":0},null,null,null,{"$f":"SUM(O61:Q61)","v":0},null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["小计",{"$f":"SUM(C62:E62)","v":0},{"$f":"SUM(C58:C61)","v":0},{"$f":"SUM(D58:D61)","v":0},{"$f":"SUM(E58:E61)","v":0},{"$f":"SUM(G62:I62)","v":0},{"$f":"SUM(G58:G61)","v":0},0,0,{"$f":"SUM(K62:M62)","v":0},0,0,0,{"$f":"SUM(O62:Q62)","v":0},0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[]
["编制说明："]
["1、费用项目应按“重大支出优先”原则列示，列入“其他”的支出不应超过总额的5％"]
["2、录入“现金流量表”的数据按照本表的“现金支付项目”小计数填列。"]
["3、对于售楼处、样板房的日常费用(保安、清洁、维修及相关物料应编制明细支持表格明确到具体的管理单位、测算物业人均成本等)"]

{"sheet":"税费支出现金预算表 ","index":4,"n_rows":17,"n_cols":21,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,0,14,2],[0,0,0,20],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,19],[2,20,3,20]]}
["各项税费支出现金预算表 "]
["编制单位：",null,null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,null,null,null,"制表人："]
["税费名称","计算依据","税费率％","本期预计现金流出额",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"预算责任人"]
[null,null,null,"1季度","1月","2月","3月","2季度","4月","5月","6月","3季度","7月","8月","9月","4季度","10月","11月","12月","全年合计"]
["营业税","销售额",0.05,{"$f":"SUM(E5:G5)","v":0},null,null,null,{"$f":"SUM(I5:K5)","v":0},null,null,null,{"$f":"SUM(M5:O5)","v":0},null,null,null,{"$f":"SUM(Q5:S5)","v":0},null,null,null,{"$f":"D5+H5+L5+P5","v":0}]
["城建税","营业税额",7.0000000000000007E-2,{"$f":"SUM(E6:G6)","v":0},null,null,null,{"$f":"SUM(I6:K6)","v":0},null,null,null,{"$f":"SUM(M6:O6)","v":0},null,null,null,{"$f":"SUM(Q6:S6)","v":0},null,null,null,{"$f":"D6+H6+L6+P6","v":0}]
["教育费附加（中央）","营业税额",0.03,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["教育费附加（地方）","营业税额",0.02,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["堤围费","销售额",1E-3,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["预缴土地增值税","销售额",0.03,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["清算土地增值税","清算结果调整",null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["企业所得税",null,0.25,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["房产税及土地使用税",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["其他",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["合  计",null,null,0,{"$f":"SUM(E5:E14)","v":0},{"$f":"SUM(F5:F14)","v":0},{"$f":"SUM(G5:G14)","v":0},0,{"$f":"SUM(I5:I14)","v":0},{"$f":"SUM(J5:J14)","v":0},{"$f":"SUM(K5:K14)","v":0},0,{"$f":"SUM(M5:M14)","v":0},0,0,0,0,0,0,0]
[]
["注：不包括印花税、车辆管理费等应列入期间费用的项目。"]

{"sheet":"投资收回现金预算表","index":5,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,21],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,19],[3,20,4,20],[3,21,4,21]]}
[]
["投资收回现金预算表"]
["编制单位：",null,null,null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,"制表人："]
["项   目","本年期初数","本年预计追加投资额","至本年末预计累计投资额","全年预计现金流入量",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合计","预算责任人"]
[null,null,null,null,"1季度","1月","2月","3月","2季度","4月","5月","6月","3季度","7月","8月","9月","4季度","10月","11月","12月"]
["一、股票名称",null,null,null,{"$f":"SUM(F6:H6)","v":0},null,null,null,{"$f":"SUM(J6:L6)","v":0},null,null,null,{"$f":"SUM(N6:P6)","v":0},null,null,null,{"$f":"SUM(R6:T6)","v":0},null,null,null,{"$f":"E6+I6+M6+Q6","v":0}]
["股票1",null,null,null,{"$f":"SUM(F7:H7)","v":0},null,null,null,{"$f":"SUM(J7:L7)","v":0},null,null,null,{"$f":"SUM(N7:P7)","v":0},null,null,null,{"$f":"SUM(R7:T7)","v":0},null,null,null,{"$f":"E7+I7+M7+Q7","v":0}]
["本金收回",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["投资收益",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["股票2",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["本金收回",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["投资收益",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["小计",{"$f":"SUM(B6:B12)","v":0},{"$f":"SUM(C6:C12)","v":0},{"$f":"SUM(D6:D12)","v":0},0,{"$f":"SUM(F6:F12)","v":0},{"$f":"SUM(G6:G12)","v":0},{"$f":"SUM(H6:H12)","v":0},0,{"$f":"SUM(J6:J12)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["二、债权投资"]
["债券1"]
["本金收回"]
["投资收益"]
["债券2"]
["本金收回"]
["投资收益"]
["小计",{"$f":"SUM(B15:B20)","v":0},{"$f":"SUM(C15:C20)","v":0},{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E15:E20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["合   计",{"$f":"B13+B21","v":0},{"$f":"C13+C21","v":0},{"$f":"D13+D21","v":0},{"$f":"E13+E21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["编制说明："]
["1、本年期初数：指投资项目预算年度期初余额"]
["2、本年预计追加投资额：指对以前年度投资项目本年追加投资额"]
["3、至本年末预计累计投资额：指至本年末对投资项目的累计投资额"]
["4、全年预计现金流入量：指按照投资项目预计收回本金和投资收益的现金数，分月份列示"]
["5、股票名称：指将闲置资金投资于股票二级市场的短期投资行为现金支出"]
["6、债权投资：指将闲置资金投资于债券市场的短期行为现金支出"]
["7、如果资产变现时发生亏损，投资收益则以“－”填列；“本金收回”根据资产变现比例填列"]

{"sheet":"  购置非流动资产支出现金预算表","index":6,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,22],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,2,20],[2,21,3,21],[2,22,3,22]]}
["  购置非流动资产支出现金预算表"]
["编制单位：",null,null,null,null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,"制表人："]
["名称","规格","数量","单价","总价","本期预计现金流出额",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年度合计","预算责任人"]
[null,null,null,null,null,"1季度","1月","2月","3月","2季度","4月","5月","6月","3季度","7月","8月","9月","4季度","10月","11月","12月"]
["固定资产：",null,null,null,null,{"$f":"SUM(G5:I5)","v":0},null,null,null,{"$f":"SUM(K5:M5)","v":0},null,null,null,{"$f":"SUM(O5:Q5)","v":0},null,null,null,{"$f":"SUM(S5:U5)","v":0},null,null,null,{"$f":"F5+J5+N5+R5","v":0}]
["电脑",null,null,null,null,{"$f":"SUM(G6:I6)","v":0},null,null,null,{"$f":"SUM(K6:M6)","v":0},null,null,null,{"$f":"SUM(O6:Q6)","v":0},null,null,null,{"$f":"SUM(S6:U6)","v":0},null,null,null,{"$f":"F6+J6+N6+R6","v":0}]
[null,null,null,null,null,{"$f":"SUM(G7:I7)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(G8:I8)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(G9:I9)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["小计",null,{"$f":"SUM(C5:C9)","v":0},{"$f":"SUM(D5:D9)","v":0},{"$f":"SUM(E5:E9)","v":0},0,{"$f":"SUM(G5:G9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["无形资产",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["小计",null,{"$f":"SUM(C11:C14)","v":0},{"$f":"SUM(D11:D14)","v":0},{"$f":"SUM(E11:E14)","v":0},0,{"$f":"SUM(G11:G14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["其他长期资产",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["小计",null,{"$f":"SUM(C16:C19)","v":0},{"$f":"SUM(D16:D19)","v":0},{"$f":"SUM(E16:E19)","v":0},{"$f":"SUM(F16:F19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["合     计",null,{"$f":"C10+C15+C20","v":0},{"$f":"D10+D15+D20","v":0},{"$f":"E10+E15+E20","v":0},{"$f":"F10+F15+F20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["注：包括固定资产购置、无形资产和增加其他长期资产等。"]

{"sheet":"投资支出","index":7,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[21,19,21,20],[0,0,0,20],[2,0,3,0],[2,1,3,1],[2,2,2,17],[2,18,3,18],[2,19,3,19],[2,20,3,20]]}
["         投资支出现金预算表       "]
["编制单位：",null,null,null,null,null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,"制表人："]
["项   目","本年期初数","本期预计追加投资现金流出额",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"全年合计","至本年末预计累计投资额","预算责任人"]
[null,null,"1季度","1月","2月","3月","2季度","4月","5月","6月","3季度","7月","8月","9月","4季度","10月","11月","12月"]
["一、长期股权投资",null,{"$f":"SUM(D5:F5)","v":0},null,null,null,{"$f":"SUM(H5:J5)","v":0},null,null,null,{"$f":"SUM(L5:N5)","v":0},null,null,null,{"$f":"SUM(P5:R5)","v":0},null,null,null,{"$f":"C5+G5+K5+O5","v":0}]
[1,null,{"$f":"SUM(D6:F6)","v":0},null,null,null,{"$f":"SUM(H6:J6)","v":0},null,null,null,{"$f":"SUM(L6:N6)","v":0},null,null,null,{"$f":"SUM(P6:R6)","v":0},null,null,null,{"$f":"C6+G6+K6+O6","v":0}]
[2,null,{"$f":"SUM(D7:F7)","v":0},null,null,null,{"$f":"SUM(H7:J7)","v":0},null,null,null,{"$f":"SUM(L7:N7)","v":0},null,null,null,{"$f":"SUM(P7:R7)","v":0},null,null,null,{"$f":"C7+G7+K7+O7","v":0}]
["小 计",{"$f":"SUM(B5:B7)","v":0},{"$f":"SUM(C5:C7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"C8+G8+K8+O8","v":0}]
["二、股票投资",null,{"$f":"SUM(D9:F9)","v":0},null,null,null,{"$f":"SUM(H9:J9)","v":0},null,null,null,{"$f":"SUM(L9:N9)","v":0},null,null,null,{"$f":"SUM(P9:R9)","v":0},null,null,null,{"$f":"C9+G9+K9+O9","v":0}]
[1,null,{"$f":"SUM(D10:F10)","v":0},null,null,null,{"$f":"SUM(H10:J10)","v":0},null,null,null,{"$f":"SUM(L10:N10)","v":0},null,null,null,{"$f":"SUM(P10:R10)","v":0},null,null,null,0]
[2,null,{"$f":"SUM(D11:F11)","v":0},null,null,null,{"$f":"SUM(H11:J11)","v":0},null,null,null,{"$f":"SUM(L11:N11)","v":0},null,null,null,{"$f":"SUM(P11:R11)","v":0},null,null,null,0]
["小 计",{"$f":"SUM(B9:B11)","v":0},{"$f":"SUM(C9:C11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["三、债券投资",null,{"$f":"SUM(D13:F13)","v":0},null,null,null,{"$f":"SUM(H13:J13)","v":0},null,null,null,{"$f":"SUM(L13:N13)","v":0},null,null,null,{"$f":"SUM(P13:R13)","v":0},null,null,null,0]
[1,null,{"$f":"SUM(D14:F14)","v":0},null,null,null,{"$f":"SUM(H14:J14)","v":0},null,null,null,{"$f":"SUM(L14:N14)","v":0},null,null,null,{"$f":"SUM(P14:R14)","v":0},null,null,null,0]
[2,null,{"$f":"SUM(D15:F15)","v":0},null,null,null,{"$f":"SUM(H15:J15)","v":0},null,null,null,{"$f":"SUM(L15:N15)","v":0},null,null,null,{"$f":"SUM(P15:R15)","v":0},null,null,null,0]
["小  计",{"$f":"SUM(B13:B15)","v":0},{"$f":"SUM(C13:C15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["四、支付的其他与投资活动有关的现金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["小  计",{"$f":"SUM(B17:B19)","v":0},{"$f":"SUM(C17:C19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["合   计",{"$f":"B8+B12+B16+B20","v":0},{"$f":"C8+C12+C16+C20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["编制说明："]
["1、本年期初数：指投资项目预算年度期初余额"]
["2、本期预计追加投资现金流出额：指按照投资项目预计追加的本金现金流出数"]
["3、长期股权投资：指作为参股或控股股东直接投资到企业的现金支出"]
["4、股票投资：指将闲置资金投资于股票二级市场现金支出"]
["5、债权投资：指将闲置资金投资于债券市场的短期行为现金支出"]

{"sheet":"财务费用","index":8,"n_rows":16,"n_cols":22,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,13],[14,17,14,20],[0,0,0,21],[2,0,3,0],[2,1,2,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21]]}
["财务费用"]
["编制单位：",null,null,null,null,null,null,null,null,"预算年度：",null,null,null,null,null,null,null,null,"制表人："]
["项目","全年预计现金流出量",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"本年合计","上年实际","增减数","增减（%）","预算责任人"]
[null,"1季度","1月","2月","3月","2季度","4月","5月","6月","3季度","7月","8月","9月","4季度","10月","11月","12月"]
["利息支出",{"$f":"SUM(C5:E5)","v":0},null,null,null,{"$f":"SUM(G5:I5)","v":0},null,null,null,{"$f":"SUM(K5:M5)","v":0},null,null,null,{"$f":"SUM(O5:Q5)","v":0},null,null,null,{"$f":"B5+F5+J5+N5","v":0},null,{"$f":"R5-S5","v":0},{"$f":"T5/R5","v":{"$error":"#DIV/0!"}}]
["其中：期间损益",{"$f":"SUM(C6:E6)","v":0},null,null,null,{"$f":"SUM(G6:I6)","v":0},null,null,null,{"$f":"SUM(K6:M6)","v":0},null,null,null,{"$f":"SUM(O6:Q6)","v":0},null,null,null,{"$f":"B6+F6+J6+N6","v":0},null,{"$f":"R6-S6","v":0},{"$f":"T6/R6","v":{"$error":"#DIV/0!"}}]
["      往来",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["      资本化利息",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["存款利息收入",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["汇兑损失（收益）",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["金融机构手续费",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["其他",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,0,{"$error":"#DIV/0!"}]
["合   计",{"$f":"C13+D13+E13","v":0},{"$f":"SUM(C5:C12)","v":0},{"$f":"SUM(D5:D12)","v":0},{"$f":"SUM(E5:E12)","v":0},{"$f":"G13+H13+I13","v":0},{"$f":"SUM(G5:G12)","v":0},{"$f":"SUM(H5:H12)","v":0},{"$f":"SUM(I5:I12)","v":0},{"$f":"K13+L13+M13","v":0},{"$f":"SUM(K5:K12)","v":0},{"$f":"SUM(L5:L12)","v":0},{"$f":"SUM(M5:M12)","v":0},{"$f":"O13+P13+Q13","v":0},{"$f":"SUM(O5:O12)","v":0},{"$f":"SUM(P5:P12)","v":0},{"$f":"SUM(Q5:Q12)","v":0},0,null,0,{"$error":"#DIV/0!"}]
[]
["注：1、利息收入以“-”号表示。"]
["       2、财务费用支出：不含进入开发成本的资本化利息。"]