{"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,"預估",{"$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,"項目預估"]
[]
[null,"庫存現金 (月初)",null,100,{"$f":"D48","v":100},{"$f":"E48","v":-125},45,-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(現金收據[[#This Row],[Period 0]:[Period 12]])","v":475}]
[null,"從貸方帳戶收款",{"$nulls":5},75,45,{"$nulls":8},{"$f":"SUM(現金收據[[#This Row],[Period 0]:[Period 12]])","v":120}]
[null,"貸款/其他現金注資",null,null,50,50,50,50,{"$nulls":9},{"$f":"SUM(現金收據[[#This Row],[Period 0]:[Period 12]])","v":200}]
[null,"合計",null,{"$f":"SUBTOTAL(109,現金收據[Period 0])","v":0},{"$f":"SUBTOTAL(109,現金收據[Period 1])","v":175},{"$f":"SUBTOTAL(109,現金收據[Period 2])","v":170},{"$f":"SUBTOTAL(109,現金收據[Period 3])","v":180},{"$f":"SUBTOTAL(109,現金收據[Period 4])","v":225},{"$f":"SUBTOTAL(109,現金收據[Period 5])","v":45},{"$f":"SUBTOTAL(109,現金收據[Period 6])","v":0},{"$f":"SUBTOTAL(109,現金收據[Period 7])","v":0},{"$f":"SUBTOTAL(109,現金收據[Period 8])","v":0},{"$f":"SUBTOTAL(109,現金收據[Period 9])","v":0},{"$f":"SUBTOTAL(109,現金收據[Period 10])","v":0},{"$f":"SUBTOTAL(109,現金收據[Period 11])","v":0},{"$f":"SUBTOTAL(109,現金收據[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,現金收據[Total])","v":795}]
[null,"可用現金總額 (兌領現金前)",null,{"$f":"D6+SUM(現金收據[Period 0])","v":100},{"$f":"E6+SUM(現金收據[Period 1])","v":275},{"$f":"F6+SUM(現金收據[Period 2])","v":45},{"$f":"G6+SUM(現金收據[Period 3])","v":225},{"$f":"H6+SUM(現金收據[Period 4])","v":224},{"$f":"I6+SUM(現金收據[Period 5])","v":269},{"$f":"J6+SUM(現金收據[Period 6])","v":269},{"$f":"K6+SUM(現金收據[Period 7])","v":269},{"$f":"L6+SUM(現金收據[Period 8])","v":269},{"$f":"M6+SUM(現金收據[Period 9])","v":269},{"$f":"N6+SUM(現金收據[Period 10])","v":269},{"$f":"O6+SUM(現金收據[Period 11])","v":269},{"$f":"P6+SUM(現金收據[Period 12])","v":269},null,{"$f":"R6+SUM(現金收據[Total])","v":1064}]
[]
[null,"現金付款"]
[null,"購物 (商品)",null,null,400,null,226,{"$nulls":10},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":626}]
[null,"購物 (詳細說明)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"購物 (詳細說明)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"薪資總額 (實際提領)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"薪酬支出 (稅務等)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"外包服務",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"用品 (辦公與營運)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"維修保養",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"廣告",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"用車、送貨及差旅",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"會計與法律",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"租金",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"電話",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"公用事業",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"保險",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"稅款 (不動產等)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"利息",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"其他費用 (詳細說明)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"其他 (詳細說明)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"其他 (詳細說明)",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"雜項",{"$nulls":15},{"$f":"SUM(現金付款[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"合計",null,{"$f":"SUBTOTAL(109,現金付款[Period 0])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 1])","v":400},{"$f":"SUBTOTAL(109,現金付款[Period 2])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 3])","v":226},{"$f":"SUBTOTAL(109,現金付款[Period 4])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 5])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 6])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 7])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 8])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 9])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 10])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 11])","v":0},{"$f":"SUBTOTAL(109,現金付款[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,現金付款[Total])","v":626}]
[]
[null,"現金付款 (非損益)"]
[null,"貸款本金款項",{"$nulls":15},{"$f":"SUM(現金付款2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"資本購買 (詳細說明)",{"$nulls":15},{"$f":"SUM(現金付款2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"其他創業成本",{"$nulls":15},{"$f":"SUM(現金付款2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"預備與/或委付",{"$nulls":15},{"$f":"SUM(現金付款2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"持有人提領",{"$nulls":15},{"$f":"SUM(現金付款2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"合計",null,{"$f":"SUBTOTAL(109,現金付款2[Period 0])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 1])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 2])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 3])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 4])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 5])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 6])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 7])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 8])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 9])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 10])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 11])","v":0},{"$f":"SUBTOTAL(109,現金付款2[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,現金付款2[Total])","v":0}]
[null,"現金付款總額",null,{"$f":"SUM(現金付款[Period 0],現金付款2[Period 0])","v":0},{"$f":"SUM(現金付款[Period 1],現金付款2[Period 1])","v":400},{"$f":"SUM(現金付款[Period 2],現金付款2[Period 2])","v":0},{"$f":"SUM(現金付款[Period 3],現金付款2[Period 3])","v":226},{"$f":"SUM(現金付款[Period 4],現金付款2[Period 4])","v":0},{"$f":"SUM(現金付款[Period 5],現金付款2[Period 5])","v":0},{"$f":"SUM(現金付款[Period 6],現金付款2[Period 6])","v":0},{"$f":"SUM(現金付款[Period 7],現金付款2[Period 7])","v":0},{"$f":"SUM(現金付款[Period 8],現金付款2[Period 8])","v":0},{"$f":"SUM(現金付款[Period 9],現金付款2[Period 9])","v":0},{"$f":"SUM(現金付款[Period 10],現金付款2[Period 10])","v":0},{"$f":"SUM(現金付款[Period 11],現金付款2[Period 11])","v":0},{"$f":"SUM(現金付款[Period 12],現金付款2[Period 12])","v":0},null,{"$f":"SUM(現金付款[Total],現金付款2[Total])","v":626}]
[]
[null,"現金狀況 (月底)",null,{"$f":"D13-D46","v":100},-125,45,-1,224,269,269,269,269,269,269,269,269,null,{"$f":"R13-R46","v":438}]