{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["営業日数","創業計画"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"営業日数","index":0,"n_rows":374,"n_cols":4,"rows_kept":374,"cut":false,"hidden":false,"merged":[]}
[]
["年間営業日数"]
[]
[null,null,null,"年間営業日数"]
[null,null,null,{"$f":"SUBTOTAL(2,D8:D374)","v":365}]
[null,null,null,"↑"]
[null,null,"日付","曜日"]
[null,"開業年月日(設立日ではありません)の入力→","2026-06-01",{"$f":"WEEKDAY(C8,1)","v":2}]
[null,null,{"$f":"C8+1","v":"2026-06-02"},3]
[null,null,"2026-06-03",4]
[null,null,"2026-06-04",5]
[null,null,"2026-06-05",6]
[null,null,"2026-06-06",7]
[null,null,"2026-06-07",1]
[null,null,"2026-06-08",2]
[null,null,"2026-06-09",3]
[null,null,"2026-06-10",4]
[null,null,"2026-06-11",5]
[null,null,"2026-06-12",6]
[null,null,"2026-06-13",7]
[null,null,"2026-06-14",1]
[null,null,"2026-06-15",2]
[null,null,"2026-06-16",3]
[null,null,"2026-06-17",4]
[null,null,"2026-06-18",5]
[null,null,"2026-06-19",6]
[null,null,"2026-06-20",7]
[null,null,"2026-06-21",1]
[null,null,"2026-06-22",2]
[null,null,"2026-06-23",3]
[null,null,"2026-06-24",4]
[null,null,"2026-06-25",5]
[null,null,"2026-06-26",6]
[null,null,"2026-06-27",7]
[null,null,"2026-06-28",1]
[null,null,"2026-06-29",2]
[null,null,"2026-06-30",3]
[null,null,"2026-07-01",4]
[null,null,"2026-07-02",5]
[null,null,"2026-07-03",6]
[null,null,"2026-07-04",7]
[null,null,"2026-07-05",1]
[null,null,"2026-07-06",2]
[null,null,"2026-07-07",3]
[null,null,"2026-07-08",4]
[null,null,"2026-07-09",5]
[null,null,"2026-07-10",6]
[null,null,"2026-07-11",7]
[null,null,"2026-07-12",1]
[null,null,"2026-07-13",2]
[null,null,"2026-07-14",3]
[null,null,"2026-07-15",4]
[null,null,"2026-07-16",5]
[null,null,"2026-07-17",6]
[null,null,"2026-07-18",7]
[null,null,"2026-07-19",1]
[null,null,"2026-07-20",2]
[null,null,"2026-07-21",3]
[null,null,"2026-07-22",4]
[null,null,"2026-07-23",5]
[null,null,"2026-07-24",6]
[null,null,"2026-07-25",7]
[null,null,"2026-07-26",1]
[null,null,"2026-07-27",2]
[null,null,"2026-07-28",3]
[null,null,"2026-07-29",4]
[null,null,"2026-07-30",5]
[null,null,"2026-07-31",6]
[null,null,"2026-08-01",7]
[null,null,"2026-08-02",1]
[null,null,"2026-08-03",2]
[null,null,"2026-08-04",{"$f":"WEEKDAY(C72,1)","v":3}]
[null,null,{"$f":"C72+1","v":"2026-08-05"},4]
[null,null,"2026-08-06",5]
[null,null,"2026-08-07",6]
[null,null,"2026-08-08",7]
[null,null,"2026-08-09",1]
[null,null,"2026-08-10",2]
[null,null,"2026-08-11",3]
[null,null,"2026-08-12",4]
[null,null,"2026-08-13",5]
[null,null,"2026-08-14",6]
[null,null,"2026-08-15",7]
[null,null,"2026-08-16",1]
[null,null,"2026-08-17",2]
[null,null,"2026-08-18",3]
[null,null,"2026-08-19",4]
[null,null,"2026-08-20",5]
[null,null,"2026-08-21",6]
[null,null,"2026-08-22",7]
[null,null,"2026-08-23",1]
[null,null,"2026-08-24",2]
[null,null,"2026-08-25",3]
[null,null,"2026-08-26",4]
[null,null,"2026-08-27",5]
[null,null,"2026-08-28",6]
[null,null,"2026-08-29",7]
[null,null,"2026-08-30",1]
[null,null,"2026-08-31",2]
[null,null,"2026-09-01",3]
[null,null,"2026-09-02",4]
[null,null,"2026-09-03",5]
[null,null,"2026-09-04",6]
[null,null,"2026-09-05",7]
[null,null,"2026-09-06",1]
[null,null,"2026-09-07",2]
[null,null,"2026-09-08",3]
[null,null,"2026-09-09",4]
[null,null,"2026-09-10",5]
[null,null,"2026-09-11",6]
[null,null,"2026-09-12",7]
[null,null,"2026-09-13",1]
[null,null,"2026-09-14",2]
[null,null,"2026-09-15",3]
[null,null,"2026-09-16",4]
[null,null,"2026-09-17",5]
[null,null,"2026-09-18",6]
[null,null,"2026-09-19",7]
[null,null,"2026-09-20",1]
[null,null,"2026-09-21",2]
[null,null,"2026-09-22",3]
[null,null,"2026-09-23",4]
[null,null,"2026-09-24",5]
[null,null,"2026-09-25",6]
[null,null,"2026-09-26",7]
[null,null,"2026-09-27",1]
[null,null,"2026-09-28",2]
[null,null,"2026-09-29",3]
[null,null,"2026-09-30",4]
[null,null,"2026-10-01",5]
[null,null,"2026-10-02",6]
[null,null,"2026-10-03",7]
[null,null,"2026-10-04",1]
[null,null,"2026-10-05",2]
[null,null,"2026-10-06",3]
[null,null,"2026-10-07",{"$f":"WEEKDAY(C136,1)","v":4}]
[null,null,{"$f":"C136+1","v":"2026-10-08"},5]
[null,null,"2026-10-09",6]
[null,null,"2026-10-10",7]
[null,null,"2026-10-11",1]
[null,null,"2026-10-12",2]
[null,null,"2026-10-13",3]
[null,null,"2026-10-14",4]
[null,null,"2026-10-15",5]
[null,null,"2026-10-16",6]
[null,null,"2026-10-17",7]
[null,null,"2026-10-18",1]
[null,null,"2026-10-19",2]
[null,null,"2026-10-20",3]
[null,null,"2026-10-21",4]
[null,null,"2026-10-22",5]
[null,null,"2026-10-23",6]
[null,null,"2026-10-24",7]
[null,null,"2026-10-25",1]
[null,null,"2026-10-26",2]
[null,null,"2026-10-27",3]
[null,null,"2026-10-28",4]
[null,null,"2026-10-29",5]
[null,null,"2026-10-30",6]
[null,null,"2026-10-31",7]
[null,null,"2026-11-01",1]
[null,null,"2026-11-02",2]
[null,null,"2026-11-03",3]
[null,null,"2026-11-04",4]
[null,null,"2026-11-05",5]
[null,null,"2026-11-06",6]
[null,null,"2026-11-07",7]
[null,null,"2026-11-08",1]
[null,null,"2026-11-09",2]
[null,null,"2026-11-10",3]
[null,null,"2026-11-11",4]
[null,null,"2026-11-12",5]
[null,null,"2026-11-13",6]
[null,null,"2026-11-14",7]
[null,null,"2026-11-15",1]
[null,null,"2026-11-16",2]
[null,null,"2026-11-17",3]
[null,null,"2026-11-18",4]
[null,null,"2026-11-19",5]
[null,null,"2026-11-20",6]
[null,null,"2026-11-21",7]
[null,null,"2026-11-22",1]
[null,null,"2026-11-23",2]
[null,null,"2026-11-24",3]
[null,null,"2026-11-25",4]
[null,null,"2026-11-26",5]
[null,null,"2026-11-27",6]
[null,null,"2026-11-28",7]
[null,null,"2026-11-29",1]
[null,null,"2026-11-30",2]
[null,null,"2026-12-01",3]
[null,null,"2026-12-02",4]
[null,null,"2026-12-03",5]
[null,null,"2026-12-04",6]
[null,null,"2026-12-05",7]
[null,null,"2026-12-06",1]
[null,null,"2026-12-07",2]
[null,null,"2026-12-08",3]
[null,null,"2026-12-09",4]
[null,null,"2026-12-10",{"$f":"WEEKDAY(C200,1)","v":5}]
[null,null,{"$f":"C200+1","v":"2026-12-11"},6]
[null,null,"2026-12-12",7]
[null,null,"2026-12-13",1]
[null,null,"2026-12-14",2]
[null,null,"2026-12-15",3]
[null,null,"2026-12-16",4]
[null,null,"2026-12-17",5]
[null,null,"2026-12-18",6]
[null,null,"2026-12-19",7]
[null,null,"2026-12-20",1]
[null,null,"2026-12-21",2]
[null,null,"2026-12-22",3]
[null,null,"2026-12-23",4]
[null,null,"2026-12-24",5]
[null,null,"2026-12-25",6]
[null,null,"2026-12-26",7]
[null,null,"2026-12-27",1]
[null,null,"2026-12-28",2]
[null,null,"2026-12-29",3]
[null,null,"2026-12-30",4]
[null,null,"2026-12-31",5]
[null,null,"2027-01-01",6]
[null,null,"2027-01-02",7]
[null,null,"2027-01-03",1]
[null,null,"2027-01-04",2]
[null,null,"2027-01-05",3]
[null,null,"2027-01-06",4]
[null,null,"2027-01-07",5]
[null,null,"2027-01-08",6]
[null,null,"2027-01-09",7]
[null,null,"2027-01-10",1]
[null,null,"2027-01-11",2]
[null,null,"2027-01-12",3]
[null,null,"2027-01-13",4]
[null,null,"2027-01-14",5]
[null,null,"2027-01-15",6]
[null,null,"2027-01-16",7]
[null,null,"2027-01-17",1]
[null,null,"2027-01-18",2]
[null,null,"2027-01-19",3]
[null,null,"2027-01-20",4]
[null,null,"2027-01-21",5]
[null,null,"2027-01-22",6]
[null,null,"2027-01-23",7]
[null,null,"2027-01-24",1]
[null,null,"2027-01-25",2]
[null,null,"2027-01-26",3]
[null,null,"2027-01-27",4]
[null,null,"2027-01-28",5]
[null,null,"2027-01-29",6]
[null,null,"2027-01-30",7]
[null,null,"2027-01-31",1]
[null,null,"2027-02-01",2]
[null,null,"2027-02-02",3]
[null,null,"2027-02-03",4]
[null,null,"2027-02-04",5]
[null,null,"2027-02-05",6]
[null,null,"2027-02-06",7]
[null,null,"2027-02-07",1]
[null,null,"2027-02-08",2]
[null,null,"2027-02-09",3]
[null,null,"2027-02-10",4]
[null,null,"2027-02-11",5]
[null,null,"2027-02-12",{"$f":"WEEKDAY(C264,1)","v":6}]
[null,null,{"$f":"C264+1","v":"2027-02-13"},7]
[null,null,"2027-02-14",1]
[null,null,"2027-02-15",2]
[null,null,"2027-02-16",3]
[null,null,"2027-02-17",4]
[null,null,"2027-02-18",5]
[null,null,"2027-02-19",6]
[null,null,"2027-02-20",7]
[null,null,"2027-02-21",1]
[null,null,"2027-02-22",2]
[null,null,"2027-02-23",3]
[null,null,"2027-02-24",4]
[null,null,"2027-02-25",5]
[null,null,"2027-02-26",6]
[null,null,"2027-02-27",7]
[null,null,"2027-02-28",1]
[null,null,"2027-03-01",2]
[null,null,"2027-03-02",3]
[null,null,"2027-03-03",4]
[null,null,"2027-03-04",5]
[null,null,"2027-03-05",6]
[null,null,"2027-03-06",7]
[null,null,"2027-03-07",1]
[null,null,"2027-03-08",2]
[null,null,"2027-03-09",3]
[null,null,"2027-03-10",4]
[null,null,"2027-03-11",5]
[null,null,"2027-03-12",6]
[null,null,"2027-03-13",7]
[null,null,"2027-03-14",1]
[null,null,"2027-03-15",2]
[null,null,"2027-03-16",3]
[null,null,"2027-03-17",4]
[null,null,"2027-03-18",5]
[null,null,"2027-03-19",6]
[null,null,"2027-03-20",7]
[null,null,"2027-03-21",1]
[null,null,"2027-03-22",2]
[null,null,"2027-03-23",3]
[null,null,"2027-03-24",4]
[null,null,"2027-03-25",5]
[null,null,"2027-03-26",6]
[null,null,"2027-03-27",7]
[null,null,"2027-03-28",1]
[null,null,"2027-03-29",2]
[null,null,"2027-03-30",3]
[null,null,"2027-03-31",4]
[null,null,"2027-04-01",5]
[null,null,"2027-04-02",6]
[null,null,"2027-04-03",7]
[null,null,"2027-04-04",1]
[null,null,"2027-04-05",2]
[null,null,"2027-04-06",3]
[null,null,"2027-04-07",4]
[null,null,"2027-04-08",5]
[null,null,"2027-04-09",6]
[null,null,"2027-04-10",7]
[null,null,"2027-04-11",1]
[null,null,"2027-04-12",2]
[null,null,"2027-04-13",3]
[null,null,"2027-04-14",4]
[null,null,"2027-04-15",5]
[null,null,"2027-04-16",6]
[null,null,"2027-04-17",{"$f":"WEEKDAY(C328,1)","v":7}]
[null,null,{"$f":"C328+1","v":"2027-04-18"},1]
[null,null,"2027-04-19",2]
[null,null,"2027-04-20",3]
[null,null,"2027-04-21",4]
[null,null,"2027-04-22",5]
[null,null,"2027-04-23",6]
[null,null,"2027-04-24",7]
[null,null,"2027-04-25",1]
[null,null,"2027-04-26",2]
[null,null,"2027-04-27",3]
[null,null,"2027-04-28",4]
[null,null,"2027-04-29",5]
[null,null,"2027-04-30",6]
[null,null,"2027-05-01",7]
[null,null,"2027-05-02",1]
[null,null,"2027-05-03",2]
[null,null,"2027-05-04",3]
[null,null,"2027-05-05",4]
[null,null,"2027-05-06",5]
[null,null,"2027-05-07",6]
[null,null,"2027-05-08",7]
[null,null,"2027-05-09",1]
[null,null,"2027-05-10",2]
[null,null,"2027-05-11",3]
[null,null,"2027-05-12",4]
[null,null,"2027-05-13",5]
[null,null,"2027-05-14",6]
[null,null,"2027-05-15",7]
[null,null,"2027-05-16",1]
[null,null,"2027-05-17",2]
[null,null,"2027-05-18",3]
[null,null,"2027-05-19",4]
[null,null,"2027-05-20",5]
[null,null,"2027-05-21",6]
[null,null,"2027-05-22",7]
[null,null,"2027-05-23",1]
[null,null,"2027-05-24",2]
[null,null,"2027-05-25",3]
[null,null,"2027-05-26",4]
[null,null,"2027-05-27",5]
[null,null,"2027-05-28",6]
[null,null,"2027-05-29",7]
[null,null,"2027-05-30",1]
[null,null,"2027-05-31",2]
[null,null,{"$f":"IF(MONTH(C8)=MONTH(C372+1),\"\",C372+1)","v":""},{"$f":"IF(C373=\"\",\"\",WEEKDAY(C373,1))","v":""}]
[null,null,"期末"]

{"sheet":"創業計画","index":1,"n_rows":612,"n_cols":17,"rows_kept":612,"cut":false,"hidden":false,"merged":[[110,8,111,8],[112,8,113,8],[8,3,8,5],[22,3,22,5]]}
[]
["①売上高と費用の見込み"]
["単位：円"]
[]
[null,"売上高"]
[null,"年間見込み","ひと月あたり平均","1日あたり平均","限界利益率"]
["集計",{"$f":"SUM(H11:H17)","v":0},{"$f":"B7/12","v":0},{"$f":"B7/営業日数!D5","v":0},{"$f":"IF(B21=0,0,100%-E21)","v":0}]
[null,null,null,null,null,null,null,null,null,"↓60%なら「60」と入力します。"]
[null,"内訳","売上単価","売上数量",null,null,"ひと月売上金額","年間金額","構成割合","掛け取引割合"]
[null,"商品名・相手名",null,"1日あたり平均","ひと月あたり平均","年間"]
[null,null,null,null,null,{"$f":"IF(D11=\"\",E11*12,D11*営業日数!$D$5)","v":0},{"$f":"C11*F11/12","v":0},{"$f":"C11*F11","v":0},{"$f":"IF($B$7=0,\"\",H11/$B$7)","v":""}]
[null,null,null,null,null,{"$f":"IF(D12=\"\",E12*12,D12*営業日数!$D$5)","v":0},{"$f":"C12*F12/12","v":0},{"$f":"C12*F12","v":0},""]
[null,null,null,null,null,{"$f":"IF(D13=\"\",E13*12,D13*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,null,null,{"$f":"IF(D14=\"\",E14*12,D14*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,null,null,{"$f":"IF(D15=\"\",E15*12,D15*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,null,null,{"$f":"IF(D16=\"\",E16*12,D16*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,null,null,{"$f":"IF(D17=\"\",E17*12,D17*営業日数!$D$5)","v":0},0,0,""]
[]
[null,"変動費(売上が動くと変わる費用)"]
[null,"年間見込み","ひと月あたり平均","1日あたり平均","変動費率"]
["集計",{"$f":"SUM(H25:H31)","v":0},{"$f":"B21/12","v":0},{"$f":"B21/営業日数!$D$5","v":0},{"$f":"IF(B7=0,0,B21/B7)","v":0}]
[null,null,null,null,null,null,null,null,null,"↓60%なら「60」と入力します。"]
[null,"内訳","変動費単価","変動費数量",null,null,"ひと月変動費額","年間金額","構成割合","掛け取引割合"]
[null,"商品名・相手名",null,"1日あたり平均","ひと月あたり平均","年間"]
[null,null,null,null,null,{"$f":"IF(D25=\"\",E25*12,D25*営業日数!$D$5)","v":0},{"$f":"C25*F25/12","v":0},{"$f":"C25*F25","v":0},{"$f":"IF($B$21=0,\"\",H25/$B$21)","v":""}]
[null,null,null,null,null,{"$f":"IF(D26=\"\",E26*12,D26*営業日数!$D$5)","v":0},{"$f":"C26*F26/12","v":0},{"$f":"C26*F26","v":0},{"$f":"IF($B$21=0,\"\",H26/$B$21)","v":""}]
[null,null,null,null,null,{"$f":"IF(D27=\"\",E27*12,D27*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,null,null,{"$f":"IF(D28=\"\",E28*12,D28*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,null,null,{"$f":"IF(D29=\"\",E29*12,D29*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,null,null,{"$f":"IF(D30=\"\",E30*12,D30*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,null,null,{"$f":"IF(D31=\"\",E31*12,D31*営業日数!$D$5)","v":0},0,0,""]
[null,null,null,{"$f":"IF($B$21=0,\"\",C32/$B$21)","v":""}]
[null,"設備と減価償却費",null,null,null,null,"固定費(売上が動いても変わらない費用)"]
[null,null,"購入金額合計","年間減価償却費","ひと月あたり平均",null,"年間見込み","ひと月あたり平均","1日あたり平均"]
[null,"集計",{"$f":"SUM(C38:C46)","v":0},{"$f":"SUM(E38:E46)","v":0},{"$f":"D35/12","v":0},"集計",{"$f":"SUM(I38:I59)","v":0},{"$f":"G35/12","v":0},{"$f":"G35/営業日数!$D$5","v":0}]
[]
[null,"設備の種類","購入金額","耐用年数","減価償却費",null,"内訳","ひと月金額","年間金額","構成割合"]
[null,null,null,null,{"$f":"IF(D38=0,0,C38/D38)","v":0},null,null,null,{"$f":"H38*12","v":0},{"$f":"IF($G$35=0,\"\",I38/$G$35)","v":""}]
[null,null,null,null,{"$f":"IF(D39=0,0,C39/D39)","v":0},null,null,null,{"$f":"H39*12","v":0},""]
[null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,"設備の主な耐用年数(壊れずに使えそうな期間)は次のとおりです。",null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,"・車のうち、新車は５年、中古車は２年",null,null,null,null,null,null,0,""]
[null,"・機械は１０年",null,null,null,null,null,null,0,""]
[null,"・備品は５年",null,null,null,null,null,null,0,""]
[null,"・ソフトウェア（ホームページ作成費用）は５年",null,null,null,null,null,null,0,""]
[null,"・店舗の内装、外装工事は１０年",null,null,null,null,null,null,0,""]
[null,"・その他金額が１つ１００万円を超えるものは１０年、超えないものは５年",null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,"敷金・保証金は「購入金額」のみ入力します。"]
[null,null,null,null,null,null,{"$f":"IF(H58=0,0,\"支払利息\")","v":0},{"$f":"D70","v":0},0,{"$f":"IF($G$35=0,\"\",I58/$G$35)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(I59=0,0,\"減価償却費\")","v":0},{"$f":"E35","v":0},0,{"$f":"IF($G$35=0,\"\",I59/$G$35)","v":""}]
[]
[]
["②借入条件と返済に必要な利益"]
[{"$f":"$A$3","v":"単位：円"}]
[]
[null,null,"融資希望額","借入期間(年)","年利","据置期間（ヶ月）"]
[null,"借入条件"]
[null,null,null,null,"↑4%なら「4」と入力します。"]
[]
[null,null,"年間","ひと月あたり平均"]
[null,"支払利息",{"$f":"C66*E66","v":0},{"$f":"C70/12","v":0}]
[]
[null,"簡易キャッシュフローの考えを使って、返済に必要な税引後利益を差し引き計算します。"]
[]
[null,null,"年間",null,null,"ひと月あたり平均"]
[null,null,"借金返済に","減価償却費（Ｂ）",null,"借金返済に","減価償却費（Ｄ）"]
[null,null,"必要なお金（Ａ）",{"$f":"I59","v":0},null,"必要なお金（Ｃ）",{"$f":"D76/12","v":0}]
[null,null,{"$f":"IF(D66=0,0,F77*12)","v":0},"返済に必要な",null,{"$f":"IF(D66=0,0,C66/(D66*12-F66))","v":0},"返済に必要な"]
[null,null,null,"税引後利益",null,null,"税引後利益"]
[null,null,null,"（Ａ）-（Ｂ）",null,null,"（Ｃ）-（Ｄ）"]
[null,null,null,{"$f":"C77-D76","v":0},null,null,{"$f":"D80/12","v":0}]
[]
[]
["③返済に必要な売上利益と見込み売上利益との比較"]
[{"$f":"$A$3","v":"単位：円"}]
[]
[null,null,null,"必要な売上利益","見込み売上利益","差額"]
[null,null,"売上高",{"$f":"IF(D90=0,D89,D89/D90)","v":0},{"$f":"B7","v":0},{"$f":"E87-D87","v":0},"←利益に必要な売上高をさかのぼって計算しています。"]
[null,null,"変動費",{"$f":"D87-D89","v":0},{"$f":"B21","v":0},0]
[null,null,"限界利益",{"$f":"D92+D91","v":0},{"$f":"E87-E88","v":0},0]
[null,null,"限界利益率",{"$f":"IF(C77=0,0,$E$7)","v":0},{"$f":"$E$7","v":0},{"$f":"E90-D90","v":0}]
[null,null,"固定費",{"$f":"IF(C77=0,0,G35)","v":0},{"$f":"G35","v":0},0]
[null,null,"税引前利益",{"$f":"IF(D93<=0,D93,D93/(1-G93))","v":0},{"$f":"E89-E91","v":0},0,"法人税等","←個人事業主の場合は「所得税等」としてください。"]
[null,null,"税引後利益",{"$f":"D80","v":0},{"$f":"IF(E92<=0,E92,E92*(1-$G$93))","v":0},0,0.4,"←40%なら「40」と入力します。"]
[]
[]
[]
[null,null,"必要な売上",null,"見込み売上",null,"損益分岐点売上"]
[null,"年間",{"$f":"D87","v":0},"年間",{"$f":"E87","v":0},"年間",{"$f":"IF(E90=0,E91,E91/E90)","v":0}]
[]
[null,"ひと月あたり平均",{"$f":"C98/12","v":0},"ひと月あたり平均",{"$f":"E98/12","v":0},"ひと月あたり平均",{"$f":"G98/12","v":0}]
[]
[null,"1日あたり平均",{"$f":"C98/営業日数!$D$5","v":0},"1日あたり平均",{"$f":"E98/営業日数!$D$5","v":0},"1日あたり平均",{"$f":"G98/営業日数!$D$5","v":0}]
[null,null,"↑",null,null,null,"↑"]
[null,null,"見込み売上がこれにとどかないと",null,null,null,"見込み売上がこれにとどかないと"]
[null,null,"いずれお金を返せなくなります。",null,null,null,"赤字になります。"]
[]
[]
["④季節性の設定"]
[{"$f":"$A$3","v":"単位：円"}]
[null,"季節性→開業月の売上を100とします。"]
[null,null,{"$f":"営業日数!C8","v":"2026-06-01"},{"$f":"DATE(YEAR(C111),MONTH(C111)+1,1)","v":"2026-07-01"},{"$f":"DATE(YEAR(D111),MONTH(D111)+1,1)","v":"2026-08-01"},"2026-09-01","2026-10-01","2026-11-01","数値合計"]
[null,null,100,100,100,100,100,100]
[null,null,{"$f":"DATE(YEAR(H111),MONTH(H111)+1,1)","v":"2026-12-01"},{"$f":"DATE(YEAR(C113),MONTH(C113)+1,1)","v":"2027-01-01"},{"$f":"DATE(YEAR(D113),MONTH(D113)+1,1)","v":"2027-02-01"},"2027-03-01","2027-04-01","2027-05-01",{"$f":"SUM(C114:H114,C112:H112)","v":1200}]
[null,null,100,100,100,100,100,100]
[]
[]
[null,"見込売上数量に季節性を反映"]
[null,"商品名・相手名",{"$f":"営業日数!C8","v":"2026-06-01"},{"$f":"DATE(YEAR(C118),MONTH(C118)+1,1)","v":"2026-07-01"},{"$f":"DATE(YEAR(D118),MONTH(D118)+1,1)","v":"2026-08-01"},"2026-09-01","2026-10-01","2026-11-01","上期"]
[null,{"$f":"B11","v":0},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($C$112/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($D$112/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($E$112/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($F$112/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($G$112/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($H$112/$I$113),0))","v":""},{"$f":"SUM(C119:H119)","v":0}]
[null,{"$f":"B12","v":0},"","","","","","",0]
[null,0,"","","","","","",0]
[null,0,"","","","","","",0]
[null,0,"","","","","","",0]
[null,0,"","","","","","",0]
[null,0,"","","","","","",0]
[]
[null,"商品名・相手名",{"$f":"DATE(YEAR(H118),MONTH(H118)+1,1)","v":"2026-12-01"},{"$f":"DATE(YEAR(C127),MONTH(C127)+1,1)","v":"2027-01-01"},{"$f":"DATE(YEAR(D127),MONTH(D127)+1,1)","v":"2027-02-01"},"2027-03-01","2027-04-01","2027-05-01","下期","年間売上数量"]
[null,{"$f":"B11","v":0},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($C$114/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($D$114/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($E$114/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($F$114/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",ROUNDDOWN(($H11/$C11)*($G$114/$I$113),0))","v":""},{"$f":"IF(C11=\"\",\"\",I128-SUM(C128:G128))","v":""},{"$f":"J128-I119","v":0},{"$f":"F11","v":0}]
[null,{"$f":"B12","v":0},"","","","","",{"$f":"IF(C12=\"\",\"\",I129-SUM(C129:G129))","v":""},{"$f":"J129-I120","v":0},{"$f":"F12","v":0}]
[null,0,"","","","","","",0,0]
[null,0,"","","","","","",0,0]
[null,0,"","","","","","",0,0]
[null,0,"","","","","","",0,0]
[null,0,"","","","","","",0,0]
[]
[]
[null,"見込変動費数量に季節性を反映"]
[null,"商品名・相手名",{"$f":"営業日数!C28","v":"2026-06-21"},{"$f":"DATE(YEAR(C138),MONTH(C138)+1,1)","v":"2026-07-01"},{"$f":"DATE(YEAR(D138),MONTH(D138)+1,1)","v":"2026-08-01"},{"$f":"DATE(YEAR(E138),MONTH(E138)+1,1)","v":"2026-09-01"},{"$f":"DATE(YEAR(F138),MONTH(F138)+1,1)","v":"2026-10-01"},{"$f":"DATE(YEAR(G138),MONTH(G138)+1,1)","v":"2026-11-01"},"上期"]
[null,{"$f":"B25","v":0},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($C$112/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($D$112/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($E$112/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($F$112/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($G$112/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($H$112/$I$113),0))","v":""},{"$f":"SUM(C139:H139)","v":0}]
[null,{"$f":"B26","v":0},"","","","","","",{"$f":"SUM(C140:H140)","v":0}]
[null,0,"","","","","","",0]
[null,0,"","","","","","",0]
[null,0,"","","","","","",0]
[null,{"$f":"B30","v":0},"","","","","","",0]
[null,0,"","","","","","",0]
[]
[null,"商品名・相手名",{"$f":"DATE(YEAR(H138),MONTH(H138)+1,1)","v":"2026-12-01"},{"$f":"DATE(YEAR(C147),MONTH(C147)+1,1)","v":"2027-01-01"},{"$f":"DATE(YEAR(D147),MONTH(D147)+1,1)","v":"2027-02-01"},{"$f":"DATE(YEAR(E147),MONTH(E147)+1,1)","v":"2027-03-01"},{"$f":"DATE(YEAR(F147),MONTH(F147)+1,1)","v":"2027-04-01"},{"$f":"DATE(YEAR(G147),MONTH(G147)+1,1)","v":"2027-05-01"},"下期","年間変動費数量"]
[null,{"$f":"B25","v":0},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($C$114/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($D$114/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($E$114/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($F$114/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",ROUNDDOWN(($H25/$C25)*($G$114/$I$113),0))","v":""},{"$f":"IF($C25=\"\",\"\",I148-SUM(C148:G148))","v":""},{"$f":"J148-I139","v":0},{"$f":"F25","v":0}]
[null,{"$f":"B26","v":0},"","","","","",{"$f":"IF($C26=\"\",\"\",I149-SUM(C149:G149))","v":""},{"$f":"J149-I140","v":0},{"$f":"F26","v":0}]
[null,0,"","","","","","",0,0]
[null,0,"","","","","","",0,0]
[null,0,"","","","","","",0,0]
[null,0,"","","","","","",0,0]
[null,0,"","","","","","",0,0]
[]
[]
[]
["⑤季節性を反映した売上利益"]
[{"$f":"$A$3","v":"単位：円"}]
[]
[null,"月次",{"$f":"C118","v":"2026-06-01"},{"$f":"D118","v":"2026-07-01"},"2026-08-01","2026-09-01","2026-10-01","2026-11-01",{"$f":"C127","v":"2026-12-01"},{"$f":"D127","v":"2027-01-01"},"2027-02-01","2027-03-01",{"$f":"G127","v":"2027-04-01"},{"$f":"H127","v":"2027-05-01"},"年間"]
[null,"売上",{"$f":"SUM(C163:C169)","v":0},{"$f":"SUM(D163:D169)","v":0},0,0,0,0,0,{"$f":"SUM(J163:J169)","v":0},{"$f":"SUM(K163:K169)","v":0},{"$f":"SUM(L163:L169)","v":0},{"$f":"SUM(M163:M169)","v":0},{"$f":"SUM(N163:N169)","v":0},{"$f":"SUM(C162:N162)","v":0}]
[null,{"$f":"B11","v":0},{"$f":"IF(C119=\"\",\"\",C119*$C11)","v":""},{"$f":"IF(D119=\"\",\"\",D119*$C11)","v":""},{"$f":"IF(E119=\"\",\"\",E119*$C11)","v":""},"","","",{"$f":"IF(C128=\"\",\"\",C128*$C11)","v":""},{"$f":"IF(D128=\"\",\"\",D128*$C11)","v":""},"","","","",{"$f":"SUM(C163:N163)","v":0}]
[null,{"$f":"B12","v":0},{"$f":"IF(C120=\"\",\"\",C120*$C12)","v":""},"","","","","",{"$f":"IF(C129=\"\",\"\",C129*$C12)","v":""},{"$f":"IF(D129=\"\",\"\",D129*$C12)","v":""},{"$f":"IF(E129=\"\",\"\",E129*$C12)","v":""},{"$f":"IF(F129=\"\",\"\",F129*$C12)","v":""},{"$f":"IF(G129=\"\",\"\",G129*$C12)","v":""},{"$f":"IF(H129=\"\",\"\",H129*$C12)","v":""},0]
[null,0,{"$f":"IF(C121=\"\",\"\",C121*$C13)","v":""},"","","","","","","","","","","",0]
[null,0,{"$f":"IF(C122=\"\",\"\",C122*$C14)","v":""},"","","","","","","","","","","",0]
[null,0,{"$f":"IF(C123=\"\",\"\",C123*$C15)","v":""},"","","","","","","","","","","",0]
[null,0,{"$f":"IF(C124=\"\",\"\",C124*$C16)","v":""},"","","","","","","","","","","",0]
[null,0,{"$f":"IF(C125=\"\",\"\",C125*$C17)","v":""},"","","","","","","","","","","",0]
[]
[null,"変動費",{"$f":"SUM(C172:C178)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C171:N171)","v":0}]
[null,{"$f":"B25","v":0},{"$f":"IF(C139=\"\",\"\",C139*$C25)","v":""},{"$f":"IF(D139=\"\",\"\",D139*$C25)","v":""},"","","","",{"$f":"IF(C148=\"\",\"\",C148*$C25)","v":""},{"$f":"IF(D148=\"\",\"\",D148*$C25)","v":""},"","","","",0]
[null,{"$f":"B26","v":0},{"$f":"IF(C140=\"\",\"\",C140*$C26)","v":""},"","","","","",{"$f":"IF(C149=\"\",\"\",C149*$C26)","v":""},{"$f":"IF(D149=\"\",\"\",D149*$C26)","v":""},{"$f":"IF(E149=\"\",\"\",E149*$C26)","v":""},{"$f":"IF(F149=\"\",\"\",F149*$C26)","v":""},{"$f":"IF(G149=\"\",\"\",G149*$C26)","v":""},{"$f":"IF(H149=\"\",\"\",H149*$C26)","v":""},0]
[null,0,{"$f":"IF(C141=\"\",\"\",C141*$C27)","v":""},"","","","","","","","","","","",0]
[null,0,{"$f":"IF(C142=\"\",\"\",C142*$C28)","v":""},"","","","","","","","","","","",0]
[null,0,{"$f":"IF(C143=\"\",\"\",C143*$C29)","v":""},"","","","","","","","","","","",0]
[null,0,{"$f":"IF(C144=\"\",\"\",C144*$C30)","v":""},"","","","","","","","","","","",0]
[null,0,{"$f":"IF(C145=\"\",\"\",C145*$C31)","v":""},"","","","","","","","","","","",0]
[]
[null,"限界利益",{"$f":"C162-C171","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C180:N180)","v":0}]
[]
[null,"固定費",{"$f":"SUM(C183:C204)","v":0},{"$f":"SUM(D183:D204)","v":0},0,0,0,0,{"$f":"SUM(I183:I204)","v":0},{"$f":"SUM(J183:J204)","v":0},0,0,0,0,{"$f":"SUM(C182:N182)","v":0}]
[null,{"$f":"G38","v":0},{"$f":"$H$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$40","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$41","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$46","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$47","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$48","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$49","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$50","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$51","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$52","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$53","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$54","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$55","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"$H$56","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"G58","v":0},{"$f":"$H$58","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"G59","v":0},{"$f":"$H$59","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"税引前利益",{"$f":"C180-C182","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C206:N206)","v":0}]
[null,{"$f":"G92","v":"法人税等"},{"$f":"IF(C206<=0,0,C206*$G$93)","v":0},{"$f":"IF(D206<=0,0,D206*$G$93)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"税引後利益",{"$f":"C206-C207","v":0},{"$f":"D206-D207","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["⑥創業計画の調整"]
[{"$f":"$A$3","v":"単位：円"}]
[]
[null,"月次",{"$f":"C161","v":"2026-06-01"},{"$f":"D161","v":"2026-07-01"},"2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","年間","調整前","差額"]
[null,"売上",{"$f":"SUM(C216:C222)","v":0},{"$f":"SUM(D216:D222)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C215:N215)","v":0},null,{"$f":"O215-P215","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C216:N216)","v":0},null,{"$f":"O216-P216","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"変動費",{"$f":"SUM(C225:C231)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C224:N224)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"限界利益",{"$f":"C215-C224","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C233:N233)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"固定費",{"$f":"SUM(C236:C257)","v":0},{"$f":"SUM(D236:D257)","v":0},0,0,0,0,{"$f":"SUM(I236:I257)","v":0},{"$f":"SUM(J236:J257)","v":0},0,0,0,0,{"$f":"SUM(C235:N235)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"税引前利益",{"$f":"C233-C235","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C259:N259)","v":0},null,0]
[null,"法人税等",{"$f":"IF(C259<=0,0,C259*$G$93)","v":0},{"$f":"IF(D259<=0,0,D259*$G$93)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"税引後利益",{"$f":"C259-C260","v":0},{"$f":"D259-D260","v":0},0,0,0,0,0,0,0,0,0,0,0,null,0]
[]
[]
["⑦売上と仕入の資金繰り"]
[{"$f":"$A$3","v":"単位：円"}]
[]
[null,null,"売上代金の回収条件",null,null,null,null,"仕入代金の支払条件"]
[null,null,"商品名・相手名","締日","回収日","掛け取引割合",null,"商品名・相手名","締日","支払日","掛け取引割合"]
[null,null,{"$f":"B163","v":0},null,null,{"$f":"J11","v":0},null,{"$f":"B172","v":0},null,null,{"$f":"J25","v":0}]
[null,null,{"$f":"B164","v":0},null,null,{"$f":"J12","v":0},null,0,null,null,{"$f":"J26","v":0}]
[null,null,0,null,null,0,null,0,null,null,0]
[null,null,0,null,null,0,null,0,null,null,0]
[null,null,0,null,null,0,null,0,null,null,0]
[null,null,0,null,null,0,null,0,null,null,0]
[null,null,0,null,null,0,null,0,null,null,0]
[]
[null,null,"※黄色いところだけ入力します。緑色の金額を黄色いところにそのまま入力していきます。コピーする時は、コピーしたい場所を選択→右クリック→「コピー」→貼り付けたい場所を選択→右クリック→「形式を選択して貼り付け」→「値」を選びます。"]
[null,"月次",{"$f":"C118","v":"2026-06-01"},"2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01",{"$f":"C127","v":"2026-12-01"},"2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","年間"]
[null,"■売上",{"$f":"SUM(C281,C285,C289,C293,C297,C301,C305)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C279:N279)","v":0}]
[]
[null,{"$f":"B163","v":0},{"$f":"SUM(C282:C283)","v":0},{"$f":"SUM(D282:D283)","v":0},0,0,0,0,0,0,{"$f":"SUM(K282:K283)","v":0},0,0,0,0]
[null,"現金売上",{"$f":"IF($J$11=\"\",C216,C216-C283)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"掛売上",{"$f":"IF($J$11=100%,C216,IF($J$11=\"\",0,ROUNDDOWN((C216/$C$11)*$J$11,0)*$C$11))","v":0},{"$f":"IF($J$11=100%,D216,IF($J$11=\"\",0,ROUNDDOWN((D216/$C$11)*$J$11,0)*$C$11))","v":0},{"$f":"IF($J$11=100%,E216,IF($J$11=\"\",0,ROUNDDOWN((E216/$C$11)*$J$11,0)*$C$11))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"掛回収",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B164","v":0},{"$f":"SUM(C286:C287)","v":0},{"$f":"SUM(D286:D287)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金売上",{"$f":"IF($J$12=\"\",C217,C217-C287)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"掛売上",{"$f":"IF($J$12=100%,C217,IF($J$12=\"\",0,ROUNDDOWN((C217/$C$12)*$J$12,0)*$C$12))","v":0},{"$f":"IF($J$12=100%,D217,IF($J$12=\"\",0,ROUNDDOWN((D217/$C$12)*$J$12,0)*$C$12))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛回収",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B165","v":0},{"$f":"SUM(C290:C291)","v":0},{"$f":"SUM(D290:D291)","v":0},0,{"$f":"SUM(F290:F291)","v":0},0,0,0,0,0,0,0,0,0]
[null,"現金売上",{"$f":"IF($J$13=\"\",C218,C218-C291)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"掛売上",{"$f":"IF($J$13=100%,C218,IF($J$13=\"\",0,ROUNDDOWN((C218/$C$13)*$J$13,0)*$C$13))","v":0},{"$f":"IF($J$13=100%,D218,IF($J$13=\"\",0,ROUNDDOWN((D218/$C$13)*$J$13,0)*$C$13))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛回収",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B166","v":0},{"$f":"SUM(C294:C295)","v":0},{"$f":"SUM(D294:D295)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金売上",{"$f":"IF($J$14=\"\",C219,C219-C295)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"掛売上",{"$f":"IF($J$14=100%,C219,IF($J$14=\"\",0,ROUNDDOWN((C219/$C$14)*$J$14,0)*$C$14))","v":0},{"$f":"IF($J$14=100%,D219,IF($J$14=\"\",0,ROUNDDOWN((D219/$C$14)*$J$14,0)*$C$14))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛回収",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B167","v":0},{"$f":"SUM(C298:C299)","v":0},{"$f":"SUM(D298:D299)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金売上",{"$f":"IF($J$15=\"\",C220,C220-C299)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"掛売上",{"$f":"IF($J$15=100%,C220,IF($J$15=\"\",0,ROUNDDOWN((C220/$C$15)*$J$15,0)*$C$15))","v":0},{"$f":"IF($J$15=100%,D220,IF($J$15=\"\",0,ROUNDDOWN((D220/$C$15)*$J$15,0)*$C$15))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛回収",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B168","v":0},{"$f":"SUM(C302:C303)","v":0},{"$f":"SUM(D302:D303)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金売上",{"$f":"IF($J$16=\"\",C221,C221-C303)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"掛売上",{"$f":"IF($J$16=100%,C221,IF($J$16=\"\",0,ROUNDDOWN((C221/$C$16)*$J$16,0)*$C$16))","v":0},{"$f":"IF($J$16=100%,D221,IF($J$16=\"\",0,ROUNDDOWN((D221/$C$16)*$J$16,0)*$C$16))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛回収",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B169","v":0},{"$f":"SUM(C306:C307)","v":0},{"$f":"SUM(D306:D307)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金売上",{"$f":"IF($J$17=\"\",C222,C222-C307)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"掛売上",{"$f":"IF($J$17=100%,C222,IF($J$17=\"\",0,ROUNDDOWN((C222/$C$17)*$J$17,0)*$C$17))","v":0},{"$f":"IF($J$17=100%,D222,IF($J$17=\"\",0,ROUNDDOWN((D222/$C$17)*$J$17,0)*$C$17))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛回収",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"集計",{"$f":"SUM(C311:C312)","v":0},{"$f":"SUM(D311:D312)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O311:O312)","v":0}]
[null,"現金売上",{"$f":"SUM(C282,C286,C290,C294,C298,C302,C306)","v":0},{"$f":"SUM(D282,D286,D290,D294,D298,D302,D306)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O282,O286,O290,O294,O298,O302,O306)","v":0}]
[null,"掛回収",{"$f":"SUM(C284,C288,C292,C296,C300,C304,C308)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O284,O288,O292,O296,O300,O304,O308)","v":0}]
[]
[null,"■変動費",{"$f":"SUM(C316,C320,C324,C328,C332,C336,C340)","v":0},{"$f":"SUM(D316,D320,D324,D328,D332,D336,D340)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B172","v":0},{"$f":"SUM(C317:C318)","v":0},{"$f":"SUM(D317:D318)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入",{"$f":"IF($J$25=\"\",C225,C225-C318)","v":0},{"$f":"IF($J$25=\"\",D225,D225-D318)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛仕入",{"$f":"IF($J$25=100%,C225,IF($J$25=\"\",0,ROUNDDOWN((C225/$C$25)*$J$25,0)*$C$25))","v":0},{"$f":"IF($J$25=100%,D225,IF($J$25=\"\",0,ROUNDDOWN((D225/$C$25)*$J$25,0)*$C$25))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛支払",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B173","v":0},{"$f":"SUM(C321:C322)","v":0},{"$f":"SUM(D321:D322)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入",{"$f":"IF($J$26=\"\",C226,C226-C322)","v":0},{"$f":"IF($J$26=\"\",D226,D226-D322)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛仕入",{"$f":"IF($J$26=100%,C226,IF($J$26=\"\",0,ROUNDDOWN((C226/$C$26)*$J$26,0)*$C$26))","v":0},{"$f":"IF($J$26=100%,D226,IF($J$26=\"\",0,ROUNDDOWN((D226/$C$26)*$J$26,0)*$C$26))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($J$26=\"\",0,ROUNDDOWN((N226/$C$26)*$J$26,0)*$C$26)","v":0},0]
[null,"掛支払",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B174","v":0},{"$f":"SUM(C325:C326)","v":0},{"$f":"SUM(D325:D326)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入",{"$f":"IF($J$27=\"\",C227,C227-C326)","v":0},{"$f":"IF($J$27=\"\",D227,D227-D326)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛仕入",{"$f":"IF($J$27=100%,C227,IF($J$27=\"\",0,ROUNDDOWN((C227/$C$27)*$J$27,0)*$C$27))","v":0},{"$f":"IF($J$27=100%,D227,IF($J$27=\"\",0,ROUNDDOWN((D227/$C$27)*$J$27,0)*$C$27))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛支払",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B175","v":0},{"$f":"SUM(C329:C330)","v":0},{"$f":"SUM(D329:D330)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入",{"$f":"IF($J$28=\"\",C228,C228-C330)","v":0},{"$f":"IF($J$28=\"\",D228,D228-D330)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛仕入",{"$f":"IF($J$28=100%,C228,IF($J$28=\"\",0,ROUNDDOWN((C228/$C$28)*$J$28,0)*$C$28))","v":0},{"$f":"IF($J$28=100%,D228,IF($J$28=\"\",0,ROUNDDOWN((D228/$C$28)*$J$28,0)*$C$28))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛支払",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B176","v":0},{"$f":"SUM(C333:C334)","v":0},{"$f":"SUM(D333:D334)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入",{"$f":"IF($J$29=\"\",C229,C229-C334)","v":0},{"$f":"IF($J$29=\"\",D229,D229-D334)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛仕入",{"$f":"IF($J$29=100%,C229,IF($J$29=\"\",0,ROUNDDOWN((C229/$C$29)*$J$29,0)*$C$29))","v":0},{"$f":"IF($J$29=100%,D229,IF($J$29=\"\",0,ROUNDDOWN((D229/$C$29)*$J$29,0)*$C$29))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛支払",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B177","v":0},{"$f":"SUM(C337:C338)","v":0},{"$f":"SUM(D337:D338)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入",{"$f":"IF($J$30=\"\",C230,C230-C338)","v":0},{"$f":"IF($J$30=\"\",D230,D230-D338)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛仕入",{"$f":"IF($J$30=100%,C230,IF($J$30=\"\",0,ROUNDDOWN((C230/$C$30)*$J$30,0)*$C$30))","v":0},{"$f":"IF($J$30=100%,D230,IF($J$30=\"\",0,ROUNDDOWN((D230/$C$30)*$J$30,0)*$C$30))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛支払",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B178","v":0},{"$f":"SUM(C341:C342)","v":0},{"$f":"SUM(D341:D342)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入",{"$f":"IF($J$31=\"\",C231,C231-C342)","v":0},{"$f":"IF($J$31=\"\",D231,D231-D342)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛仕入",{"$f":"IF($J$31=100%,C231,IF($J$31=\"\",0,ROUNDDOWN((C231/$C$31)*$J$31,0)*$C$31))","v":0},{"$f":"IF($J$31=100%,D231,IF($J$31=\"\",0,ROUNDDOWN((D231/$C$31)*$J$31,0)*$C$31))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"掛支払",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"集計",{"$f":"SUM(C346:C347)","v":0},{"$f":"SUM(D346:D347)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O346:O347)","v":0}]
[null,"現金仕入",{"$f":"SUM(C317,C321,C325,C329,C333,C337,C341)","v":0},{"$f":"SUM(D317,D321,D325,D329,D333,D337,D341)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O317,O321,O325,O329,O333,O337,O341)","v":0}]
[null,"掛支払",{"$f":"SUM(C319,C323,C327,C331,C335,C339,C343)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O319,O323,O327,O331,O335,O339,O343)","v":0}]
[]
[]
[]
["⑧会社設立からの資金繰り"]
[{"$f":"$A$3","v":"単位：円"}]
[null,null,"開業"]
[null,"月次","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01"]
[null,"現金預金月初残高",null,{"$f":"C422","v":0},{"$f":"D422","v":0},{"$f":"E422","v":0},{"$f":"F422","v":0},{"$f":"G422","v":0},{"$f":"H422","v":0},{"$f":"I422","v":0},{"$f":"J422","v":0},{"$f":"K422","v":0},{"$f":"L422","v":0},{"$f":"M422","v":0}]
[]
[null,"営業収支",{"$f":"C359-C364","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"営業収入",{"$f":"SUM(C360:C363)","v":0},{"$f":"SUM(D360:D363)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"現金売上"]
[null,"掛回収"]
[]
[]
[null,"営業支出",{"$f":"SUM(C365:C389)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入"]
[null,"掛支払"]
[]
[null,{"$f":"B236","v":0}]
[null,{"$f":"B237","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[null,{"$f":"B256","v":0}]
[null,{"$f":"B260","v":"法人税等"}]
[]
[null,"投資収支",{"$f":"-C393","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"投資支出",{"$f":"SUM(C394:C402)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B38","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[null,"財務収支",{"$f":"C406-C413","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"財務収入",{"$f":"SUM(C407:C411)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[null,"財務支出",{"$f":"SUM(C414:C418)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[null,"キャッシュフロー",{"$f":"SUM(C357,C391,C404)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"現金預金月末残高",{"$f":"SUM(C355,C420)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"(翌月に繰り越し)"]
[]
[]
[null,"①の減価償却費計算で設定した設備投資支出",null,null,"②の借入条件で設定した財務収支と支払利息",null,null,null,null,"決算月に応じた税金支払月と税額"]
[]
[null,"設備の種類","購入金額",null,null,"融資希望額","借入期間(年)","年利",null,"決算月",{"$f":"C111","v":"2026-06-01"},{"$f":"D111","v":"2026-07-01"},{"$f":"E111","v":"2026-08-01"},{"$f":"F111","v":"2026-09-01"}]
[null,{"$f":"B38","v":0},0,null,"借入条件",{"$f":"C66","v":0},{"$f":"D66","v":0},{"$f":"E66","v":0},null,"支払月",{"$f":"DATE(YEAR(K428),MONTH(K428)+2,1)","v":"2026-08-01"},{"$f":"DATE(YEAR(L428),MONTH(L428)+2,1)","v":"2026-09-01"},"2026-10-01","2026-11-01"]
[null,0,0,null,null,null,null,null,null,{"$f":"G92","v":"法人税等"},{"$f":"IF(SUM(C259)<=0,0,SUM(C259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:D259)<=0,0,SUM($C$259:D259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:E259)<=0,0,SUM($C$259:E259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:F259)<=0,0,SUM($C$259:F259)*$G$93)","v":0}]
[null,0,0,null,null,null,null,null,null,"決算月",{"$f":"G111","v":"2026-10-01"},{"$f":"H111","v":"2026-11-01"},{"$f":"C113","v":"2026-12-01"},{"$f":"D113","v":"2027-01-01"}]
[null,0,0,null,null,"年間","ひと月あたり返済","据置期間（ヶ月）",null,"支払月",{"$f":"DATE(YEAR(K431),MONTH(K431)+2,1)","v":"2026-12-01"},{"$f":"DATE(YEAR(L431),MONTH(L431)+2,1)","v":"2027-01-01"},{"$f":"DATE(YEAR(M431),MONTH(M431)+2,1)","v":"2027-02-01"},{"$f":"DATE(YEAR(N431),MONTH(N431)+2,1)","v":"2027-03-01"}]
[null,0,0,null,"元本返済額",{"$f":"C77","v":0},{"$f":"F77","v":0},{"$f":"F66","v":0},null,{"$f":"J430","v":"法人税等"},{"$f":"IF(SUM($C$259:G259)<=0,0,SUM($C$259:G259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:H259)<=0,0,SUM($C$259:H259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:I259)<=0,0,SUM($C$259:I259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:J259)<=0,0,SUM($C$259:J259)*$G$93)","v":0}]
[null,0,0,null,null,null,null,null,null,"決算月",{"$f":"E113","v":"2027-02-01"},{"$f":"F113","v":"2027-03-01"},{"$f":"G113","v":"2027-04-01"},{"$f":"H113","v":"2027-05-01"}]
[null,0,0,null,null,null,null,null,null,"支払月",{"$f":"DATE(YEAR(K434),MONTH(K434)+2,1)","v":"2027-04-01"},{"$f":"DATE(YEAR(L434),MONTH(L434)+2,1)","v":"2027-05-01"},{"$f":"DATE(YEAR(M434),MONTH(M434)+2,1)","v":"2027-06-01"},{"$f":"DATE(YEAR(N434),MONTH(N434)+2,1)","v":"2027-07-01"}]
[null,0,0,null,null,"年間","ひと月あたり支払",null,null,{"$f":"J433","v":"法人税等"},{"$f":"IF(SUM($C$259:K259)<=0,0,SUM($C$259:K259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:L259)<=0,0,SUM($C$259:L259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:M259)<=0,0,SUM($C$259:M259)*$G$93)","v":0},{"$f":"IF(SUM($C$259:N259)<=0,0,SUM($C$259:N259)*$G$93)","v":0}]
[null,0,0,null,"支払利息",{"$f":"C70","v":0},{"$f":"D70","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["その他の資金繰り調整(リセット用)→触ると上手く動かなくなります。"]
[{"$f":"$A$3","v":"単位：円"},null,"開業"]
[null,"月次","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01"]
[null,"現金預金月初残高",null,{"$f":"C611","v":0},{"$f":"D611","v":0},{"$f":"E611","v":0},{"$f":"F611","v":0},{"$f":"G611","v":0},{"$f":"H611","v":0},{"$f":"I611","v":0},{"$f":"J611","v":0},{"$f":"K611","v":0},{"$f":"L611","v":0},{"$f":"M611","v":0}]
[]
[null,"営業収支",{"$f":"C548-C553","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"営業収入",{"$f":"SUM(C549:C552)","v":0},{"$f":"SUM(D549:D552)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"現金売上"]
[null,"掛回収"]
[]
[]
[null,"営業支出",{"$f":"SUM(C554:C578)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"現金仕入"]
[null,"掛支払"]
[]
[null,{"$f":"B368","v":0}]
[null,{"$f":"B369","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,"法人税等"]
[]
[null,"投資収支",{"$f":"-C582","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"投資支出"]
[null,{"$f":"B394","v":0}]
[null,{"$f":"B395","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[null,"財務収支",{"$f":"C595-C602","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"キャッシュフロー",{"$f":"SUM(C546,C580,C593)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"現金預金月末残高",{"$f":"SUM(C544,C609)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"(翌月に繰り越し)"]