Required:

Download the AR Aging Report.txt file from Blackboard. Note that this is a text file.

Open Excel and import the text file. Name this worksheet Imported Data.

You will then reference the imported data and create a calculations page using formulas. Do not key any data into the calculations page, they must all be formula or function based. Name this worksheet Calculations.

Prepare an accounts receivable aging report as of June 30, 2016 on a separate tab in the workbook. Name this worksheet Aging Report. (Hint: you might want to look up examples of Accounts Receivable aging reports online before you begin designing yours if you are unfamiliar with them).

Specific requirements for the Aging Report include:

Column headings for customer name

A column for total balance

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.

Any additions that make the report more readable such as totals, percentages, days before due, days outstanding, etc.

The summary numbers will need to be calculated from the Calculations data sheet to receive credit. Do noRequired:

Download the AR Aging Report.txt file from Blackboard. Note that this is a text file.

Open Excel and import the text file. Name this worksheet Imported Data.

You will then reference the imported data and create a calculations page using formulas. Do not key any data into the calculations page, they must all be formula or function based. Name this worksheet Calculations.

Prepare an accounts receivable aging report as of June 30, 2016 on a separate tab in the workbook. Name this worksheet Aging Report. (Hint: you might want to look up examples of Accounts Receivable aging reports online before you begin designing yours if you are unfamiliar with them).

Specific requirements for the Aging Report include:

Column headings for customer name

A column for total balance

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.

Any additions that make the report more readable such as totals, percentages, days before due, days outstanding, etc.

The summary numbers will need to be calculated from the Calculations data sheet to receive credit. Do not key balances directly in the report. Doing so will result in zero points being awarded for the project.t key balances directly in the report. Doing so will result in zero points being awarded for the project.

ustomer 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 4500.00 SmithCo 1992 3/18/2016 Net 30 5621.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 9845.23 "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 5412.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 12345.65 "Acme Co., Inc." 2009 6/16/2016 Net 30 8974.23 Dayton Co. 2010 6/17/2016 2/10/Net 15 3200.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 4612.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 2324.56 SmithCo 2018 6/30/2016 Net 30 1989.43 SmithCo Finance Charge 6/30/2016 Net 30 200.00