Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2) The following accounts receivable information is presented for a firm over a 180-day analysis period (6 months): A/R Schedule (as of December 31, 2020)
2) The following accounts receivable information is presented for a firm over a 180-day analysis period (6 months): A/R Schedule (as of December 31, 2020) Month January February March April May June Credit Sales 1,564,500 1,276,200 2,007,450 2,345,150 2,550,000 2,100,700 11,844,000 Uncollected Past Due Amount Status 155,000 > 90 days 220,000 > 90 days 380,000 61-90 days 750,000 31-60 days 1,100,000 0-30 days 2,100,700 Current 4,705,700 Past Due % 3.3% 4.7% 8.1% 15.9% 23.4% 44.6% A. Construct an Aging Schedule: focus on the uncollected amount only. Your total amount should be equal to $4,705,700 and your total % should be 100% A/R AGING ( AS PF DECEMBER 31, 2020) Current June 0-30 May 31-60 April 61-90 March >90 Feb and older TOTAL Age Month $ % B. Calculate DSO and A/R Turnover (times) for the 180-day analysis period (assume each month has 30 days): DSO = A/R / Avg Daily Sales A/R turnover = 180/DSO
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started