i need the formulas for the cash budget steps 2-6

Step 36 of 40: Cash Budget Formulas A 1 2 Cash Balance, Beginning 3 ollections 1 5 YOUR TURN: Fill in January December and the word Recap 7 along with your Spreadsheet ID in cell N1 on the Cash 9 Budget worksheet. 10 January 2. Cash Balance, Beginning $20.000.00 Collections 3 l.Cash Available YOUR TURN: Enter 2 formulas for cells B3:M3. 8 9 10 OUR 6 5 YOUR TURN: Create formulas that carry over the operating expense names in column A and use VLOOKUP to return the 6 amounts in cells B9:M11 7 Terrory POCUSES PUSO 8 Commissions 120,00 9 10 11 6 8 Cash Budget Cash Budget A B Janman 2 Cash Balance, Beginning 3 Collections 2 5 YOUR TURN: Enter a formula 6 here that references the 7 Minimum Cash Balance from 8 the Inputs worksheet. 9 10 UwN co IWN A B 4 YOUR TURN: Create formulas that carry over the inventory payments and commissions in cells B7 MB 6 Less Disbursements Inventory Purchases 8 Commissions Supporting Schedulet ... A el 13 Total Disbursements 10 Sxcess deficiency) of receippverdisburs 6 16 YOUR TURN: Add a formulas 17 for subtotals and ending 18 balances for columns B:M, as well as beginning balances for 20 columns C:M. 21 22 Cash Balance, Ending Cash Sudget 10 Cash Budget Cash Budget D Budget Assumptions First Month's Sales in Units 3 Unit Sales Growth Per Month 4 Unit Sales Price 10,000 250 12.00 LEFT/HIND Functions First Month's Sales in Units Assumption Unit Sales Growth Pet Month Assumption Unit Sales Price Assumption $ 7 Grous Martin a Commission Ending Inventory SON 10 BON THIMunction Gross Margo Commission Ending Inventory 5 20,000.00 12N SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption 11 12 Minimum Cash Balance 13 Interest Rate 14 15 Month 16 Month 17 Month 10 Months 19 Co Operating Expenses 1 Payroll 2. Utilities 3 Other + Collections 25 SOS 25 Payments 60% LON 0 CONCATENATE/RIGHT Function Period: Period 2 Period UPPER Function LOWER.Function PERIOD 1 period PERIOD 2 period 2 PERIOD 3 perioda - Per Month S 16,000 S 7,000.0 S 19,500.0 MID Function 7200 Payroll 7500. Utilities 7900 - Other Wow ry Mer Ile 1. . Y. HO NE VE 1. SO I. OS 1000 DOLCE VE TOO 100 TO 11.10 200 7,10 12.15001000 Gros A . 10250 Merchant Own D 111 10.00 000 11.50 ! 12 BOG 0.0000 1200 12000 000 6,00 11, 000 LE 13. 15 IND 141.00 11 SHOW 150.000 100 JO at AME A Sow 21 NE Ver 90 SSC i May NE SON NE SON SE SON ON WE 25 50 2 21 October NO W 50 2 Den MY 5 At September Och December Forum Maret BLOODOO 0.000.00 0.750.00 1,500.00 310.00 0.750.00 1,000.00 CO DO 13.750.00 stions ry February March Anti MY 11 Luty 33 Agust weber 4500.00 23,000.00 1000 00 DOTE 11.350.00 67 500.00 DE OOSTE IL1000 000.00 2.250.00 340.00 750.00 1.000.000000 72.500.00 Cash Budget 2.750.00 neration Burnet VA AVE Die he US IN AN M My w we NO De M 4 wy 800000 SO TOTTE DEYE 14.500.00 March 00 Mwy 1000 31 ALS ONE . GO October 2,780.00 500.00 560.00 Det DOBOS W 000 00:00 DOTCOM 00 DO 67,100.00 10000 DOCE DE D Meth April May hly AH 110,000 TE income Sales Total income Cost of Goods Sold Puri 300 GOOSE 11.00 141.00 000'rt 1000 111.000 DOO 120.000 1000 112 0001 14 10 100 14.00 140.000 110.000 900'EST 16 Insol BOTA 112 . 1. X 12. 0.001 OC 12.00 22.01 100 INICI 11.2001 165.400 112.00 21, 1.700 (310 1010 1744 116.00 114400 CON 100 IN 100 53.100 300 ot 100 18.00 101 59,00 06 15.100 31000 61 200 008 6700 700 1927900 0011 100 55,500 DOW 00311 116.000 Total Cost of Good 1 Gross Profit Operating Expenses Play Us O I Total Operating pances 15 Net Income 19 100) 000 7.100 100 1060 COM 001 lo con 2001 13 fool TO 142.500 4100 000 T500 103.100 100 114.000 00 (1950) 185001 7,000 os (16. 12.000 . 142 500 10.600 10.500 143 500 1.200 11 101 142.00 460 . 195,500 22 SCO 11.30 2,5001 13,000 115 142.100 34200 15.50 42,500 15,00 142,5001 16.6 LOGO (9.500 1.700 135.300 === 11 ora 110 . ATE www. w Sportingscode Order oferint Operating for Cash Budget TOTAM O e Type here to search Step 36 of 40: Cash Budget Formulas A 1 2 Cash Balance, Beginning 3 ollections 1 5 YOUR TURN: Fill in January December and the word Recap 7 along with your Spreadsheet ID in cell N1 on the Cash 9 Budget worksheet. 10 January 2. Cash Balance, Beginning $20.000.00 Collections 3 l.Cash Available YOUR TURN: Enter 2 formulas for cells B3:M3. 8 9 10 OUR 6 5 YOUR TURN: Create formulas that carry over the operating expense names in column A and use VLOOKUP to return the 6 amounts in cells B9:M11 7 Terrory POCUSES PUSO 8 Commissions 120,00 9 10 11 6 8 Cash Budget Cash Budget A B Janman 2 Cash Balance, Beginning 3 Collections 2 5 YOUR TURN: Enter a formula 6 here that references the 7 Minimum Cash Balance from 8 the Inputs worksheet. 9 10 UwN co IWN A B 4 YOUR TURN: Create formulas that carry over the inventory payments and commissions in cells B7 MB 6 Less Disbursements Inventory Purchases 8 Commissions Supporting Schedulet ... A el 13 Total Disbursements 10 Sxcess deficiency) of receippverdisburs 6 16 YOUR TURN: Add a formulas 17 for subtotals and ending 18 balances for columns B:M, as well as beginning balances for 20 columns C:M. 21 22 Cash Balance, Ending Cash Sudget 10 Cash Budget Cash Budget D Budget Assumptions First Month's Sales in Units 3 Unit Sales Growth Per Month 4 Unit Sales Price 10,000 250 12.00 LEFT/HIND Functions First Month's Sales in Units Assumption Unit Sales Growth Pet Month Assumption Unit Sales Price Assumption $ 7 Grous Martin a Commission Ending Inventory SON 10 BON THIMunction Gross Margo Commission Ending Inventory 5 20,000.00 12N SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption 11 12 Minimum Cash Balance 13 Interest Rate 14 15 Month 16 Month 17 Month 10 Months 19 Co Operating Expenses 1 Payroll 2. Utilities 3 Other + Collections 25 SOS 25 Payments 60% LON 0 CONCATENATE/RIGHT Function Period: Period 2 Period UPPER Function LOWER.Function PERIOD 1 period PERIOD 2 period 2 PERIOD 3 perioda - Per Month S 16,000 S 7,000.0 S 19,500.0 MID Function 7200 Payroll 7500. Utilities 7900 - Other Wow ry Mer Ile 1. . Y. HO NE VE 1. SO I. OS 1000 DOLCE VE TOO 100 TO 11.10 200 7,10 12.15001000 Gros A . 10250 Merchant Own D 111 10.00 000 11.50 ! 12 BOG 0.0000 1200 12000 000 6,00 11, 000 LE 13. 15 IND 141.00 11 SHOW 150.000 100 JO at AME A Sow 21 NE Ver 90 SSC i May NE SON NE SON SE SON ON WE 25 50 2 21 October NO W 50 2 Den MY 5 At September Och December Forum Maret BLOODOO 0.000.00 0.750.00 1,500.00 310.00 0.750.00 1,000.00 CO DO 13.750.00 stions ry February March Anti MY 11 Luty 33 Agust weber 4500.00 23,000.00 1000 00 DOTE 11.350.00 67 500.00 DE OOSTE IL1000 000.00 2.250.00 340.00 750.00 1.000.000000 72.500.00 Cash Budget 2.750.00 neration Burnet VA AVE Die he US IN AN M My w we NO De M 4 wy 800000 SO TOTTE DEYE 14.500.00 March 00 Mwy 1000 31 ALS ONE . GO October 2,780.00 500.00 560.00 Det DOBOS W 000 00:00 DOTCOM 00 DO 67,100.00 10000 DOCE DE D Meth April May hly AH 110,000 TE income Sales Total income Cost of Goods Sold Puri 300 GOOSE 11.00 141.00 000'rt 1000 111.000 DOO 120.000 1000 112 0001 14 10 100 14.00 140.000 110.000 900'EST 16 Insol BOTA 112 . 1. X 12. 0.001 OC 12.00 22.01 100 INICI 11.2001 165.400 112.00 21, 1.700 (310 1010 1744 116.00 114400 CON 100 IN 100 53.100 300 ot 100 18.00 101 59,00 06 15.100 31000 61 200 008 6700 700 1927900 0011 100 55,500 DOW 00311 116.000 Total Cost of Good 1 Gross Profit Operating Expenses Play Us O I Total Operating pances 15 Net Income 19 100) 000 7.100 100 1060 COM 001 lo con 2001 13 fool TO 142.500 4100 000 T500 103.100 100 114.000 00 (1950) 185001 7,000 os (16. 12.000 . 142 500 10.600 10.500 143 500 1.200 11 101 142.00 460 . 195,500 22 SCO 11.30 2,5001 13,000 115 142.100 34200 15.50 42,500 15,00 142,5001 16.6 LOGO (9.500 1.700 135.300 === 11 ora 110 . ATE www. w Sportingscode Order oferint Operating for Cash Budget TOTAM O e Type here to search