75
30/360
1.
Adjust D1 and D2 accor
ding to the fol-
lowing rules:
(1) If D2 and D1 ar
e both the last day of
February
, change D2 to 30.
(2) If D1 is the last day of February
,
change D1 to 30.
(3) If D2 is 31 and D1 is 30 or 31, change
D2 to 30.
(4) If D1 is 31, change D1 to 30.
2. Calculate using the following formula:
DA
YS = (Y2 – Y1)
×
360 + (M2 – M1)
×
30 + (D2 – D1)
Actual
P
e
rcent c
hang
e/Compound
interest calculations
wher
e NEW = NEW PRC(FV), OLD = OLD
PRC(PV), %CH = %(I/Y), PD = PERIODS(N)
Err
or
%CH –100
NEW
×
OLD 0
Cost/Sell/Mar
gin/Markup
calculations
wher
e MAR = MARGIN, MU = MARK UP
Breake
ven calculations
Statistical Calcula-
tion Form
ulas
T
y
pe
Regression f
orm
ula
Linear
y = a + bx
Quadr
atic
y = a + bx + cx
2
Exponential
y = a • e
bx
Logar
ithmic
y = a + b •
In
x
Po
w
e
r
y = a • x
b
In
v
erse
1
y = a + b
x
x
=
x
n
Σ
sx
=
x
2
– nx
2
n –
1
Σ
x
=
x
2
– nx
2
n
σ
Σ
x
=
x
1
+
x
2
+
···
+
x
n
Σ
x
2
=
x
1
2
+
x
2
2
+
···
+
x
n
2
Σ
y
=
y
n
Σ
sy
=
y
2
– ny
2
n –
1
Σ
y
=
y
2
– ny
2
n
Σ
σ
y
=
y
1
+
y
2
+
···
+
y
n
Σ
y
2
=
y
1
2
+
y
2
2
+
···
+
y
n
2
Σ
xy
=
x
1
y
1
+
x
2
y
2
+
···
+
x
n
y
n
Σ
An error will occur in a statisti-
cal calculation if:
•
The absolute v
alue of an
inter
mediate or calculation
result is equal to or g
reater
than 1
×
10
100
.
•
The denominator is z
ero
.
•
An attempt is made to fi
nd
the square root of a negativ
e
n
umber
.
•
No solution e
xists f
or a qua-
dr
atic reg
ression calculation.
Appendix.indd 75
06.7.10 8:42:06 PM
