Question

The trial balance of Pacilio Security Services, Inc. as of January 1, Year 5, had the following normal balances:

Cash	$	62,860
Accounts receivable		20,500
Supplies		150
Prepaid rent		2,000
Merchandise inventory (9 @ $240)		2,160
Land		4,000
Accounts payable		980
Salaries payable		1,500
Common stock		50,000
Retained earnings		39,190

During Year 5, Pacilio Security Services experienced the following transactions:

1. Paid the salaries payable from Year 4.
2. On January 15, purchased 20 standard alarm systems for cash at a cost of $250 each.
3. On February 1, paid the accounts payable of $980, but not within the discount period. (The company uses the gross method.)
4. On March 1, leased a business van. Paid $4,800 for one year’s lease in advance.
5. Paid $7,200 on May 1 for one year’s rent on the office in advance.
6. Purchased with cash $500 of supplies to be used over the next several months by the business.
7. Purchased with cash another 25 alarm systems on August 1 for resale at a cost of $260 each.
8. On September 5, purchased on account 30 standard alarm systems at a cost of $265.
9. Installed 60 standard alarm systems for $33,000. Sales of $22,000 were on account, while $11,000 were cash sales.
10. Record the cost of goods sold related to the sale from Event 9 using the perpetual FIFO method.
11. Made a full refund to a dissatisfied customer who returned her alarm system. The sale had been a cash sale for $550 with a cost of $260. Record the reversal of revenue.
12. Made a full refund to a dissatisfied customer who returned her alarm system. The sale had been a cash sale for $550 with a cost of $260. Record the reversal of cost.
13. Paid installers and other employees a total of $21,000 cash for salaries.
14. Sold $45,000 of monitoring services during the year. The services are billed to the customers each month.
15. Sold an additional monitoring service for $1,200 for one year’s service. The customer paid the full amount of $1,200 on October 1.
16. Collected $74,000 of accounts receivable during the year.
17. Paid an additional $6,000 to settle some of the accounts payable.
18. Paid $3,500 of advertising expense during the year.
19. Paid $2,320 of utilities expense for the year.
20. Paid a dividend of $15,000 to the shareholders.

Adjustments

21. There was $200 of supplies on hand at the end of the year.
22. Recognized the expired rent from the prior year, van and office building for the year.
23. Recognized the revenue earned from transaction 15.
24. Accrued salaries at December 31, Year 5, were $1,000

General Journal tab - Prepare the journal entries to record transactions (1) through (20). Then prepare the necessary adjusting entries (21) through (24) to correctly report net income for the period. Then record the closing entries (25) through (27) as of December 31, Year 5.

General Ledger tab - Each journal entry is posted automatically to the general ledger.

Trial Balance tab - The ending balance values from the General Ledger tab flows through to the Trial Balance tab.

Income Statement tab - Use the drop-down to select the accounts properly included on the income statement.

Statement of Changes in Stockholders' Equity tab - Prepare the statement of changes in stockholders’ equity for the year ended December 31, Year 5.

Balance Sheet tab - Prepare a classified Balance Sheet at December 31, Year 5.

Statement of Cash flows - Prepare the statement of cash flow for year ended December 31, Year 5.

Analysis tab - Use a horizontal statements model to show how each transaction affects the balance sheet, income statement, and statement of cash flows.

Answer 1

Please find the below spreadsheet useful to get the desired results: -

Journal

Pacilio Security Services, Inc.
Event	Account Titles	Debit	Credit
1	Salaries Payable	$   1,500.00
	Cash		$   1,500.00
2	Merchandise Inventory	$   5,000.00
	Cash		$   5,000.00
3	Accounts payable	$      980.00
	Interest Expense	$        20.00
	Cash		$   1,000.00
4	Prepaid Rent	$   4,800.00
	Cash		$   4,800.00
5	Prepaid Rent (office)	$   7,200.00
	Cash		$   7,200.00
6	Supplies	$      500.00
	Cash		$      500.00
7	Merchandise Inventory	$   6,500.00
	Cash		$   6,500.00
8	Merchandise Inventory	$   7,950.00
	Accounts Payable		$   7,950.00
9a	Accounts Receivable	$ 22,000.00
	Cash	$ 11,000.00
	Alarm Sales		$ 33,000.00
9b	Cost of Goods Sold1	$ 15,250.00
	Merchandise Inventory		$ 15,250.00
10a	Alarm Sales	$      550.00
	Cash		$      550.00
10b	Merchandise Inventory	$      260.00
	Cost of Goods sales		$      260.00
11	Salaries Expense	$ 21,000.00
	Cash		$ 21,000.00
12	Accounts receivable	$ 45,000.00
	Monitoring Service Revenue		$ 45,000.00
13	Cash	$   1,200.00
	Unearned Revenue		$   1,200.00
14	Cash	$ 74,000.00
	Accounts receivable		$ 74,000.00
15	Accounts payable	$   6,000.00
	Cash		$   6,000.00
16	Advertising Expense	$   3,500.00
	Cash		$   3,500.00
17	Utilities Expense	$   2,300.00
	Cash		$   2,300.00
18	Dividends	$ 15,000.00
	Cash		$ 15,000.00
19	Supplies Expense (150+500-200)	$      450.00
	Supplies		$      450.00
20	Rent Expense2	$ 10,800.00
	Prepaid Rent		$ 10,800.00
21	Unearned Revenue3	$      300.00
	Monitoring Service Revenue		$      300.00
22	Salaries Expense	$   1,000.00
	Salaries Payable		$   1,000.00

COGS
$                                   9.00	$      240.00	$   2,160.00
$                                 20.00	$      250.00	$   5,000.00
$                                 25.00	$      260.00	$   6,500.00
$                                   6.00	$      265.00	$   1,590.00
		$ 15,250.00
Expired Van Lease Paid	$   4,000.00
Office:
Expired rent paid in Year 4	$   2,000.00
Expired rent paid in Year 5	$   4,800.00
Total Rent Expense	$ 10,800.00
Unearned Revenue Collected	$      300.00