Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The trial balance of Pacilio Security Services, Incorporated as of January 1, Year 9 , had the following normal balances. During Year 9, Pacilio Security

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The trial balance of Pacilio Security Services, Incorporated as of January 1, Year 9 , had the following normal balances. 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 15 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-yoar 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 utiities experse for the yeat 18. Paid the payroll taxes, both the amounts withheld trom the salaries plus the employer share of Social Security tax and Medicare taxi; on $60,000 of the sataries plus 57,000 of the federal income tax thint was withheld. fUnemplayment 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 5165 of wivpplies on hind at the end of the yeac. 22. Recognized the empired rent for the office buidding for the year 23. Aecognited uncollectibie accounts experise for the year using the allownnce method. The company revised its estimate of incoilectible be collected 18. Paid the payroll taxes, both the amounts withheld from the solaries 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 poid 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, Pacilio estimates that 275 percent of sales on account will not be collected. 24. Recognized depreciation expense on the equipment and the van. The equipment has a fiveyear life and a $2,000 salvage value. The van has a four-year life and a $6,000 salvage value. The company uses double-decliring-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. Pacilio 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. (514,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. General Joumal 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 aitomatically to the general ledger: Trial Balance tab - The ending balance values from the General Ledger tab flows through to the Thal Balance tab. Income Statement tab - Use the drop-down to select the accounts properly induded on the income statement. Statement of Changes in Stockholders' Fquity tab - Prepare the statement of changes in stockholders' equity for the year ended December 31, year 9 . Balance Sheet tab - Prepare a dassified Batance Sheet at December 31, Year. 9. Statement of Cash flows - Prepare the statement of cash fiow 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 fows Indicate whether the trapsaction Increases (4), decreases (), or increases and decreases (+f) each eicment of the finandal statements, Also, In the Staternent of Cash flows column, use the letters OA to designate operating activity, 1A for investing actlvity, FA for financing activity, and leave blank for no effect. The first transaction is recorded as an example. (Not all cellis require input.) The van has a four-year life and a $6,000 salvage value. The compary uses double-declining-balance for the van and straight-1ne for the equipment. (A full year's depreciation was taken in Year 8, the year of acquisition.) 25. The alam 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. 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 yeat, 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 salaties expense. Prepare the statement of cash flow for year ended December 31, Yoar 9. (Enter cash outflows and amounts to be deducted with a minus sign.) The balance sheet is the accounting equation: Assets = Uablililes + Equity. Each asset and liablity account is reported separabely 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 the order of Hiquidity.) Prepare the statement of changes in stockholders' equity for the year ended December 31 , Year 9 . You will need to determine and enter the accounts and balances to prepare the Statement of Changes in Stockholders' Equity. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Choose the appropriate accounts to be reported on the Income statement. The unadjusted, adjusted, or post-dosing balanoes will appear for each account, based on your selection. 27. The unemployment tax on salaries has not been paid. Recorded the accrued unemployment tax on the salaries for the year. T 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. 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. Each joumal entry is posted automatically to the general ledger. The unadjusted, adjusted, or post-dosing balances will appear for each account, based on your selection. The trial balance of Pacilio Security Services, Incorporated as of January 1, Year 9 , had the following normal balances. 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 15 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-yoar 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 utiities experse for the yeat 18. Paid the payroll taxes, both the amounts withheld trom the salaries plus the employer share of Social Security tax and Medicare taxi; on $60,000 of the sataries plus 57,000 of the federal income tax thint was withheld. fUnemplayment 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 5165 of wivpplies on hind at the end of the yeac. 22. Recognized the empired rent for the office buidding for the year 23. Aecognited uncollectibie accounts experise for the year using the allownnce method. The company revised its estimate of incoilectible be collected 18. Paid the payroll taxes, both the amounts withheld from the solaries 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 poid 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, Pacilio estimates that 275 percent of sales on account will not be collected. 24. Recognized depreciation expense on the equipment and the van. The equipment has a fiveyear life and a $2,000 salvage value. The van has a four-year life and a $6,000 salvage value. The company uses double-decliring-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. Pacilio 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. (514,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. General Joumal 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 aitomatically to the general ledger: Trial Balance tab - The ending balance values from the General Ledger tab flows through to the Thal Balance tab. Income Statement tab - Use the drop-down to select the accounts properly induded on the income statement. Statement of Changes in Stockholders' Fquity tab - Prepare the statement of changes in stockholders' equity for the year ended December 31, year 9 . Balance Sheet tab - Prepare a dassified Batance Sheet at December 31, Year. 9. Statement of Cash flows - Prepare the statement of cash fiow 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 fows Indicate whether the trapsaction Increases (4), decreases (), or increases and decreases (+f) each eicment of the finandal statements, Also, In the Staternent of Cash flows column, use the letters OA to designate operating activity, 1A for investing actlvity, FA for financing activity, and leave blank for no effect. The first transaction is recorded as an example. (Not all cellis require input.) The van has a four-year life and a $6,000 salvage value. The compary uses double-declining-balance for the van and straight-1ne for the equipment. (A full year's depreciation was taken in Year 8, the year of acquisition.) 25. The alam 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. 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 yeat, 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 salaties expense. Prepare the statement of cash flow for year ended December 31, Yoar 9. (Enter cash outflows and amounts to be deducted with a minus sign.) The balance sheet is the accounting equation: Assets = Uablililes + Equity. Each asset and liablity account is reported separabely 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 the order of Hiquidity.) Prepare the statement of changes in stockholders' equity for the year ended December 31 , Year 9 . You will need to determine and enter the accounts and balances to prepare the Statement of Changes in Stockholders' Equity. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Choose the appropriate accounts to be reported on the Income statement. The unadjusted, adjusted, or post-dosing balanoes will appear for each account, based on your selection. 27. The unemployment tax on salaries has not been paid. Recorded the accrued unemployment tax on the salaries for the year. T 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. 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. Each joumal entry is posted automatically to the general ledger. The unadjusted, adjusted, or post-dosing balances will appear for each account, based on your selection

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

Step: 3

blur-text-image

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

IT Audit Control And Security

Authors: Robert R. Moeller

1st Edition

0471406767, 9780471406761

More Books

Students also viewed these Accounting questions