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 $35,000. f. Monthly depreciation is $10,000. g. Property tax of $25,000 is due in February. Round your answers to the nearest dollar. Enter the disbursements values as positive values. Use a minus sign to enter shortage of cash, negative beginning and ending cash values, if any. Do not leave any cells blank. If the answer is zero, enter "0". Sales Cash sales Collections Other receipts Total cash receipts Salaries Mortgage Other disbursements Total cash disbursements Net change during the month February March April 170,000 $ 220,000 $ 35,000 20,000 $ 270,000 70,000 $ $ $ Beginning cash 40,000 $ Ending cash $ $ Required level of cash 6,000 $ 6,000 $ 6,000 Excess cash or (shortage) $