Given the following information, complete the cash budget:

Collections occur one month after the sale.

January$$s credit sales were $$80,000.$

The firm has a certificate of deposit for $$40,000$ that matures in April.

Salaries are $$155,000$ a month.

The monthly mortgage payment is $$20,000.$

Monthly depreciation is $$10,000.$

Property tax of $$30,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".$

February March April

Sales $ $150,000$ $ $210,000$ $ $270,000$

Cash sales $ $35,000$ $ $20,000$ $ $70,000$

Collections $

$

$

Other receipts $

$

$

Total cash receipts $

$

$

Salaries $

$

$

Mortgage $

$

$

Other disbursements $

$

$

Total cash disbursements $

$

$

Net change during the month $

$

$

Beginning cash $ $30,000$ $

$

Ending cash $

$

$

Required level of cash $ $13,000$ $ $13,000$ $ $13,000$

Excess cash or $($shortage$)$ $

$

$