Have an accounting assignment due tomorrow and I can't figure out this question. I've attached the question and instructions given to me, including a template that isn't required to use but is there for a resource.
All solutions please
Excel Templates to accompany Fundamental Accounting Principles, 15th Edition, by Larson/Jensen/Dieckmann prepared by Ian Feltmate, Acadia University Given Data: Note: see 'Part 1' for the Unadjusted Trial balance a) Store supplies on hand at year-end b) Month's of insurance represented by balance in Prepaid insurance (insurance was in effect starting November 1, 2016) c) Estimated useful life of store equipment (years) Estimated resale value of equipment at the end of its life d) Merchandise inventory on hand October 31, 2017 $ 6,600 $ $ 12 20 47,600 29,800 Note: Rent and salaries expense are equally divided between the selling and administrative functions. Account Titles for Journal Entries: Cash Merchandise inventory Store supplies Prepaid insurance Store equipment Accumulated depreciation, store equipment Accounts payable Dallas End, capital Dallas End, withdrawals Sales Sales discounts Sales returns and allowances Cost of goods sold Depreciation expense, store equipment Salaries expense Interest expense Insurance expense Rent expense Store supplies expense Advertising expense
Excel Templates Problem 5-4B Part 1 Note: The following work sheet is not required for the question. It is presented to show the impact of the adjusting entries on the account balances. JOURNEY'S END COMPANY Work Sheet For the Year Ended October 31, 2017 Account Cash Merchandise inventory Store supplies Prepaid insurance Store equipment Accumulated depreciation, store equipment Accounts payable Dallas End, capital Dallas End, withdrawals Sales Sales discounts Sales returns and allowances Cost of goods sold Depreciation expense, store equipment Salaries expense Interest expense Insurance expense Rent expense Store supplies expense Advertising expense Totals Loss Totals Unadjusted Trial Balance Debit Credit 12,800 41,500 16,700 5,700 167,600 60,000 34,700 172,100 12,000 391,000 3,500 8,000 149,600 -0144,000 800 -056,000 -039,600 657,800 657,800 Adjustments Debit Credit Adjusted Trial Balance Debit Credit Balance Sheet & Statement of Changes Income Statement in Equity Debit Credit Debit Credit Excel Templates Problem 5-4B Part 1-Adjusting Entries Date 2017 a) Dec. 31 b) 31 c) 31 d) 31 Account Titles Debit Credit Excel Templates Problem 5-4B Part 2 JOURNEY'S END COMPANY Income Statement For Year Ended October 31, 2017 Sales Less: Sales discounts $ $ -0-0- $ -0-0-0-0- $ -0-0- $ -0-0- $ Gross profit from sales Operating expenses: Selling expenses: Salaries expense Total selling expenses General and administrative expenses: Salaries expense Total general and administrative expenses Total operating expenses Loss from operations Other revenues and expenses: Loss $ -0-0-0-0-0$ $ -0- -0- -0-0-0-0- Excel Templates Problem 5-4B Analysis Explain why Interest Expense is shown under Other revenues and expenses on the multiple-step income statement. (Place your answer on the sheet below. If you click near the middle of a sheet, a blinking cursor will appear in the upper left corner of the sheet. If you click on the curled portion of the sheet in the lower right corner, the sheet will be selected so that you can increase or decrease its size.)