{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["キャッシュ フロー","キャッシュ フロー グラフ"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"キャッシュ フロー","index":0,"n_rows":62,"n_cols":16,"rows_kept":62,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"ADATUM CORPORATION"]
[null,"小規模ビジネスのキャッシュフロー予測"]
[]
[null,"開始日",{"$f":"TODAY()","v":"2023-03-20"}]
[null,"現金残高の最小アラート",null,{"$f":"現金_最小","v":0},{"$f":"現金_最小","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"期首","1 月 xx","2 月 xx","3 月 xx","4 月 xx","5 月 xx","6 月 xx","7 月 xx","8 月 xx","9 月 xx","10 月 xx","11 月 xx","12 月 xx","集計"]
[null,"手持ち現金 (月初)",null,{"$f":"C54","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"現金収入"," ","1 月 xx","2 月 xx","3 月 xx","4 月 xx","5 月 xx","6 月 xx","7 月 xx","8 月 xx","9 月 xx","10 月 xx","11 月 xx","12 月 xx","集計"]
[null,"現金売上",{"$nulls":13},{"$f":"SUM(D11:O11)","v":0}]
[null,"返品と値引",{"$nulls":13},0]
[null,"売掛金の回収額",{"$nulls":13},0]
[null,"利息、その他の収入",{"$nulls":13},0]
[null,"貸付金収入",{"$nulls":13},0]
[null,"事業主負担",{"$nulls":13},0]
[null,"現金収入合計",null,{"$f":"SUM(D11,D13:D16,(D12*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,現金収入[集計])","v":0}]
[null,"利用可能現金合計",{"$f":"(C8+現金収入[[#Totals],[ ]])","v":0},{"$f":"(D8+現金収入[[#Totals],[1 月 xx]])","v":0},{"$f":"(E8+現金収入[[#Totals],[2 月 xx]])","v":0},{"$f":"(F8+現金収入[[#Totals],[3 月 xx]])","v":0},{"$f":"(G8+現金収入[[#Totals],[4 月 xx]])","v":0},{"$f":"(H8+現金収入[[#Totals],[5 月 xx]])","v":0},{"$f":"(I8+現金収入[[#Totals],[6 月 xx]])","v":0},{"$f":"(J8+現金収入[[#Totals],[7 月 xx]])","v":0},{"$f":"(K8+現金収入[[#Totals],[8 月 xx]])","v":0},{"$f":"(L8+現金収入[[#Totals],[9 月 xx]])","v":0},{"$f":"(M8+現金収入[[#Totals],[10 月 xx]])","v":0},{"$f":"(N8+現金収入[[#Totals],[11 月 xx]])","v":0},{"$f":"(O8+現金収入[[#Totals],[12 月 xx]])","v":0}]
[]
[null,"現金支出"," ","1 月 xx","2 月 xx","3 月 xx","4 月 xx","5 月 xx","6 月 xx","7 月 xx","8 月 xx","9 月 xx","10 月 xx","11 月 xx","12 月 xx","集計"]
[null,"広告費",{"$nulls":13},{"$f":"SUM(D21:O21)","v":0}]
[null,"手数料",{"$nulls":13},0]
[null,"契約人件費",{"$nulls":13},0]
[null,"従業員の福利厚生プログラム",{"$nulls":13},0]
[null,"保険 (健康保険を除く)",{"$nulls":13},0]
[null,"支払利子",{"$nulls":13},0]
[null,"材料および貯蔵品 (COGS)",{"$nulls":13},0]
[null,"食事と娯楽",{"$nulls":13},0]
[null,"住宅ローン",{"$nulls":13},0]
[null,"事務所費",{"$nulls":13},0]
[null,"その他の支払利子",{"$nulls":13},0]
[null,"年金と利益分配制度",{"$nulls":13},0]
[null,"再販の購入",{"$nulls":13},0]
[null,"賃借/賃貸",{"$nulls":13},0]
[null,"賃借/賃貸: 車両、備品",{"$nulls":13},0]
[null,"修繕とメンテナンス費",{"$nulls":13},0]
[null,"消耗品費 (COGS 外)",{"$nulls":13},0]
[null,"税金とライセンス費",{"$nulls":13},0]
[null,"出張費",{"$nulls":13},0]
[null,"公共料金",{"$nulls":13},0]
[null,"賃金 (雇用還付金未満)",{"$nulls":13},0]
[null,"その他の経費",{"$nulls":13},0]
[null,"その他の経費",{"$nulls":13},0]
[null,"その他の経費",{"$nulls":13},0]
[null,"雑費",{"$nulls":13},0]
[null,"小計",null,{"$f":"SUBTOTAL(109,支出[1 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[2 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[3 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[4 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[5 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[6 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[7 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[8 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[9 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[10 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[11 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[12 月 xx])","v":0},{"$f":"SUBTOTAL(109,支出[集計])","v":0}]
[null,"現金支出"," ","1 月 xx","2 月 xx","3 月 xx","4 月 xx","5 月 xx","6 月 xx","7 月 xx","8 月 xx","9 月 xx","10 月 xx","11 月 xx","12 月 xx","集計"]
[null,"借入金返済額",{"$nulls":13},{"$f":"SUM(D48:O48)","v":0}]
[null,"資産の購入",{"$nulls":13},0]
[null,"その他の準備費用",{"$nulls":13},0]
[null,"引当金かつ/またはエスクロー",{"$nulls":13},0]
[null,"事業主の引出",{"$nulls":13},0]
[null,"現金支出合計",null,{"$f":"支出[[#Totals],[1 月 xx]]+SUBTOTAL(109,現金支出[1 月 xx])","v":0},{"$f":"支出[[#Totals],[2 月 xx]]+SUBTOTAL(109,現金支出[2 月 xx])","v":0},{"$f":"支出[[#Totals],[3 月 xx]]+SUBTOTAL(109,現金支出[3 月 xx])","v":0},{"$f":"支出[[#Totals],[4 月 xx]]+SUBTOTAL(109,現金支出[4 月 xx])","v":0},{"$f":"支出[[#Totals],[5 月 xx]]+SUBTOTAL(109,現金支出[5 月 xx])","v":0},{"$f":"支出[[#Totals],[6 月 xx]]+SUBTOTAL(109,現金支出[6 月 xx])","v":0},{"$f":"支出[[#Totals],[7 月 xx]]+SUBTOTAL(109,現金支出[7 月 xx])","v":0},{"$f":"支出[[#Totals],[8 月 xx]]+SUBTOTAL(109,現金支出[8 月 xx])","v":0},{"$f":"支出[[#Totals],[9 月 xx]]+SUBTOTAL(109,現金支出[9 月 xx])","v":0},{"$f":"支出[[#Totals],[10 月 xx]]+SUBTOTAL(109,現金支出[10 月 xx])","v":0},{"$f":"支出[[#Totals],[11 月 xx]]+SUBTOTAL(109,現金支出[11 月 xx])","v":0},{"$f":"支出[[#Totals],[12 月 xx]]+SUBTOTAL(109,現金支出[12 月 xx])","v":0},0]
[null,"手持ち現金 (月末)",{"$f":"C18","v":0},{"$f":"D18-現金支出[[#Totals],[1 月 xx]]","v":0},{"$f":"E18-現金支出[[#Totals],[2 月 xx]]","v":0},{"$f":"F18-現金支出[[#Totals],[3 月 xx]]","v":0},{"$f":"G18-現金支出[[#Totals],[4 月 xx]]","v":0},{"$f":"H18-現金支出[[#Totals],[5 月 xx]]","v":0},{"$f":"I18-現金支出[[#Totals],[6 月 xx]]","v":0},{"$f":"J18-現金支出[[#Totals],[7 月 xx]]","v":0},{"$f":"K18-現金支出[[#Totals],[8 月 xx]]","v":0},{"$f":"L18-現金支出[[#Totals],[9 月 xx]]","v":0},{"$f":"M18-現金支出[[#Totals],[10 月 xx]]","v":0},{"$f":"N18-現金支出[[#Totals],[11 月 xx]]","v":0},{"$f":"O18-現金支出[[#Totals],[12 月 xx]]","v":0}]
[]
[null,"その他の運用データ"," ","1 月 xx","2 月 xx","3 月 xx","4 月 xx","5 月 xx","6 月 xx","7 月 xx","8 月 xx","9 月 xx","10 月 xx","11 月 xx","12 月 xx","集計"]
[null,"売上高 (ドル)",{"$nulls":13},{"$f":"SUM(その他の運用データ[[#This Row],[1 月 xx]:[12 月 xx]])","v":0}]
[null,"売掛金残高",{"$nulls":13},{"$f":"SUM(その他の運用データ[[#This Row],[ ]:[12 月 xx]])","v":0}]
[null,"不良債権残高",{"$nulls":13},{"$f":"SUM(その他の運用データ[[#This Row],[ ]:[12 月 xx]])","v":0}]
[null,"手持ち在庫",{"$nulls":13},{"$f":"SUM(その他の運用データ[[#This Row],[ ]:[12 月 xx]])","v":0}]
[null,"買掛金残高",{"$nulls":13},{"$f":"SUM(その他の運用データ[[#This Row],[ ]:[12 月 xx]])","v":0}]
[null,"減価償却",{"$nulls":13},{"$f":"SUM(その他の運用データ[[#This Row],[1 月 xx]:[12 月 xx]])","v":0}]

{"sheet":"キャッシュ フロー グラフ","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[1,1,1,5],[53,2,53,3]]}
[]
[null,"現金残高アラートの最小額:",{"$nulls":4},{"$f":"[0]!現金_最小","v":{"v":0,"d":"¥0"}}]