please show the work

Input Data Collections during month of sale Collections during month after sale Collections during second month after sale Lease payments Target cash balance General and administrative salaries Depreciation charges Income tax payments (September & December) Miscellaneous expenses New Building Payment(October) Cash on hand JULY 1st NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE Prepare a monthly cash budget for the last six months of the 2022 Original sales estimates May $175,000 $88,000 Original labor and raw mat. estimates Forecasted Sales Sales (gross) Collections During month of sale During 1st month after sale During 2nd month after sale Total collections Purchases Labor and raw materials Payments for labor and raw materials Payments Payments for labor and raw materials General and administrative salaries Lease payments 8% 79% 13% $5,000 $84,000 $36,500 $42,000 $57,500 $4,500 $236,000 $145,000 June July August September October November December $210,000 $380,000 $530,500 $698,000 $406,000 $345,000 $102,000 $92,000 $136,000 $798,000 $299,000 $245,000 $159,000 $91,000 Miscellaneous expenses Income tax payments New Building Payment Total payments Net Cash Flows Cash on hand at start of month Net cash flow (NCF): Total collections - Total payments Cumulative NCF: Prior month cumulative + this month's NCF Cash Surplus (or Loan Requirement) Target cash balance Surplus cash or loan needed: Cum NCF - Target cash Highest Loan Needed Most Available for Investment