Scribd
Upload
19 views11 pages

IRR Calculation for 7-Year Project

The document outlines calculations for Present Value (PV), Future Value (FV), and Internal Rate of Return (IRR) based on cash flows over five years with an 8% interest rate. It also includes a loan schedule for a loan amount of INR 2,500,000 at a 10% annual interest rate, detailing the Equated Monthly Installment (EMI) and the breakdown of principal and interest. Additionally, it mentions date and time functions for calculating differences between dates.

Uploaded by

zaffarsharief2003
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
19 views11 pages

IRR Calculation for 7-Year Project

The document outlines calculations for Present Value (PV), Future Value (FV), and Internal Rate of Return (IRR) based on cash flows over five years with an 8% interest rate. It also includes a loan schedule for a loan amount of INR 2,500,000 at a 10% annual interest rate, detailing the Equated Monthly Installment (EMI) and the breakdown of principal and interest. Additionally, it mentions date and time functions for calculating differences between dates.

Uploaded by

zaffarsharief2003
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Calculating PV & FV

Interest Rate 8%

Year 0 1 2 3 4 5
Cashflow -1000 75 150 200 275 350
PV of Cashflow -1000

DCF Approach- Projected NPV -1000

NPV
Mention the formulas used while calculating this sum
Calculating Internal Rate of Return (IRR) Mention the formulas used while calcula

Interest Rate 8%

Year 0 1 2 3 4 5
Cashflow -1000 75 150 200 275 350
PV of Cashflow -1000
PV @ new IRR -1000

DCF Approach- Projected NPV -1000

NPV
₹ 0.00

IRR
he formulas used while calculating this sum
Loan Schedule Mention the formulas used while c

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
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
he formulas 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 3/2/2024

6/5/2023 8/8/2023 6/5/2023

12/24/2021 12/25/2021 12/24/2021

You might also like