Include in an excel sheet 1. Journal entries 2.ledgers 3.Worksheet -trial balance -adjusted trial balance -income statement -balance sheet 4. Adjustments -journal -worksheet -ledge 5.financial statements -income -owner equity -balance sheet 6.closing entries Journal and ledger As the bookkeeper of Palmer's Plowing, you have been asked to complete the entire accounting cycle for Palmer from the following information. 201X Jan. 1 Palmer invested exist9,000 cash and exist9,000 worth of snow equipment into the plowing company. 1 Paid 5 months' rent in advance for garage space, exist4,000. 4 Purchased office equipment from Lewis Corp. For exist9, 600 on account. 6 Purchased snow suppliers for exist600 cash. 8 Collected exist11,000 from plowing local shopping centers. 12 Palmer Mao withdrew exist8,000 from the business for personal use. 20 Plowed Riverton Co. Parking lots, payment not to be received until March, exist8,000. 26 Paid salaries to employees, exist2, 100. 28 Paid Lewis Corp. One-half amount owed for office equipment. 29 Advertising bill received from Taft Co. but will not be paid until March, exist300. 30 Paid telephone bill, exist180. Use the following chart of accounts. Adjustment Data a. Snow supplies on hand, exist100. b. Rent expired, exist800. c. Depreciation on office equipment, exist160: (exist9, 600/5 yr = exist1, 920/12 mo. = exist160). d. Depreciation on snow equipment, exist150: 9,000/5 yr = exist1, 800/12 mo. = exist150). e. Accrued salaries, exist340