12 Question based on the adjusted trial balance on the text page, prepare the Income Statement, Retained Earnings Statement, and Balmace Sheet for Pepper Shores, Inc. for the fiscal 12 year ending December 31, 2019 wing this Excel spreadsheet You tout follow the all of these instructions including the ones provided for Excel. Prepare the financial statements pure sects in this same Ixcel document 14 The information from Pepper Shores loc'strul balance is to be entered onto an EXCEL preadsheet. Formulas and links to the Trial Balance are to be created in order to generate the s tree financial statements Basic instructions we given in this case. If you need additional help, please see your instructor Pepper Shores, Inc. Adjusted Trial Balance December 31, 2019 Credit Debit $ 43,500 59,000 $ 5.100 18.600 2,500 2,000 100,000 700,000 340,000 400,000 Cash Accounts Receivable Allowance for Doubtful Accounts Merchandise Inventory Supplies Prepaid Insurance Land Building Accumulated Depreciation - Building Equipment Accumulated Depreciation - Equipment Accounts Payable Uneamed Revenue Salaries Payable Notes Payable, due May 31, 2020 Mortgage Payable due Dec. 31, 2025 Common Stock 2 Retained Eamings 3 Dividends -4 Sales 5 Sales Retums & Allowances 56 Sales Discounts 7 Costs of Goods Sold 58 Salaries Expense 59 Depreciation Expense 50 Freight Out 61 Advertising Expense 62 Utilities Expense 163 Supplies Expense 154 Bad Debt Expense m55 Interest Revenue 66 Gain on sale of Equipment 167 Loss on sale of Building 168 Interest Expense 168 Total 170 165,000 42,400 20,500 1,200 25,000 230,000 275,000 222.000 45,000 215,000 4.300 1,700 110,000 30,000 15,000 500 3,300 2.700 1,500 2,000 3,700 2,000 3,500 1.800