October 2007 | ||||||
| Selected Period | Budgeted | £ Difference | % Difference | |||
____________________________________________________________________________________ | ||||||
| Assets | ||||||
| Cash Accounts | ||||||
| Bank Account | £16,664.83 | £34,878.91 | (£18,214.08) | (52.2%) | ||
| Petty Cash | £100.00 | £100.00 | £0.00 | 0.0% | ||
| Total Cash Accounts | £16,764.83 | £34,978.91 | (£18,214.08) | (52.1%) | ||
| Stock | ||||||
| Raw Materials | £3,400.00 | £3,400.00 | £0.00 | 0.0% | ||
| Finished Goods | £75,129.62 | £5,400.00 | £69,729.62 | 1,291.3% | ||
| Total Stock | £78,529.62 | £8,800.00 | £69,729.62 | 792.4% | ||
| Trade Debtors | £37,264.78 | £32,000.00 | £5,264.78 | 16.5% | ||
| Deposits Paid Suppliers | £100.00 | £100.00 | £0.00 | 0.0% | ||
| Office Equipment | ||||||
| Office Equip., Original Cost | £12,000.00 | £12,000.00 | £0.00 | 0.0% | ||
| Office Equip., Amortisation | (£4,000.00) | (£4,000.00) | £0.00 | 0.0% | ||
| Total Office Equipment | £8,000.00 | £8,000.00 | £0.00 | 0.0% | ||
| Vehicles | ||||||
| Vehicles, Original Cost | £32,000.00 | £32,000.00 | £0.00 | 0.0% | ||
| Vehicles, Amortisation | (£16,500.00) | (£16,500.00) | £0.00 | 0.0% | ||
| Total Vehicles | £15,500.00 | £15,500.00 | £0.00 | 0.0% | ||
| Other Assets | £500.00 | £500.00 | £0.00 | 0.0% | ||
| Total Assets | 156,659.23 | £99,878.91 | £56,780.32 | 56.8% | ||
| Liabilities | ||||||
| Credit Cards | ||||||
| American Express | £3,200.00 | £3,200.00 | £0.00 | 0.0% | ||
| Visa | £1,000.00 | £1,000.00 | £0.00 | 0.0% | ||
| Total Credit Cards | £4,200.00 | £4,200.00 | £0.00 | 0.0% | ||
| Trade Creditors | £10,615.14 | £21,000.00 | (£10,384.86) | (49.5%) | ||
| Bank Indebtedness | £100,000.00 | £100,000.00 | £0.00 | 0.0% | ||
| VAT Liabilities | ||||||
| VAT 1 Collected | £2,214.58 | £354.98 | £1,859.60 | 523.9% | ||
| VAT 2 Collected | £2,348.68 | £452.00 | £1,896.68 | 419.6% | ||
| Total VAT Liabilities | £4,563.26 | £806.98 | £3,756.28 | 465.5% | ||
| Payroll Liabilities | ||||||
| Payroll Liabilities | £13,919.25 | £0.00 | £13,919.25 | NA | ||
| Payroll Tax Payable | £105.00 | £0.00 | £105.00 | NA | ||
| Holiday Payable | £1,267.50 | £0.00 | £1,267.50 | NA | ||
| Total Payroll Liabilities | £15,291.75 | £0.00 | £15,291.75 | NA | ||
| Deposits from Customers | £500.00 | £500.00 | £0.00 | 0.0% | ||
| Total Liabilities | £135,170.15 | £126,506.98 | £8,663.17 | 6.8% | ||
| Capital | ||||||
| Paid in Capital | £110,000.00 | £110,000.00 | £0.00 | 0.0% | ||
| Retained Earnings | (£58,078.07) | (£136,628.07) | £78,550.00 | (57.5%) | ||
| Current Year Earnings | (£30,432.85) | £14,285.00 | (£44,717.85) | (313.0%) | ||
| Total Capital | £21,489.08 | (£12,343.07) | £33,832.15 | (274.1%) | ||
| ____________ | ____________ | ____________ | __________ | |||
| Total Liability & Capital | £156,659.23 | £114,163.91 | £42,495.32 | 37.2% | ||