Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you help me fix what is wrong. Chapter 11 Comprehensive Problem The trial balance of Pacilio Security Services, Inc. as of January 1, Year
can you help me fix what is wrong.
Chapter 11 Comprehensive Problem 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. 2. Pald 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 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. Pald 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. Pald $18.500 of advertising expense during the year. 20. Pald $6,100 of utilities expense for the year. 21. Pald $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. Pald the accounts payable. 23. Pald bond Interest and amortized the discount. The bond was issued in Year 10 and pays Interest at 6 percent. 24. Pald 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. Pacillo 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. Pacillo 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 Answer is not complete. 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 S. Liabilities Revenue Expenses Equity Assets Transaction 1. Net Income Statement of Cash Flows 2. OA 3 + OA -- 4 + + x FA 5. X FA 6. +- 7. + X + X 8. + X 9. X +/- X + + 10. +/- x 11 x 12. +/- OA 13 OA + x X + > 14 + + X 15. + 16. OA x 17 OA + 18 OA + X OA X Problem i Saved Check my work mode: This shows what is correct or Incorrect for the work y TASseus Transaction 1. Liamues Equity Revenue TExpenses TlIncome 2. 3 OA + 4 X FA 5 6 FA 7 8 X OA X 9 10 11 X 12. +/- 13 14 X + X OA X X 15 X X 16 17 18 19 20. X o OA X OA X OA X 2 OA FA 24 X + >> + ere to search Prex 1 of 1 H Next C X Answer is not complete. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement of CF Analysis Prepare the statement of cash flow for year ended December 31, Year 11. (Amounts to deducted should be indicated with a minus sign.) Pacilio Security Services, Inc. Statement of Cash Flows For the Year Ended December 31, Year 11 Cash flows from operating activities: Cash receipts from customers $ 253,680 Cash payment for expenses (189,310) Cash Payment for sales tax payable (5,640) Cash payment for interest (9,493) Net cash flow from operating activities Cash flows from investing activities: $ 49,237 Net cash flows from investing activities Cash flows from financing activities: Cash inflow from stock issue Cash payment on notes payable Cash payments for dividends 92,000 (7,745) (17,500) Net cash flow from financing activities Net increase in cash Add: Beginning cash balance Ending cash balance OO 66.755 115,992 113,718 229,710 $ Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement 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 your selection. (Enter the balance sheet items in the order of liquidity.) Show less Post-closing Pacilio Security Services, Inc. Balance Sheet At December 31, Year 11 Assets 0 0 $ 0 Liabilities 0 0 S 0 Liabilities 0 0 $ 0 Stockholders' Equity Total Paid-in Capital 0 269,525 269,525 269,525 Total Liabilities and Stockholders' Equity S & Answer is not complete. 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 No. Debit Credit Date Jan 01 Balance 11 100 90 18 1 Jan 01 Jun 30 Nov 01 Dec 31 Dec 31 Dec 31 Dec 31 17,500 390 2,995 2 3 4 40,000 52.000 6 58,900 12 55,680 Balance 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 13 5,250 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 14 198,000 15 2 17 78,200 1,625 18,500 19 20 GARAN Dec 31 Dec 31 Dec 31 Dec 31 6,100 22,400 500 3,000 14.238 23 Prey 11 Accounts receivable - Credit card Accounts receivable No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 Jan 01 10 Dec 31 55,680 0 55,680 7 3,670 12 Dec 31 Dec 31 Dec 31 55,680 g 39,390 35,720 168,020 235.020 37,020 132,300 67,000 10 Dec 31 Dec 31 14 198,000 Allowance for doubtful accounts Merchandise inventory No. Date Debit Credit Balance No. Debit Jan 01 Credit 4,662 7 3,670 Dec 31 Dec 31 Date Jan 01 Dec 31 Dec 31 6 992 2,985 58.900 Balance 14,400 73,300 8,680 26 1,993 9 64,620 Supplies Van No. Date Debit Credit Balance No. Date Debit Jan 01 Credit Balance Jan 01 5 Dec 31 27,000 500 210 710 190 25 Dec 31 520 Equipment Accumulated depreciation No. Date Debit Credit No. Date Jan 01 Balance 9,000 Debit Credit Balance 27 27 Jan 01 Dec 31 Dec 31 1,400 2,875 28,075 29,475 32,350 Building Land No. Date Debit Credit No. Date Jan 01 Balance 125.000 Debit Credit Balance Jan 01 25,000 Accounts payable Debit Credit No. Date Jan 01 Balance Warranty payable Debit Credit No Date Jan 01 Balance 918 Prex 1 of 1 Ne be here to search Accounts payable Warranty payable No. Date Debit Credit Balance No. Date Debit Jan 01 Credit Balance 0 Jan 01 5 Dec 31 918 500 500 17 Dec 31 1,625 22 Dec 31 500 0 28 Dec 31 (707) 1.813 2,520 Unemployment tax payable Sales tax payable No Date Debit Credit No Date Balance 945 Debit Jan 01 Credit Balance Jan 01 2 Dec 31 945 390 0 1 Dec 31 29 Dec 31 390 0 945 945 8 Dec 31 6,300 13 Dec 31 5,250 6,300 1,050 Dividends payable Debit Credit Employee income tax payable No. Balance No. Date Debit Credit Balance Date Jan 01 Oct 01 Nov 01 0 16 Jan 01 1,000 17,500 18 2 Dec 31 17,500 0 1,000 17.500 0 15 Dec 31 Dec 31 10,600 21 9,200 10.600 1,400 FICA-Medicare tax payable FICA - Social security tax payable No. Date Debit Credit Balance No. Date Debit Credit Balance 210 2 210 840 15 2 Jan 01 Dec 31 Dec 31 Dec 31 Dec 31 840 1.440 21 15 Jan 01 Dec 31 Dec 31 Dec 31 Dec 31 0 1.440 120 240 1,320 5,760 30 21 5,280 0 5.760 480 960 120 30 480 Notes payable No. Bonds payable Date Debit Credit No. Date Debit Balance 92,762 85.017 Jan 01 Dec 31 Credit 24 Jan 01 Balance 50,000 7.745 30 Dec 31 120 w 240 30 Dec 31 480 960 Notes payable Bonds payable No. Date Debit Credit Balance No. Date Debit Credit Jan 01 Jan 01 Balance 50,000 24 Dec 31 92,762 85,017 7,745 Discount on bonds payable Common stock No. Date Debit Credit No. Debit Credit Jan 01 Dec 31 Balance 800 600 Date Jan 01 Dec 31 23 Balance 50,000 75,000 200 3 25,000 Paid-in capital in excess of par value, Common stock Preferred stock No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 0 3 Dec 31 0 15.000 Jan 01 Dec 31 15,000 4 50,000 50,000 Paid-in capital in excess of par value, Preferred stock Retained earnings No. Date Debit Credit Balance No. Date Debit Jan 01 Credit 0 4 Dec 31 2,000 2,000 31 Jan 01 Dec 31 Dec 31 Balance 124,816 375 816 161.040 251,000 32 214,776 Dividends Security service revenue No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 Oct 01 16 17,500 0 17,500 10 Dec 31 Dec 31 125,000 125.000 31 125.000 0 Monitoring service revenue Alarm sales No. Date Debit Credit Balance No Date Debit Credit Balance Jan 01 Dec 31 0 31 126,000 (126,000) Jan 01 Dec 31 8 126,000 126,000 Prex 1 of 1 Next une wo Monitoring service revenue Alarm sales No. Date Debit Credit Balance No. Date Debit Credit Balance 0 Jan 01 Dec 31 0 31 Jan 01 Dec 31 126,000 (126,000 8 126,000 126.000 Advertising expense Cost of goods sold No. Debit Credit Date Jan 01 Balance No. Date Debit Credit Balance Jan 01 0 19 18,500 Dec 31 Dec 31 0 19,500 9 64,620 32 Dec 31 Dec 31 64,620 18,500 0 32 64,620 0 Depreciation expense Supplies expense No. Debit Credit Balance No. Debit Credit Balance Date Jan 01 Dec 31 0 27 1,400 2,875 15 Date Jan 01 Jun 30 Dec 31 Dec 31 15 27 1,400 4,275 0 Dec 31 11 25 520 32 Dec 31 535 4 275 32 520 15 Salaries expense Payroll tax expense No. Date Debit Credit Balance No. Debit Credit Balance Jan 01 Dec 31 0 15 96,000 21 32 Dec 31 96,000 0 96,000 Date Jan 01 Dec 31 Dec 31 Dec 31 Dec 31 29 6,600 945 600 30 6,600 7,545 8.145 0 32 8.145 Interest expense No. Debit Credit Balance Office supplies expense Debit Credit No. Balance 0 Date Jan 01 Dec 31 0 Date Jan 01 Dec 31 Dec 31 Dec 31 23 3,200 6,493 32 3,200 9,693 15 24 32 (15) 9,693 0 Check my work mode: This shows what is correct or Incorrect for the wc 32 Dec 31 8,145 Interest expense Office supplies expense No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 0 Jan 01 23 3,200 32 Dec 31 15 3,200 9,693 (15) 24 Dec 31 Dec 31 Dec 31 6,493 32 9,693 0 Credit card expense Maintenance expense No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 0 Jan 01 10 2,320 Dec 31 Dec 31 2,320 11 Jun 30 75 32 75 2,320 32 Dec 31 75 0 Utilities expense Warranty expense No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 0 0 20 Dec 31 6,100 6.100 28 Jan 01 Dec 31 Dec 31 2,520 32 Dec 31 2,520 6.100 0 32 2.520 0 Uncollectible accounts expense No. Date Debit Credit Balance Jan 01 0 26 1,993 Dec 31 Dec 31 1,993 32 1,993 0 Supplies expense Supplies OO 520 26 Dec 31 Uncollectible accounts expense 1,993 Allowance for doubtful accounts 1,993 27 Dec 31 1.400 X Depreciation expense Accumulated depreciation Depreciation expense Accumulated depreciation 1,400 2,875 X 2,875 X 28 Dec 31 Warranty expense Warranty payable 2,520 2,520 Prex 1 of 1 N Check my work mode: This shows what is correct or Incorrect for the v ILUUIUIUILUUPILLILILIUI LU 28 Dec 31 Warranty expense Warranty payable 2,520 2,520 > 29 Dec 31 Payroll tax expense Unemployment tax payable . 945 945 30 Dec 31 600 > Payroll tax expense FICA - Social security tax payable FICA - Medicare tax payable ooo 480 120 0 31 Dec 31 0 126.000 Monitoring service revenue Security service revenue Retained earnings X 125,000 x 251,000 32 Dec 31 214,776 64,620 18,500 2,320 4,275 75 Retained earnings Cost of goods sold 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 Interest expense OOOOOOOOOOOOOO OOOOOO 15 8,145 96,000 520 1,993 6,100 2,520 9,693 OOO We Problem Saved Check my work mode: This shows what is correct or Incorrect for the work y percent of alarm sales. 29. The unemployment tax on the three employees has not been pald Record the accrued unemployment tax on the salaries for 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. Answer is not complete. 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. R Requirement General Journal > Chapter 11 Comprehensive Problem 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. 2. Pald 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 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. Pald 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. Pald $18.500 of advertising expense during the year. 20. Pald $6,100 of utilities expense for the year. 21. Pald $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. Pald the accounts payable. 23. Pald bond Interest and amortized the discount. The bond was issued in Year 10 and pays Interest at 6 percent. 24. Pald 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. Pacillo 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. Pacillo 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 Answer is not complete. 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 S. Liabilities Revenue Expenses Equity Assets Transaction 1. Net Income Statement of Cash Flows 2. OA 3 + OA -- 4 + + x FA 5. X FA 6. +- 7. + X + X 8. + X 9. X +/- X + + 10. +/- x 11 x 12. +/- OA 13 OA + x X + > 14 + + X 15. + 16. OA x 17 OA + 18 OA + X OA X Problem i Saved Check my work mode: This shows what is correct or Incorrect for the work y TASseus Transaction 1. Liamues Equity Revenue TExpenses TlIncome 2. 3 OA + 4 X FA 5 6 FA 7 8 X OA X 9 10 11 X 12. +/- 13 14 X + X OA X X 15 X X 16 17 18 19 20. X o OA X OA X OA X 2 OA FA 24 X + >> + ere to search Prex 1 of 1 H Next C X Answer is not complete. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement of CF Analysis Prepare the statement of cash flow for year ended December 31, Year 11. (Amounts to deducted should be indicated with a minus sign.) Pacilio Security Services, Inc. Statement of Cash Flows For the Year Ended December 31, Year 11 Cash flows from operating activities: Cash receipts from customers $ 253,680 Cash payment for expenses (189,310) Cash Payment for sales tax payable (5,640) Cash payment for interest (9,493) Net cash flow from operating activities Cash flows from investing activities: $ 49,237 Net cash flows from investing activities Cash flows from financing activities: Cash inflow from stock issue Cash payment on notes payable Cash payments for dividends 92,000 (7,745) (17,500) Net cash flow from financing activities Net increase in cash Add: Beginning cash balance Ending cash balance OO 66.755 115,992 113,718 229,710 $ Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Statement 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 your selection. (Enter the balance sheet items in the order of liquidity.) Show less Post-closing Pacilio Security Services, Inc. Balance Sheet At December 31, Year 11 Assets 0 0 $ 0 Liabilities 0 0 S 0 Liabilities 0 0 $ 0 Stockholders' Equity Total Paid-in Capital 0 269,525 269,525 269,525 Total Liabilities and Stockholders' Equity S & Answer is not complete. 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 No. Debit Credit Date Jan 01 Balance 11 100 90 18 1 Jan 01 Jun 30 Nov 01 Dec 31 Dec 31 Dec 31 Dec 31 17,500 390 2,995 2 3 4 40,000 52.000 6 58,900 12 55,680 Balance 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 13 5,250 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 Dec 31 14 198,000 15 2 17 78,200 1,625 18,500 19 20 GARAN Dec 31 Dec 31 Dec 31 Dec 31 6,100 22,400 500 3,000 14.238 23 Prey 11 Accounts receivable - Credit card Accounts receivable No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 Jan 01 10 Dec 31 55,680 0 55,680 7 3,670 12 Dec 31 Dec 31 Dec 31 55,680 g 39,390 35,720 168,020 235.020 37,020 132,300 67,000 10 Dec 31 Dec 31 14 198,000 Allowance for doubtful accounts Merchandise inventory No. Date Debit Credit Balance No. Debit Jan 01 Credit 4,662 7 3,670 Dec 31 Dec 31 Date Jan 01 Dec 31 Dec 31 6 992 2,985 58.900 Balance 14,400 73,300 8,680 26 1,993 9 64,620 Supplies Van No. Date Debit Credit Balance No. Date Debit Jan 01 Credit Balance Jan 01 5 Dec 31 27,000 500 210 710 190 25 Dec 31 520 Equipment Accumulated depreciation No. Date Debit Credit No. Date Jan 01 Balance 9,000 Debit Credit Balance 27 27 Jan 01 Dec 31 Dec 31 1,400 2,875 28,075 29,475 32,350 Building Land No. Date Debit Credit No. Date Jan 01 Balance 125.000 Debit Credit Balance Jan 01 25,000 Accounts payable Debit Credit No. Date Jan 01 Balance Warranty payable Debit Credit No Date Jan 01 Balance 918 Prex 1 of 1 Ne be here to search Accounts payable Warranty payable No. Date Debit Credit Balance No. Date Debit Jan 01 Credit Balance 0 Jan 01 5 Dec 31 918 500 500 17 Dec 31 1,625 22 Dec 31 500 0 28 Dec 31 (707) 1.813 2,520 Unemployment tax payable Sales tax payable No Date Debit Credit No Date Balance 945 Debit Jan 01 Credit Balance Jan 01 2 Dec 31 945 390 0 1 Dec 31 29 Dec 31 390 0 945 945 8 Dec 31 6,300 13 Dec 31 5,250 6,300 1,050 Dividends payable Debit Credit Employee income tax payable No. Balance No. Date Debit Credit Balance Date Jan 01 Oct 01 Nov 01 0 16 Jan 01 1,000 17,500 18 2 Dec 31 17,500 0 1,000 17.500 0 15 Dec 31 Dec 31 10,600 21 9,200 10.600 1,400 FICA-Medicare tax payable FICA - Social security tax payable No. Date Debit Credit Balance No. Date Debit Credit Balance 210 2 210 840 15 2 Jan 01 Dec 31 Dec 31 Dec 31 Dec 31 840 1.440 21 15 Jan 01 Dec 31 Dec 31 Dec 31 Dec 31 0 1.440 120 240 1,320 5,760 30 21 5,280 0 5.760 480 960 120 30 480 Notes payable No. Bonds payable Date Debit Credit No. Date Debit Balance 92,762 85.017 Jan 01 Dec 31 Credit 24 Jan 01 Balance 50,000 7.745 30 Dec 31 120 w 240 30 Dec 31 480 960 Notes payable Bonds payable No. Date Debit Credit Balance No. Date Debit Credit Jan 01 Jan 01 Balance 50,000 24 Dec 31 92,762 85,017 7,745 Discount on bonds payable Common stock No. Date Debit Credit No. Debit Credit Jan 01 Dec 31 Balance 800 600 Date Jan 01 Dec 31 23 Balance 50,000 75,000 200 3 25,000 Paid-in capital in excess of par value, Common stock Preferred stock No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 0 3 Dec 31 0 15.000 Jan 01 Dec 31 15,000 4 50,000 50,000 Paid-in capital in excess of par value, Preferred stock Retained earnings No. Date Debit Credit Balance No. Date Debit Jan 01 Credit 0 4 Dec 31 2,000 2,000 31 Jan 01 Dec 31 Dec 31 Balance 124,816 375 816 161.040 251,000 32 214,776 Dividends Security service revenue No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 Oct 01 16 17,500 0 17,500 10 Dec 31 Dec 31 125,000 125.000 31 125.000 0 Monitoring service revenue Alarm sales No. Date Debit Credit Balance No Date Debit Credit Balance Jan 01 Dec 31 0 31 126,000 (126,000) Jan 01 Dec 31 8 126,000 126,000 Prex 1 of 1 Next une wo Monitoring service revenue Alarm sales No. Date Debit Credit Balance No. Date Debit Credit Balance 0 Jan 01 Dec 31 0 31 Jan 01 Dec 31 126,000 (126,000 8 126,000 126.000 Advertising expense Cost of goods sold No. Debit Credit Date Jan 01 Balance No. Date Debit Credit Balance Jan 01 0 19 18,500 Dec 31 Dec 31 0 19,500 9 64,620 32 Dec 31 Dec 31 64,620 18,500 0 32 64,620 0 Depreciation expense Supplies expense No. Debit Credit Balance No. Debit Credit Balance Date Jan 01 Dec 31 0 27 1,400 2,875 15 Date Jan 01 Jun 30 Dec 31 Dec 31 15 27 1,400 4,275 0 Dec 31 11 25 520 32 Dec 31 535 4 275 32 520 15 Salaries expense Payroll tax expense No. Date Debit Credit Balance No. Debit Credit Balance Jan 01 Dec 31 0 15 96,000 21 32 Dec 31 96,000 0 96,000 Date Jan 01 Dec 31 Dec 31 Dec 31 Dec 31 29 6,600 945 600 30 6,600 7,545 8.145 0 32 8.145 Interest expense No. Debit Credit Balance Office supplies expense Debit Credit No. Balance 0 Date Jan 01 Dec 31 0 Date Jan 01 Dec 31 Dec 31 Dec 31 23 3,200 6,493 32 3,200 9,693 15 24 32 (15) 9,693 0 Check my work mode: This shows what is correct or Incorrect for the wc 32 Dec 31 8,145 Interest expense Office supplies expense No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 0 Jan 01 23 3,200 32 Dec 31 15 3,200 9,693 (15) 24 Dec 31 Dec 31 Dec 31 6,493 32 9,693 0 Credit card expense Maintenance expense No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 0 Jan 01 10 2,320 Dec 31 Dec 31 2,320 11 Jun 30 75 32 75 2,320 32 Dec 31 75 0 Utilities expense Warranty expense No. Date Debit Credit Balance No. Date Debit Credit Balance Jan 01 0 0 20 Dec 31 6,100 6.100 28 Jan 01 Dec 31 Dec 31 2,520 32 Dec 31 2,520 6.100 0 32 2.520 0 Uncollectible accounts expense No. Date Debit Credit Balance Jan 01 0 26 1,993 Dec 31 Dec 31 1,993 32 1,993 0 Supplies expense Supplies OO 520 26 Dec 31 Uncollectible accounts expense 1,993 Allowance for doubtful accounts 1,993 27 Dec 31 1.400 X Depreciation expense Accumulated depreciation Depreciation expense Accumulated depreciation 1,400 2,875 X 2,875 X 28 Dec 31 Warranty expense Warranty payable 2,520 2,520 Prex 1 of 1 N Check my work mode: This shows what is correct or Incorrect for the v ILUUIUIUILUUPILLILILIUI LU 28 Dec 31 Warranty expense Warranty payable 2,520 2,520 > 29 Dec 31 Payroll tax expense Unemployment tax payable . 945 945 30 Dec 31 600 > Payroll tax expense FICA - Social security tax payable FICA - Medicare tax payable ooo 480 120 0 31 Dec 31 0 126.000 Monitoring service revenue Security service revenue Retained earnings X 125,000 x 251,000 32 Dec 31 214,776 64,620 18,500 2,320 4,275 75 Retained earnings Cost of goods sold 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 Interest expense OOOOOOOOOOOOOO OOOOOO 15 8,145 96,000 520 1,993 6,100 2,520 9,693 OOO We Problem Saved Check my work mode: This shows what is correct or Incorrect for the work y percent of alarm sales. 29. The unemployment tax on the three employees has not been pald Record the accrued unemployment tax on the salaries for 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. Answer is not complete. 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. R Requirement General Journal >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