A	B	C	D	E	F	G	H	I	J	K	L	M	N
2										Base	1 months
3		Accounts Receivable
4
5		Months To Pay	2.00 months
6
7			Jan-2003	Feb-2003	Mar-2003	Apr-2003	May-2003	Jun-2003	Jul-2003	#####	Sep-2003	Total
8
9		Total Sales	100	120	140	160	180	200				900
10		% on Credit	20%	20%	20%	20%	20%	20%
11		Credit Deferrals	(20)	(24)	(28)	(32)	(36)	(40)				(180)
12
13		Credit Receipts			20	24	28	32	36	40		180
14		Net Credit Balance	(20)	(44)	(52)	(60)	(68)	(76)	(40)
15
16		The same thing can be done by adjusting a straight MkPmts:
17
18		Credit Receipts			20	24	28	32	36	40
19		Net Credit Balance	(20)	(44)	(52)	(60)	(68)	(76)	(40)
20
21		By Hand:				(60)
22
23		Another example where Months to Pay varies by month
24
25
26			Jan-2003	Feb-2003	Mar-2003	Apr-2003	May-2003	Jun-2003	Jul-2003	#####	Sep-2003	Total
27
28		Total Sales	100	120	140	160	180	200				900
29		% on Credit	20%	20%	20%	20%	20%	20%
30		Months To Pay	3.0 months	2.0 months	2.0 months	0.0 months	2.0 months	2.0 months
31		Credit Deferrals	(20)	(24)	(28)		(36)	(40)				(148)
32
33		Credit Receipts				44	28		36	40		148
34		Net Credit Balance	(20)	(44)	(72)	(28)	(36)	(76)	(40)			(316)
35
36		By Hand:				(28)
37
38
39
40
41
42
43		n  Look in the formulas coloured yellow to work out how we've solved the example
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