Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. 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:

  1. Which month has the highest payments, what causes this?
  2. What advice would you give about the purchase of capital items?
  3. Approximately what effect would not purchasing the capital items have?
  4. Which month has the highest revenue received?
  5. 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?
  6. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Aided Fraud Prevention And Detection A Step By Step Guide

Authors: David Coderre

1st Edition

0470392436, 978-0470392430

More Books

Students also viewed these Accounting questions