Assume that if the receivable was not paid over the course of the following year, the entire amount would be written off. In that case, the corresponding cell in column E remains blank. Assume four categories of aging receivables: (1) 0-30 days outstanding, (2) 31-60 days outstanding, (3) 61-90 days outstanding, and (4) above 90 days outstanding. The worksheet "Solution" contains a table which needs to be filled with the answers. PLEASE NOTE THAT THIS IS THE ONLY SHEET THAT WILL BE GRADED - THEREFORE ALL ANSWERS SHOULD BE PLACED ON THIS SHEET!! PLEASE DO NOT PUT ANYTHING ON OTHER WORKSHEETS!! Excel files will be auto graded. For the system to work YOU CANNOT CHANGE THE NAMES OF THE DATA SHEETS OR ANY OF THE DATA COLUMNS (A-E IN THE FILES) - That includes adding sums, averages or anything else to these columns. You can add as many work sheets as you like to the file but do not change / add any data to columns A-E in the existing data sheets. Requirements: 1. You are required to submit an excel file under the name "AR_LastName_FinstName_StudentID. x/sx/xlsm/xltx/xltm " on Blackboard. The excel file should include the following on the "Solution" worksheet: a. For each year, calculate the percentage of account receivables written off out of total credit sales. b. For each year, calculate the percentage of account receivables written off in each category of outstanding receivable age (think about which dates are relevant when assigning the categories of aging receivables). c. Collect the data for years 2013-2017 (total outstanding receivables, percentage of receivables written off relative to credit sales, and the percentage of receivables written off in each aging category of outstanding receivables), and fill in the table in the "Solution" worksheet. 2. You are required to prepare and submit a short report of your findings on Blackboard. The report should not be more than one page long and should be submitted under the name "AR_LastName_FirstName_Studentid.pde". The report should provide the following: a. A brief description of the task you were given, the data used and your method of analysis. b. A table presenting the analysis results in the following format*: Assume that if the receivable was not paid over the course of the following year, the entire amount would be written off. In that case, the corresponding cell in column E remains blank. Assume four categories of aging receivables: (1) 0-30 days outstanding, (2) 31-60 days outstanding, (3) 61-90 days outstanding, and (4) above 90 days outstanding. The worksheet "Solution" contains a table which needs to be filled with the answers. PLEASE NOTE THAT THIS IS THE ONLY SHEET THAT WILL BE GRADED - THEREFORE ALL ANSWERS SHOULD BE PLACED ON THIS SHEET!! PLEASE DO NOT PUT ANYTHING ON OTHER WORKSHEETS!! Excel files will be auto graded. For the system to work YOU CANNOT CHANGE THE NAMES OF THE DATA SHEETS OR ANY OF THE DATA COLUMNS (A-E IN THE FILES) - That includes adding sums, averages or anything else to these columns. You can add as many work sheets as you like to the file but do not change / add any data to columns A-E in the existing data sheets. Requirements: 1. You are required to submit an excel file under the name "AR_LastName_FinstName_StudentID. x/sx/xlsm/xltx/xltm " on Blackboard. The excel file should include the following on the "Solution" worksheet: a. For each year, calculate the percentage of account receivables written off out of total credit sales. b. For each year, calculate the percentage of account receivables written off in each category of outstanding receivable age (think about which dates are relevant when assigning the categories of aging receivables). c. Collect the data for years 2013-2017 (total outstanding receivables, percentage of receivables written off relative to credit sales, and the percentage of receivables written off in each aging category of outstanding receivables), and fill in the table in the "Solution" worksheet. 2. You are required to prepare and submit a short report of your findings on Blackboard. The report should not be more than one page long and should be submitted under the name "AR_LastName_FirstName_Studentid.pde". The report should provide the following: a. A brief description of the task you were given, the data used and your method of analysis. b. A table presenting the analysis results in the following format*
