Use the information in the provided trial balance to create the following financial statements:

1. Use the information in the provided trial balance to create the following financial statements: a. 2019 Income Statement b. 2019 Balance Sheet C. 2019 Cash Flow Statement 2. Create ONE Excel Workbook with the following tabs: a. Tab 1: Trial Balance for 2018 and 2019 provided b. Tab 2: Closing Entries for 2018 Income Statement C. Tab 3: 2019 Income Statement d. Tab 4: Closing entries for 2019 e. Tab 5: 2019 Balance Sheet post-closing entries (Use the 2018 Retained Earnings balance as your beginning 2019 balance) f. Tab 6: 2019 Cash Flow Statement 3. Formulas: a. Use Excel to setup the financial statements by linking the values from the trial balance, b. Use Excel formulas to calculate all totals and sub-totals. 170 99 BT 2018 Trial Balance 2019 Trial Balance 4 Account Title Debit Credit II Account Title Debit Credit 5 Cash and cash equivalents 364 Cash and cash equivalents 563 6 Short-term investments $ 155 Short-term investments 200 7 Accounts receivable $ 218 Accounts receivable $ 363 $ (145) 8 Merchandise inventories $ 500 Merchandise inventories $ 792 $ (292) Prepaid expenses and other current assets 307 Prepaid expenses and other ourrent assets $ 137 10 Property and Equipment $ 3,363 Property and Equipment $ 4,767 : 11 Accumulated depreciation and amortization 200 Acoumulated depreciation and amortization $ 375 12 Long-term investments $ 63 Long-term investments $ 143 13 Goodwill $ 710 Goodwill 710 14 Intangible assets, net of accumulated amortization Intangible assets, net of accumulated amortization 99 15 Other assets 182 Other assets 182 16 Current installments of capital lease obligations Current installments of capital lease obligations 5 17 Accounts payable 295 Accounts payable 473 $ 178 18 Accrued payroll, bonus and other benefits due team members 436 Accrued payroll bonus and other benefits due team members 487 $ 51 19 Dividends payable Dividends payable 50 $ 5 20 Other current liabilities 473 Other current liabilities 627 $ 154 21 Long-term capital lease obligations, less current installments 62 Long-term capital lease obligations, less current installments 65 22 Other long-term liabilities 658 Other long-term liabilities $ 1,342 $ 684 23 Common Stock $ 2,904 Common Stock $ 3,194 $ 290 24 Treasury Stock $ 1152 Treasury Stock $ 1214 $ (62) 25 Retained earnings 1,541 Retained earnings $ 2,037 26 Dividends $ 40 Dividends 27 Sales $15.389 Sales $ 16,061 28 Cost of Goods Sold $ 9,973 Cost of Goods Sold $ 10,453 29 Selling, general and administrative expenses $ 4,472 Selling general and administrative expenses $ 4,670 30 Pre-opening expenses Pre-opening expenses 31 Relocation, store closure and lease termination expenses $ 16 Relocation, store closure and lease termination expenses 32 Investment and other income Investment and other income 33 Income tax expense $ 342 Income tax expense $ 363 $ 22,023 $ 22.023 $24.734 $24.734 45 45 $ 36 37 Additional Information: 38 39 The company purchased new equipment for $1,404, but there were no disposals of property/equipment. 40 The company purchased $125 in new investments (including both short and long-term), and sold no investments during the year. 41 The company made payments of $3 on its capital lease obligations, and incurred new capital lease obligations of $8. 42 The company made no payments on its long-term liabilities. Any change in this account reflects new long-term liabilities incurred. 43 The company sold stock during the year, and there were no additional transactions affecting the common stock account. 44 The company purchased treasury stock during the year, and there were no additional transactions affecting the treasury stock account 45 The company paid dividends of $45 during the year. 1. Use the information in the provided trial balance to create the following financial statements: a. 2019 Income Statement b. 2019 Balance Sheet C. 2019 Cash Flow Statement 2. Create ONE Excel Workbook with the following tabs: a. Tab 1: Trial Balance for 2018 and 2019 provided b. Tab 2: Closing Entries for 2018 Income Statement C. Tab 3: 2019 Income Statement d. Tab 4: Closing entries for 2019 e. Tab 5: 2019 Balance Sheet post-closing entries (Use the 2018 Retained Earnings balance as your beginning 2019 balance) f. Tab 6: 2019 Cash Flow Statement 3. Formulas: a. Use Excel to setup the financial statements by linking the values from the trial balance, b. Use Excel formulas to calculate all totals and sub-totals. 170 99 BT 2018 Trial Balance 2019 Trial Balance 4 Account Title Debit Credit II Account Title Debit Credit 5 Cash and cash equivalents 364 Cash and cash equivalents 563 6 Short-term investments $ 155 Short-term investments 200 7 Accounts receivable $ 218 Accounts receivable $ 363 $ (145) 8 Merchandise inventories $ 500 Merchandise inventories $ 792 $ (292) Prepaid expenses and other current assets 307 Prepaid expenses and other ourrent assets $ 137 10 Property and Equipment $ 3,363 Property and Equipment $ 4,767 : 11 Accumulated depreciation and amortization 200 Acoumulated depreciation and amortization $ 375 12 Long-term investments $ 63 Long-term investments $ 143 13 Goodwill $ 710 Goodwill 710 14 Intangible assets, net of accumulated amortization Intangible assets, net of accumulated amortization 99 15 Other assets 182 Other assets 182 16 Current installments of capital lease obligations Current installments of capital lease obligations 5 17 Accounts payable 295 Accounts payable 473 $ 178 18 Accrued payroll, bonus and other benefits due team members 436 Accrued payroll bonus and other benefits due team members 487 $ 51 19 Dividends payable Dividends payable 50 $ 5 20 Other current liabilities 473 Other current liabilities 627 $ 154 21 Long-term capital lease obligations, less current installments 62 Long-term capital lease obligations, less current installments 65 22 Other long-term liabilities 658 Other long-term liabilities $ 1,342 $ 684 23 Common Stock $ 2,904 Common Stock $ 3,194 $ 290 24 Treasury Stock $ 1152 Treasury Stock $ 1214 $ (62) 25 Retained earnings 1,541 Retained earnings $ 2,037 26 Dividends $ 40 Dividends 27 Sales $15.389 Sales $ 16,061 28 Cost of Goods Sold $ 9,973 Cost of Goods Sold $ 10,453 29 Selling, general and administrative expenses $ 4,472 Selling general and administrative expenses $ 4,670 30 Pre-opening expenses Pre-opening expenses 31 Relocation, store closure and lease termination expenses $ 16 Relocation, store closure and lease termination expenses 32 Investment and other income Investment and other income 33 Income tax expense $ 342 Income tax expense $ 363 $ 22,023 $ 22.023 $24.734 $24.734 45 45 $ 36 37 Additional Information: 38 39 The company purchased new equipment for $1,404, but there were no disposals of property/equipment. 40 The company purchased $125 in new investments (including both short and long-term), and sold no investments during the year. 41 The company made payments of $3 on its capital lease obligations, and incurred new capital lease obligations of $8. 42 The company made no payments on its long-term liabilities. Any change in this account reflects new long-term liabilities incurred. 43 The company sold stock during the year, and there were no additional transactions affecting the common stock account. 44 The company purchased treasury stock during the year, and there were no additional transactions affecting the treasury stock account 45 The company paid dividends of $45 during the year