please enter in excel format thank you

Required information The following information apples to the questions displayed below) Web Wizard, Inc, has provided information technology services for several years. For the first two months of the current year, the company has used the percentage of credit sales method to estimate bad debts. At the end of the first quarter the company switched to the aging of accounts receivable method. The company entered into the following partial list of transactions during the first quarter a During January, the company provided services for $37000 on credit b. On January 31, the company estimated bad debts using 2 percent of credit sales On February 4, the company collected $18,500 of accounts receivable a on February 15, the company wiote off a $150 account receivable e Dung February, the company provided services for $27,000 on credit 1. On February 28, the company estimated bad debts using 2 percent of credit sales 9 On March 1, the company loaned $2,600 to an employee, who signed a 6% note, due in 6 months h on March 15, the company collected $150 on the account written off one month earlier On March 31, the company accrued interest earned on the note on March 31, the company adjusted for uncollectible accounts, based on an aging analysis (below). Allowance for Doubtful Accounts has an unacisted credit balance of $1,170 Totat - Over o 5 1 110 1 30 umber of Days Unpaid 11- 30 1 30 6,120 1,100 5 Customer Alba Tour Side Bungalows Others (not shown to save space) xciting X Total account cevaple Estimated collectibla () 370 14. 390 1500 6,500 390 1. 35 1 5 1 5,190 303 1,2 301 Assets Stockholders Accounts Receivable . Accounts Receivable d Accounts Receivable Accounts Receivable g 11 13