2. Given the information below.create a cah bodget Worksheet 21: Cash Budgets Sales January February 1. Given the information below, complete the cash budget O Caal badet February March Sales $150 000 $200 000 10,000 3.000 5.000 10,000 5.000 3.000 April May June April $250.000 530.000 520,000 580.000 Cash Collections Other reset Totalcash Salaris Other debuerats Toallashdistuneet Net change dumt the south 60% of sales me on credit and are collected after one month Wages are 60% of sales Monthly fixed costs are $1.000 In March, the firm receives $2.000 from a bood that matures Taxes of $2,000 me due in April and in June The firm desires a cash balance of $1,500 at all times Beginning cash is $1,500 I Collections occur ce month after the sale January's credit sales were $80,000 The firm as a certificate of deposit for $40,000 that matures in April d Salaries are $145,000 per month . The monthly mortgage payment is 325,000 f Monthly depreciation is $20,000 Property tax of $35,000 is due in February