Complete the empty boxes for the first 5 months of 2016. Based on these calculations, is the
Fantastic news! We've Found the answer you've been seeking!
Question:
Complete the empty boxes for the first 5 months of 2016. Based on these calculations, is the practice improving or getting worse over the period in the areas of Net Collections Percentage and AR Days?
5/31/16 | ||||||||||
Targets => | > 96% | < 15% | < 30 | |||||||
Gross Coll | Net Coll | AR | ||||||||
BEGINNING | ENDING | Monthly | Monthly | AR > 120 | AR > 120 | Days | ||||
DATE | A/R | CHARGES | PAYMENTS | ADJUSTMENTS | A/R | % | % | Days $ | Days % | 3 month avg |
2016 | ||||||||||
Jan-16 | 468,585 | 516,423 | 202,971 | 228,570 | 553,467 | 72,355 | ||||
Feb-16 | 553,467 | 530,046 | 289,375 | 225,456 | 568,682 | 39,262 | ||||
Mar-16 | 568,682 | 655,420 | 340,955 | 353,693 | 529,454 | 36,698 | ||||
Apr-16 | 529,454 | 596,729 | 293,456 | 373,163 | 459,564 | 42,565 | ||||
May-16 | 459,564 | 604,197 | 288,196 | 396,707 | 378,858 | 45,845 | ||||
PTD | 329,772 | 14,286,281 | 7,148,722 | 7,007,767 | 459,564 |
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: