Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone help with this question in excel? LO3-3, LO3-4,LO3-5, LO3-6,Weida Surveying. Inc., provides land surveying services. During September, its transactions LO3-7, LO3-8 PROBLEM 3.3A
Can someone help with this question in excel?
LO3-3, LO3-4,LO3-5, LO3-6,Weida Surveying. Inc., provides land surveying services. During September, its transactions LO3-7, LO3-8 PROBLEM 3.3A Analyzing and Journalizing Transactions included the following Sept. Sept. 1 3 Sept. 9 Sept. 14 Sept. 25 Sept. 26 Sept. 29 Sept. 30 Paid rent for the month of September, $4,400 Billed Fine Line Homes $5,620 for survey ing services. The entire amount is due on or before September 28. (Weida uses an account entitled Surveying Revenue when billing clients.) Provided surveying services to Sunset Ridge Developments for $2,830. The entire amount was collected on this date Placed a newspaper advertisement in the Daily Item to be published in the September 20 issue. The cost of the advertisement was $165. Payment is due in 30 days. Received a check for $5,620 from Fine Line Homes for the amount billed on September 3. Provided surveying services to Thompson Excavating Company for $1,890. Weida collected $400 cash, with the balance due in 30 days. Sent a check to the Daily Item in full payment of the liability incurred on September 14 Declared and paid a $7,600 cash dividend to the company's stockholders. Chapter 3 The Accounting Cycle: Capturing Economic Events Instructions Analyze the effects that each of these transactions will have on the following six components of the company's financial statements for the month of September. Organize your answer in tabular form, using the column headings shown. Use I for increase, D for decrease, and NE for no effect. The September 1 transaction is provided for you. a. Income Statement Balance Sheet Transaction Revenue-Expenses = Net Income Assets= Liabilities + Owners' Equity Sept. 1 NE NE b. Prepare a journal entry (including explanation) for each of these transactions. Three of September's transactions involve cash payments, yet only one of these transactions is recorded as an expense. Describe three situations in which a cash payment would not involve recognition of an expense. c
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started