Reference no: EM131156678
QUESTION 1: Balance Day Adjustments
Below is the unadjusted Trial Balance for Blue Herrings Fishing Gear as at 30th June 2016.
IMPORTANT: Use the trial balance provided below to complete this question.
Do NOT use the trial balance you completed in Part A of the assignment.
|
Blue Herrings Fishing Gear
|
|
Trial Balance
|
|
as at 30th June 2016
|
|
|
Debit
|
Credit
|
|
Cash at Bank
|
56,433
|
|
|
Accounts Receivable
|
68,398
|
|
|
Inventory (1 July 2015)
|
58,950
|
|
|
Prepaid Insurance
|
225
|
|
|
Motor Vehicle
|
45,000
|
|
|
Shop Shelving
|
95,625
|
|
|
Accumulated Depreciation - Shop Shelving
|
|
27,000
|
|
Display Cabinets
|
78,000
|
|
|
Accumulated Depreciation - Display Cabinets
|
|
7,100
|
|
Accounts Payable
|
|
17,550
|
|
Rent Payable
|
|
2,250
|
|
Loan
|
|
57,850
|
|
S. Sole, Capital (1 July 2015)
|
|
280,375
|
|
S. Sole, Drawings
|
40,500
|
|
|
Sales
|
|
766,923
|
|
Sales Returns & Allowances
|
1,060
|
|
|
Interest expense
|
4,600
|
|
|
Discount Received
|
|
2,250
|
|
Purchases
|
261,000
|
|
|
Freight Inwards Expense
|
5,550
|
|
|
Insurance Expense
|
1,350
|
|
|
Advertising Expense
|
19,300
|
|
|
Office Operating Expense
|
96,750
|
|
|
Rent Expense
|
29,250
|
|
|
Wages Expense
|
295,875
|
|
|
Delivery Expense
|
2,132
|
|
|
Discount Allowed
|
1,300
|
|
|
Totals
|
1,161,298
|
1,161,298
|
On the following page is information that Sam has provided to you related to the year ended 30 June 2016.
1. $300 of the Advertising expense relates to a radio campaign that will run in August 2016.
2. The Motor Vehicles, Shop Shelving and Display Cabinets are expected to be used evenly over their useful lives. The expected total useful lives and residual values of these assets are listed below:
|
|
Estimated Useful life
|
Estimated Residual
|
|
Motor Vehicles
|
5 years
|
$5,000
|
|
Shop Shelving
|
10 years
|
$5,625
|
|
Display Cabinets (see note below)
|
12 years
|
0
|
Sam has spoken with his accountant, Jen Ledger, about the required entries and the issue of materiality. As a result, it has been decided that due to its relatively small impact, Sam will start depreciating the new $42,000 Display Cabinets (purchased in June 2016) from the 1st July 2016.
3. A count of the stationery room revealed that Office Supplies on hand at 30th June 2016 were $2,623. This had been originally debited to Office Operating Expenses.
4. The balance in the Prepaid Insurance account represents coverage for June 2016.
5. $16,000 of the recorded Sales is for specially imported Marlin fishing rods which will not be delivered until 24th July 2016.
6. As of 30th June 2016, Tom has estimated that 5% of his Accounts Receivable will not be collected (round any required adjustment to the nearest whole dollar).
7. Wages earned by employees, but unpaid as at 30th June 2016 total $5,120.
REQUIRED:
As it is now the end of the financial year, you are required to undertake the following work for Sam:
(a) Prepare any necessary Balance Day Adjustment Journals for Blue Herrings Fishing Gear. Ensure that each journal entry is correctly formatted and include a brief narration (explanation) for each journal entry.
(b) Update the General Ledgers provided and post the journals from (a) above. All ledgers must be correctly formatted and footed (balanced).
(c) Complete the Adjusted Trial Balance provided. You will need to insert additional accounts that are not currently listed.
|
BLUE HERRINGS FISHING GEAR
UNADJUSTED TRIAL BALANCE
AS AT 30 June 2016
|
|
|
Debit ($)
|
Credit ($)
|
|
Cash at Bank
|
56,433
|
|
|
Accounts Receivable
|
68,398
|
|
|
Inventory (1 July 2015)
|
58,950
|
|
|
Prepaid Insurance
|
|
|
|
Motor Vehicle
|
45,000
|
|
|
Shop Shelving
|
95,625
|
|
|
Accumulated Depreciation - Shop Shelving
|
|
|
|
Display Cabinets
|
78,000
|
|
|
Accumulated Depreciation - Display Cabinets
|
|
|
|
Accounts Payable
|
|
17,550
|
|
Rent Payable
|
|
2,250
|
|
Loan
|
|
57,850
|
|
S. Sole, Capital (1 July 2015)
|
|
280,375
|
|
S. Sole, Drawings
|
40,500
|
|
|
Sales
|
|
|
|
Sales Returns & Allowances
|
1,060
|
|
|
Interest expense
|
4,600
|
|
|
Discount Received
|
|
2,250
|
|
Purchases
|
261,000
|
|
|
Freight Inwards Expense
|
5,550
|
|
|
Insurance Expense
|
|
|
|
Advertising Expense
|
|
|
|
Office Operating Expense
|
|
|
|
Rent Expense
|
29,250
|
|
|
Wages Expense
|
|
|
|
Delivery Expense
|
2,132
|
|
|
Discount Allowed
|
1,300
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Totals
|
|
|
QUESTION 2: Financial Statement
The following Trial Balance for Pikachu's Safety Apparel has been prepared at year end by Pikachu, but he realises it is not in the correct order.
REQUIRED:
Using the Trial Balance provided below, prepare the following for the period in question:
1. Fully classified Income Statement
2. Statement of Changes in Equity
Pikachu's Safety Apparel
TRIAL BALANCE AS AT 30 JUNE 2015
|
Shop Furniture & Fittings
|
25 000
|
|
|
Accounts Receivable
|
46 089
|
|
|
Accumulated Depreciation - Shop Furniture & Fittings
|
|
9 020
|
|
Cash at Bank
|
49 053
|
|
|
Advertising Payable
|
|
4526
|
|
Sales
|
|
547 310
|
|
Electricity Expense
|
1 600
|
|
|
COS
|
386 210
|
|
|
Pikachu, Capital
|
|
44 810
|
|
Depreciation Expense - Shop Furniture & Fittings
|
3 550
|
|
|
Freight Inwards
|
2 820
|
|
|
Rent Expense
|
29 300
|
|
|
Accounts Payable
|
|
16 018
|
|
Discount Allowed
|
3 725
|
|
|
Inventory
|
20 960
|
|
|
Salaries Expense - Store
|
33 400
|
|
|
Loan Payable
|
|
33 600
|
|
Allowance for Doubtful Debts
|
|
1 000
|
|
Prepaid Advertising
|
1 540
|
|
|
Interest Payable
|
|
620
|
|
Advertising Expense
|
560
|
|
|
Sales Equipment
|
14 400
|
|
|
Interest Expense
|
470
|
|
|
Doubtful Debts Expense
|
1 000
|
|
|
Pikachu, Drawings
|
18 500
|
|
|
Sales Returns & Allowances
|
8 630
|
|
|
Discount Received
|
|
3 203
|
|
Salaries Expense - Admin
|
13 300
|
|
|
Totals
|
660 107
|
660 107
|
Additional information
• Pikachu has determined that 30% of the electricity expense and $8,650 of the rent expense specifically relate to the administration office. The remainder of both these expenses relate to running the store.
QUESTION 4: Cash Flow Statement
You are provided with the following financial information for Goldstar Holdings Ltd:
GOLDSTAR HOLDINGS LTD
COMPARATIVE BALANCE SHEETS
AS AT JUNE 30th
2016 2015
|
Current Assets
|
|
|
|
|
|
Cash on Hand
|
$5 000
|
|
$4 000
|
|
|
Cash at Bank
|
1 400
|
|
-
|
|
|
Accounts Receivable (net) *
|
4 800
|
|
4 950
|
|
|
Inventory
|
18 500
|
|
20 100
|
|
|
Prepaid Expenses
|
1 480
|
$31 180
|
890
|
$29 940
|
|
Non Current Assets
|
|
|
|
|
|
Plant & Equipment
|
72 000
|
|
72 000
|
|
|
less Acc. Depreciation
|
(25 700)
|
46 300
|
(19 700)
|
52 300
|
|
Total Assets
|
|
77 480
|
|
82 240
|
|
|
|
|
|
|
|
Current Liabilities
|
|
|
|
|
|
Bank Overdraft
|
-
|
|
2 400
|
|
|
Accounts Payable
|
3 800
|
|
4 250
|
|
|
Accrued Expenses
|
920
|
|
850
|
|
|
Tax Payable
|
980
|
5 700
|
1 340
|
8 840
|
|
Non Current Liabilities
|
|
|
|
|
|
Mortgage
|
|
18 000
|
|
20 000
|
|
Total Liabilities
|
|
23 700
|
|
28 840
|
|
Net Assets
|
|
$53 780
|
|
$53 400
|
|
|
|
|
|
|
|
Equity
|
|
|
|
|
|
Share Capital
|
|
35 000
|
|
29 000
|
|
Retained Earnings
|
|
18 780
|
|
24 400
|
|
|
|
$53 780
|
|
$53 400
|
* The (net) notation next to Accounts Receivable means this figure is net of the Allowance for Doubtful Debts
GOLDSTAR HOLDINGS LTD
INCOME STATEMENT
FOR THE YEAR ENDED 30TH June 2016
|
Net Sales
|
|
$104 000
|
|
Cost of Sales
|
61 800
|
|
|
less Discount Received
|
450
|
61 350
|
|
Gross Profit
|
|
42 650
|
|
|
|
|
|
Expenses:
|
|
|
|
Selling & Admin Expense
|
$20 160
|
|
|
Doubtful Debts Expense
|
430
|
|
|
Depreciation Expense
|
6 000
|
|
|
Interest Expense
|
2 680
|
29 270
|
|
Profit before Tax
|
|
13 380
|
|
Income Tax Expense
|
|
4 000
|
|
Profit
|
|
$ 9 380
|
REQUIRED:
a. Using the template provided, prepare a statement of cash flows. Show all calculations on the pro forma.
b. The owner of Goldstar Holdings Ltd can't understand why his increase in cash is so different to the profit figure. Explain to the owner at least two factors that may be causing this difference.
Question 4(a)
GOLDSTAR HOLDINGS LTD
Cash Flow Statement
FOR THE YEAR ENDED 30th JUNE 2016
|
|
$'000
|
|
$'000
|
|
Cash Flows from Operating Activities
|
|
|
|
|
Receipts from customers
|
|
|
|
|
Payments to suppliers & employees
|
|
|
|
|
Cash generated by operations
|
|
|
|
|
Interest paid
|
|
|
|
|
Income tax paid
|
|
|
|
|
|
|
|
|
|
Cash Flows from Investing Activities
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flows from Financing Activities
|
|
|
|
|
Payment of Mortgage
|
|
|
|
|
Proceeds from Share Issue
|
|
|
|
|
Dividends Paid
|
|
|
|
|
|
|
|
|
|
Net increase / decrease in cash held
|
|
|
|
|
Cash at the beginning of the year
|
|
|
|
|
Cash at the end of the year
|
|
|
|
Attachment:- Accounting for Business.rar