With the following information, prepare a cash budget for the months of January to April 2021 The credit maneger provides the following infernation about sales revenue recovery: 60% comes in as cash sales today, 20% one month leg. 20% in two months ligg Cost of sales (COGS) is assumed to be 50% of reventes. - Spreadsheet set-up to calculate Payment of Outstanding coGs invoices is as tollows 70% paid todiay and 30% in one menth leg Tares are paid in each of February and April are $10,000 per payment. In Yebruary compary pians to purchase assets of $45,000 in Apel another asset purchase of $15,000 The begining cash balance in the bark on January tat, 2021 is 517,300 ( Assignment) Prepare the Cach Budgot as requested (use Excel)