In: Accounting
The trial balance for a company that sells alarms, as of January 1, 2016 had the following balances:
Cash 74,000
Accounts receivable 13,000
Supplies 200
Prepaid rent 3,200
Merchandise inventory (24 @ $200; 1 @ $200) 5,000
Land 4000
Accounts payable 1,900
Unearned revenue 900
Salaries payable 1,000
Common stock 50,000
Retained earnings 47,000
The following transactions took place during 2016:
1. Paid the salaries payable from 2015.
2. Paid $4,800 on May 1, 2016, for one year's lease on the company van in advance.
3. Paid $7,200 on May 2, 2016 for one year's office rent in advance.
4. Purchased $400 of supplies on account.
5. Purchased 100 alarm systems for $28,000 cash during the year.
6. Sold 102 alarm systems for $57,000. All sales were on account.
(Compute cost of goods sold using the FIFO cost flow method)
7. Paid $2,100 on accounts payable during the year.
8. Billed $52,000 of monitoring services for the year.
9. Paid installers and other employees a total of $25,000 cash for salaries.
10. Collected $89,000 of accounts receivable during the year.
11. Paid $3,600 of advertising expense during the year.
12. Paid $2,500 of utilities expense for the year.
13. Paid a dividend of $10,000 to the shareholders.
Required:
1. Prepare the trial balance as at Dec 31, 2016 for the company
2. Prepare the income statement and balance sheet for the company.
Trial Balance | ||
Dr | Cr | |
Cash (74000-1000-4800-7200-28000-2100-25000-3600-2500-10000+89000) | $78,800 | |
Accounts receivable (13000+57000+52000-89000) | $33,000 | |
Supplies | 600 | |
Prepaid Rent | $15,200 | |
Inventory (5000+28000-26560) | 6440 | |
Land | 4000 | |
Accounts payable (1900+400-2100) | 200 | |
Unearned Revenue | 900 | |
Salaries Payable | 0 | |
Common Stock | 50000 | |
Retained Earnings | 47000 | |
dividend | 10000 | |
Sales | $57,000 | |
Service revnue | $52,000 | |
Cost of good sold | $26,560 | |
Salaries expenses | $25,000 | |
Advertising expenses | $3,600 | |
Utilities expernses | $2,500 | |
Total | $205,700 | $207,100 |
Income statement | ||
Sales | $57,000 | |
Service revnue | $52,000 | |
Total revenue | $109,000 | |
Expenses | ||
Cost of good sold | $26,560 | |
Salaries expenses | $25,000 | |
Advertising expenses | $3,600 | |
Utilities expernses | $2,500 | |
Total expenses | $57,660 | |
Net Income | $51,340 | |
Statement of Retained Earnings | ||
Beginning Balance | $47,000 | |
Add: Net income | 51340 | |
Less: dividend | -10000 | |
Ending Balance | $88,340 | |
Balance sheet | ||
For the year ending 31st December 2016 | ||
Current assets | ||
Cash | $78,800 | |
Accounts Receivable | $33,000 | |
Supplies | $600 | |
Prepaid Rent | $15,200 | |
Invemtory | $6,440 | |
Total current assets | $134,040 | |
Land | 4000 | |
Total assets | $138,040 | |
Liabilities & stockholder equity | ||
Current liabilities | ||
Accounts payable | 200 | |
Unearned Revenue | 900 | |
Total Current liabilities | 1100 | |
stockholder equity | ||
common stock | 50000 | |
Retained earnings | $88,340 | |
Total stockholder equity | 138340 | |
Total Liabilities & stockholder equity | 139440 |
working | |||
Date | Accounts title | Dr | Cr |
1 | Salaries payable | $1,000 | |
Cash | $1,000 | ||
2 | Prepaid rent | $4,800 | |
Cash | $4,800 | ||
3 | Prepaid rent | $7,200 | |
Cash | $7,200 | ||
4 | Supplies | $400 | |
Accounts payable | $400 | ||
5 | Inventory | $28,000 | |
Cash | $28,000 | ||
6 | Accounts receivable | $57,000 | |
Sales | $57,000 | ||
Cost of good sold | 26560 | ||
mercandise Inventory (200*25)+(77*280) | $26,560 | ||
7 | Accounts payable | $2,100 | |
Cash | $2,100 | ||
8 | Accounts receivable | $52,000 | |
Service Revenue | $52,000 | ||
9 | Salaries expenses | $25,000 | |
Cash | $25,000 | ||
10 | Cash | $89,000 | |
Accounts receivable | $89,000 | ||
11 | Advertising expenses | $3,600 | |
Cash | $3,600 | ||
12 | Utilities expernses | $2,500 | |
Cash | $2,500 | ||
13 | Dividend | $10,000 | |
Cash | $10,000 |