Prepare an accounts receivable aging report as of June 30, 2016 on a separate tab in the workbook. Name this worksheet Aging Report.

Specific requirements for the project include: a. Column headings for customer name b. A column for total balance c. Current balance and past due amounts with columns of 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. The calculation should be based on invoice date. d. Any additions that make the report more readable such as totals, percentages, days before due, days outstanding, etc. At least three additions in this area are expected. The summary numbers will need to be calculated from the Calculations data sheet. You may not key balances directly in the report.

Customer Name Invoice Number Invoice Date Terms Invoice Amount SmithCo 1988 1/3/2016 Net 30 2132.45 "Acme Co., Inc." 1989 2/15/2016 Net 30 5860.56 Main Street USA 1990 2/15/2016 Net 30 1989.56 Dayton Co. 1991 2/18/2016 2/10/Net 15 4521.99 SmithCo 1992 3/18/2016 Net 30 5691.01 Main Street USA 1993 3/23/2016 Net 30 2356.25 "Acme Co., Inc." 1994 4/18/2016 Net 30 6598.36 SmithCo 1995 5/3/2016 Net 30 2211.45 Main Street USA 1996 5/14/2016 Net 30 5812.13 Dayton Co. 1997 5/24/2016 2/10/Net 15 2214.78 "Acme Co., Inc." 1998 5/24/2016 Net 30 9895.73 "Acme Co., Inc." 1999 5/24/2016 Net 30 1245.63 Main Street USA 2000 6/1/2016 Net 30 989.71 SmithCo 2001 6/1/2016 Net 30 2311.45 Dayton Co. 2002 6/7/2016 2/10/Net 15 2799.23 "Acme Co., Inc." 2003 6/7/2016 Net 30 5488.30 Main Street USA 2004 6/13/2016 Net 30 8902.32 "Acme Co., Inc." 2005 6/15/2016 Net 30 5362.12 Dayton Co. 2006 6/15/2016 2/10/Net 15 6812.45 SmithCo 2007 6/15/2016 Net 30 989.46 Main Street USA 2008 6/15/2016 Net 30 12875.65 "Acme Co., Inc." 2009 6/16/2016 Net 30 8974.23 Dayton Co. 2010 6/17/2016 2/10/Net 15 3225.01 Main Street USA 2011 6/18/2016 Net 30 2356.41 SmithCo 2012 6/18/2016 Net 30 7911.32 Main Street USA 2013 6/18/2016 Net 30 4699.23 "Acme Co., Inc." 2014 6/23/2016 Net 30 7845.12 Dayton Co. 2015 6/30/2016 2/10/Net 15 2356.36 "Acme Co., Inc." 2016 6/30/2016 Net 30 7945.63 Main Street USA 2017 6/30/2016 Net 30 2384.56 SmithCo 2018 6/30/2016 Net 30 1989.43 SmithCo Finance Charge 6/30/2016 Net 30 300.00