{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["収支予想表・償還計画表","収支予想表・償還計画表【記入】","Sheet1","収支予想表・償還計画表【記入例】"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":2,"defined_names":27,"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":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,18,50,25],[14,18,16,18],[17,18,19,18],[44,17,50,17],[21,17,26,17],[20,17,20,19],[28,17,33,17],[34,17,36,17],[28,18,30,18],[31,18,33,18],[34,18,36,18],[37,18,37,19],[38,18,38,19],[39,18,39,19],[40,18,40,19],[41,18,41,19],[42,18,42,19],[37,17,42,17],[21,1,22,2],[21,18,21,19],[22,18,22,19],[23,18,23,19],[24,18,24,19],[25,1,26,2],[25,18,25,19],[26,18,26,19],[27,1,28,2],[29,1,30,2],[31,1,32,2],[33,1,34,2],[35,1,36,2],[19,1,20,2],[1,13,1,15],[1,24,1,25],[3,12,3,13],[5,1,6,2],[7,1,8,2],[9,1,10,2],[5,17,19,17],[5,18,7,18],[8,18,10,18],[11,18,13,18],[11,1,11,2],[12,1,12,2],[13,2,14,2],[15,2,16,2],[17,1,18,2]]}
[]
[null,"収支予想表",null,null,null,null,null,null,null,null,null,null,"作成日：",null,null,null,null,"償還計画表",null,null,null,null,null,"お取引先名：",null,null,null,2,"千円"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"百万円"]
[null,null,null,null,null,null,null,null,null,null,null,null,"金額単位：",null,"百万円",null,null,null,null,null,null,null,null,null,"金額単位：","百万円"]
[null,null,"　","年度","直近期","比率",null,"比率",null,"比率",null,"比率",null,"比率",null,"比率",null,null,null,null,"直近期",{"$f":"IF(ISBLANK(G5),\"\",G5)","v":""},{"$f":"IF(ISBLANK(I5),\"\",I5)","v":""},{"$f":"IF(ISBLANK(K5),\"\",K5)","v":""},{"$f":"IF(ISBLANK(M5),\"\",M5)","v":""},{"$f":"IF(ISBLANK(O5),\"\",O5)","v":""}]
[null,"売 上 高",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E6)=TRUE,E$6<>\"\"),E6/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G6)=TRUE,G$6<>\"\"),G6/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I6)=TRUE,I$6<>\"\"),I6/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K6)=TRUE,K$6<>\"\"),K6/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M6)=TRUE,M$6<>\"\"),M6/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O6)=TRUE,O$6<>\"\"),O6/O$6*100,\"\")","v":""},null,"償還原資","当期利益","（計画）",{"$f":"IF(ISNUMBER(E34)=TRUE,E34,\"\")","v":""},{"$f":"IF(ISNUMBER(G34)=TRUE,G34,\"\")","v":""},{"$f":"IF(ISNUMBER(I34)=TRUE,I34,\"\")","v":""},{"$f":"IF(ISNUMBER(K34)=TRUE,K34,\"\")","v":""},{"$f":"IF(ISNUMBER(M34)=TRUE,M34,\"\")","v":""},{"$f":"IF(ISNUMBER(O34)=TRUE,O34,\"\")","v":""}]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E7)=TRUE,E$7<>\"\"),E7/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G7)=TRUE,G$7<>\"\"),G7/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I7)=TRUE,I$7<>\"\"),I7/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K7)=TRUE,K$7<>\"\"),K7/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M7)=TRUE,M$7<>\"\"),M7/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O7)=TRUE,O$7<>\"\"),O7/O$7*100,\"\")","v":""},null,null,null,"（実績）",{"$f":"IF(ISNUMBER(E35)=TRUE,E35,\"\")","v":""},{"$f":"IF(ISNUMBER(G35)=TRUE,G35,\"\")","v":""},{"$f":"IF(ISNUMBER(I35)=TRUE,I35,\"\")","v":""},{"$f":"IF(ISNUMBER(K35)=TRUE,K35,\"\")","v":""},{"$f":"IF(ISNUMBER(M35)=TRUE,M35,\"\")","v":""},{"$f":"IF(ISNUMBER(O35)=TRUE,O35,\"\")","v":""}]
[null,"　売上原価",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E8)=TRUE,E$6<>\"\"),E8/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G8)=TRUE,G$6<>\"\"),G8/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I8)=TRUE,I$6<>\"\"),I8/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K8)=TRUE,K$6<>\"\"),K8/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M8)=TRUE,M$6<>\"\"),M8/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O8)=TRUE,O$6<>\"\"),O8/O$6*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U7),ISNUMBER(U6))=TRUE,U7-U6,\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E9)=TRUE,E$7<>\"\"),E9/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G9)=TRUE,G$7<>\"\"),G9/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I9)=TRUE,I$7<>\"\"),I9/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K9)=TRUE,K$7<>\"\"),K9/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M9)=TRUE,M$7<>\"\"),M9/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O9)=TRUE,O$7<>\"\"),O9/O$7*100,\"\")","v":""},null,null,"配当・役員賞与","（計画）"]
[null," 売上総利益",null,"（予想）",{"$f":"IF(E6=\"\",\"\",E6-E8)","v":""},{"$f":"IF(AND(ISNUMBER(E10)=TRUE,E$6<>\"\"),E10/E$6*100,\"\")","v":""},{"$f":"IF(G6=\"\",\"\",G6-G8)","v":""},{"$f":"IF(AND(ISNUMBER(G10)=TRUE,G$6<>\"\"),G10/G$6*100,\"\")","v":""},{"$f":"IF(I6=\"\",\"\",I6-I8)","v":""},{"$f":"IF(AND(ISNUMBER(I10)=TRUE,I$6<>\"\"),I10/I$6*100,\"\")","v":""},{"$f":"IF(K6=\"\",\"\",K6-K8)","v":""},{"$f":"IF(AND(ISNUMBER(K10)=TRUE,K$6<>\"\"),K10/K$6*100,\"\")","v":""},{"$f":"IF(M6=\"\",\"\",M6-M8)","v":""},{"$f":"IF(AND(ISNUMBER(M10)=TRUE,M$6<>\"\"),M10/M$6*100,\"\")","v":""},{"$f":"IF(O6=\"\",\"\",O6-O8)","v":""},{"$f":"IF(AND(ISNUMBER(O10)=TRUE,O$6<>\"\"),O10/O$6*100,\"\")","v":""},null,null,null,"（実績）"]
[null,null,null,"（実績）",{"$f":"IF(E7=\"\",\"\",E7-E9)","v":""},{"$f":"IF(AND(ISNUMBER(E11)=TRUE,E$7<>\"\"),E11/E$7*100,\"\")","v":""},{"$f":"IF(G7=\"\",\"\",G7-G9)","v":""},{"$f":"IF(AND(ISNUMBER(G11)=TRUE,G$7<>\"\"),G11/G$7*100,\"\")","v":""},{"$f":"IF(I7=\"\",\"\",I7-I9)","v":""},{"$f":"IF(AND(ISNUMBER(I11)=TRUE,I$7<>\"\"),I11/I$7*100,\"\")","v":""},{"$f":"IF(K7=\"\",\"\",K7-K9)","v":""},{"$f":"IF(AND(ISNUMBER(K11)=TRUE,K$7<>\"\"),K11/K$7*100,\"\")","v":""},{"$f":"IF(M7=\"\",\"\",M7-M9)","v":""},{"$f":"IF(AND(ISNUMBER(M11)=TRUE,M$7<>\"\"),M11/M$7*100,\"\")","v":""},{"$f":"IF(O7=\"\",\"\",O7-O9)","v":""},{"$f":"IF(AND(ISNUMBER(O11)=TRUE,O$7<>\"\"),O11/O$7*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U10),ISNUMBER(U9))=TRUE,U10-U9,\"\")","v":""},"","","","",""]
[null,"販売費及び",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E12)=TRUE,E$6<>\"\"),E12/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G12)=TRUE,G$6<>\"\"),G12/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I12)=TRUE,I$6<>\"\"),I12/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K12)=TRUE,K$6<>\"\"),K12/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M12)=TRUE,M$6<>\"\"),M12/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O12)=TRUE,O$6<>\"\"),O12/O$6*100,\"\")","v":""},null,null,"減価償却費","（計画）",{"$f":"IF(ISNUMBER(E36)=TRUE,E36,\"\")","v":""},{"$f":"IF(ISNUMBER(G36)=TRUE,G36,\"\")","v":""},{"$f":"IF(ISNUMBER(I36)=TRUE,I36,\"\")","v":""},{"$f":"IF(ISNUMBER(K36)=TRUE,K36,\"\")","v":""},{"$f":"IF(ISNUMBER(M36)=TRUE,M36,\"\")","v":""},{"$f":"IF(ISNUMBER(O36)=TRUE,O36,\"\")","v":""}]
[null,"一般管理費",null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E13)=TRUE,E$7<>\"\"),E13/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G13)=TRUE,G$7<>\"\"),G13/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I13)=TRUE,I$7<>\"\"),I13/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K13)=TRUE,K$7<>\"\"),K13/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M13)=TRUE,M$7<>\"\"),M13/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O13)=TRUE,O$7<>\"\"),O13/O$7*100,\"\")","v":""},null,null,null,"（実績）",{"$f":"IF(ISNUMBER(E37)=TRUE,E37,\"\")","v":""},{"$f":"IF(ISNUMBER(G37)=TRUE,G37,\"\")","v":""},{"$f":"IF(ISNUMBER(I37)=TRUE,I37,\"\")","v":""},{"$f":"IF(ISNUMBER(K37)=TRUE,K37,\"\")","v":""},{"$f":"IF(ISNUMBER(M37)=TRUE,M37,\"\")","v":""},{"$f":"IF(ISNUMBER(O37)=TRUE,O37,\"\")","v":""}]
[null,null,"うち人件費","（予想）",null,{"$f":"IF(AND(ISNUMBER(E14)=TRUE,E$6<>\"\"),E14/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G14)=TRUE,G$6<>\"\"),G14/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I14)=TRUE,I$6<>\"\"),I14/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K14)=TRUE,K$6<>\"\"),K14/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M14)=TRUE,M$6<>\"\"),M14/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O14)=TRUE,O$6<>\"\"),O14/O$6*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U13),ISNUMBER(U12))=TRUE,U13-U12,\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E15)=TRUE,E$7<>\"\"),E15/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G15)=TRUE,G$7<>\"\"),G15/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I15)=TRUE,I$7<>\"\"),I15/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K15)=TRUE,K$7<>\"\"),K15/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M15)=TRUE,M$7<>\"\"),M15/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O15)=TRUE,O$7<>\"\"),O15/O$7*100,\"\")","v":""},null,null,null,"（計画）"]
[null,null,"うちリース料","（予想）",null,{"$f":"IF(AND(ISNUMBER(E16)=TRUE,E$6<>\"\"),E16/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G16)=TRUE,G$6<>\"\"),G16/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I16)=TRUE,I$6<>\"\"),I16/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K16)=TRUE,K$6<>\"\"),K16/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M16)=TRUE,M$6<>\"\"),M16/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O16)=TRUE,O$6<>\"\"),O16/O$6*100,\"\")","v":""},null,null,null,"（実績）"]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E17)=TRUE,E$7<>\"\"),E17/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G17)=TRUE,G$7<>\"\"),G17/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I17)=TRUE,I$7<>\"\"),I17/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K17)=TRUE,K$7<>\"\"),K17/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M17)=TRUE,M$7<>\"\"),M17/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O17)=TRUE,O$7<>\"\"),O17/O$7*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U16),ISNUMBER(U15))=TRUE,U16-U15,\"\")","v":""},"","","","",""]
[null," 営業利益",null,"（予想）",{"$f":"IF(E10=\"\",\"\",E10-E12)","v":""},{"$f":"IF(AND(ISNUMBER(E18)=TRUE,E$6<>\"\"),E18/E$6*100,\"\")","v":""},{"$f":"IF(G10=\"\",\"\",G10-G12)","v":""},{"$f":"IF(AND(ISNUMBER(G18)=TRUE,G$6<>\"\"),G18/G$6*100,\"\")","v":""},{"$f":"IF(I10=\"\",\"\",I10-I12)","v":""},{"$f":"IF(AND(ISNUMBER(I18)=TRUE,I$6<>\"\"),I18/I$6*100,\"\")","v":""},{"$f":"IF(K10=\"\",\"\",K10-K12)","v":""},{"$f":"IF(AND(ISNUMBER(K18)=TRUE,K$6<>\"\"),K18/K$6*100,\"\")","v":""},{"$f":"IF(M10=\"\",\"\",M10-M12)","v":""},{"$f":"IF(AND(ISNUMBER(M18)=TRUE,M$6<>\"\"),M18/M$6*100,\"\")","v":""},{"$f":"IF(O10=\"\",\"\",O10-O12)","v":""},{"$f":"IF(AND(ISNUMBER(O18)=TRUE,O$6<>\"\"),O18/O$6*100,\"\")","v":""},null,null,"（ア）合　計","（計画）",{"$f":"IF(OR(ISNUMBER(U6),ISNUMBER(U9),ISNUMBER(U12),ISNUMBER(U15))=TRUE,(SUM(U6,-U9,U12,U15)),\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",{"$f":"IF(E11=\"\",\"\",E11-E13)","v":""},{"$f":"IF(AND(ISNUMBER(E19)=TRUE,E$7<>\"\"),E19/E$7*100,\"\")","v":""},{"$f":"IF(G11=\"\",\"\",G11-G13)","v":""},{"$f":"IF(AND(ISNUMBER(G19)=TRUE,G$7<>\"\"),G19/G$7*100,\"\")","v":""},{"$f":"IF(I11=\"\",\"\",I11-I13)","v":""},{"$f":"IF(AND(ISNUMBER(I19)=TRUE,I$7<>\"\"),I19/I$7*100,\"\")","v":""},{"$f":"IF(K11=\"\",\"\",K11-K13)","v":""},{"$f":"IF(AND(ISNUMBER(K19)=TRUE,K$7<>\"\"),K19/K$7*100,\"\")","v":""},{"$f":"IF(M11=\"\",\"\",M11-M13)","v":""},{"$f":"IF(AND(ISNUMBER(M19)=TRUE,M$7<>\"\"),M19/M$7*100,\"\")","v":""},{"$f":"IF(O11=\"\",\"\",O11-O13)","v":""},{"$f":"IF(AND(ISNUMBER(O19)=TRUE,O$7<>\"\"),O19/O$7*100,\"\")","v":""},null,null,null,"（実績）","","","","","",""]
[null," 営業外収益",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E20)=TRUE,E$6<>\"\"),E20/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G20)=TRUE,G$6<>\"\"),G20/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I20)=TRUE,I$6<>\"\"),I20/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K20)=TRUE,K$6<>\"\"),K20/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M20)=TRUE,M$6<>\"\"),M20/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O20)=TRUE,O$6<>\"\"),O20/O$6*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U19),ISNUMBER(U18))=TRUE,U19-U18,\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E21)=TRUE,E$7<>\"\"),E21/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G21)=TRUE,G$7<>\"\"),G21/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I21)=TRUE,I$7<>\"\"),I21/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K21)=TRUE,K$7<>\"\"),K21/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M21)=TRUE,M$7<>\"\"),M21/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O21)=TRUE,O$7<>\"\"),O21/O$7*100,\"\")","v":""},null,"長期借入金の年間返済額"]
[null," 営業外費用",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E22)=TRUE,E$6<>\"\"),E22/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G22)=TRUE,G$6<>\"\"),G22/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I22)=TRUE,I$6<>\"\"),I22/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K22)=TRUE,K$6<>\"\"),K22/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M22)=TRUE,M$6<>\"\"),M22/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O22)=TRUE,O$6<>\"\"),O22/O$6*100,\"\")","v":""},null,"金融機関名"]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E23)=TRUE,E$7<>\"\"),E23/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G23)=TRUE,G$7<>\"\"),G23/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I23)=TRUE,I$7<>\"\"),I23/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K23)=TRUE,K$7<>\"\"),K23/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M23)=TRUE,M$7<>\"\"),M23/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O23)=TRUE,O$7<>\"\"),O23/O$7*100,\"\")","v":""}]
[null,null,"うち支払利息","（予想）",null,{"$f":"IF(AND(ISNUMBER(E24)=TRUE,E$6<>\"\"),E24/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G24)=TRUE,G$6<>\"\"),G24/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I24)=TRUE,I$6<>\"\"),I24/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K24)=TRUE,K$6<>\"\"),K24/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M24)=TRUE,M$6<>\"\"),M24/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O24)=TRUE,O$6<>\"\"),O24/O$6*100,\"\")","v":""}]
[null,null,"割引料 ","（実績）",null,{"$f":"IF(AND(ISNUMBER(E25)=TRUE,E$7<>\"\"),E25/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G25)=TRUE,G$7<>\"\"),G25/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I25)=TRUE,I$7<>\"\"),I25/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K25)=TRUE,K$7<>\"\"),K25/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M25)=TRUE,M$7<>\"\"),M25/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O25)=TRUE,O$7<>\"\"),O25/O$7*100,\"\")","v":""}]
[null,"　経常利益",null,"（予想）",{"$f":"IF(E18=\"\",\"\",E18+E20-E22)","v":""},{"$f":"IF(AND(ISNUMBER(E26)=TRUE,E$6<>\"\"),E26/E$6*100,\"\")","v":""},{"$f":"IF(G18=\"\",\"\",G18+G20-G22)","v":""},{"$f":"IF(AND(ISNUMBER(G26)=TRUE,G$6<>\"\"),G26/G$6*100,\"\")","v":""},{"$f":"IF(I18=\"\",\"\",I18+I20-I22)","v":""},{"$f":"IF(AND(ISNUMBER(I26)=TRUE,I$6<>\"\"),I26/I$6*100,\"\")","v":""},{"$f":"IF(K18=\"\",\"\",K18+K20-K22)","v":""},{"$f":"IF(AND(ISNUMBER(K26)=TRUE,K$6<>\"\"),K26/K$6*100,\"\")","v":""},{"$f":"IF(M18=\"\",\"\",M18+M20-M22)","v":""},{"$f":"IF(AND(ISNUMBER(M26)=TRUE,M$6<>\"\"),M26/M$6*100,\"\")","v":""},{"$f":"IF(O18=\"\",\"\",O18+O20-O22)","v":""},{"$f":"IF(AND(ISNUMBER(O26)=TRUE,O$6<>\"\"),O26/O$6*100,\"\")","v":""}]
[null,null,null,"（実績）",{"$f":"IF(E19=\"\",\"\",E19+E21-E23)","v":""},{"$f":"IF(AND(ISNUMBER(E27)=TRUE,E$7<>\"\"),E27/E$7*100,\"\")","v":""},{"$f":"IF(G19=\"\",\"\",G19+G21-G23)","v":""},{"$f":"IF(AND(ISNUMBER(G27)=TRUE,G$7<>\"\"),G27/G$7*100,\"\")","v":""},{"$f":"IF(I19=\"\",\"\",I19+I21-I23)","v":""},{"$f":"IF(AND(ISNUMBER(I27)=TRUE,I$7<>\"\"),I27/I$7*100,\"\")","v":""},{"$f":"IF(K19=\"\",\"\",K19+K21-K23)","v":""},{"$f":"IF(AND(ISNUMBER(K27)=TRUE,K$7<>\"\"),K27/K$7*100,\"\")","v":""},{"$f":"IF(M19=\"\",\"\",M19+M21-M23)","v":""},{"$f":"IF(AND(ISNUMBER(M27)=TRUE,M$7<>\"\"),M27/M$7*100,\"\")","v":""},{"$f":"IF(O19=\"\",\"\",O19+O21-O23)","v":""},{"$f":"IF(AND(ISNUMBER(O27)=TRUE,O$7<>\"\"),O27/O$7*100,\"\")","v":""}]
[null,"　特別損益",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E28)=TRUE,E$6<>\"\"),E28/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G28)=TRUE,G$6<>\"\"),G28/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I28)=TRUE,I$6<>\"\"),I28/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K28)=TRUE,K$6<>\"\"),K28/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M28)=TRUE,M$6<>\"\"),M28/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O28)=TRUE,O$6<>\"\"),O28/O$6*100,\"\")","v":""},null,null,"（イ）合　計",null,{"$f":"SUM(U22:U27)","v":0},0,0,0,0,0]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E29)=TRUE,E$7<>\"\"),E29/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G29)=TRUE,G$7<>\"\"),G29/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I29)=TRUE,I$7<>\"\"),I29/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K29)=TRUE,K$7<>\"\"),K29/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M29)=TRUE,M$7<>\"\"),M29/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O29)=TRUE,O$7<>\"\"),O29/O$7*100,\"\")","v":""},null,"償還計画","（ア）償還源資","（計画）",{"$f":"IF(ISNUMBER(U18)=TRUE,U18,\"\")","v":""},"","","","",""]
[null,"税引前当期利益",null,"（予想）",{"$f":"IF(E26=\"\",\"\",E26+E28)","v":""},{"$f":"IF(AND(ISNUMBER(E30)=TRUE,E$6<>\"\"),E30/E$6*100,\"\")","v":""},{"$f":"IF(G26=\"\",\"\",G26+G28)","v":""},{"$f":"IF(AND(ISNUMBER(G30)=TRUE,G$6<>\"\"),G30/G$6*100,\"\")","v":""},{"$f":"IF(I26=\"\",\"\",I26+I28)","v":""},{"$f":"IF(AND(ISNUMBER(I30)=TRUE,I$6<>\"\"),I30/I$6*100,\"\")","v":""},{"$f":"IF(K26=\"\",\"\",K26+K28)","v":""},{"$f":"IF(AND(ISNUMBER(K30)=TRUE,K$6<>\"\"),K30/K$6*100,\"\")","v":""},{"$f":"IF(M26=\"\",\"\",M26+M28)","v":""},{"$f":"IF(AND(ISNUMBER(M30)=TRUE,M$6<>\"\"),M30/M$6*100,\"\")","v":""},{"$f":"IF(O26=\"\",\"\",O26+O28)","v":""},{"$f":"IF(AND(ISNUMBER(O30)=TRUE,O$6<>\"\"),O30/O$6*100,\"\")","v":""},null,null,null,"（実績）","","","","","",""]
[null,null,null,"（実績）",{"$f":"IF(E27=\"\",\"\",E27+E29)","v":""},{"$f":"IF(AND(ISNUMBER(E31)=TRUE,E$7<>\"\"),E31/E$7*100,\"\")","v":""},{"$f":"IF(G27=\"\",\"\",G27+G29)","v":""},{"$f":"IF(AND(ISNUMBER(G31)=TRUE,G$7<>\"\"),G31/G$7*100,\"\")","v":""},{"$f":"IF(I27=\"\",\"\",I27+I29)","v":""},{"$f":"IF(AND(ISNUMBER(I31)=TRUE,I$7<>\"\"),I31/I$7*100,\"\")","v":""},{"$f":"IF(K27=\"\",\"\",K27+K29)","v":""},{"$f":"IF(AND(ISNUMBER(K31)=TRUE,K$7<>\"\"),K31/K$7*100,\"\")","v":""},{"$f":"IF(M27=\"\",\"\",M27+M29)","v":""},{"$f":"IF(AND(ISNUMBER(M31)=TRUE,M$7<>\"\"),M31/M$7*100,\"\")","v":""},{"$f":"IF(O27=\"\",\"\",O27+O29)","v":""},{"$f":"IF(AND(ISNUMBER(O31)=TRUE,O$7<>\"\"),O31/O$7*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U30),ISNUMBER(U29))=TRUE,U30-U29,\"\")","v":""},"","","","",""]
[null,"　税　　金",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E32)=TRUE,E$6<>\"\"),E32/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G32)=TRUE,G$6<>\"\"),G32/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I32)=TRUE,I$6<>\"\"),I32/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K32)=TRUE,K$6<>\"\"),K32/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M32)=TRUE,M$6<>\"\"),M32/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O32)=TRUE,O$6<>\"\"),O32/O$6*100,\"\")","v":""},null,null,"（イ）要償還額","（計画）",null,{"$f":"IF(ISNUMBER(V28)=TRUE,V28,\"\")","v":0},{"$f":"IF(ISNUMBER(W28)=TRUE,W28,\"\")","v":0},{"$f":"IF(ISNUMBER(X28)=TRUE,X28,\"\")","v":0},{"$f":"IF(ISNUMBER(Y28)=TRUE,Y28,\"\")","v":0},{"$f":"IF(ISNUMBER(Z28)=TRUE,Z28,\"\")","v":0}]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E33)=TRUE,E$7<>\"\"),E33/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G33)=TRUE,G$7<>\"\"),G33/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I33)=TRUE,I$7<>\"\"),I33/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K33)=TRUE,K$7<>\"\"),K33/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M33)=TRUE,M$7<>\"\"),M33/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O33)=TRUE,O$7<>\"\"),O33/O$7*100,\"\")","v":""},null,null,null,"（実績）",{"$f":"IF(ISNUMBER(U28)=TRUE,U28,\"\")","v":0}]
[null," 当期利益",null,"（予想）",{"$f":"IF(E30=\"\",\"\",E30-E32)","v":""},{"$f":"IF(AND(ISNUMBER(E34)=TRUE,E$6<>\"\"),E34/E$6*100,\"\")","v":""},{"$f":"IF(G30=\"\",\"\",G30-G32)","v":""},{"$f":"IF(AND(ISNUMBER(G34)=TRUE,G$6<>\"\"),G34/G$6*100,\"\")","v":""},{"$f":"IF(I30=\"\",\"\",I30-I32)","v":""},{"$f":"IF(AND(ISNUMBER(I34)=TRUE,I$6<>\"\"),I34/I$6*100,\"\")","v":""},{"$f":"IF(K30=\"\",\"\",K30-K32)","v":""},{"$f":"IF(AND(ISNUMBER(K34)=TRUE,K$6<>\"\"),K34/K$6*100,\"\")","v":""},{"$f":"IF(M30=\"\",\"\",M30-M32)","v":""},{"$f":"IF(AND(ISNUMBER(M34)=TRUE,M$6<>\"\"),M34/M$6*100,\"\")","v":""},{"$f":"IF(O30=\"\",\"\",O30-O32)","v":""},{"$f":"IF(AND(ISNUMBER(O34)=TRUE,O$6<>\"\"),O34/O$6*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U33),ISNUMBER(U32))=TRUE,U33-U32,\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",{"$f":"IF(E31=\"\",\"\",E31-E33)","v":""},{"$f":"IF(AND(ISNUMBER(E35)=TRUE,E$7<>\"\"),E35/E$7*100,\"\")","v":""},{"$f":"IF(G31=\"\",\"\",G31-G33)","v":""},{"$f":"IF(AND(ISNUMBER(G35)=TRUE,G$7<>\"\"),G35/G$7*100,\"\")","v":""},{"$f":"IF(I31=\"\",\"\",I31-I33)","v":""},{"$f":"IF(AND(ISNUMBER(I35)=TRUE,I$7<>\"\"),I35/I$7*100,\"\")","v":""},{"$f":"IF(K31=\"\",\"\",K31-K33)","v":""},{"$f":"IF(AND(ISNUMBER(K35)=TRUE,K$7<>\"\"),K35/K$7*100,\"\")","v":""},{"$f":"IF(M31=\"\",\"\",M31-M33)","v":""},{"$f":"IF(AND(ISNUMBER(M35)=TRUE,M$7<>\"\"),M35/M$7*100,\"\")","v":""},{"$f":"IF(O31=\"\",\"\",O31-O33)","v":""},{"$f":"IF(AND(ISNUMBER(O35)=TRUE,O$7<>\"\"),O35/O$7*100,\"\")","v":""},null,"余　力","差　引","（計画）",{"$f":"IF(AND(U29<>\"\",U32<>\"\"),U29-U32,\"\")","v":""},"","","","",""]
[null,"減価償却費",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E36)=TRUE,E$6<>\"\"),E36/E$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G36)=TRUE,G$6<>\"\"),G36/G$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I36)=TRUE,I$6<>\"\"),I36/I$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K36)=TRUE,K$6<>\"\"),K36/K$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M36)=TRUE,M$6<>\"\"),M36/M$6*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O36)=TRUE,O$6<>\"\"),O36/O$6*100,\"\")","v":""},null,null,null,"（実績）","","","","","",""]
[null,null,null,"（実績）",null,{"$f":"IF(AND(ISNUMBER(E37)=TRUE,E$7<>\"\"),E37/E$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(G37)=TRUE,G$7<>\"\"),G37/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I37)=TRUE,I$7<>\"\"),I37/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K37)=TRUE,K$7<>\"\"),K37/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M37)=TRUE,M$7<>\"\"),M37/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O37)=TRUE,O$7<>\"\"),O37/O$7*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U36),ISNUMBER(U35))=TRUE,U36-U35,\"\")","v":""},"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"長期借入金残高"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"特記事項"]

{"sheet":"収支予想表・償還計画表【記入】","index":1,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":true,"merged":[[42,18,42,19],[37,17,42,17],[44,17,50,17],[21,17,26,17],[20,17,20,19],[28,18,30,18],[31,18,33,18],[34,18,36,18],[28,17,33,17],[34,17,36,17],[38,18,38,19],[39,18,39,19],[40,18,40,19],[41,18,41,19],[37,18,37,19],[5,18,7,18],[8,18,10,18],[11,18,13,18],[17,18,19,18],[26,18,26,19],[21,18,21,19],[22,18,22,19],[23,18,23,19],[24,18,24,19],[25,18,25,19],[5,1,6,2],[12,1,12,2],[29,1,30,2],[31,1,32,2],[19,1,20,2],[1,24,1,25],[1,13,1,15],[3,12,3,13],[35,1,36,2],[13,2,14,2],[15,2,16,2],[21,1,22,2],[25,1,26,2],[17,1,18,2],[27,1,28,2],[5,17,19,17],[7,1,8,2],[33,1,34,2],[9,1,10,2],[11,1,11,2],[23,2,24,2]]}
[]
[null,"収支予想表",null,null,null,null,null,null,null,null,null,null,"作成日：","2021-04-01",null,null,null,"償還計画表",null,null,null,null,null,"お取引先名：","株式会社●●商会",null,null,2,"千円"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"百万円"]
[null,null,null,null,null,null,null,null,null,null,null,null,"金額単位：",null,"百万円",null,null,null,null,null,null,null,null,null,"金額単位：","百万円"]
[null,null,"　","年度","直近期","比率","2022-03-01","比率","2023-03-01","比率","2024-03-01","比率","2025-03-01","比率","2026-03-01","比率",null,null,null,null,"直近期",{"$f":"IF(ISBLANK(G5),\"\",G5)","v":"2022-03-01"},{"$f":"IF(ISBLANK(I5),\"\",I5)","v":"2023-03-01"},{"$f":"IF(ISBLANK(K5),\"\",K5)","v":"2024-03-01"},{"$f":"IF(ISBLANK(M5),\"\",M5)","v":"2025-03-01"},{"$f":"IF(ISBLANK(O5),\"\",O5)","v":"2026-03-01"}]
[null,"売 上 高",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E6)=TRUE,E$6<>\"\"),E6/E$6*100,\"\")","v":""},480,{"$f":"IF(AND(ISNUMBER(G6)=TRUE,G$6<>\"\"),G6/G$6*100,\"\")","v":100},480,{"$f":"IF(AND(ISNUMBER(I6)=TRUE,I$6<>\"\"),I6/I$6*100,\"\")","v":100},480,{"$f":"IF(AND(ISNUMBER(K6)=TRUE,K$6<>\"\"),K6/K$6*100,\"\")","v":100},480,{"$f":"IF(AND(ISNUMBER(M6)=TRUE,M$6<>\"\"),M6/M$6*100,\"\")","v":100},480,{"$f":"IF(AND(ISNUMBER(O6)=TRUE,O$6<>\"\"),O6/O$6*100,\"\")","v":100},null,"償還原資","当期利益","（計画）",{"$f":"IF(ISNUMBER(E34)=TRUE,E34,\"\")","v":""},{"$f":"IF(ISNUMBER(G34)=TRUE,G34,\"\")","v":24},{"$f":"IF(ISNUMBER(I34)=TRUE,I34,\"\")","v":28},{"$f":"IF(ISNUMBER(K34)=TRUE,K34,\"\")","v":32},{"$f":"IF(ISNUMBER(M34)=TRUE,M34,\"\")","v":32},{"$f":"IF(ISNUMBER(O34)=TRUE,O34,\"\")","v":34}]
[null,null,null,"（実績）",480,{"$f":"IF(AND(ISNUMBER(E7)=TRUE,E$7<>\"\"),E7/E$7*100,\"\")","v":100},null,{"$f":"IF(AND(ISNUMBER(G7)=TRUE,G$7<>\"\"),G7/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I7)=TRUE,I$7<>\"\"),I7/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K7)=TRUE,K$7<>\"\"),K7/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M7)=TRUE,M$7<>\"\"),M7/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O7)=TRUE,O$7<>\"\"),O7/O$7*100,\"\")","v":""},null,null,null,"（実績）",{"$f":"IF(ISNUMBER(E35)=TRUE,E35,\"\")","v":-5},{"$f":"IF(ISNUMBER(G35)=TRUE,G35,\"\")","v":""},{"$f":"IF(ISNUMBER(I35)=TRUE,I35,\"\")","v":""},{"$f":"IF(ISNUMBER(K35)=TRUE,K35,\"\")","v":""},{"$f":"IF(ISNUMBER(M35)=TRUE,M35,\"\")","v":""},{"$f":"IF(ISNUMBER(O35)=TRUE,O35,\"\")","v":""}]
[null,"　売上原価",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E8)=TRUE,E$6<>\"\"),E8/E$6*100,\"\")","v":""},320,{"$f":"IF(AND(ISNUMBER(G8)=TRUE,G$6<>\"\"),G8/G$6*100,\"\")","v":66.666666666666657},316,{"$f":"IF(AND(ISNUMBER(I8)=TRUE,I$6<>\"\"),I8/I$6*100,\"\")","v":65.833333333333329},313,{"$f":"IF(AND(ISNUMBER(K8)=TRUE,K$6<>\"\"),K8/K$6*100,\"\")","v":65.208333333333329},313,{"$f":"IF(AND(ISNUMBER(M8)=TRUE,M$6<>\"\"),M8/M$6*100,\"\")","v":65.208333333333329},313,{"$f":"IF(AND(ISNUMBER(O8)=TRUE,O$6<>\"\"),O8/O$6*100,\"\")","v":65.208333333333329},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U7),ISNUMBER(U6))=TRUE,U7-U6,\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",348,{"$f":"IF(AND(ISNUMBER(E9)=TRUE,E$7<>\"\"),E9/E$7*100,\"\")","v":72.5},null,{"$f":"IF(AND(ISNUMBER(G9)=TRUE,G$7<>\"\"),G9/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I9)=TRUE,I$7<>\"\"),I9/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K9)=TRUE,K$7<>\"\"),K9/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M9)=TRUE,M$7<>\"\"),M9/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O9)=TRUE,O$7<>\"\"),O9/O$7*100,\"\")","v":""},null,null,"配当・役員賞与","（計画）",null,0,0,0,0,0]
[null," 売上総利益",null,"（予想）",{"$f":"IF(E6=\"\",\"\",E6-E8)","v":""},{"$f":"IF(AND(ISNUMBER(E10)=TRUE,E$6<>\"\"),E10/E$6*100,\"\")","v":""},{"$f":"IF(G6=\"\",\"\",G6-G8)","v":160},{"$f":"IF(AND(ISNUMBER(G10)=TRUE,G$6<>\"\"),G10/G$6*100,\"\")","v":33.333333333333329},{"$f":"IF(I6=\"\",\"\",I6-I8)","v":164},{"$f":"IF(AND(ISNUMBER(I10)=TRUE,I$6<>\"\"),I10/I$6*100,\"\")","v":34.166666666666664},{"$f":"IF(K6=\"\",\"\",K6-K8)","v":167},{"$f":"IF(AND(ISNUMBER(K10)=TRUE,K$6<>\"\"),K10/K$6*100,\"\")","v":34.791666666666664},{"$f":"IF(M6=\"\",\"\",M6-M8)","v":167},{"$f":"IF(AND(ISNUMBER(M10)=TRUE,M$6<>\"\"),M10/M$6*100,\"\")","v":34.791666666666664},{"$f":"IF(O6=\"\",\"\",O6-O8)","v":167},{"$f":"IF(AND(ISNUMBER(O10)=TRUE,O$6<>\"\"),O10/O$6*100,\"\")","v":34.791666666666664},null,null,null,"（実績）",0]
[null,null,null,"（実績）",{"$f":"IF(E7=\"\",\"\",E7-E9)","v":132},{"$f":"IF(AND(ISNUMBER(E11)=TRUE,E$7<>\"\"),E11/E$7*100,\"\")","v":27.500000000000004},{"$f":"IF(G7=\"\",\"\",G7-G9)","v":""},{"$f":"IF(AND(ISNUMBER(G11)=TRUE,G$7<>\"\"),G11/G$7*100,\"\")","v":""},{"$f":"IF(I7=\"\",\"\",I7-I9)","v":""},{"$f":"IF(AND(ISNUMBER(I11)=TRUE,I$7<>\"\"),I11/I$7*100,\"\")","v":""},{"$f":"IF(K7=\"\",\"\",K7-K9)","v":""},{"$f":"IF(AND(ISNUMBER(K11)=TRUE,K$7<>\"\"),K11/K$7*100,\"\")","v":""},{"$f":"IF(M7=\"\",\"\",M7-M9)","v":""},{"$f":"IF(AND(ISNUMBER(M11)=TRUE,M$7<>\"\"),M11/M$7*100,\"\")","v":""},{"$f":"IF(O7=\"\",\"\",O7-O9)","v":""},{"$f":"IF(AND(ISNUMBER(O11)=TRUE,O$7<>\"\"),O11/O$7*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U10),ISNUMBER(U9))=TRUE,U10-U9,\"\")","v":""},"","","","",""]
[null,"販売費及び",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E12)=TRUE,E$6<>\"\"),E12/E$6*100,\"\")","v":""},126,{"$f":"IF(AND(ISNUMBER(G12)=TRUE,G$6<>\"\"),G12/G$6*100,\"\")","v":26.25},125,{"$f":"IF(AND(ISNUMBER(I12)=TRUE,I$6<>\"\"),I12/I$6*100,\"\")","v":26.041666666666668},125,{"$f":"IF(AND(ISNUMBER(K12)=TRUE,K$6<>\"\"),K12/K$6*100,\"\")","v":26.041666666666668},125,{"$f":"IF(AND(ISNUMBER(M12)=TRUE,M$6<>\"\"),M12/M$6*100,\"\")","v":26.041666666666668},124,{"$f":"IF(AND(ISNUMBER(O12)=TRUE,O$6<>\"\"),O12/O$6*100,\"\")","v":25.833333333333336},null,null,"減価償却費","（計画）",{"$f":"IF(ISNUMBER(E36)=TRUE,E36,\"\")","v":""},{"$f":"IF(ISNUMBER(G36)=TRUE,G36,\"\")","v":15},{"$f":"IF(ISNUMBER(I36)=TRUE,I36,\"\")","v":14},{"$f":"IF(ISNUMBER(K36)=TRUE,K36,\"\")","v":13},{"$f":"IF(ISNUMBER(M36)=TRUE,M36,\"\")","v":13},{"$f":"IF(ISNUMBER(O36)=TRUE,O36,\"\")","v":13}]
[null,"一般管理費",null,"（実績）",126,{"$f":"IF(AND(ISNUMBER(E13)=TRUE,E$7<>\"\"),E13/E$7*100,\"\")","v":26.25},null,{"$f":"IF(AND(ISNUMBER(G13)=TRUE,G$7<>\"\"),G13/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I13)=TRUE,I$7<>\"\"),I13/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K13)=TRUE,K$7<>\"\"),K13/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M13)=TRUE,M$7<>\"\"),M13/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O13)=TRUE,O$7<>\"\"),O13/O$7*100,\"\")","v":""},null,null,null,"（実績）",{"$f":"IF(ISNUMBER(E37)=TRUE,E37,\"\")","v":15},{"$f":"IF(ISNUMBER(G37)=TRUE,G37,\"\")","v":""},{"$f":"IF(ISNUMBER(I37)=TRUE,I37,\"\")","v":""},{"$f":"IF(ISNUMBER(K37)=TRUE,K37,\"\")","v":""},{"$f":"IF(ISNUMBER(M37)=TRUE,M37,\"\")","v":""},{"$f":"IF(ISNUMBER(O37)=TRUE,O37,\"\")","v":""}]
[null,null,"うち人件費","（予想）",null,{"$f":"IF(AND(ISNUMBER(E14)=TRUE,E$6<>\"\"),E14/E$6*100,\"\")","v":""},64,{"$f":"IF(AND(ISNUMBER(G14)=TRUE,G$6<>\"\"),G14/G$6*100,\"\")","v":13.333333333333334},64,{"$f":"IF(AND(ISNUMBER(I14)=TRUE,I$6<>\"\"),I14/I$6*100,\"\")","v":13.333333333333334},62,{"$f":"IF(AND(ISNUMBER(K14)=TRUE,K$6<>\"\"),K14/K$6*100,\"\")","v":12.916666666666668},63,{"$f":"IF(AND(ISNUMBER(M14)=TRUE,M$6<>\"\"),M14/M$6*100,\"\")","v":13.125},63,{"$f":"IF(AND(ISNUMBER(O14)=TRUE,O$6<>\"\"),O14/O$6*100,\"\")","v":13.125},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U13),ISNUMBER(U12))=TRUE,U13-U12,\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",65,{"$f":"IF(AND(ISNUMBER(E15)=TRUE,E$7<>\"\"),E15/E$7*100,\"\")","v":13.541666666666666},null,{"$f":"IF(AND(ISNUMBER(G15)=TRUE,G$7<>\"\"),G15/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I15)=TRUE,I$7<>\"\"),I15/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K15)=TRUE,K$7<>\"\"),K15/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M15)=TRUE,M$7<>\"\"),M15/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O15)=TRUE,O$7<>\"\"),O15/O$7*100,\"\")","v":""},null,null,null,"（計画）"]
[null,null,"うちリース料","（予想）",null,{"$f":"IF(AND(ISNUMBER(E16)=TRUE,E$6<>\"\"),E16/E$6*100,\"\")","v":""},0,{"$f":"IF(AND(ISNUMBER(G16)=TRUE,G$6<>\"\"),G16/G$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(I16)=TRUE,I$6<>\"\"),I16/I$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(K16)=TRUE,K$6<>\"\"),K16/K$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(M16)=TRUE,M$6<>\"\"),M16/M$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(O16)=TRUE,O$6<>\"\"),O16/O$6*100,\"\")","v":0},null,null,null,"（実績）"]
[null,null,null,"（実績）",0,{"$f":"IF(AND(ISNUMBER(E17)=TRUE,E$7<>\"\"),E17/E$7*100,\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(G17)=TRUE,G$7<>\"\"),G17/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I17)=TRUE,I$7<>\"\"),I17/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K17)=TRUE,K$7<>\"\"),K17/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M17)=TRUE,M$7<>\"\"),M17/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O17)=TRUE,O$7<>\"\"),O17/O$7*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U16),ISNUMBER(U15))=TRUE,U16-U15,\"\")","v":""},"","","","",""]
[null," 営業利益",null,"（予想）",{"$f":"IF(E10=\"\",\"\",E10-E12)","v":""},{"$f":"IF(AND(ISNUMBER(E18)=TRUE,E$6<>\"\"),E18/E$6*100,\"\")","v":""},{"$f":"IF(G10=\"\",\"\",G10-G12)","v":34},{"$f":"IF(AND(ISNUMBER(G18)=TRUE,G$6<>\"\"),G18/G$6*100,\"\")","v":7.083333333333333},{"$f":"IF(I10=\"\",\"\",I10-I12)","v":39},{"$f":"IF(AND(ISNUMBER(I18)=TRUE,I$6<>\"\"),I18/I$6*100,\"\")","v":8.125},{"$f":"IF(K10=\"\",\"\",K10-K12)","v":42},{"$f":"IF(AND(ISNUMBER(K18)=TRUE,K$6<>\"\"),K18/K$6*100,\"\")","v":8.75},{"$f":"IF(M10=\"\",\"\",M10-M12)","v":42},{"$f":"IF(AND(ISNUMBER(M18)=TRUE,M$6<>\"\"),M18/M$6*100,\"\")","v":8.75},{"$f":"IF(O10=\"\",\"\",O10-O12)","v":43},{"$f":"IF(AND(ISNUMBER(O18)=TRUE,O$6<>\"\"),O18/O$6*100,\"\")","v":8.9583333333333339},null,null,"（ア）合　計","（計画）",{"$f":"IF(OR(ISNUMBER(U6),ISNUMBER(U9),ISNUMBER(U12),ISNUMBER(U15))=TRUE,(SUM(U6,-U9,U12,U15)),\"\")","v":""},39,42,45,45,47]
[null,null,null,"（実績）",{"$f":"IF(E11=\"\",\"\",E11-E13)","v":6},{"$f":"IF(AND(ISNUMBER(E19)=TRUE,E$7<>\"\"),E19/E$7*100,\"\")","v":1.25},{"$f":"IF(G11=\"\",\"\",G11-G13)","v":""},{"$f":"IF(AND(ISNUMBER(G19)=TRUE,G$7<>\"\"),G19/G$7*100,\"\")","v":""},{"$f":"IF(I11=\"\",\"\",I11-I13)","v":""},{"$f":"IF(AND(ISNUMBER(I19)=TRUE,I$7<>\"\"),I19/I$7*100,\"\")","v":""},{"$f":"IF(K11=\"\",\"\",K11-K13)","v":""},{"$f":"IF(AND(ISNUMBER(K19)=TRUE,K$7<>\"\"),K19/K$7*100,\"\")","v":""},{"$f":"IF(M11=\"\",\"\",M11-M13)","v":""},{"$f":"IF(AND(ISNUMBER(M19)=TRUE,M$7<>\"\"),M19/M$7*100,\"\")","v":""},{"$f":"IF(O11=\"\",\"\",O11-O13)","v":""},{"$f":"IF(AND(ISNUMBER(O19)=TRUE,O$7<>\"\"),O19/O$7*100,\"\")","v":""},null,null,null,"（実績）",10,"","","","",""]
[null," 営業外収益",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E20)=TRUE,E$6<>\"\"),E20/E$6*100,\"\")","v":""},4,{"$f":"IF(AND(ISNUMBER(G20)=TRUE,G$6<>\"\"),G20/G$6*100,\"\")","v":0.83333333333333337},4,{"$f":"IF(AND(ISNUMBER(I20)=TRUE,I$6<>\"\"),I20/I$6*100,\"\")","v":0.83333333333333337},4,{"$f":"IF(AND(ISNUMBER(K20)=TRUE,K$6<>\"\"),K20/K$6*100,\"\")","v":0.83333333333333337},4,{"$f":"IF(AND(ISNUMBER(M20)=TRUE,M$6<>\"\"),M20/M$6*100,\"\")","v":0.83333333333333337},4,{"$f":"IF(AND(ISNUMBER(O20)=TRUE,O$6<>\"\"),O20/O$6*100,\"\")","v":0.83333333333333337},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U19),ISNUMBER(U18))=TRUE,U19-U18,\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",4,{"$f":"IF(AND(ISNUMBER(E21)=TRUE,E$7<>\"\"),E21/E$7*100,\"\")","v":0.83333333333333337},null,{"$f":"IF(AND(ISNUMBER(G21)=TRUE,G$7<>\"\"),G21/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I21)=TRUE,I$7<>\"\"),I21/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K21)=TRUE,K$7<>\"\"),K21/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M21)=TRUE,M$7<>\"\"),M21/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O21)=TRUE,O$7<>\"\"),O21/O$7*100,\"\")","v":""},null,"長期借入金の年間返済額"]
[null," 営業外費用",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E22)=TRUE,E$6<>\"\"),E22/E$6*100,\"\")","v":""},14,{"$f":"IF(AND(ISNUMBER(G22)=TRUE,G$6<>\"\"),G22/G$6*100,\"\")","v":2.9166666666666665},15,{"$f":"IF(AND(ISNUMBER(I22)=TRUE,I$6<>\"\"),I22/I$6*100,\"\")","v":3.125},14,{"$f":"IF(AND(ISNUMBER(K22)=TRUE,K$6<>\"\"),K22/K$6*100,\"\")","v":2.9166666666666665},14,{"$f":"IF(AND(ISNUMBER(M22)=TRUE,M$6<>\"\"),M22/M$6*100,\"\")","v":2.9166666666666665},13,{"$f":"IF(AND(ISNUMBER(O22)=TRUE,O$6<>\"\"),O22/O$6*100,\"\")","v":2.7083333333333335},null,"金融機関名","肥後銀行本店",null,null,2,2,2,2,2]
[null,null,null,"（実績）",15,{"$f":"IF(AND(ISNUMBER(E23)=TRUE,E$7<>\"\"),E23/E$7*100,\"\")","v":3.125},null,{"$f":"IF(AND(ISNUMBER(G23)=TRUE,G$7<>\"\"),G23/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I23)=TRUE,I$7<>\"\"),I23/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K23)=TRUE,K$7<>\"\"),K23/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M23)=TRUE,M$7<>\"\"),M23/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O23)=TRUE,O$7<>\"\"),O23/O$7*100,\"\")","v":""},null,null,"肥後銀行本店",null,10,10,10,10,10,10]
[null,null,"うち支払利息\n　　割引料","（予想）",null,{"$f":"IF(AND(ISNUMBER(E24)=TRUE,E$6<>\"\"),E24/E$6*100,\"\")","v":""},4,{"$f":"IF(AND(ISNUMBER(G24)=TRUE,G$6<>\"\"),G24/G$6*100,\"\")","v":0.83333333333333337},4,{"$f":"IF(AND(ISNUMBER(I24)=TRUE,I$6<>\"\"),I24/I$6*100,\"\")","v":0.83333333333333337},3,{"$f":"IF(AND(ISNUMBER(K24)=TRUE,K$6<>\"\"),K24/K$6*100,\"\")","v":0.625},2,{"$f":"IF(AND(ISNUMBER(M24)=TRUE,M$6<>\"\"),M24/M$6*100,\"\")","v":0.41666666666666669},2,{"$f":"IF(AND(ISNUMBER(O24)=TRUE,O$6<>\"\"),O24/O$6*100,\"\")","v":0.41666666666666669},null,null,"●●銀行●●支店",null,5,5,5,5,5,5]
[null,null,null,"（実績）",5,{"$f":"IF(AND(ISNUMBER(E25)=TRUE,E$7<>\"\"),E25/E$7*100,\"\")","v":1.0416666666666665},null,{"$f":"IF(AND(ISNUMBER(G25)=TRUE,G$7<>\"\"),G25/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I25)=TRUE,I$7<>\"\"),I25/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K25)=TRUE,K$7<>\"\"),K25/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M25)=TRUE,M$7<>\"\"),M25/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O25)=TRUE,O$7<>\"\"),O25/O$7*100,\"\")","v":""},null,null,"●●銀行●●支店",null,5,5,5,5,5,5]
[null,"　経常利益",null,"（予想）",{"$f":"IF(E18=\"\",\"\",E18+E20-E22)","v":""},{"$f":"IF(AND(ISNUMBER(E26)=TRUE,E$6<>\"\"),E26/E$6*100,\"\")","v":""},{"$f":"IF(G18=\"\",\"\",G18+G20-G22)","v":24},{"$f":"IF(AND(ISNUMBER(G26)=TRUE,G$6<>\"\"),G26/G$6*100,\"\")","v":5},{"$f":"IF(I18=\"\",\"\",I18+I20-I22)","v":28},{"$f":"IF(AND(ISNUMBER(I26)=TRUE,I$6<>\"\"),I26/I$6*100,\"\")","v":5.833333333333333},{"$f":"IF(K18=\"\",\"\",K18+K20-K22)","v":32},{"$f":"IF(AND(ISNUMBER(K26)=TRUE,K$6<>\"\"),K26/K$6*100,\"\")","v":6.666666666666667},{"$f":"IF(M18=\"\",\"\",M18+M20-M22)","v":32},{"$f":"IF(AND(ISNUMBER(M26)=TRUE,M$6<>\"\"),M26/M$6*100,\"\")","v":6.666666666666667},{"$f":"IF(O18=\"\",\"\",O18+O20-O22)","v":34},{"$f":"IF(AND(ISNUMBER(O26)=TRUE,O$6<>\"\"),O26/O$6*100,\"\")","v":7.083333333333333}]
[null,null,null,"（実績）",{"$f":"IF(E19=\"\",\"\",E19+E21-E23)","v":-5},{"$f":"IF(AND(ISNUMBER(E27)=TRUE,E$7<>\"\"),E27/E$7*100,\"\")","v":-1.0416666666666665},{"$f":"IF(G19=\"\",\"\",G19+G21-G23)","v":""},{"$f":"IF(AND(ISNUMBER(G27)=TRUE,G$7<>\"\"),G27/G$7*100,\"\")","v":""},{"$f":"IF(I19=\"\",\"\",I19+I21-I23)","v":""},{"$f":"IF(AND(ISNUMBER(I27)=TRUE,I$7<>\"\"),I27/I$7*100,\"\")","v":""},{"$f":"IF(K19=\"\",\"\",K19+K21-K23)","v":""},{"$f":"IF(AND(ISNUMBER(K27)=TRUE,K$7<>\"\"),K27/K$7*100,\"\")","v":""},{"$f":"IF(M19=\"\",\"\",M19+M21-M23)","v":""},{"$f":"IF(AND(ISNUMBER(M27)=TRUE,M$7<>\"\"),M27/M$7*100,\"\")","v":""},{"$f":"IF(O19=\"\",\"\",O19+O21-O23)","v":""},{"$f":"IF(AND(ISNUMBER(O27)=TRUE,O$7<>\"\"),O27/O$7*100,\"\")","v":""}]
[null,"　特別損益",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E28)=TRUE,E$6<>\"\"),E28/E$6*100,\"\")","v":""},0,{"$f":"IF(AND(ISNUMBER(G28)=TRUE,G$6<>\"\"),G28/G$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(I28)=TRUE,I$6<>\"\"),I28/I$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(K28)=TRUE,K$6<>\"\"),K28/K$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(M28)=TRUE,M$6<>\"\"),M28/M$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(O28)=TRUE,O$6<>\"\"),O28/O$6*100,\"\")","v":0},null,null,"（イ）合　計",null,{"$f":"SUM(U22:U27)","v":20},22,22,22,22,22]
[null,null,null,"（実績）",0,{"$f":"IF(AND(ISNUMBER(E29)=TRUE,E$7<>\"\"),E29/E$7*100,\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(G29)=TRUE,G$7<>\"\"),G29/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I29)=TRUE,I$7<>\"\"),I29/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K29)=TRUE,K$7<>\"\"),K29/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M29)=TRUE,M$7<>\"\"),M29/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O29)=TRUE,O$7<>\"\"),O29/O$7*100,\"\")","v":""},null,"償還計画","（ア）償還源資","（計画）",{"$f":"IF(ISNUMBER(U18)=TRUE,U18,\"\")","v":""},39,42,45,45,47]
[null,"税引前当期利益",null,"（予想）",{"$f":"IF(E26=\"\",\"\",E26+E28)","v":""},{"$f":"IF(AND(ISNUMBER(E30)=TRUE,E$6<>\"\"),E30/E$6*100,\"\")","v":""},{"$f":"IF(G26=\"\",\"\",G26+G28)","v":24},{"$f":"IF(AND(ISNUMBER(G30)=TRUE,G$6<>\"\"),G30/G$6*100,\"\")","v":5},{"$f":"IF(I26=\"\",\"\",I26+I28)","v":28},{"$f":"IF(AND(ISNUMBER(I30)=TRUE,I$6<>\"\"),I30/I$6*100,\"\")","v":5.833333333333333},{"$f":"IF(K26=\"\",\"\",K26+K28)","v":32},{"$f":"IF(AND(ISNUMBER(K30)=TRUE,K$6<>\"\"),K30/K$6*100,\"\")","v":6.666666666666667},{"$f":"IF(M26=\"\",\"\",M26+M28)","v":32},{"$f":"IF(AND(ISNUMBER(M30)=TRUE,M$6<>\"\"),M30/M$6*100,\"\")","v":6.666666666666667},{"$f":"IF(O26=\"\",\"\",O26+O28)","v":34},{"$f":"IF(AND(ISNUMBER(O30)=TRUE,O$6<>\"\"),O30/O$6*100,\"\")","v":7.083333333333333},null,null,null,"（実績）",10,"","","","",""]
[null,null,null,"（実績）",{"$f":"IF(E27=\"\",\"\",E27+E29)","v":-5},{"$f":"IF(AND(ISNUMBER(E31)=TRUE,E$7<>\"\"),E31/E$7*100,\"\")","v":-1.0416666666666665},{"$f":"IF(G27=\"\",\"\",G27+G29)","v":""},{"$f":"IF(AND(ISNUMBER(G31)=TRUE,G$7<>\"\"),G31/G$7*100,\"\")","v":""},{"$f":"IF(I27=\"\",\"\",I27+I29)","v":""},{"$f":"IF(AND(ISNUMBER(I31)=TRUE,I$7<>\"\"),I31/I$7*100,\"\")","v":""},{"$f":"IF(K27=\"\",\"\",K27+K29)","v":""},{"$f":"IF(AND(ISNUMBER(K31)=TRUE,K$7<>\"\"),K31/K$7*100,\"\")","v":""},{"$f":"IF(M27=\"\",\"\",M27+M29)","v":""},{"$f":"IF(AND(ISNUMBER(M31)=TRUE,M$7<>\"\"),M31/M$7*100,\"\")","v":""},{"$f":"IF(O27=\"\",\"\",O27+O29)","v":""},{"$f":"IF(AND(ISNUMBER(O31)=TRUE,O$7<>\"\"),O31/O$7*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U30),ISNUMBER(U29))=TRUE,U30-U29,\"\")","v":""},"","","","",""]
[null,"　税　　金",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E32)=TRUE,E$6<>\"\"),E32/E$6*100,\"\")","v":""},0,{"$f":"IF(AND(ISNUMBER(G32)=TRUE,G$6<>\"\"),G32/G$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(I32)=TRUE,I$6<>\"\"),I32/I$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(K32)=TRUE,K$6<>\"\"),K32/K$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(M32)=TRUE,M$6<>\"\"),M32/M$6*100,\"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(O32)=TRUE,O$6<>\"\"),O32/O$6*100,\"\")","v":0},null,null,"（イ）要償還額","（計画）",null,{"$f":"IF(ISNUMBER(V28)=TRUE,V28,\"\")","v":22},{"$f":"IF(ISNUMBER(W28)=TRUE,W28,\"\")","v":22},{"$f":"IF(ISNUMBER(X28)=TRUE,X28,\"\")","v":22},{"$f":"IF(ISNUMBER(Y28)=TRUE,Y28,\"\")","v":22},{"$f":"IF(ISNUMBER(Z28)=TRUE,Z28,\"\")","v":22}]
[null,null,null,"（実績）",0,{"$f":"IF(AND(ISNUMBER(E33)=TRUE,E$7<>\"\"),E33/E$7*100,\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(G33)=TRUE,G$7<>\"\"),G33/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I33)=TRUE,I$7<>\"\"),I33/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K33)=TRUE,K$7<>\"\"),K33/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M33)=TRUE,M$7<>\"\"),M33/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O33)=TRUE,O$7<>\"\"),O33/O$7*100,\"\")","v":""},null,null,null,"（実績）",{"$f":"IF(ISNUMBER(U28)=TRUE,U28,\"\")","v":20}]
[null," 当期利益",null,"（予想）",{"$f":"IF(E30=\"\",\"\",E30-E32)","v":""},{"$f":"IF(AND(ISNUMBER(E34)=TRUE,E$6<>\"\"),E34/E$6*100,\"\")","v":""},{"$f":"IF(G30=\"\",\"\",G30-G32)","v":24},{"$f":"IF(AND(ISNUMBER(G34)=TRUE,G$6<>\"\"),G34/G$6*100,\"\")","v":5},{"$f":"IF(I30=\"\",\"\",I30-I32)","v":28},{"$f":"IF(AND(ISNUMBER(I34)=TRUE,I$6<>\"\"),I34/I$6*100,\"\")","v":5.833333333333333},{"$f":"IF(K30=\"\",\"\",K30-K32)","v":32},{"$f":"IF(AND(ISNUMBER(K34)=TRUE,K$6<>\"\"),K34/K$6*100,\"\")","v":6.666666666666667},{"$f":"IF(M30=\"\",\"\",M30-M32)","v":32},{"$f":"IF(AND(ISNUMBER(M34)=TRUE,M$6<>\"\"),M34/M$6*100,\"\")","v":6.666666666666667},{"$f":"IF(O30=\"\",\"\",O30-O32)","v":34},{"$f":"IF(AND(ISNUMBER(O34)=TRUE,O$6<>\"\"),O34/O$6*100,\"\")","v":7.083333333333333},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U33),ISNUMBER(U32))=TRUE,U33-U32,\"\")","v":""},"","","","",""]
[null,null,null,"（実績）",{"$f":"IF(E31=\"\",\"\",E31-E33)","v":-5},{"$f":"IF(AND(ISNUMBER(E35)=TRUE,E$7<>\"\"),E35/E$7*100,\"\")","v":-1.0416666666666665},{"$f":"IF(G31=\"\",\"\",G31-G33)","v":""},{"$f":"IF(AND(ISNUMBER(G35)=TRUE,G$7<>\"\"),G35/G$7*100,\"\")","v":""},{"$f":"IF(I31=\"\",\"\",I31-I33)","v":""},{"$f":"IF(AND(ISNUMBER(I35)=TRUE,I$7<>\"\"),I35/I$7*100,\"\")","v":""},{"$f":"IF(K31=\"\",\"\",K31-K33)","v":""},{"$f":"IF(AND(ISNUMBER(K35)=TRUE,K$7<>\"\"),K35/K$7*100,\"\")","v":""},{"$f":"IF(M31=\"\",\"\",M31-M33)","v":""},{"$f":"IF(AND(ISNUMBER(M35)=TRUE,M$7<>\"\"),M35/M$7*100,\"\")","v":""},{"$f":"IF(O31=\"\",\"\",O31-O33)","v":""},{"$f":"IF(AND(ISNUMBER(O35)=TRUE,O$7<>\"\"),O35/O$7*100,\"\")","v":""},null,"余　力","差　引","（計画）",{"$f":"IF(AND(U29<>\"\",U32<>\"\"),U29-U32,\"\")","v":""},17,20,23,23,25]
[null,"減価償却費",null,"（予想）",null,{"$f":"IF(AND(ISNUMBER(E36)=TRUE,E$6<>\"\"),E36/E$6*100,\"\")","v":""},15,{"$f":"IF(AND(ISNUMBER(G36)=TRUE,G$6<>\"\"),G36/G$6*100,\"\")","v":3.125},14,{"$f":"IF(AND(ISNUMBER(I36)=TRUE,I$6<>\"\"),I36/I$6*100,\"\")","v":2.9166666666666665},13,{"$f":"IF(AND(ISNUMBER(K36)=TRUE,K$6<>\"\"),K36/K$6*100,\"\")","v":2.7083333333333335},13,{"$f":"IF(AND(ISNUMBER(M36)=TRUE,M$6<>\"\"),M36/M$6*100,\"\")","v":2.7083333333333335},13,{"$f":"IF(AND(ISNUMBER(O36)=TRUE,O$6<>\"\"),O36/O$6*100,\"\")","v":2.7083333333333335},null,null,null,"（実績）",-10,"","","","",""]
[null,null,null,"（実績）",15,{"$f":"IF(AND(ISNUMBER(E37)=TRUE,E$7<>\"\"),E37/E$7*100,\"\")","v":3.125},null,{"$f":"IF(AND(ISNUMBER(G37)=TRUE,G$7<>\"\"),G37/G$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(I37)=TRUE,I$7<>\"\"),I37/I$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(K37)=TRUE,K$7<>\"\"),K37/K$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(M37)=TRUE,M$7<>\"\"),M37/M$7*100,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(O37)=TRUE,O$7<>\"\"),O37/O$7*100,\"\")","v":""},null,null,null,"（計画比）",{"$f":"IF(AND(ISNUMBER(U36),ISNUMBER(U35))=TRUE,U36-U35,\"\")","v":""},"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"長期借入金残高","肥後銀行本店",null,null,15,13,11,9,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"肥後銀行本店",null,100,90,80,70,60,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●●銀行●●支店",null,60,55,50,45,40,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●●銀行●●支店",null,40,35,30,25,20,15]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"特記事項"]

{"sheet":"Sheet1","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["千円"]
["百万円"]

{"sheet":"収支予想表・償還計画表【記入例】","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}