I want to know the exact formulas that are highlighted in the second picture in the white box at the top for each because I'm confused and don't know what to do.

It's a cash budget.

2 A D E F G Hi February October November December Totals January March April July September June August Cash Balance, Beginning Collections 20,000 141,000 147,000 150,000 1,485,750 126,000 138,000 144,000 30,000 90,750 123,000 129,000 132,000 135,000 144,000 150,000 141,000 147,000 1,505,750 Total Cash Available 126,000 132,000 138,000 50,000 90,750 123,000 129,000 135,000 5 Less Disbursements Inventory Purchases 75,300 15,000 76,260 798,300 72,300 73,800 67.800 69,300 70,800 61,800 63,300 64,800 66,300 36,540 15,300 163,800 14.400 14.700 14.100 13,200 13,500 13,800 Commissions 12,000 12,300 12,600 12.900 192,000 2,304,000 192,000 192,000 192.000 192,000 192.000 192,000 192,000 Payroll 0 Utilities 1 Other 192,000 192,000 192,000 192.000 84.000 1,008,000 2,808,000 84,000 84.000 84,000 84.000 84,000 84.000 84,000 84,000 84,000 84,000 84,000 234,000 234,000 234,000 234,000 234,000 234.000 234,000 234,000 234,000 234,000 234,000 234,000 2 7,082,100 600,300 601,560 598,500 594,900 596,700 587,700 59 593,100 589,500 585,900 584,100 3 Total Disbursements 558,540 5,576,350 453,300 451,560 455,700 454,500 456,900 458,100 460,500 459,300 462,900 461,700 4 Excess (deficiency) of receipts o 5 Financing 493,350 508,540 6 Interest 7 Borrowings 18 Repayments 19 20 Total Financing 21 Dividends Paid 22 Cash Balance, Ending 03 X D Copy aste Format Painter -A Clipboard Font 821 A January February March Cash Balance, Beginning 20,000 Collections 30,000 90,750 123,000 12 Total Cash Available Less Disbursements 50,000 90,750 123,000 12 Inventory Purchases 36,540 61,800 63,300 Commissions 12,000 12,300 12,600 1 Payroll 192,000 192,000 192,000 19 Utilities 84,000 84,000 84,000 84 Other 234,000 234,000 234,000 23 Total Disbursements 558,540 584,100 585,900 587 Excess (deficiency) of receipts o Financing 508,540 493,350 462,900 461 Interest Borrowings Repayments Total Financing Dividends Paid Cash Balance, Ending Inputs Supporting Schedules Operating Budget dit Budget Assumptions First Month's Sales 5Sales Price Gross Margin 10,000 12.00 50% 7 Commission 8 Sales Growth 9 Ending Inventory 10 Minimum Cash Balance 10% 250 60% 20,000 11 Interest Rate 12 13 12% Collections Payments 60% 14 Month 1 25% %0t 09% 50% 15 Month 2 25% 16 Month 3 17 18 Operating Expenses 19 Payroll 20 Utilities Per Month $192,000 $84,000 $234,000 21 Other 22 Formatting Table Styles Clipboard Font Alignment Number Styles Cells fr IFERROR (CHOOSE(MONTH(B$11&1)-MONTH(SA12&1)+1, Collections1 3315,Collections2 3315,Collections3 3315),0) B12 E N F G Hi C Wally's Widgets January September October November December 1 February April August March May June July 2 Budgeted Sales in Units 3 Add: Ending Inventory 4 Total Needs 5 Less Beginning Inventory 6 Required Purchases in Units 7 Required Purchases in Dolla 8 Budgeted Sales in Dollars 9 Sales Commissions in Dolla 12,750 10,000 10,250 11,750 12,000 12.250 12,500 10,500 10,750 11,000 11,250 11,500 7,650 7,650 7,200 7,350 7,500 6.150 7,050 6,300 6,450 6,600 6,750 6,900 19,750 20,150 20,400 17,750 18,950 19,350 16,150 16,550 16,950 17,350 18,150 18,550 7,350 7,500 7,650 7,200 6,750 6,900 7,050 6,000 6,150 6,300 6,450 6,600 12,650 12,750 12.150 12,400 11,900 11,150 11,400 11,650 10,150 10,400 10,650 10,900 75,900 76,500 74,400 71,400 72,900 68,400 69,900 65,400 66,900 62,400 63,900 60,900 150,000 153,000 147,000 144,000 135,000 138,000 141,000 #### 132,000 126,000 120,000 123,000 15,000 15,300 14,700 14,400 14,100 13,500 13,800 13,200 12,600 12,900 12,000 12,300 10 September October November December 0 % August April May July June March February January 11 Collection Ratio 0 % 0 % 0 % 0 % 0 % 0% 0 % 0% 25% 50% 25% 12 January 13 February 14 March 0 % 0% 0 % 0% 0 % 0 % 0 % 0% 25% 0 % 50% 25% 0% 0% 0 % 0 % 0 % 0% 0% 0% 25% 50 % 25% 0 % 0% 0% 0 % 0 % 0% 0 % 0 % 50 % 25% 25% 0 % 0% 0 % 0% 0% 0 % 0 % 15 April 50 % 25% 25% 0 % 0% 0 % 0% 0 % 0% 0 % 0% 25% 16 May 0 % 50% 25% 0 % 0 % 0% 0% 0% 0 % 50 % 0% 25% 25% 17 June 0% 0% 0 % 0% 0 % 0% 0% 0% 25% 50% 25% 0% 0 % 0 % 18 July 0 % 0 % 0% 0% 25% 0% 50% 25% 0% 0 % 19 August 20 September O% 0 % 0% 0% 25% 0% 25 % 50% 0 % 0 % 0% 0 % 0% 0 % 0 % 0 % 0% 50% 0% 25% 0% 0% 0% 0 % 0% 0 % 0 % 0 % 21 October 25% 0% 0% 0 % 0% 0 % 09 0 % 0% 0 % 0 % 22 November 0 % 0% 0% 23 December October November December Sentemben August Jul bane May Anril 24 March Fehruary lanuary Cash Budget 25 Collectinns Operating Budget Supporting Schedules Inputs Ready 88888 8888 866 88885 Format Painter Fill Merge & Center $ Conditional Format as Cell Formatting Table Styles Insert Delete Format Clear Clipboard Font Alignment Number Styles Cells G8 -Sales Price G2 A D F K H M N 25 Collections August September October November December January February March April July May June 26 January 30,000 60,000 30,000 27 February 30,750 61,500 30,750 28 March 31,500 63,000 31,500 29 April 32,250 32,250 64,500 33,000 33,000 66,000 30 May 67,500 33,750 33,750 31 June 34,500 69,000 34,500 32 July 70,500 35,250 35,250 33 August 36,000 72,000 36,000 34 September 36,750 73,500 36,750 35 October 75,000 37,500 38,250 36 November 150,000 147,000 37 December 144,000 141,000 138,000 132,000 135,000 129,000 126,000 123,000 90,750 30,000 38 Total August September October 0% November December July 39 June April May March 0% February 09% January 0% 0% 0% 40 Payment Ratio 0% 0% 0 % 0% 0% 40% 0% 60% 0% 09% 0% 0 % 0% 0 % 41 January 0 % 09% 40% 0 % 0% 60% 0% 0 % 0 % 0% 09% 42 February 0% 0% 0 % 0% 40% 60% 0% 0 % 0% 09% 0% 0% 0% March 40% 0 % 43 60% 0% 0% 0% 09% 0% 0% 09% 40% 60% 44 April 0% 0% 0% 0% Cash Budget 45 May Operating Budget Supporting Schedules Inputs Ready X C onal Format as Cell 66 Fill Insert Delete Format Clipboard Formatting Table Styles Font Clear Alignment Number Styles G8 Cells x f =Sales Price G2 A B C D F G K M 46 June N C 0% 0% 0% 0% 0% 60% 0 % 0 % 40% 0 % 0 % 0% 47 July 48 August 49 September 0 % 0% 0% 0% 0% 0 % 0% 60% 40% 0 % 09% 09% 0% 0% 0% 0% 0% 0% 0% 40% 0 % 60% 0% 0% 09% 0 % 0 % 40 % 0% 0% 0% 60 % 0 % 0 % 0% 0% 50 October 0%6 0% 0 % 0 % 40 % 0% 0% 0% 0% 0% 60% 0% 51 November 0 % 0% 0 % 40 % 0% 0% 0% 60% 0% 0% 0% 0% 0 % 0 % 60 % 0% 0% 0% 52 December 0% 0% 0% 0% 0% 0% 53 August September October November December July April May June February March 54 Payments 55 January 56 February January 24,360 36,540 24,960 37,440 38,340 25,560 57 March 26,160 39,240 58 April 59 May 26,760 40,140 27,360 41,040 27,960 60 June 41,940 28,560 42,840 61 July 62 August 29,160 43,740 29,760 44,640 63 September 64 October 30,360 45,540 45.900 65 November + Cash Budget 66 December Operating Budget Supporting Schedules Inputs Ready H Wrap Text Paste Custom BIU Format Painter A Merge & Center +0 00 Conditional Format as Cell Clipboard Insert Delete For Font Formatting Table- Styles Alignment Number Styles G8 X Cells Sales_Price*G2 A C D E F G 55 January K M 36,540 24,360 56 February 37,440 24,960 57 March 38,340 25,560 58 April 39,240 26,160 59 May 40,140 26,760 60 June 41,040 27,360 61 July 62 August 63 September 41,940 27,960 42,840 28,560 43,740 29,160 64 October 44,640 29,760 65 November 66 December 45,540 30,360 45,900 70,800 73,800 75,300 76,260 67 Total Payments 64,800 66,300 67,800 69,300 72,300 61,800 63,300 36,540 68 69 70 71 72 73 74 75 Tell me what you want to do Page Layout Data Review View Help Formulas Draw Home Insert File AutoSum X Cut ab Wrap Text A A Custom Calibri 11 Fill- Copy Insert Delete Format Sort & Find & Filter Select - Cell Conditional Format as Merge & Center Clear EE Paste A - B Format Painter Table Styles Formatting Editing Cells Styles Number Alignment Font Cipboard -SUMIF(Inputs!$A$19:SA$21,SA10,Inputs!$B$19:SB$21) B10 N K Hi G E C A December Total November October August September July June February March April May January 1,638,000 150,000 153,000 147,000 144,000 141,000 138,000 135,000 129,000 132,000 123,000 126,000 2 Sales 120,000 3 Cost of Goods Sold 828,900 76,500 75,900 74,400 71,400 72,900 69,900 68.400 65,400 66,900 63,900 60,900 62,400 Purchases 163,800 15,300 15,000 14,700 14,400 14,100 13,800 13,500 13,200 12,600 12,900 12,300 12,000 5 Commissions 992,700 91.800 90.900 89.100 87,300 85,500 81,900 83,700 78,300 80,100 76.500 74,700 72,900 7 Total Cost of Goods Sold 645,300 59,100 61,200 57,900 56,700 55,500 54,300 53.100 50,700 51,900 49,500 48,300 47,100 8 Gross Profit 9 Operating Expenses 10 Payroll 2,304,000 192,000 192,000 192,000 192.000 192,000 192,000 192,000 192,000 192,000 192,000 192,000 192,000 1,008,000 84,000 84,000 84,000 84,000 84,000 84,000 84,000 84,000 84,000 84,000 84,000 84,000 11 Utilities 2,808,000 234,000 234.000 234,000 234,000 234,000 234,000 234.000 234,000 234,000 234,000 234,000 234,000 12 Other 6,120,000 5,474,700 13 510,000 510,000 510,000 510,000 510,000 510.000 510,000 510,000 510,000 510,000 14 Total Operating Expenses 510,000 510,000 448,800 450,900 452,100 454,500 453,300 455,700 456,900 458,100 459,300 460,500 461,700 462,900 15 Net Income 16 17 18 19 20 21 Cash Budget Operating Budget Supporting Schedules Inputs Ready 10:3 6/21 WES h