Version A Cash Budget With the following information, prepare a cash budget for the months of January to April 2021 Forecast of sales for the periods Nov-20 $75,000 Dec-20 590,000 Jan-21 $90,000 Feb-21 $105,000 Mar-21 $130,000 Apr-21 $150,000 The credit manager provides the following information about sales revenue recovery 50% comes in as cash sales today, 30% one month lag, 20% in two months lag Cost of sales (COGS) is assumed to be 50% of revenues. - Spreadsheet set-up to calculate Payment of Outstanding COGS Invoices is as follows 50% paid today and 50% in one month ag Monthly expenses are as follows Salaries $25.000 Leasing Expenses $5,000 Promo & Advertising $3,000 Taxes are paid in each of February and Aoni are $15.000 por payment In February company plans to purchase sets of 545 000. In Apnt another asset purchase of $15.000 The beginning cash balance in the bank on January 16, 2023 517.300 Agent Prepare the Cash Budget a requested Excel