Write a formula onto Yellow Cells. Input Variables in Green Cells can be any number. Yellow cells must adjust in response to changes of the values in green cells. Journalize to recognize bad debt expense and to set up a proper amount of allowance on 12/31/2017, based on the aging method. Probability of Bad Debt Ages of A/R Before Due Date 1-30 days past due 31-60 days past due 61-90 days past due 91-120 days past due more than 120 days Allowance for Doubtful Accounts Journal Entry Bad Debt Expense Total 170 Allowance 1% 3% 6% 9% 12% 20% Balance of A/R 120,000 150,000 20,000 15,000 10,000 33,000 Estimated Bad Debt Remember the balance of Allowance could be in debit or in credit. Your journal entry below must accommodate both debit balance and credit balance.