SITXFIN002 Interpret Financial Information Assignment
Order ID: 89JHGSJE83839 Style: APA/MLA/Harvard/Chicago Pages: 5-10 Instructions:
SITXFIN002 Interpret Financial Information Assignment
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
Julys 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
Julys 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 dont 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 Agencys 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 start Cash balance at end
SITXFIN002 Interpret Financial Information Assignment
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow SITXFIN002 Interpret Financial Information Assignment
SITXFIN002 Interpret Financial Information Assignment