Operation Manual

185
Appendix E
Formulas Used
Percentage
% =
% =
%T =
Interest
Simple Interest
I
360
=
I
365
=
Compound Interest
Without an odd period:
0 =
n = number of compounding periods.
i = periodic interest rate, expressed as a decimal.
PV = present value.
FV = future value or balance.
PMT = periodic payment.
S = payment mode factor (0 or 1) indicating treatment
of PMT. 0 corresponds to End, 1 to Begin.
I = interest amount.
INTG (n) = integer portion of n.
FRAC (n) = fractional portion of n.
Base x() Rate x()×
100
----------------------------------------------
100
NewAmount x() Base y()
Base y()
--------------------------------------------------------------------


100
Amount x()
Total y()
-----------------------------


n
360
---------
PV i××
n
365
---------
PV× i×
PV 1 iS+()PMT
11i+()
n
i
------------------------------
FV 1 i+()
n
+⋅⋅+