I need to know how to do the A-G parts. The Customer/Invoice spreadsheet is just for info for the A-G parts. You don't have to work everything out if you could just give me the excel formulas for A-G

Midler Corporation operates in an industry that has a high rate of bad debts and uses the allowance method to account for its bad debt expenses. Before any year-adjustment on 7/1/2014, Midler's accountant compiled a list of account receivables, showing customer names, invoices amounts, and invoice dates. Count of Late Payments Sum of Late Payments Estimated Bad Debts Days Account Late 1-59 Days 60-119 Days 120-179 Days 180+ Days Estimated Bad Debt Percentage 25% 80% 90% 95% Total Required (A) If Midler's invoice term is 2/10, EOM, use CountIFS, SumIFs, and other appropriate Excel functions to complete the table above for 2014 year-end adjustment. Required (B) What is the appropriate balance for Allowance for Doubtful Accounts at year end? Required (C) Assume that the Allowance for Doubtful Accounts had a credit balance of $5000 before adjustments, what is the journal entry to recognize bad debt expense? Required (D) Assume that the Allowance for Doubtful Accounts had a debit balance of $2000 before adjustments, what is the journal entry to recognize bad debt expense? Required (E) Normally the Allowance for Doubtful Account has a credit balance before year-end adjustments. Explain why Midler has a debit balance. Estimated Bad Debts Required (F) If Midler's invoice term is 2/10, net 30, use CountIFs, SumIFs, and other appropriate Excel functions to complete the following table for 2014 year-end adjustment. Days Account Late Estimated Bad Debt Percentage Count of Late Payments Sum of Late Payments 1-59 Days 25% 60-119 Days 80% 120-179 Days 90% 180+ Days 95% Total Required (G) The CFO of Midler Corporation is superstitious and believes customers whose FIRST NAME starting with "D" or "L" are frequently late in payments. First Name starting with Count of Late Payments Sum of Late Payments Other Customers Total Due Date - 2/10, net 30 DaysLate - 2/10,n/30 1 Customer 2 Steffen, Malinda 3 Zook, Corrinne 4 Mccain, Elba 5 Baca, Tressa 6 Pennell, Willena 7 Mathias, Debrah 8 Whited, Un 9 Mclean, Eldora 10 Silverman, Delmar 11 Thigpen, Mia 12 Settle, Madelene 13 Anglin, Thanh 14 Wofford, Reyes 15 Lentz, Rosana 16 Hanley, Leatrice 17 Irby, Tama 18 Hickey, Melina 19 Ho, Sylvie 20 Edgar, Dusti 21 Dang, Trista 22 Brill, Evelynn 23 Johns, Yuonne 24 Cousins, Jeniffer 25 Mosier, Maude 26 Pimentel, Cristopher Invoice AmountInvoice Date Due Date - EOM Days Late - EOM $3,282.00 10/1/2013 10/31/2013 $1,718.00 10/4/2013 10/31/2013 $6,448.00 10/5/2013 10/31/2013 $175.00 10/6/2013 10/31/2013 $1,440.00 10/6/2013 10/31/2013 $1,416.00 10/10/2013 10/31/2013 $4,797.00 10/10/2013 10/31/2013 $1,929.00 10/14/2013 10/31/2013 $2,237.00 10/15/2013 10/31/2013 $5,517.00 10/17/2013 10/31/2013 $111.00 10/20/2013 10/31/2013 $1,617.00 10/21/2013 10/31/2013 $4,865.00 10/21/2013 10/31/2013 $1,822.00 10/29/2013 10/31/2013 $2,038.00 10/31/2013 10/31/2013 $3,846.00 11/2/2013 11/30/2013 $3,531.00 11/3/2013 11/30/2013 $4,292.00 11/4/2013 11/30/2013 $5,261.00 11/5/2013 11/30/2013 $343.00 11/8/2013 11/30/2013 $835.00 11/23/2013 11/30/2013 $1,414.00 11/25/2013 11/30/2013 $6,013.00 11/28/2013 11/30/2013 $4,378.00 11/29/2013 11/30/2013 $1,290.00 11/30/2013 11/30/2013 Day of Week Tuesday Friday Saturday Sunday Sunday Thursday Thursday Monday Tuesday Thursday Sunday Monday Monday Tuesday Thursday Saturday Sunday Monday Tuesday Friday Saturday Monday Thursday Friday Saturday