{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["返済総額算出シート "],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"返済総額算出シート ","index":0,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[45,3,45,4],[61,2,61,3],[61,4,61,5],[56,3,56,5],[57,3,57,5],[51,2,51,3],[7,3,7,4],[2,4,2,5],[13,3,13,4],[18,3,18,4],[24,2,24,3],[31,3,31,4],[27,2,27,3]],"flags":["formulas_cached_only"]}
["　　　返済総額算出シート（小規模個人再生）　　　　　　　　　　　　"]
[]
[null,null,null,"再生債務者"]
[]
["第１　返済総額の最低限度額の検討"]
[]
[]
[null,"返済総額の最低限度額","Ａ",3000000]
[]
[null,"※この額は，下記のＣ及びＤの額以上になる必要があります。"]
[]
[]
[1,"最低弁済額"]
["①","再生債権の総額","Ｂ",24004444]
[null,"・　無異議債権及び評価済債権（別除権の行使によって弁済を受けることができると見込まれる再生債権の額及び民事再生法"]
[null,"　８４条２項に規定する請求権の額を除く。）の総額　　"]
[null,"・　住宅資金特別条項を定める場合は，住宅資金貸付債権の額を除く。"]
[]
["②","最低弁済額（算出方法は下記のとおり）","Ｃ",3000000]
[]
[]
[null,"　　　 Ｂの額が１００万円以下の場合　　　　　 　　　　その額"]
[null,"　　　 Ｂの額が５００万円以下の場合",null,"1,000,000円"]
[null,"　　　 Ｂの額が１５００万円以下の場合（下記の計算式により算出した額）"]
[null,"　Ｂの額÷５＝",4800888.8]
[null,"　　　 Ｂの額が１５００万円を超える場合　　　 　　　３００万円",null,"3,000,000円"]
[null,"　　　 Ｂの額が３０００万円を超える場合（下記の計算式により算出した額）"]
[null,"　Ｂの額÷１０＝",2400444.4]
[]
[]
[2,"清算価値"]
[null,"清算価値チェックシートにより算出した額","Ｄ",2194000]
[]
[]
[]
[]
[]
["第２　実際の返済方法の検討"]
[]
[1,"返済率（再生債権の権利変更の割合）の算定"]
[null,"　（計算式）　返済率≧Ａの額÷Ｂの額×１００",null,"返済率",0.125]
[null,null,"（参考","最低返済率",0.12497686,"）"]
[null,"　※再生計画案には，１００から上記の返済率を差し引いた％を免除率として記入する。"]
[]
[2,"返済総額の算定"]
[null,"　（計算式）　返済総額＝Ｂの額×返済率",null,3000555.5]
[]
[3,"返済期間の設定",null,3,0]
[null,null,null,"（全",36,"月）"]
[4,"返済方法の設定（分割返済）","　 毎月払い","各","","（分割","","回）",false]
[null,"（※各回の返済割合は，権利変更後","　 ボーナス時払いの併用"]
[null,"　の再生債権額に対する割合を示す。）","　　毎月の支払分　　各",null,"%","（分割",36,"回）"]
[null,null,"　　ボーナス時の支払分",null,"%","（分割",6,"回）"]
[]
[null,"＊　分　割　返　済　額　試　算　表　＊"]
[]
[null,"① 再生計画による返済総額（第２の２の額）",null,3000555.5]
[null,"② １年分の返済額＝①÷返済期間（月数）×１２",null,1000185.1666666667]
[null,"③ １年分の返済額を割り振った額","毎月の支払分",null,"ボーナス時の支払分"]
[null,"(④の額＋⑤の額＝②の額）",800185," 円　④",200000," 円 ⑤"]
[null,"⑥ 返済の回数 （１年間における分割の回数）",12,"回",2,"回"]
[null,"⑦ １回当たりの返済額",66683,null,100000]