Question

On January 1, 2018, the general ledger of a company includes the following account balances Debit Credit Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Building Accumulated Depreciation Land Accounts Payable Notes Payable (6%, due in 3 years) Common Stock Retained Earnings $ 81,000 54,000 $ 8,000 41,000 81,000 21,000 211,000 31,000 45,000 111,000 252,000 468,000 Totals $ 468,000 The company accounts for all inventory transactions using the perpetual FIFO method. Purchases and sales of inventory are recorded using the gross method for cash discounts. The $30,000 beginning balance of inventory consists of 300 units, each costing $100 During January 2018, the company had the following transactions During January 2018, the following transactions occur: January 2 Lent $31,000 to an employee by accepting 6% note due in six months. January 5 Purchased 4,900 units of inventory on account for $539,000 ($110 each) with terms 1/10, n/30 January 8 Returned 120 defective units of inventory purchased on January 5. January 15 Sold 4,700 units of inventory on account for $611,000 ($130 each) with terms 2/10, n/30 January 17 Customers returned 300 units sold on January 15. These units are placed in inventory to be sold in the future January 20 Received cash from customers on accounts receivable. This amount includes $47,000 from 2017 plus amount receivable on sale of 4,100 units sold on January 15 January 21 Wrote off remaining accounts receivable from 2017. January 24 Paid on accounts payable. The amount includes the amount owed at the beginning of the period plus the amount owed from purchase of 4,500 units on January 5 January 28 Paid cash for salaries during January, $39,000 January 29 Paid cash for utilities during January, $21,000 January 30 Paid dividends, $7,000. The following information is available on January 31, 2018 a. Of the remaining accounts receivable, the company estimates that 10% will not be collected b. Accrued interest income on notes receivable for January C. Accrued interest expense on notes payable for January d. Accrued income taxes at the end of January for $6,100 e. Depreciation on the building, $3,100General Journal General Trial Balance Ledger Statement Balance Sheet Analysis Record each of the transactions listed above in the General Journal tab (these are shown as items 1 -13) assuming a FIFO perpetual inventory system. The transaction on January 30 requires two entries: one to record sales revenue and one to record cost of goods sold. Review the General Ledger and the Trial Balance tabs to see the effect of the transactions on the account balances 2. Record adjusting entries on January 31. in the General Journal tab (these are shown as items 14-18). 3. Review the adjusted Trial Balance as of January 31, 2018, in the Trial Balance tab. 4. Prepare a multiple-step income statement for the period ended January 31, 2018, in the Income Statement tab. 5. Prepare a classified balance sheet as of January 31, 2018, in the Balance Sheet tab. 6. Record the closing entries in the General Journal tab (these are shown as items 19 and 20). Using the information from the requirements above, complete the Analysis tab.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Date Account Debit Credit
Jan 2 Note Receivable $    31,000
Jan 2 Cash $ 31,000
Jan 5 Inventory $ 539,000
Jan 5 Accounts Payable $539,000
Jan 8 Accounts Payable $    13,200
Jan 8 Inventory $ 13,200
Jan 15 Accounts Receivable $ 611,000
Jan 15 Sale $611,000
Jan 15 Cost of Goods Sold $ 517,000 4700*110
Jan 15 Inventory $517,000
Jan 17 Sales Return and Allowance $    39,000 300*130
Jan 17 Accounts Receivable $ 39,000
Jan 17 Inventory $    33,000 300*110
Jan 17 Cost of Goods Sold $ 33,000
Jan 20 Cash $ 569,340
Jan 20 Sales Discount $    10,660 (4100*130)*2%
Jan 20 Accounts Receivable $580,000 47000+(4100*130)
Jan 21 Allowance for Uncollectible Accounts $      7,000
Jan 21 Accounts Receivable $    7,000
Jan 24 Accounts Payable $ 526,000 31000+(4500*110)
Jan 24 Cash $526,000
Jan 28 Salaries Expense $    39,000
Jan 28 Cash $ 39,000
Jan 29 Utilities Expense $    21,000
Jan 29 Cash $ 21,000
Jan 30 Dividends $      7,000
Jan 30 Cash $    7,000
Adjusting Entries:
a Bad Debt Expense $      2,900
Allowance for Uncollectible Accounts $    2,900
Beginning Balance, Accounts Receivable $    54,000
Add: Credit Sale $ 611,000
Less: Collection $-580,000
Less: Sales Return $ -39,000
Less: Write off $    -7,000
Ending Balance, Unadjusted $    39,000
Estimated Uncollectible 10% $      3,900
Beginning Balance, Allowance $      8,000
Less: Write Off $      7,000
Less: Ending Balance $      3,900
Bad Debt Expense to be recorded $      2,900
b Interest Receivable $         155 31000*6%*1/12
Interest Revenue $        155
c Interest Expense $         225 45000*6%*1/12
Interest Payable $        225
d Income Tax Expense $      6,100
Income Tax Payable $    6,100
e Depreciation Expense $      3,100
Accumulated Depreciation $    3,100
Closing Entries:
f Sales Revenue $ 611,000
Interest Revenue $         155
Income Summary $611,155
g Income Summary $ 605,985
Sales Return and Allowance $ 39,000
Cost of Goods Sold $484,000
Sales Discount $ 10,660
Salaries Expense $ 39,000
Utilities Expense $ 21,000
Bad Debt Expense $    2,900
Interest Expense $        225
Depreciation Expense $    3,100
Income Tax Expense $    6,100
h Income Summary $      5,170
Retained Earning
i Retained Earning $      7,000
Dividends $    7,000
Beginning Jan Normal Unadjusted Adjustments Adjusted Post Closing
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
Cash $     81,000 $    54,660 $     26,340 $     26,340 $ 26,340 $           -  
Accounts Receivable $     54,000 $    15,000 $     39,000 $     39,000 $ 39,000 $           -  
Allowance for Uncollectible Accounts $     8,000 $    7,000 $        1,000 $    2,900 $        3,900 $          -   $    3,900
Inventory $     41,000 $ 41,800 $     82,800 $     82,800 $ 82,800 $           -  
Interest Receivable $              -   $       155 $           155 $       155 $           -  
Note Receivable $ 31,000 $     31,000 $     31,000 $ 31,000 $           -  
Building $     81,000 $     81,000 $     81,000 $ 81,000 $           -  
Accumulated Depreciation $   21,000 $     21,000 $    3,100 $     24,100 $          -   $ 24,100
Land $   211,000 $   211,000 $   211,000 $211,000 $           -  
Accounts Payable $   31,000 $        200 $     30,800 $     30,800 $          -   $ 30,800
Interest Payable $              -   $       225 $           225 $          -   $        225
Income Tax Payable $              -   $    6,100 $        6,100 $          -   $    6,100
Notes Payable $   45,000 $     45,000 $     45,000 $          -   $ 45,000
Common Stock $ 111,000 $   111,000 $   111,000 $          -   $111,000
Retained Earning $ 252,000 $   252,000 $   252,000 $250,170
Dividends $    7,000 $        7,000 $        7,000
Sales $ 611,000 $   611,000 $   611,000
Interest Revenue $              -   $       155 $           155
Sales Return and Allowance $ 39,000 $     39,000 $     39,000
Cost of Goods Sold $484,000 $   484,000 $   484,000
Sales Discount $ 10,660 $     10,660 $     10,660
Salaries Expense $ 39,000 $     39,000 $     39,000
Utilities Expense $ 21,000 $     21,000 $     21,000
Bad Debt Expense $              -   $    2,900 $        2,900
Interest Expense $              -   $       225 $           225
Depreciation Expense $              -   $    3,100 $        3,100
Income Tax Expense $              -   $    6,100 $        6,100
Total $   468,000 $ 468,000 $680,660 $ 680,660 $1,071,800 $1,071,800 $ 12,480 $ 12,480 $1,084,280 $1,084,280 $471,295 $471,295
Income Statement:
Sales $ 611,000
Less: Sales Return and Allowance $   39,000
Less: Sales Discount $   10,660
Net Sales $ 561,340
Less: Cost of Goods Sold $ 484,000
Gross Margin $   77,340
Less: Operating Expense
Salaries Expense $     39,000
Utilities Expense $     21,000
Bad Debt Expense $        2,900
Depreciation Expense $        3,100
Total Operatng Expense $   66,000
Net Operating Income $   11,340
Less: Other Expense and Revenue
Interest Expense $         -225
Interest Revenue $           155
$         -70
Income Before Tax $   11,270
Less:Income Tax Expense $     6,100
Net Income $     5,170
Statement of Retained Earning:
Beginning Balance $ 252,000
Add: Net Income $     5,170
Less: Dividends $     7,000
Ending $ 250,170
Balance Sheet:
Current Assets:
Cash $   26,340
Accounts Receivable $     39,000
Allowance for Uncollectible Accounts $      -3,900 $   35,100
Inventory $   82,800
Interest Receivable $         155
Note Receivable $   31,000
Total Current Assets $ 175,395
Building $     81,000
Accumulated Depreciation $    -24,100 $   56,900
Land $ 211,000
Total Assets $ 443,295
Current Liabilities:
Accounts Payable $   30,800
Interest Payable $         225
Income Tax Payable $     6,100
Total Current Liabilities $   37,125
Notes Payable $   45,000
Total Liabilities $   82,125
Equity:
Common Stock $ 111,000
Retained Earning $ 250,170
Total Equity $ 361,170
Total Liabilities and Equity $ 443,295
CO Ind
Gross Profit Ratio 77340/561340 13.78% 10.00% Better
Inventory Turnover 484000/61900              7.82        12.00 Lower is not better
COGS/Inventory
Avg Inventory (82800+41000)/2 $     61,900
It means selling low vlume with high profit
Add a comment
Know the answer?
Add Answer to:
On January 1, 2018, the general ledger of a company includes the following account balances Debit...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • On January 1, 2018, the general ledger of a company includes the following account balances: Credit...

    On January 1, 2018, the general ledger of a company includes the following account balances: Credit Debit $ 78,000 48,000 $ 5,000 38,000 78,000 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Building Accumulated Depreciation Land Accounts Payable Notes Payable (8%, due in 3 years) Common Stock Retained Earnings Totals 18,000 208,000 28,000 42,000 108,000 249,000 $ 450,000 $ 450,000 The company accounts for all inventory transactions using the perpetual FIFO method. Purchases and sales of inventory are recorded...

  • On January 1, 2018, the general ledger of Freedom Fireworks includes the following account balances: Credit...

    On January 1, 2018, the general ledger of Freedom Fireworks includes the following account balances: Credit Debit $ 103,200 38,000 154,000 87,300 140,000 $ Accounts Cash Accounts Receivable Inventory Land Buildings Allowance for Uncollectible Accounts Accumulated Depreciation Accounts Payable Bonds Payable Discount on Bonds Payable Common Stock Retained Earnings Totals 3,800 11,600 39,700 140,000 32,000 220,000 139,400 $ 554,500 $ 554,500 During January 2018, the following transactions occur: January 1 Borrow $120,000 from Captive Credit Corporation. The installment note bears...

  • On January 1, 2018, the general ledger of Freedom Fireworks includes the following account balances: Accounts Debit Cred...

    On January 1, 2018, the general ledger of Freedom Fireworks includes the following account balances: Accounts Debit Credit Cash $ 101,400 Accounts Receivable 34,400 Inventory 152,200 Land 69,300 Buildings 122,000 Allowance for Uncollectible Accounts $ 2,000 Accumulated Depreciation 9,800 Accounts Payable 19,900 Bonds Payable 122,000 Discount on Bonds Payable 30,200 Common Stock 202,000 Retained Earnings 153,800 Totals $ 509,500 $ 509,500 During January 2018, the following transactions occur: January 1 Borrow $102,000 from Captive Credit Corporation. The installment note bears...

  • On January 1, 2018, the general ledger of ACME Fireworks includes the following account balances: Accounts...

    On January 1, 2018, the general ledger of ACME Fireworks includes the following account balances: Accounts Debit Credit Cash $ 28,000 Accounts Receivable 48,000 Inventory 20,900 Land 75,000 Equipment 19,500 Allowance for Uncollectible Accounts 5,100 Accumulated Depreciation 2,400 Accounts Payable 29,400 Notes Payable (6%, due April 1, 2019) 59,000 Warranty Liability 26,000 Common Stock 44,000 Retained Earnings 25,500 Totals $ 191,400 $ 191,400 During January 2018, the following transactions occur: January 2 Sold gift cards totaling $9,800. The cards are...

  • On January 1, 2018, the general ledger of TNT Fireworks includes the following account balances: Credit...

    On January 1, 2018, the general ledger of TNT Fireworks includes the following account balances: Credit Debit $ 59,000 25,600 $ 2,500 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Notes Receivable (5%, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 36,600 15,600 158,000 15,100 223,000 54,200 $ 294,800 $ 294,800 During January 2018, the following transactions occur: January 1 Purchase equipment for $19,800. The company estimates a residual value of $1,800 and a six-year...

  • On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances:...

    On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: Credit Debit $ 26, 100 14,700 $ 3,000 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Supplies Notes Receivable (6%, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 3,600 15,000 80,000 7,900 95,000 33,500 $139,400 $139,400 During January 2021, the following transactions occur. January 2 Provide services to customers for cash, $46,100. January 6 Provide services to customers on account,...

  • On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances:...

    On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: Accounts Debit Credit Cash $ 27,300 Accounts Receivable 15,300 Allowance for Uncollectible Accounts $ 4,200 Supplies 4,200 Notes Receivable (6%, due in 2 years) 21,000 Land 80,600 Accounts Payable 9,100 Common Stock 101,000 Retained Earnings 34,100 Totals $ 148,400 $ 148,400 During January 2021, the following transactions occur: January 2 Provide services to customers for cash, $52,100. January 6 Provide services to customers on...

  • The general ledger of Jackrabbit Rentals at January 1, 2021, includes the following account balances: Accounts...

    The general ledger of Jackrabbit Rentals at January 1, 2021, includes the following account balances: Accounts Debits Credits Cash $ 46,500 Accounts Receivable 30,700 Land 115,800 Accounts Payable 15,800 Notes Payable (due in 2 years) 35,000 Common Stock 105,000 Retained Earnings 37,200 Totals $ 193,000 $ 193,000 The following is a summary of the transactions for the year: 1. January 12 Provide services to customers on account, $67,400. 2. February 25 Provide services to customers for cash, $77,800. 3. March...

  • On January 1, 2021, the general ledger of Grand Finale Fireworks includes the following account balances:...

    On January 1, 2021, the general ledger of Grand Finale Fireworks includes the following account balances: Accounts Debit Credit Cash $ 42,900 Accounts Receivable 44,900 Supplies 7,700 Equipment 66,000 Accumulated Depreciation $ 9,200 Accounts Payable 14,800 Common Stock, $1 par value 12,000 Additional Paid-in Capital 82,000 Retained Earnings 43,500 Totals $ 161,500 $ 161,500 During January 2021, the following transactions occur: January 2 Issue an additional 2,200 shares of $1 par value common stock for $44,000. January 9 Provide services...

  • On January 1, 2018, the general ledger of Grand Finale Fireworks includes the following account balances:...

    On January 1, 2018, the general ledger of Grand Finale Fireworks includes the following account balances: Accounts Debit Credit Cash $ 44,100 Accounts Receivable 47,300 Supplies 8,900 Equipment 78,000 Accumulated Depreciation $ 10,400 Accounts Payable 16,000 Common Stock, $1 par value 14,000 Paid-in Capital-Excess of Par 94,000 Retained Earnings 43,900 Totals $ 178,300 $ 178,300 During January 2018, the following transactions occur: January 2 Issue an additional 2,000 shares of $1 par value common stock for $40,000. January 9 Provide...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT