ACX5903 Semester 2 2003 Assignment 1
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
ACX5903 Semester 2 2003
Assignment 1 – Accounting Basics
Chief Examiner: Dr Sandip Dhole
Assessment marks:
This assignment accounts for 15% (part A 10% and part B 5%) of the total marks for the unit. The assignment must be completed and submitted individually.
Due Date:
Part A: 11:55 pm (AEST) 25th August 2023
Part B: a 19-minute quiz to be completed between 4:30 pm – 11:55 pm (AEST) 1st September 2023
Objective:
The assignment's objective is to give you experience in recording business transactions and preparing and evaluating (where appropriate) financial reports for a service business.
Data Sheet:
The datasheet is available at the end of this document.
The datasheet is assigned to students based on the last digit of their student ID number. E.g., if the last digit of your student ID number is 1 or 2, you should use the first datasheet. Using the wrong datasheet will result in a penalty of 1 mark.
Requirements:
Submission Details:
The Assignment consists of two parts. Part A must be submitted through Moodle. The link for the submission is under the section titled Assignment 1.
If you are unable to submit Part A, on time due to circumstances out of your control, you must apply for special consideration using the Special Consideration block on Moodle.
If you are unable to finish the quiz in Part B, you must apply for special consideration using the Special Consideration block on Moodle.
. Students who submit an assessment task after the due date will receive a late-submission penalty of 10 per cent of the available marks in that task. Tasks submitted more than seven days after the due date will receive a mark of zero for that task. The detailed university policy is here.
. Assignment Part A must be submitted with the Faculty cover sheet attached. The cover sheet can be accessed in the Assignments section on Moodle.
. If you are a student registered with Disability Support Services and require approved forms of support to complete this assignment, please notify the Chief Examiner at least one week before the due date.
1. Using the information in the datasheet, please analyse the transactions and balance-day adjustments for the month’s activities. This worksheet (Microsoft Excel) is available on Moodle.
2. Based on your worksheet, prepare the Income Statement, Balance Sheet, and statement of Cash Flows. Please refer to the formats in the prescribed textbook.
3. Calculate the profit if the business uses cash accounting. Compare the profit from cash and accrual accounting for the business and give 3 reasons why the amounts are different. Explain which accounting method is better for the business in your datasheet.
You need to submit: Score
2 Datasheet 3
3 Worksheet 44
4 Income Statement for the month of June 8
5 Balance Sheet at 1 June 5
6 Balance Sheet at 30 June 8
7 Classified Statement of Cash Flow for the month of June 10
8 Analysis of difference between two profit numbers 20
Total 100
Note:
· Use the Notes column of the Worksheet to describe the type of expense and income – this will make your preparation of the Income Statement easier;
You may need to add the column headings of the accounting worksheet (i.e. the account names) and/or add columns/rows;
· You must show and explain your calculation of the values of all adjusting entries. This can be provided either in the Worksheet or on separate pages;
· Formatting: ensure it fits well on an A4 page and is readable at Moodle.
· The Statement of Cash Flows must be classified, i.e. cash flows must be shown in the categories of operating, investing, and financing cash flows;
· You must use the Direct Method to prepare the Statement of Cash Flows. Show all calculations;
Round all monetary amounts to the nearest dollar;
· All non-current assets are depreciated using the straight-line method
PART B
Part B consists of a 10-minute quiz. The skills and knowledge required for the task are relevant to those required for Part A.
Use this datasheet if the last digit of your Student ID number is 1 or 2.
Proprietor: Ms Enid Blackwell
Business Name: Your Dream Home Ltd
Business Type: Real Estate
Business Opening Balances: |
Additional Information: |
|||
Cash at Bank |
$21,563 |
|
Bank loan interest rates (% per year) |
10 |
Account Receivable |
$23,534 |
|
Motor vehicle useful life (yeas) |
6 |
Motor Vehicle |
$45,050 |
|
Motor vehicle scrap value ($) |
$6,731 |
Account Payable |
$13,914 |
|
Insurance paid for (months) |
4 |
Bank Loan (due 2025) |
$38,313 |
|
Rent paid for (months) |
4 |
Furniture |
$33,522 |
|
Furniture useful life (years) |
2 |
Promotional Material Supplies |
$866 |
|
Furniture scrap value |
0 |
Capital |
? |
|
Closing stock of promotional materials 30/6 ($) |
$1,247 |
|
|
|
Staff work a 14-day fortnight and are paid on the 15th day. |
|
Transactions |
||||||
1-Jun |
Paid General Insurance |
$4,455 |
|
3-Jun |
Rent of Business Premises |
$5,840 |
4-Jun |
Rental commission - Cash |
$2,727 |
6-Jun |
Rental commission - Account |
$2,010 |
|
8-Jun |
Purchase promotional materials |
$1,388 |
9-Jun |
Receive Payment from Account Customers |
$2,889 |
|
12-Jun |
Advertising placement fees - Cash |
$1,058 |
12-Jun |
Cash Withdrawals by Owner |
$1,556 |
|
13-Jun |
Advertising placement fees - Account |
$1,314 |
14-Jun |
Advertising placement fees - Account |
$1,461 |
|
15-Jun |
Advertising Expense - Account |
$2,204 |
15-Jun |
Rental commission - Cash |
$2,540 |
|
15-Jun |
Staff Wages |
$3,243 |
16-Jun |
Payment to Account Payable |
$2,192 |
|
16-Jun |
Advertising placement fees - Cash |
$1,127 |
17-Jun |
Receive Payment from Account Customers |
$1,965 |
|
20-Jun |
Motor Vehicle Expense |
$471 |
20-Jun |
Auction commission - Cash |
$2,567 |
|
20-Jun |
Auction commission - Account |
$1,593 |
20-Jun |
Sundry Expenses |
$414 |
|
24-Jun |
Auction commission - Cash |
$2,745 |
27-Jun |
Auction commission - Account |
$1,190 |
|
27-Jun |
Advertising Expense - Cash |
$1,467 |
27-Jun |
Additional cash contributed by owner |
$4,769 |
|
28-Jun |
Payment to Account Payable |
$1,788 |
29-Jun |
Rental commission - Account |
$2,171 |
|
29-Jun |
Staff Wages |
$3,243 |
|
|
|
Comments:
- Assume that this involves an existing business that was purchased by the new owner on 1 June 2022.
- Use three separate accounts for revenue: rental commission, auction commission and advertisement placement fees. All revenues relate to the month of June.
- Transactions involve cash unless specified as ‘Account’ .
- Record payments for rent and insurance in prepaid accounts initially.
- Information relevant to complete adjusting entries can be found in the top right section of this page.
- The periods to which the rent and insurance apply commence on 1 June.
2023-08-24
Accounting Basics