Spreadsheet: 71122d1271852767-cell-sum-mpt-cash-flow-forecast-year-1
Sheet: 2010 & 2011

Sales / Placements | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | Actual Totals
MPT Recruitment Limited | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget
Permanent Placement fees Consultant 1 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 30000 | Permanent Placement fees Consultant 1
Temporary placement fees Consultant 1 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 1000 | 1000 | 1500 | 1500 | 1750 | 7250 | Temporary placement fees Consultant 1
Permanent Placement fees Consultant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Permanent Placement fees Consultant 2
Temporary placement fees Consultant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Temporary placement fees Consultant 2
Grant & funding income | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | Grant & funding income
Bank & other loans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank & other loans
MPT Capital | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | MPT Capital
Outside Capital | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Outside Capital
Other receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Other receipts
Total Sales | 15000 | 0 | 0 | 0 | 0 | 0 | 5500 | 6000 | 6000 | 6500 | 6500 | 6750 | 52250 | Total Sales
Cost of Sales |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost of Sales
Client refunds | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Client refunds
Bank loan repayments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank loan repayments
Bank loan insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank loan insurance
Overdraft charges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Overdraft charges
Payroll costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Payroll costs
Bank Charges | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 420 | Bank Charges
Rent & Rates | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Rent & Rates
Credit Control | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Credit Control
Professional Insurance | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 1500 | Professional Insurance
Publicity & Promotion | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 3000 | Publicity & Promotion
Petty cash taken | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 600 | Petty cash taken
Salary Consultant 1 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 21996 | Salary Consultant 1
Commission consultant 1 | 0 | 0 | 0 | 0 | 0 | 0 | 550 | 600 | 600 | 650 | 650 | 675 | 3725 | Commission consultant 1
Employers NI Contributions Consultant 1 | 234.624 | 234.624 | 234.624 | 234.624 | 234.624 | 234.624 | 305.024 | 311.424 | 311.424 | 317.824 | 317.824 | 321.024 | 3292.288 | Employers NI Contributions Consultant 1
Salary Consultant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Salary Consultant 2
Commission consultant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Commission consultant 2
Employers NI Contributions Consultant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Employers NI Contributions Consultant 2
Accountant fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Accountant fees
Legal fees | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | Legal fees
Heating & Lighting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Heating & Lighting
Vehicle Leasing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Vehicle Leasing
Vehicle Insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Vehicle Insurance
Vehicle Fuel | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 600 | Vehicle Fuel
Parking & Congestion charges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Parking & Congestion charges
Flights / Travel / Accomodation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Flights / Travel / Accomodation
Postage | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 600 | Postage
Repairs & Maintenance | 0 | 100 | 0 | 100 | 0 | 100 | 0 | 100 | 0 | 100 | 0 | 100 | 600 | Repairs & Maintenance
Stationary/Printing costs | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 350 | 50 | 50 | 50 | 50 | 690 | Stationary/Printing costs
Mobile Telephones | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 600 | Mobile Telephones
[NAME] calls / Line rental | 215 | 215 | 215 | 215 | 215 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 3175 | [NAME] calls / Line rental
Broadband Internet / Router | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 780 | Broadband Internet / Router
IT Hardware | 1000 | 0 | 0 | 0 | 0 | 1500 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | IT Hardware
IT Software | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 4200 | IT Software
Subscriptions / Books / Show tickets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Subscriptions / Books / Show tickets
Furniture & Fittings | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Furniture & Fittings
Signage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Signage
Entertainment | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 600 | Entertainment
Other costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Other costs
Total Cost of Sales | 5377.624 | 3477.624 | 3377.624 | 3477.624 | 3377.624 | 5062.624 | 4083.024 | 4569.424 | 4169.424 | 4325.824000000001 | 4225.824000000001 | 4354.023999999999 | 49878.288 | Total Cost of Sales
Net Cash Flow | 9622.376 | -3477.624 | -3377.624 | -3477.624 | -3377.624 | -5062.624 | 1416.976 | 1430.576 | 1830.576 | 2174.175999999999 | 2274.175999999999 | 2395.976000000001 |  | Net Cash Flow
Initial | 0 | 9622.376 | 6144.752 | 2767.128000000001 | 0 | -3377.624 | -8440.248 | -7023.271999999999 | -5592.695999999999 | -3762.119999999999 | -1587.944 | 686.232 |  | Initial
Final | 9622.376 | 6144.752 | 2767.128000000001 | 0 | -3377.624 | -8440.248 | -7023.271999999999 | -5592.695999999999 | -3762.119999999999 | -1587.944 | 686.232 | 3082.208000000001 |  | Final
Sales / Placements | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | Actual Totals
MPT Recruitment Limited | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget