Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Money Laundering Prevention Deterring Detecting And Resolving Financial Fraud

Authors: Jonathan E. Turner

1st Edition

0470874759, 978-0470874752

More Books

Students also viewed these Accounting questions