{"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,10000,{"$f":"D48","v":10000},{"$f":"E48","v":-12500},4500,-100,22400,26900,26900,26900,26900,26900,26900,26900,null,{"$f":"P6","v":26900}]
[]
[null,"現金収入"]
[null,"現金売上",null,null,12500,12000,13000,10000,{"$nulls":9},{"$f":"SUM(現金収入[[#This Row],[Period 0]:[Period 12]])","v":47500}]
[null,"銀行口座への入金",{"$nulls":5},7500,4500,{"$nulls":8},{"$f":"SUM(現金収入[[#This Row],[Period 0]:[Period 12]])","v":12000}]
[null,"融資/その他の現金注入",null,null,5000,5000,5000,5000,{"$nulls":9},{"$f":"SUM(現金収入[[#This Row],[Period 0]:[Period 12]])","v":20000}]
[null,"合計",null,{"$f":"SUBTOTAL(109,現金収入[Period 0])","v":0},{"$f":"SUBTOTAL(109,現金収入[Period 1])","v":17500},{"$f":"SUBTOTAL(109,現金収入[Period 2])","v":17000},{"$f":"SUBTOTAL(109,現金収入[Period 3])","v":18000},{"$f":"SUBTOTAL(109,現金収入[Period 4])","v":22500},{"$f":"SUBTOTAL(109,現金収入[Period 5])","v":4500},{"$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":79500}]
[null,"利用可能現金合計 (精算前)",null,{"$f":"D6+SUM(現金収入[Period 0])","v":10000},{"$f":"E6+SUM(現金収入[Period 1])","v":27500},{"$f":"F6+SUM(現金収入[Period 2])","v":4500},{"$f":"G6+SUM(現金収入[Period 3])","v":22500},{"$f":"H6+SUM(現金収入[Period 4])","v":22400},{"$f":"I6+SUM(現金収入[Period 5])","v":26900},{"$f":"J6+SUM(現金収入[Period 6])","v":26900},{"$f":"K6+SUM(現金収入[Period 7])","v":26900},{"$f":"L6+SUM(現金収入[Period 8])","v":26900},{"$f":"M6+SUM(現金収入[Period 9])","v":26900},{"$f":"N6+SUM(現金収入[Period 10])","v":26900},{"$f":"O6+SUM(現金収入[Period 11])","v":26900},{"$f":"P6+SUM(現金収入[Period 12])","v":26900},null,{"$f":"R6+SUM(現金収入[Total])","v":106400}]
[]
[null,"現金支払い"]
[null,"購入 (商品)",null,null,40000,null,22600,{"$nulls":10},{"$f":"SUM(支払現金[[#This Row],[Period 0]:[Period 12]])","v":62600}]
[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":40000},{"$f":"SUBTOTAL(109,支払現金[Period 2])","v":0},{"$f":"SUBTOTAL(109,支払現金[Period 3])","v":22600},{"$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":62600}]
[]
[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":40000},{"$f":"SUM(支払現金[Period 2],支払現金2[Period 2])","v":0},{"$f":"SUM(支払現金[Period 3],支払現金2[Period 3])","v":22600},{"$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":62600}]
[]
[null,"現金持ち高 (月末)",null,{"$f":"D13-D46","v":10000},-12500,4500,-100,22400,26900,26900,26900,26900,26900,26900,26900,26900,null,{"$f":"R13-R46","v":43800}]