accounting

profilekatty2018
Group_Project.docx

Financial Accounting

Module 4 Group Project 2017 - 2018

Financial Accounting

Module 4 Group Project 2017 - 2018

Financial Accounting

Module 4 Group Project 2017 - 2018

The table below provides a list of three different sole trader businesses. You are to choose one then give it an appropriate name and state the nature of the business; which MUST be in accordance WITH the items sold.

After selecting, naming and describing the nature of the business as well as identifying at least three aims of the project, you should then perform the different actions outlined in Tasks 1-5 for period one (1), then Tasks 6-9 for period 2.

You may choose goods from the following list to prepare transactions:

*

Computer Store

Clothing & Accessories Store

Small Appliances &

Household Supplies Store

A

Keyboard

Pants

Irons

B

Mouse

Blouse

Blenders

C

Printer

Hand Bags

Juicers

D

Surge Protector

Skirts

Dish Drainers

E

Speakers

Sandals

Rugs

The (business name) has been in operations for some time and has been having problems with maintaining its accounting books. the owner is not sure how profitable the business is and has therefore decided to hire you as an accountant to record the daily transactions carried out by the business in the relevant books. You are also required to prepare the necessary financial statements as well as to prepare reports on how the business is doing as well as to provide recommendations on how the business can improve. During your first month (January 2017) as the new accountant, the following transactions were carried out by (business name). You are required to carefully analyze each transaction, then enter them in the appropriate books of accounts as outlined in the different tasks below:

2017

January 1 Opening Entries / Balances: $

Capital 500,000

Cash at Bank 234,000

Cash in Hand 43,150

Debtors:

M. Jackson 21,400

A. Lewis 14,200

Creditor:

J & J Manufacturers Ltd 33,350

Delivery Van 62,840

Fixtures and Fittings 8,000

Land 100,000

Stock:

18 units Pants 36,000

1 dozen Blouse 6,400

1 dozen Skirts 7,360

Transactions during the month of January:

January 1

Sold the following goods on credit to M. Jackson:

· 1 dozen Pants @ $3,500 each

· ½ dozen Blouse @ $1,650 each

· 1 dozen Skirts @ $1,320 each

January 1

Bought machinery by cheque $78,000.

January 2

Bought the following items on credit from J & J Manufacturers:

· 10 dozen Pants @ $2,000 each

· 10 dozen Blouse @ $6500 per dozen

· 7 boxes Juicer @ $2,500 per box

· 6 dozen Skirts @ 2,250 each

· 8 dozen Sandals @ $1,500 per dozen

January 2

Withdrew $93,000 cash from the bank account to be used in the business.

January 3

Cash Sales:

· 1 dozen Pants @ $2,520 each

· 1 dozen Blouse @ $2,950 each

· 1 dozen Skirts @ $3,400 each

January 3

Paid rent by cheque $40,000.

January 5

Sold goods on credit to P. Simpson:

· 18 units Pants @ $1,650 each

· 3 dozen Blouse @ $1,200 each

· 1 dozen Sandals @ $2,500 per dozen

January 6

Bought fixtures with cash $55, 000.

January 7

Cash Sales:

· 3 boxes Hand Bags @ $5,875 per box

· 1 dozen Skirts @ $2,400 each

· 1 dozen Sandals @ $2,500 per dozen

January 8

Paid wages $42, 000 by cheque.

January 9.

Returned goods to J & J Manufacturers as items were damaged:

· 18 units Pants

· 3 boxes Hand Bags

January 11

Paid the following expenses by cheque:

· Telephone $9,100;

· Electricity $12,300 and

· General Expenses $2,600

January 13

Sold goods on credit to A. Holness:

· 2 dozen Pants @ $3,650 each

· 2 dozen Blouse @ $1,250 each

· 1 Hand Bags @ $3,000 per unit

 1 dozen Skirts @ $1,400 each

January 15

Paid J & J Manufacturers by cheque and received a 5% cash discount.

January 15

Paid office wages with cash $20,000

January 16

Owner withdrew $12,200 cash to pay his daughter’s school fees.

January 18

Collected cheque from P. Simpson for goods sold on January 5th, 2017, allowing a 2.5% discount

January 19

Purchased computer and desk from Singer Jamaica valued at $30,600, paying $15,000 in cash.

January 20

Sold goods on credit to H. Jackman:

· 3 dozen Pants @ $1,650 each

· 3 dozen Blouse @ $1,200 each

· 2 dozen Sandals @ $3,500 per dozen

January 22

Paid wages with cheque $10,000.

January 24

1 dozen Skirts returned to us by A. Holness as they were the wrong brand.

January 27

Bought goods on credit from J & J Manufacturers Ltd.:

· 6 dozen Pants @ $ 2,100 each

· 10 boxes Hand Bags @ $ 2,850 per box

· 3 dozen Sandals @ $ 1,080 per dozen

January 29

A. Holness paid half of what he owed us by cheque after deducting a 10% cash discount.

January 30

H. Jackman sent us ½ dozen B

January 30

Cash Sales:

· 3 dozen Pants @ $ 2,935 each

· 1 dozen Blouse @ $ 1,950 each

· 4 Hand Bags @ $ 4,500 per box

· 2 dozen Skirts @ $ 1,400 per dozen

YOU ARE REQUIRED TO:

Task 1:

Enter the above transactions in the appropriate subsidiary book/book of original entry and then post the transactions to the relevant ledgers. Ensure that you use all the relevant books. The opening entries should be shown in the General Journal for the period.

Task 2:

Prepare the Trial Balance as at January 31, 2017.

Task 3:

On a Stock/Store Ledger, determine the value of the closing stock using the:

LIFO method of stock valuation for the computer Store

FIFO method of stock valuation for the Clothing Store.

AVCO method of stock valuation for the Small Appliances and Household Items Store.

Task 4: Prepare the Financial Statements for the period ending January 31, 2017.

On February 5, 2017: the (business name) received the following bank statement from its bank, National Commercial Bank (NCB). After examining the bank statement below, you observed that the cheques used to pay for machinery purchased on January 1, 2017 and the one sent to J & J Manufacturers Limited were not included. The cheques collected from P. Jackson and A. Holness were not deposited until February 1, 2017.

National Commercial Bank

Date

Particulars

Withdrawals

Deposits

Balance

Jan 1

Balance b/f

234,000

Jan 1

Cheque (M. Jackson)

20,000

254,000

Jan 2

Standing Order (Insurance Expense)

6,400

247,600

Jan 2

Cheque

93,000

154,600

Jan 8

Rent

40,000

114,600

Jan 8

Wages

42,000

72,600

Jan 11

Telephone expense

9,100

63,500

Jan 11

Electricity

12,300

51,200

Jan 11

General expenses

2,600

48,600

Jan 19

Cheque

15,600

33,000

Jan 22

Wages

10,000

23,000

Jan 24

Credit Transfer (J & J Manufacturers Ltd)

32,000

(9,000)

Jan 29

Standing Order

15,000

(24,000)

Jan 31

Bank charges

650

(24,650)

Task 5:

(1)

Update the Cashbook for January 2017 and balance it off.

(2)

Draw up a Bank Reconciliation Statement as at January 31, 2017; reconciling the corrected cash book balance with the bank statement

Period Two

February 1

Bought goods on credit from J & J Manufacturers Ltd valued at

· 12 boxes of Hand Bags @ $2,750

· 4 dozens Skirts @ $2,300

· 5 dozens Sandals @ $1,750

February 2.

Sold the following to A. Holness on credit

· Pants: 30 units @ $3,500

· Sandals: 2 dozen @ $2,000

February 3.

Paid wages $10,000 by cash

February 4.

Paid cleaning expense $2,500 by cash

February 5.

Received a cheque from A. Lewis $14,200

February 6.

Paid electricity bill by cheque $5,400

February 7.

Deposit $80,000 of cash into bank.

February 9.

Paid water rate by cash $6,800

February 12.

Paid J&J Manufacturers Ltd. by cheque $60,000

February 15.

Paid for the maintenance of machinery $6,000 by cash

February 17.

Cash sales paid directly into bank:

· Pants: 15 units @ $3,500

· Hand Bags: 3 boxes @ $2,500

· Sandals: 4 boxes @ $2,500

February18.

Bought goods on credit from J & J Manufacturers Ltd.

Pants: 50 units @ $2,000 per unit

Blouse: 5 dozen @ $6,500 per dozen

Hand Bags: 3 boxes @ $2,500 per box

February 19.

Paid wages $12,000 by cash

February 20

Paid telephone bill of $8,000 by cash

February 24.

Sold the following to A. Holness on credit:

Pants: 3 units @ $3,500

Blouse: 3 dozen @ $1,200 each

Task 6:

Enter the above transactions in the appropriate subsidiary book/book of original entry and then post the transactions to the relevant ledgers. Ensure that you use all the relevant books. The opening entries should be shown in the General Journal for the period.

Task 7:

Extract a trial balance as at February 28, 2017.

Task 8:

Prepare the Financial Statements for the period ending February 28, 2017. The following additional information must be considered when preparing the financial statements:

1. Closing Stock as per the stock valuation method used as per Task 3 above.

2. Depreciate non-current assets as follows:

a. Fixtures & fittings – 15% on the straight line basis.

b. Delivery van – 20% on the reducing balance basis

c. Machinery – 20% on the reducing balance basis.

d. Computer desk – 25% on the straight-line basis.

e. Land is not depreciated.

3. The following expenses were outstanding at the end of February 2017:

a. Water rates $3,500

b. Telephone $1,750

c. Electricity $2,590

4. The following expenses were paid in advance:

a. Machine Maintenance $1,500

b. Cleaning expense $500

5. $1,800 of the amount owed by M. Jackson is to be written off as bad debt.

Task 9: Calculate a minimum of five accounting ratios for BOTH periods. Use ratios

to:

a. comment on the performance of the business

b. make comparisons – the use of tables, charts or graphs must be used to illustrate the comparisons. you are expected to compare the first period with the second period or beginning balances with ending balances,

c. make a least three (3) suggestions and recommendations.

1

1

1