|
|
| | | | | 12 Month Business Budget |
| | | | | XYZ IT Consultancy Firm |
| | | | | 2012/2013 Budget |
| | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Total |
| Beginning cash Balance | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 300000 |
| Cash Inflows (Income): |
| Consulting services fees | £ 100,000.00 | £ 100,000.00 | £ 100,000.00 | £ 150,000.00 | £ 150,000.00 | £ 150,000.00 | £ 200,000.00 | £ 200,000.00 | £ 225,000.00 | £ 225,000.00 | £ 225,000.00 | £ 225,000.00 | £ 2,050,000.00 |
| Project Consulting | £ 150,000.00 | £ 150,000.00 | £ 150,000.00 | £ 200,000.00 | £ 200,000.00 | £ 200,000.00 | £ 300,000.00 | £ 300,000.00 | £ 300,000.00 | £ 500,000.00 | £ 500,000.00 | £ 500,000.00 | £ 3,450,000.00 |
| IT reports | £ 75,000.00 | £ 75,000.00 | £ 75,000.00 | £ 105,000.00 | £ 105,000.00 | £ 150,000.00 | £ 150,000.00 | £ 150,000.00 | £ 150,000.00 | £ 250,000.00 | £ 250,000.00 | £ 250,000.00 | £ 1,785,000.00 |
| Research Fees | £ 65,000.00 | £ 65,000.00 | £ 65,000.00 | £ 80,000.00 | £ 80,000.00 | £ 80,000.00 | £ 105,000.00 | £ 105,000.00 | £ 105,000.00 | £ 150,000.00 | £ 150,000.00 | £ 150,000.00 | £ 1,200,000.00 |
| Other | £ 5,000.00 | £ 5,000.00 | £ 5,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 20,000.00 | £ 20,000.00 | £ 20,000.00 | £ 25,000.00 | £ 25,000.00 | £ 25,000.00 | £ 195,000.00 |
| Total Cash Inflows | £ 395,000.00 | £ 395,000.00 | £ 395,000.00 | £ 550,000.00 | £ 550,000.00 | £ 595,000.00 | £ 775,000.00 | £ 775,000.00 | £ 800,000.00 | £ 1,150,000.00 | £ 1,150,000.00 | £ 1,150,000.00 | £ 8,680,000.00 |
| Cash outflows( Expenses) |
| Advertising | £ 2,000.00 | £ 2,000.00 | £ 2,000.00 | £ 5,000.00 | £ 5,000.00 | £ 5,000.00 | £ - 0 | £ - 0 | £ 8,000.00 | £ 8,000.00 | £ 8,000.00 | £ 8,000.00 | £ 53,000.00 |
| Health Insurance | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 1,500.00 | £ 18,000.00 |
| Wages and salaries | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 3,000.00 | £ 9,000.00 | £ 42,000.00 |
| Payroll taxes | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 900.00 | £ 4,200.00 |
| Telephone & Fax | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 1,800.00 |
| Travelling | £ 250.00 | £ 250.00 | £ 250.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 100.00 | £ 100.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 3,250.00 |
| Insurance | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 4,200.00 |
| Stationery | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 100.00 | £ 1,200.00 |
| Marketing | £ 300.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 400.00 | £ 400.00 | £ 400.00 | £ 400.00 | £ 400.00 | £ 4,250.00 |
| Bank service charges | £ 150.00 | £ 150.00 | £ 150.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 300.00 | £ 300.00 | £ 300.00 | £ 2,850.00 |
| Rent | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 500.00 | £ 6,000.00 |
| Security & alarm fees | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 250.00 | £ 3,000.00 |
| Pantry expense | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 150.00 | £ 1,800.00 |
| Taxes and Licenses | £ 2,500.00 | | | | | | | | | | | | £ 2,500.00 |
| Supplies | £ 300.00 | £ 300.00 | £ 300.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 350.00 | £ 400.00 | £ 400.00 | £ 250.00 | £ 400.00 | £ 350.00 | £ 4,100.00 |
| Dues and subscriptions | £ 300.00 |
| Professional fees | £ 350.00 |
| SubTotal | £ 12,450.00 | £ 9,300.00 | £ 9,300.00 | £ 12,500.00 | £ 12,550.00 | £ 12,550.00 | £ 7,350.00 | £ 7,450.00 | £ 15,700.00 | £ 15,600.00 | £ 15,750.00 | £ 22,300.00 | £ 152,150.00 |
| Other Cash outflows |
| Capital Purchases | £ 5,000.00 | | | | | | £ 5,000.00 | | | | | | £ 10,000.00 |
| Loan Principal | £ 300,000.00 | | | | | | | | | | | | £ 300,000.00 |
| Directors emoluments | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 15,000.00 | £ 50,000.00 | £ 215,000.00 |
| Other: | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 200.00 | £ 2,400.00 |
| Subtotal: | £ 320,200.00 | £ 15,200.00 | £ 15,200.00 | £ 15,200.00 | £ 15,200.00 | £ 15,200.00 | £ 20,200.00 | £ 15,200.00 | £ 15,200.00 | £ 15,200.00 | £ 15,200.00 | £ 50,200.00 | £ 527,400.00 |
| Total cash outflows | £ 332,650.00 | £ 24,500.00 | £ 24,500.00 | £ 27,700.00 | £ 27,750.00 | £ 27,750.00 | £ 27,550.00 | £ 22,650.00 | £ 30,900.00 | £ 30,800.00 | £ 30,950.00 | £ 72,500.00 | £ 679,550.00 |
| Ending cash balance | £ 62,350.00 | £ 370,500.00 | £ 370,500.00 | £ 522,300.00 | £ 522,250.00 | £ 567,250.00 | £ 747,450.00 | £ 752,350.00 | £ 769,100.00 | £ 1,119,200.00 | £ 1,119,050.00 | £ 1,077,500.00 | £ 8,000,450.00 |
| Notes |
| Bonuses are paid at the end of the year |
| Licences and taxes are paid at the beginning of the year |
| The loan principle is borrowed at the beginning of the year. |
| Capital purchases are done bi annually |
| Professional fees are paid at the beginning of the year. |
| Dues ans subscriptions are paid at the beginning of the year |
| The ending balance is the difference between the total inflows and total out flows. |
| The figures can change any time with the preparation of month end budget report versus the actual report. |
solil_
copy_of_copy_of_budget.xls
