please answer in excel

Ivanhoe Corporation operates in an industry that has a high rate of bad debts. Before any year-end adjustments, the balance in Ivanhoe's Accounts Receivable account was $597,800 and Allowance for Doubtul Accounts had a credit balance of $40,970. The year-end balance reported in the balance sheet for Aliowance for Doubtful Accounts will be based on the aging schedule shown below. Assume that occounts with a zero percent chance of collection are intended to be written off. 1. What is the appropriate balance for the Allowance for Doubtful Accounts at year-end? 2. Show how accounts receivable would be presented on the balance sheet. 3. What is the dollar effect of the year-end bad debt adjustment on the before-tax income? Ivanhoe Corporation operates in an industry that has a high rate of bad debts. Before any year-end adjustments, the balance in Ivanhoe's Accounts Receivable account was $597,800 and Allowance for Doubtul Accounts had a credit balance of $40,970. The year-end balance reported in the balance sheet for Aliowance for Doubtful Accounts will be based on the aging schedule shown below. Assume that occounts with a zero percent chance of collection are intended to be written off. 1. What is the appropriate balance for the Allowance for Doubtful Accounts at year-end? 2. Show how accounts receivable would be presented on the balance sheet. 3. What is the dollar effect of the year-end bad debt adjustment on the before-tax income