Can somebody help me with my assignment as soon as possible? I get stuck with some adjusting journal entry.

Broadening Your Perspective 4-7 Natalie reviews the updated trial balance presented below: KOEBEL'S FAMILY BAKERY LTD. Trial Balance June 30, 2014 Debit Cash $17,117 Accounts receivable 11,380 Merchandise inventory 17,665 Supplies 4,005 Prepaid insurance 25,160 Land 87,000 Buildings 162,000 Accumulated depreciationbuildings Equipment 39,144 Accumulated depreciation equipment Vehicles 48,100 Accounts payable Unearned revenue Bank loan payable Mortgage payable Common shares Retained earnings Dividends 35,000 Rent revenue Sales Sales returns and allowances 5,420 Cost of goods sold 93,719 Salaries expense 278,183 Freight out 17,240 Utilities expense 10,700 Advertising expense 9,350 Property tax expense 6,200 Interest expense 4,855 Income tax expense 31,700 Total $903,938 Credit $135,000 12,400 6,665 458 23,800 55,200 350 47,829 5,520 616,716 $903,938 She recalls from her introductory accounting class that there are some adjustments that need to be prepared. She gathers up as much information as she can to enable the following adjusting journal entries to be prepared on June 30, Koebel's Family Bakery's year end: 2. Depreciation is to be recorded on the building for the year. The building was purchased 26 years ago and has an estimated useful life of 30 years. 3. Depreciation is to be recorded on the equipment for the year. The equipment was purchased three years ago at a cost of $37,200 and has an estimated useful life of six years. Recall as well that there was new baking equipment purchased on June 16 at a cost of $1,944. One month's depreciation is to be recorded on this equipment; its useful life is six years. 4. Depreciation is to be recorded on the delivery truck, recorded in the Vehicles account. The delivery truck was purchased on January 1 at a cost of $48,100 and has an estimated useful life of five years. 9. During the last week of June an unexpected order was received from Biscuits to prepare 750 dozen oatmeal chocolate chip cookies. The order was filled and an invoice was prepared, $1,600. This invoice was not included in the accounting records at June 30. Prepare the adjusting journal entries required at June 30. (Record journal entries in the order presented in the problem. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter "0" for the amounts.) Broadening Your Perspective 5-7 (Part Level Submission) Natalie reviews the updated trial balance presented below: KOEBEL'S FAMILY BAKERY LTD. Trial Balance June 30, 2014 Debit Cash $16,961 Accounts receivable 11,460 Merchandise inventory 17,770 Supplies 3,970 Prepaid insurance 24,940 Land 86,000 Buildings 161,700 Accumulated depreciationbuildings Equipment $134,750 38,472 Accumulated depreciation equipment Vehicles Accounts payable Credit 12,200 47,650 6,710 Unearned revenue 454 Bank loan payable 23,900 Mortgage payable 55,400 Common shares Retained earnings 355 46,490 Dividends 35,500 Rent revenue 5,460 Sales Sales returns and allowances Cost of goods sold Salaries expense 614,143 5,460 92,933 277,214 Freight out 17,170 Utilities expense 10,600 Advertising expense 9,400 Property tax expense 6,250 Interest expense 4,812 Income tax expense Total 31,600 0 $899,862 $899,862 She recalls from her introductory accounting class that there are some adjustments that need to be prepared. She gathers up as much information as she can to enable the following adjusting journal entries to be prepared on June 30, Koebel's Family Bakery's year end: 1. A count reveals that $545 worth of advertising brochures, recorded in the Supplies account, have been distributed during the month of June. 2. Depreciation is to be recorded on the building for the year. The building was purchased 26 years ago and has an estimated useful life of 30 years. 3. Depreciation is to be recorded on the equipment for the year. The equipment was purchased three years ago at a cost of $36,600 and has an estimated useful life of six years. Recall as well that there was new baking equipment purchased on June 16 at a cost of $1,872. One month's depreciation is to be recorded on this equipment; its useful life is six years. 4. Depreciation is to be recorded on the delivery truck, recorded in the Vehicles account. The delivery truck was purchased on January 1 at a cost of $47,650 and has an estimated useful life of five years. 5. Interest on the bank loan and mortgage payable was last paid on June 25. Interest accrued on the five days remaining in June is $44. 6. One month's worth of the 12-month property insurance policy purchased for $14,040 on June 2 has expired. 7. Six months' worth of the prepaid vehicle insurance has also expired. Recall that this insurance was purchased on January 1 for an annual cost of $10,900. 8. At the end of June, heat and electricity on the building, $1,025, was owed. Amounts are to be paid by July 15. (Hint: Use the Utilities Expense account). 9. During the last week of June an unexpected order was received from Biscuits to prepare 750 dozen oatmeal chocolate chip cookies. The order was filled and an invoice was prepared, $1,600. This invoice was not included in the accounting records at June 30. 10. Salaries for employees were paid on June 30. There were two part-time employees working in the bake shop on June 30 who forgot to submit their timesheets for that day. They both worked an eight-hour shift and were paid $11 an hour. Natalie and her parents, Janet and Brian, are anxious to examine and analyze the updated financial statements. Natalie has obtained a copy of the financial statements of a major competitor, a public company, and has been able to determine a number of their ratios: the current ratio is 2:1, the gross profit margin is 75%, and the profit margin is 15%. The following information represents additional adjustment data that must be recorded to enable the preparation of Koebel's year-end financial statements. Koebel's uses a perpetual inventory system. 1. The physical count of inventory indicates $18,800 on hand at June 30. 2. Of the bank loan payable, $7,100 is to be paid in the next year; the remainder is non-current. 3. Of the mortgage payable, $5,400 is to be paid in the next year; the remainder is non-current. 4. Natalie estimates that an additional $926 of corporate income tax is owed at June 30. Record any required adjusting entries from the above data. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Prepare an adjusted trial balance at June 30. Prepare a multiple-step income statement for the year ended June 30. KOEBEL'S FAMILY BAKERY LTD. Income Statement Year Ended June 30, 2014 Sales Revenue $ : $ $ Don't show me this message again for the assignment Calculate the ending retained earnings for the year. (List items that increase retained earnings first. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) KOEBEL'S FAMILY BAKERY LTD. Retained Earnings Year Ended June 30, 2014 $ : : $ Don't show me this message again for the assignment Prepare a statement of financial position as at June 30. (List current assets in order of liquidity. List Property, Plant and Equipment in order of Land, Buildings and Equipment.) KOEBEL'S FAMILY BAKERY LTD. Statement of Financial Position June 30, 2014 Assets $ $ $ : $ : $ : $ Liabilities and Shareholders' Equity $ $ $ Don't show me this message again for the assignment Calculate the current ratio, gross profit margin, and profit margin for the year. (Round answers to 1 decimal place, e.g. 15.2.) Koebel Current ratio :1 Gross profit margin % Profit margin % Compared with Koebel's major competitor, are Koebel's Family Bakery's ratios better or worse than their competitor? Koebel's Family Bakery's ratios is than their competitor Broadening Your Perspective 4-7 Natalie reviews the updated trial balance presented below: KOEBEL'S FAMILY BAKERY LTD. Trial Balance June 30, 2014 Debit Cash $17,117 Accounts receivable 11,380 Merchandise inventory 17,665 Supplies 4,005 Prepaid insurance 25,160 Land 87,000 Buildings 162,000 Accumulated depreciationbuildings Equipment 39,144 Accumulated depreciation equipment Vehicles 48,100 Accounts payable Unearned revenue Bank loan payable Mortgage payable Common shares Retained earnings Dividends 35,000 Rent revenue Sales Sales returns and allowances 5,420 Cost of goods sold 93,719 Salaries expense 278,183 Freight out 17,240 Utilities expense 10,700 Advertising expense 9,350 Property tax expense 6,200 Interest expense 4,855 Income tax expense 31,700 Total $903,938 Credit $135,000 12,400 6,665 458 23,800 55,200 350 47,829 5,520 616,716 $903,938 She recalls from her introductory accounting class that there are some adjustments that need to be prepared. She gathers up as much information as she can to enable the following adjusting journal entries to be prepared on June 30, Koebel's Family Bakery's year end: 2. Depreciation is to be recorded on the building for the year. The building was purchased 26 years ago and has an estimated useful life of 30 years. 3. Depreciation is to be recorded on the equipment for the year. The equipment was purchased three years ago at a cost of $37,200 and has an estimated useful life of six years. Recall as well that there was new baking equipment purchased on June 16 at a cost of $1,944. One month's depreciation is to be recorded on this equipment; its useful life is six years. 4. Depreciation is to be recorded on the delivery truck, recorded in the Vehicles account. The delivery truck was purchased on January 1 at a cost of $48,100 and has an estimated useful life of five years. 9. During the last week of June an unexpected order was received from Biscuits to prepare 750 dozen oatmeal chocolate chip cookies. The order was filled and an invoice was prepared, $1,600. This invoice was not included in the accounting records at June 30. Prepare the adjusting journal entries required at June 30. (Record journal entries in the order presented in the problem. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter "0" for the amounts.) Broadening Your Perspective 5-7 (Part Level Submission) Natalie reviews the updated trial balance presented below: KOEBEL'S FAMILY BAKERY LTD. Trial Balance June 30, 2014 Debit Cash $16,961 Accounts receivable 11,460 Merchandise inventory 17,770 Supplies 3,970 Prepaid insurance 24,940 Land 86,000 Buildings 161,700 Accumulated depreciationbuildings Equipment $134,750 38,472 Accumulated depreciation equipment Vehicles Accounts payable Credit 12,200 47,650 6,710 Unearned revenue 454 Bank loan payable 23,900 Mortgage payable 55,400 Common shares Retained earnings 355 46,490 Dividends 35,500 Rent revenue 5,460 Sales Sales returns and allowances Cost of goods sold Salaries expense 614,143 5,460 92,933 277,214 Freight out 17,170 Utilities expense 10,600 Advertising expense 9,400 Property tax expense 6,250 Interest expense 4,812 Income tax expense Total 31,600 0 $899,862 $899,862 She recalls from her introductory accounting class that there are some adjustments that need to be prepared. She gathers up as much information as she can to enable the following adjusting journal entries to be prepared on June 30, Koebel's Family Bakery's year end: 1. A count reveals that $545 worth of advertising brochures, recorded in the Supplies account, have been distributed during the month of June. 2. Depreciation is to be recorded on the building for the year. The building was purchased 26 years ago and has an estimated useful life of 30 years. 3. Depreciation is to be recorded on the equipment for the year. The equipment was purchased three years ago at a cost of $36,600 and has an estimated useful life of six years. Recall as well that there was new baking equipment purchased on June 16 at a cost of $1,872. One month's depreciation is to be recorded on this equipment; its useful life is six years. 4. Depreciation is to be recorded on the delivery truck, recorded in the Vehicles account. The delivery truck was purchased on January 1 at a cost of $47,650 and has an estimated useful life of five years. 5. Interest on the bank loan and mortgage payable was last paid on June 25. Interest accrued on the five days remaining in June is $44. 6. One month's worth of the 12-month property insurance policy purchased for $14,040 on June 2 has expired. 7. Six months' worth of the prepaid vehicle insurance has also expired. Recall that this insurance was purchased on January 1 for an annual cost of $10,900. 8. At the end of June, heat and electricity on the building, $1,025, was owed. Amounts are to be paid by July 15. (Hint: Use the Utilities Expense account). 9. During the last week of June an unexpected order was received from Biscuits to prepare 750 dozen oatmeal chocolate chip cookies. The order was filled and an invoice was prepared, $1,600. This invoice was not included in the accounting records at June 30. 10. Salaries for employees were paid on June 30. There were two part-time employees working in the bake shop on June 30 who forgot to submit their timesheets for that day. They both worked an eight-hour shift and were paid $11 an hour. Natalie and her parents, Janet and Brian, are anxious to examine and analyze the updated financial statements. Natalie has obtained a copy of the financial statements of a major competitor, a public company, and has been able to determine a number of their ratios: the current ratio is 2:1, the gross profit margin is 75%, and the profit margin is 15%. The following information represents additional adjustment data that must be recorded to enable the preparation of Koebel's year-end financial statements. Koebel's uses a perpetual inventory system. 1. The physical count of inventory indicates $18,800 on hand at June 30. 2. Of the bank loan payable, $7,100 is to be paid in the next year; the remainder is non-current. 3. Of the mortgage payable, $5,400 is to be paid in the next year; the remainder is non-current. 4. Natalie estimates that an additional $926 of corporate income tax is owed at June 30. Question 1: Record any required adjusting entries from the above data. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Question 2: Prepare an adjusted trial balance at June 30. Calculate the current ratio, gross profit margin, and profit margin for the year. (Round answers to 1 decimal place, e.g. 15.2.) Koebel Current ratio :1 Gross profit margin % Profit margin % Compared with Koebel's major competitor, are Koebel's Family Bakery's ratios better or worse than their competitor? Koebel's Family Bakery's ratios is than their competitor