Healthy Eating Foods Company | ||||||||||||
Worksheet | ||||||||||||
For the Year Ended December 31, 2019 | ||||||||||||
Account | Unadjusted Trial Balance | Adjustments | Adjusted Trial Balance | Income Statement | Balance Sheet | |||||||
Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | |||
Cash | 29300 | 29300 | 29300 | |||||||||
Accounts receivable | 34400 | 34400 | 34400 | |||||||||
Allowance for doubtful accounts | 340 | c. | 2760 | 3100 | 3100 | |||||||
Merchandise inventory | 85200 | a, b. | 77200 | a, b. | 85200 | 77200 | 77200 | |||||
Supplies | 9600 | d. | 8500 | 1100 | 1100 | |||||||
Prepaid insurance | 4440 | e. | 2960 | 1480 | 1480 | |||||||
Office Equipment | 8200 | 8200 | 8200 | |||||||||
Accum. depreciation-office equipment | 2570 | f. | 1285 | 3855 | 3855 | |||||||
Warehouse equipment | 23200 | 23200 | 23200 | |||||||||
Accum. depreciation-warehouse equipment | 8000 | g. | 4000 | 12000 | 12000 | |||||||
Notes payable-bank | 28000 | 28000 | 28000 | |||||||||
Accounts payable | 11400 | 11400 | 11400 | |||||||||
Interest payable | h. | 560 | 560 | 560 | ||||||||
Social security tax payable | 1600 | j. | 868 | 2468 | 2468 | |||||||
Medicare tax payable | 380 | j. | 203 | 583 | 583 | |||||||
Federal unemployment tax payable | k. | 84 | 84 | 84 | ||||||||
State unemployment tax payable | k. | 756 | 756 | 756 | ||||||||
Salaries payable | i. | 14000 | 14000 | 14000 | ||||||||
Phillip Tucker, Capital | 95872 | 95872 | 95872 | |||||||||
Phillip Tucker, Drawing | 52000 | 52000 | 52000 | |||||||||
Sales | 645778 | 645778 | 645778 | |||||||||
Sales returns and allowances | 9200 | 9200 | 9200 | |||||||||
Purchases | 346000 | 346000 | 346000 | |||||||||
Purchases returns and allowances | 8400 | 8400 | 8400 | |||||||||
Income summary | a, b. | 85200 | a, b. | 77200 | 8000 | 8000 | ||||||
Rent expense | 35200 | 35200 | 35200 | |||||||||
Telephone expense | 1400 | 1400 | 1400 | |||||||||
Salaries expense | 152000 | i. | 14000 | 166000 | 166000 | |||||||
Payroll taxes expense | 12200 | j, k | 1911 | 14111 | 14111 | |||||||
Supplies expense | d. | 8500 | 8500 | 8500 | ||||||||
Insurance expense | e. | 2960 | 2960 | 2960 | ||||||||
Depreciation expense-office equip. | f. | 1285 | 1285 | 1285 | ||||||||
Depreciation expense-warehouse equip. | g. | 4000 | 4000 | 4000 | ||||||||
Uncollectible accounts expense | c. | 2760 | 2760 | 2760 | ||||||||
Interest expense | h. | 560 | 560 | 560 | ||||||||
Totals | 802340 | 802340 | 198376 | 198376 | 826856 | 826856 | 599976 | 654178 | 226880 | 172678 | ||
Net income | 54202 | 54202 | ||||||||||
Totals | 654178 | 654178 | 226880 | 226880 |
Working:
c. Uncollectible accounts expense = 0.50% x $552000 = $2760
e. Insurance expense = $4440 x 8/12 = $2960
f. Depreciation-office equipment = ($8200 - $490) x 1/6 = $1285
g. Depreciation-warehouse equipment = ($23200 - $3200) x 1/5 = $4000
h. Interest expense = $28000 x 12% x 2/12 = $560
Analyze:
Net income: $54202
Problem 12.5A Recording adjustments and completing the worksheet. LO 12-1, 12-2, 12-3, 12-4 Healthy Eating Foods...
Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On December 31, 2019, the firm’s general ledger contained the accounts and balances that follow. ACCOUNTS AND BALANCES Cash $ 30,900 Dr. Accounts Receivable 36,000 Dr. Allowance for Doubtful Accounts 500 Cr. Merchandise Inventory 86,800 Dr. Supplies 11,200 Dr. Prepaid Insurance 6,360 Dr. Office Equipment 10,000 Dr. Accum. Depreciation—Office Equipment 2,730 Cr. Warehouse Equipment 38,400 Dr. Accum. Depreciation—Warehouse Equipment 11,200 Cr. Notes Payable—Bank 36,000 Cr....
The Green Thumb Gardener is a retail store that sells plants, soil, and decorative pots. On December 31, 2019, the firm's general ledger contained the accounts and balances that appear below. ACCOUNTS AND BALANCES Cash $ 4,800 Dr. Accounts Receivable 1,700 Dr. Allowance for Doubtful Accounts 43 Cr. Merchandise Inventory 10,400 Dr. Supplies 1,110 Dr. Prepaid Advertising 1,080 Dr. Store Equipment 7,560 Dr. Accumulated Depreciation—Store Equipment 1,410 Cr. Office Equipment 1,060 Dr. Accumulated Depreciation—Office Equipment 190 Cr. Accounts Payable 2,535...
The Green Thumb Gardener is a retail store that sells plants, soil, and decorative pots. On December 31, 2019, the firm's general ledger contained the accounts and balances that appear below. ACCOUNTS AND BALANCES Cash $ 5,200 Dr. Accounts Receivable 2,100 Dr. Allowance for Doubtful Accounts 47 Cr. Merchandise Inventory 10,800 Dr. Supplies 1,150 Dr. Prepaid Advertising 960 Dr. Store Equipment 7,800 Dr. Accumulated Depreciation—Store Equipment 1,450 Cr. Office Equipment 1,300 Dr. Accumulated Depreciation—Office Equipment 230 Cr. Accounts Payable 2,575...
The worksheet of Bridget's Office Supplies contains the following revenue, cost, and expense accounts. The merchandise inventory amounted to $59,275 on January 1, 2019, and $52,225 on December 31, 2019. The expense accounts numbered 611 through 617 represent selling expenses, and those numbered 631 through 646 represent general and administrative expenses. Accounts 401 Sales $ 246,600 Cr. 451 Sales Returns and Allowances 4,300 Dr. 491 Miscellaneous Income 350 Cr. 501 Purchases 103,100 Dr. 502 Freight In 1,925 Dr. 503 Purchases...
The worksheet of Bridget's Office Supplies contains the following revenue, cost, and expense accounts. The merchandise inventory amounted to $58,575 on January 1, 2019, and $51,525 on December 31, 2019. The expense accounts numbered 611 through 617 represent selling expenses, and those numbered 631 through 646 represent general and administrative expenses. Accounts 401 Sales $ 245,200 Cr. 451 Sales Returns and Allowances 4,230 Dr. 491 Miscellaneous Income 280 Cr. 501 Purchases 102,400 Dr. 502 Freight In 1,855 Dr. 503 Purchases...
The worksheet of Bridget's Office Supplies contains the following revenue, cost, and expense accounts. The merchandise inventory amounted to $59,175 on January 1, 2019, and $52,125 on December 31, 2019. The expense accounts numbered 611 through 617 represent selling expenses, and those numbered 631 through 646 represent general and administrative expenses. Accounts 401 Sales 451 Sales Returns and Allowances 491 Miscellaneous Income 501 Purchases 502 Freight In 503 Purchases Returns and Allowances 504 Purchases Discounts 611 Salaries Expense-Sales 614 Store...
The Green Thumb Gardener is a retail store that sells plants, soil, and decorative pots. On December 31, 2019, the firm's general ledger contained the accounts and balances that appear below ACCOUNTS AND BALANCES Cash Accounts Receivable Allowance for Doubtful Accounts Merchandise Inventory Supplies Prepaid Advertising Store Equipment Accumulated Depreciation-Store Equipment Office Equipment Accumulated Depreciation-Office Equipment Accounts Payable Social Security Tax Payable Medicare Tax Payable Federal Unemployment Tax Payable State Unemployment Tax Payable Salaries Payable Beth Argo, Capital Beth Argo,...
Using the information in the Worksheet (1) tab, Aging Analysis (2) tab, and Adjustments (3) tab, prepare the adjusting journal entries for the period. Record the entries in the Adjusting Journal Entries (4) tab. (Round all numbers to the nearest dollar.) SHOW YOUR WORK FOR THE ADJUSTMENT IN THE CELL OR YOU WILL NOT RECEIVE CREDIT FOR THE ENTRY. Use formulas and link the values to the adjustment. Adjusting Journal Entries For the Year Ended December 31,2019 Account Titles DR...
Exercise 13.3 Preparing a classified income statement. LO 13-1 The worksheet of Bridget's Office Supplies contains the following revenue, cost, and expense accounts. The merchandise inventory amounted to $58,975 on January 1, 2019, and $51.925 on December 31, 2019. The expense accounts numbered 611 through 617 represent selling expenses, and those numbered 631 through 646 represent general and administrative expenses. eBook $246.000 r. 4,270 Dr. J20 CP 182,800 Or 3.5e Cr. 1,720 C Accounts 401 Sales 451 Sales Returns and...
The worksheet of Bridget's Office Supplies contains the following revenue, cost, and expense accounts. The merchandise Inventory amounted to $58,375 on January 1, 2019, and $51,325 on December 31, 2019. The expense accounts numbered 611 through 617 represent selling expenses, and those numbered 631 through 646 represent general and administrative expenses. Accounts 401 Sales 451 Sales Returns and Allowances 491 Miscellaneous Income 501 Purchases 5e2 Freight In 5e3 Purchases Returns and Allowances 504 Purchases Discounts 611 Salaries Expense-Sales 614 Store...