QUESTION 1: Balance Day Adjustments (23 marks)
Below is the unadjusted Trial Balance for Pool Wave, a pool product and maintenance shop owned and operated by Wade Wilson, as at 30 June 2018.
Pool Wave
Unadjusted Trial Balance
As at 30 June 2018
Debit ($) | Credit ($) | |
Cash at Bank | 26,766 | |
Accounts Receivable | 31,875 | |
Inventory | 140,400 | |
Prepaid Insurance | 4,914 | |
Office Supplies on hand | 3,276 | |
Furniture & Fittings | 39,780 | |
Accumulated Depreciation – Furniture & Fittings | 11,934 | |
Cleaning Equipment | 46,800 | |
Accumulated Depreciation – Cleaning Equipment | 18,720 | |
Accounts Payable | 27,027 | |
Loan Payable | 117,000 | |
W. Wilson – Capital | 66,222 | |
W. Wilson – Drawings | 28,080 | |
Sales Revenue | 691,029 | |
Sales Returns and Allowances | 9,924 | |
Cost of Good Sold | 412,308 | |
Discount received | 12,957 | |
Freight inwards | 9,360 | |
Sales Salary Expense | 68,328 | |
Delivery Expense | 18,252 | |
Advertising Expense | 26,910 | |
Rent Expense | 28,548 | |
Office Salaries Expense | 33,750 | |
Electricity Expense | 8,832 | |
Discount Allowed | 6,786 | |
Totals | 944 889 | 944 889 |
(Continued on the next page)
Estimated Useful life | Estimated Residual | |
Furniture & Fittings | 8 years | $1 780 |
Cleaning Equipment | 10 years | $2 100 |
REQUIRED:
It is now the end of the financial year and Wade has asked you to prepare any necessary balance day adjusting journals.
Use the General Journal document provided to record the correctly formatted journal entries required.
IMPORTANT* Journals must be correctly formatted and must include a date and a narration (explanation) for each entry. Marks will be deducted if this instruction is not followed.
(23 marks)
Pool Wave General Journal
Date | Details | Debit ($) | Credit ($) |
QUESTION 2: Financial Statements (20 marks)
Tony Stark owns and operates a dry cleaning and pressing business called “Ironing Man”. At year end Tony has prepared the following partially completed Trial Balance. Tony knows it is not in the correct order and he has not yet included all the Balance Sheet accounts. There is however sufficient information to complete an Income Statement.
IRONING MAN
TRIAL BALANCE
AS AT 30 JUNE 2018
Debit ($) | Credit ($) | |
Shop Shelving | 255 000 | |
Delivery Van | 120 000 | |
Sales | 1 560 000 | |
Purchases | 576 000 | |
Insurance Expense | 19 500 | |
Allowance for Doubtful Debts | 4 932 | |
Accounts Receivable | 82 200 | |
Bank Overdraft | 3 000 | |
Shop Water Expense | 12 000 | |
Discount Received | 6 000 | |
Interest Expense | 12 300 | |
Office Water Expense | 4 140 | |
Loan (repayable 1 Oct 2019) | 138 000 | |
Discount Allowed | 3 450 | |
Bookkeepers Wages | 75 000 | |
Shop Staff Wages | 256 386 | |
Accumulated Depreciation – Office Furniture & Fittings | 18 900 | |
Accounts Payable | 23 268 | |
Doubtful Debts | 4 932 | |
Freight Inwards Expense | 6 450 | |
Advertising Expense | 14 100 | |
Shop Rent Expense | 196 000 | |
Office Cleaning Expense | 35 400 | |
Depreciation – Shop Shelving | 36 000 | |
Interest Received | 4 500 | |
Unearned Revenue | 3 600 | |
Depreciation – Delivery Van | 30 000 | |
Accumulated Depreciation – Shop Shelving | 72 000 | |
T. Stark, Capital (1 July 2017) | 400 650 | |
Depreciation – Office Furniture & Fittings | 18 900 | |
Inventory (1 July 2017) | 157 200 | |
Office Furniture and Fittings | 96 000 | |
Office Rent | 53 750 | |
Freight Out | 22 260 | |
Electricity Expense | 29 100 | |
Purchase Returns and Allowances | 18 600 | |
T. Stark, Drawings | 108 000 | |
Sales Returns & Allowances | 2 850 | |
Shop Cleaning | 21 600 | |
(Continued on the next page)
Tony has provided the following additional information to assist in your statement preparation:
REQUIRED:
Prepare a fully classified Income Statement using the partially completed Trial Balance and additional information provided. (20 Marks)
Answer on following pages (insert additional pages if required)
QUESTION 3: Accounting Concepts (12 marks), Communication (9 Marks)
Part 1: The Business Letter
You are employed as a graduate accountant in a mid-tier accounting firm called Professional Accounting Solutions. As part of your ongoing professional development, the Managing Partner periodically presents you with a client’s financial statements and asks you for comments in your own words (using references where appropriate), to demonstrate your understanding of various accounting concepts and assumptions.
This year, the managing Partner has provided you with the reports of Cycles’R Us and has asked that you write a formal business letter to her addressing the technical issues referred to below. She will then keep the letter on your employment file. The letter should be no more than 300 – 400 words (maximum). Penalties may be applied if the word limit is exceeded.
REQUIRED:
On the following page, you are required write a letter in your own words to Christine Daniels (Managing Partner) addressing the three issues referred to below.
You have been presented with the accounts of Cycles’R US (a cycling shop owned and operated by Judy Wheeler) for the year ending 30 June 2018, and asked to explain the following:
(3 marks)
CYCLES’ R US
Balance sheet extract
as at 30 June 2018
Computer $2 000
Less Accumulated Depreciation 200 $1 800
The remaining 3 marks will be awarded for following the formatting requirements below.
Part 2: Use of communication skills (9 Marks)
The following aspects of your written communication skills development will be awarded a total of 9 marks.
BEING RELEVANT
Does what is written contribute to answering the question(s)
Mark (maximum 3):
WRITING FOR A PROFESSIONAL BUSINESS AUDIENCE (including good presentation)
Good presentation
Mark (maximum 6):
TOTAL WRITTEN COMMUNICATION SKILLS MARK (maximum 9)
Answer on following page
QUESTION 4: Cash Flow Statement (16 marks)
You are provided with the following financial information for Dwayne Pipe Plumbing:
DWAYNE PIPE PLUMBING
COMPARATIVE BALANCE SHEETS
AS AT 30 JUNE
Current Assets |
2019 | 2018 | ||
Cash on Hand | $1 200 | $4 000 | ||
Cash at Bank | – | 1 009 | ||
Accounts Receivable (net) | 5 200 | 4 500 | ||
Inventory | 28 000 | 18 000 | ||
Prepaid Expenses | 1 650 | $36 050 | 650 | $28 159 |
Non-Current Assets | ||||
Plant & Equipment | 83 500 | 64 000 | ||
Less:Accum. Depreciation | (23 000) | 60 500 | (17 600) | 46 400 |
Total Assets | 96 550 | 74 559 | ||
Current Liabilities | ||||
Bank Overdraft | 6 402 | – | ||
Accounts Payable | 4 000 | 2 800 | ||
Expenses Payable | 780 | 790 | ||
Tax Payable | 890 | 12 072 | 1 200 | 4 790 |
Non-Current Liabilities | ||||
Bank Loan | 20 000 | 20 000 | ||
Total Liabilities | 32 072 | 24 790 | ||
Net Assets | $64 478 | $49 769 | ||
Equity | ||||
Capital – D.Pipe | 64 478 | 49 769 | ||
$64 478 | $49 769 |
(Continued on the next page)
DWAYNE PIPE PLUMBING
INCOME STATEMENT
FOR THE YEAR ENDED 30 JUNE 2018
Net Sales | $107 000 | |
Cost of Sales | 45 200 | |
Gross Profit: | 61 800 | |
Other Revenue: | ||
Discount Received | $280 | |
Interest Revenue | 40 | 320 |
62 120 | ||
Expenses: | ||
Selling & Admin Expense | 16 500 | |
Doubtful Debts Expense | 354 | |
Depreciation Expense | 5 400 | |
Interest Expense | 3 800 | 26 054 |
Profit before tax | 36 066 | |
Income Tax Expense | 3 378 | |
Profit | $32 688 |
ANSWER THIS QUESTION ON THE PRO FORMA PROVIDED
REQUIRED:
(15 marks)
DWAYNE PIPE PLUMBING
CASH FLOW STATEMENT
FOR THE YEAR ENDING 30 JUNE 2018
$ | $ | ||
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 | |||
Interest received | |||
Payment for Plant & Equipment | |||
Cash Flows from Financing Activities | |||
Drawings | |||
Net increase / decrease in cash held | |||
Cash at the beginning of the year | |||
Cash at the end of the year |
ALL WORKINGS MUST BE PRESENTED BELOW OR YOUR CASH FLOW STATEMENT WILL RECEIVE NO MARKS
The following aspects of students’ written communication skills development are also awarded a total of 9 marks.
PARAPHRASING
Mark (maximum 3 marks)
BEING RELEVANT
Does what is written contribute to answering the question(s)
Mark (maximum 3 marks)
WRITING FOR A PROFESSIONAL BUSINESS AUDIENCE (including good presentation)
Good presentation
Mark (maximum 3 marks)
TOTAL WRITTEN COMMUNICATION SKILLS MARK (Maximum 9 marks)
Acknowledgement:
We acknowledge the kind assistance and cooperation of Heather Prider and Phil Johnson of UniSA in allowing access to their materials for the purpose of the assignment.