I dont know how to do the Excess of recipts part or down. I need the formulas!

Step 36 of 40: Cash Budget Formulas 5 Cash Balance, Beginning (1 YOUR TURN: Create formulas that carry over the operating expense names in column A and use VLOOKUP to return the amounts in cells B9:M11. January 2 Cash Balance, Beginning 20,000.00 3 Collections (3 tal.Cash Available YOUR TURN: Create a formula that carries over the collections in cells B3:M3. 7 Inventory Purchases Commissions YOUR TURN: Fill in January December and the word Recap along with your Spreadsheet ID in cell N1 on the Cash Budget worksheet. 10 Utilities 11 Other Operating Budget Cash Budget 36540 - 12000 10 Utilities 11 Other Operating Budget Cash Budget Operating Budget Cash Budget Jan Februar Lanuary 2 Cash Balance, Beginning Collections YOUR TURN: Create formulas that carry over the inventory payments and commissions in cells B7:M8. YOUR TURN: Enter a formula here that references the Minimum Cash Balance from the Inputs worksheet. 6 Less Disbursements 7 Inventory Purchases 8 Commissions 9 Payroll 10 Utilities 11 Other Operating Budget 2 (Cash Balace, Beginning $ 20,000.00 3 Collections 30000 Total Cash Available 6 less Disbursements YOUR TURN: Add a formulas for subtotals and ending balances for columns B:M, as well as beginning balances for columns C:M. Operating Budget Cash Budget Cash Budget dget wed 523 PM Edit View insert Format Tools Data Window Help Autodiaren s Home Insert Draw Page Layout Formulas Data Review P X Cabr (Body! 11 A A cash flow budget 3 Malte View Comments Share . O 2 . Custom $ % a 11 R13 x f x -SUM[87:812) 11100019.000 2.0 12. 0 1 3 .00 14 dienorts ever disbursements FR Step 36 of 40: Cash Budget Formulas 5 Cash Balance, Beginning (1 YOUR TURN: Create formulas that carry over the operating expense names in column A and use VLOOKUP to return the amounts in cells B9:M11. January 2 Cash Balance, Beginning 20,000.00 3 Collections (3 tal.Cash Available YOUR TURN: Create a formula that carries over the collections in cells B3:M3. 7 Inventory Purchases Commissions YOUR TURN: Fill in January December and the word Recap along with your Spreadsheet ID in cell N1 on the Cash Budget worksheet. 10 Utilities 11 Other Operating Budget Cash Budget 36540 - 12000 10 Utilities 11 Other Operating Budget Cash Budget Operating Budget Cash Budget Jan Februar Lanuary 2 Cash Balance, Beginning Collections YOUR TURN: Create formulas that carry over the inventory payments and commissions in cells B7:M8. YOUR TURN: Enter a formula here that references the Minimum Cash Balance from the Inputs worksheet. 6 Less Disbursements 7 Inventory Purchases 8 Commissions 9 Payroll 10 Utilities 11 Other Operating Budget 2 (Cash Balace, Beginning $ 20,000.00 3 Collections 30000 Total Cash Available 6 less Disbursements YOUR TURN: Add a formulas for subtotals and ending balances for columns B:M, as well as beginning balances for columns C:M. Operating Budget Cash Budget Cash Budget dget wed 523 PM Edit View insert Format Tools Data Window Help Autodiaren s Home Insert Draw Page Layout Formulas Data Review P X Cabr (Body! 11 A A cash flow budget 3 Malte View Comments Share . O 2 . Custom $ % a 11 R13 x f x -SUM[87:812) 11100019.000 2.0 12. 0 1 3 .00 14 dienorts ever disbursements FR