Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please display it in excel format The following information applies to the questions displayed below) Web Wizard, Inc. has provided information technology services for several
please display it in excel format
The following information applies 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 $37,000 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 d. On February 15, the company wrote off a $150 account receivable e. During 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 n. 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 1. On March 31, the company adjusted for uncollectible accounts, based on an aging analysis (below). Allowance for Doubtful Accounts has an unachusted credit balance of $1170 Mumber of Days 31-60 61-10 1 $ 30 Over 90 $ 110 Customer Alaban Tourism Bayside ng others (not shown to save soke) xciting cursions Total Accounts receivable Estimated Uncollectie (5) Toto 3 23 370 36,600 390 $ 1.590 970 0,100 1,100 See 39 7,00 23 8,190 1 21 1,210 30 Required 1. Poems analyze the action to determine conector the overall counter any decreases to Aces Les or fitockholders with a misst. De round Intermediate actions.) Les d + 0 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started