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

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more