ATC 5-10 Spreadsheet As Required Complete ATC 5-5 using an Excel spreadsheet. Use Excel problem ATC 59 structuring the spreadsheet. VE PROBLEM The trial balance of Pacilio Security Services Inc. as of January 1, 2015, had the normal balances: Cash $62,800 Accounts receivable 20,500 Supplies 150 Prepaid rent 2,000 Merchandise inventory (9 @$240) 2,160 Land 4,000 Accounts payable 980 Salaries payable 1,500 Common stock Retained earnings 50,000 39,190 Adjust 1. The 20. Re 21. Ro 22. Ac Require Ro 4 4 Pre and 2222182 Cle During 2015, Pacilio Security Services experienced the following transactions 1. Paid the salaries payable from 2014. 2. On January 15. purchased 20 standard alarm systems for cash at a cost of $250 d 3. On February 1, paid the accounts payable of $980, but not within the discount peri company uses the gross method.) 4. On March 1, leased a business van. Paid $4,800 for one yests lease in advance 5. Paid $7,200 on May 1 for one year's rent on the office in acc 6. Purchased with cash $500 of supplies to be used over next several mont business. 7. Purchased with cash another 25 alarm systems on Augus i for resale at a co each. 8. On September 5, purchased on account 30 standard alarm systems at a cost of $3 9. Installed 60 standard alarm systems for $33,000. $22,000 of the sales were on a $11,000 were cash sales. (Note: Be sure to record cost of goods sold using the p FIFO method.) 10. Made a full refund to a dissatisfied customer who returned her alarm system. The been a cash sale for $550 with a cost of $260. 11. Paid installers and other employees a total of $21,000 cash for salaries 12. Sold $45,000 of monitoring services during the year. The services are billed to the each month. 13. Sold an additional monitoring service for $1,200 for one year's service. The co the full amount of $1,200 on October 1. 14. Collected $74,000 of accounts receivable during the year. 15. Paid an additional $6,000 to settle some of the accounts payable. 16. Paid $3,500 of advertising expense during the year. 17. Paid $2,320 of utilities expense for the year. 18. Paid a dividend of $15,000 to the shareholders.