Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On December 31, 20X1, the firm's general ledger contained the accounts and balances that follow. $ 29,100 Dr. 34,200 Dr. 320 Cr. 85,000 Dr. 9,400 Dr. 4,200 Dr. 9,400 Dr. 2,550 Cr 25,800 Dr. 7,600 Cr. 27,000 Cr. 11, 200 Cr. 1,580 Cr. 378 Cr. ACCOUNTS AND BALANCES Cash Accounts Receivable Allowance for Doubtful Accounts Merchandise Inventory Supplies Prepaid Insurance Office Equipment Accumulated Depreciation-office Equipment Warehouse Equipment Accumulated Depreciation-Warehouse Equipment Notes Payable-Bank Accounts Payable Interest Payable Social Security Tax Payable Medicare Tax Payable Federal Unemployment Tax Payable State Unemployment Tax Payable Salaries Payable Phillip Tucker, Capital Phillip Tucker, Drawing Sales Sales Returns and Allowances Purchases Purchases Returns and Allowances Income Summary Rent Expense Telephone Expense Salaries Expense Payroll Taxes Expense Supplies Expense Insurance Expense Depreciation Expense-Office Equipment Depreciation Expense-Warehouse Equipment Uncollectible Accounts Expense Interest Expense 97,694 Cr. 51,000 Dr. 643,778 Cr. 9,000 Dr. 345,000 Dr. 8,200 Cr. 35,000 Dr. 1,200 Dr. 150,000 Dr. 12,000 Dr. ADJUSTMENTS a.-b. Merchandise inventory on December 31, 20X1, is $77,000. c. During 20X1, the firm had net credit sales of $550,000; past experience indicates that 0.75 percent of these sales should result in uncollectible accounts. d. On December 31, 20X1, an inventory of supplies showed that items costing $1,080 were on hand. e. On May 1, 20X1, the firm purchased a one-year insurance policy for $4,200. f. Three years ago the firm purchased office equipment for $9,400. At that time, the equipment was estimated to have a useful life of seven years and a salvage value of $475. g. Three years ago the firm purchased warehouse equipment for $25,800. At that time, the equipment was estimated to have a useful life of six years and a salvage value of $3,000. h. On November 1, 20X1, the firm issued a four-month, 10 percent note for $27,000. i. On December 31, 20X1, the firm owed salaries of $12,000 that will not be paid until 20X2. j. On December 31, 20X1, the firm owed the employer's social security tax (assume 6.2 percent) and Medicare tax (assume 1.45 percent) on the entire $12,000 of accrued wages. k. On December 31, 20X1, the firm owed the federal unemployment tax (assume 0.6 percent) and the state unemployment tax (assume 5.4 percent) on the entire $12,000 of accrued wages. Required: 1. Prepare the Trial Balance section of a 10-column worksheet. The worksheet covers the year ended December 31, 20X1. 2. Enter the adjustments above in the Adjustments section of the worksheet. 3. Complete the worksheet. Analyze: When the financial statements for Healthy Eating Foods Company are prepared, what net income will be reported for the period ended December 31, 20X1? Healthy Eating Foods Company Worksheet Year Ended December 31, 20X1 Adjustments Adjusted Trial Balance Debit Credit Debit Credit Income Statement Trial Balance Debit Credit Balance Sheet Debit Credit Debit Credit Account Name Cash Accounts Receivable Allowance for Doubtful Accounts Merchandise Inventory Supplies Prepaid Insurance Office Equipment Accumulated Depreciation-Office Equipment Warehouse Equipment Accumulated Depreciation-Warehouse Equipment Notes Payable-Bank Accounts Payable Interest Payable Social Security Tax Payable Medicare Tax Payable Federal Unemployment Tax Payable State Unemployment Tax Payable Salaries Payable Phillip Tucker, Capital Phillip Tucker, Drawing Sales Sales Returns and Allowances Purchases Purchases Returns and Allowances Income Summary Rent Expense Telephone Expense Salaries Expense Payroll Taxes Expense Supplies Expense Insurance Expense Depreciation Expense-Office Equipment Depreciation Expense-Warehouse Equipment Uncollectible Accounts Expense Interest Expense Totals Net Income Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On December 31, 20X1, the firm's general ledger contained the accounts and balances that follow. $ 29,100 Dr. 34,200 Dr. 320 Cr. 85,000 Dr. 9,400 Dr. 4,200 Dr. 9,400 Dr. 2,550 Cr 25,800 Dr. 7,600 Cr. 27,000 Cr. 11, 200 Cr. 1,580 Cr. 378 Cr. ACCOUNTS AND BALANCES Cash Accounts Receivable Allowance for Doubtful Accounts Merchandise Inventory Supplies Prepaid Insurance Office Equipment Accumulated Depreciation-office Equipment Warehouse Equipment Accumulated Depreciation-Warehouse Equipment Notes Payable-Bank Accounts Payable Interest Payable Social Security Tax Payable Medicare Tax Payable Federal Unemployment Tax Payable State Unemployment Tax Payable Salaries Payable Phillip Tucker, Capital Phillip Tucker, Drawing Sales Sales Returns and Allowances Purchases Purchases Returns and Allowances Income Summary Rent Expense Telephone Expense Salaries Expense Payroll Taxes Expense Supplies Expense Insurance Expense Depreciation Expense-Office Equipment Depreciation Expense-Warehouse Equipment Uncollectible Accounts Expense Interest Expense 97,694 Cr. 51,000 Dr. 643,778 Cr. 9,000 Dr. 345,000 Dr. 8,200 Cr. 35,000 Dr. 1,200 Dr. 150,000 Dr. 12,000 Dr. ADJUSTMENTS a.-b. Merchandise inventory on December 31, 20X1, is $77,000. c. During 20X1, the firm had net credit sales of $550,000; past experience indicates that 0.75 percent of these sales should result in uncollectible accounts. d. On December 31, 20X1, an inventory of supplies showed that items costing $1,080 were on hand. e. On May 1, 20X1, the firm purchased a one-year insurance policy for $4,200. f. Three years ago the firm purchased office equipment for $9,400. At that time, the equipment was estimated to have a useful life of seven years and a salvage value of $475. g. Three years ago the firm purchased warehouse equipment for $25,800. At that time, the equipment was estimated to have a useful life of six years and a salvage value of $3,000. h. On November 1, 20X1, the firm issued a four-month, 10 percent note for $27,000. i. On December 31, 20X1, the firm owed salaries of $12,000 that will not be paid until 20X2. j. On December 31, 20X1, the firm owed the employer's social security tax (assume 6.2 percent) and Medicare tax (assume 1.45 percent) on the entire $12,000 of accrued wages. k. On December 31, 20X1, the firm owed the federal unemployment tax (assume 0.6 percent) and the state unemployment tax (assume 5.4 percent) on the entire $12,000 of accrued wages. Required: 1. Prepare the Trial Balance section of a 10-column worksheet. The worksheet covers the year ended December 31, 20X1. 2. Enter the adjustments above in the Adjustments section of the worksheet. 3. Complete the worksheet. Analyze: When the financial statements for Healthy Eating Foods Company are prepared, what net income will be reported for the period ended December 31, 20X1? Healthy Eating Foods Company Worksheet Year Ended December 31, 20X1 Adjustments Adjusted Trial Balance Debit Credit Debit Credit Income Statement Trial Balance Debit Credit Balance Sheet Debit Credit Debit Credit Account Name Cash Accounts Receivable Allowance for Doubtful Accounts Merchandise Inventory Supplies Prepaid Insurance Office Equipment Accumulated Depreciation-Office Equipment Warehouse Equipment Accumulated Depreciation-Warehouse Equipment Notes Payable-Bank Accounts Payable Interest Payable Social Security Tax Payable Medicare Tax Payable Federal Unemployment Tax Payable State Unemployment Tax Payable Salaries Payable Phillip Tucker, Capital Phillip Tucker, Drawing Sales Sales Returns and Allowances Purchases Purchases Returns and Allowances Income Summary Rent Expense Telephone Expense Salaries Expense Payroll Taxes Expense Supplies Expense Insurance Expense Depreciation Expense-Office Equipment Depreciation Expense-Warehouse Equipment Uncollectible Accounts Expense Interest Expense Totals Net Income