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

Sales / Placements | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-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 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 60000 | Permanent Placement fees Consultant 1
Temporary placement fees Consultant 1 | 1750 | 2000 | 2000 | 2250 | 2250 | 2500 | 2500 | 2750 | 2750 | 3000 | 3000 | 3250 | 30000 | Temporary placement fees Consultant 1
Permanent Placement fees Consultant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 30000 | Permanent Placement fees Consultant 2
Temporary placement fees Consultant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 1000 | 1000 | 1500 | 1500 | 1750 | 7250 | Temporary placement fees Consultant 2
Grant & funding income | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | Grant & funding income
Bank & other loans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank & other loans
MPT Capital | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 11750 | 7000 | 7000 | 7250 | 7250 | 7500 | 13000 | 13750 | 13750 | 14500 | 14500 | 15000 | 132250 | 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 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 6000 | 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 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 4200 | 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 | 675 | 700 | 700 | 725 | 725 | 750 | 750 | 775 | 775 | 800 | 800 | 825 | 9000 | Commission consultant 1
Employers NI Contributions Consultant 1 | 321.024 | 324.224 | 324.224 | 327.424 | 327.424 | 330.624 | 330.624 | 333.824 | 333.824 | 337.024 | 337.024 | 340.224 | 3967.488 | Employers NI Contributions Consultant 1
Salary Consultant 2 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 675 | Salary Consultant 2
Commission consultant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 550 | 600 | 600 | 650 | 650 | 675 | 0 | Commission consultant 2
Employers NI Contributions Consultant 2 | 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 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 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1200 | 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 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1200 | 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 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1200 | Postage
Repairs & Maintenance | 0 | 100 | 0 | 100 | 0 | 100 | 0 | 100 | 0 | 100 | 0 | 100 | 600 | Repairs & Maintenance
Stationary/Printing costs | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 480 | Stationary/Printing costs
Mobile Telephones | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 780 | Mobile Telephones
[NAME] calls / Line rental | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 3600 | [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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 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 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 900 | Entertainment
Other costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Other costs
Total Cost of Sales | 9151.648 | 7279.848 | 7179.848 | 7308.048 | 7208.048 | 7336.248 | 7856.648 | 8041.248000000001 | 7941.248000000001 | 8125.847999999999 | 8025.847999999999 | 8182.248000000001 | 68590.776 | Total Cost of Sales
Net Cash Flow | 2598.352000000001 | -279.848 | -179.848 | -58.04799999999977 | 41.95200000000023 | 163.7520000000004 | 5143.352 | 5708.751999999999 | 5808.751999999999 | 6374.152000000001 | 6474.152000000001 | 6817.751999999999 |  | Net Cash Flow
Initial | 2598.352000000001 | 5196.704000000002 | 4916.856000000002 | 4737.008000000002 | 4678.960000000002 | 4720.912000000002 | 4884.664000000002 | 10028.016 | 15736.768 | 21545.52 | 27919.67200000001 | 34393.82400000001 |  | Initial
Final | 5196.704000000002 | 4916.856000000002 | 4737.008000000002 | 4678.960000000002 | 4720.912000000002 | 4884.664000000002 | 10028.016 | 15736.768 | 21545.52 | 27919.67200000001 | 34393.82400000001 | 41211.57600000001 |  | Final
Sales / Placements | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | Actual Totals
MPT Recruitment Limited | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget