A	B	C	D	E	F	G	H	I	J	K	L	M	N
2
3		Example: Periods - Advance and Arrears
4
5		n  Uses Con
6
7		n  The Business Functions Library has functions that cope with both Accruals and Cash projections.
8		n  There is a variable, Periods, used with DayCount option 6, for fine control over Actual/Actual (in period) daycount
9
10		Does Advance or Arrears have anything to do with it?
11
12		n  In a Cash function, of course it makes a difference. But in an Accruals function, {7.01} in advance is the same as {-7.01} in arrears
13
14		n  However you can specify Periods as periods in arrear (negative figures) providing you recall that periods specified in arrear accrue to the day BEFORE the payment date
15
16		n  Payment in arrear still therefore adheres to BF's rule of 'include the start date, exclude the finish date'
17
18					ie	1.01	7.01	=	(1.01)	(7.01)
19
20							Bi-annual in advance starting on the 1st Jan and 1st Jul	=	Bi-Annual in Arrears running up to but not including the 1st Jan and 1st Jul
21									ie running up to and including 31st Dec and 30th Jun.
22
23					and	1.02	7.02	=	(1.02)	(7.02)
24
25		n  Whether specified in advance or arrear, the year is still divided up in the same way
26
27				Period 1:		1st Jan - 1st Jul exclusive			or	1st Jan - 30th June inclusive
28				Period 2:		1st Jul - 1st Jan exclusive			or	1st Jul - 31st Dec inclusive
29		Consequences
30
31		n  If you do specify periods in arrears in an accruals function, remember that they should be a day behind their correspoonding in advance counterparts.
32
33		Same Thing	1 Apr 04	1 Oct 05		1.01	7.01			1500.00
34		Same Thing	1 Apr 04	1 Oct 05		(1.01)	(7.01)			1500.00
35
36		Same Thing	1 Apr 04	1 Oct 05		1.02	7.02			1500.03
37		Same Thing	1 Apr 04	1 Oct 05		(1.02)	(7.02)			1500.03
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80