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 | ||||
Subtotal 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 |
(GST=10%)
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