расчеты

	A	B	C	D
1
2		сумма кредита	500,000.00
3		процентная ставка (месяц/год)	0.01333	0.16
4		инфляция (месяц/год)	0.01	0.12
5		срок кредита	36
6
7	период	платеж, руб	накопленная инфляция	платеж в ценах на момент получения кредита
8	1	17,578.52	0.9900990099	17,404.47
9	2	17,578.52	0.9802960494	17,232.15
10	3	17,578.52	0.9705901479	17,061.53
11	4	17,578.52	0.9609803445	16,892.61
12	5	17,578.52	0.9514656876	16,725.36
13	6	17,578.52	0.9420452353	16,559.76
14	7	17,578.52	0.9327180547	16,395.80
15	8	17,578.52	0.9234832225	16,233.47
16	9	17,578.52	0.9143398242	16,072.74
17	10	17,578.52	0.9052869547	15,913.60
18	11	17,578.52	0.8963237175	15,756.04
19	12	17,578.52	0.8874492253	15,600.04
20	13	17,578.52	0.8786625993	15,445.59
21	14	17,578.52	0.8699629696	15,292.66
22	15	17,578.52	0.8613494748	15,141.25
23	16	17,578.52	0.8528212622	14,991.33
24	17	17,578.52	0.8443774873	14,842.90
25	18	17,578.52	0.8360173142	14,695.94
26	19	17,578.52	0.827739915	14,550.44
27	20	17,578.52	0.8195444703	14,406.38
28	21	17,578.52	0.8114301687	14,263.74
29	22	17,578.52	0.8033962066	14,122.51
30	23	17,578.52	0.7954417887	13,982.69
31	24	17,578.52	0.7875661274	13,844.24
32	25	17,578.52	0.779768443	13,707.17
33	26	17,578.52	0.7720479634	13,571.46
34	27	17,578.52	0.7644039241	13,437.09
35	28	17,578.52	0.7568355684	13,304.05
36	29	17,578.52	0.749342147	13,172.32
37	30	17,578.52	0.7419229178	13,041.90
38	31	17,578.52	0.7345771463	12,912.78
39	32	17,578.52	0.7273041053	12,784.93
40	33	17,578.52	0.7201030745	12,658.34
41	34	17,578.52	0.7129733411	12,533.01
42	35	17,578.52	0.7059141991	12,408.92
43	36	17,578.52	0.6989249496	12,286.06
44	ИТОГО	632,826.59	x	529,245.27
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