please completed in excel

1.

2.

please completed in excel

a) Budget an income statement for the months of January, February and March 2018, with the following information i) Actual sales for the month of October November and December 2017 Sales forecast for the month of January February and March 2018 Cash sales are 30% and the balance are credit sales. For credit sales 60% of it will be collected in the next month and 20% of it will be collected two months after the sale, and the remaining 20% will be collected three months after the sale. Month October November December January February March Sales (RM) 80,000.00 90,000.00 110,000.00 120,000.00 130,000.00 150,000.00 iv) The purchase of raw material is predicted at 50% of sales and the payments will be made two months later Rentals are RM5 500 per month Salaries are RM6 000 per month vii) The company will pay the building insurance premiums of RM3 800 will be paid in the month of February viii) The purchase of machinery involving a cost of RM60 000 will be made in the month of January ix) Opening cash balance for the month of January was RM20 000 x) The cash balance that the company intends to hold every month is RM15 000. The following balances are taken from the books of George Anderson at the end of his first year trading on 31 December 2014 Debit Credit $ Sales 40000 18500 5100 1300 Purchases Wages and salaries Repairs and maintenance Heating and lighting General expenses Insurance 900 1200 800 Cash at bank 2200 1300 4100 3400 Cash in hand Trade receivables Trade payables Premises Fixtures and fittings Motor vehicle Capital at 1 January 2014 Drawings 30000 10000 8000 52000 12000 95400 95400 The following additional information is available: Inventory at 31 December 2014 was valued at $4500 Required: (a) Prepare income statement for the year ended 31 December 2014. (b) Prepare a balance sheet as at 31 December 2014