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

Sales / Placements | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-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 | 3250 | 3250 | 3500 | 3500 | 3750 | 3750 | 4000 | 4000 | 4250 | 4250 | 4500 | 4500 | 46500 | Temporary placement fees Consultant 1
Permanent Placement fees Consultant 2 | 5000 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 35000 | Permanent Placement fees Consultant 2
Temporary placement fees Consultant 2 | 1750 | 1750 | 2000 | 2000 | 2250 | 2250 | 2500 | 2500 | 2750 | 2750 | 3000 | 3000 | 28500 | Temporary placement fees Consultant 2
Grant & funding income | 2500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 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 | 17500 | 10000 | 10500 | 10500 | 11000 | 11000 | 16500 | 16500 | 17000 | 17000 | 17500 | 17500 | 172500 | 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 | 825 | 825 | 850 | 850 | 875 | 875 | 900 | 900 | 925 | 925 | 950 | 950 | 10650 | Commission consultant 1
Employers NI Contributions Consultant 1 | 340.224 | 340.224 | 343.424 | 343.424 | 346.624 | 346.624 | 349.824 | 349.824 | 353.024 | 353.024 | 356.224 | 356.224 | 4178.688 | Employers NI Contributions Consultant 1
Salary Consultant 2 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 1833 | 800 | Salary Consultant 2
Commission consultant 2 | 675 | 175 | 200 | 200 | 225 | 225 | 750 | 750 | 775 | 775 | 800 | 800 | 0 | Commission consultant 2
Employers NI Contributions Consultant 2 | 321.024 | 257.024 | 260.224 | 260.224 | 263.424 | 263.424 | 330.624 | 330.624 | 333.824 | 333.824 | 337.024 | 337.024 | 3628.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 | 10082.248 | 7618.248000000001 | 7574.648 | 7674.648 | 7631.048 | 7731.048 | 8251.448 | 8351.448 | 8307.848 | 8407.848 | 8364.248 | 8464.248 | 70912.976 | Total Cost of Sales
Net Cash Flow | 7417.752 | 2381.751999999999 | 2925.352 | 2825.352 | 3368.952 | 3268.952 | 8248.552 | 8148.552 | 8692.152 | 8592.152 | 9135.752 | 9035.752 |  | Net Cash Flow
Initial | 41211.58 | 48629.332 | 51011.084 | 53936.436 | 56761.788 | 60130.74 | 63399.692 | 71648.24399999999 | 79796.79599999999 | 88488.94799999999 | 97081.09999999999 | 106216.852 |  | Initial
Final | 48629.332 | 51011.084 | 53936.436 | 56761.788 | 60130.74 | 63399.692 | 71648.24399999999 | 79796.79599999999 | 88488.94799999999 | 97081.09999999999 | 106216.852 | 115252.604 |  | Final
Sales / Placements | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | Actual Totals
MPT Recruitment Limited | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget