On December 1, 2010, Moreland Company had the following account balances. Debits Credits Cash $18,200 Accumulated Depreciation $ 3,000 Notes Receivable 2,500 Accounts Payable 6,100 Accounts Receivable 7,500 Common Stock 20,000 Merchandise Inventory 16,000 Retained Earnings 44,700 Prepaid Insurance 1,600 $73,800 Equipment 28,000 $73,800 During December the company completed the following transactions. Dec. 7 Received $3,200 cash from customers in payment of account (no discount allowed). 12 Purchased merchandise on account from King Co. $12,000, terms 2/10, n/30. 17 Sold merchandise on account $15,000, terms 1/10, n/30. The cost of the merchandise sold was $10,000. 19 Paid salaries $2,500. 22 Paid King Co. in full, less discount. 26 Received collections in full, less discounts, from customers billed on December 17. Adjustment data: 1. Depreciation $200 per month. 2. Insurance expired $400. 3. Income tax expense was $425. It was unpaid at December 31. Instructions (a) Journalize the December transactions. (Assume a perpetual inventory system.) (b) Enter the December 1 balances in the ledger T accounts and post the December transactions. Use Cost of Goods Sold, Depreciation Expense, Insurance Expense, Salaries Expense, Sales, Sales Discounts, Income Tax Payable, and Income Tax Expense. (c) The statement from Lyon County Bank on December 31 showed a balance of $22,164. A comparison of the bank statement with the cash account revealed the following facts. 1. The bank collected a note receivable of $2,500 for Moreland Company on December 15. 2. The December 31 receipts of $2,736 were not included in the bank deposits for December. The company deposited these receipts in a night deposit vault on December 31. 3. Checks outstanding on December 31 totaled $1,210. 4. On December 31 the bank statement showed a NSF charge of $800 for a check received by the company from C. Park, a customer, on account. Prepare a bank reconciliation as of December 31 based on the available information. (Hint: The cash balance per books is $21,990. This can be proven by finding the balance in the Cash account from parts (a) and (b).) (d) Journalize the adjusting entries resulting from the bank reconciliation and adjustment data. (e) Post the adjusting entries to the ledger T accounts. (f) Prepare an adjusted trial balance. Totals $89,425 (g) Prepare an income statement for December and a classified balance sheet at December 31. Net income $ 1,325 Total assets $72,550
(a) | Dec. 7 | Cash
Accounts Receivable…………………………………….. |
3,200
|
3,200 |
|||
12 | Merchandise Inventory………………………………………….
Accounts Payable…………………………………………. |
12,000
|
12,000 |
||||
17 | Accounts Receivable………………………………………………
Sales…………………………………………………………….
Cost of Goods Sold……………………………………………….. Merchandise Inventory………………………………… |
15,000
10,000 |
15,000
10,000 |
||||
19 | Salaries Expense……………………………………………………
Cash……………………………………………………………. |
2,500 |
2,500 |
||||
22 | Accounts Payable…………………………………………………..
Cash ($12,000 X .98)…………………………………….. Merchandise Inventory………………………………… |
12,000 |
11,760 240 |
||||
26 | Cash ($15,000 X .99)………………………………………………
Sales Discounts……………………………………………………… Accounts Receivable…………………………………….. |
14,850
150 |
15,000 |
(b) & (e) General Ledger
Cash | |
12/1 Bal. 18,200
12/7 3,200 12/26 14,850 12/31 2,500 |
12/19 2,500
12/22 11,760 12/31 800 |
12/31 Bal. 23,690 |
Notes Receivable | |
12/1 Bal. 2,500 | 12/31 2,500 |
12/31 Bal. – 0 – |
Accounts Receivable |
|
12/1 Bal. 7,500
12/17 15,000 12/31 800 |
12/7 3,200
12/26 15,000
|
12/31 Bal. 5,100 |
Merchandise Inventory | |
12/1 Bal. 16,000
12/12 12,000 |
12/17 10,000
12/22 240 |
12/31 Bal. 17,760 |
Prepaid Insurance | |
12/1 Bal. 1,600 | 12/31 400 |
12/31 Bal. 1,200 |
Equipment | |
12/1 Bal. 28,000 | |
Accumulated Depreciation | |
12/1 Bal. 3,000
12/31 200 |
|
12/31 Bal. 3,200 |
Accounts Payable | |
12/22 12,000 | 12/1 Bal. 6,100
12/12 12,000 |
12/31 Bal. 6,100 |
Income Tax Payable | |
12/31 425 | |
12/31 Bal. 425 |
Common Stock | |
12/1 Bal. 20,000 | |
Retained Earnings | |
12/1 Bal. 44,700 | |
Sales | |
12/17 15,000 | |
12/31 Bal. 15,000 |
Sales Discounts | |
12/26 150 | |
12/31 Bal. 150 |
Cost of Goods Sold | |
12/17 10,000 | |
12/31 Bal. 10,000 |
Depreciation Expense | |
12/31 200 | |
12/31 Bal. 200 |
Salaries Expense | |
12/19 2,500 | |
12/31 Bal. 2,500 |
Insurance Expense | |
12/31 400 | |
12/31 Bal. 400 |
Income Tax Expense | |
12/31 425 | |
12/31 Bal. 425 |
(c) MORELAND COMPANY
Bank Reconciliation
December 31, 2010
Cash balance per bank statement…………………………………………….. $22,164
Add: Deposits in transit…………………………………………………………… 2,736
24,900
Less: Outstanding checks………………………………………………………… 1,210
Adjusted cash balance per bank………………………………………………. $23,690
Cash balance per books…………………………………………………………… 21,990
Add: Collection of note receivable……………………………………………. 2,500
24,490
Less: NSF check……………………………………………………………………… 800
Adjusted cash balance per books…………………………………………….. $23,690
(d) Dec. 31 Cash…………………………………………………………………….. 2,500
Notes Receivable…………………………………………… 2,500
Accounts Receivable……………………………………………… 800
Cash…………………………………………………………….. 800
Depreciation Expense……………………………………………. 200
Accumulated Depreciation…………………………….. 200
Insurance Expense………………………………………………… 400
Prepaid Insurance…………………………………………. 400
Income Tax Expense……………………………………………… 425
Income Tax Payable……………………………………… 425
(f) MORELAND COMPANY
Adjusted Trial Balance
December 31, 2010
DR. | CR. | |||
Cash………………………………………………………………………. | $23,690 | |||
Notes receivable……………………………………………………… | –0– | |||
Accounts Receivable……………………………………………….. | 5,100 | |||
Merchandise Inventory…………………………………………… | 17,760 | |||
Prepaid Insurance………………………………………………….. | 1,200 | |||
Equipment……………………………………………………………… | 28,000 | |||
Accumulated Depreciation……………………………………… | $ 3,200 | |||
Accounts Payable…………………………………………………… | 6,100 | |||
Income Tax Payable……………………………………………….. | 425 | |||
Common Stock………………………………………………………. | 20,000 | |||
Retained Earnings………………………………………………….. | 44,700 | |||
Sales………………………………………………………………………. | 15,000 | |||
Sales Discounts……………………………………………………….. | 150 | |||
Cost of Goods Sold…………………………………………………. | 10,000 | |||
Depreciation Expense……………………………………………… | 200 | |||
Salaries Expense…………………………………………………….. | 2,500 | |||
Insurance Expense…………………………………………………. | 400 | |||
Income Tax Expense………………………………………………. | 425 | |||
$89,425 | $89,425 |
(g) MORELAND COMPANY
Income Statement
For the Month Ending December 31, 2010
Sales………………………………………………………………………. | $15,000 | |||
Less: Sales discounts………………………………………………. | 150 | |||
Net sales…………………………………………………………………. | 14,850 | |||
Cost of goods sold…………………………………………………… | 10,000 | |||
Gross profit……………………………………………………………. | 4,850 | |||
Operating expenses | ||||
Salaries expense…………………………………………….. | $2,500 | |||
Insurance expense………………………………………….. | 400 | |||
Depreciation expense……………………………………… | 200 | 3,100 | ||
Income before income tax……………………………………….. | 1,750 | |||
Income tax expense…………………………………………………. | 425 | |||
Net income……………………………………………………………… | $ 1,325 |
(g) MORELAND COMPANY
Balance Sheet
December 31, 2010
Assets
Current assets | ||||
Cash………………………………………………………………….. | $23,690 | |||
Accounts receivable……………………………………………. | 5,100 | |||
Merchandise inventory………………………………………. | 17,760 | |||
Prepaid Insurance……………………………………………… | 1,200 | |||
Total current assets……………………………………… | $47,750 | |||
Property, plant, and equipment | ||||
Equipment………………………………………………………… | 28,000 | |||
Less: Accumulated depreciation………………………… | 3,200 | 24,800 | ||
Total assets…………………………………………………………………. | $72,550 |
Liabilities and Stockholders’ Equity
Current liabilities | ||||
Accounts payable………………………………………………. | $ 6,100 | |||
Income tax payable……………………………………………. | 425 | |||
Total current liabilities………………………………… | $ 6,525 | |||
Stockholders’ equity | ||||
Common stock…………………………………………………… | 20,000 | |||
Retained earnings ($44,700 + $1,325)………………….. | 46,025 | |||
Total stockholders’ equity……………………………. | 66,025 | |||
Total liabilities and stockholders’ equity………………………. | $72,550 |