Sitxfin401 interpret financial information projects

Question

Interpret financial information Projects-

Learning Outline - Within this resource, you will be covering the following key topics:

• Access and interpret financial information
• Use and provide financial information
• Use correct financial terminology.

Using these key topics as a guide, you will work with your trainer/assessor to develop your skills and knowledge. The role of your trainer/assessor is to assist and guide you through your learning journey to achieve your goals.

Project 1 -

Based on the principles of double-entry accounting and assuming that the following table is a general journal, indicate whether the accounting transaction requires a debit or credit by placing a tick or a cross in the appropriate box.

Accounting Transaction	Debit	Credit
Increase in cash in bank account
Decrease in sales revenue
Increase in rent expenses
Decrease in credit card liability
Decrease in postage expenses
Decrease in owner's equity
Decrease in non-current asset
Increase in bank loan
Increase in sales revenue
Increase in owner's equity

Match the financial information listed below (and on the next page) to the correct explanation by placing the correct number in the right hand column.

No.	Financial Information	Explanation	No.
1	Expenditure Report	A report showing GST collected and paid by the business and remitted to the ATO monthly, quarterly or annually.
2	Invoice	Used to record the transactions from source documents.
3	Journal	Provides a financial snapshot of the owner's equity (difference between asset and liability valuation) at the end of an accounting period
4	Accounts Payable	Shows the difference between actual performance and forecasted performance (the difference is usually expressed in both dollars and as a percentage)
5	Budget Report	Shows the allocated budget for all key financial indicators of the business
6	Chart of Accounts	Written acknowledgement that a specified article or sum of money has been received - it records the purchase of goods or a service.
7	Balance Sheet	The department (typically within larger organisations) that handles purchases and the payment of bills.
8	Accounts Receivable	Generally used to highlight the costs of doing business (C.O.D.B.) and usually includes a corresponding budget for each line of expense
9	Inventory Report	Allocates a general ledger code and is used to help organise and post financial transactions in a consistent and uniform manner.
10	Business Activity Statement	The record of either a sales transaction or a purchase transaction.
11	Cash Flow	The income derived by a business from sales of its products and services.
12	Variance Report	The department (typically within larger organisations) that handles sales and receipting payments from customers.
13	Revenue Summary	Tracks the flow of money into and out of the business.
14	Disbursement	This statement is made up of revenues received and expenses incurred for the period, highlighting the change in owner's equity with either a profit or loss.
15	Receipt	The act of paying out money.
16	Profit and Loss	Shows the closing stock on hand levels at the end of an accounting period

Project 2 -

Complete both variance columns of the following Profit and Loss statement ensuring that you signify negative variances by placing brackets around the calculated variance figures.

Around the World Travel Services Monthly Profit and Loss Statement (Final) as at 30 September 2013
Details	$ Actual	$ Budget *	$ Variance	% Variance
REVENUE (ex. GST)
Retail takings	54,000	45,000
Wholesale commission	8,000	5,000
Total Revenue	62,000	50,000
EXPENSES (ex. GST)
Variable operating expenses
Wages (casual consultants)	22,100	13,235
Advertising costs	3,500	600
Vehicle costs	3,000	400
Fixed operating expenses
Electricity (accrual)	350	350
Wages (permanent staff)	8,500	8,500
Rent	3,500	3,500
Water (accrual)	100	100
Gas (accrual)	500	500
Total operating expenses	41,550	27,185
NET OPERATING PROFIT	20,450	22,815

*NB:  Budget forecast figures were established in May 2013.

As the owner of Around the World Travel Services, you tried a new sales strategy during the month of September 2013.  This involved hiring a number of casual travel consultants to drive around to businesses in an attempt to 'drum up' new business.  You also needed to hire several rental cars.  In addition to this, you decided to heavily advertise through print and radio media.

a) Address the following questions (which relate to the above Profit and Loss statement, generated after implementing your new sales strategy) in the form of a report that might be required by management to monitor performance and / or assist with decision making.  You can answer each question individually or holistically.

i) What impact did the sales strategy have on your revenue?

ii) What impact did the sales strategy have on both your variable and fixed expenses?

iii) Explain why water, gas and electricity might be accounted for on an accrual basis?

iv) Explain why GST has not been accounted for / reported on the P&L.  How might GST instead be accounted for and reported?  Explain.

v) What part did the budgeted forecast play in the overall result (if any)?  Consider when the forecast was developed.

Project 3 -

Below is a sales report showing total retail takings for the last quarter (July, August and September) for all permanent sales consultants (including yourself).

Review this report and answer the questions below.

Sales Consultant	July	August	September	Total
Brown, Aaron	12,000.00	9,000.00	16,000.00	37,000.00
Davis, Tina	15,500.00	14,000.00	23,500.00	53,000.00
You	10,500.00	13,500.00	14,500.00	38,500.00
Total Sales:	38,000.00	36,500.00	54,000.00	128,500.00

a) Who has had the highest sales this quarter?  Include their total sales for the quarter in your answer.

b) Who has had the lowest sales for this quarter?  Include their total sales for the quarter in your answer.

c) Who had the best month during the quarter?  Include the month and sales figure in your answer.

d) Each of your sales consultants is entitled to 5% commission on total retail takings for the quarter.  How much will each consultant's commission be for this quarter as well as the total?  Show your calculations.  Do not calculate any commission for yourself.

Project 4 -

Below is the Balance Sheet for Around the World Travel Services as at 30 September 2013.

Review this report and answer the questions below.

Around the World Travel Services Balance Sheet as at 30 September 2013
Assets
Current Assets
Bank account	71,258.00
Cash Drawer	1,000.00
Trade Debtors	43,775.00
Total Current Assets	116,033.00
Non-Current Assets
Equipment @ Cost	25,000.00
Less Accumulated Depreciation	<4,270.00>
Total Non-Current Assets	20,730.00
Total Assets		136,763.00
Liabilities
Current Liabilities
Credit Card	5,525.00
Trade Creditors	20,899.00
GST Collected	13,215.00
less GST Paid	<11,578.00>
PAYG Payable	9,637.00
Superannuation Payable	6,800.00
Total Current Liabilities	44,498.00
Non-Current Liabilities
Bank Loan	20,000.00
Total Non-Current Liabilities	20,000.00
Total Liabilities		64,498.00
Net Assets
Equity
Capital from Owner / Shareholders	5,000.00
Current Year's Earnings	67,265.00
Retained Earnings	0.00
Total Equity		72,265.00

a) How much GST is owed to the ATO based on this balance sheet?  Show your calculations.

b) How much PAYG is owed to the ATO based on this balance sheet?

c) How much is owed in total to the ATO based on this balance sheet?  Show your calculations.

d) How much is owed in superannuation based on this balance sheet?

e) If all of these payments were made on 1 October 2013, how much money would be left in the business bank account?  Show your calculations.

f) How much is owed to your suppliers?

g) Using your bank balance calculated in (e), how much would you have left in your bank account if you paid your suppliers in full?  Show your calculations.

Attachment:- Assignment.rar