Cash budget

As you know, the two capital projects being proposed are an effort to sustain long-term growth. However, its important to present an accurate projection of our short-term cash requirements to ensure we have a capacity to grow.

I would like you to develop a cash budget for the months of July 2017 December 2017. Be sure it is divided in to three sections: (1) Total Cash Receipts; (2) Total Cash Disbursements, (3) Cash or Financing covering the period of July through December. Do we have excess cash each month? Or, do we need financing each month to sustain our day-to-day operations?

The following is a summary of the cash inflows and outflows our team put together last month:

Expected gross sales for April 2017 December 2017 are: $300,000, $300,000, $290,000, $425,000, $500,000, $600,000, $625,000, $650,000, and $700,000

5% of the sales are collected in cash each month

15% of sales are collected during the following month; 50% in the second month; 30% in the third month

Expected purchases of raw materials are 70% of the expected sales each month

The firm pays 100% of its raw materials purchases in the following month

Wages and salaries are paid monthly and are 10% of the current months sales

Monthly lease payments are 6% of the current months sales

Monthly advertising expense amounts to 8% of current months sales

R&D expenditures are expected to be allocated in August, September, and October at the rate of 12% of sales in those months

During December, a prepayment of insurance will be made in the amount of $24,000

During the months of July through December, the firm expects to have miscellaneous expenditures of $15,000, $20,000, $25,000, $30,000, $35,000, and $40,000

Taxes will be paid in September in the amount of $40,000 and in December in the amount of $45,000

The beginning cash balance in July is $15,000

The target cash balance is $15,000