This assignment will require you to prepare the cash budget and determine the cash surplus and shortage each month. The management estimates total sales for the period January through June based on actual sales from the immediate past six months. The following assumptions are made:

1. The Sales were $150,000 in January 2018 and then the sales grew by 10% each month for the first five months (February to June). The sales are expected to grow by 5% each month thereafter.

2. 50% of the Sales are collected in the same month. 45% of the sales are collected in the following month and remainder are not collected.

3. The Purchases are 20% of sales and paid in the same month.

4. Wages and Salaries are $10,000 each month and paid in the same month.

5. Depreciation expense is $5,000 each month.

6. An equipment worth $100,000 will be purchased with cash in October.

7. The company's debt is $50,000 and the company pays coupon payments in June and December of each year. The coupon rate is 10% per year.

8. Rent Expenses will be $5000 and will be paid at the end of each calendar quarter.

Determine the cash surplus and shortages for each month from July to December. Provide your analysis.