Answered step by step
Verified Expert Solution
Question
1 Approved Answer
income statement only! The trial balance of Pacilio Security Services, Inc. as of January 1, Year 9, had the following normal balances: Cash Petty cash
income statement only!
The trial balance of Pacilio Security Services, Inc. as of January 1, Year 9, had the following normal balances: Cash Petty cash Accounts receivable Allowance for doubtful accounts Supplies Prepaid rent Merchandise inventory (23e $280) Equipment Van Accumulated depreciation Salaries payable Common stock Retained earnings $93,380 100 21,390 2,485 180 3,000 6,440 9,000 27,000 14,900 1,500 50,000 91,605 During Year 9, Pacilio Security Services experienced the following transactions: 1. Paid the salaries payable from Year 8. 2. Paid $9,000 on May 2, Year 9, for one year's office rent in advance. 3. Purchased $425 of supplies on account. 4. Purchased 145 alarm systems at a cost of $290 each. Paid cash for the purchase.. 5. After numerous attempts to collect from customers, wrote off $2,060 of uncollectible accounts receivable. 6. Sold 130 alarm systems for $580 each plus sales tax of 5 percent. All sales were on account. (Be sure to compute cost of goods sold using the FIFO cost flow method.) 7. Record the cost of goods sold related to the sale from Event 6 using the FIFO method. 8. Billed $107.000 of monitoring services for the year. Credit card sales amounted to $42,000, and the credit card company charged a 4 percent fee. The remaining $65,000 were sales on account Sales tax is not charged on this service. 9. Replenished the petty cash fund on June 30. The fund had $5 cash and has receipts of $60 for yard mowing. $15 for office supplies expense, and $17 for miscellaneous expenses 10. Collected the amount due from the credit card company, 11. Paid the sales tax collected on $69,600 of the alarm sales. 12. Paid installers and other employees a total of $65.000 for salaries for the year. Assume the Social Security tax rate is 6 percent and the Medicare tax rate is 1.5 percent. Federal income taxes withheld amounted to $7,500. Cash was paid for the net amount of salaries due. 13. Pacilio now offers a one-year warranty on its alarm systems. Paid $1,950 in warranty repairs during the year. 14. On September 1, borrowed $12.000 from State Bank. The note had an 8 percent interest rate and a one-vear term to maturity. 15. Collected $136,100 of accounts receivable during the year. 16. Paid $15.000 of advertising expense during the year. 17. Paid $7,200 of utilities expense for the year. 18. Paid $7,000 of the Federal Income Tax Payable, $3,600 of the FICA Tax - Soc. Sec. Tax Payable and $900 of the FICA Tax - Medicare Tax Payable. Also, paid the Payroll Tax Expense for the 7.5% employer matching of FICA taxes on $60,000 of salaries. 19. Paid the accounts payable. 20. Paid a dividend of $10,000 to the shareholders. Adjustments 20. There was $165 of supplies on hand at the end of the year. 21. Recognized the expired rent for the office building for the year. 22. Recognized uncollectible accounts expense for the year using the allowance method. The company revised its estimate of uncollectible accounts based on prior years' experience. This year, Pacilio estimates that 275 percent of sales on account will not be collected 23. Recognized depreciation expense on the equipment and the van. The equipment has a five-year life and a $2,000 salvage value. The von 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. (A full year's depreciation was taken in Year 8. the year of acquisition.) 24. The alarm systems sold in transaction 6 were covered with a one-year warranty. Pacilio estimated that the warranty cost would be 3 percent of alarm sales. 25. Recognized the accrued interest on the note payable at December 31, Year 9. 26. The unemployment tax on salaries has not been paid. Recorded the accrued unemployment tax on the salaries for the year. The unemployment tax rate is 4.5 percent ($14.000 of salaries is subject to this tax.) 27. Recognized the employer Social Security and Medicare payroll tax that has not been paid on $5,000 of salaries expense. Requirement General Journal General Ledger Changes in Trial Balance Income Statement Balance Sheet SE Statement of CF Analysis General Journal tab - Prepare the journal entries to record transactions (1) through (20). Then prepare the necessary adjusting entries (21) through (28) to correctly report net income for the period. Then record the closing entries (29) through (31) as of December 31, Year 9. 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 9. Balance Sheet tab - Prepare a classified Balance Sheet at December 31, Year 9. Statement of Cash flows - Prepare the statement of cash flow for year ended December 31, Year 9. Analysis tab - Use a horizontal statements model to show how each transaction affects the balance sheet, income statement, and statement of cash flows. 1 Paid the salaries payable from Year 8. 2 Paid $9,000 on May 2, Year 9, for one year's office rent in advance. 3 Purchased $425 of supplies on account. 4 Purchased 145 alarm systems at a cost of $290 each. Paid cash for the purchase. 5 After numerous attempts to collect from customers, wrote off $2,060 of uncollectible accounts receivable. 6 Sold 130 alarm systems for $580 each plus sales tax of 5 percent. All sales were on account. 7 Record the cost of goods sold related to the sale from Event 6 using the FIFO method. 8 Billed $107,000 of monitoring services for the year. Credit card sales amounted to $42,000, and the credit card company charged a 4 percent fee. The remaining $65,000 were sales on account. Sales tax is not charged on this service. 9 Replenished the petty cash fund on June 30. The fund had $5 cash and has receipts of $60 for yard mowing, $15 for office supplies expense, and $17 for miscellaneous expenses. 10 Collected the amount due from the credit card company. 11 Paid the sales tax collected on $69,600 of the alarm sales. 12 Paid installers and other employees a total of $65,000 for salaries for the year. Assume the Social Security tax rate is 6 percent and the Medicare tax rate is 1.5 percent. Federal income taxes withheld amounted to $7,500. Cash was paid for the net amount of salaries due. 13 Pacilio now offers a one-year warranty on its alarm systems. Paid $1,950 in warranty repairs during the year. 14 On September 1, borrowed $12,000 from State Bank. The note had an 8 percent interest rate and a one-year term to maturity. 15 Collected $136,100 of accounts receivable during the year. 16 Paid $15,000 of advertising expense during the year. 17 Paid $7,200 of utilities expense for the year. 18 Paid $7,000 of the Federal Income Tax Payable, $3,600 of the FICA Tax - Soc. Sec. Tax Payable and $900 of the FICA Tax - Medicare Tax Payable. Also, paid the Payroll Tax Expense for the 7.5% employer matching of FICA taxes on $60,000 of salaries. 19 Paid the accounts payable. 20 Paid a dividend of $10,000 to the shareholders. 21 There was $165 of supplies on hand at the end of the year. Prepare the adjusting journal entry, if necessary. 22 Recognized the expired rent for the office building for the year. Prepare the adjusting journal entry, if necessary. 23 Recognized uncollectible accounts expense for the year using the allowance method. The company revised its estimate of uncollectible accounts based on prior years' experience. This year, Pacilio estimates that 2.75 percent of sales on account will not be collected. Prepare the adjusting journal entry, if necessary. 24 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. (A full year's depreciation was taken in Year 8, the year of acquisition.) Prepare the adjusting journal entry, if necessary. 25 The alarm systems sold in transaction 6 were covered with a one-year warranty. Pacilio estimated that the warranty cost would be 3 percent of alarm sales. Prepare the adjusting journal entry, if necessary. 1 26 Recognized the accrued interest on the note payable at December 31, Year 9. Prepare the adjusting journal entry, if necessary. 27 The unemployment tax on salaries has not been paid. Recorded the accrued unemployment tax on the salaries for the year. The unemployment tax rate is 4.5 percent. ($14,000 of salaries is subject to this tax.) Prepare the adjusting journal entry, if necessary. 28 Recognized the employer Social Security and Medicare payroll tax that has not been paid on $5,000 of salaries expense. Prepare the adjusting journal entry, if necessary. 29 Record the closing entry for the revenue accounts. 30 Record the closing entry for the expense accounts. 31 Record the closing entry for dividends account. Post-closing Pacilio Security Services, Inc. Income Statement For the Year Ended December 31, Year 9 Revenues Cash $ 122,475 Accounts receivable 27,400 Supplies 165 Total Revenues $ Cost of goods sold 150,040 (37,470) 112,570 Expenses Total Operating Expenses Net Operating Income Non-Operating Items 112,570 $ 112,570 (Trial Balance Changes in SE > Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started