Question
The information in the table is based on source documentation from the companys previous operations. GST Expenses are shown. September December March June Motor vehicle
- The information in the table is based on source documentation from the companys previous operations. GST Expenses are shown.
September | December | March | June | |
Motor vehicle | 1,300 | 1,495 | 300 | 450 |
Printing | 200 | 50 | 200 | 50 |
Electricity | 600 | 555 | 500 | 500 |
Rent | 4,500 | 4,500 | 4,500 | 4,500 |
Depreciation is $700 per quarter and tax payable at 30% of net profit per quarter. Wages for the senior staff are $8,000 per quarter and junior $5,000.
Complete the expense budget, budgeted statement of financial performance; you will need to add the non GST items to the expense budget, and the cash flow budget which has an opening cash balance of $42,000. The opening GST liability is 2,000 and the opening PAYG tax instalment is 2,500.
Voyager Co. Expense Budget 30 June | ||||
September | December | March | June | |
Cash Expenses | ||||
Motor vehicle | ||||
Printing | ||||
Electricity | ||||
Rent | ||||
Sub Total GST inclusive | ||||
GST | ||||
Net of GST | ||||
Wages Senior | ||||
Wages Junior | ||||
Sub Total Cash Items | ||||
Depreciation | ||||
Total |
Voyager Co. Budget statement of financial performance 30 June | |||||
September | December | March | June | Liability | |
Service revenue | |||||
Less Expenses | |||||
Subtotal | |||||
Income tax 30% | |||||
Net Profit |
Voyager Co GST Budget 30 June | |||||
September | December | March | June | Liability | |
GST Collected on Sales | |||||
GST Paid on Expenses | |||||
GST Paid on Capital Acquisitions | |||||
Net GST |
Voyager Co. Budget statement of cash flows 30 June | ||||
September | December | March | June | |
Opening Cash | ||||
Add Collections from revenues | ||||
Total cash available | ||||
Less estimated cash payments | ||||
Cash Payments in expense budget | ||||
Capital Expenditures | ||||
GST Payments* | ||||
Tax payments | ||||
Total | ||||
Closing cash balance | ||||
*Includes GST from capital expenditure and GST items in expense budget |
2) Use the cash budget to prepare a graph of quarterly revenue received, payments made and closing cash position.
3) Explain the graph by answering:
- Which month has the highest payments, what causes this?
- What advice would you give about the purchase of capital items?
- Approximately what effect would not purchasing the capital items have?
- Which month has the highest revenue received?
- Describe the position of closing cash throughout the year. The owner realises that there will be significant expenses in this first year of operations. Identify in which quarter the milestone of revenues exceeding expenditures occurs. What effect does this have on cash?
- What advice would you give about the paying of a $1,000 bonus to the junior staff in June promised in the September quarter based on the staffs performance and the financial performance of the business for the year?
In context of Australia . Please complete the answer donot copy paste from other source
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started