Download - Scadentar Rata Bancare Excel
-
7/25/2019 Scadentar Rata Bancare Excel
1/7
Nr. luna Data Principal Rata principal Dobanda Total de plata
1 200,000.00 1,111.00 1,200.00 2,311.00
2 198,889.00 1,111.00 1,193.33 2,304.33
3 197,778.00 1,111.00 1,186.67 2,297.67
4 196,667.00 1,111.00 1,180.00 2,291.00
5 195,556.00 1,111.00 1,173.34 2,284.34
6 194,445.00 1,111.00 1,166.67 2,277.677 193,334.00 1,111.00 1,160.00 2,271.00
8 192,223.00 1,111.00 1,153.34 2,264.34
9 191,112.00 1,111.00 1,146.67 2,257.67
10 190,001.00 1,111.00 1,140.01 2,251.01
11 188,890.00 1,111.00 1,133.34 2,244.34
12 187,779.00 1,111.00 1,126.67 2,237.67
13 186,668.00 1,111.00 1,120.01 2,231.01
14 185,557.00 1,111.00 1,113.34 2,224.34
15 184,446.00 1,111.00 1,106.68 2,217.68
16 183,335.00 1,111.00 1,100.01 2,211.01
17 182,224.00 1,111.00 1,093.34 2,204.34
18 181,113.00 1,111.00 1,086.68 2,197.6819 180,002.00 1,111.00 1,080.01 2,191.01
20 178,891.00 1,111.00 1,073.35 2,184.35
21 177,780.00 1,111.00 1,066.68 2,177.68
22 176,669.00 1,111.00 1,060.01 2,171.01
23 175,558.00 1,111.00 1,053.35 2,164.35
24 174,447.00 1,111.00 1,046.68 2,157.68
25 173,336.00 1,111.00 1,040.02 2,151.02
26 172,225.00 1,111.00 1,033.35 2,144.35
27 171,114.00 1,111.00 1,026.68 2,137.68
28 170,003.00 1,111.00 1,020.02 2,131.02
29 168,892.00 1,111.00 1,013.35 2,124.35
30 167,781.00 1,111.00 1,006.69 2,117.6931 166,670.00 1,111.00 1,000.02 2,111.02
32 165,559.00 1,111.00 993.35 2,104.35
33 164,448.00 1,111.00 986.69 2,097.69
34 163,337.00 1,111.00 980.02 2,091.02
35 162,226.00 1,111.00 973.36 2,084.36
36 161,115.00 1,111.00 966.69 2,077.69
37 160,004.00 1,111.00 960.02 2,071.02
38 158,893.00 1,111.00 953.36 2,064.36
39 157,782.00 1,111.00 946.69 2,057.69
40 156,671.00 1,111.00 940.03 2,051.03
41 155,560.00 1,111.00 933.36 2,044.36
42 154,449.00 1,111.00 926.69 2,037.6943 153,338.00 1,111.00 920.03 2,031.03
44 152,227.00 1,111.00 913.36 2,024.36
45 151,116.00 1,111.00 906.70 2,017.70
46 150,005.00 1,111.00 900.03 2,011.03
47 148,894.00 1,111.00 893.36 2,004.36
48 147,783.00 1,111.00 886.70 1,997.70
-
7/25/2019 Scadentar Rata Bancare Excel
2/7
Situatie derulare imprumut
ul!06 "u#!06 $ep!06 %ct!06 No&!06 Dec!06 an!07 'eb!07 (ar!07
Nr. Luni 1 2 3 4 5 6 7 8
ACTIV INVESTITIIINTRARI TOTAL, din care: 487,!7 !4,"!7 #8,$77 !4,"%& !!,8"8 4!%,"% !!,#8 !",8&%
Credit 'R( 476,987 390,953
Ap)rt pr)priu * in natura 558,000
Ap)rt pr)priu * numerar 165,300 10,630 14,917 38,277 14,905 11,898 19,952 11,638 19,850
IESIRI TOTAL, din care: ,&8% "#,4$" $#",7# "#,# 74,&! !$4,"4 7$,88" !$4,#$4
Al)care c)+turi cladire 66,580 93,429 239,736 93,353 74,516 124,964 72,889 124,324
4$!,%#7 #4$,&$& !4!,%7 $,!" % $8&,"4! $$4,"% !$%,$!
ACTIV EXLOATAREINTRARI TOTAL, din care : $%,#7! #7! #7! #7! #7! #7! #7! #7!
Venituri c-irie
C)ntriutie (C CO// 13,587 247 247 247 247 247 247 247
C)ntriutie 0EA(VERT. 6,783 123 123 123 123 123 123 123
IESIRI CRE(IT, din care: $%,#7! #7! #7! #7! #7! #7! #7! #7!
343 343 343 343 343 343 343 343
20,000 0 0 0 0 0 0 0
28 28 28 28 28 28 28 28
% % % % % % % %
1L2X (E N2/ERAR NET *INVESTITII
Rata lunara CRE(IT3rincipal()anda5
C)mi+i)n de ac)rdare * !6 adal)rem
C)mi+i)n de e+tiune * lunar3%,6, aplicat la +)ld5
1L2X (E N2/ERAR NET *
INVESTITII
-
7/25/2019 Scadentar Rata Bancare Excel
3/7
Situatie derulare imprumut ANEXA I
$ep!07 %ct!07 No&!07 Dec!07 an!08 'eb!08 (ar!08 "pr!08 (a)!08 un!08 ul!08
14 15 16 17 18 19 20 21 22 23 24
$%&,"87 !$,!$# % % % % % % % % %
176,179
29,808 12,123
!8,"4 #!,4! % % % % % % % % %
186,694 31,416
!",$"# %
$ % 4%,%%% 4%,%%% 4%,%%% 4%,%%% 4%,%%% 4%,%%% 4%,%%% 4%,%%% 4%,%%%
40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000
442 440
220 220
$ % &8 & &4 &$ &% 48 4 4# 4!
636 634 632 630 628 626 624 622 620 618 616
0 0 0 0 0 0 0 0 0 0 0
27 26 26 26 26 26 26 25 25 25 25
% % #",#4$ #",#44 #",#4 #",#48 #",#&% #",#&$ #",#&4 #",#&7 #",#&"
-
7/25/2019 Scadentar Rata Bancare Excel
4/7
9raic ramur+are
Ane;a II
Nr. luna rincipal Rata principal ()anda T)tal de plata
1 7,200,000.00 65,940.00 65,940.00
2 7,200,000.00 65,940.00 65,940.00
3 7,200,000.00 65,940.00 65,940.00
4 7,200,000.00 65,940.00 65,940.00
5 7,200,000.00 65,940.00 65,940.00
6 7,200,000.00 65,940.00 65,940.00
7 7,200,000.00 65,940.00 65,940.008 7,200,000.00 65,940.00 65,940.00
9 7,200,000.00 65,940.00 65,940.00
10 7,200,000.00 65,940.00 65,940.00
11 7,200,000.00 65,940.00 65,940.00
12 7,200,000.00 65,940.00 65,940.00
13 7,200,000.00 66,667.00 65,940.00 132,607.00
14 7,133,333.00 66,667.00 65,329.44 131,996.44
15 7,066,666.00 66,667.00 64,718.88 131,385.88
16 6,999,999.00 66,667.00 64,108.32 130,775.32
17 6,933,332.00 66,667.00 63,497.77 130,164.77
18 6,866,665.00 66,667.00 62,887.21 129,554.21
19 6,799,998.00 66,667.00 62,276.65 128,943.6520 6,733,331.00 66,667.00 61,666.09 128,333.09
21 6,666,664.00 66,667.00 61,055.53 127,722.53
22 6,599,997.00 66,667.00 60,444.97 127,111.97
23 6,533,330.00 66,667.00 59,834.41 126,501.41
24 6,466,663.00 66,667.00 59,223.86 125,890.86
25 6,399,996.00 66,667.00 58,613.30 125,280.30
26 6,333,329.00 66,667.00 58,002.74 124,669.74
27 6,266,662.00 66,667.00 57,392.18 124,059.18
28 6,199,995.00 66,667.00 56,781.62 123,448.62
29 6,133,328.00 66,667.00 56,171.06 122,838.06
30 6,066,661.00 66,667.00 55,560.50 122,227.50
31 5,999,994.00 66,667.00 54,949.95 121,616.95
32 5,933,327.00 66,667.00 54,339.39 121,006.39
33 5,866,660.00 66,667.00 53,728.83 120,395.83
34 5,799,993.00 66,667.00 53,118.27 119,785.27
35 5,733,326.00 66,667.00 52,507.71 119,174.71
36 5,666,659.00 66,667.00 51,897.15 118,564.15
37 5,599,992.00 66,667.00 51,286.59 117,953.59
38 5,533,325.00 66,667.00 50,676.03 117,343.03
39 5,466,658.00 66,667.00 50,065.48 116,732.48
40 5,399,991.00 66,667.00 49,454.92 116,121.92
41 5,333,324.00 66,667.00 48,844.36 115,511.36
42 5,266,657.00 66,667.00 48,233.80 114,900.8043 5,199,990.00 66,667.00 47,623.24 114,290.24
44 5,133,323.00 66,667.00 47,012.68 113,679.68
45 5,066,656.00 66,667.00 46,402.12 113,069.12
46 4,999,989.00 66,667.00 45,791.57 112,458.57
47 4,933,322.00 66,667.00 45,181.01 111,848.01
48 4,866,655.00 66,667.00 44,570.45 111,237.45
49 4,799,988.00 66,667.00 43,959.89 110,626.89
50 4,733,321.00 66,667.00 43,349.33 110,016.33
51 4,666,654.00 66,667.00 42,738.77 109,405.77
52 4,599,987.00 66,667.00 42,128.21 108,795.21
53 4,533,320.00 66,667.00 41,517.66 108,184.66
54 4,466,653.00 66,667.00 40,907.10 107,574.1055 4,399,986.00 66,667.00 40,296.54 106,963.54
56 4,333,319.00 66,667.00 39,685.98 106,352.98
57 4,266,652.00 66,667.00 39,075.42 105,742.42
58 4,199,985.00 66,667.00 38,464.86 105,131.86
59 4,133,318.00 66,667.00 37,854.30 104,521.30
-
7/25/2019 Scadentar Rata Bancare Excel
5/7
60 4,066,651.00 66,667.00 37,243.75 103,910.75
61 3,999,984.00 66,667.00 36,633.19 103,300.19
62 3,933,317.00 66,667.00 36,022.63 102,689.63
63 3,866,650.00 66,667.00 35,412.07 102,079.07
64 3,799,983.00 66,667.00 34,801.51 101,468.51
65 3,733,316.00 66,667.00 34,190.95 100,857.95
66 3,666,649.00 66,667.00 33,580.39 100,247.39
67 3,599,982.00 66,667.00 32,969.84 99,636.84
68 3,533,315.00 66,667.00 32,359.28 99,026.28
69 3,466,648.00 66,667.00 31,748.72 98,415.7270 3,399,981.00 66,667.00 31,138.16 97,805.16
71 3,333,314.00 66,667.00 30,527.60 97,194.60
72 3,266,647.00 66,667.00 29,917.04 96,584.04
73 3,199,980.00 66,667.00 29,306.48 95,973.48
74 3,133,313.00 66,667.00 28,695.92 95,362.92
75 3,066,646.00 66,667.00 28,085.37 94,752.37
76 2,999,979.00 66,667.00 27,474.81 94,141.81
77 2,933,312.00 66,667.00 26,864.25 93,531.25
78 2,866,645.00 66,667.00 26,253.69 92,920.69
79 2,799,978.00 66,667.00 25,643.13 92,310.13
80 2,733,311.00 66,667.00 25,032.57 91,699.57
81 2,666,644.00 66,667.00 24,422.01 91,089.0182 2,599,977.00 66,667.00 23,811.46 90,478.46
83 2,533,310.00 66,667.00 23,200.90 89,867.90
84 2,466,643.00 66,667.00 22,590.34 89,257.34
85 2,399,976.00 66,667.00 21,979.78 88,646.78
86 2,333,309.00 66,667.00 21,369.22 88,036.22
87 2,266,642.00 66,667.00 20,758.66 87,425.66
88 2,199,975.00 66,667.00 20,148.10 86,815.10
89 2,133,308.00 66,667.00 19,537.55 86,204.55
90 2,066,641.00 66,667.00 18,926.99 85,593.99
91 1,999,974.00 66,667.00 18,316.43 84,983.43
92 1,933,307.00 66,667.00 17,705.87 84,372.87
93 1,866,640.00 66,667.00 17,095.31 83,762.31
94 1,799,973.00 66,667.00 16,484.75 83,151.75
95 1,733,306.00 66,667.00 15,874.19 82,541.19
96 1,666,639.00 66,667.00 15,263.64 81,930.64
97 1,599,972.00 66,667.00 14,653.08 81,320.08
98 1,533,305.00 66,667.00 14,042.52 80,709.52
99 1,466,638.00 66,667.00 13,431.96 80,098.96
100 1,399,971.00 66,667.00 12,821.40 79,488.40
101 1,333,304.00 66,667.00 12,210.84 78,877.84
102 1,266,637.00 66,667.00 11,600.28 78,267.28
103 1,199,970.00 66,667.00 10,989.73 77,656.73
104 1,133,303.00 66,667.00 10,379.17 77,046.17105 1,066,636.00 66,667.00 9,768.61 76,435.61
106 999,969.00 66,667.00 9,158.05 75,825.05
107 933,302.00 66,667.00 8,547.49 75,214.49
108 866,635.00 66,667.00 7,936.93 74,603.93
109 799,968.00 66,667.00 7,326.37 73,993.37
110 733,301.00 66,667.00 6,715.81 73,382.81
111 666,634.00 66,667.00 6,105.26 72,772.26
112 599,967.00 66,667.00 5,494.70 72,161.70
113 533,300.00 66,667.00 4,884.14 71,551.14
114 466,633.00 66,667.00 4,273.58 70,940.58
115 399,966.00 66,667.00 3,663.02 70,330.02
116 333,299.00 66,667.00 3,052.46 69,719.46117 266,632.00 66,667.00 2,441.90 69,108.90
118 199,965.00 66,667.00 1,831.35 68,498.35
119 133,298.00 66,667.00 1,220.79 67,887.79
120 66,631.00 66,667.00 610.23 67,277.23
-
7/25/2019 Scadentar Rata Bancare Excel
6/7
Nr. luna Principal Rata principal Dobanda Total de plata
1 7,047,600.00 64,544.27 64,544.27
2 7,047,600.00 64,544.27 64,544.27
3 7,047,600.00 64,544.27 64,544.27
4 7,047,600.00 64,544.27 64,544.27
5 7,047,600.00 64,544.27 64,544.27
6 7,047,600.00 64,544.27 64,544.27
7 7,047,600.00 64,544.27 64,544.278 7,047,600.00 64,544.27 64,544.27
9 7,047,600.00 64,544.27 64,544.27
10 7,047,600.00 64,544.27 64,544.27
11 7,047,600.00 64,544.27 64,544.27
12 7,047,600.00 64,544.27 64,544.27
13 7,047,600.00 65,256.00 64,544.27 129,800.27
14 6,982,344.00 65,256.00 63,946.63 129,202.63
15 6,917,088.00 65,256.00 63,349.00 128,605.00
16 6,851,832.00 65,256.00 62,751.36 128,007.36
17 6,786,576.00 65,256.00 62,153.73 127,409.73
18 6,721,320.00 65,256.00 61,556.09 126,812.09
19 6,656,064.00 65,256.00 60,958.45 126,214.4520 6,590,808.00 65,256.00 60,360.82 125,616.82
21 6,525,552.00 65,256.00 59,763.18 125,019.18
22 6,460,296.00 65,256.00 59,165.54 124,421.54
23 6,395,040.00 65,256.00 58,567.91 123,823.91
24 6,329,784.00 65,256.00 57,970.27 123,226.27
25 6,264,528.00 65,256.00 57,372.64 122,628.64
26 6,199,272.00 65,256.00 56,775.00 122,031.00
27 6,134,016.00 65,256.00 56,177.36 121,433.36
28 6,068,760.00 65,256.00 55,579.73 120,835.73
29 6,003,504.00 65,256.00 54,982.09 120,238.09
30 5,938,248.00 65,256.00 54,384.45 119,640.45
31 5,872,992.00 65,256.00 53,786.82 119,042.82
32 5,807,736.00 65,256.00 53,189.18 118,445.18
33 5,742,480.00 65,256.00 52,591.55 117,847.55
34 5,677,224.00 65,256.00 51,993.91 117,249.91
35 5,611,968.00 65,256.00 51,396.27 116,652.27
36 5,546,712.00 65,256.00 50,798.64 116,054.64
37 5,481,456.00 65,256.00 50,201.00 115,457.00
38 5,416,200.00 65,256.00 49,603.37 114,859.37
39 5,350,944.00 65,256.00 49,005.73 114,261.73
40 5,285,688.00 65,256.00 48,408.09 113,664.09
41 5,220,432.00 65,256.00 47,810.46 113,066.46
42 5,155,176.00 65,256.00 47,212.82 112,468.8243 5,089,920.00 65,256.00 46,615.18 111,871.18
44 5,024,664.00 65,256.00 46,017.55 111,273.55
45 4,959,408.00 65,256.00 45,419.91 110,675.91
46 4,894,152.00 65,256.00 44,822.28 110,078.28
47 4,828,896.00 65,256.00 44,224.64 109,480.64
48 4,763,640.00 65,256.00 43,627.00 108,883.00
49 4,698,384.00 65,256.00 43,029.37 108,285.37
50 4,633,128.00 65,256.00 42,431.73 107,687.73
51 4,567,872.00 65,256.00 41,834.09 107,090.09
52 4,502,616.00 65,256.00 41,236.46 106,492.46
53 4,437,360.00 65,256.00 40,638.82 105,894.82
54 4,372,104.00 65,256.00 40,041.19 105,297.1955 4,306,848.00 65,256.00 39,443.55 104,699.55
56 4,241,592.00 65,256.00 38,845.91 104,101.91
57 4,176,336.00 65,256.00 38,248.28 103,504.28
58 4,111,080.00 65,256.00 37,650.64 102,906.64
59 4,045,824.00 65,256.00 37,053.00 102,309.00
-
7/25/2019 Scadentar Rata Bancare Excel
7/7
60 3,980,568.00 65,256.00 36,455.37 101,711.37
61 3,915,312.00 65,256.00 35,857.73 101,113.73
62 3,850,056.00 65,256.00 35,260.10 100,516.10
63 3,784,800.00 65,256.00 34,662.46 99,918.46
64 3,719,544.00 65,256.00 34,064.82 99,320.82
65 3,654,288.00 65,256.00 33,467.19 98,723.19
66 3,589,032.00 65,256.00 32,869.55 98,125.55
67 3,523,776.00 65,256.00 32,271.92 97,527.92
68 3,458,520.00 65,256.00 31,674.28 96,930.28
69 3,393,264.00 65,256.00 31,076.64 96,332.6470 3,328,008.00 65,256.00 30,479.01 95,735.01
71 3,262,752.00 65,256.00 29,881.37 95,137.37
72 3,197,496.00 65,256.00 29,283.73 94,539.73
73 3,132,240.00 65,256.00 28,686.10 93,942.10
74 3,066,984.00 65,256.00 28,088.46 93,344.46
75 3,001,728.00 65,256.00 27,490.83 92,746.83
76 2,936,472.00 65,256.00 26,893.19 92,149.19
77 2,871,216.00 65,256.00 26,295.55 91,551.55
78 2,805,960.00 65,256.00 25,697.92 90,953.92
79 2,740,704.00 65,256.00 25,100.28 90,356.28
80 2,675,448.00 65,256.00 24,502.64 89,758.64
81 2,610,192.00 65,256.00 23,905.01 89,161.0182 2,544,936.00 65,256.00 23,307.37 88,563.37
83 2,479,680.00 65,256.00 22,709.74 87,965.74
84 2,414,424.00 65,256.00 22,112.10 87,368.10
85 2,349,168.00 65,256.00 21,514.46 86,770.46
86 2,283,912.00 65,256.00 20,916.83 86,172.83
87 2,218,656.00 65,256.00 20,319.19 85,575.19
88 2,153,400.00 65,256.00 19,721.56 84,977.56
89 2,088,144.00 65,256.00 19,123.92 84,379.92
90 2,022,888.00 65,256.00 18,526.28 83,782.28
91 1,957,632.00 65,256.00 17,928.65 83,184.65
92 1,892,376.00 65,256.00 17,331.01 82,587.01
93 1,827,120.00 65,256.00 16,733.37 81,989.37
94 1,761,864.00 65,256.00 16,135.74 81,391.74
95 1,696,608.00 65,256.00 15,538.10 80,794.10
96 1,631,352.00 65,256.00 14,940.47 80,196.47
97 1,566,096.00 65,256.00 14,342.83 79,598.83
98 1,500,840.00 65,256.00 13,745.19 79,001.19
99 1,435,584.00 65,256.00 13,147.56 78,403.56
100 1,370,328.00 65,256.00 12,549.92 77,805.92
101 1,305,072.00 65,256.00 11,952.28 77,208.28
102 1,239,816.00 65,256.00 11,354.65 76,610.65
103 1,174,560.00 65,256.00 10,757.01 76,013.01
104 1,109,304.00 65,256.00 10,159.38 75,415.38105 1,044,048.00 65,256.00 9,561.74 74,817.74
106 978,792.00 65,256.00 8,964.10 74,220.10
107 913,536.00 65,256.00 8,366.47 73,622.47
108 848,280.00 65,256.00 7,768.83 73,024.83
109 783,024.00 65,256.00 7,171.19 72,427.19
110 717,768.00 65,256.00 6,573.56 71,829.56
111 652,512.00 65,256.00 5,975.92 71,231.92
112 587,256.00 65,256.00 5,378.29 70,634.29
113 522,000.00 65,256.00 4,780.65 70,036.65
114 456,744.00 65,256.00 4,183.01 69,439.01
115 391,488.00 65,256.00 3,585.38 68,841.38
116 326,232.00 65,256.00 2,987.74 68,243.74117 260,976.00 65,256.00 2,390.11 67,646.11
118 195,720.00 65,256.00 1,792.47 67,048.47
119 130,464.00 65,256.00 1,194.83 66,450.83
120 65,208.00 65,208.00 597.20 65,805.20