i need help with the excel formulas

Net Zero Products, a wholesaler of sustainable raw materials, prepares the following aging of receivables analysis. Required: 1. Estimate the balance of the Allowance for Doubtful Accounts using the aging of accounts receivable method. (Use cells A4 to G6 from the given information to complete this question.) 2. Prepare the adjusting entry to record bad debts expense assuming the unadjusted balance in the Allowance for Doubtful Accounts is a $1,000 credit. 1. Estimate the balance of the Allowance for Doubtful Accounts using the aging of accounts receivable method. (Use cells A4 to G6 from the given information to complete this question.) 2. Prepare the adjusting entry to record bad debts expense assuming the unadjusted balance in the Allowance for Doubtful Accounts is a $1,000 credit