სესხის დაფარვის გრაფიკი.xls

	B	C	D	E	F	G	H	J	K	L
1	sesxis dafarvis grafiki
2
3	msesxebeli		?
4
5	sesxis moculoba		33,000		sesxis gacemis TariRi			efeq. saprocento sarg.		-23.1%
6	saprocento sarg. (wl.)		7.5%		Tve	11
7	vada		64		dRe	28		Method of calculation
8	saSeRavaTo periodi		0		weli	2019
9	sakomisio (%)		0.0%						Input payment schedule by hand
10
11	sul		30,529.93	7,101.78	37,631.71				Calculate payment schedule
12
13	#	TariRi	Ziri	procenti	Senatani	balansi	fuladi nakadi
15	1	28.12.2019	420.95	206.25	627.20	32,579.05	627.20
16	2	28.01.2020	423.58	203.62	627.20	32,155.48	627.20
17	3	28.02.2020	426.22	200.97	627.20	31,729.26	627.20
18	4	28.03.2020	428.89	198.31	627.20	31,300.37	627.20
19	5	28.04.2020	431.57	195.63	627.20	30,868.80	627.20
20	6	28.05.2020	434.27	192.93	627.20	30,434.53	627.20
21	7	28.06.2020	436.98	190.22	627.20	29,997.56	627.20
22	8	28.07.2020	439.71	187.48	627.20	29,557.85	627.20
23	9	28.08.2020	442.46	184.74	627.20	29,115.39	627.20
24	10	28.09.2020	445.22	181.97	627.20	28,670.16	627.20
25	11	28.10.2020	448.01	179.19	627.20	28,222.16	627.20
26	12	28.11.2020	450.81	176.39	627.20	27,771.35	627.20
27	13	28.12.2020	453.62	173.57	627.20	27,317.73	627.20
28	14	28.01.2021	456.46	170.74	627.20	26,861.27	627.20
29	15	28.02.2021	459.31	167.88	627.20	26,401.95	627.20
30	16	28.03.2021	462.18	165.01	627.20	25,939.77	627.20
31	17	28.04.2021	465.07	162.12	627.20	25,474.70	627.20
32	18	28.05.2021	467.98	159.22	627.20	25,006.72	627.20
33	19	28.06.2021	470.90	156.29	627.20	24,535.82	627.20
34	20	28.07.2021	473.85	153.35	627.20	24,061.97	627.20
35	21	28.08.2021	476.81	150.39	627.20	23,585.16	627.20
36	22	28.09.2021	479.79	147.41	627.20	23,105.38	627.20
37	23	28.10.2021	482.79	144.41	627.20	22,622.59	627.20
38	24	28.11.2021	485.80	141.39	627.20	22,136.78	627.20
39	25	28.12.2021	488.84	138.35	627.20	21,647.94	627.20
40	26	28.01.2022	491.90	135.30	627.20	21,156.05	627.20
41	27	28.02.2022	494.97	132.23	627.20	20,661.08	627.20
42	28	28.03.2022	498.06	129.13	627.20	20,163.02	627.20
43	29	28.04.2022	501.18	126.02	627.20	19,661.84	627.20
44	30	28.05.2022	504.31	122.89	627.20	19,157.53	627.20
45	31	28.06.2022	507.46	119.73	627.20	18,650.07	627.20
46	32	28.07.2022	510.63	116.56	627.20	18,139.44	627.20
47	33	28.08.2022	513.82	113.37	627.20	17,625.61	627.20
48	34	28.09.2022	517.04	110.16	627.20	17,108.58	627.20
49	35	28.10.2022	520.27	106.93	627.20	16,588.31	627.20
50	36	28.11.2022	523.52	103.68	627.20	16,064.79	627.20
51	37	28.12.2022	526.79	100.40	627.20	15,538.00	627.20
52	38	28.01.2023	530.08	97.11	627.20	15,007.92	627.20
53	39	28.02.2023	533.40	93.80	627.20	14,474.53	627.20
54	40	28.03.2023	536.73	90.47	627.20	13,937.80	627.20
55	41	28.04.2023	540.08	87.11	627.20	13,397.71	627.20
56	42	28.05.2023	543.46	83.74	627.20	12,854.25	627.20
57	43	28.06.2023	546.86	80.34	627.20	12,307.40	627.20
58	44	28.07.2023	550.27	76.92	627.20	11,757.12	627.20
59	45	28.08.2023	553.71	73.48	627.20	11,203.41	627.20
60	46	28.09.2023	557.17	70.02	627.20	10,646.24	627.20
61	47	28.10.2023	560.66	66.54	627.20	10,085.58	627.20
62	48	28.11.2023	564.16	63.03	627.20	9,521.42	627.20
63	49	28.12.2023	567.69	59.51	627.20	8,953.73	627.20
64	50	28.01.2024	571.23	55.96	627.20	8,382.50	627.20
65	51	28.02.2024	574.80	52.39	627.20	7,807.69	627.20
66	52	28.03.2024	578.40	48.80	627.20	7,229.30	627.20
67	53	28.04.2024	582.01	45.18	627.20	6,647.29	627.20
68	54	28.05.2024	585.65	41.55	627.20	6,061.64	627.20
69	55	28.06.2024	589.31	37.89	627.20	5,472.33	627.20
70	56	28.07.2024	592.99	34.20	627.20	4,879.33	627.20
71	57	28.08.2024	596.70	30.50	627.20	4,282.63	627.20
72	58	28.09.2024	600.43	26.77	627.20	3,682.20	627.20
73	59	28.10.2024	604.18	23.01	627.20	3,078.02	627.20
74	60	28.11.2024	607.96	19.24	627.20	2,470.07	627.20
75	61	28.12.2024	611.76	15.44	627.20	1,858.31	627.20
76	62	28.01.2025	615.58	11.61	627.20	1,242.73	627.20
77	63	28.02.2025	619.43	7.77	627.20	623.30	627.20
78	64	28.03.2025	623.30	3.90	627.20	0.00	627.20
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101