L16 A B D E F G H 1 Prepare a Cash Budget based for the 6 Months January 2022 to June 2020 on the following data. 2 3 Salaries & 4 Sales: Purchases Benefits Other Capital Insurance Taxes 5 Oct-21 $1,000,000 $300,000 $375,000 $170,000 $225,000 $35,000 $150,000 6 Nov-21 $975,000 $292,500 $365,625 $165,750 Dec-21 $1,100,000 $330,000 $412,500 $187,000 3 Jan-22 $1,250,000 $375,000 $468,750 $212,500 $250,000 $35,000 $150,000 Feb-22 $1,300,000 $390,000 $487,500 $221,000 0 Mar-22 $1,000,000 $300,000 $375,000 $170,000 Apr-22 $975,000 $292,500 $365,625 $165,750 $250,000 $35,000 $150,000 May-22 $985,000 $295,500 $369,375 $167,450 Jun-22 $965,000 $289,500 $361,875 $164,050 $250,000 Jul-22 $975,000 $292,500 $365,625 $165,750 $35,000 $150,000 Aug-22 $950,000 $285,000 $356,250 $161,500 Sep-22 $945,000 $283,500 $330,750 $160,650 $12,420,000 Cash Collection 20% month of sale 55% 1st month after sale 25% 2nd month after sale Cash Payments Purchases: Month after sale Salaries Benefits: Month of Sale Other: 2 months after sale Capital: Month after sale Insurance: Month of Sale Taxes: Month of Sale Beginning Cash Balance: $75,000