![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_largeCoverImage.gif)
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 1, Problem 5R
On June 1 of the current year, Wilson Wood opened Woodyʼs Web Services. This sole proprietorship had the following transactions during June.
- a. Opened a business checking account and made a deposit, $9,000.
- b. Paid rent for June for office space and computer equipment, $3,000.
- c. Purchased office supplies (stamps, pens, etc.) on account, $1,980.
- d. Received cash for services rendered, $4,500.
- e. Paid creditor for office supplies purchased on account, $1,400.
- f. Purchased office supplies for cash, $420.
- g. Billed clients for consultations performed on account, $4,600.
- h. Paid monthly internet service bill of $360.
- i. Paid the secretaryʼs salary of $2,400.
- j. Returned $300 of office supplies purchased in transaction f. Received a full refund.
- k. Received cash from clients previously billed, $3,000.
- l. Cash was withdrawn for ownerʼs personal use, $2,000.
Use the space below to prepare an income statement, a statement of ownerʼs equity (capital statement), and a balance sheet in good form for Woodyʼs Web Services for the month of June.
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Trending nowThis is a popular solution!
![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
On July 1, 2019, Pat Glenn established Half Moon Realty. Pat completed the following transactions during the month of July:
a. Opened a business bank account with a deposit of $30,000 from personal funds.
b. Purchased office supplies on account, $3,010.
c. Paid creditor on account, $1,900.
d. Earned sales commissions, receiving cash, $30,690.
Domingo Company started its business on January 1, 2019. The following transactions occurredduring the month of May. Prepare the journal entries in the journal on Page 1.A. The owners invested $10,000 from their personal account to the business account.B. Paid rent $500 with check #101.C. Initiated a petty cash fund $500 with check #102.D. Received $1,000 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,500, paid $1,350 with check #104, and will pay the remainder in 30days.G. Received $800 cash for services rendered.H. Paid wages $600, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $77,miscellaneous expense $55. Cash on hand $11. Check #106.J. Increased petty cash by $30, check #107.
On April 1, 2019, Maria Adams established Custom Realty. Maria completed the following transactions during the month of April:a. Opened a business bank account with a deposit of $24,000 from personal funds.b. Paid rent on office and equipment for the month, $3,600.c. Paid automobile expenses (including rental charge) for the month, $1,350, and miscellaneous expenses, $600.d. Purchased office supplies on account, $1,200.e. Earned sales commissions (revenue) from selling real estate, receiving cash, $19,800.f. Paid creditor on account, $750.g. Paid office salaries, $2,500.h. Withdrew cash for personal use, $3,500.i. Determined that the cost of supplies on hand was $300; therefore, the cost of supplies used was $900.
Chapter 1 Solutions
Excel Applications for Accounting Principles
Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - Prob. 7R
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Inner Resources Company started its business on April 1, 2019. The following transactions occurred during the month of April. Prepare the journal entries in the journal on Page 1. A. The owners invested $8,500 from their personal account to the business account. B. Paid rent $650 with check #101. C. Initiated a petty cash fund $550 check #102. D. Received $750 cash for services rendered. E. Purchased office supplies for $180 with check #103. F. Purchased computer equipment $8,500, paid $1,600 with check #104 and will pay the remainder in 30 days. G. Received $1,200 cash for services rendered. H. Paid wages $560, check #105. I. Petty cash reimbursement office supplies $200, Maintenance Expense $140, Miscellaneous Expense $65. Cash on Hand $93. Check #106. J. Increased Petty Cash by $100, check #107.arrow_forwardIn July of this year, M. Wallace established a business called Wallace Realty. The account headings are presented below. Transactions completed during the month follow. a. Wallace deposited 24,000 in a bank account in the name of the business. b. Paid the office rent for the current month, 650, Ck. No. 1000. c. Bought office supplies for cash, 375, Ck. No. 1001. d. Bought office equipment on account from Dellos Computers, 6,300. e. Received a bill from the City Crier for advertising, 455. f. Sold services for cash, 3,944. g. Paid on account to Dellos Computers, 1,500, Ck. No. 1002. h. Received and paid the bill for utilities, 340, Ck. No. 1003. i. Paid on account to the City Crier, 455, Ck. No. 1004. j. Paid truck expenses, 435, Ck. No. 1005. k. Wallace withdrew cash for personal use, 1,500, Ck. No. 1006. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.arrow_forwardDomingo Company started its business on May 1, 2019. The following transactions occurred during the month of May and the following entries were recorded. A. The owners invested $9,500 from their personal account to the business account.B. Paid rent $600 with check #101.C. Initiated a petty cash fund $600 with check #102.D. Received $1,100 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,300, paid $1,350 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $800, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $77, miscellaneous expense $55. Cash on hand $115. Check #106.J. Increased petty cash by $30, check #107. A. Cash 9,500 Domingo, Capital 9,500 B. Rent Expense 600 Cash 600 C. Petty Cash 600 Cash 600 D. Cash 1,100 Services Income 1,100 E. Office…arrow_forward
- Domingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. A. The owners invested $10,000 from their personal account to the business account.B. Paid rent $700 with check #101.C. Initiated a petty cash fund $500 with check #102.D. Received $1,100 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,500, paid $1,250 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $600, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $110, postage expense $79, miscellaneous expense $57. Cash on hand $10. Check #106.J. Increased petty cash by $30, check #107. Domingo Company received the following bank statement. Bank Statement Beginning balance $0 Deposits Checks A. $10,000 101 $700 D. 1,100 102 500 103 158 106 490 Bank service…arrow_forwardDomingo Company started its business on May 1, 2019. The following transactions occurred during the month of May and the following entries were recorded. A. The owners invested $5,000 from their personal account to the business account.B. Paid rent $700 with check #101.C. Initiated a petty cash fund $500 with check #102.D. Received $1,300 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,000, paid $1,350 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $700, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $71, miscellaneous expense $55. Cash on hand $18. Check #106.J. Increased petty cash by $30, check #107. A. Cash 5,000 Domingo, Capital 5,000 B. Rent Expense 700 Cash 700 C. Petty Cash 500 Cash 500 D. Cash 1,300 Services Income 1,300 E. Office…arrow_forwardDomingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. A. The owners invested $12,000 from their personal account to the business account.B. Paid rent $700 with check #101.C. Initiated a petty cash fund $500 with check #102.D. Received $1,000 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,100, paid $1,350 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $800, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $75, miscellaneous expense $55. Cash on hand $18. Check #106.J. Increased petty cash by $30, check #107. Prepare the journal entries. If an amount box does not require an entry, leave it blank. A. fill in the blank 2 fill in the blank 3 fill in the blank 5 fill in the blank 6 B. fill in the blank 8 fill in the blank 9…arrow_forward
- Domingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. A. The owners invested $12,000 from their personal account to the business account.B. Paid rent $600 with check #101.C. Initiated a petty cash fund $600 with check #102.D. Received $1,100 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,500, paid $1,350 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $600, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $73, miscellaneous expense $55. Cash on hand $116. Check #106.J. Increased petty cash by $30, check #107. Prepare the journal entries. If an amount box does not require an entry, leave it blank. A. Domingo, Capital Domingo, Capital Cash Cash B. Rent Expense Rent Expense Cash Cash C. Petty Cash…arrow_forwardInner Resources Company started its business on April 1, 2019. The following transactions occurred during the month of April. A. The owners invested $9,000 from their personal account to the business account. B. Paid rent$650 with check #101. C. Initiated a petty cash fund $650 with check #102. D. Received $850 cash for services rendered. E. Purchased office supplies for $180 with check #103. F. Purchased computer equipment $9,500, paid $1,600 with check #104, and will pay the remainder in 30 days. G. Received s1,200 cash for services rendered. H. Paid wages $560, check #105. I. Petty cash reimbursement: office supplies $250, Maintenance Expense $140, Miscellaneous Expense $65. Cash on Hand $137. Check #106. J. Increased Petty Cash by $100, check #107. Inner Resources Company received the following bank statement. Bank Statement Beginning balance Deposits Checks A. $9,000 101 $650 G. 1,200 102 650 103 180 106 513 Bank service charges 150 Total $10,200 $2,143 Ending balance $8,057…arrow_forwardDomingo Company started its business on May 1, 2019. The following transactions occurred during the month of May and the following entries were recorded. A. The owners invested $1,000 from their personal account to the business account. B. Paid rent $500 with check #101. C. Initiated a petty cash fund $500 with check #102. D. Received $1,000 cash for services rendered. E. Purchased office supplies for $158 with check #103. F. Purchased computer equipment $2,200, paid $1,350 with check #104, and will pay the remainder in 30 days. G. Received $800 cash for services rendered. H. Paid wages $800, check #105. I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $75, miscellaneous expense $55. Cash on hand $18. Check #106. J. Increased petty cash by $30, check #107. A. Cash 1,000 Domingo, Capital 1,000 В. Rent Expense 500 Cash 500 C. С. Petty Cash 500 Cash 500 D. Cash 1,000 Services Income 1,000 Е. Office Supplies 158 Cash 158 F. Computer Equipment…arrow_forward
- Domingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. A. The owners invested $10,000 from their personal account to the business account. B. Paid rent $500 with check #101. C. Initiated a petty cash fund $500 with check #102. D. Received $1,100 cash for services rendered. E. Purchased office supplies for $158 with check #103. F. Purchased computer equipment $2,500, paid $1,250 with check #104, and will pay the remainder in 30 days. G. Received $800 cash for services rendered. H. Paid wages $600, check #105. I. Petty cash reimbursement: office supplies $256, maintenance expense $110, postage expense $79, miscellaneous expense $57. Cash on hand $5. Check #106. J. Increased petty cash by $30, check #107. Domingo Company received the following bank statement. Bank Statement Beginning balance $0 Deposits Checks А. $10,000 101 $500 D. 1,100 102 500 103 158 106 495 Bank service charges 100 Total 11,100 1,753 Ending balance $9,347…arrow_forwardInner Resources Company started its business on April 1, 2019. The following transactions occurred during the month of April. A. The owners invested $9,000 from their personal account to the business account. B. Paid rent $750 with check #101. C. Initiated a petty cash fund $550 with check #102. D. Received $850 cash for services rendered. E. Purchased office supplies for $180 with check #103. F. Purchased computer equipment $8,500, paid $1,600 with check #104 and will pay the remainder in 30 days. G. Received $1,200 cash for services rendered. H. Paid wages $560, check #105. I. Petty cash reimbursement: Office supplies $200, Maintenance Expense $140, Miscellaneous Expense $65. Cash on Hand $93. Check #106. J. Increased Petty Cash by $100, check #107. Prepare the journal entries. If an amount box does not require an entry, leave it blank. A. В. E. F. G. Н. II II II 1I I II II I II II 1I I1 III II II D.arrow_forwardInner Resources Company started its business on April 1, 2019. The following transactions occurred during the month of April. A. The owners invested $8,500 from their personal account to the business account.B. Paid rent $850 with check #101.C. Initiated a petty cash fund $550 with check #102.D. Received $800 cash for services rendered.E. Purchased office supplies for $180 with check #103.F. Purchased computer equipment $9,500, paid $1,600 with check #104, and will pay the remainder in 30 days.G. Received $1,200 cash for services rendered.H. Paid wages $560, check #105.I. Petty cash reimbursement: office supplies $200, Maintenance Expense $160, Miscellaneous Expense $65. Cash on Hand $65. Check #106.J. Increased Petty Cash by $100, check #107. Inner Resources Company received the following bank statement. Bank Statement Beginning balance $0 Deposits Checks A. $8,500 101 $850 G. 1,200 102 550 103 180 106 485 Bank service charges 100…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337280570/9781337280570_smallCoverImage.gif)
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272124/9781337272124_smallCoverImage.gif)
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY