ACCOUNTING
tia900
assignment_2_-_excel_template.xlsBudgets
| Sales Budget | ||||||||
| April | May | June | July | August | September | Total | ||
| Sales | £0 | |||||||
| Units | 0 | |||||||
| Sales Price | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Debtors Budget | ||||||||
| April | May | June | July | August | September | Total | ||
| Opening Debtors | £0 | |||||||
| Sales | £0 | |||||||
| £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Cash Received | £0 | |||||||
| Closing Debtors | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Creditors Budget | ||||||||
| April | May | June | July | August | September | Total | ||
| Opening Creditors | £0 | |||||||
| Purchases | £0 | |||||||
| £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Cash Paid | £0 | |||||||
| Closing Creditors | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Raw Materials Budget | ||||||||
| April | May | June | July | August | September | Total | ||
| Opening Stock of RM | £0 | |||||||
| Purchases | £0 | |||||||
| £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| UnitsProduced | £500 | £500 | £500 | £500 | £500 | £500 | £3,000 | |
| Used in Production* | £0 | |||||||
| Closing Stock of RM | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Finished Goods Budget | ||||||||
| April | May | June | July | August | September | Total | ||
| Opening Stock of FG | £0 | |||||||
| Produced ** | £0 | |||||||
| £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Cost of sales* | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Closing Stock of FG | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Production Costs Budget | ||||||||
| April | May | June | July | August | September | Total | ||
| Direct Materials | £0 | |||||||
| Direct Labour | £0 | |||||||
| Production Overheads | £0 | |||||||
| £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Cash Budget | ||||||||
| April | May | June | July | August | September | Total | ||
| Opening Cash | £0 | |||||||
| Add Receipts | ||||||||
| Debtors | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Less Payments | ||||||||
| Payment for Goods | £0 | |||||||
| Non-production exps | £0 | |||||||
| Direct Labour | £0 | |||||||
| Production Overhead | £0 | |||||||
| £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Cashflow | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Closing Cash | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
P&L and BSheet
| P&L | ||||||
| Sales | £0 | |||||
| Cost of Sales | £0 | |||||
| Gross Profit | £0 | |||||
| Less Expenses | ||||||
| Depreciation | ||||||
| Expenses | £0 | |||||
| £0 | ||||||
| Net Profit / (Loss) | £0 | |||||
| Balance Sheet | ||||||
| Cost | Depn | NBV | ||||
| Fixed Assets | 0 | |||||
| Current Assets | ||||||
| Debtors | 0 | |||||
| Stock of raw materials | 0 | |||||
| stock of finished goods | 0 | 0 | ||||
| Current liabilities | ||||||
| Creditors | 0 | |||||
| Bank overdraft | 0 | 0 | ||||
| Net Current Assets | 0 | |||||
| Total Net Assets | 0 | |||||
| Share Capital and Reserves | ||||||
| Share Capital | ||||||
| Opening P&L | ||||||
| Loss for year | ||||||
| Total Shareholders Funds | 0 |
