Scribd
Importer
3 vues11 pages

Calcul des Flux de Trésorerie et NPV

Le document présente des calculs de valeur actuelle (PV) et de valeur future (FV) pour des flux de trésorerie sur cinq ans avec un taux d'intérêt de 8%. Il inclut également le calcul du taux de rendement interne (IRR) et un calendrier de remboursement de prêt pour un montant de 2,5 millions INR à un taux d'intérêt annuel de 10%. Les résultats montrent un NPV projeté de -202,85 et un IRR de 1,35%.

Transféré par

xokaw78204
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
3 vues11 pages

Calcul des Flux de Trésorerie et NPV

Le document présente des calculs de valeur actuelle (PV) et de valeur future (FV) pour des flux de trésorerie sur cinq ans avec un taux d'intérêt de 8%. Il inclut également le calcul du taux de rendement interne (IRR) et un calendrier de remboursement de prêt pour un montant de 2,5 millions INR à un taux d'intérêt annuel de 10%. Les résultats montrent un NPV projeté de -202,85 et un IRR de 1,35%.

Transféré par

xokaw78204
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

Calculating PV & FV Mention the form

Interest Rate 8%

Year 0 1 2 3 4 5
Cashflow -1000 75 150 200 275 350
PV of Cashflow -1000 69 129 159 202 238

DCF Approach- Projected NPV -202.851

NPV
Mention the formulas used while calculating this sum
Future cash flow/(1+r)^n
Calculating Internal Rate of Return (IRR) Mention the formulas used while calculati
Future cash flow/(1+r)^
Interest Rate 8%

Year 0 1 2 3 4 5
Cashflow -1000 75 150 200 275 350
PV of Cashflow -1000 69 129 159 202 238
PV @ new IRR -1000 74 146 192 261 327

DCF Approach- Projected NPV -202.851

NPV ₹ 797.15
₹ -202.85

IRR 1.35%
e formulas used while calculating this sum
Loan Schedule Mention the formulas used while calculating

Tenure in months 120


Interest Rate Annual 10%
Interest Rate Monthly 0.83%
Loan INR 2,500,000

EMI ₹ 33,037.68

Month EMI Interest Principal Residual Loan


1 ₹ 33,037.68 20,833.33 ₹ 12,204.35 2,487,795.65
2 ₹ 33,037.68 20,731.63 ₹ 12,306.05 2,475,489.60
3 ₹ 33,037.68 20,629.08 ₹ 12,408.60 2,463,080.99
4 ₹ 33,037.68 20,525.67 ₹ 12,512.01 2,450,568.98
5 ₹ 33,037.68 20,421.41 ₹ 12,616.28 2,437,952.71
6 ₹ 33,037.68 20,316.27 ₹ 12,721.41 2,425,231.29
7 ₹ 33,037.68 20,210.26 ₹ 12,827.42 2,412,403.87
8 ₹ 33,037.68 20,103.37 ₹ 12,934.32 2,399,469.55
9 ₹ 33,037.68 19,995.58 ₹ 13,042.10 2,386,427.45
10 ₹ 33,037.68 19,886.90 ₹ 13,150.79 2,373,276.66
11 ₹ 33,037.68 19,777.31 ₹ 13,260.38 2,360,016.28
12 ₹ 33,037.68 19,666.80 ₹ 13,370.88 2,346,645.40
13 ₹ 33,037.68 19,555.38 ₹ 13,482.31 2,333,163.09
14 ₹ 33,037.68 19,443.03 ₹ 13,594.66 2,319,568.43
15 ₹ 33,037.68 19,329.74 ₹ 13,707.95 2,305,860.49
16 ₹ 33,037.68 19,215.50 ₹ 13,822.18 2,292,038.31
17 ₹ 33,037.68 19,100.32 ₹ 13,937.37 2,278,100.94
18 ₹ 33,037.68 18,984.17 ₹ 14,053.51 2,264,047.43
19 ₹ 33,037.68 18,867.06 ₹ 14,170.62 2,249,876.81
20 ₹ 33,037.68 18,748.97 ₹ 14,288.71 2,235,588.10
21 ₹ 33,037.68 18,629.90 ₹ 14,407.78 2,221,180.31
22 ₹ 33,037.68 18,509.84 ₹ 14,527.85 2,206,652.47
23 ₹ 33,037.68 18,388.77 ₹ 14,648.91 2,192,003.55
24 ₹ 33,037.68 18,266.70 ₹ 14,770.99 2,177,232.57
25 ₹ 33,037.68 18,143.60 ₹ 14,894.08 2,162,338.49
26 ₹ 33,037.68 18,019.49 ₹ 15,018.20 2,147,320.29
27 ₹ 33,037.68 17,894.34 ₹ 15,143.35 2,132,176.94
28 ₹ 33,037.68 17,768.14 ₹ 15,269.54 2,116,907.40
29 ₹ 33,037.68 17,640.89 ₹ 15,396.79 2,101,510.61
30 ₹ 33,037.68 17,512.59 ₹ 15,525.10 2,085,985.51
31 ₹ 33,037.68 17,383.21 ₹ 15,654.47 2,070,331.04
32 ₹ 33,037.68 17,252.76 ₹ 15,784.93 2,054,546.11
33 ₹ 33,037.68 17,121.22 ₹ 15,916.47 2,038,629.65
34 ₹ 33,037.68 16,988.58 ₹ 16,049.10 2,022,580.54
35 ₹ 33,037.68 16,854.84 ₹ 16,182.85 2,006,397.70
36 ₹ 33,037.68 16,719.98 ₹ 16,317.70 1,990,079.99
37 ₹ 33,037.68 16,584.00 ₹ 16,453.68 1,973,626.31
38 ₹ 33,037.68 16,446.89 ₹ 16,590.80 1,957,035.51
39 ₹ 33,037.68 16,308.63 ₹ 16,729.05 1,940,306.46
40 ₹ 33,037.68 16,169.22 ₹ 16,868.46 1,923,437.99
41 ₹ 33,037.68 16,028.65 ₹ 17,009.03 1,906,428.96
42 ₹ 33,037.68 15,886.91 ₹ 17,150.78 1,889,278.18
43 ₹ 33,037.68 15,743.98 ₹ 17,293.70 1,871,984.48
44 ₹ 33,037.68 15,599.87 ₹ 17,437.81 1,854,546.67
45 ₹ 33,037.68 15,454.56 ₹ 17,583.13 1,836,963.54
46 ₹ 33,037.68 15,308.03 ₹ 17,729.65 1,819,233.89
47 ₹ 33,037.68 15,160.28 ₹ 17,877.40 1,801,356.48
48 ₹ 33,037.68 15,011.30 ₹ 18,026.38 1,783,330.10
49 ₹ 33,037.68 14,861.08 ₹ 18,176.60 1,765,153.50
50 ₹ 33,037.68 14,709.61 ₹ 18,328.07 1,746,825.43
51 ₹ 33,037.68 14,556.88 ₹ 18,480.81 1,728,344.63
52 ₹ 33,037.68 14,402.87 ₹ 18,634.81 1,709,709.82
53 ₹ 33,037.68 14,247.58 ₹ 18,790.10 1,690,919.71
54 ₹ 33,037.68 14,091.00 ₹ 18,946.69 1,671,973.03
55 ₹ 33,037.68 13,933.11 ₹ 19,104.58 1,652,868.45
56 ₹ 33,037.68 13,773.90 ₹ 19,263.78 1,633,604.67
57 ₹ 33,037.68 13,613.37 ₹ 19,424.31 1,614,180.36
58 ₹ 33,037.68 13,451.50 ₹ 19,586.18 1,594,594.18
59 ₹ 33,037.68 13,288.28 ₹ 19,749.40 1,574,844.78
60 ₹ 33,037.68 13,123.71 ₹ 19,913.98 1,554,930.80
61 ₹ 33,037.68 12,957.76 ₹ 20,079.93 1,534,850.87
62 ₹ 33,037.68 12,790.42 ₹ 20,247.26 1,514,603.61
63 ₹ 33,037.68 12,621.70 ₹ 20,415.99 1,494,187.62
64 ₹ 33,037.68 12,451.56 ₹ 20,586.12 1,473,601.50
65 ₹ 33,037.68 12,280.01 ₹ 20,757.67 1,452,843.83
66 ₹ 33,037.68 12,107.03 ₹ 20,930.65 1,431,913.18
67 ₹ 33,037.68 11,932.61 ₹ 21,105.07 1,410,808.11
68 ₹ 33,037.68 11,756.73 ₹ 21,280.95 1,389,527.16
69 ₹ 33,037.68 11,579.39 ₹ 21,458.29 1,368,068.86
70 ₹ 33,037.68 11,400.57 ₹ 21,637.11 1,346,431.75
71 ₹ 33,037.68 11,220.26 ₹ 21,817.42 1,324,614.33
72 ₹ 33,037.68 11,038.45 ₹ 21,999.23 1,302,615.10
73 ₹ 33,037.68 10,855.13 ₹ 22,182.56 1,280,432.54
74 ₹ 33,037.68 10,670.27 ₹ 22,367.41 1,258,065.13
75 ₹ 33,037.68 10,483.88 ₹ 22,553.81 1,235,511.32
76 ₹ 33,037.68 10,295.93 ₹ 22,741.76 1,212,769.57
77 ₹ 33,037.68 10,106.41 ₹ 22,931.27 1,189,838.30
78 ₹ 33,037.68 9,915.32 ₹ 23,122.37 1,166,715.93
79 ₹ 33,037.68 9,722.63 ₹ 23,315.05 1,143,400.88
80 ₹ 33,037.68 9,528.34 ₹ 23,509.34 1,119,891.54
81 ₹ 33,037.68 9,332.43 ₹ 23,705.25 1,096,186.28
82 ₹ 33,037.68 9,134.89 ₹ 23,902.80 1,072,283.48
83 ₹ 33,037.68 8,935.70 ₹ 24,101.99 1,048,181.49
84 ₹ 33,037.68 8,734.85 ₹ 24,302.84 1,023,878.65
85 ₹ 33,037.68 8,532.32 ₹ 24,505.36 999,373.29
86 ₹ 33,037.68 8,328.11 ₹ 24,709.57 974,663.72
87 ₹ 33,037.68 8,122.20 ₹ 24,915.49 949,748.23
88 ₹ 33,037.68 7,914.57 ₹ 25,123.12 924,625.12
89 ₹ 33,037.68 7,705.21 ₹ 25,332.47 899,292.64
90 ₹ 33,037.68 7,494.11 ₹ 25,543.58 873,749.06
91 ₹ 33,037.68 7,281.24 ₹ 25,756.44 847,992.62
92 ₹ 33,037.68 7,066.61 ₹ 25,971.08 822,021.54
93 ₹ 33,037.68 6,850.18 ₹ 26,187.50 795,834.04
94 ₹ 33,037.68 6,631.95 ₹ 26,405.73 769,428.30
95 ₹ 33,037.68 6,411.90 ₹ 26,625.78 742,802.52
96 ₹ 33,037.68 6,190.02 ₹ 26,847.66 715,954.86
97 ₹ 33,037.68 5,966.29 ₹ 27,071.39 688,883.47
98 ₹ 33,037.68 5,740.70 ₹ 27,296.99 661,586.48
99 ₹ 33,037.68 5,513.22 ₹ 27,524.46 634,062.01
100 ₹ 33,037.68 5,283.85 ₹ 27,753.83 606,308.18
101 ₹ 33,037.68 5,052.57 ₹ 27,985.12 578,323.06
102 ₹ 33,037.68 4,819.36 ₹ 28,218.33 550,104.74
103 ₹ 33,037.68 4,584.21 ₹ 28,453.48 521,651.26
104 ₹ 33,037.68 4,347.09 ₹ 28,690.59 492,960.67
105 ₹ 33,037.68 4,108.01 ₹ 28,929.68 464,030.99
106 ₹ 33,037.68 3,866.92 ₹ 29,170.76 434,860.23
107 ₹ 33,037.68 3,623.84 ₹ 29,413.85 405,446.38
108 ₹ 33,037.68 3,378.72 ₹ 29,658.96 375,787.42
109 ₹ 33,037.68 3,131.56 ₹ 29,906.12 345,881.30
110 ₹ 33,037.68 2,882.34 ₹ 30,155.34 315,725.96
111 ₹ 33,037.68 2,631.05 ₹ 30,406.63 285,319.32
112 ₹ 33,037.68 2,377.66 ₹ 30,660.02 254,659.30
113 ₹ 33,037.68 2,122.16 ₹ 30,915.52 223,743.77
114 ₹ 33,037.68 1,864.53 ₹ 31,173.15 192,570.62
115 ₹ 33,037.68 1,604.76 ₹ 31,432.93 161,137.69
116 ₹ 33,037.68 1,342.81 ₹ 31,694.87 129,442.82
117 ₹ 33,037.68 1,078.69 ₹ 31,958.99 97,483.83
118 ₹ 33,037.68 812.37 ₹ 32,225.32 65,258.51
119 ₹ 33,037.68 543.82 ₹ 32,493.86 32,764.65
120 ₹ 33,037.68 273.04 ₹ 32,764.65 0.00
s used while calculating this sum
Date & Time Functions
Start End Difference Start End of month Exact date Exact date
3/2/2024 4/3/2024 -32 3/2/2024 3/31/2024 8/2/2024 3/2/2034

6/5/2023 8/8/2023 -64 6/5/2023 6/30/2023 11/5/2023 6/5/2033

12/24/2021 12/25/2021 -1 12/24/2021 12/31/2021 5/24/2022 12/24/2031

Vous aimerez peut-être aussi