Filter
Top Products
237
Appendix
5. Error Conditions Relating to Specific Tasks
1. Financial
* Define constants “r” and “s” as used in the equation below.
r =
S = 1 (Pmt_Begin)
S = 0 (Pmt_End)
(
{}
)
÷ C/Y + 1 – 1 ,
I (%)
100
C/Y
P/Y
1. I% calculation
1 If PMT = 0
r = – 1-
()
1
n
-
PV
FV
2 If PMT ≠ 0
f (r) = PV + (1 + r × s) × PMT ×
1
–
(1
+
r)
-
n
r
+ FV (1 + r)
-
n
: (r ≠ 0)
f (r) = PV + PMT × n + FV: (r = 0)
calculate the following for r solved in 1 and 2
I (%) = 100
× C/Y × ((r + 1)
P/Y
C/Y
–1)
2. PV calculation
1 If r ≠ 0, r >
-1
PV = - (1 + r × s) ×
1
–
(1
+
r)
-
n
r
× PMT – FV × (1 + r)
-
n
2 If r = 0
PV = -n × PMT – FV
3 If r ≤ -1
Error