Please help

P7-3 (LO3) EXCEL (Bad-Debt Reporting Aging) Manilow Corporation operates in an industry that has a high rate of bad debts. Before any year-end adjustments, the balance in Manilow's Accounts Receivable account was $555,000 and Allowance for Doubtful Accounts had a credit balance of $40000. The yearend balance reported in the balance sheet for Allowance for Doubtful Accounts will be based on the aging schedule shown below Probability of Collection .98 .90 .85 .80 ay Accure OuestandingClei Less than 16 days Between 16 and 30 days Between 31 and 45 days Between 46 and 60 days Between 61 and 75 days Over 75 days ngAmount $300,000 100,000 80,000 40,000 20,000 500000