Loading ...
Loading ...
Loading ...
APPENDIX - Reference Information 91
VC =variable cost
Q =quantity
Days between Dates
With the Date worksheet, you can enter or compute a date within the
range January 1, 1950, through December 31, 2049.
Actual/actual day-count method
Note: The method assumes the actual number of days per month and
per year.
DBD (days between dates) = number of days II - number of days I
Number of Days I
= (Y1 - YB) Q 365
+ (
number of days MB to M1)
+ DT1
+
Number of Days II=(Y2 - YB) Q 365
+ (
number of days MB to M2)
+
DT2
+
where:
M1 =month of first date
DT1 =day of first date
Y1 =year of first date
M2 =month of second date
DT2 =day of second date
Y2 =year of second date
MB =base month (January)
DB =base day (1)
YB =base year (first year after leap year)
30/360 day-count method
1
Note: The method assumes 30 days per month and 360 days per year.
1.Source for 30/360 day-count method formula: Lynch, John
J., Jr., and Jan H. Mayle. Standard Securities Calculation
Methods. New York: Securities Industry Association, 1986
Y1 YB–
4
------------------------
Y2 YB–
4
------------------------
Loading ...
Loading ...
Loading ...