the change in the firm's need for funds? parts a and b. What is the revised cash budget's "bottom line"? the desired minimum level of cash and sales change as in 4. Given the following information, complete the cash budget: a. Collections occur one month after the sale. b. January's credit sales were $80,000. c. The firm has a certificate of deposit for $40,000 that matures in April. d. Salaries are $145,000 a month. e. The monthly mortgage payment is $25,000. f. Monthly depreciation is $20,000. g. Property tax of $35,000 is due in February. Sales Cash sales Collections Other receipts Total cash receipts Salaries Other disbursements Total cash disbursements Net change during the month Beginning cash Ending cash Required level of cash Excess cash or (shortage) February $150,000 30,000 30,000 - 10,000 March $200,000 20,000 10,000 April $250,000 60,000 10,000