Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The trial balance of Pacilio Security Services, Inc. as of January 1, Year 8, had the following normal balances: ALREADY DONE General Journal tab -

image text in transcribedThe trial balance of Pacilio Security Services, Inc. as of January 1, Year 8, had the following normal balances:

ALREADY DONE General Journal tab - Prepare the journal entries to record transactions (1) through (18). Then prepare the necessary adjusting entries (19) through (23) to correctly report net income for the period. Then record the closing entries (24) through (26) as of December 31, Year 8.

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

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

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

NEEDS TO BE ANSWERED Statement of Changes in Stockholders' Equity tab - Prepare the statement of changes in stockholders equity for the year ended December 31, Year 8.

NEEDS TO BE ANSWERED Balance Sheet tab - Prepare a classified Balance Sheet at December 31, Year 8.

NEEDS TO BE ANSWERED Statement of Cash flows - Prepare the statement of cash flow for year ended December 31, Year 8.

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

Cash $ 93,708
Petty cash 100
Accounts receivable 22,540
Allowance for doubtful accounts 1,334
Supplies 250
Prepaid rent 3,600
Merchandise inventory (18 @ $285) 5,130
Land 4,000
Salaries payable 2,100
Common stock 50,000
Retained earnings 75,894

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

  1. Paid the salaries payable from Year 7.
  2. Purchased equipment and a van for a lump sum of $36,000 cash on January 2, Year 8. The equipment was appraised for $10,000 and the van was appraised for $30,000.
  3. Paid $9,000 on May 1, Year 8, for one years office rent in advance.
  4. Purchased $300 of supplies on account.
  5. Purchased 120 alarm systems at a cost of $280 each. Paid cash for the purchase.
  6. After numerous attempts to collect from customers, wrote off $2,350 of uncollectible accounts receivable.
  7. Sold 115 alarm systems for $580 each. All sales were on account.
  8. Record the cost of goods sold related to the sale from Event 7 using the FIFO method.
  9. Billed $86,000 of monitoring services for the year. Credit card sales amounted to $36,000, and the credit card company charged a 4 percent fee. The remaining $50,000 were sales on account.
  10. Replenished the petty cash fund on June 30. The fund had $12 cash and receipts of $45 for yard mowing, $28 for office supplies expense, and $11 for miscellaneous expenses.
  11. Collected the amount due from the credit card company.
  12. Paid installers and other employees a total of $52,000 cash for salaries.
  13. Collected $115,500 of accounts receivable during the year.
  14. Paid $12,500 of advertising expense during the year.
  15. Paid $6,800 of utilities expense for the year.
  16. Sold the land, which was purchased in 2011, for $12,000.
  17. Paid the accounts payable.
  18. Paid a dividend of $10,000 to the shareholders.

Adjustments

  1. Determined that $180 of supplies were on hand at the end of the year.
  2. Recognized the expired rent for both the old van and the office building for the year. The lease on the van was not renewed. Rent paid on March 1, Year 7, for the van was $4,800.
  3. Recognized uncollectible accounts expense for the year using the allowance method. Pacilio estimates that 3 percent of sales on account will not be collected.
  4. Recognized depreciation expense on the equipment and the van. The equipment has a five-year life and a $2,000 salvage value. The van has a four-year life and a $6,000 salvage value. The company uses double-declining-balance for the van and straight-line for the equipment.
  5. Accrued salaries at December 31, Year 8, were $1,500.
  6. Record the closing entry for the revenue accounts.
  7. Record the closing entry for the expense accounts.
  8. Record the closing entry for dividends account.
Requirement General Journal General Ledger Income Trial Balance: Statement changes in SE Balance Sheet Statement of CF Analysis The ending balance values from the General Ledger tab flows through to the Trial Balance below. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Year 2018 represents Year 7 from the problem statement. Adjusted Pacilio Security Services, Inc. Trial Balance December 31, 2020 Account Title Credit Debit 93,708 100 22,540 1,334 Cash Petty cash Accounts receivable Allowance for doubtful accounts Merchandise inventory Supplies Prepaid rent Land Salaries payable Common stock Retained earnings Total 5,130 250 3,600 4,000 2,100 50,000 75,894 129,328 $ 129,328 $ Requirement General Journal General Ledger Income Trial Balance: Statement changes in SE Balance Sheet Statement of CF Analysis The ending balance values from the General Ledger tab flows through to the Trial Balance below. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Year 2018 represents Year 7 from the problem statement. Adjusted Pacilio Security Services, Inc. Trial Balance December 31, 2020 Account Title Credit Debit 93,708 100 22,540 1,334 Cash Petty cash Accounts receivable Allowance for doubtful accounts Merchandise inventory Supplies Prepaid rent Land Salaries payable Common stock Retained earnings Total 5,130 250 3,600 4,000 2,100 50,000 75,894 129,328 $ 129,328 $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting

Authors: John Hoggett, Lew Edwards, John Medlin

6th Edition

0470806583, 978-0470806586

More Books

Students also viewed these Accounting questions

Question

=+b) State the hypotheses.

Answered: 1 week ago

Question

CL I P COL Astro- L(1-cas0) Lsing *A=2 L sin(0/2)

Answered: 1 week ago