General: You have been tasked with providing the CFO of your firm an analysis of the receivables outstanding at the end of 2018 and advising her as to what should be the ending balance of the allowance for uncollectible accounts on the balance sheet. After learning in accounting about the different methods of estimating bad debt expense, you decided to analyze the aging and percentage of sales methods using historical data of the firm. You requested that the firm's IT personnel provide you with historic information dating back five years (2013-2017). You are going to use that information to provide an informed data-based report backing your conclusions. Instructions to download the file: 1. Download the file "ReceivablesDataSimulation.xls" from Blackboard. 2. Open the file using Excel. You might need to "enable macros" on your program for the code to work. To generate the data, click on the "Generate Data" button. The file produces a simulated database (different data for each student). 3. Save the file under the name (any of these four Excel file extensions) "AR_LastName_FirstName_StudentID.xlsx/xlsm/xltx/xltm" - you will submit this file on Blackboard under this name, with all your data work, along with a short report. Explanations and Assumptions: Once the data are generated you will see six worksheets, each pertaining to accounts receivables outstanding at each year-end. The worksheets "Dec 31 2013", "Dec 31 2014", "Dec 31 2015", "Dec 31 2016", and "Dec 31 2017" contain the historical data, and the worksheet "Dec 31 2018" contains the outstanding receivables for which you need to estimate the allowance. The firm had a different number of customers each year as well as total credit sales. There are five columns in each worksheet: - - Column A: the customer ID Column B: the total sale on account and invoiced during the year Column C: the account receivable balance outstanding at year-end Column D: the date when the invoice was issued Column E: the date when the invoice balance was paid off in the following year (this column is blank in the "Dec 31 2018" worksheet).