Understanding Aging Accounts Receivable: Analysis & Insights
School
University of California, Berkeley**We aren't endorsed by this school
Course
UGBA MISC
Subject
Marketing
Date
Dec 10, 2024
Pages
3
Uploaded by jaggerwocky
student nameAGINGAging Accounts ReceivableDate:October 31, 2012Analysis of Accounts Receivable by AgeNot1-3031-6061-90Over 90YetDaysDaysDaysDaysCustomerTotalDuePast DuePast DuePast DuePast DueAttitudes For Hair$4,600 $2,600 $700 $1,300 Beauty Box7,500 5,600 1,900 Hair Affair10,000 3,000 3,000 2,000 2,000 Headliners Salon3,800 3,800 Ooh La La Hair800 800 Shear Paradise3,500 1,000 640 1,400 460 Totals$30,200 $15,000 $6,600 $2,640 $3,400 $2,560 Estimate of ProbableUncollectible Accounts ExpenseTotalPercentTotalAmountUncoll.Uncoll.Not yet dueFORMULA11%FORMULA71-30 days past dueFORMULA23%FORMAUL831-60 days past dueFORMULA35%FORMUAL961-90 days past dueFORMULA410%FORMULA10Over 90 days past due FORMULA525%FORMULA11TotalsFORMULA6FORMULA12ABCDEFG1234567891011121314151617181920212223242526272829
Not1-3031-6061-90Over 90$0 $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 $40,000