B Format Painter Es ed Merge Center $ %. Conditional Format as a Formatting Table Styles Clipboard Font Alignment Number B9 A 2975000 A 3 4 CASH BUDGET 5 for the year ending 31st December 2020 6 1 Year 7 Beginning cash balance $15,000.00 $10,000.00 $10,000.00 $309,627.50 8 Add: Receipts $15,000.00 9 Collections from Customers $2.975,000.00 $4,652,000.00 $5,089,500.00 $5,211,000.00 $17,927,500.00 10 Total receipts: $2.975,000.00 $4,652,000.00 $5,089,500.00 $5,211,000.00 $17,927,500.00 11 Total available cash: $2,990,000.00 $4,662,000.00 $5,099,500.00 $5,520,627.50 $17,942,500.00 12 Less: Disbursements 13 Direct Materials $4,110,000.00 $4,140,000.00 $4,050,000.00 $4,320,000.00 $16,620,000.00 14 Direct Labour $406,350.00 $434,700.00 $425,250.00 $453,600.00 $1,719,900.00 15 Manufacturing Overhead $223,299.00 $238,878.00 $233,685.00 $249,264.00 $945, 126.00 16 Selling and Administrative expenses $45,622.50 $46,095.00 $45,937.50 $46,410.00 $183,965,00 17 Purchase of a truck $35,000.00 $35,000.00 $70,000.00 18 Income Tax expense $4,591,370.10 $4,591,370.10 19 Dividends $60,000.00 $60,000.00 20 Total disbursements: $4,820,271.50 $4,859,673.00 $4,789,872.50 $9,720,644.10 $24,190,361.10 Excess (deficiency) of available cash over 21 cash disbursements -$1,830,271.50 -$197,673.00 $309,627.50 $4,200,016.60 $6, 247,861.10 22 Financing $207,673,00 $1,840,271.50 $4,219,016.60 $6,266,861.10 23 Add: Borrowings $9.000.00 $9.000.00 24 Less: Repavments includine interest CVP Income Statement Cash Budget Worksheets Instructions Balance Sheet Ready ORI O Search + B Format Painter Es ed Merge Center $ %. Conditional Format as a Formatting Table Styles Clipboard Font Alignment Number B9 A 2975000 A 3 4 CASH BUDGET 5 for the year ending 31st December 2020 6 1 Year 7 Beginning cash balance $15,000.00 $10,000.00 $10,000.00 $309,627.50 8 Add: Receipts $15,000.00 9 Collections from Customers $2.975,000.00 $4,652,000.00 $5,089,500.00 $5,211,000.00 $17,927,500.00 10 Total receipts: $2.975,000.00 $4,652,000.00 $5,089,500.00 $5,211,000.00 $17,927,500.00 11 Total available cash: $2,990,000.00 $4,662,000.00 $5,099,500.00 $5,520,627.50 $17,942,500.00 12 Less: Disbursements 13 Direct Materials $4,110,000.00 $4,140,000.00 $4,050,000.00 $4,320,000.00 $16,620,000.00 14 Direct Labour $406,350.00 $434,700.00 $425,250.00 $453,600.00 $1,719,900.00 15 Manufacturing Overhead $223,299.00 $238,878.00 $233,685.00 $249,264.00 $945, 126.00 16 Selling and Administrative expenses $45,622.50 $46,095.00 $45,937.50 $46,410.00 $183,965,00 17 Purchase of a truck $35,000.00 $35,000.00 $70,000.00 18 Income Tax expense $4,591,370.10 $4,591,370.10 19 Dividends $60,000.00 $60,000.00 20 Total disbursements: $4,820,271.50 $4,859,673.00 $4,789,872.50 $9,720,644.10 $24,190,361.10 Excess (deficiency) of available cash over 21 cash disbursements -$1,830,271.50 -$197,673.00 $309,627.50 $4,200,016.60 $6, 247,861.10 22 Financing $207,673,00 $1,840,271.50 $4,219,016.60 $6,266,861.10 23 Add: Borrowings $9.000.00 $9.000.00 24 Less: Repavments includine interest CVP Income Statement Cash Budget Worksheets Instructions Balance Sheet Ready ORI O Search +