Cash Budget B C D E F G H With the following information, prepare a cash budget for the months of March to June 2021. Sales (and forecasts) for the periods: Jan-21 $80,000 Feb-21 $100,000 Mar-21 $100,000 Apr-21 $110,000 $120,000 K May-21 Jun-21 $130,000 The credit manager provides the following information about sales revenue recovery: 60% comes in on a cash basis, 15% in the first 30 days, 25% in 31-60 days Cost of sales (COGS) is assumed to be 50% of revenues. Payment of outstanding bills is paid as follows: 40% in the first 30 days, and 60% in 31-60 days. Monthly expenses are as follows: Salaries $30,000 $2,500 Promo & Advertising $ 3,000 Leasing Expenses Taxes are paid in each of April, June, and August, at $15,000 per payment. In April, the company plans to purchase assets of $45,000 (cash basis). In June another investment $15,000 (cash). The cash balance in the bank on March 1st, 2021 is $17,100 2 Prepare the Cash Budget as requested (next sheet)