Sitxfin002 interpret financial information | Accounting homework help

Task 1

Answer the following questions:

1. What are meant by the terms assets and liabilities?

2. What is a bank statement and how does it assist in identifying discrepancies?

3. What is the GST, who pays it and how is it calculated when shown as a GST exclusive price and as a GST inclusive price?

4. Describe the differences between accrual accounting and cash accounting?

5. Explain the following:

a. General ledger

b. Chart of accounts

c. Journals

d. Double entry accounting

Task 2

Using the following ledgers and bank statement answer the following questions.

Cash Receipts Journal

CASH RECEIPTS JOURNAL OF THE RESORT – STUDENTS LODGE – JULY 20XX

Day

Description

Bank

Food

Beverage

Accommodation

1

Days takings – food

$ 764.00

$ 764.00

Days takings – beverage

$1375.00

$1375.00

3

Days takings – beverage

$5000.00

$5000.00

7

Days takings – food

$6400.00

$6400.00

10

Takings – Accommodation

$10125.00

$10125.00

17

Takings – Accommodation

$3775.00

$3775.00

Days takings – beverage

$1045.00

$1045.00

21

Days takings – food

$4675.00

$4675.00

25

Days takings – food

$4880.00

$4880.00

31

Days takings – beverage

$6500.00

$6500.00

31

Balance b/d

$5544.00

TOTAL

$50083.00

$11839.00

$13920.00

$18780.00

T-1.8.1

Finance 1 Assessment Task 1, v1.0

Last updated on 15/05/2017 Page 6

Cash Payment Journal

CASH PAYMENTS JOURNAL FOR THE RESORT – STUDENTS LODGE – JULY 20XX

Date

Chq No

Payee

Details

Bank

Purchase Food

Purchase Beverage

Wages

Advertising

Insurance

Misc

1/7/XX

1101

No Spots

Laundry

$1000.00

$1000.00

1102

One Stop Food

Purchases – Food

$4150.00

$4150.00

3/7/XX

1103

Cash Wages

Wages

$2625.00

$2625.00

7/7/XX

1104

Integra Energy

Electricity

$315.00

$315.00

10/7/XX

1105

Cash Wages

Weekly Wages

$2625.00

$2625.00

14/7/XX

1106

Cowan Comps

Purchase of new computer

$1750.00

$1750.00

17/7/XX

1107

Cash Wages

Weekly Wages

$2625.00

$2625.00

22/7/XX

1108

Finley Gellars

Purchases – liquor

$4750.00

$4750.00

24/7/XX

1109

Cash Wages

Weekly Wages

$2625.00

$2625.00

1110

Cash

Purchases Beverages

$2000.00

$2000.00

26/7/XX

1111

Office Supplies

Stationery

$995.00

$995.00

29/7/XX

1112

News Ltd

July’s advertising

$325.00

$325.00

1113

ITT Insurance

Insurance premium

$4145.00

$4145.00

31/7/XX

1114

Cash Wages

Weekly Wages

$2625.00

$2625.00

1115

ANZ Bank

Interest on mortgage

$1458.00

$1458.00

1116

Cash- Food

Purchase Food

$4875.00

$4875.00

1117

ABC Office

July’s stationery

$107.00

$107.00

Total

$38995.00

$9025.00

$6750.00

$13125.00

$325.00

$4145.00

$5625.00

T-1.8.1

Finance 1 Assessment Task 1, v1.0

Last updated on 15/05/2017 Page 7

Bank Statement

ACADEMIES BANK

THE RESORT – STUDENTS LODGE

STATEMENT FOR THE MONTH OF: JULY 20XX

JUL- XX

Debit

Credit

Balance

1

Balance brought forward

2

Deposit

$2139.00

$2139.00

Cr

3

Cheque

103

$2625.00

$486.00

Dr

6

Deposit

$5000.00

$4514.00

Cr

Cheque

1101

$1000.00

$3514.00

Cr

8

Deposit

$6400.00

9914.00

Cr

10

Deposit

$3775.00

13689.00

Cr

Cheque

1107

$2625.00

11064.00

Cr

11

Cheque

1102

$4150.00

6914.00

Cr

15

Deposit

$1045.00

7959.00

Cr

17

Cheque

1110

$2000.00

5959.00

Cr

18

Cheque

1109

$2625.00

3334.00

Cr

Deposit

$10125.00

13459.00

Cr

19

Cheque

1104

$315.00

13144.00

Cr

Cheque

1108

$4750.00

8394.00

Cr

26

Cheque

1111

$995.00

7399.00

Cr

27

Deposit

$4675.00

12074.00

Cr

29

Cheque

1112

$325.00

11749.00

Cr

Cheque

1113

$4145.00

7604.00

Cr

30

Deposit

$4880.00

12484.00

Cr

Cheque

1105

$2625.00

9859.00

Cr

Cheque

1106

$1750.00

8109.00

Cr

31

Cheque

1114

$2625.00

5484.00

Cr

Cheque

1115

$1458.00

4026.00

Cr

B/Fees

$8.00

4018.00

Cr

1. Complete a bank reconciliation, the balance in the general ledger account as at 30 June 20XX was $0 as this is the first month the profit centre of the Backpackers Lodge has commenced. (Excel file)

2. Complete a Cash Balance Summary (Excel file)

3. Complete a Bank deposit slip for the cheque deposited on the 18th July 20XX (at the bottom off assessment)

4. Complete a Profit and Loss Statement for the month of July 20XX (Excel file)

T-1.8.1

Finance 1 Assessment Task 1, v1.0

Last updated on 15/05/2017 Page 8

5. Business Activity Statement Locate the BAS form by visiting the Australian Tax Office (ATO) website (https://www.ato.gov.au/Forms/BAS-A—quarterly-BAS/). Print, complete and submit the form with this assessment

Task 3

Complete and answer the following table

Complete the following – don’t round off calculations Budget as a model Regular Queen size Total

Rooms

40

20

60

Occupancy

60%

60%

Rooms sold per day

by 30 days

Room nights

Nightly tariff

$ 85

$ 100

Revenue

Manipulating the model (1) Regular Queen size Total

Rooms

40

75%

15

20

60

Occupancy

75%

75%

Rooms sold per day

by 30 days

Room nights

Nightly tariff

$ 85

$ 95

Revenue

Manipulating the model (2) Regular Queen size Total

Rooms

40

20

60

Occupancy

55%

55%

Rooms sold per day

by 30 days

Room nights

Nightly tariff

$ 80

$ 100

Revenue

Manipulating the model (3) Regular Queen size Total

Rooms

40

63%

13

20

60

Occupancy

50%

50%

Rooms sold per day

by 30 days

Room nights

Nightly tariff

$ 75

$ 100

Revenue

The best outcome model for maximum sales is?

T-1.8.1

Finance 1 Assessment Task 1, v1.0

Last updated on 15/05/2017 Page 9

Task 4A

Iain Hew owns The French Travel Agency, at Cape Drayton, Queensland and is thinking of buying new office furniture in three months’ time (December, 20XX) at a cost of $65,000. The old furniture will be sold at that time for $3,000. Assume an opening bank balance of $50,000 at the beginning of October. Other details include:

1. Iain estimates $70,000 sales for each month. Half these sales are received in cash and half are received in the next month as they are credit sales. Octobers credit sales from September, amount to $35,000.

2. Purchases amount to 25% of sales (excluding scrap) and are paid for in cash.

3. Labour costs are $20,000 each month.

4. Superannuation ($3,000), rent (3,000), energy bills ($2,000), miscellaneous ($2,500) are all paid monthly.

5. Transport costs to the dock, town accommodation areas, and general couriering work amount to $1,000 per month.

6. Rates are paid once in October of $5,000. Requirements:

1. Prepare a cash budget for each month for The French Travel Agency, with the view to advising Iain whether he is in a position to pay $65,000 cash for the furniture at the end of the third month (December). Include also an accurate heading for this cash budget.

2. Suppose your balance at end was negative, what (new approaches) actions to rectify the problem would you consider?

3. Who would you consult and inform in relation to resource decisions?

Cash budget for the three months ending 31/12/08 October November December Quarter Cash receipts Cash sales Debtors Scrap Total cash receipts Cash payments Purchases Labour cost Superannuation Rent Energy bills Miscellaneous Transport and couriers Rates New bread oven Total cash payments Surplus / Deficit Cash balance at start Cash balance at end

T-1.8.1

Finance 1 Assessment Task 1, v1.0

Last updated on 15/05/2017 Page 10

Task 4B

Recalculate The French Travel Agency’s cash budget for the same period if:

1. sales still averaged $70,000 per month,

2. with sales averaging 90% cash and 10%, debtors for September were $ 6,000

3. purchases averaging 30% of sales

4. bank balance to start was $4,000

5. all else remains the same.

6. is there a problem with resource decisions?

Cash budget for the three months ending 31/12/08 October November December Quarter Cash receipts Cash sales Debtors Scrap Total cash receipts Cash payments Purchases Labour cost Superannuation Rent Energy bills Miscellaneous Transport and couriers Rates New bread oven Total cash payments Surplus / Deficit Cash balance at start Cash balance at end

T-1.8.1

Finance

Essay Help
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.