just need help filling this out please

NAME: SECTION: FALL 2021 Chapter 16 Cash Budget Concept Input Data Collections during month of sale Collections during month after sale Collections foring werend math after sale Lease payments Target cash balance General and administrative salaries Depreciation charges Income tax payments (March and Jury Miscellaneous expenses Equipment Purchme (April) Cashchand JANUARY IN N% 81% 11% $24.600 $16.00 S4 900 S2000 596.900 $17.625 5229.500 59.00 NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE Prepare a meally each budget for the first math of the 2023 November 550.00 Original sales estimates Original aber and raw matatimates December SI5.000 SINS, 5475.000 $333,000 February 50 5393,100 March 5655 500 5.800.000 April SS8000 SINKO May $40,000 S186,000 June 10.000 SO SI11.000 Far Sale Sales (gros) Collections During month of sale During Is mint after sale During Ind month after sale Total collections Paren Labor and raw materials Payments for labor and raw material Payment wyments for labor and raw materials General and admitive salaris Lase payments Miscellaneous expen Tecome tax paymes Equipment Purchase Total payments Net Cash Flow Cash a hand at start of meath Net ash flow NCHI Total collection - Total payments Cumutathe NCF: Priormente cumulative this month's NCE Carl Swer Len Newmenty Target cash balance Surplus cash or loan needed: Com NCF-Target cash Highest Loan Needed Most Available for Investment Nov Doc Jan Feb Mar Apr $71,218.01_$68,212:00 $65 213,00 $52,475.00 $42.999.00 $30,524.00 12,7875 10,285.10 1,748.40 45,649.10 7,121.80 5,821.20 $67,651.98 $62,755.40 mars April 85 Febx 85 $44,603,75 $36.472.65 $25.945.40 wait to Cash Budget (Thousands of Dollars) Sales Forecast 11) Sales (gross! Collections 21 During month of sale: 10.240.90 month's sales) 3) During first month after sale: 10.7/previous month's sales 14 Dating second month after skler (0.11 dites 2 months agol Topal collections Linos 2 + 3 + 4) Purchases 161 10.85) forecasted sales 2 months from now) Payments Payments (1-month lag) (8) Wages and salaries 19) Rent (10) Taxes (1 Total payments NCFS (12) Cash on hand at start of forecast 113) NCF: Coll. - Pmts. = Line 5 - Line 11 (14) Cum NCH: Prior + this mos. NCF Cash Surplus (or Loan Requirement) (15) Target cash balance 116) Surplus cash or loan needed positive negative 44,603.75 6,690.56 2,500.00 36.472.65 5,470.90 2,500.00 pay one month later! $53,794.31 $44,443.55 given $ 3,000.00 16,957,67 $13,857 64 $16,857.64 $18,311.85 S 35169.49 do this last! 1,500.00 $15,357.64 1,500.00 $33,669.49 p. 687 NAME: SECTION: FALL 2021 Chapter 16 Cash Budget Concept Input Data Collections during month of sale Collections during month after sale Collections foring werend math after sale Lease payments Target cash balance General and administrative salaries Depreciation charges Income tax payments (March and Jury Miscellaneous expenses Equipment Purchme (April) Cashchand JANUARY IN N% 81% 11% $24.600 $16.00 S4 900 S2000 596.900 $17.625 5229.500 59.00 NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE Prepare a meally each budget for the first math of the 2023 November 550.00 Original sales estimates Original aber and raw matatimates December SI5.000 SINS, 5475.000 $333,000 February 50 5393,100 March 5655 500 5.800.000 April SS8000 SINKO May $40,000 S186,000 June 10.000 SO SI11.000 Far Sale Sales (gros) Collections During month of sale During Is mint after sale During Ind month after sale Total collections Paren Labor and raw materials Payments for labor and raw material Payment wyments for labor and raw materials General and admitive salaris Lase payments Miscellaneous expen Tecome tax paymes Equipment Purchase Total payments Net Cash Flow Cash a hand at start of meath Net ash flow NCHI Total collection - Total payments Cumutathe NCF: Priormente cumulative this month's NCE Carl Swer Len Newmenty Target cash balance Surplus cash or loan needed: Com NCF-Target cash Highest Loan Needed Most Available for Investment Nov Doc Jan Feb Mar Apr $71,218.01_$68,212:00 $65 213,00 $52,475.00 $42.999.00 $30,524.00 12,7875 10,285.10 1,748.40 45,649.10 7,121.80 5,821.20 $67,651.98 $62,755.40 mars April 85 Febx 85 $44,603,75 $36.472.65 $25.945.40 wait to Cash Budget (Thousands of Dollars) Sales Forecast 11) Sales (gross! Collections 21 During month of sale: 10.240.90 month's sales) 3) During first month after sale: 10.7/previous month's sales 14 Dating second month after skler (0.11 dites 2 months agol Topal collections Linos 2 + 3 + 4) Purchases 161 10.85) forecasted sales 2 months from now) Payments Payments (1-month lag) (8) Wages and salaries 19) Rent (10) Taxes (1 Total payments NCFS (12) Cash on hand at start of forecast 113) NCF: Coll. - Pmts. = Line 5 - Line 11 (14) Cum NCH: Prior + this mos. NCF Cash Surplus (or Loan Requirement) (15) Target cash balance 116) Surplus cash or loan needed positive negative 44,603.75 6,690.56 2,500.00 36.472.65 5,470.90 2,500.00 pay one month later! $53,794.31 $44,443.55 given $ 3,000.00 16,957,67 $13,857 64 $16,857.64 $18,311.85 S 35169.49 do this last! 1,500.00 $15,357.64 1,500.00 $33,669.49 p. 687