Need help to make sure the cash budget is corrected based off the information/ dats given .

- NEED HELP FILLING IN

250 Unit Sales Growth Per Month Assumption Unit Sales Price Assumption $ 12.00 3 Unit Sales Growth Per Month 4 Unit Sales Price 5 6 7 Gross Margin 8 Commission 9 Ending Inventory 10 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory $ 20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption Sla Collections 25% SOX 25% Payments 60% 40% OX CONCATENATE/RIGHT Function Period 1 Period 2 Perlod 3 U PE PE PE 12 Minimum Cash Balance 13 Interest Rate 14 15 Month 16 Monthi 27 Month2 18 Month 19 20 Operating Expenses 21 Payroll 22 Utilities 23 Other 24 Expense 6867 25 Per Month $ 16,000 $ 17,000 s 19,500 $ 3,434 MID Function 7200 Payroll 7500 -Utilities 7900 Other MS . 10,000 2000 10.000 1. T. 20. 141.00 1 HIP 10.000 IO 75 Com . or BE 1 . . . . 17.00 . . D. HO . ICH 33 2.44 DAHA IO cor 0 BH 1.43 CHE RE PER EHTE HE 2221 TI tano LET I DO 14 DE WHIT EN UT 0,00 Ruta OT 120 SE DOO 8 SE 1 Budget Assumptions 2 First Month's Sales in Units 3 Unit Sales Growth Per Month 4 Unit Sales Price 5 10,000 250 12.00 LEFT/FIND Functions First Month's Sales in Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption $ 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory 7 Gross Marcin 8 Commission 9 Ending Inventory 20 11 12 Minimum Cash Balance 13 Interest Rate $ 20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption Collections 25% 50% 25% Payments 60% 40% 0% CONCATENATE/RIGHT Function Period 1 Period 2 Perlod 3 15 Month 16 Month 17 Month 18 Month 29 20 Operating Expenses 21 Payroll 22 Utilities 23 Other 24 Expense 6867 25 Per Month $ 16,000 $ 7,000 S 19,500 3,434 MID Function 7200 Payroll 7500 Utilities 7900. Other us 250 Unit Sales Growth Per Month Assumption Unit Sales Price Assumption $ 12.00 3 Unit Sales Growth Per Month 4 Unit Sales Price 5 6 7 Gross Margin 8 Commission 9 Ending Inventory 10 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory $ 20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption Sla Collections 25% SOX 25% Payments 60% 40% OX CONCATENATE/RIGHT Function Period 1 Period 2 Perlod 3 U PE PE PE 12 Minimum Cash Balance 13 Interest Rate 14 15 Month 16 Monthi 27 Month2 18 Month 19 20 Operating Expenses 21 Payroll 22 Utilities 23 Other 24 Expense 6867 25 Per Month $ 16,000 $ 17,000 s 19,500 $ 3,434 MID Function 7200 Payroll 7500 -Utilities 7900 Other MS . 10,000 2000 10.000 1. T. 20. 141.00 1 HIP 10.000 IO 75 Com . or BE 1 . . . . 17.00 . . D. HO . ICH 33 2.44 DAHA IO cor 0 BH 1.43 CHE RE PER EHTE HE 2221 TI tano LET I DO 14 DE WHIT EN UT 0,00 Ruta OT 120 SE DOO 8 SE 1 Budget Assumptions 2 First Month's Sales in Units 3 Unit Sales Growth Per Month 4 Unit Sales Price 5 10,000 250 12.00 LEFT/FIND Functions First Month's Sales in Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption $ 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory 7 Gross Marcin 8 Commission 9 Ending Inventory 20 11 12 Minimum Cash Balance 13 Interest Rate $ 20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption Collections 25% 50% 25% Payments 60% 40% 0% CONCATENATE/RIGHT Function Period 1 Period 2 Perlod 3 15 Month 16 Month 17 Month 18 Month 29 20 Operating Expenses 21 Payroll 22 Utilities 23 Other 24 Expense 6867 25 Per Month $ 16,000 $ 7,000 S 19,500 3,434 MID Function 7200 Payroll 7500 Utilities 7900. Other us