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