In Excel, create a solution for each situation making sure you answer the questions and/or prepare the requested information for each item at the end of each situation below. Place each situation on its own sheet in one Excel workbook (one Excel file with 2 sheets). Make sure your schedules are shown on one page, so IF printed each schedule will not be split between pages. Based on Problem 6-3 Situation \#1: balance of $40,970. The year-end balance reported in the balance sheet for Allowance for Doubtful Accounts will be based on the aging schedule shown below. Assume that accounts 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