Exercise (6 The following information are about an aging schedule for Jordan Company accounts receivable, the client balances, and maturity date, as shown in figure (3-50):

Transcribed Image Text:

5 Customer Name Customer Balance Maturity Date 9 Aguba Company 10 Amman Copmany 11 Salt Companys 12 $13 Chapter Three: Spreadsheets Applications in Financial Accounting Student Name Student ID EX6 14 20000 -30000 10000 2/10/2016: ::1/19/2016- 2/8/2016 Age in Days From 1 to 19 From 20 to 39 Allowance for Doubtful Debts % 5% 10% lentation Date 12/31/2015 Balance Age in Dats ??? ???: ??? Over 39 15% Aging Balances in Days From 1 to 19 From 20 to 39 ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? Total Bala for Each Age Allowance for Doubtful Debts for Each Age Total Allowance for Doubtful Debts ??? (Figure 3-50) Over 39 ??? ??? ??? ??? ??? Required: 1. Create a new worksheet "Chapter3 EX6", and enter the previous data in it. 2. Insert necessary equations in the related cells to calculate the balance age in days for each customer on December 31, 2015. 3. Use the necessary equations to calculate the balance age in days for each customer on December 31, 2015. 4. Use the "IF" function in the related cells to determine to which aging balance category each customer balance belongs according to its balance age in days. 5. Use the necessary equations in the related cells to calculate total balance for each age, allowance for doubtful debts for each age, and the total allowance for doubtful debts. is about the worksheet for 5 Customer Name Customer Balance Maturity Date 9 Aguba Company 10 Amman Copmany 11 Salt Companys 12 $13 Chapter Three: Spreadsheets Applications in Financial Accounting Student Name Student ID EX6 14 20000 -30000 10000 2/10/2016: ::1/19/2016- 2/8/2016 Age in Days From 1 to 19 From 20 to 39 Allowance for Doubtful Debts % 5% 10% lentation Date 12/31/2015 Balance Age in Dats ??? ???: ??? Over 39 15% Aging Balances in Days From 1 to 19 From 20 to 39 ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? Total Bala for Each Age Allowance for Doubtful Debts for Each Age Total Allowance for Doubtful Debts ??? (Figure 3-50) Over 39 ??? ??? ??? ??? ??? Required: 1. Create a new worksheet "Chapter3 EX6", and enter the previous data in it. 2. Insert necessary equations in the related cells to calculate the balance age in days for each customer on December 31, 2015. 3. Use the necessary equations to calculate the balance age in days for each customer on December 31, 2015. 4. Use the "IF" function in the related cells to determine to which aging balance category each customer balance belongs according to its balance age in days. 5. Use the necessary equations in the related cells to calculate total balance for each age, allowance for doubtful debts for each age, and the total allowance for doubtful debts. is about the worksheet for

Answer rating: 100% (QA)

Solution a Both are individual questions Requirement of Blosso... View the full answer