{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["现金流量表"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"现金流量表","index":0,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[13,1,13,18],[37,1,37,18],[46,1,46,18]]}
[null,"現金流量表"]
[]
[null,"会计年度起始于:",null,"（预）启动",{"$f":"UPPER(TEXT(FiscalYearStartDate,\"M 月\"))","v":"1 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,1),\"M 月\"))","v":"2 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,2),\"M 月\"))","v":"3 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,3),\"M 月\"))","v":"4 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,4),\"M 月\"))","v":"5 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,5),\"M 月\"))","v":"6 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,6),\"M 月\"))","v":"7 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,7),\"M 月\"))","v":"8 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,8),\"M 月\"))","v":"9 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,9),\"M 月\"))","v":"10 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,10),\"M 月\"))","v":"11 月"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,11),\"M 月\"))","v":"12 月"},null,"总计"]
[null,"2012-01-05",null,"EST",{"$f":"FiscalYearStartDate","v":"2012-01-05"},{"$f":"EOMONTH(E4,0)+DAY(FiscalYearStartDate)","v":"2012-02-05"},{"$f":"EOMONTH(F4,0)+DAY(FiscalYearStartDate)","v":"2012-03-05"},{"$f":"EOMONTH(G4,0)+DAY(FiscalYearStartDate)","v":"2012-04-05"},{"$f":"EOMONTH(H4,0)+DAY(FiscalYearStartDate)","v":"2012-05-05"},{"$f":"EOMONTH(I4,0)+DAY(FiscalYearStartDate)","v":"2012-06-05"},{"$f":"EOMONTH(J4,0)+DAY(FiscalYearStartDate)","v":"2012-07-05"},{"$f":"EOMONTH(K4,0)+DAY(FiscalYearStartDate)","v":"2012-08-05"},{"$f":"EOMONTH(L4,0)+DAY(FiscalYearStartDate)","v":"2012-09-05"},{"$f":"EOMONTH(M4,0)+DAY(FiscalYearStartDate)","v":"2012-10-05"},{"$f":"EOMONTH(N4,0)+DAY(FiscalYearStartDate)","v":"2012-11-05"},{"$f":"EOMONTH(O4,0)+DAY(FiscalYearStartDate)","v":"2012-12-05"},null,"项目 EST"]
[]
[null,"库存现金 (月初)",null,100,{"$f":"D48","v":100},{"$f":"E48","v":{"v":-125,"d":"!-125"}},45,{"v":-1,"d":"!-1"},224,269,269,269,269,269,269,269,null,{"$f":"P6","v":269}]
[]
[null,"现金收入"]
[null,"现金销售",null,null,125,120,130,100,{"$nulls":9},{"$f":"SUM(CashReceipts[[#This Row],[Period 0]:[Period 12]])","v":475}]
[null,"贷方应收款",{"$nulls":5},75,45,{"$nulls":8},{"$f":"SUM(CashReceipts[[#This Row],[Period 0]:[Period 12]])","v":120}]
[null,"贷款/其他现金投入",null,null,50,50,50,50,{"$nulls":9},{"$f":"SUM(CashReceipts[[#This Row],[Period 0]:[Period 12]])","v":200}]
[null,"总计",null,{"$f":"SUBTOTAL(109,CashReceipts[Period 0])","v":0},{"$f":"SUBTOTAL(109,CashReceipts[Period 1])","v":175},{"$f":"SUBTOTAL(109,CashReceipts[Period 2])","v":170},{"$f":"SUBTOTAL(109,CashReceipts[Period 3])","v":180},{"$f":"SUBTOTAL(109,CashReceipts[Period 4])","v":225},{"$f":"SUBTOTAL(109,CashReceipts[Period 5])","v":45},{"$f":"SUBTOTAL(109,CashReceipts[Period 6])","v":0},{"$f":"SUBTOTAL(109,CashReceipts[Period 7])","v":0},{"$f":"SUBTOTAL(109,CashReceipts[Period 8])","v":0},{"$f":"SUBTOTAL(109,CashReceipts[Period 9])","v":0},{"$f":"SUBTOTAL(109,CashReceipts[Period 10])","v":0},{"$f":"SUBTOTAL(109,CashReceipts[Period 11])","v":0},{"$f":"SUBTOTAL(109,CashReceipts[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,CashReceipts[Total])","v":795}]
[null,"总可用现金（现金支出前）",null,{"$f":"D6+SUM(CashReceipts[Period 0])","v":100},{"$f":"E6+SUM(CashReceipts[Period 1])","v":275},{"$f":"F6+SUM(CashReceipts[Period 2])","v":45},{"$f":"G6+SUM(CashReceipts[Period 3])","v":225},{"$f":"H6+SUM(CashReceipts[Period 4])","v":224},{"$f":"I6+SUM(CashReceipts[Period 5])","v":269},{"$f":"J6+SUM(CashReceipts[Period 6])","v":269},{"$f":"K6+SUM(CashReceipts[Period 7])","v":269},{"$f":"L6+SUM(CashReceipts[Period 8])","v":269},{"$f":"M6+SUM(CashReceipts[Period 9])","v":269},{"$f":"N6+SUM(CashReceipts[Period 10])","v":269},{"$f":"O6+SUM(CashReceipts[Period 11])","v":269},{"$f":"P6+SUM(CashReceipts[Period 12])","v":269},null,{"$f":"R6+SUM(CashReceipts[Total])","v":1064}]
[]
[null,"现金支付"]
[null,"购买（商品）",null,null,400,null,226,{"$nulls":10},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":626}]
[null,"购买（请指定）",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"购买（请指定）",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"总工资（具体提款）",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"薪资支出（税款等）",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"外包服务",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"与经营活动有关的费用 (含办公室租金)",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"修理维护费",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"广告费",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"汽车，运输及差旅费用",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"财务及法务费用",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"租金",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"电话费",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"水电费和采暖费",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"保险费",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"税款（房地产等）",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"利息",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"其他费用（请指定）",{"$nulls":13}," ",null,{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"其他费用（请指定）",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"其他费用（请指定）",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"杂项",{"$nulls":15},{"$f":"SUM(CashPaidOut[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"总计",null,{"$f":"SUBTOTAL(109,CashPaidOut[Period 0])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 1])","v":400},{"$f":"SUBTOTAL(109,CashPaidOut[Period 2])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 3])","v":226},{"$f":"SUBTOTAL(109,CashPaidOut[Period 4])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 5])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 6])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 7])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 8])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 9])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 10])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 11])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,CashPaidOut[Total])","v":626}]
[]
[null,"现金支付（无损益）"]
[null,"贷款本金支付",{"$nulls":15},{"$f":"SUM(CashPaidOut2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"资本购买（请指定）",{"$nulls":15},{"$f":"SUM(CashPaidOut2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"其他启动费用",{"$nulls":15},{"$f":"SUM(CashPaidOut2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"保留或由第三人保存",{"$nulls":15},{"$f":"SUM(CashPaidOut2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"所有者提款",{"$nulls":15},{"$f":"SUM(CashPaidOut2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"总计",null,{"$f":"SUBTOTAL(109,CashPaidOut2[Period 0])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 1])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 2])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 3])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 4])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 5])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 6])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 7])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 8])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 9])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 10])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 11])","v":0},{"$f":"SUBTOTAL(109,CashPaidOut2[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,CashPaidOut2[Total])","v":0}]
[null,"总现金支付",null,{"$f":"SUM(CashPaidOut[Period 0],CashPaidOut2[Period 0])","v":0},{"$f":"SUM(CashPaidOut[Period 1],CashPaidOut2[Period 1])","v":400},{"$f":"SUM(CashPaidOut[Period 2],CashPaidOut2[Period 2])","v":0},{"$f":"SUM(CashPaidOut[Period 3],CashPaidOut2[Period 3])","v":226},{"$f":"SUM(CashPaidOut[Period 4],CashPaidOut2[Period 4])","v":0},{"$f":"SUM(CashPaidOut[Period 5],CashPaidOut2[Period 5])","v":0},{"$f":"SUM(CashPaidOut[Period 6],CashPaidOut2[Period 6])","v":0},{"$f":"SUM(CashPaidOut[Period 7],CashPaidOut2[Period 7])","v":0},{"$f":"SUM(CashPaidOut[Period 8],CashPaidOut2[Period 8])","v":0},{"$f":"SUM(CashPaidOut[Period 9],CashPaidOut2[Period 9])","v":0},{"$f":"SUM(CashPaidOut[Period 10],CashPaidOut2[Period 10])","v":0},{"$f":"SUM(CashPaidOut[Period 11],CashPaidOut2[Period 11])","v":0},{"$f":"SUM(CashPaidOut[Period 12],CashPaidOut2[Period 12])","v":0},null,{"$f":"SUM(CashPaidOut[Total],CashPaidOut2[Total])","v":626}]
[]
[null,"现金头寸 (月末)",null,{"$f":"D13-D46","v":100},{"v":-125,"d":"!-125"},45,{"v":-1,"d":"!-1"},224,269,269,269,269,269,269,269,269,null,{"$f":"R13-R46","v":438}]