(a). Using the list of transactions at question A5.5 prepare a spreadsheet similar to that presented in...
Question:
(a). Using the list of transactions at question A5.5 prepare a spreadsheet similar to that presented in Table5.3.
(b). Show that the spreadsheet totals satisfy the accounting equation.
Transcribed Image Text:
Table 5.3 Spreadsheet analysing transactions into the elements of the accounting equation Asets Liabiltie Ownertip hteret Bushes tarsad bns of the ertity (nature of the etty, medical pradice) Cash and Trade Ivertay Capital Experses Date Non- Trade pay able core buted or (radtod Revenue bank recble stock) arrert (debtor) azds withdwn Od. 1 DrLee provides the pacticewith cash to allaw business to start 50,000 50,000 Oct. 2 The entty acquires medcal equipmentfor ash (30,000) 30000 Oct. 2 One monthis entis paid in advance for consuting rooms (1,900) 1,900 Oct. 2 Office fumitue is purhased on two mon ths'cred t from Office Supplies Сопраry 6500 6,500 The practice purchases medcal supplies on credtfrom P. Jones and receives aninvoice Ot. 7 1,200 1,200 DrLee pays the medial receptionist for one week's work, 2 b8 Ocbber Oct. 8 Od. 10 (300) 300 Fourpatients are ox armrined each paying £S00 cah 2,000 2,000 Oct. 11 The business pays P. Jones in cash for te goods itacquiredon credit (1.200) (1,200) (100) Oct. 14 The business pays an electricity bil in cash 100 Od. 15 DrLee pays the medial reeptiorist for oneweek'swork, 9 to 15October (300) 300 Oct. 17 Three patients are examined, teir employer (Mrs West) beingsentaninvoice requesting payment of £500 foreach 1,500 1,500 Od. 22 Dr Lee pays the medical receptionist for one weeks work, 16 b 22 October (300) 300 Od. 23 The employer (Mrs West) pays in cash forthe exarmination of three patierts 1,500 (1 500) Oct. 24 Fourpatent are examined, heir employer (Mr East) beingsentaninvoice requesting payment of £S00 foreach 2,000 2,000 Od. 28 DrLee daws ash from the business for personal use (1,000) (1p00) Oct. 29 Dr Lee pays the medical receptoristfor one week's work, 23 b 29 October (300) 300 Oct. 31 The medial equ ipment and office furniture is estimated by Dr Lee tb hae fallen in value Over the mon th (250) 250 Od. 31 350) DrLee checis the inventory (stock) of medial supplies and findsthat terns costing f350 have been used durdng the month 350 t to t Totaks 18,100 2,000 850 36250 6,500 49,000 5,500 3800 57,200 50 700
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 45% (11 reviews)
the table shown in the image is a spreadsheet analyzing transactions into the elements of the accoun...View the full answer
Answered By
Gaurav Soni
Teaching was always an area where I can pursue my passion. I used to teach my friends and junior during my school and college life. After completing my professional qualification (chartered accountancy) and before joining my job, I also joined an organization for teaching and guidance to my juniors. I had also written some articles during my internship which later got published. apart from that, I have also given some presentations on certain amendments/complex issues in various forms.
Linkedin profile link:
https://www.linkedin.com/in/gaurav-soni-38067110a
5.00+
7+ Reviews
13+ Question Solved
Related Book For
Financial And Management Accounting An Introduction
ISBN: 9781292244419
8th Edition
Authors: Pauline Weetman
Question Posted:
Students also viewed these Business questions
-
(a) Using the list of transactions at question A6.4 above, prepare a spreadsheet similar to that presented in Table 6.8. Refer to A6.4, Table 6.8, Spreadsheet analyzing transactions into the elements...
-
(a). Using the list of transactions at question B6.2 above, prepare a spreadsheet similar to that presented in Table6.8. (b). Show the resulting impact on the accounting equation and demonstrate that...
-
Following is a lifetime-value analysis framework similar to that presented in the chapter. Perform the calculations necessary to complete row K: YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Revenue A Customers...
-
Hi, I need help with this accounting problem, thanks inadvance.l [The following information applies to the questions displayed below.] Delph Company uses a job-order costing system and has two...
-
What is the nominal annual rate of interest compounded quarterly at which $420 will accumulate to $1000 in nine years and six months?
-
What are the basic components of a database management system (DBMS)? Discuss the relationship between the above components of DBMS and the functional model of information systems discussed in...
-
Sami Company recorded the following selected transactions during November 2005: 1. Open a general ledger having T-accounts for Accounts Receivable, Sales, and Sales Returns and Allowances. Also open...
-
The comparative income statements and balance sheets of Sarot, Inc., Compute the amount and percentage changes for the income statement, and comment on the changes from 2011 to 2012. Sarot, Inc....
-
12. Check to see if the sides are proportional by creating ratios between corresponding sides and reducing the fractions: Shortest Sides 5 Middle Sides 11 Longest Sides 13 13. Are the two triangles...
-
for the system shown below, design the complete oc protection using the idmt relays. thus, decide the ct ratios, the plug settings and the tms at all locations. 115 A 1500 A 6000 A 80 A 1000 A 77 A...
-
Using the totals from the columns of the spreadsheet of question B5.1, prepare for the dental practice in the month of April: (a) A statement of cash flows; (b) A statement of financial position...
-
A company is able to sell four products and is planning its production mix for the next period. Estimated costs, sales and production data are as follows: Required (a). Based on the foregoing...
-
By using the IS alignment work and the financial analysis, prepare research on a complete IS strategic plan. Your paper should include at least 5 references from peer-reviewed journals associated...
-
The distance D that a charter bus is away from a destination in Arizona after t hours is represented by: D= f(t) = 1850 - 60t Determine the range of the bus given the domain for the first 19 hours,...
-
How do hierarchical societies develop after some time, and which job do administration styles play in forming social standards and values inside an association ?
-
Read the below linked article. Comment on the article and what ways you think it is best for companies to come up with new ideas. https://www.entrepreneur.com/article/421375
-
Describe the significance of reconciliation processes in banking operations and how discrepancies in reconciliations can affect financial accuracy.
-
The Northridge, California, earthquake of 1 9 9 4 had a magnitude of 6 . 8 on the Richter scale. A year later, a 7 . 2 - magnitude earthquake struck Kobe, Japan. How many times more intense was the...
-
Define the term cost allocation base. Can you think of a suitable cost allocation base for assigning advertising costs to the various attractions at a large theme park (such as Disneyland or...
-
Why do bars offer free peanuts?
-
In 2005, the SEC filed a civil action suit against Samuel Israel III and Daniel E. Marino, managers of a group of hedge funds known as the Bayou Funds. The SEC alleged that Israel and Marino...
-
What is corporate social responsibility?
-
What is the Global Reporting Initiative?
-
YoY growth rate of 17 percent Plant currently operating at capacity Growth will require a new machine costing $3 million Assume additional $300,000 of annual depreciation for this new machine...
-
Ross chooses not to allocate assets costing between $300 and $1,000 into a low-value pool. Instead, he prefers that you depreciate any depreciable assets purchasedin accordance with their effective...
-
Accounting I11) WE THE BEST Inc. has net sales revenue of $1,360,000, cost of goods sold of$761,100, and all other expenses of $301,000. The beginning balance of stockholders'equity is $411,000 and...
Study smarter with the SolutionInn App