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


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


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 #",#&"


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


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


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/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

scadentar rata bancare excel

Documents