VIEWS: 0 PAGES: 52 CATEGORY: Business POSTED ON: 1/7/2011
Blank Room Lease Agreement document sample
OUTPUTS NAME OF PROJECT Scheme summary Outdoor Number Buildings m2 spaces m2 Affordable homes 0 0 Community building 0 0 Office premises Meeting rooms 0 0 Shops 0 0 Workspaces 0 0 Multi-use games area 0 0 Sportsfield 0 0 Pavilion/changing rooms 0 Circulation 0 Homes for sale 0 0 TOTAL AREA 0 0 Cost £ Land 0 Building work #DIV/0! Fees #DIV/0! Fitting out costs #DIV/0! Other costs #DIV/0! TOTAL EXPENDITURE #DIV/0! Income Housing - equity sales 0 Housing - loans repaid from rent 0 Housing for sale 0 Workshop/shop loans repaid from rent Workshop sales 0 Loan on community building 0 Loan on meeting spaces 0 Loan on sports facilities 0 Other sources Parish Council 0 District authority 0 County authority 0 Devon CCD scheme 0 s106 0 Local Action Group (LEADER4) 0 CommunityBuilders 0 Lottery 0 Sport England 0 Charitable Trusts 0 Homes & Communities Agency 0 Local fundraising 0 Others 0 TOTAL INCOME 0 Development cash flow forecast Buy land 1-Apr-10 Planning granted 1-Jun-10 Start 1-Jan-11 Complete 1-Jan-12 Expenditure Pre- Jan-Jun '10 Jul-Dec '10 Jan-Jun '11 Jul-Dec '11 Jan-Jun '12 Jul-Dec '12 purchase £ £ £ £ £ £ £ Land 0 #DIV/0! 0 0 0 0 0 Building work #DIV/0! 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Fitting out costs 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! Fees and charges including VAT #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total income #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Income Sales 0 0 0 0 0 0 0 Loans 0 0 0 0 0 0 0 Grants #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Own funds 0 0 0 0 0 0 0 Total expenditure #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Net income #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Cumulative income #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Maximum development loan required: #DIV/0! (note may exceed number above if peak loan is not at end of a quarter) Revenue forecast Inflation 2.50% Wage/cost inflation 3.00% 2009/10 £ Staff salaries including NI/pension 0 Advertising/marketing 0 Equipment depreciation 0 Fire and alarm maintenance 0 Service charges 0 Rates 0 Water rates 0 Training 0 Heat, light power 0 Telephones 0 Postage 0 Printing and stationery 0 Recruitment 0 Insurance 0 Repairs and maintenance 0 Cleaning 0 Cleaning materials 0 Book-keeping and finance support 0 IT 0 Website 0 Refuse collection 0 Sportsfield maintenance 0 Miscellaneous 0 SUBTOTAL 0 Housing costs 0 Loan repayments 0 TOTAL 0 Income £ Housing income 0 Workshop rent 0 Use of community building 0 Office and shop rent 0 Meeting room lettings 0 Sportsfield, MUGA and pavilion 0 TOTAL 0 Surplus/deficit 0 Start up funding Year 1 Year 2 Year 3 Year 4 Year 5 £ £ £ £ £ Income 0 0 0 0 0 Expenditure 0 0 0 0 0 Surplus/deficit 0 0 0 0 0 Surplus/deficit 0 0 0 0 0 Brought forward 0 0 0 0 0 Grant required 0 Carried forward 0 0 0 0 0 Your scheme 1. What will it include? Summary Communi Office Meeting Work Circulation Homes Shops Pavilion TOTAL ty building premises rooms spaces m2 0 0 0 0 0 0 0 0 Affordable homes "1-bed 2-person" "2bed 3p" "2-bed 4p" "3bed 4p" "3bed 5/6p" "4bed 6p" "4bed 7/8p""5bed 8/10p" Shared equity sale 0 Submarket rent 0 TOTAL 0 0 0 0 0 0 0 0 0 For older people 0 Disabled 0 Community building Size Kitchen Size m2 100 150 200 250 300 350 400 450 500 Enter number 0 Default fee for weekday daytime 20 20 20 22 22 25 25 25 25 Default fee for weekday evening 25 30 30 35 35 40 40 45 45 Default fee for weekend daytime 25 30 30 35 35 40 40 45 45 Default fee for weekend evening 40 45 50 55 60 70 80 90 100 Fee for weekday daytime Income from 3 lettings/ day, 7 Fee for weekday evening a week, 52 weeks a year Fee for weekend daytime Fee for weekend evening TOTAL MAXIMUM, one letting per session 26260 29120 29640 33540 34060 39000 40040 43420 44460 Potential for subdivision 0 0 10% 20% 20% 25% 40% 50% 50% TOTAL MAXIMUM INCOME 0 0 0 0 0 0 0 0 0 Office premises Rent/m2 m2 Income 120 0 Income from 3 lettings/ day, 7 a week, 52 weeks a year Meeting rooms Size (m2) 5 10 15 25 40 65 100 Total area Number 0 Fee per 3 hours Income as % of maximum Default fee £12.00 £15.00 £20.00 £25.00 £30.00 £45.00 £60.00 Shops 25m2 50m2 100m2 Total m2 Rent Income Number 0 0 Workspaces 10m2 25m2 50m2 75m2 100m2 200m2 Total m2 Rent £/m2 Rent m2 Number 0 0 0 0 0 0 0 Sales m2 400m2 1-hour fee Hrs/week Income 0 Multi-use games area 0 Football Half-size Income Fee for Fee for 6,000m2 2,500m2 Total m2 full size half-size Weeks (assumed 39) Sportsfield 0 0 Default fee £50 £25 Pavilion/changing rooms 50m2 100m2 Total m2 0 No extra fees assumed Homes for sale "1-bed 2-person" "2bed 3p" "2-bed 4p" "3bed 4p" "3bed 5/6p" "4bed 6p" "4bed 7/8p""5bed 8/10p" Total m2 Number 0 0 Toilets, storage Total m2 0 0 Income from 3 lettings/ day, 7 days a week, 52 weeks a year £0 £0 Income from 3 lettings/ day, 7 days a week, 52 weeks a year £0 Income as % of maximum £0 Total rent 0 0 Sales £0 Operational Elements of a financial plan Project Capital budget budget develop- Sources Sources ment of Expen- Capital Start-up of Expen- Revenue budget income diture cash flow budget income diture cash flow Reserves Project idea Project outline Project development plan Business plan Project funding secured Capital work priced Complete: starting up Up and running You know what the project aims to do; where the funds might come from if it will involve capital spending; and how it would meet its costs once up and You have broadly worked out the numbers and can answer questions about how the project will work You have prepared a forecast based on evidence or professional advice You have figures which you are confident can be achieved Your financial plan is in operation: real costs replace estimates Project development budget Work needed to move project to Who could do the work? Likely costs Notes major grant application stage Project feasibility study Dependent on size of project and work necessary Building design brief Printing, volunteer expenses, hire of premises etc. Legal advice on legal structures for the project group General legal advice on the terms of the land purchase or agreements with funders etc Bid writing (for project development costs) Site feasibility study Measured survey of site Site investigations Planning drawings (to RIBA stage Around 2% (35% of 6%) of build D) and indicative costs cost but architects/building surveyors may well agree to get your site to planning stage for a fixed fee which is lower than this if they will have the opportunity to Planning application fees Business Plan Bid writing (for project) Legal fees for land search if buying/ leasing land Legal advice on the terms of the purchase or lease agreement Disabled access advice Environmental Impact Assessment Contact English Nature, Devon Wildlife Trust etc. Full set of drawings Full Bill of Quantities Stage 1 - to enable the project development funds to be raised £0 Stage 2 - to enable a business plan to be developed £0 Stage 3 - to secure the funds for the project itself (which may be dependent on securing planning £0 Total £0 Project development budget Work needed to move project to Who could do the work? Likely costs Notes major grant application stage Project feasibility study Building design brief Printing, volunteer expenses, hire of premises etc. Legal advice on legal structures for the project group General legal advice on the terms of the land purchase or agreements with funders etc Bid writing (for project development costs) Site feasibility study Measured survey of site Often around £1,000 (entered as Site investigations default) Planning drawings (to RIBA stage Usually a sum of around £270 per D) and indicative costs house (entered as default). Planning application fees Business Plan Bid writing (for project) Legal fees for land search if buying/ leasing land Legal advice on the terms of the purchase or lease agreement Disabled access advice Environmental Impact Assessment Contact English Nature, Devon Wildlife Trust etc. Full set of drawings Full Bill of Quantities Stage 1 - to enable the project development funds to be raised £0 Stage 2 - to enable a business plan to be developed £1,000 Stage 3 - to secure the funds for the project itself (which may be dependent on securing planning £0 Total £1,000 PROJECT NAME: INCOME 1 2 3 4 5 6 7 8 9 10 11 12 13 Management, Number Open insurance, of market maintenance, cyclical Mortgage bedrooms Number value Number and planned based Suggested and of each (OMV) Number of Equity of rented maintenance and void on this Type Size (m2) sizes (m2) persons type (£) part-equity % OMV share (£) homes cost per week (M&M): rent (£) M&M: Typical Rent £pw £pw A 55 55 1bed 2p 0 90,000 0 50% 45,000 0 85 0 B 65 65 2bed 3p 0 140,000 0 50% 70,000 0 97 0 C 72 72 2bed 4p 0 170,000 0 50% 85,000 0 105 0 D 77 77 3bed 4p 0 180,000 0 50% 90,000 0 115 0 E 92 92 3bed 5/6p 0 190,000 0 50% 95,000 0 130 0 F 98 98 4-bed 6p 0 210,000 0 50% 105,000 0 140 0 G 105 105 4-bed 7/8p 0 220,000 0 50% 110,000 0 155 0 H 112 112 5-bed 8/10p 0 240,000 0 50% 120,000 0 165 0 Subtotal 0 0 Sales: 0 0 Rental loan: 0 m2 0 Rental element 0.75% OK Part-equity sales 0 Loan on rental element: 0 Loan on rental element: 0 TOTAL INCOME 0 Annual increase in Rate Period payment Loan terms available EXPENDITURE £ INCOME 0 £ £ LAND 0 Estimate £/m2 (2- Agreed bed) price CONSTRUCTION 0 ON-COSTS 0 0 Surplus/deficit Per 0 equity Per rented share Additional income home home £ £ HCA grant 0 Source Other grant Surplus from sales Number 0 Income 0 Cost 0 0 % of build cost as sweat 0 Self-build option Extra supervision costs 0 Total additional income 0 Total cost 0 Total income 0 OVERALL SURPLUS/DEFICIT 0 PROJECT NAME: Details of cost Types of home TOTAL Number 0 Size m2 0 £ Land 0 Legals - acquisition and set-up 0 Legals - part-equity sales. HCA 0 Site investigation & survey 0 2-bed4p £/m2 Typical Build (from "quick" sheet) 1,200 0 Elderly/disabled adaptations 3,000 0 Disabled adaptations 7,000 0 Per home Infrastructure 7,000 0 Total scheme Exceptional costs 0 Architects fees 3-6% 0 QS fees 0-4% 0 Per home Planning 270 0 Building regs 0 Other fees and charges 0-2% 0 Employer's agent 1.5%-2.5% 0 RSL costs 0-3% 0 10 year guarantees 1,000 0 Finance fees 1.00% 0 CLT fee 1.50% 0 CLT contingency /dowry 2.00% 0 Per home Marketing/sale 0-500 0 VAT 0 Interest 7.00% 0 TOTAL COST 0 Grant 0 Total cost 0 Build £/m2 Types of home TOTAL 0 0 £ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m2 0 Total m2 Staff 0 General admin cost of centre Inflation 2.50% Year Wage/cost inflation Charge % 3.00% to NI/pension Job title services? Salary % full-time 0 0 0 0% 0 0% 0 0% 0 0% Subtotal 0.0 Basis for Notes Suggestion default calc Your estimate £ £ £ Advertising/marketing 1 see note 500 see note Equipment depreciation 0 cost/m2 Fire and alarm maintenance 1,200 lump sum Service charges 2 see note 0 see note Rates 0 cost/m2 Water rates 0 cost/person Training 0 cost/m2 Heat, light power 0 cost/m2 Telephones 0 cost/person Postage 3 see note 0 cost/person Printing and stationery 0 cost/person Recruitment 4 see note 400 lump sum Insurance 0 cost/m2 Repairs and maintenance 0 cost/m2 Cleaning 0 cost/m2 Cleaning materials 0 cost/m2 Book-keeping and finance support 133 % total IT 0 cost/person Website 700 lump sum Refuse collection 0 cost/m2 Sportsfield maintenance 0 cost/m2 Miscellaneous 19 % total SUBTOTAL Housing costs Loan repayments TOTAL Income Housing income Workshop rent Use of community building Office and shop rent Office service charges Meeting room lettings Sportsfield, MUGA and pavilion TOTAL Surplus/deficit Notes 1. The need for advertising and marketing depends very much on the project. If you are meeting the needs of a known group it coiuld be quite low - say £1,500 for producing an annual report and a leaflet to explain your aims: if you have rooms and office space to be let, or events to attract people to, £10,000 or so may be needed. 2. If you are part of a larger building there may be a service charge from your landlord. If you are the building owner but share it with others, you may need to prepare a building running cost budget and allocate it between your organisation and others. You would then need to re-introduce your share of costs here. 3. A substantial promotional budget may well also need a higher postage budget to pay for mailshots. Otherwise a cost of around £200 per person might suffice. 4. You will have a substantial recruitment cost in year 1: thereafter you may go several years without cost. You can either handle these costs when they arise or create a sinking fund. Recruitment via the press can cost £1,000-£3,000: recruitment via websites can be a lot cheaper and may be no more than a few hundred pounds. 1 2009/10 0.00% 0 0 0 0 0 0 0 Plus inflation £ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 eting the needs of a known in your aims: if you have d. u are the building owner e it between your mailshots. Otherwise a s without cost. You can s can cost £1,000-£3,000: nds. 1 2 3 4 April May June July Expenditure £ £ £ £ Salaries/NI/pension 0 M 0 0 0 0 Advertising/marketing 0 B 0 0 0 0 Equipment depreciation 0 AE 0 0 0 0 Fire and alarm maintenance 0 AE 0 0 0 0 Service charges 0 M 0 0 0 0 Rates 0 B 0 0 0 0 Water rates 0 B 0 0 0 0 Training 0 B 0 0 0 0 Heat, light power 0 M 0 0 0 0 Telephones 0 M 0 0 0 0 Postage 0 M 0 0 0 0 Printing and stationery 0 M 0 0 0 0 Recruitment 0 AS 0 0 0 0 Insurance 0 AS 0 0 0 0 Repairs and maintenance 0 M 0 0 0 0 Cleaning 0 M 0 0 0 0 Cleaning materials 0 M 0 0 0 0 Book-keeping and finance support 0 M 0 0 0 0 IT 0 AS 0 0 0 0 Website 0 M 0 0 0 0 Refuse collection 0 M 0 0 0 0 Sportsfield maintenance 0 M 0 0 0 0 Miscellaneous 0 M 0 0 0 0 SUBTOTAL 0 0 0 0 0 Housing costs 0 M 0 0 0 0 Loan repayments 0 B 0 0 0 0 TOTAL 0 0 0 0 0 Income Housing income 0 M 0 0 0 0 Workshop rent 0 M 0 0 0 0 Use of community building 0 M 0 0 0 0 Office and shop rent 0 M 0 0 0 0 Meeting room lettings 0 M 0 0 0 0 Sportsfield, MUGA and pavilion 0 M 0 0 0 0 TOTAL 0 0 0 0 0 Surplus/deficit 0 0 0 0 Brought forward 0 0 0 0 Carried forward 0 0 0 0 5 6 7 8 9 10 11 12 Aug Sep Oct Nov Dec Jan Feb Mar £ £ £ £ £ £ £ £ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Year 1 Year 2 Your view Suggested Your view Suggested Inflation 2.50% 0.00% 2.50% Items higher in year 1 120% 90% Items that continue 100% 100% Items that grow Full year 75% 90% Expenditure £ Salaries/NI/pension 0 100% 0 100% Advertising/marketing 0 120% 0 90% Equipment depreciation 0 100% 0 100% Fire and alarm maintenance 0 100% 0 100% Service charges 0 100% 0 100% Rates 0 100% 0 100% Water rates 0 100% 0 100% Training 0 120% 0 90% Heat, light power 0 100% 0 100% Telephones 0 75% 0 90% Postage 0 100% 0 100% Printing and stationery 0 100% 0 100% Recruitment 0 120% 0 90% Insurance 0 100% 0 100% Repairs and maintenance 0 75% 0 90% Cleaning 0 100% 0 100% Cleaning materials 0 100% 0 100% Book-keeping and finance support 0 75% 0 90% IT 0 100% 0 100% Website 0 100% 0 100% Refuse collection 0 100% 0 100% Sportsfield maintenance 0 100% 0 100% Miscellaneous 0 100% 0 100% SUBTOTAL 0 100% 0 100% Housing costs 0 75% 0 90% Loan repayments 0 100% 0 100% TOTAL 0 0 Income Housing income 0 100% 0 100% Workshop rent 0 100% 0 100% Use of community building 0 75% 0 90% Office and shop rent 0 100% 0 100% Meeting room lettings 0 75% 0 90% Sportsfield, MUGA and pavilion 0 75% 0 90% TOTAL 0 0 Deficit grant required 0 Surplus/deficit 0 0 Brought forward 0 0 Carried forward 0 0 Year 2 Year 3 Year 4 Year 5 Your view Suggested Your view Suggested Your view Suggested 2.50% 2.50% 2.50% 90% 100% 100% 100% 100% 100% 100% 100% 100% £ £ £ £ 0 100% 0 100% 0 100% 0 0 90% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 90% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 90% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 100% 0 100% 0 100% 0 0 0 0 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 100% 0 100% 0 100% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ITEM Offices, Communit meeting Homes y building rooms Shop Guide cost/m 1,700 1,100 900 2 or Proposed cost/m2 - new build cost Proposed cost/m2 - refurb Total m2 0 0 0 0 % New build 100% 100% 100% 100% Refurbishment 0% 0% 0% 0% Refurbishment (m2) 0 0 0 0 Land/property acquistion - if £ £ £ £ single sum 0 #DIV/0! #DIV/0! #DIV/0! Acquisition -if price for each element work Building Construction 0 0 0 0 Housing adapatations for 0 elderly/disabled Site investigation 1,000 1,000 #DIV/0! #DIV/0! #DIV/0! Site clearance/demolition 0 #DIV/0! #DIV/0! #DIV/0! Externals: access roads, service S connections, landscape 0 0 0 0 Exceptional costs to be shared across scheme: access road, renewable energy plant, planning #DIV/0! #DIV/0! #DIV/0! Exceptionals: related to each 0 element work subtotal Building 1,000 #DIV/0! #DIV/0! #DIV/0! Fees and expenses 6-14% total Architect 3-6% 0 #DIV/0! #DIV/0! #DIV/0! Building surveyor 10% 0 #DIV/0! #DIV/0! #DIV/0! Quantity surveyor 0-4% 0 #DIV/0! #DIV/0! #DIV/0! Employer's agent 1-2.5% 0 #DIV/0! #DIV/0! #DIV/0! Others: structural engineer; 0-2% mechanical and electrical engineer 0 #DIV/0! #DIV/0! #DIV/0! Sustainability and energy £1,000- assessment; wildlife assessment; £20,000 0 #DIV/0! #DIV/0! #DIV/0! Fees subtotal archaeology etc. #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! Planning fee 0 0 #DIV/0! #DIV/0! #DIV/0! Building control fee 0.50% 0 #DIV/0! #DIV/0! #DIV/0! Equipment Kitchen fittings £500/m2 0 Furniture: ctty bldg £200/m2 0 Furniture: meeting rooms £100/m2 0 Shop fitting £400/m2 0 shops Play/sports equipment #DIV/0! #DIV/0! #DIV/0! Other FALSE FALSE FALSE FALSE 0 0 0 0 Equipment subtotal 0 0 #DIV/0! #DIV/0! #DIV/0! Legal fees (acquisition) £2,000- £5,000 0 #DIV/0! #DIV/0! #DIV/0! Other legal fees (agreements, 0 #DIV/0! #DIV/0! #DIV/0! External project management fees 2.50% 0 #DIV/0! #DIV/0! #DIV/0! Own costs 1.50% 0 #DIV/0! #DIV/0! #DIV/0! Guarantees (homes for sale or £1,000/hom 0 0 0 0 part-sale) Marketing e £100- 0 #DIV/0! #DIV/0! #DIV/0! Finance fees £5,000 1% 0 #DIV/0! #DIV/0! #DIV/0! Interest 5%-7.5% 0 #DIV/0! #DIV/0! #DIV/0! VAT on fees and costs 0 #DIV/0! #DIV/0! #DIV/0! VAT on building costs 0 #DIV/0! #DIV/0! #DIV/0! Contingency 1.50% #DIV/0! #DIV/0! #DIV/0! Dowry to create initial reserve 40% 0 #DIV/0! #DIV/0! #DIV/0! Other running cost #DIV/0! #DIV/0! #DIV/0! #DIV/0! TOTAL #DIV/0! #DIV/0! #DIV/0! #DIV/0! Income Housing - equity sales Housing - loans repaid from rent Housing for sale Workshop/shop loans repaid from Workshop sales Office loans repaid from rent 90% Loan on community building repaid 20% Loan on meeting spaces repaid 20% Loan on sports facilities 20% Other sources Parish Council District authority County authority Devon CCD scheme s106 Local Action Group (LEADER4) CommunityBuilders Lottery Sport England Charitable Trusts Homes & Communities Agency 0 Sweat equity Local fundraising Other income - enter sources FUNDING GAP #DIV/0! #DIV/0! Work- Sportsfiel spaces MUGA d Pavilion TOTAL 800 200,000 250,000 1,400 0 0 0 100% 100% 100% 100% 0% 0% 0% 0% 0% 0 0 0 0 0 £ £ £ £ £ #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! FALSE FALSE FALSE FALSE 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 Total non- 0 housing 0 0 0 Loans x 4/6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ASSUMPTIONS Your entry Dates Buy land 1.4.10 Planning granted 1.6.10 Start 1.1.11 Complete 1.1.12 1.1.12 Month Phase Pre-purchase 1.1.10 1.2.10 1.3.10 Expenditure £ £ £ £ Acquisition #DIV/0! 0 0 0 Build cost #DIV/0! 0 0 Site investigation #DIV/0! #DIV/0! Legal fees #DIV/0! 0 0 0 #DIV/0! Design fees #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Project manager's fee #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Other costs and fees #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Finance fee #DIV/0! 0 0 0 #DIV/0! Marketing #DIV/0! 0 0 0 Fit out costs #DIV/0! 0 0 0 Interest #DIV/0! 0 0 0 Own costs #DIV/0! 0 0 0 Dowry #DIV/0! 0 0 0 VAT #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! TOTAL EXPENDITURE #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Income Housing - equity sales 0 0 0 0 Housing for sale 0 0 0 0 Workshop sales 0 0 0 0 Housing - loans repaid from rent 0 0 0 0 Workshop/shop loans repaid from rent 0 0 0 0 Loan on community building repaid from income 0 0 0 0 Loan on meeting spaces repaid from income 0 0 0 0 Loan on sports facilities 0 0 0 0 Parish Council 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! District authority 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! County authority 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Devon CCD scheme 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! s106 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Local Action Group (LEADER4) 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! CommunityBuilders 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Lottery 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Sport England 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Charitable Trusts 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Homes & Communities Agency 0 0 0 0 0 Local fundraising 0 0 Other sources 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! TOTAL INCOME 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Net #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Loan b/f 0 #DIV/0! #DIV/0! #DIV/0! New loan #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total loan #DIV/0! #DIV/0! #DIV/0! #DIV/0! Interest 6.50% #DIV/0! #DIV/0! #DIV/0! Assumed casdh flow on site Month 0 1 2 3 4 5 Build - 12 months 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 2.0% 5.0% 8.0% 9.0% 10.5% Month 0 1 2 3 4 5 Fit out 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! % 40.0% 40.0% 20.0% Month 0 1 2 3 4 5 Housing - equity sales 0 0 0 0 0 0 Month 0 1 2 3 4 5 Housing for sale 0 0 0 0 0 0 Month 0 1 2 3 4 5 Workshop sales 0 0 0 0 0 0 1.4.10 1.5.10 1.6.10 1.7.10 1.8.10 1.9.10 1.10.10 1.11.10 1.12.10 1.1.11 £ £ £ £ £ £ £ £ £ £ #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 6 7 8 9 10 11 12 13 14 15 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 11.5% 11.5% 11.0% 10.0% 9.0% 7.0% 4.0% 0.0% 0.0% 0.0% 6 7 8 9 10 11 12 13 14 15 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 6 7 8 9 10 11 12 13 14 15 0 0 0 0 0 0 0 0 0 0 6 7 8 9 10 11 12 13 14 15 0 0 0 0 0 0 0 0 0 0 6 7 8 9 10 11 12 13 14 15 0 0 0 0 0 0 0 0 0 0 1.2.11 1.3.11 1.4.11 1.5.11 1.6.11 1.7.11 1.8.11 1.9.11 1.10.11 1.11.11 £ £ 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 16 17 18 19 20 21 22 23 24 25 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.0% 0.0% 1.5% 0 0 0 0 0 0 0 16 17 18 19 20 21 22 23 24 25 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 16 17 18 19 20 21 22 23 24 25 0 0 0 0 0 0 0 0 0 0 16 17 18 19 20 21 22 23 24 25 0 0 0 0 0 0 0 0 0 0 16 17 18 19 20 21 22 23 24 25 0 0 0 0 0 0 0 0 0 0 1.12.11 1.1.12 1.2.12 1.3.12 1.4.12 1.5.12 1.6.12 1.7.12 1.8.12 1.9.12 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 #DIV/0! 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 26 27 28 29 30 31 32 33 34 35 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 26 27 28 29 30 31 32 33 34 35 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 26 27 28 29 30 31 32 33 34 35 0 0 0 0 0 0 0 0 0 0 26 27 28 29 30 31 32 33 34 35 0 0 0 0 0 0 0 0 0 0 26 27 28 29 30 31 32 33 34 35 0 0 0 0 0 0 0 0 0 0 2.10.12 2.11.12 3.12.12 3.1.13 3.2.13 TOTAL check £ £ 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 36 37 38 39 40 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 100.0% 36 37 38 39 40 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 36 37 38 39 40 0 0 0 0 0 36 37 38 39 40 0 0 0 0 0 36 37 38 39 40 0 0 0 0 0 0 13 15 16 Full cost recovery spreadsheet Enter data in unshaded cells only. Do not alter shaded cells. Refer to the guidance notes for assistance with each step. Step 1: Information about your project 1.1 Funding year 2009 e.g. 2007/2008, 2007 Project duration If the project will run for the 1.2 (weeks) in the funding 39 whole of the funding year, year enter 52 or leave blank Percentage of the 1.3 75% funding year Step 2: Enter your project's direct costs Revenue Capital Costs Costs List cost descriptions and amounts below £ £ Various 50,000 3,000 Total direct project costs 50,000 3,000 Step 3: Describe how your organisation's overheads are to be shared Overhead type Overhead Overhead 1 type 2 type 3 Describe the type of overhead, for example, Premises, 3.1 Type of overhead administration, Management Finance stationery, premises, management audit etc and support Describe how each type How the overheads are will be shared, for Number of 3.2 Number of staff Floor area to be shared example number of staff staff, floor area occupied Step 4: Share the overheads Enter projects' shares below: List Projects below: Number of staff Number of Floor area staff 4.1 Your project 2.00 2.00 100.00 4.2 Other projects: Project 2 0.50 0.50 50.00 Project 3 1.00 1.00 100.00 4.3 Overheads Management Finance Totals 3.50 3.50 250.00 Increase in activity due to your project 133% 133% 67% Percentage due to your project 57% 57% 40% Step 5: Enter your organisation's overheads Overhead type Overhead Overhead 1 type 2 type 3 List overheads and amounts £ £ £ Management 25,000 Finance 20,000 Premises etc 21,000 Totals 25,000 20,000 21,000 Step 6: Full costs of your project These are the full costs of your project £ £ Direct costs Revenue costs 50,000 Capital costs 3,000 Total direct project costs 53,000 57.1% 10,714 The project's share of overheads The project's share of 57.1% 8,571 overheads 40.0% 6,300 Total share of the overheads 25,586 Full project costs 78,586 Salary spreadsheet Enter National Insurance (NI) Rates Secondary Earnings threshold (£ per week) 104.52 This is the rate above which employers must pay employers' This is the rate of employers' Employers' 12.80% NI on rate earnings above the threshold Enter post Calculated amounts Enter amounts and rates below description below Weeks employed Employer Employers' Post hours in project Pension National Employers' Total cost Pay Rate per week period Rate Gross Pay Insurance Pension of post Post £/hour hours/week weeks % £ £ £ £ #N/A #N/A #N/A 52.00 12.20% #N/A #N/A #N/A #N/A #N/A #N/A #N/A 52.00 12.20% #N/A #N/A #N/A #N/A #N/A #N/A #N/A 52.00 12.20% #N/A #N/A #N/A #N/A - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total staff costs #N/A ALLOCATED TO TOTAL Old School Training Exhibitions COSTS £ £ £ £ Salaries 50,000 2,000 20,000 8,000 NI 5,460 218 2,184 874 Employer's pension contrib 3,500 140 1,400 560 Advertising/marketing 2,000 80 800 320 Equipment depreciation 2,000 0 1,000 500 Office costs 4,000 160 1,600 640 Training 1,000 40 400 160 Recruitment 500 20 200 80 Insurance 3,900 1,500 500 1,000 Book-keeping and finance support 6,000 240 2,400 960 IT 2,000 80 800 320 Website 1,000 40 400 160 Miscellaneous 1,000 40 400 160 Loan repayments 1,860 1,000 500 360 TOTAL 84,220 5,558 32,584 14,094 Re-allocate central costs 1,638 9,604 4,154 TOTAL 84,220 7,197 42,188 18,248 INCOME Rent 5,544 5,544 Service charge fee 2,033 2,033 Fees 22,000 21,000 Revenue grants 57,500 43,500 TOTAL 87,077 7,577 43,500 21,000 Net income 2,857 380 1,312 2,752 LOCATED TO Events Project X Central cost £ £ £ check 2,000 1,000 17,000 0 218 109 1,856 0 140 70 1,190 0 80 40 680 0 0 0 500 0 160 80 1,360 0 40 20 340 0 20 10 170 0 500 0 400 0 240 120 2,040 0 80 40 680 0 40 20 340 0 40 20 340 0 0 0 0 0 3,558 1,529 26,896 84,220 1,049 451 16,896 16,896 4,607 1,980 10,000 84,220 1,000 2,000 2,000 10,000 3,000 2,000 10,000 -1,607 20 0