Aging Analysis of Accounts Recievable
I have no idea where to begin with this one. Year end is January 31,2011. The beginng was February 1,2010. Help don't know how.
Customer acc. Amount due date
J. Kras $11,077 Jan. 15
t. Lopez 9,314 Feb 15 (next fiscal year)
L.Zapal 8,664 Dec.20
R. Caputo 780 Oct.1
E. rago 14,710 Jan.4
S. smith 6,316 Nov.15
A.Quinn 4,389 Mar.1 (next fiscal year)
Totals $55,250
Time Percentage Considered
Uncollectible
Not yet due 2
1-30 days past due 5
31-60 days past due 15
61-90 days past due 25
Over 90 days past due 50