Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please help me fix what I have missed or what is wrong please. The trial balance of Pacilio Security Services, Inc. as of
Can you please help me fix what I have missed or what is wrong please.
The trial balance of Pacilio Security Services, Inc. as of January 1, Year 11, had the following normal balances: Cash Petty cash Accounts receivable Allowance for doubtful accounts Supplies Merchandise inventory (48 @ $300) Equipment Van Building Accumulated depreciation Land Sales tax payable Employee income tax payable FICA-Social Security tax payable FICA-Medicare tax payable Warranty payable Unemployment tax payable Notes payable-Building Bonds payable Discount on bonds payable Common stock Retained earnings $113,718 100 39,390 4,662 210 14,400 9,000 27,000 125,000 28,075 25,000 390 1,000 840 210 918 945 92,762 50,000 800 50,000 124,816 During Year 11, Pacilio Security Services experienced the following transactions: 1. Paid the sales tax payable from Year 10. Prev 1 of 1 Next During Year 11, Pacilio Security Services experienced the following transactions: 1. Paid the sales tax payable from Year 10. 2. Paid the balance of the payroll liabilities due for Year 10 (federal income tax, FICA taxes, and unemployment taxes). 3. Issued 5,000 additional shares of the $5 par value common stock for $8 per share. 4. Issued 1,000 shares of $50 stated value, 5 percent cumulative preferred stock for $52 per share. 5. Purchased $500 of supplies on account. 6. Purchased 190 alarm systems at a cost of $310. Cash was paid for the purchase. 7. After numerous attempts to collect from customers, wrote off $3,670 of uncollectible accounts receivable. 8. Sold 210 alarm systems for $600 each plus sales tax of 5 percent. All sales were on account. 9. Record the cost of goods sold related to the sale from Event 8 using the FIFO method. 10. Billed $125,000 of monitoring services for the year. Credit card sales amounted to $58,000, and the credit card company charged a 4 percent fee. The remaining $67,000 were sales on account. Sales tax is not charged on this service. 11. Replenished the petty cash fund on June 30. The fund had $10 cash and receipts of $75 for yard mowing and $15 for office supplies expense. 12. Collected the amount due from the credit card company. 13. Paid the sales tax collected on $105,000 of the alarm sales. 14. Collected $198,000 of accounts receivable during the year. 15. Paid installers and other employees a total of $96,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 $10,600. No employee exceeded $110,000 in total wages. The net salaries were paid in cash. 16. On October 1, declared a dividend on the preferred stock and a $1 per share dividend on the common stock to be paid to shareholders of record on October 15, payable on November 1, Year 11. 17. Paid $1,625 in warranty repairs during the year. 18. On November 1, Year 11, paid the dividends that had been previously declared. 19. Paid $18,500 of advertising expense during the year. 20. Paid $6,100 of utilities expense for the year. 21. Paid $9,200 of the Employee Income Tax Payable, $5,280 of the FICA Tax Soc. Sec. Tax Payable and $1,320 of the FICA Tax - Medicare Tax Payable. Also, paid the Payroll Tax Expense for the 7.5% employer matching of FICA taxes on $88,000 of salaries. 22. Paid the accounts payable. Prev 1 of 1 Next BE 14. Collected $198,000 of accounts receivable during the year. 15. Paid installers and other employees a total of $96,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 $10,600. No employee exceeded $110,000 in total wages. The net salaries were paid in cash. 16. On October 1, declared a dividend on the preferred stock and a $1 per share dividend on the common stock to be paid to shareholders of record on October 15, payable on November 1, Year 11. 17. Paid $1,625 in warranty repairs during the year. 18. On November 1, Year 11, paid the dividends that had been previously declared. 19. Paid $18,500 of advertising expense during the year. 20. Paid $6,100 of utilities expense for the year. 21. Paid $9,200 of the Employee Income Tax Payable, $5,280 of the FICA Tax - Soc. Sec. Tax Payable and $1,320 of the FICA Tax - Medicare Tax Payable. Also, paid the Payroll Tax Expense for the 7.5% employer matching of FICA taxes on $88,000 of salaries. 22. Paid the accounts payable. 23. Paid bond interest and amortized the discount. The bond was issued in Year 10 and pays interest at 6 percent. 24. Paid the annual installment of $14,238 on the amortized note. The interest rate for the note is 7 percent. Adjustment 25. There was $190 of supplies on hand at the end of the year. 26. Recognized the uncollectible accounts expense for the year using the allowance method. Pacilio now estimates that 1 percent of sales on account will not be collected. 27. Recognized depreciation expense on the equipment, van, and building. The equipment, purchased in Year 8, 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 building has a 40-year life and a $10,000 salvage value. The company uses straight-line for the equipment and the building. The van is fully depreciated. 28. The alarm systems sold in transaction 7 were covered with a one-year warranty. Pacilio estimated that the warranty cost would be 2 percent of alarm sales. 29. The unemployment tax on the three employees has not been paid. Record the accrued unemployment tax on the salaries for the year. The unemployment tax rate is 4.5 percent and gross wages for all three employees exceeded $7,000. 30. Recognized the employer Social Security and Medicare payroll tax that has not been paid on $8,000 of salaries expense. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement of CF Analysis General Journal tab - Prepare the journal entries to record transactions (1) through (24). Then prepare the necessary adjusting entries (25) through (30) to correctly report net income for the period. Then record the closing entries (31) through (33) as of December 31, Year 11. 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. Balance Sheet tab - Prepare a classified Balance Sheet at December 31, Year 11. Statement of Cash flows - Prepare the statement of cash flow for year ended December 31, Year 11. Analysis tab - Use a horizontal statements model to show how each transaction affects the balance sheet, income statement, and statement of cash flows. Requirement General Journal > W Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement of CF Analysis Prepare the journal entries to record transactions (1) through (24). Then prepare the necessary adjusting entries (25) through (30) to correctly report net income for the period. Then record the closing entries (31) through (33) as of December 31, Year 11. (If no entry is required for a transaction, select "No journal entry required in the first account field. Round final answers to the nearest whole dollars.) Show less View transaction list View journal entry worksheet No Date General Journal Debit Credit 1 Dec 31 Sales tax payable 390 Cash 390 2 Dec 31 1,000 840 Employee income tax payable FICA - Social security tax payable FICA - Medicare tax payable Unemployment tax payable Cash 210 945 2,995 3 Dec 31 Cash 40,000 Common stock 25,000 Paid-in capital in excess of par value, Common stock 15,000 Prev 1 of 1 Next 4 Dec 31 Cash 52,000 Preferred stock Paid-in capital in excess of par value, Preferred stock 50,000 2,000 5 Dec 31 Supplies Accounts payable 500 500 6 Dec 31 Merchandise inventory Cash 58,900 58,900 7 Dec 31 Allowance for doubtful accounts 3,670 Accounts receivable 3,670 8 Dec 31 Accounts receivable 132,300 Alarm sales Sales tax payable 126,000 6,300 9 Dec 31 64,620 Cost of goods sold Merchandise inventory 64,620 10 Dec 31 Accounts receivable - Credit card Accounts receivable 55,680 67,000 2,320 Credit card expense Security service revenue 125.000 BOR Prev 1 of 1 Next J 11 Jun 30 Supplies expense Maintenance expense 15 75 Cash 90 12 Dec 31 Cash 55,680 Accounts receivable - Credit card LIE Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement of CF Analysis Each journal entry is posted automatically to the general ledger. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Post-closing General Ledger Account Cash Petty cash No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 Jun 30 Jan 01 100 11 90 18 Nov 01 17,500 390 1 Dec 31 Dec 31 2 2,995 3 Dec 31 40,000 52,000 4 Dec 31 6 Dec 31 58,900 113,718 113,628 96,128 95,738 92,743 132,743 184,743 125,843 181,523 176,273 374,273 296,073 294,448 275,948 269,848 247,448 12 Dec 31 55,680 13 5,250 Dec 31 Dec 31 14 198,000 15 Dec 31 17 Dec 31 19 20 Dec 31 Dec 31 78,200 1,625 18,500 6,100 22,400 21 Dec 31 Proly 1 of 1 Next General Ledger Account Cash No. Date Debit Petty cash Credit Balance Jan 01 No. Date Debit Credit Balance 11 Jun 30 Jan 01 90 100 18 Nov 01 17,500 1 Dec 31 390 2. Dec 31 2,995 3 Dec 31 4 Dec 31 40,000 52,000 6 Dec 31 58,900 12 Dec 31 55,680 13 Dec 31 5,250 113,718 113,628 96,128 95,738 92,743 132,743 184,743 125,843 181,523 176,273 374,273 296,073 294,448 275,948 269,848 247 448 246,948 243,948 229,710 14 198,000 15 17 19 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 20 21 78,200 1,625 18,500 6.100 22,400 500 3,000 14,238 22 23 Dec 31 24 Dec 31 Accounts receivable - Credit card Accounts receivable No. Date Debit Credit Balance No. Date Debit Credit 0 Jan 01 Dec 31 Jan 01 Dec 31 10 55,680 Balance 39,390 35,720 16802 55,680 7 3,670 12 Der 31 55 680 8 Der 31 132 300 Prey 1 of 1 Next Accounts receivable - Credit card No. Date Accounts receivable Debit Credit Balance Jan 01 No. Date Debit Credit Balance 0 10 Dec 31 Dec 31 55,680 Jan 01 Dec 31 7 55,680 0 12 3,670 55,680 8 Dec 31 132,300 67,000 39,390 35,720 168,020 235,020 37,020 10 Dec 31 Dec 31 14 198,000 Allowance for doubtful accounts Merchandise inventory No. Date Debit Credit No. Date Balance 4,662 Debit Credit Jan 01 Jan 01 7 Dec 31 3,670 992 6 Dec 31 Balance 14,400 73,300 8,680 58,900 26 Dec 31 1,993 2,985 9 Dec 31 64,620 Supplies Van No. Date Debit Credit Balance No. Date Debit Credit Jan 01 210 Balance 27,000 Jan 01 5 Dec 31 500 710 25 Dec 31 520 190 Equipment Accumulated depreciation No. Date Debit Credit Balance No. Date Debit Credit Jan 01 9.000 Balance 28,075 29,475 32,350 Jan 01 Dec 31 Dec 31 27 1,400 2,875 27 Building Land No. Debit Date Credit Balance No. Debit Date Balance Credit HI Prey. 1 of 1 Next ", 27 Dec 31 2,875 32,350 Building No. Date Land Debit Credit Balance Jan 01 No. Date Debit Credit 125,000 Jan 01 Balance 25,000 Accounts payable No. Warranty payable Debit Date Jan 01 Credit Balance No. Debit Credit Balance 0 5 Dec 31 Date Jan 01 Dec 31 500 500 17 22 Dec 31 1,625 500 918 (707) 1,813 0 28 Dec 31 2,520 Unemployment tax payable No. Debit Credit Date Jan 01 Sales tax payable Debit Credit Balance No. Date Balance 945 2 390 Dec 31 945 0 1 Jan 01 Dec 31 Dec 31 390 0 29 Dec 31 945 945 8 6,300 13 Dec 31 5,250 6,300 1,050 Dividends payable Debit Credit Employee income tax payable No. Date Balance No. Date Debit Credit Jan 01 Jan 01 16 Oct 01 17,500 17,500 2 1,000 Balance 1,000 0 10,600 1,400 18 Nov 01 17.500 0 Dec 31 Dec 31 Dec 31 15 10,600 21 9,200 FICA-Medicare tax payable FICA - Social security tax payable No. Date Debit Credit Balance No. Date Debit Credit Balance Tan 040 FICA - Medicare tax payable No. Date Debit Credit No. Balance 210 Jan 01 Dec 31 Date FICA - Social security tax payable Debit Credit Jan 01 2 Balance 840 210 0 Dec 31 2 Dec 31 840 15 21 1,440 Dec 31 15 Dec 31 1,320 5,760 1,440 120 240 ol 5,760 480 30 Dec 31 21 Dec 31 5,280 120 30 Dec 31 480 960 Notes payable Debit Credit No. Bonds payable Date Balance No. Date Jan 01 Debit Credit Balance Jan 01 24 Dec 31 7,745 92,762 85,017 50,000 Discount on bonds payable Debit Credit Common stock No. Date Balance No Debit Credit Jan 01 800 Date Jan 01 Dec 31 23 Dec 31 Balance 50,000 75,000 200 600 3 25,000 Preferred stock Paid-in capital in excess of par value, Common stock No. Date Debit Credit Balance Jan 01 0 3 Dec 31 15,000 15,000 No. Date Debit Credit Jan 01 Dec 31 Balance 0 50,000 4 50,000 Paid-in capital in excess of par value, Preferred stock Retained earnings Debit Credit No. Date Debit Credit Balance No. Date 0 Jan 01 Jan 01 Dec 31 4 2,000 2,000 31 Balance 124,816 375,816 161,040 Dec 31 Dec 31 251,000 32 214,776 Prey 1 of 1 Next Dec 31 214,776 Dividends 161,040 No. Date Debit Credit Balance Security service revenue Debit Credit Jan 01 No. Date 16 Balance Oct 01 0 17,500 17,500 10 Dec 31 125,000 31 Dec 31 125,000 125,000 0 Monitoring service revenue Debit Credit No. Date Alarm sales Balance No Jan 01 Debit Credit Balance 31 Dec 31 Date Jan 01 Dec 31 126,000 0 (126,000) 8 126,000 126,000 Advertising expense Debit Credit No. Date Balance Cost of goods sold Debit No. Date Jan 01 Credit Balance 19 18,500 0 18,500 Dec 31 Dec 31 0 9 Jan 01 Dec 31 Dec 31 32 64,620 64,620 18,500 32 64,620 0 Depreciation expense No. Date Debit Supplies expense Credit Credit Balance No. Date Debit Balance 0 0 27 27 11 Jan 01 Dec 31 Dec 31 Dec 31 Jan 01 Jun 30 1,400 2,875 1,400 4,275 0 15 520 25 32 Dec 31 Dec 31 15 535 32 4,275 520 15 Salaries expense Debit Credit Payroll tax expense Debit Credit No. Date Balance No. Balance Date lan 01 lan 01 ol Prey 1 of 1 PA Next Salaries expense No. Payroll tax expense Date Debit Credit Balance No. Debit Credit Balance 0 15 Jan 01 Dec 31 Dec 31 96,000 0 96,000 21 32 6,600 96,000 Date Jan 01 Dec 31 Dec 31 Dec 31 Dec 31 0 29 945 30 6,600 7,545 8,145 0 600 32 8,145 Interest expense Office supplies expense No. Date Debit Credit Balance No. Date Debit Credit Balance 0 Jan 01 0 23 3,200 32 Jan 01 Dec 31 Dec 31 Dec 31 Dec 31 3,200 6,493 15 (15) 24 9,693 32 9,693 0 Maintenance expense Credit card expense Debit Credit No. Date Balance No. Date Debit Credit Balance Jan 01 0 Jan 01 0 10 2,320 2,320 11 75 75 Dec 31 Dec 31 Jun 30 Dec 31 32 2,320 0 32 75 0 Warranty expense Utilities expense Debit Credit Date Balance Debit No. No. Date Balance Credit Jan 01 0 Jan 01 0 6,100 2,520 2,520 20 Dec 31 6,100 28 32 Dec 31 Dec 31 2,520 0 0 32 6,100 Dec 31 Uncollectible accounts expense 3 Utilities expense ok No. Date Debit Credit Balance Warranty expense Debit Credit No. Date Jan 01 Balance 1 0 Jan 01 20 Dec 31 6,100 0 int 6,100 28 Dec 31 32 Dec 31 2,520 2,520 6,100 0 32 Dec 31 2,520 0 Uncollectible accounts expense rences No. Date Debit Credit Balance Jan 01 0 26 1,993 Dec 31 Dec 31 1,993 32 1,993 Bw Requirement General Journal General Ledger Trial Balance Income Statement 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 2021 represents Year 11 from the problem statement. Post-closing Pacilio Security Services, Inc. Trial Balance December 31, 2021 Account Title Cash Debit Credit $ 229,710 Petty cash 100 Accounts receivable 37,020 Allowance for doubtful accounts 2,985 8,680 Merchandise inventory Supplies Van 190 27,000 9,000 32,350 125,000 25,000 Equipment Accumulated depreciation Building Land Warranty payable Unemployment tax payable Sales tax payable Employee income tax payable FICA - Medicare tax payable FICA-Social security tax payable 1,813 945 1,050 1,400 240 960 Notae navabla 05 017 Prey 1 of 1 Next 190 Supplies Van Equipment Accumulated depreciation Building 27,000 9,000 32,350 Land 125,000 25,000 1,813 945 1,050 1,400 240 Warranty payable Unemployment tax payable Sales tax payable Employee income tax payable FICA - Medicare tax payable FICA - Social security tax payable Notes payable Bonds payable Discount on bonds payable Common stock Paid-in capital in excess of par value, Common stock Preferred stock Paid-in capital in excess of par value, Preferred stock Retained earnings 960 85,017 50,000 600 75,000 15,000 50,000 2,000 161,040 Dividends 17,500 126,000 126,000 Monitoring service revenue Alarm sales Supplies expense Office supplies expense Total 15 15 605,815 605,815 $ Prey 1 of 1 IT Next Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement of CF Analysis ts Choose the appropriate accounts to be reported on the income statement. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. However, you will need to calculate and enter the amount of the net income or loss for the period. eBook Post-closing Pacilio Security Services, Inc. Income Statement For the Year Ended December 31, Year 11 Revenues Monitoring service revenue Alarm sales 126,000 Print References $ Total Revenues Cost of goods sold 126,000 (Gross margin 126,000 Expenses Advertising expense Credit card expense Depreciation expense Maintenance expense Office supplies expense Payroll tax expense Salaries expense Supplies expense Uncollectible accounts expense 15 Prey 1 of 1 DET | Graw Hill Next Advertising expense Credit card expense Depreciation expense Maintenance expense Office supplies expense Payroll tax expense Salaries expense Supplies expense Uncollectible accounts expense Utilities expense Warranty expense 15 $ 15 125,985 Total Operating Expenses Net Operating Income Non-Operating Items Interest expense Net income $ 125,985 Trial Balance Balance Sheet > Prey 1 of 1 ELL Next Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement of CF Analysis The balance sheet is the accounting equation: Assets = Liabilities + Equity. Each asset and liability account is reported separately on the balance sheet.The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. (Enter the balance sheet items in the order of liquidity.) Post-closing Show less Pacilio Security Services, Inc. Balance Sheet At December 31, Year 11 Assets 0 0 $ 0 Liabilities Prey 1 of 1 Next 0 $ Liabilities 0 0 0 es $ 0 Stockholders' Equity Total Paid-in Capital 0 269,525 269,525 269,525 Total Liabilities and Stockholders' Equity $ Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement of CF Analysis Indicate whether the transaction increases (+), decreases (-), or increases and decreases (+/-) for each element of the financial statements. Also, in the Cash Flow column, use the letters OA to designate operating activity, IA for investing activity, FA for financing activity. When more than one activity can be correct response, select from options "FA or IA", "IA or OA", "OA or FA. The first transaction is recorded as an example. Show less Pacilio Security Services, Inc. Effect of Transactions on Financial Statements - Year 11 Balance Sheet Income Statement Net = Liabilities + S. Equity Revenue Expenses Income Transaction Assets Statement of Cash Flows 1 2. OA 3 OA + 4. FA + 5. FA + 6. +/- 7. 8. + 9 + 10 + OA 11 OA 12. +/- 13. 14. 15. Prey 1 of 1 Next 4. 5. FA + 6. +/- 7 8 + 9. + 10 + 11 12 +/- 13. 14 15 16 17 18. 19 20 21. +/- 22 + OA or FA 23 + 24 25. 26. + 27. 28 29 30. Prey. 1 of 1 NextStep 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