In: Accounting
M Ratajczyk opened the Big D Emporium on March 1, 2017. During March, the following transactions were completed:
March 1 Issued 10,000 shares of common stock for $25,000 cash.
1 Purchased used servers for $10,000, paying $6,000 cash and the balance on account.
3 Purchased office supplies for $1,500 on account.
5 Paid $2,400 cash on 1-year insurance policy effective March 1.
14 Billed customers $4,200 for data analysis services.
18 Paid $1,500 cash on amount owed on servers and $500 on amount owed on office supplies.
20 Paid $2,750 cash for employee salaries.
21 Collected $1,400 cash from customers billed on March 14.
28 Billed customers $6,200 for data analysis services.
31 Paid $350 for server maintenance which did not extend the life or function of the servers.
31 Declared and paid $900 cash dividend. ACCT 3201
Required:
Post to the ledger accounts.
Prepare a trial balance at March 31.
Journalize the following adjustments:
Earned but unbilled and uncollected revenue at March 31 was $800.
Depreciation on equipment for the month was $650.
One-twelfth of the insurance policy expired.
An inventory count shows $280 of office supplies on hand at March 31.
Incurred employee salaries but unpaid were $1,060.
Post adjusting entries to the general ledger.
Prepare an adjusted trial balance.
Prepare the income statement and a retained earnings statement for March and a classified balance sheet at March 31.
Journalize and post closing entries and complete the closing process.
Prepare a post-closing trial balance at March 31.
| Cash | Common Stock | |||||||||||
| Balance | Balance | |||||||||||
| Date | Particulars | Debit | Credit | Debit | Credit | Date | Particulars | Debit | Credit | Debit | Credit | |
| Mar.1 | Common Stock | 25000 | 25000 | Mar.1 | Cash | 25000 | 25000 | |||||
| Mar.1 | Equipment | 6000 | 19000 | 25000 | ||||||||
| Mar.5 | Prepaid insurance | 2400 | 16600 | 25000 | ||||||||
| Mar.18 | Accounts Payable | 2000 | 14600 | 25000 | ||||||||
| Mar.20 | Salaries Expense | 2750 | 11850 | 25000 | ||||||||
| Mar.21 | Accounts Receivable | 1400 | 13250 | |||||||||
| Mar.31 | Maintenance expenses | 350 | 12900 | |||||||||
| Mar.31 | Dividend | 900 | 12000 | |||||||||
| Equipment | Accounts Payable | |||||||||||
| Balance | Balance | |||||||||||
| Date | Particulars | Debit | Credit | Debit | Credit | Date | Particulars | Debit | Credit | Debit | Credit | |
| Mar.1 | Cash | 6000 | 6000 | Mar.1 | Equipment | 10000 | 10000 | |||||
| Accounts payable | 10000 | 16000 | Mar.3 | Office Supplies | 1500 | 11500 | ||||||
| 16000 | Mar.18 | Cash | 2000 | 9500 | ||||||||
| 16000 | 9500 | |||||||||||
| Office Supplies | Prepaid Insurance | |||||||||||
| Balance | Balance | |||||||||||
| Date | Particulars | Debit | Credit | Debit | Credit | Date | Particulars | Debit | Credit | Debit | Credit | |
| Mar.3 | Accounts Payable | 1500 | 1500 | mar.5 | Cash | 2400 | 2400 | |||||
| 1500 | 2400 | |||||||||||
| 1500 | 2400 | |||||||||||
| 1500 | 2400 | |||||||||||
| Service Revenue | Accounts Receivable | |||||||||||
| Balance | Balance | |||||||||||
| Date | Particulars | Debit | Credit | Debit | Credit | Date | Particulars | Debit | Credit | Debit | Credit | |
| Mar.14 | Accounts Receivable | 4200 | 4200 | Mar.14 | Service Revenue | 4200 | 4200 | |||||
| Mar.28 | Accounts Receivable | 6200 | 10400 | Mar.21 | Cash | 1400 | 2800 | |||||
| 10400 | Mar.28 | Service Revenue | 6200 | 9000 | ||||||||
| 10400 | 9000 | |||||||||||
| Salaries Expense | Maintenance expenses | |||||||||||
| Balance | Balance | |||||||||||
| Date | Particulars | Debit | Credit | Debit | Credit | Date | Particulars | Debit | Credit | Debit | Credit | |
| Mar.20 | Cash | 2750 | 2750 | Mar.31 | Cash | 350 | 350 | |||||
| 2750 | 350 | |||||||||||
| 2750 | 350 | |||||||||||
| 2750 | 350 | |||||||||||
| Dividend | ||||||||||||
| Balance | ||||||||||||
| Date | Particulars | Debit | Credit | Debit | Credit | |||||||
| Mar.31 | Cash | 900 | 900 | |||||||||
| 900 | ||||||||||||
| 900 | ||||||||||||
| 900 | ||||||||||||
| Big D Emporium | ||
| Trial balance as at Marc 31, 2017 | ||
| Unadjusted | ||
| Debit | credit | |
| Cash | 12000 | |
| Accounts receivable | 9000 | |
| Office Supplies | 1500 | |
| Prepaid Insurance | 2400 | |
| Equipment | 16000 | |
| Accounts Payable | 9500 | |
| Common stock | 25000 | |
| Dividend | 900 | |
| Service revenue | 10400 | |
| Salary expense | 2750 | |
| Miscellaneous expense | 350 | |
| 44900 | 44900 | |
| Big D Emporium | |||
| Adjusting entries as at March 31, 2017 | |||
| Date | Account Title | Debit | Credit |
| Dec.31 | Accounts Receivable | 800 | |
| Service Revenue | 800 | ||
| Dec.31 | Depreciation expense | 650 | |
| Acumulated Depreciation | 650 | ||
| Dec.31 | Insurance Expense | 200 | |
| Prepaid Insurance | 200 | ||
| Dec.31 | Salary expense | 1060 | |
| Salary payable | 1060 | ||
| Dec.31 | Supplies expense | 1220 | |
| Office supplies | 1220 | ||
| Big D Emporium | ||||||
| Trial balance as at Marc 31, 2017 | ||||||
| Unadjusted | Adjustments | Adjusted | ||||
| Debit | credit | Debit | credit | Debit | credit | |
| Cash | 12000 | 12000 | ||||
| Accounts receivable | 9000 | 800 | 9800 | |||
| Office Supplies | 1500 | 1220 | 280 | |||
| Prepaid Insurance | 2400 | 200 | 2200 | |||
| Equipment | 16000 | 16000 | ||||
| Acumulated Depreciation | 650 | 650 | ||||
| Accounts Payable | 9500 | 9500 | ||||
| Salary Payable | 1060 | 1060 | ||||
| Common stock | 25000 | 25000 | ||||
| Dividend | 900 | 900 | ||||
| Service revenue | 10400 | 800 | 11200 | |||
| Salary expense | 2750 | 1060 | 3810 | |||
| Miscellaneous expense | 350 | 350 | ||||
| Depreciation expense | 650 | 650 | ||||
| Insurance Expense | 200 | 200 | ||||
| Supplies Expense | 1220 | 1220 | ||||
| Total | 44900 | 44900 | 3930 | 3930 | 47410 | 47410 |
| Big D Emporium | ||
| Income statement | ||
| for the month ending March 31, 2017 | ||
| Service Revenue | 11200 | |
| Expenses: | ||
| Salary expense | 3810 | |
| Supplies expense | 1220 | |
| Miscellaneous expense | 350 | |
| Depreciation expense | 650 | |
| Insurance Expense | 200 | |
| Total expenses | 6230 | |
| Net income | 4970 | |
| Big D Emporium | ||
| Statement of retained earnings | ||
| for the month ending March 31, 2017 | ||
| Beginning balance | 0 | |
| Add: Net income for the month | 4970 | |
| 4970 | ||
| Less: Dividend paid | 900 | |
| Ending balance | 4070 | |
| Big D Emporium | ||
| Balance Sheet | ||
| as at March 31, 2017 | ||
| Assets | ||
| Cash | 12000 | |
| Accounts receivable | 9800 | |
| Office Supplies | 280 | |
| Prepaid Insurance | 2200 | |
| Equipment | 16000 | |
| Acumulated Depreciation | 650 | 15350 |
| Total Assets | 39630 | |
| Liabilities and equity | ||
| Accounts Payable | 9500 | |
| Salary Payable | 1060 | |
| Common stock | 25000 | |
| Retained earnings | 4070 | |
| Total liabilities and equity | 39630 | |
| CARL REDMON CONSULTING | ||
| Closing entries for the month ending March 31, 2017 | ||
| Account Title | Debit | Credit |
| Service Revenue | 11200 | |
| Salary expense | 3810 | |
| Supplies expense | 1220 | |
| Miscellaneous expense | 350 | |
| Depreciation expense | 650 | |
| Insurance Expense | 200 | |
| Income summary | 4970 | |
| (Closing the incomes and expenses to income summary) | ||
| Income summary | 4970 | |
| Retained earnings | 4970 | |
| (Closing income summary to retained earnings) | ||
| Dividends | 900 | |
| Retained earnings | 900 | |
| (Closing of dividend to retained earnings) | ||
| Big D Emporium | ||
| Trial balance as at Marc 31, 2017 | ||
| Post Closing | ||
| Debit | credit | |
| Cash | 12000 | |
| Accounts receivable | 9800 | |
| Office Supplies | 280 | |
| Prepaid Insurance | 2200 | |
| Equipment | 16000 | |
| Acumulated Depreciation | 650 | |
| Accounts Payable | 9500 | |
| Salary Payable | 1060 | |
| Common stock | 25000 | |
| Retained Earnings | 4070 | |
| Dividend | ||
| Service revenue | ||
| Salary expense | ||
| Miscellaneous expense | ||
| Depreciation expense | ||
| Insurance Expense | ||
| Supplies Expense | ||
| Total | 40280 | 40280 |