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

{"sheet":"キャッシュ フロー予測","index":0,"n_rows":64,"n_cols":16,"rows_kept":64,"merged":[[4,14,5,14]]}
[{"$nulls":15}," "]
[]
[null,"開始時の\n手持ち現金",{"v":10000,"d":"¥10,000.00"},null,"開始日",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)","v":"2019-11-01"},null,"現金最小残高のアラート",null,{"v":2000,"d":"¥2,000.00"}]
[]
[null,null,{"$f":"IF(開始_日=\"\",\"\",開始_日)","v":"2019-11-01"},{"$f":"IF(C5=\"\",\"\",DATE(YEAR(C5),MONTH(C5)+1,1))","v":"2019-12-01"},{"$f":"IF(D5=\"\",\"\",DATE(YEAR(D5),MONTH(D5)+1,1))","v":"2020-01-01"},"2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","合計"]
[null,"手持ち現金 (月初)",{"$f":"C3","v":{"v":10000,"d":"¥10,000.00"}},{"$f":"C55","v":{"v":8050,"d":"¥8,050.00"}},{"v":9350,"d":"¥9,350.00"},{"v":890,"d":"¥890.00"},{"v":2190,"d":"¥2,190.00"},{"v":13590,"d":"¥13,590.00"},{"v":13790,"d":"¥13,790.00"},{"v":15290,"d":"¥15,290.00"},{"v":16410,"d":"¥16,410.00"},{"v":14360,"d":"¥14,360.00"},{"v":16560,"d":"¥16,560.00"},{"v":18780,"d":"¥18,780.00"}]
[]
[null,"現金収入"]
[]
[null,"現金売上",{"v":2500,"d":"¥2,500.00"},{"v":3000,"d":"¥3,000.00"},{"v":3600,"d":"¥3,600.00"},{"v":3000,"d":"¥3,000.00"},{"v":14000,"d":"¥14,000.00"},{"v":6000,"d":"¥6,000.00"},{"v":3000,"d":"¥3,000.00"},{"v":2800,"d":"¥2,800.00"},{"v":3500,"d":"¥3,500.00"},{"v":4000,"d":"¥4,000.00"},{"v":3800,"d":"¥3,800.00"},{"v":4200,"d":"¥4,200.00"},{"$f":"SUM(C10:N10)","v":{"v":53400,"d":"¥53,400.00"}}]
[null,"返品と値引",null,null,{"v":200,"d":"¥200.00"},{"$nulls":9},{"v":200,"d":"¥200.00"}]
[null,"売掛金の回収額",{"$nulls":12},0]
[null,"利息、その他の収入",{"$nulls":12},0]
[null,"貸付金収入",{"$nulls":12},0]
[null,"事業主負担",{"$nulls":12},0]
[null,"その他の収入",{"$nulls":12},0]
[null,"現金収入合計",{"$f":"SUM(C10,C12:C16,(C11*-1))","v":{"v":2500,"d":"¥2,500.00"}},{"$f":"SUM(D10,D12:D16,(D11*-1))","v":{"v":3000,"d":"¥3,000.00"}},{"v":3400,"d":"¥3,400.00"},{"v":3000,"d":"¥3,000.00"},{"v":14000,"d":"¥14,000.00"},{"v":6000,"d":"¥6,000.00"},{"v":3000,"d":"¥3,000.00"},{"v":2800,"d":"¥2,800.00"},{"v":3500,"d":"¥3,500.00"},{"v":4000,"d":"¥4,000.00"},{"v":3800,"d":"¥3,800.00"},{"v":4200,"d":"¥4,200.00"},{"$f":"SUM(O10:O16)","v":{"v":53600,"d":"¥53,600.00"}}]
[null,"利用可能現金合計",{"$f":"(C6+C17)","v":{"v":12500,"d":"¥12,500.00"}},{"v":11050,"d":"¥11,050.00"},{"v":12750,"d":"¥12,750.00"},{"v":3890,"d":"¥3,890.00"},{"v":16190,"d":"¥16,190.00"},{"v":19590,"d":"¥19,590.00"},{"v":16790,"d":"¥16,790.00"},{"v":18090,"d":"¥18,090.00"},{"v":19910,"d":"¥19,910.00"},{"v":18360,"d":"¥18,360.00"},{"v":20360,"d":"¥20,360.00"},{"v":22980,"d":"¥22,980.00"}]
[]
[null,"現金支出"]
[]
[null,"広告費",{"v":3000,"d":"¥3,000.00"},{"$nulls":11},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"¥3,000.00"}}]
[null,"手数料",{"v":250,"d":"¥250.00"},{"v":300,"d":"¥300.00"},{"v":360,"d":"¥360.00"},{"v":300,"d":"¥300.00"},{"v":1400,"d":"¥1,400.00"},{"v":400,"d":"¥400.00"},{"v":300,"d":"¥300.00"},{"v":280,"d":"¥280.00"},{"v":350,"d":"¥350.00"},{"v":400,"d":"¥400.00"},{"v":380,"d":"¥380.00"},{"v":420,"d":"¥420.00"},{"v":5140,"d":"¥5,140.00"}]
[null,"契約人件費",null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},{"v":1200,"d":"¥1,200.00"}]
[null,"従業員の福利厚生プログラム",{"$nulls":12},0]
[null,"保険 (健康保険を除く)",null,null,{"v":4000,"d":"¥4,000.00"},null,null,{"v":4000,"d":"¥4,000.00"},null,null,{"v":4000,"d":"¥4,000.00"},null,null,{"v":4000,"d":"¥4,000.00"},{"v":16000,"d":"¥16,000.00"}]
[null,"支払利子",{"$nulls":12},0]
[null,"材料および貯蔵品 (COGS)",{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":7500,"d":"¥7,500.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":20700,"d":"¥20,700.00"}]
[null,"食事と娯楽",{"$nulls":12},0]
[null,"住宅ローン",{"$nulls":12},0]
[null,"事務所費",{"$nulls":12},0]
[null,"その他の支払利子",{"$nulls":12},0]
[null,"年金と利益分配制度",{"$nulls":12},0]
[null,"再販の購入",{"$nulls":12},0]
[null,"賃借/賃貸",{"$nulls":12},0]
[null,"賃借/賃貸: 車両、備品",{"$nulls":12},0]
[null,"修繕とメンテナンス費",{"$nulls":12},0]
[null,"消耗品費 (COGS 外)",{"$nulls":12},0]
[null,"税金とライセンス費",{"$nulls":12},0]
[null,"出張費",{"$nulls":12},0]
[null,"公共料金",{"$nulls":12},0]
[null,"賃金 (雇用還付金未満)",{"$nulls":12},0]
[null,"その他の経費",{"$nulls":12},0]
[null,"その他の経費",{"$nulls":12},0]
[null,"その他の経費",{"$nulls":12},0]
[null,"雑費",{"$nulls":12},0]
[null,"小計",{"$f":"SUM(C22:C46)","v":{"v":4450,"d":"¥4,450.00"}},{"v":1700,"d":"¥1,700.00"},{"v":11860,"d":"¥11,860.00"},{"v":1700,"d":"¥1,700.00"},{"v":2600,"d":"¥2,600.00"},{"v":5800,"d":"¥5,800.00"},{"v":1500,"d":"¥1,500.00"},{"v":1680,"d":"¥1,680.00"},{"v":5550,"d":"¥5,550.00"},{"v":1800,"d":"¥1,800.00"},{"v":1580,"d":"¥1,580.00"},{"v":5820,"d":"¥5,820.00"},{"v":46040,"d":"¥46,040.00"}]
[]
[null,"借入金返済額",{"$nulls":12},0]
[null,"資産の購入",{"$nulls":12},0]
[null,"その他の準備費用",{"$nulls":12},0]
[null,"引当金かつ/またはエスクロー",{"$nulls":12},0]
[null,"事業主の引出",{"$nulls":12},0]
[null,"現金支出合計",{"$f":"C47-SUM(C49:C53)","v":{"v":4450,"d":"¥4,450.00"}},{"$f":"D47-SUM(D49:D53)","v":{"v":1700,"d":"¥1,700.00"}},{"v":11860,"d":"¥11,860.00"},{"v":1700,"d":"¥1,700.00"},{"v":2600,"d":"¥2,600.00"},{"v":5800,"d":"¥5,800.00"},{"v":1500,"d":"¥1,500.00"},{"v":1680,"d":"¥1,680.00"},{"v":5550,"d":"¥5,550.00"},{"v":1800,"d":"¥1,800.00"},{"v":1580,"d":"¥1,580.00"},{"v":5820,"d":"¥5,820.00"},{"$f":"SUM(O47,O49:O53)","v":{"v":46040,"d":"¥46,040.00"}}]
[null,"手持ち現金 (月末)",{"$f":"(C18-C54)","v":{"v":8050,"d":"¥8,050.00"}},{"v":9350,"d":"¥9,350.00"},{"v":890,"d":"¥890.00"},{"v":2190,"d":"¥2,190.00"},{"v":13590,"d":"¥13,590.00"},{"v":13790,"d":"¥13,790.00"},{"v":15290,"d":"¥15,290.00"},{"v":16410,"d":"¥16,410.00"},{"v":14360,"d":"¥14,360.00"},{"v":16560,"d":"¥16,560.00"},{"v":18780,"d":"¥18,780.00"},{"v":17160,"d":"¥17,160.00"}]
[]
[null,"その他の運用データ"]
[]
[null,"売上高 (ドル)"]
[null,"売掛金残高"]
[null,"不良債権残高"]
[null,"手持ち在庫"]
[null,"買掛金残高"]
[null,"減価償却費"]

{"sheet":"キャッシュ フロー グラフ","index":1,"n_rows":15,"n_cols":15,"rows_kept":15}
[{"$nulls":11}," "]
[]
[null,"月","手持ち現金",{"$nulls":9},{"$f":"B3","v":"月"},"最小以上","最小以下"]
[null,{"$f":"'キャッシュ フロー予測'!C5","v":"2019-11-01"},{"$f":"'キャッシュ フロー予測'!C6","v":{"v":10000,"d":"¥10,000.00"}},{"$nulls":9},{"$f":"B4","v":"2019-11-01"},{"$f":"IF(C4<現金_最小,0,C4)","v":{"v":10000,"d":"¥10,000.00"}},{"$f":"IF(C4<現金_最小,C4,0)","v":0}]
[null,{"$f":"'キャッシュ フロー予測'!D5","v":"2019-12-01"},{"$f":"'キャッシュ フロー予測'!D6","v":{"v":8050,"d":"¥8,050.00"}},{"$nulls":9},"2019-12-01",{"v":8050,"d":"¥8,050.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!E5","v":"2020-01-01"},{"$f":"'キャッシュ フロー予測'!E6","v":{"v":9350,"d":"¥9,350.00"}},{"$nulls":9},"2020-01-01",{"v":9350,"d":"¥9,350.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!F5","v":"2020-02-01"},{"$f":"'キャッシュ フロー予測'!F6","v":{"v":890,"d":"¥890.00"}},{"$nulls":9},"2020-02-01",0,{"v":890,"d":"¥890.00"}]
[null,{"$f":"'キャッシュ フロー予測'!G5","v":"2020-03-01"},{"$f":"'キャッシュ フロー予測'!G6","v":{"v":2190,"d":"¥2,190.00"}},{"$nulls":9},"2020-03-01",{"v":2190,"d":"¥2,190.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!H5","v":"2020-04-01"},{"$f":"'キャッシュ フロー予測'!H6","v":{"v":13590,"d":"¥13,590.00"}},{"$nulls":9},"2020-04-01",{"v":13590,"d":"¥13,590.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!I5","v":"2020-05-01"},{"$f":"'キャッシュ フロー予測'!I6","v":{"v":13790,"d":"¥13,790.00"}},{"$nulls":9},"2020-05-01",{"v":13790,"d":"¥13,790.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!J5","v":"2020-06-01"},{"$f":"'キャッシュ フロー予測'!J6","v":{"v":15290,"d":"¥15,290.00"}},{"$nulls":9},"2020-06-01",{"v":15290,"d":"¥15,290.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!K5","v":"2020-07-01"},{"$f":"'キャッシュ フロー予測'!K6","v":{"v":16410,"d":"¥16,410.00"}},{"$nulls":9},"2020-07-01",{"v":16410,"d":"¥16,410.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!L5","v":"2020-08-01"},{"$f":"'キャッシュ フロー予測'!L6","v":{"v":14360,"d":"¥14,360.00"}},{"$nulls":9},"2020-08-01",{"v":14360,"d":"¥14,360.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!M5","v":"2020-09-01"},{"$f":"'キャッシュ フロー予測'!M6","v":{"v":16560,"d":"¥16,560.00"}},{"$nulls":9},"2020-09-01",{"v":16560,"d":"¥16,560.00"},0]
[null,{"$f":"'キャッシュ フロー予測'!N5","v":"2020-10-01"},{"$f":"'キャッシュ フロー予測'!N6","v":{"v":18780,"d":"¥18,780.00"}},{"$nulls":9},"2020-10-01",{"v":18780,"d":"¥18,780.00"},0]