PQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECF
1
2
▼契約▼開所(8/1)
3
年月12月-211月-222月-223月-224月-225月-226月-227月-228月-229月-2210月-2211月-2212月-221月-232月-233月-234月-235月-236月-237月-238月-239月-2310月-2311月-2312月-231月-242月-243月-244月-245月-246月-247月-248月-249月-2410月-2411月-2412月-241月-252月-253月-254月-255月-256月-257月-258月-259月-2510月-2511月-2512月-251月-262月-263月-264月-265月-266月-267月-268月-269月-2610月-2611月-2612月-26
4
契約後経過月0ヶ月1ヶ月2ヶ月3ヶ月4ヶ月5ヶ月6ヶ月7ヶ月8ヶ月9ヶ月10ヶ月11ヶ月12ヶ月13ヶ月14ヶ月15ヶ月16ヶ月17ヶ月18ヶ月19ヶ月20ヶ月21ヶ月22ヶ月23ヶ月24ヶ月25ヶ月26ヶ月27ヶ月28ヶ月29ヶ月30ヶ月31ヶ月32ヶ月33ヶ月34ヶ月35ヶ月36ヶ月37ヶ月38ヶ月39ヶ月40ヶ月41ヶ月42ヶ月43ヶ月44ヶ月45ヶ月46ヶ月47ヶ月48ヶ月49ヶ月50ヶ月51ヶ月52ヶ月53ヶ月54ヶ月55ヶ月56ヶ月57ヶ月58ヶ月59ヶ月60ヶ月
5
開所後経過月1ヶ月2ヶ月3ヶ月4ヶ月5ヶ月6ヶ月7ヶ月8ヶ月9ヶ月10ヶ月11ヶ月12ヶ月13ヶ月14ヶ月15ヶ月16ヶ月17ヶ月18ヶ月19ヶ月20ヶ月21ヶ月22ヶ月23ヶ月24ヶ月25ヶ月26ヶ月27ヶ月28ヶ月29ヶ月30ヶ月31ヶ月32ヶ月33ヶ月34ヶ月35ヶ月36ヶ月37ヶ月38ヶ月39ヶ月40ヶ月41ヶ月42ヶ月43ヶ月44ヶ月45ヶ月46ヶ月47ヶ月48ヶ月49ヶ月50ヶ月51ヶ月52ヶ月53ヶ月
6
資本剰余金(月初) 46,200,000 11,760,000 11,700,150 11,640,300 10,260,450 10,200,600 4,090,750 2,050,900 1,991,050 2,156,050 2,321,050 2,486,050 2,651,050 2,981,050 3,311,050 3,641,050 3,971,050 4,501,183 5,031,316 5,561,448 6,091,581 7,123,995 8,156,410 9,314,964 10,473,519 11,632,073 12,790,628 13,949,183 15,107,737 16,447,225 17,786,712 19,126,200 20,465,688 21,805,175 23,144,663 24,665,478 26,186,294 27,707,110 29,227,925 30,748,741 32,269,556 33,790,372 35,311,188 36,832,003 38,352,819 39,873,634 41,394,450 42,915,266 44,436,081 45,956,897 47,477,712 48,998,528 50,519,344 52,040,159 53,560,975 55,081,790 56,602,606 58,123,422 59,644,237 61,165,053 62,685,868
7
支援契約金 34,210,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8
物件取得費 0 0 0 1,320,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9
内装工事費 0 0 0 0 0 6,050,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10
陶器・備品等 0 0 0 0 0 0 1,980,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11
初期費用 230,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12
資本剰余金残 11,760,000 11,760,000 11,700,150 10,320,300 10,260,450 4,150,600 2,110,750 2,050,900 1,991,050 2,156,050 2,321,050 2,486,050 2,651,050 2,981,050 3,311,050 3,641,050 3,971,050 4,501,183 5,031,316 5,561,448 6,091,581 7,123,995 8,156,410 9,314,964 10,473,519 11,632,073 12,790,628 13,949,183 15,107,737 16,447,225 17,786,712 19,126,200 20,465,688 21,805,175 23,144,663 24,665,478 26,186,294 27,707,110 29,227,925 30,748,741 32,269,556 33,790,372 35,311,188 36,832,003 38,352,819 39,873,634 41,394,450 42,915,266 44,436,081 45,956,897 47,477,712 48,998,528 50,519,344 52,040,159 53,560,975 55,081,790 56,602,606 58,123,422 59,644,237 61,165,053 62,685,868
13
14
（想定稼働率）n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.20%20%40%40%50%50%50%50%70%70%70%70%90%90%100%100%100%100%100%100%125%125%125%125%125%125%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%150%
←想定稼働率のみ変更できます
15
売上 0 0 0 0 0 0 0 0 989,100 989,100 1,978,200 1,978,200 2,472,720 2,472,720 2,472,720 2,472,720 3,461,808 3,461,808 3,461,808 3,461,808 4,450,896 4,450,896 4,945,440 4,945,440 4,945,440 4,945,440 4,945,440 4,945,440 5,392,400 5,392,400 5,392,400 5,392,400 5,392,400 5,392,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400
16
売上原価 0 0 0 0 0 0 0 0 260,000 260,000 520,000 520,000 650,018 650,018 650,018 650,018 874,825 874,825 874,825 874,825 1,099,632 1,099,632 1,212,035 1,212,035 1,212,035 1,212,035 1,212,035 1,212,035 1,314,162 1,314,162 1,314,162 1,314,162 1,314,162 1,314,162 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234 1,416,234
17
粗利 0 0 0 0 0 0 0 0 729,100 729,100 1,458,200 1,458,200 1,822,702 1,822,702 1,822,702 1,822,702 2,586,983 2,586,983 2,586,983 2,586,983 3,351,264 3,351,264 3,733,405 3,733,405 3,733,405 3,733,405 3,733,405 3,733,405 4,078,238 4,078,238 4,078,238 4,078,238 4,078,238 4,078,238 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166 4,423,166
18
販売管理費 0 0 0 0 0 0 0 0 1,735,000 1,735,000 1,735,000 1,735,000 1,735,000 1,735,000 1,735,000 1,735,000 1,997,000 1,997,000 1,997,000 1,997,000 2,259,000 2,259,000 2,515,000 2,515,000 2,515,000 2,515,000 2,515,000 2,515,000 2,678,900 2,678,900 2,678,900 2,678,900 2,678,900 2,678,900 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500 2,842,500
19
営業利益 0 0 0 0 0 0 0 0 (1,005,900)(1,005,900)(276,800)(276,800) 87,702 87,702 87,702 87,702 589,983 589,983 589,983 589,983 1,092,264 1,092,264 1,218,405 1,218,405 1,218,405 1,218,405 1,218,405 1,218,405 1,399,338 1,399,338 1,399,338 1,399,338 1,399,338 1,399,338 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666 1,580,666
20
合同会社経費 0 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850 59,850
21
最終利益 0 (59,850)(59,850)(59,850)(59,850)(59,850)(59,850)(59,850)(1,065,750)(1,065,750)(336,650)(336,650) 27,852 27,852 27,852 27,852 530,133 530,133 530,133 530,133 1,032,414 1,032,414 1,158,555 1,158,555 1,158,555 1,158,555 1,158,555 1,158,555 1,339,488 1,339,488 1,339,488 1,339,488 1,339,488 1,339,488 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816
22
23
▼営業利益が赤字の場合
24
営業保証金n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a. 165,000 165,000 165,000 165,000 330,000 330,000 330,000 330,000 495,000 495,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25
最終利益 0 (59,850)(59,850)(59,850)(59,850)(59,850)(59,850)(59,850) 165,000 165,000 165,000 165,000 330,000 330,000 330,000 330,000 530,133 530,133 530,133 530,133 1,032,414 1,032,414 1,158,555 1,158,555 1,158,555 1,158,555 1,158,555 1,158,555 1,339,488 1,339,488 1,339,488 1,339,488 1,339,488 1,339,488 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816
26
ROE（契約月ベース）1.24%18.73%34.79%39.50%39.50%
27
ROE（開所月ベース）8.88%31.11%38.72%39.50%39.50%
28
資本剰余金(右軸) 11,760,000 11,700,150 11,640,300 10,260,450 10,200,600 4,090,750 2,050,900 1,991,050 2,156,050 2,321,050 2,486,050 2,651,050 2,981,050 3,311,050 3,641,050 3,971,050 4,501,183 5,031,316 5,561,448 6,091,581 7,123,995 8,156,410 9,314,964 10,473,519 11,632,073 12,790,628 13,949,183 15,107,737 16,447,225 17,786,712 19,126,200 20,465,688 21,805,175 23,144,663 24,665,478 26,186,294 27,707,110 29,227,925 30,748,741 32,269,556 33,790,372 35,311,188 36,832,003 38,352,819 39,873,634 41,394,450 42,915,266 44,436,081 45,956,897 47,477,712 48,998,528 50,519,344 52,040,159 53,560,975 55,081,790 56,602,606 58,123,422 59,644,237 61,165,053 62,685,868 64,206,684 139%
29
30
グラフ用12月-211月-222月-223月-224月-225月-226月-227月-228月-229月-2210月-2211月-2212月-221月-232月-233月-234月-235月-236月-237月-238月-239月-2310月-2311月-2312月-231月-242月-243月-244月-245月-246月-247月-248月-249月-2410月-2411月-2412月-241月-252月-253月-254月-255月-256月-257月-258月-259月-2510月-2511月-2512月-251月-262月-263月-264月-265月-266月-267月-268月-269月-2610月-2611月-2612月-26
31
資本剰余金（右軸）11,760,000 11,700,150 11,640,300 10,260,450 10,200,600 4,090,750 2,050,900 1,991,050 2,156,050 2,321,050 2,486,050 2,651,050 2,981,050 3,311,050 3,641,050 3,971,050 4,501,183 5,031,316 5,561,448 6,091,581 7,123,995 8,156,410 9,314,964 10,473,519 11,632,073 12,790,628 13,949,183 15,107,737 16,447,225 17,786,712 19,126,200 20,465,688 21,805,175 23,144,663 24,665,478 26,186,294 27,707,110 29,227,925 30,748,741 32,269,556 33,790,372 35,311,188 36,832,003 38,352,819 39,873,634 41,394,450 42,915,266 44,436,081 45,956,897 47,477,712 48,998,528 50,519,344 52,040,159 53,560,975 55,081,790 56,602,606 58,123,422 59,644,237 61,165,053 62,685,868 64,206,684
32
売上0 0 0 0 0 0 0 0 989,100 989,100 1,978,200 1,978,200 2,472,720 2,472,720 2,472,720 2,472,720 3,461,808 3,461,808 3,461,808 3,461,808 4,450,896 4,450,896 4,945,440 4,945,440 4,945,440 4,945,440 4,945,440 4,945,440 5,392,400 5,392,400 5,392,400 5,392,400 5,392,400 5,392,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400 5,839,400
33
最終利益0 -59,850 -59,850 -59,850 -59,850 -59,850 -59,850 -59,850 165,000 165,000 165,000 165,000 330,000 330,000 330,000 330,000 530,133 530,133 530,133 530,133 1,032,414 1,032,414 1,158,555 1,158,555 1,158,555 1,158,555 1,158,555 1,158,555 1,339,488 1,339,488 1,339,488 1,339,488 1,339,488 1,339,488 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816 1,520,816
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100