Question

In: Accounting

[The following information applies to the questions displayed below.] Execusmart Consultants has provided business consulting services...

[The following information applies to the questions displayed below.]

Execusmart Consultants has provided business consulting services for several years. The company has been using the percentage of credit sales method to estimate bad debts but switched at the end of the first quarter this year to the aging of accounts receivable method. The company entered into the following partial list of transactions.

  1. During January, the company provided services for $230,000 on credit.
  2. On January 31, the company estimated bad debts using 1 percent of credit sales.
  3. On February 4, the company collected $115,000 of accounts receivable.
  4. On February 15, the company wrote off a $650 account receivable.
  5. During February, the company provided services for $180,000 on credit.
  6. On February 28, the company estimated bad debts using 1 percent of credit sales.
  7. On March 1, the company loaned $15,000 to an employee, who signed a 10% note due in 3 months.
  8. On March 15, the company collected $650 on the account written off one month earlier.
  9. On March 31, the company accrued interest earned on the note.
  10. On March 31, the company adjusted for uncollectible accounts, based on the following aging analysis, which includes the preceding transactions (as well as others not listed). Prior to the adjustment, Allowance for Doubtful Accounts had an unadjusted credit balance of $6,600.
Number of Days Unpaid
Customer Total 0–30 31–60 61–90 Over 90
Arrow Ergonomics $ 1,900 $ 800 $ 700 $ 400
Asymmetry Architecture 2,300 $ 2,300
Others (not shown to save space) 83,500 31,900 42,000 5,300 4,300
Weight Whittlers 2,300 2,300
Total Accounts Receivable $ 90,000 $ 35,000 $ 42,700 $ 5,700 $ 6,600
Estimated Uncollectible (%) 2 % 20 % 30 % 40 %

Required:

  1. For items (a)–(j), analyze the amount and direction (+ or –) of effects on specific financial statement accounts and the overall accounting equation. TIP: In item (j), you must first calculate the desired ending balance before adjusting the Allowance for Doubtful Accounts. (Do not round intermediate calculations. Enter any decreases to Assets, Liabilities, or Stockholders Equity with a minus sign.)

  2. Prepare the journal entries for items (a)–(j). (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field. Do not round intermediate calculations.)

  3. Show how Accounts Receivable, Notes Receivable, and their related accounts would be reported in the current assets section of a classified balance sheet at the end of the quarter on March 31.

  4. Sales Revenue and Service Revenue are two income statement accounts that relate to Accounts Receivable. Name two other accounts related to Accounts Receivable and Notes Receivable that would be reported on the income statement and indicate whether each would appear before, or after, Income from Operations.

Solutions

Expert Solution

1.

Event Assets = Liabilities + Stockholder's Equity
a Accounts receivables $2,30,000 Service revenue $2,30,000
b Allowance for doubtful accounts -$2,300 Bad debts expense -$2,300
c Cash $1,15,000
Accounts receivables -$1,15,000
d Allowance for doubtful accounts $650
Accounts receivables -$650
e Accounts receivables $1,80,000 Service revenue $1,80,000
f Allowance for doubtful accounts -$1,800 Bad debts expense -$1,800
g Note receivables $15,000
Cash -$15,000
h Accounts receivables $650
Allowance for doubtful accounts -$650
Cash $650
Accounts receivables -$650
i Interest receivables ($15000*10%*1/12) $125 Interest revenue $125
j Allowance for doubtful accounts ($13590-6600) -$6,990 Bad debts expense -$6,990
Computation of allowance for estimated uncollectibles - Execusmart consultants
Customer Total Balance 0-30 days 31-60 days 61-90 days Over 90 days
Total Receivables $90,000 $35,000 $42,700 $5,700 $6,600
Percentage uncollectibles 2% 20% 30% 40%
Allowance for doubtful accounts $13,590 $700 $8,540 $1,710 $2,640

2.

Journal Entries
Event Particulars Debit Credit
1 Accounts receivables Dr $2,30,000
      To Service revenue $2,30,000
(To record services provided on credit)
2 Bad debts Expense Dr $2,300
      To Allowance for doubtful accounts $2,300
(To record bad debts expense)
3 Cash Dr $1,15,000
      To Accounts receivables $1,15,000
(To record collection of receivables)
4 Allowance for doubtful accounts Dr $650
      To Accounts receivables $650
(To write off receivables)
5 Accounts receivables Dr $1,80,000
      To Service revenue $1,80,000
(To record services provided on credit)
6 Bad debts Expense Dr $1,800
      To Allowance for doubtful accounts $1,800
(To record bad debts expense)
7 Notes receivables Dr $15,000
      To Cash $15,000
(Loan given to employee against note)
8 Accounts receivables Dr $650
      To Allowance for doubtful accounts $650
(To reinstate debtor account)
9 Cash Dr $650
      To Accounts receivables $650
(To record collection from customer previously written off)
10 Interest receivables Dr $125
      To Interest revenue ($15,000*10%*1/12) $125
(To record interest revenue)
11 Bad debts Expense Dr $6,990
      To Allowance for doubtful accounts $6,990
(To record bad debts expense)

3.

Execusmart Consultants (Partial Balance Sheet)
At March 31
Assets Amount
Current Assets:
Accounts receivables - Gross $90,000.00
Allowance for doubtful accounts $13,590.00
Accounts receivables, net of allowance $76,410.00
Note Receivables $15,000.00
Interest receivables $125.00

4.

Execusmart Consultants would report:
Bad debts expense before Income from operations
Interest revenue after Income from operations

Related Solutions

Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,600 $ 17,500 Beginning work in process inventory 18,000 20,550 Beginning raw materials inventory (direct materials) 7,400 12,150 Rental cost on factory equipment 30,500 24,700 Direct labor 21,200 41,000 Ending finished goods inventory 17,150 14,100 Ending work in process inventory 25,900 20,200 Ending raw materials inventory 7,100 7,600 Factory...
Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,600 $ 17,500 Beginning work in process inventory 18,000 20,550 Beginning raw materials inventory (direct materials) 7,400 12,150 Rental cost on factory equipment 30,500 24,700 Direct labor 21,200 41,000 Ending finished goods inventory 17,150 14,100 Ending work in process inventory 25,900 20,200 Ending raw materials inventory 7,100 7,600 Factory...
Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,700 $ 19,600 Beginning work in process inventory 18,800 22,800 Beginning raw materials inventory 7,200 13,200 Rental cost on factory equipment 31,500 24,100 Direct labor 20,800 37,800 Ending finished goods inventory 19,250 13,100 Ending work in process inventory 23,800 21,400 Ending raw materials inventory 6,300 9,800 Factory utilities 10,950...
Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,200 $ 17,350 Beginning work in process inventory 15,600 23,400 Beginning raw materials inventory 7,300 11,550 Rental cost on factory equipment 29,750 24,400 Direct labor 24,800 41,400 Ending finished goods inventory 20,900 16,200 Ending work in process inventory 22,300 16,600 Ending raw materials inventory 6,400 7,400 Factory utilities 14,250...
Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,700 $ 16,600 Beginning work in process inventory 18,000 23,550 Beginning raw materials inventory 11,500 13,350 Rental cost on factory equipment 27,250 26,950 Direct labor 20,600 43,000 Ending finished goods inventory 20,000 13,500 Ending work in process inventory 25,300 17,200 Ending raw materials inventory 6,200 8,000 Factory utilities 11,550...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 13,800 $ 16,000 Beginning work in process inventory 17,300 23,400 Beginning raw materials inventory (direct materials) 8,100 10,500 Rental cost on factory equipment 28,750 24,250 Direct labor 21,000 36,200 Ending finished goods inventory 20,300 16,000 Ending work in process inventory 22,300 17,000 Ending raw materials inventory 6,600 9,400 Factory utilities 12,150...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,500 $ 16,300 Beginning work in process inventory 15,900 19,650 Beginning raw materials inventory 10,500 14,400 Rental cost on factory equipment 28,750 26,500 Direct labor 25,000 42,600 Ending finished goods inventory 20,000 13,000 Ending work in process inventory 23,500 19,600 Ending raw materials inventory 7,200 8,800 Factory utilities 9,150 12,250 Factory...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,500 $ 16,300 Beginning work in process inventory 15,900 19,650 Beginning raw materials inventory 10,500 14,400 Rental cost on factory equipment 28,750 26,500 Direct labor 25,000 42,600 Ending finished goods inventory 20,000 13,000 Ending work in process inventory 23,500 19,600 Ending raw materials inventory 7,200 8,800 Factory utilities 9,150 12,250 Factory...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,000 $ 19,450 Beginning work in process inventory 16,300 20,100 Beginning raw materials inventory (direct materials) 8,900 9,450 Rental cost on factory equipment 32,750 24,850 Direct labor 24,400 41,000 Ending finished goods inventory 21,050 13,400 Ending work in process inventory 25,000 19,400 Ending raw materials inventory 7,100 8,200 Factory utilities 13,500...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,000 $ 19,450 Beginning work in process inventory 16,300 20,100 Beginning raw materials inventory (direct materials) 8,900 9,450 Rental cost on factory equipment 32,750 24,850 Direct labor 24,400 41,000 Ending finished goods inventory 21,050 13,400 Ending work in process inventory 25,000 19,400 Ending raw materials inventory 7,100 8,200 Factory utilities 13,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT