To prepare the cash budget for Silo Limited for February and March 2025, we will first create the Debtors Collection Schedule and then the Cash Budget.
### Debtors Collection Schedule
**February:**
- Collections from January Credit Sales: 25% of 405000 = 101250
- Collections from December Credit Sales: 25% of 600000 = 150000
- Collections from February Credit Sales: 50% of 450000 = 225000
**Total for February:**
1. Collections from January Credit Sales: 101250
2. Collections from December Credit Sales: 150000
3. Collections from February Credit Sales: 225000
4. **Total:** 101250 + 150000 + 225000 = **476250**
**March:**
- Collections from February Credit Sales: 25% of 450000 = 112500
- Collections from January Credit Sales: 25% of 405000 = 101250
- Collections from March Credit Sales: 50% of 495000 = 247500
**Total for March:**
1. Collections from February Credit Sales: 112500
2. Collections from January Credit Sales: 101250
3. Collections from March Credit Sales: 247500
4. **Total:** 112500 + 101250 + 247500 = **461250**
### Cash Budget of Silo Ltd
| | February | March |
|-------------------|----------|--------|
| Opening balance | 300000 | 411250 |
| Add: Total receipts | | |
| Cash sales | 450000 | 300000 |
| Credit sales | 476250 | 461250 |
| Interest | 25000 | 25000 |
| Rent income | 10500 | 10500 |
| Equipment | 0 | 500000 |
| **Total cash available** | 1307750 | 1361000 |
| Less: Total cash payments | | |
| Purchases | 145500 | 97000 |
| Salaries | 200000 | 100000 |
| Rent | 11100 | 11100 |
| Interest | 4000 | 4000 |
| Advertising | 6000 | 6000 |
| Equipment | 0 | 500000 |
| Sundry Expenses | 55450 | 39500 |
| **Total cash payments** | 360050 | 1061600 |
| **Closing balance** | 947000 | 299000 |
### Final Blanks
#### Debtors Collection Schedule
Blank 1: 101250
Blank 2: 150000
Blank 3: 225000
Blank 4: 476250
Blank 5: 112500
Blank 6: 101250
Blank 7: 247500
Blank 8: 461250
Blank 9: 476250
Blank 10: 461250
Blank 11: **Total**: 937500
Blank 12: 937500
#### Cash Budget of Silo Ltd
Blank 15: 300000
Blank 16: 411250
Blank 17: 1307750
Blank 18: 1361000
Blank 19: 450000
Blank 20: 300000
Blank 21: 476250
Blank 22: 461250
Blank 23: 25000
Blank 24: 25000
Blank 25: 10500
Blank 26: 10500
Blank 27: 0
Blank 28: 500000
Blank 29: 1307750
Blank 30: 1361000
Blank 31: 360050
Blank 32: 1061600
Blank 33: 145500
Blank 34: 97000
Blank 35: 200000
Blank 36: 100000
Blank 37: 11100
Blank 38: 11100
Blank 39: 4000
Blank 40: 4000
Blank 41: 6000
Blank 42: 6000
Blank 43: 0
Blank 44: 500000
Blank 45: 55450
Blank 46: 39500
Blank 47: 947000
Blank 48: 299000
This completes your cash budget, taking into account all the scheduled collections, cash sales, and planned expenditures.