185
Formulas Used
Percentage
% =
∆% =
%T =
Interest
Simple Interest
I
360
=
I
365
=
Compound Interest
Without an odd period:
0 =
With simple interest used for an odd period:
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 y() 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–
+⋅⋅+