Hi, can you help me with this? The information to complete the required is in the screenshots below.

Required:

Complete the following schedules and accounts for the budget:

a)Sales budget with a schedule of expected cash collections;

b)Purchases budget;

c)Selling and administrative costs budget;

d)Cash budget;

e)Budgeted Income statement for the Apr-Jun quarter; and

f)A Budgeted Balance sheet for the end of the quarter.

Expected sales (units) m 18,000 68,000 25,000 29,000 45,000 Further information: 0 Each unit is sold for 512 0 Cost of goods sold are 50% of sale price a 70% of sales are cash {received in the month of sale) 0 30% is collected in the following month Purchases The inventory at the end of each month is to be 20% of next month's sales. This inventory is produced to ensure there are goods for sale at the start of the month. As can be seen from the balance sheet, there are 524,000 of goods in the inventory. This is the equivalent of 4,000 units. The inventories are paid for 50% in the month of purchase and 50% in the following month. Selling and administrative costs, including depreciation The variable element of Selling and Administration costs if 50.80 per unit sold {not produced}. The xed costs excluding depreciation are 574,500 per month. Depreciation is $45,000 per quarter. Capital expenditure Goldstar intends to buy more equipment. This will cost $205,700 in May and $28,300 in June. Financing Goldstar Ltd is paying back $6,000 of the principal of the short-term loan per month, along with the interest on the remaining loan balance at a rate of 8% per annum. The mortgage is currently interest-only at a rate of 4% per annum. A dividend of 519,000 will be paid in April. The following information relates to the operations of Goldstar Ltd. Prepare a full budget for Goldstar Led, including the cash budget, budgeted income statement and the budgeted balance sheet for the end of the quarter. Balance sheet for the quarter ending 31 March 2020 $ un ASSETS Current Assets Cash 21,000 Accounts receivable 45,000 Inventory 24,000 Total Current Assets 90,000 Non-current Assets Equipment 265,000 Land 85,000 Total Non-current Assets 350,000 TOTAL ASSETS 440,000 Liabilities Current Liabilities Accounts payable 7,000 Short-term loan 40,000 Total Current Liabilities 47,000 Non-Current Liabilities Mortgage 100,000 Total Liabilities Equity Share capital 100,000 Retained Earnings 193,000 Total Equity 293,000 Total Liabilities and Equity 440,000