The trial balance of Pacillo Security Services, Incorporated as of January 1, Year 9, had the...

Transcribed Image Text:

The trial balance of Pacillo Security Services, Incorporated as of January 1, Year 9, had the following normal balances. Cash Petty cash Accounts receivable Allowance for doubtful accounts $ 93,380 100 21,390 2,485 Supplies 180 Prepaid rent 3,000 Merchandise inventory (23 @ $280) 6,440 Equipment 9,000 Van 27,000 Accumulated depreciation 14,900 1,500 50,000 91,605 Salaries payable Common stock Retained earnings 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. 7. Record cost of good sold for the sales transaction mentioned in previous transaction (number 6). Be sure to compute cost of goods sold using the FIFO cost flow 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 the payroll taxes, both the amounts withheld from the salaries plus the employer share of Social Security tax and Medicare tax, on $60,000 of the salaries plus $7,000 of the federal Income tax that was withheld. (Unemployment taxes were not paid at this time.) 19. Paid the accounts payable. 20. Paid a dividend of $10,000 to the shareholders. Adjustments 21. There was $165 of supplies on hand at the end of the year. 22. Recognized the expired rent for the office building for the year. 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, Pacillo estimates that 2.75 percent of sales on account will not be collected. 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.) 25. The alarm systems sold in transaction 6 were covered with a one-year warranty. Pacillo estimated that the warranty cost would be 3 percent of alarm sales. 26. Recognized the accrued Interest on the note payable at December 31, Year 9. 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.) 28. 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 Trial Balance Income Statement Changes in SE Balance Sheet Statement of CF Analysis 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. (If no entry is required for a transaction, select "No journal entry required" in the first account field. Round your answers to the nearest dollar amount.) Show less View transaction list Journal entry worksheet 1 24 25 26 27 28 29 30 31 Record the closing entry for the revenue accounts. Note: Enter debits before credits. Date Dec 31 General Journal Debit Credit Record entry Clear entry View general journal < Requirement General Ledger > Requirement General Journal General Ledger Trial Balance Income Statement Changes in SE Balance Sheet Statement of CF Analysis 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. (If no entry is required for a transaction, select "No journal entry required" in the first account field. Round your answers to the nearest dollar amount.) Show less View transaction list Journal entry worksheet 1 24 25 26 27 28 29 30 31 Record the closing entry for the expense accounts. Note: Enter debits before credits. Date Dec 31 General Journal Debit Credit Requirement General Journal General Ledger Trial Balance Income Statement Changes in Balance SE Sheet Statement of CF Analysis 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. (If no entry is required for a transaction, select "No journal entry required" in the first account field. Round your answers to the nearest dollar amount.) Show less View transaction list Journal entry worksheet 1 24 25 26 27 28 29 30 31 Record the closing entry for dividends account. Note: Enter debits before credits. Date Dec 31 General Journal Debit Credit Record entry Clear entry View general journal separately on the balance sheet. Choose the appropriate accounts to be reported 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 th order of liquidity.) Adjusted Balance Sheet At December 31, Year 9 Cash Petty cash Accounts receivable Allowance for doubtful accounts Supplies Prepaid rent Merchandise inventory Equipment Van Accumulated depreciation Total Assets Salaries payable Common stock Retained earnings Assets 122,475 100 27,400 (4,390) 23,010 165 3,000 11,020 9,000 27,000 (23,050) 12,950 Liabilities $ 0 Stockholders' Equity $ 50,000 107,918 Total Stockholders' Equity Total Liabilities and Stockholders' Equity $ 172,720 $ 0 157,918 $ 157,918 Requirement General Journal General Ledger Trial Balance Income Statement Changes in SE Balance Sheet Statement Analysis of CF Prepare the statement of cash flow for year ended December 31, Year 9. (Enter cash outflows and amounts to be de with a minus sign.) Pacilio Security Services, Incorporated Statement of Cash Flows For the Year Ended December 31, Year 9 Cash flows from operating activities: Cash receipts from customers Cash payment for expenses Net cash flow from operating activities Cash flows from investing activities: Net cash flows from investing activities Cash flows from financing activities: Net cash flow from financing activities Net increase in cash Add: Beginning cash balance Ending cash balance < Balance Sheet $ 0 Analysis > General Requirement Journal General Ledger Trial Balance Income Statement Changes in Balance SE Sheet Statement of CF Analysis Indicate whether the transaction increases (+), decreases (-), or increases and decreases (+/-) each element of the financial statements. Also, in the Statement of Cash Flows column, use the letters OA to designate operating activity, IA for investing activity, FA for financing activity, and leave blank for no effect. The first transaction is recorded as an example. (Not all cells require input.) Show less Pacilio Security Services, Incorporated Horizontal Statements Model Balance Sheet Income Statement Transaction Assets Liabilities Stockholders' Equity Net Revenue Expenses Statement of Cash Flows Income 1. OA IA 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. OA OA OA OA OA The trial balance of Pacillo Security Services, Incorporated as of January 1, Year 9, had the following normal balances. Cash Petty cash Accounts receivable Allowance for doubtful accounts $ 93,380 100 21,390 2,485 Supplies 180 Prepaid rent 3,000 Merchandise inventory (23 @ $280) 6,440 Equipment 9,000 Van 27,000 Accumulated depreciation 14,900 1,500 50,000 91,605 Salaries payable Common stock Retained earnings 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. 7. Record cost of good sold for the sales transaction mentioned in previous transaction (number 6). Be sure to compute cost of goods sold using the FIFO cost flow 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 the payroll taxes, both the amounts withheld from the salaries plus the employer share of Social Security tax and Medicare tax, on $60,000 of the salaries plus $7,000 of the federal Income tax that was withheld. (Unemployment taxes were not paid at this time.) 19. Paid the accounts payable. 20. Paid a dividend of $10,000 to the shareholders. Adjustments 21. There was $165 of supplies on hand at the end of the year. 22. Recognized the expired rent for the office building for the year. 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, Pacillo estimates that 2.75 percent of sales on account will not be collected. 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.) 25. The alarm systems sold in transaction 6 were covered with a one-year warranty. Pacillo estimated that the warranty cost would be 3 percent of alarm sales. 26. Recognized the accrued Interest on the note payable at December 31, Year 9. 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.) 28. 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 Trial Balance Income Statement Changes in SE Balance Sheet Statement of CF Analysis 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. (If no entry is required for a transaction, select "No journal entry required" in the first account field. Round your answers to the nearest dollar amount.) Show less View transaction list Journal entry worksheet 1 24 25 26 27 28 29 30 31 Record the closing entry for the revenue accounts. Note: Enter debits before credits. Date Dec 31 General Journal Debit Credit Record entry Clear entry View general journal < Requirement General Ledger > Requirement General Journal General Ledger Trial Balance Income Statement Changes in SE Balance Sheet Statement of CF Analysis 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. (If no entry is required for a transaction, select "No journal entry required" in the first account field. Round your answers to the nearest dollar amount.) Show less View transaction list Journal entry worksheet 1 24 25 26 27 28 29 30 31 Record the closing entry for the expense accounts. Note: Enter debits before credits. Date Dec 31 General Journal Debit Credit Requirement General Journal General Ledger Trial Balance Income Statement Changes in Balance SE Sheet Statement of CF Analysis 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. (If no entry is required for a transaction, select "No journal entry required" in the first account field. Round your answers to the nearest dollar amount.) Show less View transaction list Journal entry worksheet 1 24 25 26 27 28 29 30 31 Record the closing entry for dividends account. Note: Enter debits before credits. Date Dec 31 General Journal Debit Credit Record entry Clear entry View general journal separately on the balance sheet. Choose the appropriate accounts to be reported 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 th order of liquidity.) Adjusted Balance Sheet At December 31, Year 9 Cash Petty cash Accounts receivable Allowance for doubtful accounts Supplies Prepaid rent Merchandise inventory Equipment Van Accumulated depreciation Total Assets Salaries payable Common stock Retained earnings Assets 122,475 100 27,400 (4,390) 23,010 165 3,000 11,020 9,000 27,000 (23,050) 12,950 Liabilities $ 0 Stockholders' Equity $ 50,000 107,918 Total Stockholders' Equity Total Liabilities and Stockholders' Equity $ 172,720 $ 0 157,918 $ 157,918 Requirement General Journal General Ledger Trial Balance Income Statement Changes in SE Balance Sheet Statement Analysis of CF Prepare the statement of cash flow for year ended December 31, Year 9. (Enter cash outflows and amounts to be de with a minus sign.) Pacilio Security Services, Incorporated Statement of Cash Flows For the Year Ended December 31, Year 9 Cash flows from operating activities: Cash receipts from customers Cash payment for expenses Net cash flow from operating activities Cash flows from investing activities: Net cash flows from investing activities Cash flows from financing activities: Net cash flow from financing activities Net increase in cash Add: Beginning cash balance Ending cash balance < Balance Sheet $ 0 Analysis > General Requirement Journal General Ledger Trial Balance Income Statement Changes in Balance SE Sheet Statement of CF Analysis Indicate whether the transaction increases (+), decreases (-), or increases and decreases (+/-) each element of the financial statements. Also, in the Statement of Cash Flows column, use the letters OA to designate operating activity, IA for investing activity, FA for financing activity, and leave blank for no effect. The first transaction is recorded as an example. (Not all cells require input.) Show less Pacilio Security Services, Incorporated Horizontal Statements Model Balance Sheet Income Statement Transaction Assets Liabilities Stockholders' Equity Net Revenue Expenses Statement of Cash Flows Income 1. OA IA 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. OA OA OA OA OA