Cyrus Brown Manufacturing
Tootie
gmp.xlsxSheet1
| MONTHLY CASH BUDGET FOR CYRUS BROWN MANUFACTURING | |||||||||||||||||||
| MARCH - NOVEMBER | |||||||||||||||||||
| (MC1) | (MC2) | (MC3) | (TC1) | (DMC) | (AS) | (LP) | (NP) | (IT) | (MISC.) | (TC2) | |||||||||
| MOS 25% | MFS 55% | 2nd MFS 20% | Total | DMC | ADMIN | Lease | New | Income | MISC. | Total | Profit / | Financing | Cash on | Net | |||||
| Sales Forecast | Collection | Collection | Collection | Collection | COSTS | Salaries | Pymnts | Plant | Tax | Costs | Loss | Needed | Hand | Balance | |||||
| March | $100,000 | $25,000 | 25000 | $35,000 | $15,000 | $10,000 | $60,000 | -$35,000 | $35,000 | $50,000 | $35,000 | ||||||||
| April | $275,000 | $68,750 | 55,000 | 123750 | $187,500 | $35,000 | $15,000 | $10,000 | $247,500 | -$123,750 | $123,750 | $50,000 | $158,750 | ||||||
| May | $320,000 | $80,000 | 151,250 | $20,000 | 251250 | $206,250 | $35,000 | $15,000 | $10,000 | $266,250 | -$15,000 | $15,000 | $50,000 | $173,750 | |||||
| June | $450,000 | $112,500 | 176,000 | $55,000 | 343500 | $375,000 | $35,000 | $15,000 | $95,000 | $55,000 | $10,000 | $585,000 | -$241,500 | $241,500 | $50,000 | $415,250 | |||
| July | $700,000 | $175,000 | 247,500 | $64,000 | 486500 | $337,500 | $35,000 | $15,000 | $10,000 | $397,500 | $89,000 | -$89,000 | $50,000 | $326,250 | |||||
| August | $700,000 | $175,000 | 385,000 | $90,000 | 650000 | $431,250 | $35,000 | $15,000 | $10,000 | $491,250 | $158,750 | -$158,750 | $50,000 | $167,500 | |||||
| September | $825,000 | $206,250 | 385,000 | $140,000 | 731250 | $640,000 | $35,000 | $15,000 | $55,000 | $10,000 | $755,000 | -$23,750 | $23,750 | $50,000 | $191,250 | ||||
| October | $500,000 | $125,000 | 453,750 | $140,000 | 718750 | $395,000 | $35,000 | $15,000 | $10,000 | $455,000 | $263,750 | -$263,750 | $50,000 | -$72,500 | |||||
| November | $115,000 | $28,750 | 275,000 | $100,000 | 403750 | $425,000 | $35,000 | $15,000 | $10,000 | $485,000 | -$81,250 | $81,250 | $50,000 | $8,750 | |||||
| Payment collection within month of sale | 25% | ||||||||||||||||||
| Payment collection within month following sales | 55% | Calculations | |||||||||||||||||
| Payment Collection the second month following sales | 20% | Total collection = MC1+MC2+MC3 | |||||||||||||||||
| Admnistrative salaries per month | $35,000 | Total Costs = DMC+AS+LP+NP+IT+MISC. | |||||||||||||||||
| Lease payments per month | $15,000 | Profit/Loss = TC1-TC2 | |||||||||||||||||
| Depreciation per month | $15,000 | Net Balance = TC2-TC1+PREVIOUS BALANCE | |||||||||||||||||
| One time plant investment in June | $95,000 | ||||||||||||||||||
| Income tax in June and September | $55,000 | ||||||||||||||||||
| Miscellaneous costs | $10,000 | ||||||||||||||||||
| Cash on hand at all times with a minimum balance of the same | $50,000 | ||||||||||||||||||
1
2
3
4
5
6
7
8
9
A
B
C
D
E
Sales Forecast
March
$100,000
April
$275,000
May
$320,000
