Untitled spreadsheet

	B	C	D	E
1
2
3	元金	月々返済
4	100000	10000
5
6	支払い月	残金	残金に対する利息	支払い
7	1	100000	9000	19000
8	2	90000	8100	18100
9	3	80000	7200	17200
10	4	70000	6300	16300
11	5	60000	5400	15400
12	6	50000	4500	14500
13	7	40000	3600	13600
14	8	30000	2700	12700
15	9	20000	1800	11800
16	10	10000	900	10900
17				149500
18
19
20	元金	月々返済
21	100000	10000
22
23	支払い月	残金	残金に対する利息	支払い
24	1	100,000	9,000	10,000
25	2	99,000	8,910	10,000
26	3	97,910	8,812	10,000
27	4	96,722	8,705	10,000
28	5	95,427	8,588	10,000
29	6	94,015	8,461	10,000
30	7	92,477	8,323	10,000
31	8	90,800	8,172	10,000
32	9	88,972	8,007	10,000
33	10	86,979	7,828	10,000
34	11	84,807	7,633	10,000
35	12	82,440	7,420	10,000
36	13	79,859	7,187	10,000
37	14	77,047	6,934	10,000
38	15	73,981	6,658	10,000
39	16	70,639	6,358	10,000
40	17	66,997	6,030	10,000
41	18	63,026	5,672	10,000
42	19	58,699	5,283	10,000
43	20	53,982	4,858	10,000
44	21	48,840	4,396	10,000
45	22	43,235	3,891	10,000
46	23	37,127	3,341	10,000
47	24	30,468	2,742	10,000
48	25	23,210	2,089	10,000
49	26	15,299	1,377	10,000
50	27	6,676	601	7,277
51				267,277
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