hello, can you walk me through with excel project

Customer Year End A/R Date A/R Amount Abigail, AL Dec 31, 2014 Dec 28, 2014 27960.17 Abram, AL Dec 31, 2014 Nov 09, 2014 12503.54 Alejandro, AL Dec 31, 2014 Mar 28, 2014 23153.54 Amare, AL Dec 31, 2014 Aug 25, 2014 17341.59 Angel, SC Dec 31, 2014 Nov 22, 2014 8262.39 Archer, FL Dec 31, 2014 Nov 06, 2014 8890.71 Ashley, GA Dec 31, 2014 Dec 24, 2014 28651.33 Atticus, GA Dec 31, 2014 Jul 16, 2014 24158.85 Ava, FL Dec 31, 2014 Aug 02, 2014 1225.22 Brandon, FL Dec 31, 2014 Dec 20, 2014 20043.36 Brantley, GA Dec 31, 2014 Jan 10, 2014 5277.88 Bruce, AL Dec 31, 2014 Dec 28, 2014 22525.22 Chana, GA Dec 31, 2014 Nov 29, 2014 4021.24 Chandler, GA Dec 31, 2014 Sep 23, 2014 12723.45 Charles, SC Dec 31, 2014 Dec 03, 2014 15393.80 Chaya, AL Dec 31, 2014 Sep 19, 2014 4869.47 Chloe, GA Dec 31, 2014 Oct 15, 2014 21362.83 Christopher, TN Dec 31, 2014 Jul 25, 2014 4461.06 Daniel, FL Dec 31, 2014 Sep 30, 2014 2638.94 David, FL Dec 31, 2014 Dec 01, 2014 14451.33 David, SC Dec 31, 2014 Nov 22, 2014 15205.31 Declan, AL Dec 31, 2014 Oct 29, 2014 11215.49 Elijah, GA Dec 31, 2014 Dec 09, 2014 10461.50 Emily, TN Dec 31, 2014 Dec 26, 2014 30850.44 Esther, FL Dec 31, 2014 Oct 24, 2014 5057.96 Esther, FL Dec 31, 2014 May 07, 2014 1853.54 Fiona, GA Dec 31, 2014 Sep 27, 2014 30065.04 Gabrielle, AL Dec 31, 2014 Aug 31, 2014 28494.25 Gabrielle, FL Dec 31, 2014 Nov 27, 2014 26672.12 Iker, AL Dec 31, 2014 Sep 07, 2014 22273.89 Iker, AL Dec 31, 2014 Aug 18, 2014 23876.10 Isabella, GA Dec 31, 2014 Oct 23, 2014 23687.61 Isabella, SC Dec 31, 2014 Aug 13, 2014 9707.52 Jack, GA Dec 31, 2014 Mar 04, 2014 1665.04 Jack, TN Dec 31, 2014 May 25, 2014 2796.02 Jackson, SC Dec 31, 2014 Dec 14, 2014 21865.48 James, AL Dec 31, 2014 Oct 20, 2014 21959.73 Jameson, FL Dec 31, 2014 Feb 24, 2014 6314.60 Jameson, SC Dec 31, 2014 Dec 05, 2014 9330.53 Jasmine, AL Dec 31, 2014 Nov 24, 2014 18095.57 Jose, SC Dec 31, 2014 Oct 12, 2014 12315.04 Kamden, GA Dec 31, 2014 Feb 25, 2014 3989.82 Kayla, FL Dec 31, 2014 Jul 05, 2014 30410.62 London, TN Dec 31, 2014 May 25, 2014 8545.13 Maverick, TN Dec 31, 2014 Feb 02, 2014 19226.55 Maximiliano, AL Dec 31, 2014 Nov 19, 2014 21551.33 Nico, GA Dec 31, 2014 Dec 18, 2014 29625.22 Olivia, TN Dec 31, 2014 May 18, 2014 28525.66 Rachel, GA Dec 31, 2014 Nov 11, 2014 8262.39 Richard, GA Dec 31, 2014 Aug 23, 2014 28211.50 Samantha, GA Dec 31, 2014 Nov 20, 2014 19572.12 Valentina, FL Dec 31, 2014 Jun 05, 2014 7162.83 Customer Year End A/R Date A/R Amount Age Default Abel, GA Dec 31, 2011 Dec 29, 2011 23687.61 2 0 Alejandro, AL Dec 31, 2011 Aug 11, 2011 20294.69 142 795 Amare, GA Dec 31, 2011 Nov 16, 2011 22965.04 45 965 Amare, AL Dec 31, 2011 Aug 17, 2011 11152.65 136 0 Angelina, GA Dec 31, 2011 Apr 30, 2011 8293.80 245 2294 Elizabeth, AL Dec 31, 2011 Dec 09, 2011 24912.83 22 0 Finnegan, GA Dec 31, 2011 Oct 04, 2011 5770.80 88 0 Finnegan, SC Dec 31, 2011 Sep 04, 2011 6660.18 118 0 Jacob, TN Dec 31, 2011 Jul 18, 2011 15927.87 166 0 Jason, AL Dec 31, 2011 Nov 02, 2011 8796.46 59 0 Jason, AL Dec 31, 2011 Sep 10, 2011 27394.69 112 0 Jayce, GA Dec 31, 2011 Feb 13, 2011 7162.83 321 6162.8 John, SC Dec 31, 2011 Sep 20, 2011 29342.48 102 0 Kamden, GA Dec 31, 2011 Nov 03, 2011 29185.40 58 685.4 Kason, TN Dec 31, 2011 Oct 27, 2011 11843.80 65 0 Madison, AL Dec 31, 2011 Nov 09, 2011 19226.55 52 0 Mason, GA Dec 31, 2011 Dec 22, 2011 5749.11 9 0 Mateo, GA Dec 31, 2011 Jul 04, 2011 28494.25 180 0 Matthew, GA Dec 31, 2011 Nov 20, 2011 27771.68 41 0 Moshe, GA Dec 31, 2011 Oct 20, 2011 18221.24 72 0 Nicolas, AL Dec 31, 2011 Jun 04, 2011 15645.13 210 645.13 Rachel, GA Dec 31, 2011 Dec 01, 2011 28242.92 30 0 Remington, SC Dec 31, 2011 Sep 09, 2011 21394.25 113 0 Sofia, TN Dec 31, 2011 Sep 27, 2011 18064.16 95 0 Taylor, SC Dec 31, 2011 Dec 26, 2011 4146.90 5 0 Taylor, SC Dec 31, 2011 Dec 16, 2011 15770.80 15 0 Thomas, TN Dec 31, 2011 Apr 07, 2011 29216.81 268 0 Tyler, FL Dec 31, 2011 Oct 03, 2011 20200.44 89 1300.44 Tyler, TN Dec 31, 2011 Jan 06, 2011 20200.44 359 0 Zoe, AL Dec 31, 2011 Jul 12, 2011 2890.27 172 0 Angela, GA Dec 31, 2012 Dec 16, 2012 24661.50 15 0 Anthony, SC Dec 31, 2012 Aug 30, 2012 28557.08 123 0 Benjamin, TN Dec 31, 2012 Sep 07, 2012 24221.68 115 0 Camila, TN Dec 31, 2012 Dec 14, 2012 15739.38 17 0 Charlie, FL Dec 31, 2012 May 15, 2012 30033.63 230 1033.63 Christian, GA Dec 31, 2012 Aug 16, 2012 29593.80 137 0 Dexter, FL Dec 31, 2012 Nov 30, 2012 17498.67 31 1498.67 Dexter, FL Dec 31, 2012 Nov 03, 2012 26829.20 58 0 Diego, FL Dec 31, 2012 Nov 30, 2012 17027.43 31 0 Francis, AL Dec 31, 2012 Dec 11, 2012 18598.23 20 0 Jackson, SC Dec 31, 2012 Nov 21, 2012 4586.73 40 0 Jayden, GA Dec 31, 2012 Nov 25, 2012 6440.26 36 140.26 Jayden, TN Dec 31, 2012 Nov 23, 2012 3235.84 38 0 Jeremiah, TN Dec 31, 2012 Oct 04, 2012 31353.09 88 0 Jimena, SC Dec 31, 2012 Jan 21, 2012 18189.82 345 3689.82 Justin, TN Dec 31, 2012 Dec 19, 2012 9110.62 12 0 Leah, FL Dec 31, 2012 Dec 23, 2012 22336.72 8 0 Leah, GA Dec 31, 2012 Oct 26, 2012 29782.30 66 0 Lily, GA Dec 31, 2012 Jul 18, 2012 9738.94 166 0 Lucas, FL Dec 31, 2012 Dec 28, 2012 26734.95 3 0 Luciana, AL Dec 31, 2012 Dec 08, 2012 30536.28 23 0 Luciana, AL Dec 31, 2012 Dec 04, 2012 20043.36 27 0 Madison, TN Dec 31, 2012 Jun 15, 2012 17467.26 199 0 Maria, GA Dec 31, 2012 Aug 09, 2012 15582.30 144 0 Mariana, TN Dec 31, 2012 Sep 27, 2012 3392.92 95 0 Mateo, SC Dec 31, 2012 Nov 26, 2012 4241.15 35 0 Nicolas, FL Dec 31, 2012 Sep 29, 2012 8827.88 93 0 Olivia, TN Dec 31, 2012 Nov 10, 2012 30096.46 51 0 Rachel, GA Dec 31, 2012 Sep 18, 2012 15739.38 104 0 Samuel, SC Dec 31, 2012 Nov 28, 2012 13948.67 33 0 Samuel, SC Dec 31, 2012 Mar 15, 2012 17090.26 291 1390.26 Santiago, TN Dec 31, 2012 Dec 02, 2012 7791.15 29 0 Santiago, SC Dec 31, 2012 Sep 04, 2012 18755.31 118 1755.31 Sarah, FL Dec 31, 2012 Nov 24, 2012 13320.35 37 0 Sarah, SC Dec 31, 2012 Nov 23, 2012 17687.17 38 0 Sophia, GA Dec 31, 2012 Apr 29, 2012 6534.51 246 0 Tyler, GA Dec 31, 2012 Oct 20, 2012 23122.12 72 0 Valeria, SC Dec 31, 2012 Jul 14, 2012 11309.73 170 1809.73 William, GA Dec 31, 2012 Dec 20, 2012 31038.94 11 0 William, TN Dec 31, 2012 Jul 07, 2012 24912.83 177 0 Zaiden, TN Dec 31, 2012 Oct 22, 2012 14325.66 70 0 Abel, AL Dec 31, 2013 Oct 02, 2013 31196.02 90 0 Adriel, SC Dec 31, 2013 Nov 04, 2013 9519.03 57 0 Alejandro, TN Dec 31, 2013 Nov 29, 2013 20860.18 32 0 Angela, GA Dec 31, 2013 Jun 03, 2013 25761.06 211 0 Angelina, AL Dec 31, 2013 Mar 24, 2013 15896.46 282 896.46 Anthony, TN Dec 31, 2013 Dec 04, 2013 18598.23 27 0 Camila, TN Dec 31, 2013 Nov 15, 2013 6220.35 46 2220.35 Christian, SC Dec 31, 2013 Nov 09, 2013 15833.63 52 0 Emma, FL Dec 31, 2013 Dec 18, 2013 16053.54 13 0 Emma, TN Dec 31, 2013 Nov 25, 2013 30473.45 36 0 Eric, GA Dec 31, 2013 Oct 20, 2013 8859.29 72 0 Eric, SC Dec 31, 2013 Aug 13, 2013 18158.41 140 0 Ethan, AL Dec 31, 2013 Dec 26, 2013 13885.84 5 0 Francis, FL Dec 31, 2013 Dec 22, 2013 15425.22 9 0 Jacob, FL Dec 31, 2013 Dec 02, 2013 25289.82 29 0 Jada, AL Dec 31, 2013 Dec 31, 2013 22745.13 0 0 Jada, SC Dec 31, 2013 Nov 13, 2013 28337.17 48 0 Jeremiah, AL Dec 31, 2013 Dec 29, 2013 29562.39 2 0 Joseph, SC Dec 31, 2013 Oct 30, 2013 19038.05 62 0 Justin, GA Dec 31, 2013 Nov 27, 2013 26295.13 34 0 Kamden, TN Dec 31, 2013 Nov 21, 2013 6785.84 40 0 Kieran, AL Dec 31, 2013 Dec 22, 2013 27457.52 9 0 Kieran, AL Dec 31, 2013 Dec 21, 2013 6377.43 10 0 Lily, GA Dec 31, 2013 Nov 19, 2013 30756.19 42 0 Lucas, TN Dec 31, 2013 Aug 22, 2013 19509.29 131 509.29 Makayla, SC Dec 31, 2013 Sep 01, 2013 17969.91 121 0 Maria, FL Dec 31, 2013 Oct 11, 2013 26986.28 81 0 Mariana, TN Dec 31, 2013 Dec 26, 2013 11152.65 5 0 Matias, GA Dec 31, 2013 Sep 22, 2013 28117.25 100 0 Matias, AL Dec 31, 2013 Jul 12, 2013 1193.81 172 1193.81 Mia, TN Dec 31, 2013 Dec 09, 2013 4178.32 22 0 Mia, TN Dec 31, 2013 Oct 21, 2013 25572.56 71 0 Michael, SC Dec 31, 2013 Dec 05, 2013 5403.54 26 0 Michael, SC Dec 31, 2013 Jun 24, 2013 20106.19 190 906.19 Milo, GA Dec 31, 2013 Dec 11, 2013 18346.90 20 0 Noah, FL Dec 31, 2013 Nov 18, 2013 29562.39 43 0 Noah, SC Dec 31, 2013 Jan 09, 2013 19540.71 356 3540.71 Olivia, GA Dec 31, 2013 Sep 11, 2013 14294.25 111 0 Robert, GA Dec 31, 2013 Nov 30, 2013 16022.12 31 0 Robert, AL Dec 31, 2013 Nov 16, 2013 19697.79 45 0 Ryan, SC Dec 31, 2013 Jul 19, 2013 29468.14 165 0 Ryan, SC Dec 31, 2013 Jul 08, 2013 24190.26 176 0 Valentina, FL Dec 31, 2013 Sep 29, 2013 15582.30 93 1582.3 Victoria, FL Dec 31, 2013 Nov 23, 2013 12472.12 38 0 Victoria, GA Dec 31, 2013 Oct 24, 2013 26169.47 68 0 Zaiden, SC Dec 31, 2013 Sep 09, 2013 3864.16 113 0 Since inception, the company utilized a customized Java-based program to maintain records of receivables. ACCT4113 Project, \"Accounting Data Management: A Spreadsheet Analysis\" Introduction Southern Electronics Company was started in Atlanta, Georgia early 2011. It sells electronic parts to customers in southeastern states of the country. Since the company's sales are heavily based on a credit basis, managers have worked to develop a more efficient method of managing receivables. 1 The Company's accounting system provides a detailed list of receivables, including the customer's name, transaction date, and the amount of receivables at any time during the year. At the end of 2013, the company retrieved a file named \"HISTORY.DATA\" which shows previous three years' (2011-2013) ending balances of receivables in text format. CURRENT.DATA file includes a list of receivables at the end of current year (2014). The company collects receivables over a year after credit sales. Uncollected receivables over 359 days after sales are written off or transferred to a collection agency for minimal revenue. The company adopts the Aging Method to record the Allowance for Doubtful Accounts at the end of each year. Therefore, it estimates historical default ratio for each age group of 0-59, 60-119, ..., over last three years and the ratio will be applied to the current year-end A/R to compute the expected future default. Recently, the accounting manager of the company has learned that spreadsheet analysis might be easier and more useful in analyzing the receivables. You are assigned to develop an efficient way of analyzing the company's receivables, using Microsoft Excel. Project Assignments The purpose of this project is to get familiar with the accounting data analyses using spreadsheets. Detail questions for each part are as follows: 1. The HISTORY.DATA file shows ending balances of receivables at December 31, 20112013 in text format. The last two columns show the age of receivables at year-end (# of days) and any default amount over next year (uncollected and written-off amount over next 359 days). Convert the text file into an Excel worksheet, and identify the total amount of receivables at the end of each year. Also, prepare a list of customers who have a default history during last three years. 2. 5. Analyze previous three years' receivables by age group. Analyze the 6. trend amount of each age group and the percentage weight of receivable amount of each age group relative to total annual receivable amount for each of the last three years. 3. Identify historical default ratio for each age group. Has the default ratio improved over time? 4. Analyze current year's receivables from CURRENT.DATA. Identify customers with relatively old 2 and material amount of receivables at the end of 2014. Also, identify whether any current customer has defaulted receivables over last three years. Guidelines. Some tips are available for each part. It is recommended to form a study group, discuss each other, and post questions/answers in the Discussion section of D2L Brightspace. However, the final report is individual, Compute the amount not to be shared with of \"Allowance for others. Doubtful Account\" as of December 31, Submission 2014, by applying Files and Procedure previous years' Following the average default attached Detailed Guidelines, ratios into each age prepare an Excel file with all group of current requested information. Your year's receivables. The company sets up a new policy to retrieve text data from the company's Java program for receivables on a weekly basis from January 1, 2015, and review customer records. Prepare for the plan for repetitive spreadsheet analyses of the future. Some parts are challenging and you should follow the step-by-step instruction carefully from the attached Detailed Excel file, named \"Your GSU_ID.xlsm\