Accounts receivable and allowance for doubtful accounts The hotel charges $150 per night for accommodation in one of the rental suites, and guests pay at the end of their stay, with daily revenue being accrued as it is earned. At December 31, the amount outstanding from short-term guests was $10,500. At year end, management expects to be unable to collect an amount equal to 5% of the outstanding receivables for this type of suite. During the year, Service Revenue amounted to $1,750,000, and the balance in Allowance for Doubtful Accounts at the end of the previous year was $15,000. During the year, $32,000 in accounts was written off. The two corporate suites are rented for $45,000 apiece per year. The payment for these longer-term rentals is due in advance each July 1 for the following 12 months. One of these corporate suites has been in use for part of the year, but the corporate tenant went bankrupt and was unable to pay the $45,000 fee. Hotel management had hoped the tenant would eventually be able to pay, and it allowed the company to use the suite until the end of October. Since then, the hotel has been in negotiations with the bankruptcy accountant and expects to eventually receive a settlement of $10,000. The balance will become uncollectible; no allowance for doubtful accounts has been recorded with respect to these suites as there have never been collection problems in the past. Required: Calculate the accounts receivable, allowance for doubtful accounts, and bad debt balances as of December 31. Instruction: Enter the dollar amount for each item in the box in the table below. Accounts receivable Allowance for doubtful accounts Amount as of December 31 $ 25,500 $ 5,525 $ 22,525 Bad debt expense Show your calculations on a supporting Excel worksheet.