Question: Could you show me the steps to solve this please? Water Play Pty Ltd sells inflatable water toys and other pool play items. You have
Could you show me the steps to solve this please?
Water Play Pty Ltd sells inflatable water toys and other pool play items. You have been asked to prepare budgets for the quarter ended March for the business based on the following information.
The Balance Sheet for Water Play Pty Ltd as at December ie previous quarter was as follows:
Current Assets
Bank
Inventory
Accounts Receivable
Prepaid insurance
Noncurrent Assets
Store furniture & fittings
Accumulated depreciation
Current liabilities
Accounts payable
Superannuation payable
PAYG WH Payable
GST clearing account
Noncurrent liabilities
Bank Loan
Total liabilities
Net Assets
Owners Equity
Credit sales for December were $ and of these were still outstanding on st December.
Credit purchases for December were $ and of these were outstanding on st December.
Prepaid insurance expires on February The new insurance policy will be paid on March for months and will be $ including GST Prepaid insurance at March should be $
Revenue
Income for January to March last year net of GST was:
January
February
March
Total
Revenue
$
$
$
$
Note: Sales for December were $ including GST and of this total was on still outstanding at st December.
Budgeted revenue is to be increased in accordance with organisational policies and procedures for budgeting.However in view of the business natureManagement has decided to stay at CPI as appropriate arrangement for current year's budget forecast.
Collection of revenue:
Sales are made up of cash and credit.
of the credit sales are collected in the month of sale and the balance are collected in the month following the sale.
Purchases
Credit purchases are estimated to be of sales each month. of purchases are paid for in the month of acquisition and the balance are paid for in the following month.
Monthly Cash expenses:
Rent $ Including GST
Leasing $ Including GST
Stationery $ Including GST
Electricity $ Including GST
Loan repayments $ per month no GST
Net Wages Paid $ per month. PAYG Withholding tax has been withheld. This needs to be paid by st of each month in accordance with ATO requirements.
Superannuation is of gross wages and is paid by st of the following month to employee superannuation funds as a means of managing cash flow.
Quarterly BAS Payment
Water Play lodge and pay their GST quarterly as per the ATO requirements. The liability owing at the end of the quarter is as per the GST Clearing Account.
Non Cash Expenses
Depreciation is $ per annum
Loan Interest $ for the quarter ended March
Inventory
Inventory is seasonal and expected value on hand on March is $ excluding GST
a Prepare a cash budget for the quarter ended March showing each month and the totals for the quarter.
b Prepare a Budgeted Income Statement for the quarter ended March
c Prepare a Budgeted Balance Sheet as at March
I started doing it but my teacher took a really long time to give me feedback and now i only have a few hours to get it finished i have attached the feedback i was provided so you can see where i made errors
Budgeted Income Statement for the quarter ended March
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
