In: Finance
Finish the following Cash Budget
CASH BUDGET | |||||||||||||
JAN | FEB | MAR | APRIL | MAY | JUNE | JULY | AUG | SEPT | OCT | NOV | DEC | ||
SALES | 200,000 | 230,000 | 150000 | 210,000.00 | 220,000.00 | 170,000.00 | 160,000.00 | 150,000.00 | 180,000.00 | 210,000.00 | 220,000.00 | 210,000.00 | |
COLLECTIONS: | |||||||||||||
No cash Sales | |||||||||||||
30 days | 50% | ||||||||||||
60 days | 50% | ||||||||||||
TOTAL CASH RECEIPTS | |||||||||||||
CASH DISBURSEMENTS | |||||||||||||
SUPPLIES | 70% | ||||||||||||
PAYABLES/SUPPLIES | paid next month(in 30 days) | ||||||||||||
SALARIES/OVER | monthly | 40000 | |||||||||||
INTEREST | monthly | 1000 | |||||||||||
DIVIDENDS | monthly | 1000 | |||||||||||
TAXES | quarterly | 1200 | |||||||||||
TOTAL DISBURSEMENT | 42000 | 0 | 1200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
NET CHANGE IN CASH | |||||||||||||
BEGINNING CASH | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
FINANCING NEEDED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
ENDING CASH | |||||||||||||
starting loan balance | |||||||||||||
CUMMULATIVE BORROWING | 100,000 |
JAN | FEB | MAR | APRIL | MAY | JUNE | JULY | AUG | SEPT | OCT | NOV | DEC | ||
SALES | 200,000 | 230,000 | 150000 | 210,000.00 | 220,000.00 | 170,000.00 | 160,000.00 | 150,000.00 | 180,000.00 | 210,000.00 | 220,000.00 | 210,000.00 | |
COLLECTIONS: | |||||||||||||
30 days | 50% | 100000 | 115000 | 75000 | 105000 | 110000 | 85000 | 80000 | 75000 | 90000 | 105000 | ||
60 days | 50% | 100000 | 115000 | 75000 | 105000 | 110000 | 85000 | 80000 | 75000 | 90000 | 105000 | ||
TOTAL CASH RECEIPTS | 100000 | 215000 | 190000 | 180000 | 215000 | 195000 | 165000 | 155000 | 165000 | 195000 | 105000 | ||
SUPPLIES | 70% | ||||||||||||
SUPPLIES | paid next month | 140000 | 161000 | 105000 | 147000 | 154000 | 119000 | 112000 | 105000 | 126000 | 147000 | 154000 | |
SALARIES | monthly | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 |
INTEREST | monthly | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |
DIVIDENDS | monthly | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |
TAXES | quarterly | 1200 | 1200 | 1200 | 1200 | ||||||||
TOTAL | 42000 | 182000 | 204200 | 147000 | 189000 | 198000 | 161000 | 154000 | 148200 | 168000 | 189000 | 198200 | |
NET CHANGE IN CASH | (42000) | (82000) | 10800 | 43000 | (9000) | 17000 | 34000 | 11000 | 6800 | (3000) | 6000 | (93200) | |
FINANCING NEEDED | (32000) | (114000) | (103200) | (60200) | (69200) | (52200) | (18200) | (7200) | (400) | (3400) | 2600 | (90600) | |
CUMMULATIVE BORROWING | 100,000 |