Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Sustainability

Authors: Gunnar Rimmel

1st Edition

0367478927, 9780367478926

More Books

Students also viewed these Accounting questions

Question

Define static chain, static_depth, nesting_depth, and chain_offset.

Answered: 1 week ago