
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 1R
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.
REQUIREMENT
1. Review the printout of the worksheet PTRANS. You have been asked to complete the worksheet by recording these transactions.
Expert Solution & Answer

To determine
Show the printout of worksheet of PTRANS.
Explanation of Solution
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
I am searching for the correct answer to this general accounting problem with proper accounting rules.
I need help finding the correct solution to this financial accounting problem with valid methods.
Can you solve this general accounting problem using accurate calculation methods?
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
- Please provide correct solution and accounting questionarrow_forwardI need help with question is correct answer and accountingarrow_forwardFor the current year ended March 31, Carter Company expects fixed costs of $620,000, a unit variable cost of $72, and a unit selling price of $95. a. Compute the anticipated break-even sales (units). b. Compute the sales (units) required to realize an operating income of $145,000. (Round your answer to nearest units)arrow_forward
- What is Bobby's 2019 net income using accrual accounting?arrow_forwardPension plan assets were $2,300 million at the beginning of the year and $2,560 million at the end of the year. At the end of the year, retiree benefits paid by the trustee were $60 million and cash invested in the pension fund was $65 million. What was the percentage rate of return on plan assets?arrow_forwardDon't use AIarrow_forward
- I am looking for the correct answer to this general accounting question with appropriate explanations.arrow_forwardPlease provide the solution to this general accounting question using proper accounting principles.arrow_forwardI need assistance with this financial accounting problem using valid financial procedures.arrow_forward
- Accounting problemarrow_forwardRoyal Designs creates custom furniture. During November, it had applied an overhead of $162,000. Overhead is applied at the rate of 80% of direct labor cost. Direct labor wages average $32 per hour. How many direct labor hours did Royal Designs have for the month of November?arrow_forwardCan you explain the process for solving this financial accounting question accurately?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College

Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY