Business Template - Accounts Receivable

Accounts Receivable Months To Pay 2.00 months Jan-2003 Feb-2003 Mar-2003 Apr-2003 May-2003 Total Sales 100 120 140 160 180 % on Credit 20% 20% 20% 20% 20% Credit Deferrals (20) (24) (28) (32) (36) Credit Receipts 20 24 28 Net Credit Balance (20) (44) (52) (60) (68) The same thing can be donw by adjusting a straight MkPmts: Credit Receipts 20 24 28 Net Credit Balance (20) (44) (52) (60) (68) By Hand: (60) Another example where Months to Pay varies by month Jan-2003 Feb-2003 Mar-2003 Apr-2003 May-2003 Total Sales 100 120 140 160 180 % on Credit 20% 20% 20% 20% 20% Months To Pay 3.0 months 2.0 months 2.0 months 0.0 months 2.0 months Credit Deferrals (20) (24) (28) (36) Credit Receipts 44 28 Net Credit Balance (20) (44) (72) (28) (36) By Hand: (28) Look in the formulas coloured yellow to work out how we've solved the exampleBase 1 months Jun-2003 Jul-2003 Aug-2003 Sep-2003 Total 200 900 20% (40) (180) 32 36 40 180 (76) (40) 32 36 40 (76) (40) Jun-2003 Jul-2003 Aug-2003 Sep-2003 Total 200 900 20% 2.0 months (40) (148) 36 40 148 (76) (40) (316)