Santa Rita Co.
Cash Budget calculated
Cash Receipts
September October November December January February March April
sales 210,000 250,000 170,000 160,000 140,000 180,000 200,000 250,000
cash sale 20% 42,000 50,000 34,000 32,000 28,000 36,000 40,000 50,000
Collections:
Lag 1 month 40% 84,000 100,000 68,000 64,000 56,000 72,000 80,000
Lag 2 month 40% 84,000 100,000 68,000 64,000 56,000 72,000
cash inflow 12,000 0 0 15,000 27,000 15,000 12,000
Total 218,000 200,000 175,000 183,000 183,000 214,000
Cash Disbursement
Purchases 120,000 150,000 140,000 100,000 80,000 110,000 100,000 90,000
Cash purchase 10% 12,000 15,000 14,000 10,000 8,000 11,000 10,000 9,000
1 Month Delay 50% 60,000 75,000 70,000 50,000 40,000 55,000 50,000
2 Month Delay 40% 48,000 60,000 56,000 40,000 32,000 44,000
Wages 20% (Sale) 50,000 34,000 32,000 28,000 36,000 40,000
Rent 20,000 20,000 20,000 20,000 20,000 20,000
Interest 0 0 10,000 0 0 10,000
Principal payment 0 0 0 0 0 30,000
Cash dividends 0 0 20,000 0 0 20,000
Taxes 0 0 0 0 0 80,000
Fixed Assets 0 25,000 0 0 0 0
Total 207,000 219,000 196,000 139,000 153,000 303,000
Cash Budget
Cash Receipts 218,000 200,000 175,000 183,000 183,000 214,000
Less: Cash Disbursement 207,000 219,000 196,000 139,000 153,000 303,000
Net Cash flow 11,000 -19,000 -21,000 44,000 30,000 -89,000
Add: Beginning Cash 22,000 33,000 14,000 -7,000 37,000 67,000
Ending Cash 33,000 14,000 -7,000 37,000 67,000 -22,000
Less: Minimum Cash Bal 15,000 15,000 15,000 15,000 15,000 15,000
Required Total Financing -1,000 -22,000 -37,000
Excess Balance 18,000 22,000 52,000
