I need to prepare closing entries for both 2017 and 2018, 2018 income statement, 2018 balance sheet post closing entries (use 2017 post closing retained earnings balance as your beginning 2018 balance) , and 2018 cash flow statement in excel.
KELLEY ENTERPRISES 2017 Tridl Balance 2018 Trial Balance 4 Account Title 5 Cash and cash equivalents 6 Short-term investments Debit Credit Account Title Debit Credit $ 364 $ 155 S 218 S 500 307 S 3,363 Cash and cash equivalents Short-term investments Accounts receivable Merchandise inventories Prepaid expenses and other current assets Property and Equipment Accumulated depreciation and amortization Long term investments Goodwill Intangible assets, net of accumulated amortization 718 s 200 S 363 S 792 $ 170 5 4,767 Accounts receivable 8 Merchandise inventories Prepaid expenses and other current assets 0 Property and Equipment 11 Accumulated depreciation and amortization 2 Long term investments 13 Goodwill 4 Intangible assets, net of accumulated amortization 5 Accumulated amortization of intangible assets 6 Other assets Current installments of capital lease obligations 8 Accounts payable 19 Accrued payroll, bonus and other benefits due team members 0 Dividends payable 1 Other current liabilities 22 Long-term capital lease obligations, less current installments 23 Other long-term liabilities 4 Common Stock 25 Treasury Stock 26 Retained earnings (beginning of year) S 200 s 375 63 S 710 5 99 $ 143 710 $20IAccumulated amortization of intangible assets S 30 S 182 Other assets S 182 SCurrent installments of capital lease obligations 295 Accounts payable 173 436 I1 Accrued payroll, bonus and other benefits due team members S 487 S 50 S 627 45Dividends payable S473 Other current liabilities S 62Lone-term capital lease obligations, less current installments $ 658 Other lone-term liabilities S 2,904 Common Stock $ 1,342 3,194 $ 1.152 Treasury Stock S 1,214 S 45 $10,415 s 1521 Retained earnings (beginning of year) 27 Dividends 28 Sales 29 Cost of Goods Soled 0 Selling general and administrative expenses 5 2017 Dividends Sales Cost of Goods Sold Selling, general and administrative expenses Pre opening expenses Relocation, store closure and lease termination expenses sis,n89 16,061 $ 9,973 $ 4,472 $67 4632 Pre-opening expenses Relocation, store closure and lease termination expenses Trial Balance 2017 Closing Entries 2018 lncome Statement |2018 closing Ennes 2018 Balance Sheet 201e Cash O Type here to search 434 .11 2K Income tax expense 16 Other assets 182 5 182 Current installments of capital lease obligations 18 Accounts payable 19 Accrued payroll, bonus and other benefits due tea members 20 Dividends payable 21 Other current liabilities 22 Long-term capital lease obligations, less current installments 3 Other lone term liabalities 24 Common Stock 25 Treasury Stock 5 Retained earnings (beginning of year) 27 Dividends 23 Sales 9 Cost of Goods Sold 30 Selling, general and administrative expenses 3 Current installments of capital lease obligations 436Accrued payroll, bonus and other bnefits due tram members 473Other current liabilities S 473 S AR7 $ 50 S 295Accounts payable S 45Dividends payable 62 Long-term capital lease obligations, less current installments 658 0ther long trmliabilities S 6 1342 $ 3,194 s 2,017 $16,061 s 2904 ICommon Stock S 1,214 S 45 $10,415 S 1152 Treasury Stock 1,521 Retained earnings (beginning of year) Dividends $15,389 Sales 9,973 4,472 $ 67 $16 Cost of Goods Sold Selling, general and administrative expenses Pre-opening expenses Relocation, store closure and lease termination expenses S 4,632 Pre opening expenses 32 Relocation, store closure and lease termination expenses 33 investment and other income 4 Income tax expense 3) 36 37 401 , 1257 s 401 7Investment and other income S 342 Income tax expense Additional Information 4) The company purchased new equipment for $1,404, but there were no disposals of propertwlequipment 41 The company purchased $125 in new investments fincluding both short and long terml and sold no investments during the year 42 The company made payments of $3 on its capital lease obligations, and incurred new cepital lease obligations of $8 3 The company made no payments on its long term liabilities Any change in this account reflects new long-term liabilities incurred 4 The company sold stock during the year, and there were no additional transactions affecting the common stock account 45 The company purchased treasury stock during the year, and there were no additional transactions affecting the treasury stock account 46 The company paid dividents of $40 in 2017, and declared dividends of $45 The company paid dividents of $4S in 2018, and declared dividends of $50 Trial Balance 2017 Closng Entries 2018 Income Statement 2018 Closing Entries 2018 Balance Sheet 2018 Cash O Type here to search
