Fill out income statement, balance sheet, statement of CF$,$ and analysis please

Durlng Year 11, Paclllo Security Servlces experlenced the followlng transactlons: 1. Pald the soles tox payable from Year 10. 2 Paid the balance of the payroll Ilebllltles due for Year 10 (federal Income tax. FICA taxes, and unemployment toxesl 3. Issued 5,000 addltlonal shores of the $5 par value common stock for S8 per shore. 4. Issued 1.000 shores of S50 stated value, 5 percent cumulotlve preferred stock for S52 per share. 5. Purchased $500 of supplles on account 6. Purchased Igo alarm systems ot a cost of S310_ Cash was pold for the purchase. 7 After numerous eltempts to collect from customers, wrote off $3,670 of uncollectlble accounts recelvable_ 8. Sold 210 alarm systems for $600 each plus soles lox of 5 percent. All soles were on account. g. Record the cost of goods sold related to the sale from Event 8 uslng the FIFO method. 10 Bllled $125,000 of monltorlng servlces for the year Creel: cord soles amounted to S58,OOO, and the credlt card company charged a 4 percent fee. The remelnlng S67,OOO were sales on account Sales tax Is not charged on tills seMce_ 11. Replenlshed the petty cash fund on June 30. The fund hed SIO cosh end recelpts of $75 for yard mowlng and SIS for office supplles expense 12 Collected the amount due from the credn card company 13. Pald the soles tox collected on S105.OOO ofline alarm sales 14. Collected $198,000 of accounts recelvable durlng the year. 15. Paid Installers and other employees total of "6.000 for salarles for the year. Assume the Soclal Securlty tax rote Is 6 percent and the Medlcare tax rete Is IS percent Federal Income Wes wlthheld amounted to SIO,600_ No employee exceeded $110,000 In total wages. The net salaries were vald In castm 16. On October 1, declared dlvldend on the preferred stock and $1 per share dlvldend on the common stock to be pald to shareholders of record on October 15. payable on November 1. Year 11. 17 Pald Sl.625 In warranty repalrs durlng the year. 18. On November 1, Year 11. pald the dlvldends that had been prevlousty declared. 19. Pald S18.500 of advenlslng expense durvng the yeer_ 20 Paid S6,100 of utllltles expense for the year 21. Paid the payroll llabtlltles, both the amounts wlthheld from the selarles plus the employer share of Soclal SecurITytox end Medlcore tax, on 388.000 of the salaries plus Sg.200 of the federal Income tex the: was vvlthheld_ 22 Pald the accounts payable. 23. Pald bond Interest and amortlzed the dLscount The bond wos Issued In Year 10 end pays Interest at 6 percent. 22 Paid the accounts ayable. 23_ Pold bond Interest end amortlzed the discount The bond was Issued In Year 10 end pays Interest at 6 percent. 24. Pard the annual Installment of 314.238 on the amortlzed note. The Interest rate for the note IS 7 percent Adjustment 25 There was $190 of supplles on hand at the end of the year. 26. Recognized the uncollectlble accounts expense for the year using the allowance method. Paclllo now estimates that 1 percent of soles on account wlll not be collected. 27. Recognized expense on the equipment. Van. and The equipment. purchased In Year 8. a five year Ilfe and S2.OOO salvage value. The von has a four-year Ilfe end a SOOOO salvoge volue. The bulldlng nes 40- year life and a SIO,OOO salvage value. The company uses stralghtllne for the equloment and the building. The van IS fulty depreclated_ 28. Tre alarm systems sold In transactlon 8 were covered wlth a one-year warranty. Pactno estimated that the warranty cost wou'd be 2 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 the yeer_ The unemployment tox rate Is 4.5 percent end gross wages for all three employees exceeded $7,000. 30. Recognlzed the employer Social Securny' end Medlure payroll tax thet has not been peld on 58.000 of selarles expense. The trlal balance of Paclllo Securlty Servlces, Inc. as of January 1, Year 11, had the followlng normal balances 113, 718 , egg 28, ejs t on 12-1, 816 tab - the entries (2) through (24). the will need to StocktWders' Equity should indiated minus sign.) Cys Cysh fnm investing yetivities: from Activitie 11 pet ty Supplies Merch Eguipmen Building Salu t doubtful a d i inventory ( a g @ S gee) Accumulated depreciation x #yable e for- Employ x payable x pzyable payable unemploymen x payable Not u #yabl Bui1ding Bonds payable Retained gg, ggg a, ss2 g, egg 21, egg 29, egg 1, egg 92, 762 se,eeg se,eeg Trial Sheet Anal entries through (20) report net for the Then the through (32) s 31, 11. tab - Each entry iS automatically to the Balance tab - ending values from Ledger through the Trial Balance Income tab - ampdown to seQt the properly irauded on inume statement. Sheet tab a Shu: at 3:. Yer of Cash flo Prepare the cf cash for yr ended Dember 31, Year 11. tab - ntalstat mentS statement. and statement of cash model to Shaw how each t.nnction aff"ts the balance Sheet, income State of Trial e the eczunts to reportd on the income statement. The will appear for each on Y income or lus for the C Unadjusted Tots' Tots' Operating Net 'nc Non-opersting Item n adj u Balance Sht L iab i n Cypitl TotI Liabilities nd E. Ity un adjusted, 124,316 124.3% adjustd, or put-closing t the a o f the n the statement of esh flow for statement of cash Fl fro m Net from d d 31, 11. (A oun m ts to with a r.ting h s fro fro fi ncing E ctivitieE Net cysh f, Net Ending Effect of Balance Sht Liabilities + mti on Financial Statements - Ye Statenwnt of CF Statement of Cash