Principal 50000

IR 0.1
Durée 5 YEARS

Year Principal Interest Amortization

1 50000 5000 8189.87403974
2 41810.126 4181.0126 9008.86144371
3 32801.2645 3280.12645 9909.74758808
4 22891.5169 2289.15169 10900.7223469
5 11990.7946 1199.07946 11990.7945816
YP
13189.8740397373
13189.8740397373
13189.8740397373
13189.8740397373
13189.8740397373
Investment 200 M EUR/years
re deposit in yea45 M tons
Production : 2 M tons / years
i 0.07
revenue 39 Meur/tons ore
co 19M eur/tons
L 150 M
interest rate 0.1
years 10

i 0.08
TRI 36%
loan NPV 112.474639739662 M EUR
IN FINE METHOD
TOTAL NPV 272.182983966107 M EUR

time principal interest amortisation yearly payment

1 150 15 0 15
2 150 15 0 15
3 150 15 0 15
4 150 15 0 15
5 150 15 0 15
6 150 15 0 15
7 150 15 0 15
8 150 15 0 15
9 150 15 0 15
10 150 15 150 165
 Reserves Production I CO Ru
0 45 0 270 0 0
1 42.5 2.5 0 40 100
2 40 2.5 0 40 100
3 37.5 2.5 0 40 100
4 35 2.5 0 40 100
5 32.5 2.5 0 40 100
6 30 2.5 0 40 100
7 27.5 2.5 0 40 100
8 25 2.5 0 40 100
9 22.5 2.5 0 40 100
10 20 2.5 0 40 100
11 17.5 2.5 0 40 100
12 15 2.5 0 40 100
13 12.5 2.5 0 40 100
14 10 2.5 0 40 100
15 7.5 2.5 0 40 100
16 5 2.5 0 40 100
17 2.5 2.5 0 40 100
18 0 2.5 0 40 100
L Yp CF CF@ CCF@
150 0 -120 -120 -120
15 45 41.666666666667 -78.33333333333
15 45 38.58024691358 -39.75308641975
15 45 35.722450845908 -4.030635573845
15 45 33.07634337584 29.045707801995
15 45 30.626243866519 59.671951668514
15 45 28.35763320974 88.029584878254
15 45 26.257067786796 114.28665266505
15 45 24.312099802589 138.59875246764
15 45 22.511203520916 161.10995598855
165 -105 -48.63531624889 112.47463973966
0 0 60 25.73297156026 138.20761129992
0 0 60 23.82682551876 162.03443681868
0 0 60 22.061875480333 184.09631229902
0 0 60 20.42766248179 204.52397478081
0 0 60 18.914502297953 223.43847707876
0 0 60 17.513428053661 240.95190513242
0 0 60 16.216137086723 257.16804221914
0 0 60 15.014941746966 272.18298396611
Investment 200 M EUR/years
re deposit in y45 M tons
Production : 2 M tons / years
i 0.07
revenue 39 Meur/tons ore
co 19M eur/tons
L 150 M
interest rate 0.1
years 10

i 0.08
TRI 29% THE CONSTANT
loan NPV 120.267689182517 M EUR AMORTIZATION
METHOD
TOTAL NPV 279.976033408961 M EUR

time principal interest amortisation yearly payment

1 150 15 15 30
2 135 13.5 15 28.5
3 120 12 15 27
4 105 10.5 15 25.5
5 90 9 15 24
6 75 7.5 15 22.5
7 60 6 15 21
8 45 4.5 15 19.5
9 30 3 15 18
10 15 1.5 15 16.5
 N reserve production I co Ru L
0 45 0 270 150
1 42.5 2.5 40 100
2 40 2.5 40 100
3 37.5 2.5 40 100
4 35 2.5 40 100
5 32.5 2.5 40 100
6 30 2.5 40 100
7 27.5 2.5 40 100
8 25 2.5 40 100
9 22.5 2.5 40 100
STANT 10 20 2.5 40 100
ZATION 11 17.5 2.5 40 100
D
12 15 2.5 40 100
13 12.5 2.5 40 100
14 10 2.5 40 100
15 7.5 2.5 40 100
16 5 2.5 40 100
17 2.5 2.5 40 100
18 0 2.5 40 100
amort cst yp CF CF@ cumul CF@
-120 -120 -120
15 30 30 27.7777777777778 -92.2222222
15 28.5 31.5 27.0061728395062 -65.2160494
15 27 33 26.1964639536656 -39.0195854
15 25.5 34.5 25.3585299214776 -13.6610555
15 24 36 24.5009950932151 10.8399396
15 22.5 37.5 23.6313610081164 34.4713006
15 21 39 22.7561254152232 57.227426
15 19.5 40.5 21.88088982233 79.1083158
15 18 42 21.0104566195213 100.118772
15 16.5 43.5 20.1489167316838 120.267689
0 60 25.7329715602602 146.000661
0 60 23.8268255187595 169.827486
0 60 22.0618754803328 191.889362
0 60 20.4276624817897 212.317024
0 60 18.9145022979534 231.231527
0 60 17.5134280536606 248.744955
0 60 16.2161370867227 264.961092
0 60 15.0149417469655 279.976033
Investment 200 M EUR/years
re deposit in y45 M tons
Production : 2 M tons / years
i 0.07
revenue 39 Meur/tons ore
co 19M eur/tons
L 150 M
interest rate 0.1
years 10

i 0.08
TRI 31% Paiement Constant
loan NPV 118.799656891808 M EUR
TOTAL NPV 278.508001118253 M EUR

Temps principal i amortisation

1 150 15 9.41180923
2 140.588190767623 14.05881908 10.3529902
3 130.235200612009 13.02352006 11.3882892
4 118.846911440833 11.88469114 12.5271181
5 106.31979335254 10.63197934 13.7798299
6 92.5399634554168 9.253996346 15.1578129
7 77.3821505685818 7.738215057 16.6735942
8 60.7085563930632 6.070855639 18.3409536
9 42.3676027999928 4.23676028 20.175049
10 22.1925538476153 2.219255385 22.1925538
 N reserve production I CO
0 45 0 270
1 42.5 2.5 40
2 40 2.5 40
3 37.5 2.5 40
4 35 2.5 40
5 32.5 2.5 40
6 30 2.5 40
7 27.5 2.5 40
8 25 2.5 40
9 22.5 2.5 40
Paiement Constant 10 20 2.5 40
11 17.5 2.5 40
12 15 2.5 40
13 12.5 2.5 40
Paiement annuel 14 10 2.5 40
24.4118092323767 15 7.5 2.5 40
24.4118092323767 16 5 2.5 40
24.4118092323767 17 2.5 2.5 40
24.4118092323767 18 0 2.5 40
24.4118092323767
24.4118092323767
24.4118092323767
24.4118092323767
24.4118092323768
24.4118092323768
Ru L amortissement Yp CF CF@ cumul CF@
150 -120 -120 -120
100 9.41180923 24.4118092 35.5881908 32.9520285 -87.0479715
100 10.3529902 24.4118092 35.5881908 30.5111375 -56.536834
100 11.3882892 24.4118092 35.5881908 28.2510532 -28.2857808
100 12.5271181 24.4118092 35.5881908 26.1583826 -2.12739817
100 13.7798299 24.4118092 35.5881908 24.2207246 22.0933265
100 15.1578129 24.4118092 35.5881908 22.4265969 44.5199234
100 16.6735942 24.4118092 35.5881908 20.7653675 65.2852909
100 18.3409536 24.4118092 35.5881908 19.2271921 84.512483
100 20.175049 24.4118092 35.5881908 17.8029557 102.315439
100 22.1925538 24.4118092 35.5881908 16.4842182 118.799657
100 60 25.7329716 144.532628
100 60 23.8268255 168.359454
100 60 22.0618755 190.421329
100 60 20.4276625 210.848992
100 60 18.9145023 229.763494
100 60 17.5134281 247.276922
100 60 16.2161371 263.493059
100 60 15.0149417 278.508001
METHODE Net prevent value
in fine method 112.474639739662
constant amortization 120.267689182517
constant payment method 118.799656891808

la NPV par in fine method est celle

élévée que celles des autres méthode
fine method est celle choisie! car elle est moins
les des autres méthodes dans le processus d'emprunt.