Problem #2: Listed below are transactions for J. Fraser Electronics. Required: Indicate the impact each transaction (in dollars and +/-) and any subsequent adjustments required at year end will have on the current assets, current liability, net income and working capital of the company. If the transaction does not impact a particular item indicate "none" in the space provided. Example: on December 31, 2017, utilities of $300 have been incurred but not paid until January, 2018. 1. On December 31, 2017 Wages earned by the employees for the week totaled $7,500 but will not be paid until January 3. On December 1, 2017 J. Fraser borrowed $10,000 at 6%. Interest and principal are due February 1, 2018. (a) Impact of transaction on 12/1/17 and (b) accrual of interest on 12/31. 2. 3. On December 1, 2017 J. Frazer paid $24,000 for 12 months' rent. (a) Impact of payment for rent on 12/1 and (b) adjustment at year end on 12/31. 4. On December 31, 2017 J. Frazer received $2,000 cash for service to be performed next month. Current Liability Working Capital Current Asset Net Income Example + $300 - $300 - $300 None 2 (a) (b) 3 (a) (b) 4

Problem #2: Listed below are transactions for J. Fraser Electronics. Required: Indicate the impact each transaction (in dollars and +/-) and any subsequent adjustments required at year end will have on the current assets, current liability, net income and working capital of the company. If the transaction does not impact a particular item indicate "none" in the space provided. Example: on December 31, 2017, utilities of $300 have been incurred but not paid until January, 2018. 1. On December 31, 2017 Wages earned by the employees for the week totaled $7,500 but will not be paid until January 3. On December 1, 2017 J. Fraser borrowed $10,000 at 6%. Interest and principal are due February 1, 2018. (a) Impact of transaction on 12/1/17 and (b) accrual of interest on 12/31. 2. 3. On December 1, 2017 J. Frazer paid $24,000 for 12 months' rent. (a) Impact of payment for rent on 12/1 and (b) adjustment at year end on 12/31. 4. On December 31, 2017 J. Frazer received $2,000 cash for service to be performed next month. Current Liability Working Capital Current Asset Net Income Example + $300 - $300 - $300 None 2 (a) (b) 3 (a) (b) 4

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter3: Merchandising Company Worksheet (p2work)

Section: Chapter Questions

Problem 4R: The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as...

See similar textbooks

Similar questions

Reece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services Co.s accounting clerk prepared the following unadjusted trial balance at July 31, 2016: The data needed to determine year-end adjustments are as follows: a. Depreciation of building for the year, 6,400. b. Depreciation of equipment for the year, 2,800. c. Accrued salaries and wages at July 31, 900. d. Unexpired insurance at July 31, 1,500. e. Fees earned but unbilled on July 31, 10,200. f. Supplies on hand at July 31, 615. g. Rent unearned at July 31, 300. Instructions 1. Journalize the adjusting entries using the following additional accounts: Salaries and Wages Payable; Rent Revenue; Insurance Expense; Depreciation ExpenseBuilding; Depreciation ExpenseEquipment; and Supplies Expense. 2. Determine the balances of the accounts affected by the adjusting entries and preparean adjusted trial balance.
Reading and Interpreting Chipotles Financial Statements Refer to the financial statements for Chipotle reproduced in the chapter and answer the following questions. What was the companys net income for 2014? State Chipotles financial position on December 31, 2014, in terms of the accounting equation. By what amount did Leasehold improvements, property and equipment, net, increase during 2014? Explain what would cause an increase in this item.
Worksheet Victoria Company has the following account balances on December 31, 2019, prior to any adjustments: Additional adjustment information: (a) depreciation on buildings, 1,100; on equipment, 600; (b) bad debts expense, 240; (c) interest accumulated but not paid: on note payable, 50; on mortgage payable, 530 (this interest is due during the next accounting period); (d) insurance expired, 175; (e) salaries accrued but not paid 370; (f) rent was collected in advance and the performance obligation is now satisfied, 800; (g) office supplies cm hand at year-end, 230 (expensed when originally purchased earlier in the year); and (h) the income tax rate is 30% on current income and is payable in the first quarter of 2020. Required: 1. Transfer the account balances to a 10-column worksheet and prepare a trial balance. 2. Prepare the adjusting entries in the general journal and complete the worksheet. 3. Prepare the companys income statement, retained earnings statement, and balance sheet. 4. Prepare closing entries in the general journal.
The unadjusted trial balance of La Mesa Laundry at August 31, 2016, the end of the fiscal year, follows: The data needed to determine year-end adjustments are as follows: a. Wages accrued but not paid at August 31 are 2,200. b. Depreciation of equipment during the year is 8,150. c. Laundry supplies on hand at August 31 are 2,000. d. Insurance premiums expired during the year are 5,300. Instructions 1. For each account listed in the unadjusted trial balance, enter the balance in a T account. Identify the balance as Aug. 31 Bal. In addition, add T accounts for Wages Payable, Depreciation Expense, Laundry Supplies Expense, Insurance Expense, and Income Summary. 2. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. Add the accounts listed in part (1) as needed. 3. Journalize and post the adjusting entries. Identify the adjustments by Adj. and the new balances as Adj. Bal. 4. Prepare an adjusted trial balance. 5. Prepare an income statement, a statement of owners equity (no additional investments were made during the year), and a balance sheet. 6. Journalize and post the closing entries. Identify the closing entries by Clos. 7. Prepare a post-closing trial balance.
Reece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services accounting clerk prepared the following unadjusted trial balance at July 31, 2019: The data needed to determine year-end adjustments are as follows: Depreciation of building for the year, 6,400. Depreciation of equipment for the year, 2,800. Accrued salaries and wages at July 31, 900. Unexpired insurance at July 31, 1,500. Fees earned but unbilled on July 31, 10,200. Supplies on hand at July 31, 615. Rent unearned at July 31, 300. Instructions 1. Journalize the adjusting entries using the following additional accounts: Salaries and Wages Payable, Rent Revenue, Insurance Expense, Depreciation ExpenseBuilding, Depreciation ExpenseEquipment, and Supplies Expense. 2. Determine the balances of the accounts affected by the adjusting entries and prepare an adjusted trial balance.
The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. Open the file P2WORK from the website for this book at cengagebrain.com. Enter the formulas in the appropriate cells on the worksheet. Then enter the adjusting amounts in columns E and G. Also, in column D or F, insert the letter corresponding to the adjusting entry (ae). (Note: Not all textbooks handle the change in inventory as an adjustment. Use the method for handling inventory that is prescribed in your textbook.) Column A is frozen on the screen to assist you in completing requirement 3.
The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. Complete the income statement and balance sheet by entering formulas in columns J, K, L, and M that reference the appropriate cells in column H or I. Net income will be automatically calculated at the bottom of the income statement and balance sheet columns. Check to be sure that these numbers are the same. Enter your name in cell A1. Save the completed file as P2WORK3. Print the worksheet. Also print your formulas using landscape orientation and fit-to-1 page scaling. Check figure: Net income (cell J34), 37,902.
The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. In the space provided below, prepare an income statement, a capital statement (statement of owners equity), and a balance sheet. Use the corrected worksheet (P2WORK4) as a basis for your work. Assume no additional owner investments were made during the year.
Adjustment for depreciation The estimated amount of depredation on equipment for the current year is $133,000. a. How is the adjustment recorded? Indicate each account affected, whether the account is increased or decreased, and the amount of the increase or decrease. b. If the adjustment in (a) was omitted, which items would be erroneously stated on (1) the income statement for the year and (2) the balance sheet as of December 31?