Reference no: EM131950382

Assignment -

Golden Horn is a sole trader operating as a wholesaler in the paint industry. She is considering expanding the business and needs to know if future cash flows are sufficient to fund the expansion or whether additional external borrowings wilt be needed in part or in full.

All other Wholesalers in the industry offer retail paint shops extended credit terms.

Golden Horn is required to maintain extensive levels of inventory to satisfy customer demands.

The paint manufacturers offer the wholesalers credit terms.

The premises are rented and located in an industrial estate. The lease agreement has six years to run with an option to renew for an additional six years ensuring a reasonable level of continuity at the same location. The premises are sublet to a business to defray some of the monthly rental costs.

Distribution of the paint to the retail paint shops is outsourced to the local transport company on a needs basis. This relieves him of maintaining his own tracks and associated labour costs.

Golden Horn is registered for GST, reporting quarterly on an Accruals Basis. The GST Payable per the Balance Sheet ac 31 March is payable by 21 April. The GST rate is 10%.

A balance sheet as at 31 March has been produced and provides the opening balances for the period commencing 1 April.

Golden Horn Balance Sheet as at 31 March

Current Assets
Accounts Receivable		$137,808
Cash at Bank		$40,000
Inventory		$18,200	$196,008
Non-Current Assets
Plant and Equipment (at cost)	$140,000
Accumulated Depredation on Plant & Equipment	$52,000	$92,000
Office Equipment (at cost)	$65,000
Accumulated Depredation on Office Equipment	$20,000	$45,000	$137,000
Total Assets			$329,008
Current Liabilities
Trade Creditors		$45,300
GST Payable		$8,000
Non-Current Liabilities
5.4% Loan (due in 2 years)		$110,000
Total Liabilities			$163,300
Net Assets			$165,708
Proprietors Equity
Capital			$115,200
Accumulated Profits			$50,508
			$165,708

Data and Supporting Information

Sales - Sales (in dollars excluding GST).

Actual	January	$75,000
	February	78,000
	March	85,200
Forecast	April	$86,100
	May	90,500
	June	87,500
	July	85,000

Accounts Receivable (Debtors) -

Current industry experience reveals the Following pattern of debtors' collections.

All sales are on credit and each month's invoices are mailed On the last day of the month of sale. The historical collection pattern is:

• 50% pay within 30 days of invoice date.
• 30% pay between 30 and 60 days of invoice date.
• 20% pay between 60 and 90 days of invoice date.
• 90% of sales are on credit; the remainder arc cash. GST applies to all sales.

Purchases and Accounts Payable -

The only Accounts Payable are for purchases of paint stock. All other expenses are paid in cash.

The markup on cost for paint averages 70%.

Closing inventory for each month should represent 30% of the next month's sales in units (cost of sales).

All purchases for a month are paid for in the month following the purchase. GST applies to all paint purchases.

Rent Revenue -

Golden sublets space in her warehouse to another business. She charges a monthly rent of $500 plus GST which will rise to $530 plus GST in June, The tenant meets all his own power and utility costs; the rental amount includes a portion of the rent and other costs associated with the building.

Operating Expenses -

Administration costs (excluding depreciation and rent) represent 20% of each month's purchases and are paid in cash in the month in which they are incurred. GST applies.

Depreciation is charged to the accounts at the rate of:

Plant and equipment (marketing) - 15% per year on cost.

Office equipment - 12% per year on cost.

Marketing and Distributing costs represents 10% of each month's sales and are paid in the month in which they are incurred. GST applies.

Loan interest is paid at the end of each month at the rate of 5.4% per year. (The mortage is an interest only loan with the principal due next year {Not subject to GST}).

Property rental (commercial) of $4,000 plus GST is paid at the beginning of each month.

As the accountant, you have been instructed to produce budgets that will be the basis for management decisions, and support any borrowing submissions made to financial institutions.

Required: Based on your accounting experience and after discussions with the proprietor it was decided that your brief would be to prepare the following:

Prepare month-by-month budgets for the three months ending 30 June 2016:

(a) Sales budget.

(b) Purchases budget.

(c) Cost of Goods Sold budget.

(d) Expenses budget.

(e) Cash Receipts budget.

(f) Cash Payments budget.

(g) Cash Budget.

(h) GST payable ledger account.

All monetary amounts should be rounded to the nearest dollar.

Attachment:- Assignment File.rar