Prepare the requirements below using Excel.

Required:

Prepare the journal entries to record iransactions $(1)$ through $(16).$ Then prepare the neosssa adjusting entries $(17)$ through $(20)$ to correctly report net income for the period.

Post each journal entry to T$-$accounts in the general iedger.

Prepare a $|$rial balance;

Prepare a multiple$-$siep income statement for the year ended December $31,2014.$

Prepare the statement of changes in stockholders' equity for the year ended December $31\mathrm{.}20$

Prepare a balance sheet at December $31,2014.$

Prepare the statement of cash flows for year ended December $31,2014.$

Record the closing entries as of December $31,2014,$ in the general joumal.

Post each closing entry to T$-$accounts in the general ledger.

Prepare a post$-$closing trial balance.

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

Cash

$$14,520$

Accounts Receivabie

$2,960$

Supplies

$320$

Prepaid Rent

$1,040$

Land

Uneamed Revenue

$3,280$

$1,080$

Salaries Payable

In $2014.$ Pacio Security Services decided to expand its business to sell secunty systems and offer $24-$hour alarm moniloring services, It plans to phase out its current service of providing security personnel at various events. The following summary transactions occurred during $2014.$

Paid the salaries payable from $2013.$

Acquired an additional $$9,000$ cash from the issue of common stack.

Rented a larger building on May $1$: paid $$24,400$ for $12$ months' rent in advance.

Paid $$800$ cash for supplies to be used over the next several months by the business.

Purchased $40$ alarm systems for resale at a cost of $$240$ each. The alarm systems were purchased on account with the terms $\frac{1}{15},\frac{n}{30}.$

Rctumed three of the alarm systems that each had a cost of $5240.$ Instalied $32$ alarm systems during the year at a price to customers of $7.$ $$550$ each. The cost of these systems was $$240$ each. Sales on account were $$13,200,$ and cash sales were $$4,400.$

Paid the installers and alher employees a total of $$10,100$ in salaries.

Sold $$38,900$ of monitaring services for the year, The services were billed to customers.

Paid cash on accounts payable of $$5,760$ less applicable discount, since

the payment was made before the discount period expired. Purchase terms were $\frac{1}{15},\frac{n}{30}.$

Paid cash to settle an additional $$1,920$ of accounts payable after the discount period expired.

Collected $$35,100$ of accounts receivable during the year.

Performed $$10,200$ of security scrvices for area events; $$6,120$ was on account and $$4,080$ was for cash.

Paid advertising cost of $$1,900$ for the year.

Paid $$1,100$ for utilities expense for the year.

Paid a dividend of $$13,800$ to the shareholders.

Adjustment Information:

$17.$ Supplies of $$100$ were on hand at the end of the year.

$18.$ Recognized the expired rent for the year.

$19.$ Recognized the balance of the unearned revenue; cash was received in $2013.$

$20.$ Accrued salaries at December $31,2014,$ were $$1,400.$

$1,080$

Common Stock

$6,800$

Retained Earnings

$13,160$