Prepare an unadjusted trial balance as of August 31, 2015. 1. The Sunflower Wholesale Company began operations on August 1, 2015. The following transactions took place during the month of August. a. Owners invested P50,000 cash in the corporation in exchange for 5,000 shares of equity capital. b. Equipment was purchased for P20,000 cash. c. On the first day of August, P6,000 rent on a building was paid for the months of August and September d. Merchandise costing P38,000 was purchased on account. (The company uses the perpetual inventory system.) e. P30,000 was borrowed from a local bank, and a note payable was signed. f. Credit sales for the month were P40,000. The cost of merchandise sold was P22,000 g P15,000 was collected on account from customers. h. P20,000 was paid on account to suppliers of merchandise. i. Salaries of P7,000 were paid to employees for August. j. A bill for P2,000 was received from local utility company for the month of August. k. P20,000 cash was loaned to another company, evidenced by a note receivable. I. The corporation paid its shareholders a cash dividend of P1,000.

Prepare an unadjusted trial balance as of August 31, 2015. 1. The Sunflower Wholesale Company began operations on August 1, 2015. The following transactions took place during the month of August. a. Owners invested P50,000 cash in the corporation in exchange for 5,000 shares of equity capital. b. Equipment was purchased for P20,000 cash. c. On the first day of August, P6,000 rent on a building was paid for the months of August and September d. Merchandise costing P38,000 was purchased on account. (The company uses the perpetual inventory system.) e. P30,000 was borrowed from a local bank, and a note payable was signed. f. Credit sales for the month were P40,000. The cost of merchandise sold was P22,000 g P15,000 was collected on account from customers. h. P20,000 was paid on account to suppliers of merchandise. i. Salaries of P7,000 were paid to employees for August. j. A bill for P2,000 was received from local utility company for the month of August. k. P20,000 cash was loaned to another company, evidenced by a note receivable. I. The corporation paid its shareholders a cash dividend of P1,000.

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 1R: The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as...

See similar textbooks

Similar questions

Income Statement and Balance Sheet Fort Worth Corporation began business in January 2016 as a commercial carpet-cleaning and drying service. Shares of stock were issued to the owners in exchange for cash. Equipment was purchased by making a down payment in cash and signing a note payable for the balance. Services are performed for local restaurants and office buildings on open account, and customers are given 15 days to pay their accounts. Rent for office and storage facilities is paid at the beginning of each month. Salaries and wages are paid at the end of the month. The following amounts are from the records of Fort Worth Corporation at the end of its first month of operations: Required Prepare an income statement for the month ended January 31, 2016. Prepare a balance sheet at January 31, 2016. What information would you need about Notes Payable to fully assess Fort Worths longterm viability? Explain your answer.
The transactions completed by PS Music during June 2018 were described at the end of Chapter 1. The following transactions were completed during July, the second month of the businesss operations: July 1. Peyton Smith made an additional investment in PS Musk in exchange for common stock by depositing 5,000 in PS Music s checking account. 1. Instead of continuing to share office space with a local real estate agency, Peyton decided to rent office space near a local music store. Paid rent for July, 1,750. 1. Paid a premium of 2,700 for a comprehensive insurance policy covering liability, theft, and fire. The policy covers a one-year period. 2. Received 1,000 on account. 3. On behalf of PS Music, Peyton signed a contract with a local radio station, KXMD, to provide guest spots for the next three months. The contract requires PS Music to provide a guest disc jockey for 80 hours per month for a monthly fee of 3,600. Any additional hours beyond 80 will be billed to KXMD at 40 per hour. In accordance with the contract, Peyton received 7,200 from KXMD as an advance payment for the first two months. 3. Paid 250 on account. 4. Paid an attorney 900 for reviewing the July 3 contract with KXMD. (Record as Miscellaneous Expense.) 5. Purchased office equipment on account from Office Mart, 7,500. 8. Paid for a newspaper advertisement, 200. 11. Received 1,000 for serving as a disc jockey for a party. 13. Paid 700 to a local audio electronics store for rental of digital recording equipment. 14. Paid wages of 1,200 to receptionist and part-time assistant. Enter the following transactions on lage 2 of the two-column journal: 16. Received 2,000 for serving as a disc jockey for a wedding reception. 18. Purchased supplies on account, 850. 21. Paid 620 to Upload Music for use of its current music demos in making various music sets. 22. Paid 800 to a local radio station to advertise the services of PS Music twice daily for the remainder of July. 23. Served as disc jockey for a party for 2,500. Received 750, with the remainder due August 4, 2018. 27. Paid electric bill, 915. 28. Paid wages of 1,200 to receptionist and part-time assistant. 29. Paid miscellaneous expenses, 540. 30. Served as a disc jockey for a charity ball for 1,500. Received 500, with the remainder due on August 9, 2018. 31. Received 3,000 for serving as a disc jockey for a party. July 31. Paid 1,400 royalties (music expense) to National Music Clearing for use of various artists music during July. 31. Paid dividends, 1,250. PS Musics chart of accounts and the balance of accounts as of July 1, 2018 (all normal balances), are as follows: 11 Cash 3,920 41 Fees Earned 6,200 12 Accounts Receivable 1,000 50 Wages Expense 400 14 Supplies 170 51 Office Rent Expense 800 15 Prepaid Insurance 52 Equipment Rent Expense 675 17 Office Equipment 53 Utilities Expense 300 21 Accounts Payable 250 54 Music Expense 1,590 23 Unearned Revenue 55 Advertising Expense 500 31 Common Stock 4,000 56 Supplies Expense 180 33 Dividends 500 59 Miscellaneous Expense 415 Instructions 1. Enter the July 1, 2018, account balances in the appropriate balance column of a four-column account. Write Balance in the Item column, and place a check mark () in the Posting Reference column. {Hint: Verify the equality of the debit and credit balances in the ledger before proceeding with the next instruction.) 2. Analyze and journalize each transaction in a two-column journal beginning on Page 1, omitting journal entry explanations. 3. Post the journal to the ledger, extending the account balance to the appropriate balance column after each posting. 4. Prepare an unadjusted trial balance as of July 31, 2018.
Journal entries and trial balance On August 1, 20Y7, Rafael Masey established Planet Realty, which completed the following transactions during the month: a. Rafael Masey transferred cash from a personal bank account to an account to be used for the business in exchange for common stock, 17,500. b. Purchased supplies on account, 2,300. c. Earned sales commissions, receiving cash, 13,300. d. Paid rent on office and equipment for the month, 3,000. e. Paid creditor on account, 1,150. f. Paid dividends, 1,800. g. Paid automobile expenses (including rental charge) for month, 1,500, and miscellaneous expenses, 400. h. Paid office salaries, 2,800. i. Determined that the cost of supplies used was 1,050. Instructions 1. Journalize entries for transactions (a) through (i), using the following account titles: Cash, Supplies, Accounts Payable, Common Stock, Dividends, Sales Commissions, Rent Expense, Office Salaries Expense, Automobile Expense, Supplies Expense, Miscellaneous Expense. Journal entry explanations may be omitted. 2. Prepare T accounts, using the account titles in (1). Post the journal entries to these accounts, placing the appropriate letter to the left of each amount to identify the transactions. Determine the account balances, after all posting is complete. Accounts containing only a single entry do not need a balance. 3. Prepare an unadjusted trial balance as of August 31, 20Y7. 4. Determine the following: a. Amount of total revenue recorded in the ledger. b. Amount of total expenses recorded in the ledger. c. Amount of net income for August. 5. Determine the increase or decrease in retained earnings for August.
The transactions completed by PS Music during June 20Y5 were described at the end of Chapter 1. The following transactions were completed during July, the second month of the businesss operations: July 1. Peyton Smith made an additional investment in PS Music in exchange for common stock by depositing 5,000 in PS Musics checking account. 1. Instead of continuing to share office space with a local real estate agency, Peyton decided to rent office space near a local music store. Paid rent for July, 1,750. 1. Paid a premium of 2,700 for a comprehensive insurance policy covering liability, theft, and fire. The policy covers a one-year period. 2. Received 1,000 on account. 3. On behalf of PS Music, Peyton signed a contract with a local radio station, KXMD, to provide guest spots for the next three months. The contract requires PS Music to provide a guest disc jockey for 80 hours per month for a monthly fee of 3,600. Any additional hours beyond 80 will be billed to KXMD at 40 per hour. In accordance with the contract, Peyton received 7,200 from KXMD as an advance payment for the first two months. 3. Paid 250 on account. 4. Paid an attorney 900 for reviewing the July 3 contract with KXMD. (Record as Miscellaneous Expense.) 5. Purchased office equipment on account from Office Mart, 7,500. 8. Paid for a newspaper advertisement, 200. 11. Received 1,000 for serving as a disc jockey for a party. 13. Paid 700 to a local audio electronics store for rental of digital recording equipment. 14. Paid wages of 1,200 to receptionist and part-time assistant. Enter the following transactions on Page 2 of the two-column journal: 16. Received 2,000 for serving as a disc jockey for a wedding reception. 18. Purchased supplies on account, 850. 21. Paid 620 to Upload Music for use of its current music demos in making various music sets. 22. Paid 800 to a local radio station to advertise the services of PS Music twice daily for the remainder of July. 23. Served as disc jockey for a party for 2,500. Received 750, with the remainder due August 4, 20Y5. 27. Paid electric bill, 915. 28. Paid wages of 1,200 to receptionist and part-time assistant. 29. Paid miscellaneous expenses, 540. 30. Served as a disc jockey for a charity ball for 1,500. Received 500, with the remainder due on August 9, 20Y5. 31. Received 3,000 for serving as a disc jockey for a party. 31. Paid 1,400 royalties (music expense) to National Music Clearing for use of various artists music during July. 31. Paid dividends, 1,250. PS Musics chart of accounts and the balance of accounts as of July 1, 20Y5 (all normal balances), are as follows: Instructions 1. Enter the July 1, 20Y5, account balances in the appropriate balance column of a four-column account. Write Balance in the Item column, and place a check mark () in the Posting Reference column. (Hint: Verify the equality of the debit and credit balances in the ledger before proceeding with the next instruction.) 2. Analyze and journalize each transaction in a two-column journal beginning on Page 1, omitting journal entry explanations. 3. Post the journal to the ledger, extending the account balance to the appropriate balance column after each posting. 4. Prepare an unadjusted trial balance as of July 31, 20Y5.
Transactions using accrual accounting Terry Mason organized The Fifth Season at the beginning of February 20Y4. During February, The Fifth Season entered into the following transactions: a. Terry Mason invested $15000 in The Fifth Season in exchange for common stock. h. Paid $2,700 on February 1 for an insurance premium on a 1-year policy. c. Purchased supplies on account. $900. d. Received fees of $28500 during February. e. Paid expenses as follows: wages. $10,800; rent, $3,200; utilities, $1,400; and miscellaneous, $1,600. f. Paid dividends of $4,000. Record the preceding transactions using the integrated financial statement framework. Alt er each transaction, you should enter a balance for each item.
Using the income statement for Sentinel Travel Service shown in Practice Exercise 1-4B, prepare a statement of owners equity for the year ended August 31, 2016. Barb Schroeder, the owner, invested an additional 36,000 in the business during the year and withdrew cash of 18,000 for personal use. Barb Schroeder, capital as of September 1, 2015, was 380,000.
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.
Income Statement and Balance Sheet Green Bay Corporation began business in July 2016 as a commercial fishing operation and a passenger service between islands. Shares of stock were issued to the owners in exchange for cash. Boats were purchased by making a down payment in cash and signing a note payable for the balance. Fish are sold to local restaurants on open account, and customers are given 15 days to pay their account. Cash fares are collected for all passenger traffic. Rent for the dock facilities is paid at the beginning of each month. Salaries and wages are paid at the end of the month. The following amounts are from the records of Green Bay Corporation at the end of its first month of operations: Required Prepare an income statement for the month ended July 31, 2016. Prepare a balance sheet at July 31, 2016. What information would you need about Notes Payable to fully assess Green Bays long-term viability? Explain your answer.
The transactions completed by PS Music during June 2019 were described at the end of Chapter 1. The following transactions were completed during July, the second month of the businesss operations: July 1.Peyton Smith made an additional investment in PS Music by depositing 5,000 in PS Musics checking account. 1.Instead of continuing to share office space with a local real estate agency, Peyton decided to rent office space near a local music store. Paid rent for July, 1,750. 1.Paid a premium of 2,700 for a comprehensive insurance policy covering liability, theft, and fire. The policy covers a one-year period. 2.Received 1,000 cash from customers on account. 3.On behalf of PS Music, Peyton signed a contract with a local radio station, KXMD, to provide guest spots for the next three months. The contract requires PS Music to provide a guest disc jockey for 80 hours per month for a monthly fee of 3,600. Any additional hours beyond 80 will be billed to KXMD at 40 per hour. In accordance with the contract, Peyton received 7,200 from KXMD as an advance payment for the first two months. 3.Paid 250 to creditors on account. 4.Paid an attorney 900 for reviewing the July 3 contract with KXMD. (Record as Miscellaneous Expense.) 5.Purchased office equipment on account from Office Mart, 7,500. 8.Paid for a newspaper advertisement, 200. 11.Received 1,000 for serving as a disc jockey for a party. 13.Paid 700 to a local audio electronics store for rental of digital recording equipment. 14.Paid wages of 1,200 to receptionist and part-time assistant. Enter the following transactions on Page 2 of the two-column journal: 16.Received 2,000 for serving as a disc jockey for a wedding reception. 18.Purchased supplies on account, 850. July 21. Paid 620 to Upload Music for use of its current music demos in making various music sets. 22.Paid 800 to a local radio station to advertise the services of PS Music twice daily for the remainder of July. 23.Served as disc jockey for a party for 2,500. Received 750, with the remainder due August 4, 2019. 27.Paid electric bill, 915. 28.Paid wages of 1,200 to receptionist and part-time assistant. 29.Paid miscellaneous expenses, 540. 30.Served as a disc jockey for a charity ball for 1,500. Received 500, with the remainder due on August 9, 2019. 31.Received 3,000 for serving as a disc jockey for a party. 31.Paid 1,400 royalties (music expense) to National Music Clearing for use of various artists music during July. 31.Withdrew 1,250 cash from PS Music for personal use. PS Musics chart of accounts and the balance of accounts as of July 1, 2019 (all normal balances), are as follows: Instructions 1. Enter the July 1, 2019, account balances in the appropriate balance column of a four-column account. Write Balance in the Item column and place a check mark () in the Posting Reference column. (Hint: Verify the equality of the debit and credit balances in the ledger before proceeding with the next instruction.) 2. Analyze and journalize each transaction in a two-column journal beginning on Page 1, omitting journal entry explanations. 3. Post the journal to the ledger, extending the account balance to the appropriate balance column after each posting. 4. Prepare an unadjusted trial balance as of July 31, 2019.
The transactions completed by PS Music during June 2019 were described at the end of Chapter 1. The following transactions were completed during July, the second month of the business's operations: July 1. Peyton Smith made an additional investment in PS Music by depositing 5,000 in PS Music's checking account. 1. Instead of continuing to share office space with a local real estate agency, Peyton decided to rent office space near a local music: store. Paid rent for July, 1,750. 1. Paid a premium of 2,700 for a comprehensive insurance policy covering liability, theft, and fire. The policy covers a one-year period. 2. Received 1,000 cash from customers on account. 3. On behalf of PS Music, Peyton signed a contract with a local radio station, KXMD, to provide guest spots for the next three months. The contract requires PS Music to provide a guest disc jockey for SO hours per month for a monthly fee of 3,600. Any additional hours beyond SO will be billed to KXMD at 40 per hour. In accordance with the contract, Peyton received 7,200 from KXMD as an advance payment for the first two months. 3. Paid 250 to creditors on account. 4. Paid an attorney 900 for reviewing the July 3 contract with KXMD. (Record as Miscellaneous Expense.) 5. Purchased office equipment on account from Office Mart, 7,500. 8. Paid for a newspaper advertisement, 200. 11. Received 1,000 for serving as a disc jockey for a party. 13. Paid 700 to a local audio electronics store for rental of digital recording equipment. 11. Paid wages of 1,200 to receptionist and part-time assistant. Enter the following transactions on Page 2 of the two-column journal: 16. Received 2,000 for serving as a disc jockey for a wedding reception. 18. Purchased supplies on account, 850. July 21. Paid 620 to Upload Music for use of its current music demos in making various music sets. 22. Paid 800 to a local radio station to advertise the services of PS Music twice daily for the remainder of July. 23. Served as disc jockey for a party for 2,500. Received 750, with the remainder due August 4, 2019. 27. Paid electric bill, 915. 28. Paid wages of 1,200 to receptionist and part-time assistant. 29. Paid miscellaneous expenses, 540. 30. Served as a disc jockey for a charity ball for 1,500. Received 500, with the remainder due on August 9, 2019. 31. Received 3,000 for serving as a disc jockey for a party. 31. Paid 1,400 royalties (music expense) to National Music Clearing for use of various artists' music during July. 31. Withdrew l,250 cash from PS Music for personal use. PS Music's chart of accounts and the balance of accounts as of July 1, 2019 (all normal balances), are as follows: 11 Cash 3,920 12 Accounts receivable 1,000 14 Supplies 170 15 Prepaid insurance 17 Office Equipment 21 Accounts payable 250 23 Unearned Revenue 31 Peyton smith, Drawing 4,000 32 Fees Earned 500 41 Wages Expense 6,200 50 Office Rent Expense 400 51 Equipment Rent Expense 800 52 Utilities Expense 675 53 Supplies Expense 300 54 music Expense 1,590 55 Advertising Expense 500 56 Supplies Expense 180 59 Miscellaneous Expense 415 Instructions 1.Enter the July 1, 2019, account balances in the appropriate balance column of a four-column account. Write Balance in the Item column and place a check mark () in the Posting Reference column. (Hint: Verify the equality of the debit and credit balances in the ledger before proceeding with the next instruction.) 2.Analyze and journalize each transaction in a two-column journal beginning on Page 1, omitting journal entry explanations. 3.Post the journal to the ledger, extending the account balance to the appropriate balance column after each posting. 4.Prepare an unadjusted trial balance as of July 31, 2019.
Wyoming Tours Co. is a travel agency. The nine transactions recorded by Wyoming Tours during June 2016, its first month of operations, are indicated in the following T accounts: Indicate for each debit and each credit: (a) whether an asset, liability, owners equity, drawing, revenue, or expense account was affected and (b) whether the account was increased (+) or decreased (). Present your answers in the following form, with transaction (1) given as an example:
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.