Please help me fill in the blue boxes! (with excel formulas)
Previous picture was blurry. please help fill in blue boxes
Auto cash flow budget - Saved Lindsey Spicer Share 3 Review View Help Group File Home Insert Draw Page Layout Formulas Date roles Recent Soon Queries & Connection From Web Eng Connection Det Boes Dula Drone Range AP Tmi So W 11 8 YI Secondale Remove Duplicates Columns Dute Validation Managers Moser Geography TE What Forecast Anal Sheet Subt And O CP N a D February M December May June September October November Recap 154 Sanary 20,000 30.000 126.000 90,750 129.000 121.000 112.000 144.000 135.000 1.000 141,000 150,000 147,000 Cash Balance, Being 3 Collection 5 Total Cash Awaitable 0001 OP 200 Inventory B Com 7550 -1500 - 12000 16000 -611 130 1 7000 12000 16000 6450 12900 - 16000 OD 670 -110 1000 2000 16000 7050 14100 10000 2000 19 7350 -14700 - 16000 -7000 2000 14400 16000 7000 19500 470 -15000 16000 -7000 19500 10 Us 11 Othe 1600 7000 19900 000 61 0001 DO DE 19500 43500 90' OS 300 1200 7140 410 21000 310 21000 100 22000 140 2000 100 2000 190 22000 OVEC 0001 100 O 0 0 0 0 0 20120 20100 20 Total 2010 0 0 0 0 0 0 23 nous Order of Optom Operating Budget Cash Budget 1001 PM Type here to search B Get & Transform Data Queries & Connections Data Types Sort & Fiter 321 16000 D F H Operating Budget E LEFT/FIND Functions First Month's Sales in Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption TRIM Function Gross Margin Commission Ending Inventory SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption B Budget Assumptions 2. First Month's Sales in Units 10,000 3 Unit Sales Growth Per Month 250 4 Unit Sales Price $ 12.00 5 6 7 Gross Margin 50% 8 Commission 10% 9 Ending Inventory 60% 10 11 12 Minimum Cash Balance $ 20,000 13 Interest Rate 12% 14 15 Month Collections Payments 16 Month 1 25% 60% 17 Month 2 50% 18 Month 25% OX 19 20 Operating Expenses - Per Month 21 Payroll 16,000 22 Utilities 7.000 23 Other 19,500 24 25 26 27 28 29 Inputs Supporting Schedules Order of Operations Ready CONCATENATE/RIGHT Function Period 1 Period 2 Period 3 UPPER Function LOWER Function PERIOD 1 period 1 PERIOD 2 period 2 PERIOD 3 period 3 40% MID Function 7200 Payroll 7500 Utilities 7900. Other Operating Budget Cash Budget a Type here to search o . LAS La Recent Sources From Web Existing Connections Get Data - From Table/Range Queries & Connections Property Refresh A Edit Links Queries connection 21 09 Y PO er B Stocks Geography Sort Se Consolidate Remove Duplicates Relationships Text to Columns Data Validation - Manage Data Mo Data Tools GeTransform Data Advanced Sortar les B38 x SUMB26) H A 1 Wally's Widgets 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 Dollars 8 Budgeted Sales in Dollars 9 Sales Commissions in Dollars 10 11 Collection Ratio 12 anuary 13 February 14 March 15 April 16 May 17 June 18 July B D January February March April May 10000 10,250 10,500 10,750 6150 6300 6450 6600 16150 16550 16950 17350 6000 6150 6300 6450 10150 10650 10000 60900 62400 63900 65400 120000 123000 126000 129000 12000 12300 12600 12900 F G June July 11,000 11,250 6750 6900 17750 18150 6600 6750 11150 11400 66900 68400 132000 135000 13200 13500 10400 1 M September October November December 11,750 12.000 12,250 12,500 12,750 7200 7350 7500 7650 7650 18950 19350 19750 20150 20400 7050 7200 7350 7500 7650 11900 12150 12400 12650 12750 71400 7900 74000 79900 76500 141000 144000 147000 150000 151000 14100 14600 14700 15000 15300 11,500 2050 18550 6900 11650 69900 138000 13800 January February April May June NY September October November December March SOX 25% 25 SOM 25% 25% SON 25% 25% SON 25% 25 Son 25 25% 50% 25 25% SON 25 25 SON 25N SON 25% SON 25 SON 25 20 September 21 October 22 November 23 December 24 25 Collections January February March May 26 lancary 30000 6000 30000 0 27 February 0 30750 61500 30750 28 March 0 0 31500 63000 29 April 0 0 0 32250 Inputs Supporting Schedules Order of Operations Operating Budget Ready July August September October December 0 0 0 0 0 0 32250 O 31500 64500 Cash Budget 0 0 0 0 November 0 0 a O O 0 0 0 0 0 0 0 O 0 0 Type here to search o RI a + cash flow budget - Saved e Search Lindley Spices Share 2- Home Insert Draw Page Layout From Text/CSV Recent sources from Web Dining Connections G ata - omable Formulas Data Review View Help Oris & Connections Properties Refresh Stocks Geography 21 A 7 ellung Sort Fier Come Remove Duplicates this Colanta Vidrion - Man Duta Model ST What It Forecast Advanced Out Deres comme Sort C26 E H 1 D March M December N Recap 8354 September he November February October July April May At January 20,000 30.000 12 129.000 1 DO 141.00 126,000 11 DO 135,000 9070 144,000 147.000 150,000 6750 7150 2 Cash Balance, Beaning 3 Collection 5 Total Cash Available 6 Len Disbursements 7 Inter Purchases Com 9 Pro 10 Uits 11 Other 13 Total Dimet 1670 -700 14100 16000 - 15000 - 12000 16000 640 -17 16000 000 7200 14400 10000 -7000 -700 15100 16000 12300 16000 7000 1900 4 1600D 1600 2000 19500 47100 13200 -10000 -7000 1900 4500 16000 7000 19900 43500! THE DO 1900 1 000 - 1990 000 19500 1900 19500 o' 4140" 43500 1040 2140 2000 1930 22000 D 21000 21000 0 810 21000 0 20170 1200 2000 0 2014 21000 0 2100 0 2000 0 0 206 2050 0 0 0 0 0 0 20 Total Financing 21 Owend Pad 22 Cahang 24 25 21 30 Order of Operation Operating Budget Cash Budget 1006 Type here to search o 9. Lindary Scho wbudget prod Pending Formes Data Review View ories Connection Help File Home Tesert Draw Page Layout om From Web [wing Connection Get women Gwa 910 YY. Refresh A Stocks Geography at Sort Columns Managers Model What For ngop- Do Sed February March Art May une August September October November December January 20,000 30,000 N Recap 1354 90.750 123,000 126.000 129,000 132.000 135.000 13 OCO 141,000 144 000 147.000 150,000 6600 13200 - 10 2 Cashiance, Beginning 3 Collections 5 Total Cash Available 6 Less Dsbursements 7 Inventory Purchases 8 Commons 9 Payrol 10 11 Other 13 Totalements 14 Excess deficiency of receipts over disbursements 15 Financing 16 Interest 12:00 16000 6000 - 12000 1600 -7000 -19500 42500 6150 12300 16000 -7000 19500 42500 1200 160 -7000 19500 16000 6750 13500 16000 -7000 195.00 2050 -14100 16000 -7000 195.00 -7200 16400 - 16000 -7000 19500 7500 15000 16000 7000 19500 7350 -14700 - 16000 7000 19500 7500' -7000 1900 42500 -7000 1900 " 19500 7650 15300 16000 -7000 1950 42500 4500 200 30 2140 410 21000 0 20000 21000 10.60 71000 1480 21000 1700 22000 22000 21000 D 2000 0 20/0 0 2000 ZOO 2018" 0 20170 0 in Repayments 20 Total Financing 21 Dividends Paid 22 Cash Balance, India 2 200 0 2010 2060 0 0 0 0 25 27 28 InputSupporting Schedules Order of Operations Operating Budget Cash Budget 34 AM O Type here to search BI Auto cash flow budget - Saved Lindsey Spicer Share 3 Review View Help Group File Home Insert Draw Page Layout Formulas Date roles Recent Soon Queries & Connection From Web Eng Connection Det Boes Dula Drone Range AP Tmi So W 11 8 YI Secondale Remove Duplicates Columns Dute Validation Managers Moser Geography TE What Forecast Anal Sheet Subt And O CP N a D February M December May June September October November Recap 154 Sanary 20,000 30.000 126.000 90,750 129.000 121.000 112.000 144.000 135.000 1.000 141,000 150,000 147,000 Cash Balance, Being 3 Collection 5 Total Cash Awaitable 0001 OP 200 Inventory B Com 7550 -1500 - 12000 16000 -611 130 1 7000 12000 16000 6450 12900 - 16000 OD 670 -110 1000 2000 16000 7050 14100 10000 2000 19 7350 -14700 - 16000 -7000 2000 14400 16000 7000 19500 470 -15000 16000 -7000 19500 10 Us 11 Othe 1600 7000 19900 000 61 0001 DO DE 19500 43500 90' OS 300 1200 7140 410 21000 310 21000 100 22000 140 2000 100 2000 190 22000 OVEC 0001 100 O 0 0 0 0 0 20120 20100 20 Total 2010 0 0 0 0 0 0 23 nous Order of Optom Operating Budget Cash Budget 1001 PM Type here to search B Get & Transform Data Queries & Connections Data Types Sort & Fiter 321 16000 D F H Operating Budget E LEFT/FIND Functions First Month's Sales in Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption TRIM Function Gross Margin Commission Ending Inventory SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption B Budget Assumptions 2. First Month's Sales in Units 10,000 3 Unit Sales Growth Per Month 250 4 Unit Sales Price $ 12.00 5 6 7 Gross Margin 50% 8 Commission 10% 9 Ending Inventory 60% 10 11 12 Minimum Cash Balance $ 20,000 13 Interest Rate 12% 14 15 Month Collections Payments 16 Month 1 25% 60% 17 Month 2 50% 18 Month 25% OX 19 20 Operating Expenses - Per Month 21 Payroll 16,000 22 Utilities 7.000 23 Other 19,500 24 25 26 27 28 29 Inputs Supporting Schedules Order of Operations Ready CONCATENATE/RIGHT Function Period 1 Period 2 Period 3 UPPER Function LOWER Function PERIOD 1 period 1 PERIOD 2 period 2 PERIOD 3 period 3 40% MID Function 7200 Payroll 7500 Utilities 7900. Other Operating Budget Cash Budget a Type here to search o . LAS La Recent Sources From Web Existing Connections Get Data - From Table/Range Queries & Connections Property Refresh A Edit Links Queries connection 21 09 Y PO er B Stocks Geography Sort Se Consolidate Remove Duplicates Relationships Text to Columns Data Validation - Manage Data Mo Data Tools GeTransform Data Advanced Sortar les B38 x SUMB26) H A 1 Wally's Widgets 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 Dollars 8 Budgeted Sales in Dollars 9 Sales Commissions in Dollars 10 11 Collection Ratio 12 anuary 13 February 14 March 15 April 16 May 17 June 18 July B D January February March April May 10000 10,250 10,500 10,750 6150 6300 6450 6600 16150 16550 16950 17350 6000 6150 6300 6450 10150 10650 10000 60900 62400 63900 65400 120000 123000 126000 129000 12000 12300 12600 12900 F G June July 11,000 11,250 6750 6900 17750 18150 6600 6750 11150 11400 66900 68400 132000 135000 13200 13500 10400 1 M September October November December 11,750 12.000 12,250 12,500 12,750 7200 7350 7500 7650 7650 18950 19350 19750 20150 20400 7050 7200 7350 7500 7650 11900 12150 12400 12650 12750 71400 7900 74000 79900 76500 141000 144000 147000 150000 151000 14100 14600 14700 15000 15300 11,500 2050 18550 6900 11650 69900 138000 13800 January February April May June NY September October November December March SOX 25% 25 SOM 25% 25% SON 25% 25% SON 25% 25 Son 25 25% 50% 25 25% SON 25 25 SON 25N SON 25% SON 25 SON 25 20 September 21 October 22 November 23 December 24 25 Collections January February March May 26 lancary 30000 6000 30000 0 27 February 0 30750 61500 30750 28 March 0 0 31500 63000 29 April 0 0 0 32250 Inputs Supporting Schedules Order of Operations Operating Budget Ready July August September October December 0 0 0 0 0 0 32250 O 31500 64500 Cash Budget 0 0 0 0 November 0 0 a O O 0 0 0 0 0 0 0 O 0 0 Type here to search o RI a + cash flow budget - Saved e Search Lindley Spices Share 2- Home Insert Draw Page Layout From Text/CSV Recent sources from Web Dining Connections G ata - omable Formulas Data Review View Help Oris & Connections Properties Refresh Stocks Geography 21 A 7 ellung Sort Fier Come Remove Duplicates this Colanta Vidrion - Man Duta Model ST What It Forecast Advanced Out Deres comme Sort C26 E H 1 D March M December N Recap 8354 September he November February October July April May At January 20,000 30.000 12 129.000 1 DO 141.00 126,000 11 DO 135,000 9070 144,000 147.000 150,000 6750 7150 2 Cash Balance, Beaning 3 Collection 5 Total Cash Available 6 Len Disbursements 7 Inter Purchases Com 9 Pro 10 Uits 11 Other 13 Total Dimet 1670 -700 14100 16000 - 15000 - 12000 16000 640 -17 16000 000 7200 14400 10000 -7000 -700 15100 16000 12300 16000 7000 1900 4 1600D 1600 2000 19500 47100 13200 -10000 -7000 1900 4500 16000 7000 19900 43500! THE DO 1900 1 000 - 1990 000 19500 1900 19500 o' 4140" 43500 1040 2140 2000 1930 22000 D 21000 21000 0 810 21000 0 20170 1200 2000 0 2014 21000 0 2100 0 2000 0 0 206 2050 0 0 0 0 0 0 20 Total Financing 21 Owend Pad 22 Cahang 24 25 21 30 Order of Operation Operating Budget Cash Budget 1006 Type here to search o 9. Lindary Scho wbudget prod Pending Formes Data Review View ories Connection Help File Home Tesert Draw Page Layout om From Web [wing Connection Get women Gwa 910 YY. Refresh A Stocks Geography at Sort Columns Managers Model What For ngop- Do Sed February March Art May une August September October November December January 20,000 30,000 N Recap 1354 90.750 123,000 126.000 129,000 132.000 135.000 13 OCO 141,000 144 000 147.000 150,000 6600 13200 - 10 2 Cashiance, Beginning 3 Collections 5 Total Cash Available 6 Less Dsbursements 7 Inventory Purchases 8 Commons 9 Payrol 10 11 Other 13 Totalements 14 Excess deficiency of receipts over disbursements 15 Financing 16 Interest 12:00 16000 6000 - 12000 1600 -7000 -19500 42500 6150 12300 16000 -7000 19500 42500 1200 160 -7000 19500 16000 6750 13500 16000 -7000 195.00 2050 -14100 16000 -7000 195.00 -7200 16400 - 16000 -7000 19500 7500 15000 16000 7000 19500 7350 -14700 - 16000 7000 19500 7500' -7000 1900 42500 -7000 1900 " 19500 7650 15300 16000 -7000 1950 42500 4500 200 30 2140 410 21000 0 20000 21000 10.60 71000 1480 21000 1700 22000 22000 21000 D 2000 0 20/0 0 2000 ZOO 2018" 0 20170 0 in Repayments 20 Total Financing 21 Dividends Paid 22 Cash Balance, India 2 200 0 2010 2060 0 0 0 0 25 27 28 InputSupporting Schedules Order of Operations Operating Budget Cash Budget 34 AM O Type here to search BI
