Problem 24-04 Given the following information, complete the cash budget Collections occur one month after the sale b. January credit sales were $90,000 The form has a certificate of deposit for $50,000 that matures in April Salanes are $145.000 a month e. The monthly mortgage payment is $15,000 Monthly depreciation is $10,000 Property tax of $30,000 is due in February Round your answers to the newest dollar. Enter the disbursements values as positive values. Use a mis sign to enter shortage of cash negative beginning and ending cash values any. Do not leave any cells blank. If the answer is zero, enter" February 120.000 25.000 March 240,000 20,000 April 310,000 50.000 $ 5 5 $ 5 5 Sales Cash sales Collection Other receipts Tot cash recipes Salaries Morte Other disbursements Total cash disbursements Net change during the month Beginning Ending cash Required level of com Ex cash or (shortage) 5 $ $ $ 5 5 $ 5 30.000 5 5 5 5 5 12,000 $ 12,000 12.000 5 $