Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

image text in transcribedimage text in transcribedimage text in transcribed
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.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Davis, Charles E., Elizabeth

1st Edition

0471699608, 978-0471699606

More Books

Students also viewed these Accounting questions

Question

6. How can hidden knowledge guide our actions?

Answered: 1 week ago

Question

7. How can the models we use have a detrimental effect on others?

Answered: 1 week ago