Question

1 Approved Answer

Posted on Jul 30, 2024

PLEASE SHOW CELL REFERENCES IN EXCEl!!!!!!! PLEASE SHOW CELL REFERENCES IN EXCEl!!!!!!! PLEASE SHOW CELL REFERENCES IN EXCEl!!!!!!! # Excel Chapter 10 Cash Budget SUMMER

PLEASE SHOW CELL REFERENCES IN EXCEl!!!!!!!

# Excel Chapter 10 Cash Budget SUMMER 20221 Sav Formulas Data File Home Imert Draw Page Layout Arial Black 10 3 BA 137 $ A B C D 4 5 Input Data & Collections during month of sale 7 Collections during month after sale 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) 16 Cash on hand JULY 1st 17 18 NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE 19 20 Prepare a menthly cash budget for the last six months of the 2022 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 29 Collections 30 During month of sale 31 During 1st month after sale 32 During 2nd month after sale Chapter 16+ Search (Option - Q N View E E Automate F 8% 79% 13% $5,000 $04,000 $36,500 $42,000 $57,500 $4,500 $230,000 $145,000 July June $210,000 $300,000 592,000 $130,000 $210,000 $380,000 $27,900 $165,900 $22,750 Help Editing V 10 H 1 3 K August September October November December $530,500 $600,000 $400,000 $345,000 $102,000 $790,000 $200,000 $245,000 $159,000 $91,000 $530,500 $098,000 $400,000 $345,000 $102,000 $39,045 $51,373 $29,882 $25,392 $300,200 $7,507 $272,550 $419,095 $551,420 $320,740 $27,300 $49,400 560,965 590,740 $52,780 Currency G KY Share L 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 Formulas Data File Home Imert Draw Page Layout Arial Black 10 3 BA 137 $ A B C D 4 5 Input Data & Collections during month of sale 7 Collections during month after sale 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) 16 Cash on hand JULY 1st 17 18 NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE 19 20 Prepare a menthly cash budget for the last six months of the 2022 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 29 Collections 30 During month of sale 31 During 1st month after sale 32 During 2nd month after sale Chapter 16+ Search (Option - Q N View E E Automate F 8% 79% 13% $5,000 $04,000 $36,500 $42,000 $57,500 $4,500 $230,000 $145,000 July June $210,000 $300,000 592,000 $130,000 $210,000 $380,000 $27,900 $165,900 $22,750 Help Editing V 10 H 1 3 K August September October November December $530,500 $600,000 $400,000 $345,000 $102,000 $790,000 $200,000 $245,000 $159,000 $91,000 $530,500 $098,000 $400,000 $345,000 $102,000 $39,045 $51,373 $29,882 $25,392 $300,200 $7,507 $272,550 $419,095 $551,420 $320,740 $27,300 $49,400 560,965 590,740 $52,780 Currency G KY Share L 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