0% ont trouvé ce document utile (0 vote)
11 vues12 pages

Dossier 3

Le document présente des tableaux financiers détaillant les valeurs d'actifs, les dotations, les amortissements et les pertes sur plusieurs années. Il inclut également des informations sur les dettes, les loyers et les intérêts associés. Les données s'étendent de 2013 à 2036, montrant une tendance générale de diminution des valeurs nettes comptables (VNC) et des dettes au fil du temps.

Transféré par

fificac96
Copyright
© © All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd
0% ont trouvé ce document utile (0 vote)
11 vues12 pages

Dossier 3

Le document présente des tableaux financiers détaillant les valeurs d'actifs, les dotations, les amortissements et les pertes sur plusieurs années. Il inclut également des informations sur les dettes, les loyers et les intérêts associés. Les données s'étendent de 2013 à 2036, montrant une tendance générale de diminution des valeurs nettes comptables (VNC) et des dettes au fil du temps.

Transféré par

fificac96
Copyright
© © All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd

année, VO Ajustement provision

2015 15,421,732 1,542,173 16,963,905


2016 16,963,905 1,696,390 18,660,295
2017 18,660,295 1,866,030 20,526,325
2018 20,526,325 2,052,632 22,578,957
2019 22,578,957 2,257,896 24,836,853
2020 24,836,853 2,483,685 27,320,538
2021 27,320,538 2,732,054 30,052,592
2022 30,052,592 3,005,259 33,057,851
2023 33,057,851 3,305,785 36,363,636
2024 36,363,636 3,636,364 40,000,000
dotation amortissement
1,542,173 3,084,346 4,000,000 915,654
1,542,173 3,238,564 4,000,000 761,436
1,542,173 3,408,203 4,000,000 591,797
1,542,173 3,594,806 4,000,000 405,194
1,542,173 3,800,069 4,000,000 199,931
1,542,173 4,025,858 4,000,000 - 25,858
1,542,173 4,274,227 4,000,000 - 274,227
1,542,173 4,547,432 4,000,000 - 547,432
1,542,173 4,847,958 4,000,000 - 847,958
1,542,173 5,178,537 4,000,000 - 1,178,537
40,000,000 40,000,000
année VO dotation culule VNC
2013 25,000,000 3,000,000 3,000,000 22,000,000
2014 22,000,000 3,000,000 6,000,000 19,000,000
2015 19,000,000 3,000,000 9,000,000 16,000,000
2016 11,000,000 1,666,667 10,666,667 9,333,333
2017 9,333,333 1,666,667 12,333,333 7,666,667
2018 7,666,667 1,666,667 14,000,000 6,000,000
2019 6,000,000 1,666,667 15,666,667 4,333,333
2020 4,333,333 1,666,667 17,333,333 2,666,667
2021 2,666,667 1,666,667 19,000,000 1,000,000

année VO dotation culule pertes


2013 25,000,000 3,000,000 3,000,000
2014 22,000,000 3,000,000 6,000,000
2015 19,000,000 3,000,000 9,000,000 - 5,000,000
2016 11,000,000 1,666,667 10,666,667
2017 9,333,333 1,666,667 12,333,333
2018 7,666,667 1,666,667 14,000,000 2,500,000
2019 8,500,000 2,500,000 16,500,000
2020 6,000,000 2,500,000 19,000,000
2021 3,500,000 2,500,000 21,500,000
pertes VR année VO dotation
22,000,000 2013 25,000,000 2,666,667
19,000,000 2014 22,333,333 2,666,667
- 5,000,000 11,000,000 2015 19,666,667 2,666,667
9,333,333 2016 17,000,000 2,666,667
7,666,667 2017 14,333,333 2,666,667
6,000,000 2018 11,666,667 2,666,667
4,333,333 2019 9,000,000 2,666,667
2,666,667 2020 6,333,333 2,666,667
1,000,000 2021 3,666,667 2,666,667

VNC année VO dotation


22,000,000 2013 25,000,000 2,666,667
19,000,000 2014 22,333,333 2,666,667
11,000,000 2015 19,666,667 2,666,667
9,333,333 2016 17,000,000 2,666,667
7,666,667 2017 14,333,333 2,666,667
8,500,000 - 500,000 - 500,000 2018 11,666,667 2,666,667
6,000,000 2019 9,000,000 2,666,667
3,500,000 2020 6,333,333 2,666,667
1,000,000 2021 3,666,667 2,666,667
culule VNC
2,666,667 22,333,333
5,333,333 19,666,667
8,000,000 17,000,000
10,666,667 14,333,333
13,333,333 11,666,667
16,000,000 9,000,000
18,666,667 6,333,333
21,333,333 3,666,667
24,000,000 1,000,000

culule VNC
2,666,667 22,333,333
5,333,333 19,666,667
8,000,000 17,000,000
10,666,667 14,333,333
13,333,333 11,666,667
16,000,000 9,000,000
18,666,667 6,333,333
21,333,333 3,666,667
24,000,000 1,000,000
Tableau d’amortissement

année VO GWH Dotation GWH dotation ann


1 2017 8,000,000,000 200 2,077,922 415,584,416
2 2018 7,584,415,584 200 2,077,922 415,584,416
3 2019 7,168,831,169 200 2,077,922 415,584,416
4 2020 6,753,246,753 200 2,077,922 415,584,416
5 2021 6,337,662,338 200 2,077,922 415,584,416
6 2022 5,922,077,922 200 2,077,922 415,584,416
7 2023 5,506,493,506 200 2,077,922 415,584,416
8 2024 5,090,909,091 200 2,077,922 415,584,416
9 2025 4,675,324,675 200 2,077,922 415,584,416
10 2026 4,259,740,260 200 2,077,922 415,584,416
11 2027 3,844,155,844 190 2,077,922 394,805,195
12 2028 3,449,350,649 190 2,077,922 394,805,195
13 2029 3,054,545,455 185 2,151,088 397,951,344
14 2030 2,656,594,110 185 2,151,088 397,951,344
15 2031 2,258,642,766 185 2,151,088 397,951,344
16 2032 1,860,691,421 185 2,151,088 397,951,344
17 2033 1,462,740,077 170 2,151,088 365,685,019
18 2034 1,097,055,058 170 2,151,088 365,685,019
19 2035 731,370,038 170 2,151,088 365,685,019
20 2036 365,685,019 170 2,151,088 365,685,019
cumule VNC
415,584,416 7,584,415,584
831,168,831 7,168,831,169
1,246,753,247 6,753,246,753
1,662,337,662 6,337,662,338
2,077,922,078 5,922,077,922
2,493,506,494 5,506,493,506
2,909,090,909 5,090,909,091
3,324,675,325 4,675,324,675
3,740,259,740 4,259,740,260
4,155,844,156 3,844,155,844
4,550,649,351 3,449,350,649
4,945,454,545 3,054,545,455
5,343,405,890 2,656,594,110
5,741,357,234 2,258,642,766
6,139,308,579 1,860,691,421
6,537,259,923 1,462,740,077
6,902,944,942 1,097,055,058
7,268,629,962 731,370,038
7,634,314,981 365,685,019
8,000,000,000 0
date valeur dette loyer interets cap
9/30/2015 20,000,000 753,661.52 357,192.34 396,469.18
10/31/2015 19,603,531 753,661.52 350,111.55 403,549.97
11/30/2015 19,199,981 753,661.52 342,904.31 410,757.21
12/31/2015 18,789,224 753,661.52 335,568.34 418,093.18
1/31/2016 18,371,130 753,661.52 328,101.36 425,560.16
2/29/2016 17,945,570 753,661.52 320,501.01 433,160.51
3/31/2016 17,512,410 753,661.52 312,764.93 440,896.59
4/30/2016 17,071,513 753,661.52 304,890.69 448,770.83
5/31/2016 16,622,742 753,661.52 296,875.81 456,785.71
6/30/2016 16,165,957 753,661.52 288,717.80 464,943.72
7/31/2016 15,701,013 753,661.52 280,414.08 473,247.44
8/31/2016 15,227,766 753,661.52 271,962.06 481,699.46
9/30/2016 14,746,066 753,661.52 263,359.09 490,302.43
10/31/2016 14,255,764 753,661.52 254,602.48 499,059.04
11/30/2016 13,756,705 753,661.52 245,689.48 507,972.04
12/31/2016 13,248,733 753,661.52 236,617.29 517,044.23
1/31/2017 12,731,688 753,661.52 227,383.08 526,278.44
2/28/2017 12,205,410 753,661.52 217,983.95 535,677.57
3/31/2017 11,669,732 753,661.52 208,416.95 545,244.57
4/30/2017 11,124,488 753,661.52 198,679.09 554,982.43
5/31/2017 10,569,505 753,661.52 188,767.32 564,894.20
6/30/2017 10,004,611 753,661.52 178,678.52 574,983.00
7/31/2017 9,429,628 753,661.52 168,409.55 585,251.97
8/31/2017 8,844,376 753,661.52 157,957.17 595,704.35
9/30/2017 8,248,672 753,661.52 147,318.12 606,343.40
10/31/2017 7,642,328 753,661.52 136,489.06 617,172.46
11/30/2017 7,025,156 753,661.52 125,466.59 628,194.93
12/31/2017 6,396,961 753,661.52 114,247.27 639,414.25
1/31/2018 5,757,547 753,661.52 102,827.58 650,833.94
2/28/2018 5,106,713 753,661.52 91,203.94 662,457.58
3/31/2018 4,444,255 753,661.52 79,372.70 674,288.82
4/30/2018 3,769,966 753,661.52 67,330.16 686,331.36
5/31/2018 3,083,635 753,661.52 55,072.54 698,588.98
6/30/2018 2,385,046 753,661.52 42,596.01 711,065.51
7/31/2018 1,673,981 753,661.52 29,896.65 723,764.87
8/31/2018 950,216 753,661.52 16,970.49 736,691.03
9/1/2018 213,525 200,000.00 - 200,000.00
date valeur dette loyer
19,603,531 9/1/2015 20,000,000
19,199,981 9/30/2015 - 753,662
18,789,224 10/31/2015 - 753,662
18,371,130 11/30/2015 - 753,662
17,945,570 12/31/2015 - 753,662
17,512,410 1/31/2016 - 753,662
17,071,513 2/29/2016 - 753,662
16,622,742 3/31/2016 - 753,662
16,165,957 4/30/2016 - 753,662
15,701,013 5/31/2016 - 753,662
15,227,766 6/30/2016 - 753,662
14,746,066 7/31/2016 - 753,662
14,255,764 8/31/2016 - 753,662
13,756,705 9/30/2016 - 753,662
13,248,733 10/31/2016 - 753,662
12,731,688 11/30/2016 - 753,662
12,205,410 12/31/2016 - 753,662
11,669,732 1/31/2017 - 753,662
11,124,488 2/28/2017 - 753,662
10,569,505 3/31/2017 - 753,662
10,004,611 4/30/2017 - 753,662
9,429,628 5/31/2017 - 753,662
8,844,376 6/30/2017 - 753,662
8,248,672 7/31/2017 - 753,662
7,642,328 8/31/2017 - 753,662
7,025,156 9/30/2017 - 753,662
6,396,961 10/31/2017 - 753,662
5,757,547 11/30/2017 - 753,662
5,106,713 12/31/2017 - 753,662
4,444,255 1/31/2018 - 753,662
3,769,966 2/28/2018 - 753,662
3,083,635 3/31/2018 - 753,662
2,385,046 4/30/2018 - 753,662
1,673,981 5/31/2018 - 753,662
950,216 6/30/2018 - 753,662
213,525 7/31/2018 - 753,662
13,525 8/31/2018 - 753,662
9/1/2018 - 200,000
23.667%

1.2366722
1.017860
0.017860
2,000,000,000
100,000,000
25,000,000
3,475,000
9,622,000
900,000
13,997,000

Vous aimerez peut-être aussi