please show cell referencing thanks!!!
Input Data Collections during month of sale Collections during month after sale. Collections during second month after sale Lease payments Target cash balance General and administrative salaries Depreciation charges Income tax payments (September & Dcember) Miscellaneous expenses New Building Payment(October) Cash on hand JULY 1st NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE Prepare a monthly cash budget for the last six months of the 2022 8% 79% 13% $5,000 $84,000 $36,500 $42,000 $57,500 $4,500 $236,000 $145,000 Original sales estimates Original labor and raw mat. estimates Forecasted Sales Sales (gross) Collections During month of sale During 1st month after sale During 2nd month after sale Total collections A 5 Purchases 6 Labor and raw materials 17 Payments for labor and raw materials 38 Payments 40 Payments for labor and raw materials 41 General and administrative salaries 42 Lease payments 43 Miscellaneous expenses Income tax payments 45 New Buliding Payment 46 Total payments May $175,000 $80,000 June July August September October November December $210,000 $380,000 $530,500 $608,000 $406,000 $345,000 $102,000 $92,000 $136,000 $798,000 $299,000 $245,000 $159,000 $91,000 General and administrative salaries Lease payments Miscellaneous expenses Encome tax payments New Building Payment Total payments Net Cash Flows Cash on hand at start of month Net cash flow (NCF): Total collections-Total payments Cumulative NCF: Prior month cumulative this month's NCF Cash Surplus (or Loan Requirement) Target cash balance Surplus cash or loan needed: Cum NCF-Target cash Highest Loan Needed Most Available for Investment Home Insert Draw Arial Black F37 f A A 31 During 1st month after sale 32 During 2nd month after sale 33 Total collections 34 35 Purchases 36 Labor and raw materials 17 Payments for labor and raw materials 39 Payments 40 Payments for labor and raw materials 41 General and administrative salaries Lease payments Miscellaneous expenses Income tax payments 45 New Building Payment Tatal payments Net Cash Flows 43 Cash on hand at start of month 50 Net cash flow (NCF): Total collections-Total payments 31 Cumulative NCP: Prior month cumulative this month's NCF SE 23Cash Surplus for Lnan Requirement) 34 Target cash balance 15 Surplus cash or lean needed: Cum NCF-Target cash esc 80 900 FF File Page Layout 10 B Formulas C Data Rew A*** View Share Currency A D G H 1 K L IM $165,900 $22,750 $300,200 $419,005 $551,420 $320,740 $272,550 $27,300 $40,400 $60,965 $90,740 $52,700 $366,545 $519,868 $650,267 $436,872 $332,837 $216,610 * $88,000 $92,000 $136,000 $798,000 $299,000 $245,000 $150,000 $91,000 Highest Loan Needed Most Available for Investment MacBook Air Automate Help Editing 8 Comm # Excel Chapter To Cash Budget SUMMER 2020 File Home Insert Draw Page Layout Dv 64 Arial Black 10 F37 -X h 201 25 Collections 30 During month of sale 31 During 1st month after sale 32 During 2nd month after sale 33 Total collections 24 35 Purchases 35 Labor and raw materials 37 Payments for labor and raw materials 31 Payments 40 Payments for labor and raw materials 41 General and administrative salaries 42 Lesse payments 43 Miscellaneous expenses 44 Income tax payments 45 New Building Payment Total payments 47 Net Cash Flows Cash on hand at start of month 34 Net cash flow NCF) Total collections-Total payments 11 Cumulative NCF: Prior month cumulative this month's NCF 52 Cash Burples for Lean Requirement) St Target cash belance 33 Surplus cash or lean needed Cum NCF-Target cash Chapter 16 B B Saved Formulas Data C (Option) View Automate Help 22 Currency G $27,968 $39,045 $300,200 $165,900 $22,750 $27,300 $216,618 $366,545 $130,000 K Review D E $68,000 $92,000 Share ~~~ H I 3 K $7,507 $25,392 $320,740 $51,373 $29,882 $419,095 $551,420 $49,400 $68,965 $519,868 $90,740 $272,550 $52,780 $332,837 $650,267 $436,872 $798,000 $299,000 $245,000 $159,000 $91,000 MacBook Air V Editing 1 Excel Chapter 10 Cash Budget SUMMER 20221 Sav File Home Imert Draw Page Layout Formulas 10 V B Data D C Search (Option-C View Arial Black 137 f B 4 5 Input Data 6 Collections during month of sale 7 Collections during month after sale 0 Collections during second month after sale 9 Lease payments 10 Target cash balance 11 General and administrative salaries 12 Depreciation charges 13 Income tax payments (September & December) 14 Miscellaneous expenses 15 New Building Payment(October) 18 Cash on hand JULY 1 17 18 NO CASH DISCOUNT IS OFFERED IN THE MONTH OF BALE 19 20 Prepare a monthly cash budget for the last six months of the 2022 21 22 23 Original sales estimates May $175,000 $88,000 24 Original labor and raw mat. estimates 25 Forecasted Sales 27 Sales (gross) $175,000 $210,000 $300,000 29 Collections 30 During month of sale $27,968 31 During 1st month after sale $165,000 32 During 2nd month after sale $22,750 Chapter 15+ Automate E Help Currency G 8% 79% 13% $5,000 $04,000 $36,500 $42,000 $57,500 $4,500 $230,000 $145,000 July June August $210,000 $300,000 $530,500 $92,000 $130,000 $790,000 $530,500 $39,045 $300,200 $27,300 Y Editing to H BY Share M I 3 K September October November December $608,000 $400,000 $345,000 $102,000 $299,000 $245,000 $159,000 501,000 $098,000 $406,000 $345,000 $102,000 $51,373 $29,882 $25,392 $419,095 $551,420 $320,740 $49,400 560,965 590,740 $7,507 $272,550 $52,780 L Input Data Collections during month of sale Collections during month after sale. Collections during second month after sale Lease payments Target cash balance General and administrative salaries Depreciation charges Income tax payments (September & Dcember) Miscellaneous expenses New Building Payment(October) Cash on hand JULY 1st NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE Prepare a monthly cash budget for the last six months of the 2022 8% 79% 13% $5,000 $84,000 $36,500 $42,000 $57,500 $4,500 $236,000 $145,000 Original sales estimates Original labor and raw mat. estimates Forecasted Sales Sales (gross) Collections During month of sale During 1st month after sale During 2nd month after sale Total collections A 5 Purchases 6 Labor and raw materials 17 Payments for labor and raw materials 38 Payments 40 Payments for labor and raw materials 41 General and administrative salaries 42 Lease payments 43 Miscellaneous expenses Income tax payments 45 New Buliding Payment 46 Total payments May $175,000 $80,000 June July August September October November December $210,000 $380,000 $530,500 $608,000 $406,000 $345,000 $102,000 $92,000 $136,000 $798,000 $299,000 $245,000 $159,000 $91,000 General and administrative salaries Lease payments Miscellaneous expenses Encome tax payments New Building Payment Total payments Net Cash Flows Cash on hand at start of month Net cash flow (NCF): Total collections-Total payments Cumulative NCF: Prior month cumulative this month's NCF Cash Surplus (or Loan Requirement) Target cash balance Surplus cash or loan needed: Cum NCF-Target cash Highest Loan Needed Most Available for Investment Home Insert Draw Arial Black F37 f A A 31 During 1st month after sale 32 During 2nd month after sale 33 Total collections 34 35 Purchases 36 Labor and raw materials 17 Payments for labor and raw materials 39 Payments 40 Payments for labor and raw materials 41 General and administrative salaries Lease payments Miscellaneous expenses Income tax payments 45 New Building Payment Tatal payments Net Cash Flows 43 Cash on hand at start of month 50 Net cash flow (NCF): Total collections-Total payments 31 Cumulative NCP: Prior month cumulative this month's NCF SE 23Cash Surplus for Lnan Requirement) 34 Target cash balance 15 Surplus cash or lean needed: Cum NCF-Target cash esc 80 900 FF File Page Layout 10 B Formulas C Data Rew A*** View Share Currency A D G H 1 K L IM $165,900 $22,750 $300,200 $419,005 $551,420 $320,740 $272,550 $27,300 $40,400 $60,965 $90,740 $52,700 $366,545 $519,868 $650,267 $436,872 $332,837 $216,610 * $88,000 $92,000 $136,000 $798,000 $299,000 $245,000 $150,000 $91,000 Highest Loan Needed Most Available for Investment MacBook Air Automate Help Editing 8 Comm # Excel Chapter To Cash Budget SUMMER 2020 File Home Insert Draw Page Layout Dv 64 Arial Black 10 F37 -X h 201 25 Collections 30 During month of sale 31 During 1st month after sale 32 During 2nd month after sale 33 Total collections 24 35 Purchases 35 Labor and raw materials 37 Payments for labor and raw materials 31 Payments 40 Payments for labor and raw materials 41 General and administrative salaries 42 Lesse payments 43 Miscellaneous expenses 44 Income tax payments 45 New Building Payment Total payments 47 Net Cash Flows Cash on hand at start of month 34 Net cash flow NCF) Total collections-Total payments 11 Cumulative NCF: Prior month cumulative this month's NCF 52 Cash Burples for Lean Requirement) St Target cash belance 33 Surplus cash or lean needed Cum NCF-Target cash Chapter 16 B B Saved Formulas Data C (Option) View Automate Help 22 Currency G $27,968 $39,045 $300,200 $165,900 $22,750 $27,300 $216,618 $366,545 $130,000 K Review D E $68,000 $92,000 Share ~~~ H I 3 K $7,507 $25,392 $320,740 $51,373 $29,882 $419,095 $551,420 $49,400 $68,965 $519,868 $90,740 $272,550 $52,780 $332,837 $650,267 $436,872 $798,000 $299,000 $245,000 $159,000 $91,000 MacBook Air V Editing 1 Excel Chapter 10 Cash Budget SUMMER 20221 Sav File Home Imert Draw Page Layout Formulas 10 V B Data D C Search (Option-C View Arial Black 137 f B 4 5 Input Data 6 Collections during month of sale 7 Collections during month after sale 0 Collections during second month after sale 9 Lease payments 10 Target cash balance 11 General and administrative salaries 12 Depreciation charges 13 Income tax payments (September & December) 14 Miscellaneous expenses 15 New Building Payment(October) 18 Cash on hand JULY 1 17 18 NO CASH DISCOUNT IS OFFERED IN THE MONTH OF BALE 19 20 Prepare a monthly cash budget for the last six months of the 2022 21 22 23 Original sales estimates May $175,000 $88,000 24 Original labor and raw mat. estimates 25 Forecasted Sales 27 Sales (gross) $175,000 $210,000 $300,000 29 Collections 30 During month of sale $27,968 31 During 1st month after sale $165,000 32 During 2nd month after sale $22,750 Chapter 15+ Automate E Help Currency G 8% 79% 13% $5,000 $04,000 $36,500 $42,000 $57,500 $4,500 $230,000 $145,000 July June August $210,000 $300,000 $530,500 $92,000 $130,000 $790,000 $530,500 $39,045 $300,200 $27,300 Y Editing to H BY Share M I 3 K September October November December $608,000 $400,000 $345,000 $102,000 $299,000 $245,000 $159,000 501,000 $098,000 $406,000 $345,000 $102,000 $51,373 $29,882 $25,392 $419,095 $551,420 $320,740 $49,400 560,965 590,740 $7,507 $272,550 $52,780 L
