6. (20 points) Preparing financial statements from an adjusted trial balance North Star Inc. Adjusted Trial Balance 31-Dec-18 185,000 Allowance for Doubtl Accounts Inventory (as of 12/31/18) Supplies Equipment 2,400 275,000 355,000 27s Building Accumulated Deperciatbn- Building 195,000 29,500 Accounts Payable Salaries and Wages Payable $O.10 Common Stock APIC Retained Earnings 145,000 Selling Expenses Administratve Expenses Income Tax Expense 289,300 s 245,000 $ 286,000 75,000 52,049,950 EXCEL >Use of EXCEL is required. Create your own EXCEL file to complete the five requirements (below). Then >into WORD (Refer to example on page 3) Required: 1. 2. 3. 4. 5. Prepare the income Statement (Multiple Step Format) Prepare the Statement of Retained Earnings Prepare the Balance Sheet (Classified Format) Prepare the necessary year-end closing entries Prepare the Year End Trial Balance