Transac Purchased 150 units of st Durcha ced 22E unite of

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter12: Statement Of Stockholders’ Equity (stockeq)
Section: Chapter Questions
Problem 4R: The following selected transactions and events occurred during 2013: a. Issued 200 shares of...
icon
Related questions
Question
The following stock-related transactions
occurred during the period 1 July to 31
December.
Date
Transaction
25 July
Purchased 150 units of stock @
£20 each
28 August
Purchased 225 units of stock @
£30 each
15 September Sold 305 units of stock @ £45
each
4 October
Sold 50 units of stock @ £45
each
10 November Purchased 410 units of stock @
£40 each
23 December Sold 100 units of stock @ £75
each
Additional Information:
1. The Balance Sheet as at 1 July was as
follows:
Bank
£10,000
Capital Account
£10,000
2. Two months' credit is received from
suppliers.
3. One month's credit is allowed to
customers.
4. Expenses of £1,400 are paid by cheque
each month as incurred.
5. The purchase and sale prices referred to
above are exclusive of VAT. Purchases are
liable to VAT at the rate of 10% and sales are
liable to VAT at the rate of 20%.
Required:
Calculate the value of stock on hand at
(a)
the end of each month during the period 1
July to 31 December, using the First In, First
Out method (FIFO); and
Prepare a Trading and Profit and Loss
(b)
Account and Balance Sheet for the period 1
July to 31 December.
Transcribed Image Text:The following stock-related transactions occurred during the period 1 July to 31 December. Date Transaction 25 July Purchased 150 units of stock @ £20 each 28 August Purchased 225 units of stock @ £30 each 15 September Sold 305 units of stock @ £45 each 4 October Sold 50 units of stock @ £45 each 10 November Purchased 410 units of stock @ £40 each 23 December Sold 100 units of stock @ £75 each Additional Information: 1. The Balance Sheet as at 1 July was as follows: Bank £10,000 Capital Account £10,000 2. Two months' credit is received from suppliers. 3. One month's credit is allowed to customers. 4. Expenses of £1,400 are paid by cheque each month as incurred. 5. The purchase and sale prices referred to above are exclusive of VAT. Purchases are liable to VAT at the rate of 10% and sales are liable to VAT at the rate of 20%. Required: Calculate the value of stock on hand at (a) the end of each month during the period 1 July to 31 December, using the First In, First Out method (FIFO); and Prepare a Trading and Profit and Loss (b) Account and Balance Sheet for the period 1 July to 31 December.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
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
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning