HOMEWORK CASH BUDGET. BASE CASE Cash Receipts Morth of sale (25%) First month (75%) Total collections Cash Disbursements Purchases (505) Operating Expenses Corporate Overhead Bond Interest Payment Equipment Purchase Real Estate Taxes Total Disbursements Net Monthly Change Beginning Cash Balance Borrowings (Repayments) Ending Cash Balance 750.000 Cumulative Borrowing Cash Budget Assignment Using the template contained in the Module for this week, prepare a cash budget for 2018 based on the following information: NOTE: Refer to the example that supplements the Power Point example as a guide. Cash Receipts 25% of sales are in cash and collected in the month the sale is made and 75% are on credit and collected in the month . after the sale. December 2017 sales were $3 million. The sales forecast for 2018 is as follows: January 2,800,000 February 2,500,000 March 3,200,000 April 3,400,000 May 3,600,000 June 3,600,000 July 3,800,000 August 4,000,000 September 3,600,000 October 3,400,000 November December 2,800,000 2,600,000 UUUUU 2,00UUUU Cash Disbursements The disbursements for this firm are as follows: Payments for raw materials are calculated based on 50% of current month sales. Operating expenses are $700,000 per month. Corporate overheadys $100,000 per month. $1.5 million semi-annual bond interest payments are due in May and November. $1.8 million in new equipment will arrive in May and must be paid for in July. $1.2 million in new equipment will arrive in September and must be paid for in October A $1.4 million insurance premium is due in February $900,000 quarterly real estate tax payments are due in February, May, August, and November Cash/Credit Line Information The company must have a minimum cash balance of $200,000 at month-end and the cash balance at the end of December 2017 is $750,000. The company maintains a $1 million credit line for short-term liquidity purposes, none of which is outstanding at the end of December 2017 DO NOT include interest expense on the credit line in your calculations