ACX5903 Semester 2 2024 1 - Accounting Basics

Java Python ACX5903 Semester 2 2024

Assignment 1 - Accounting Basics

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: 23 August 2024, 11:55 PM

Part B: a 15-minute quiz to be completed between 4:30PM - 11:55PM, 30 August 2024

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 your student ID. E.g., if the last digit of your student ID number is 1, you should use the first data sheet.

You will be deducted 20% marks if you use the wrong datasheet.

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 Assessments.

If you are unable to submit Part A on time due to circumstances out of your control, you must apply for extensions or special consideration.

If you are unable to finish Part B during the designated period, you must apply for special consideration. The guidance on how to apply for extensions and special consideration is here.

Students who submit an assessment task after the due date will receive a late- submission penalty of 5 per cent ofthe 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 Assessments 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.

PART A

1.   Use an accounting worksheet to analyse transactions and balance-day adjustments for the month's activities, then record it in an excel worksheet. An Excel worksheet to assist you is available on Moodle.

2.   Based on your worksheet, prepare the Income Statement, Balance Sheet, and Statement of Cash Flows. Show all calculations. Please refer to the formats in the prescribed textbook.

3.  Calculate the profit if the business uses cash accounting. Show all calculations. 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.

4. You need to submit two pdf files. The first pdf file includes items  1-2 in the following table. The second pdf file includes items 3-8 in the following table.

     You need to submit:                                                             Score

1   Assessment Cover Sheet                                                           2

2   Datasheet                                                                               3

3   Worksheet                                                                              44

4   Income Statement for the month of June                                    8

5   Balance Sheet at 1 June (excluding transactions on 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&nbs ACX5903 Semester 2 2024 Assignment 1 - Accounting Basics p;a 15-minute quiz. The skills and knowledge required for the task are relevant to those required for Part A. The questions are either multiple choice questions or calculation questions.

If the last digit of your student ID number is 1, use this data sheet.

Proprietor: Ms. Nicole Coffeur Name: Teenage Style. Bag

Description: Hair and Beauty Salon

The business has the following opening balances:                 Additional Information:

Cash At Bank         $13,561                                          Bank loan interest rates (% per year)           8

Account Receivable      $19,245                                     Motor vehicle useful life (years)                      3

Motor Vehicle            $34,878                                       Motor vehicle scrap value ($)            3,890

Account Payable           $7,653                                      Insurance paid for (months)              3

Bank Loan (due 2027)         $28,929                             Rent paid for (months)               4

Hair Styling Equipment          $17,574                            Hair styling equipment useful life (years)           3

Hair Styling Supplies                 $759                             Hair styling equipment scrap value ($)           3,176

Capital               ?                                                       Closing stock of hair styling supplies on 30/6 ($)        679

                                                                                Staff work a 14 day fortnight and are paid on the 15th day.

Transactions:

Date                       Description                       Amount                 Date                  Description                         Amount

1-Jun Paid General Insurance          $2,709              2-Jun Motor Vehicle Expenses               $538

3-Jun Rent of Business Premises         $4,453              6-Jun Receive Payment from Account Customers          $1,990

6-Jun Facial services fees - Cash          $1,400            8-Jun Purchase books and magazines                 $100

8-Jun Hair styling fees - Account          $1,765            8-Jun Manicure services - Account             $1,349

11-Jun Cash Withdrawals by Owner       $802            12-Jun Hair styling fees - Cash                $1,074

12-Jun Facial services fees - Cash          $1,747           12-Jun Advertising Expense - Cash           $920

12-Jun Facial services fees - Cash            $1,593           13-Jun Hair styling fees - Cash               $1,423

14-Jun Receive Payment from Account Customers       $1,280          15-Jun Manicure services - Cash            $867

15-Jun Staff Wages          $2,419                         16-Jun Payment to Account Payable            $1,263

18-Jun Purchase hair styling supplies - account            $703              19-Jun Payment to Account Payable          $906

21-Jun Advertising Expense - Account             $1,165                  21-Jun Manicure services - Account             $1,329

24-Jun Hair styling fees - Account               $1,538                 24-Jun Additional cash contributed by owner           $2,644

28-Jun Sundry Expenses              $332                           29-Jun Manicure services - Cash                $952

29-Jun Staff Wages                       $2,419

Comments:

- Assume that this assignment involves an existing business that was purchased by the new owner on 1 June 2024.

- Note the list of transactions is in date order, left to right, line by line.

- Use three separate accounts for revenue, namely hair styling services, manicure services and facial services. 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.

- Round your calculations to the nearest dollar.

If the last digit of your student ID number is 2, use this data sheet.

Proprietor:    Mr. lsell Holmes

Name:           Realtor 21

Description:  Real Estate Agent

The business has the following opening balances:                                             Additional Information:

Staff work a 14 day fortnight and are paid on the 15th day