Sadiq Corporation has made a sale of Rs 1.2 Million in December 2015. It is expected that the sales growth rate would be (assume a rate between 12%-15%) each month of the previous months sale. The revenue collection follows a set pattern and the debtors of the company pay 55% of the sale made to them by the company in cash form. 30% are received after one month. And the remaining 15% are received after two month.

The expenses incurred for making sales include the followings. Raw material cost Rs. 0.45 Million, Labor cost Rs. 0.2 Million Miscellaneous cost Rs. 0.15 Million and Advertising & Promotion Rs. 0.2 Million. These are for December 2015. The raw material cost is expected to increase at (assume a rate between 9%-12%) per month of the previous months value. The labor cost will be at an incline by (assume a rate between 6%-9%) while the miscellaneous cost would be rising by (assume a rate between 12%-15%) per month. A&P will remain constant each month.

Requirement:

Calculate the revenues and expenses incurred in each month from December 2015 to June 2016 and also find the value of net cash in hand at the end of each year.