Question Tag: Capital Grant

The Atlantic Staff Housing Corporation is preparing its budget for 2015. You have been engaged as a Consultant to the Corporation to assist in the preparation of the budget. The following information has been made available:

1. The total annual subventions from the Federal Government in 2014 was N36,000,000. There is an expectation that this amount will increase by 10% in the year 2015. The expected 10% increase will be received in the first six months of the year along with the normal monthly allocations.
2. The management has decided to reduce transport and travelling by 5% in the year 2015. The total amount in 2014 was N3,780,000, and the expense will accrue evenly throughout the year.
3. Capital grant of N14 million is expected in February, May, and November.
4. Salaries and wages for 2014 were N28 million. In 2015, salaries and wages will increase by 12.5% of the amount paid in 2014. Housing allowance is 33% of salaries and wages.
5. Ground rent for industrial estates will be received as follows: January N2.8 million, February N1.5 million, and March N2.08 million.
6. The training and development expenses of N700,000 are to increase by 10% in the year 2015. The total amount will be spent on an equal basis in February and October 2015.
7. The Corporation will commence construction of 100 low-cost housing units in the year 2015. The following are the commitments through LPOs in 2014, which will be met in the New Year:
   

   Date Purchased	Particulars	LPOs	Time to Pay	Amount (N’Million)
   15/08/2014	Cement	121	February	9.5
   15/09/2014	Iron-rod	111	March	2.8
   31/10/2014	Gravels	120	30/01/2015	1.5
   01/11/2014	Plumbing Materials	122	20/02/2015	0.75
   05/12/2014	Sands	119	March	1.2513

8. Rent receivable from the shopping complex of the Corporation will be: January N1.7 million, February N1.5 million, and March N2.5 million.
9. The cash balance as of December 31, 2014, was N1.5 million.

Required:

a. Prepare a cash flow projection for the first quarter of the year 2015.
(15 Marks)

b. Calculate the ratio of recurrent expenditure to total inflow for each month and make a brief comment on the ratio.
(5 Marks)
(Total 20 Marks)