Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please assist with steps 6 through 8. The answers for the first 5 steps are given below the question The following information is given at

Please assist with steps 6 through 8. The answers for the first 5 steps are given below the question

The following information is given at the beginning of December.

Debit

Credit

Cash

$67,500

Accounts receivables

$21,000

Allowance for uncollectible accounts

$7,000

Inventory (1,100 units at $7)

$7,700

Accounts payable

$25,400

Common stock

$43,000

Retained earnings

$20,800

Total

$96,200

$96,200

Required:

#1

Enter the beginning balance for each account in the T-accounts (General Ledger) tab in the excel template file.

Required:

#2.

Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file. Use the following accounts as appropriate: Cash, Accounts receivable, Allowance for uncollectible accounts, Inventory, Notes receivables, Interest receivables, Equipment, Accumulated depreciation, Accounts payable, Common stock, Retained earnings, Sales revenue, Interest revenue, Cost of goods sold, Depreciation expense, Bad debt expense, Income tax expense.

Dec. 1.

Used cash to purchase equipment at a purchase price of $20,600, plus tax $300, plus shipping $700.

Dec. 1.

Lend $14,000 to an employee by receiving a note for six months at annual interest rate of 12% due at the maturity date.

Dec. 6.

Purchase 3,800 units of inventory on account at $10 per unit for a total cost of $38,000.

Dec 12.

Assuming the perpetual method is used, the company sold 3,200 units at $20 each on account, terms 2/10, n/30. Calculate the cost of goods sold using the FIFO method and record the appropriate journal entries for the sale and the cost of the sale. (Hint: Make sure to consider the beginning inventory balance from the beginning trial balance)

Dec 20.

Paid $28,000 to suppliers for purchases made on account in the prior month.

Dec 23.

Received cash of $16,000 for sales of inventory made on account on December 12.

Dec 28.

Write-off $2,800 of accounts receivables using the allowance method.

Dec 30.

Paid $4,400 for income tax for the month of December.

Required:

#3.

Post all of the December transactions from the General Journal tab to the T-accounts under the T-Accounts (General Ledger) tab in the excel template file. Make sure to include beginning balances for accounts where necessary.

Required:

#4.

Compute the balances for each T-account after all of the entries have been posted. These are the unadjusted balance as of December 31.

Required:

#5.

Prepare the unadjusted trial balance under the Unadjusted Trial Balance tab in the excel template file.

Provide the total of the debit column from the Unadjusted trial balance _____________

Required:

#6.

Record the following four transactions as adjusting entries under the General Journal tab.

Dec 31.

The company estimates 20% of the ending balance of accounts receivables is not going to be collected. (Hint: Remember to consider the balance in the allowance for uncollectible account, if any.)

Dec 31.

Record December's adjustment to accrue interest for the notes receivables.

Dec 31.

The company uses the lower of cost or market method for inventory valuation. The market value of the inventory is $8 per unit. Make the adjusting entry if necessary.

Dec 31.

Calculate depreciation using Straight line method. The equipment purchased has a useful life of 72 months and no residual value. Record the depreciation for the month of December.

Required:

#7.

Post all of the adjusting entries to the T-accounts under the T-Accounts (General Ledger) tab. Compute the balance for each T-account after all of the adjusting entries have been posted. These are the adjusted balance as of December 31.

Required:

#8.

Prepare the adjusted trial balance under the Adjusted Trial Balance tab as of December 31 in the excel template file.

Provide the following accounts balances from the Adjusted Trial Balance: (Please enter all amounts as a positive number. No brackets.)

Cash ___________

Accounts receivable ___________

Allowance for uncollectible accounts _________

Inventory _________

Notes receivable _____________

Interest receivables _____________

Equipment _______________

Accumulated depreciation _____________

Accounts payable __________________

Common stock _______________

Retained earnings ______________

Sales revenue ___________

Interest revenue ____________

Cost of goods sold ____________

Bad debt expense ____________

Depreciation expense ______________

Income tax expense ______________

Here are the answers for the first five steps......... Please assist with steps 6 through 8

1. Beginning balance for each account in the T-accounts (General Ledger) tab in the excel template file is ahown below:

Cash
Particulars Amount ($) Particulars Amount ($)
Opening balance 67,500
Account Receivable
Particulars Amount ($) Particulars Amount ($)
Opening balance 21,000
Allowance for uncollectible accounts
Particulars Amount ($) Particulars Amount ($)
Opening balance 7,000
Inventory
Particulars Amount ($) Particulars Amount ($)
Opening balance 7,700
Accounts Payable
Particulars Amount ($) Particulars Amount ($)
Opening balance 25,400
Common Stock
Particulars Amount ($) Particulars Amount ($)
Opening balance 43,000
Retained Earnings
Particulars Amount ($) Particulars Amount ($)
Opening balance 20,800

2.

Journal entries for ecember are as shown below:

Date Particulars L.F Amount ($) Amount ($)
Dec-01 Equipment 21,600
Cash 21,600
(For equipment purchased)
Dec-01 Note Receivable 14,000
Cash 14,000
(For cash lend for note receivable)
Dec-06 Inventory 38,000
Accounts Payable 38,000
(For inventory purchased)
Dec-12 Accounts Receivable 64,000
Sales 64,000
(For goods sold)
Dec-12 Cost of good sold 28,700
Inventory 28,700
(For cost of goods sold recorded)
1,100*7 = 7,700
2,100*10= 21,000
Dec-20 Accounts Payable 28,000
cash 28,000
(For paid to suppliers)
Dec-23 Cash 16,000
Accounts Receivable 16,000
(For cash received against sale)
Dec-28 Allowance for doubtful accounts 2,800
Accounts Receivable 2,800
(For accounts receivable written off)
Dec-30 Income tax expense 4,400
cash 4,400
(For income tax paid)

3 and 4. Adjusted general ledger with balances are as shown below:

Cash
Particulars Amount ($) Particulars Amount ($)
Opening balance 67,500 Equipment 21,600
Accounts Receivable 16,000 Note Receivable 14,000
Accounts payable 28,000
Income tax expesne 4,400
83,500 68,000
Closing balance 15,500
Account Receivable
Particulars Amount ($) Particulars Amount ($)
Opening balance 21,000 Cash 16,000
Sales 64,000 Allowance for doubtful 2,800
85,000 18,800
66,200
Allowance for uncollectible accounts
Particulars Amount ($) Particulars Amount ($)
Account Receivable 2,800 Opening balance 7,000
Closing balance 4,200
Inventory
Particulars Amount ($) Particulars Amount ($)
Opening balance 7,700 Cost of goods sold 28,700
Cash 38,000
45,700 28,700
Closing balance 17,000
Accounts Payable
Particulars Amount ($) Particulars Amount ($)
Cash 28,000 Opening balance 25,400
Inventory 38,000
28,000 63,400
Closing balance 35,400
Common Stock
Particulars Amount ($) Particulars Amount ($)
Opening balance 43,000
Closing balance 43,000
Retained Earnings
Particulars Amount ($) Particulars Amount ($)
Opening balance 20,800
Closing balance 20,800
Equipment
Particulars Amount ($) Particulars Amount ($)
Cash 21,600
Closing balance 21,600
Note Receivable
Particulars Amount ($) Particulars Amount ($)
Cash 14,000
Closing balance 14,000
Sales
Particulars Amount ($) Particulars Amount ($)
Account Receivable 64,000
Cost of goods sold
Particulars Amount ($) Particulars Amount ($)
Inventory 28,700
Income tax expense
Particulars Amount ($) Particulars Amount ($)
Inventory 4,400

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

CPA Excel Auditing And Attestation

Authors: Robert A. Prentice

1st Edition

0977165876, 978-0977165872

More Books

Students also viewed these Accounting questions