Notes to the Grant for R&D Financial Appendices You must fully complete these financial appendices as part of your Grant for R&D application. We are only able to accept applications which include all of the required information. We recommend that you fill in the spreadsheets off-line as some of the formulas may not work online. When you print off these tables to send in with your application please ensure they a size which is easy to read. Gantt Chart -This spreadsheet is not "interactive" and will not produce a Gantt chart for you in the way that Microsoft Project will. However this spreadsheet shows you how a Gantt chart can be produced using Excel, and it is possible to manipulate the example to make it fit your own purposes. Project Costs -The project cost figures on this sheet will fill in automatically when you complete the Project Cashflow. If you wish to complete it manually then remove the protection via Tools, Protection, Unprotect worksheet. This worksheet also includes a table detailing the staff working on the project and the overheads apportioned to the project. This should be filled in manually. Project Cash Flow -This spreadsheet should show the cashflow relating to the project expenditure. The totals will be calculated automatically and these will copy across into the Project Costs. This should be completed for the project duration. Please bear in mind the limits on project duration for the type of project you are applying for: Micro projects -up to 12 Months Research projects -6-18 months Development projects -6-36 months Exceptional Development projects -6-36 Business Cashflow -This cashflow is for the business as a whole and should include the expenditure on your project and its effect on your business both during and after its completion. For Micro and Development projects a minimum 2 year business cashflow should be provided; For Research projects a minimum 1 year business cashflow should be provided; For Exceptional Development projects a minimum 3 year business cashflow should be provided.Gantt Chart EXAMPLE TASK NAME Feb Mar Apr May Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 1 Project 2 Soucing capital equipment 3 Soucing components 4 Materials selection 5 Design power unit 6 Assemble power unit 7 PCB design 8 PCB manufacture 9 Consultancy 10 IPR 11 Systems integration 12 Testing 1 13 Testing 2 14 Comparison of results 15 Build 2nd prototype 16 Cicuitry tests 17 Software integration 18 Testing 3 19 Design consultancy 20 EMC tests 20 Market assessment 20 Product launch 20 Project management Q2 2003 Q3 2003 Q4 2003 Q1 2004 Q2 2004 Jun JulProject Cost Breakdown Company Name Expenditure (£) Year 1 Year 2 Year 3 Total (£) Pay of staff (employees only excl. NIC) -complete pay of staff table below 0 0 0 0 Overheads -complete overheads table below 0 0 0 0 Materials used during the project 0 0 0 0 Consultancy fees 0 0 0 0 Sub-contract charges 0 0 0 0 Fees for trials & testing 0 0 0 0 Other external costs (you must provide details on a separate sheet) 0 0 0 0 Preparation of technical manuals 0 0 0 0 Intellectual property costs 0 0 0 0 Capital equipment & tooling 0 0 0 0 Market assessment 0 0 0 0 Training 0 0 0 0 Other (you must provide details on a separate sheet) 0 0 0 0 Gross Total Project Costs 0 0 0 0 Less estimated residual value of capital equipment, tooling and scrap material 0 0 0 0 Net Total Project Costs 0 0 0 0 Pay of Staff detail* Name (or post to be filled) Expected Salary or drawings* at the time of the project Daily Rate (£) Number of Days to be Worked on Project Total cost (daily rate x number of days) 0 Overhead detail *Overheads should relate to the project only and should be apportioned from the business overheads, please show your working under 'notes'. Overhead (e.g. rent, rates, NIC, pension contributions etc) Yearly rate for the business (£) % to be appportioned soley to this project Overheads for the project* (£) Notes TOTAL 0 * Only include staff employed directly by the company and directly engaged on the project. (Directors' fees charged as consultants to their own company are not eligible for grant support.) This should tally with 'Pay of Staff' in the projcet costs table above This should tally with 'Overheads' in the project costs table aboveProject Cashflow Company Name Year 1 of Project Month 1 2 3 4 5 6 7 8 9 10 11 12 Total Yr 1 Total All Yrs Expenditure (£) Pay of staff (not external consultants) 0 0 Overheads 0 0 Materials used during the project 0 0 Consultancy fees 0 0 Sub-contract charges 0 0 Fees for trials & testing 0 0 Other external costs 0 0 Preparation of technical manuals 0 0 Intellectual property costs 0 0 Capital equipment & tooling 0 0 Market assessment 0 0 Training 0 0 Other 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Less Residual Value 0 0 Net Project Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 0 R&D Grant 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Balance c/f 0 0 0 0 0 0 0 0 0 0 0 0Year 2 of Project Month 13 14 15 16 17 18 19 20 21 22 23 24 Total Yr2 Expenditure (£) Pay of staff (not external consultants) 0 0 0 0 0 0 0 0 0 0 0 0 0 Overheads 0 0 0 0 0 0 0 0 0 0 0 0 0 Materials used during the project 0 0 0 0 0 0 0 0 0 0 0 0 0 Consultancy fees 0 0 0 0 0 0 0 0 0 0 0 0 0 Sub-contract charges 0 0 0 0 0 0 0 0 0 0 0 0 0 Fees for trials & testing 0 0 0 0 0 0 0 0 0 0 0 0 0 Other external costs 0 0 0 0 0 0 0 0 0 0 0 0 0 Preparation of technical manuals 0 0 0 0 0 0 0 0 0 0 0 0 0 Intellectual property costs 0 0 0 0 0 0 0 0 0 0 0 0 0 Capital equipment & tooling 0 0 0 0 0 0 0 0 0 0 0 0 0 Market assessment 0 0 0 0 0 0 0 0 0 0 0 0 0 Training 0 0 0 0 0 0 0 0 0 0 0 0 0 Other 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 Less Residual Value 0 Net Project Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 R&D Grant 0 0 0 0 0 0 0 0 0 0 0 0 0 Balance c/f 0 0 0 0 0 0 0 0 0 0 0 0Year 3 of Project Month 25 26 27 28 29 30 31 32 33 34 35 36 Total Yr 3 Expenditure (£) Pay of staff (not external consultants) 0 0 0 0 0 0 0 0 0 0 0 0 0 Overheads 0 0 0 0 0 0 0 0 0 0 0 0 0 Materials used during the project 0 0 0 0 0 0 0 0 0 0 0 0 0 Consultancy fees 0 0 0 0 0 0 0 0 0 0 0 0 0 Sub-contract charges 0 0 0 0 0 0 0 0 0 0 0 0 0 Fees for trials & testing 0 0 0 0 0 0 0 0 0 0 0 0 0 Other external costs 0 0 0 0 0 0 0 0 0 0 0 0 0 Preparation of technical manuals 0 0 0 0 0 0 0 0 0 0 0 0 0 Intellectual property costs 0 0 0 0 0 0 0 0 0 0 0 0 0 Capital equipment & tooling 0 0 0 0 0 0 0 0 0 0 0 0 0 Market assessment 0 0 0 0 0 0 0 0 0 0 0 0 0 Training 0 0 0 0 0 0 0 0 0 0 0 0 0 Other 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 Less Residual Value 0 Net Project Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 R&D Grant 0 0 0 0 0 0 0 0 0 0 0 0 0 Balance c/f 0 0 0 0 0 0 0 0 0 0 0 0Business Cashflow PLEASE NOTE: For Micro and Development projects a minimum 2 year business cashflow should be provided; For Research projects a minimum 1 year business cashflow should be provided; For Exceptional Development projects a minimum 3 year business cashflow should be provided. Company Name Year 1 of Project Month 1 2 3 4 5 6 7 8 9 10 11 12 Total Yr 1 Total All Years Income (£) Equity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Loans 0 0 0 0 0 0 0 0 0 0 0 0 0 0 R&D Grant 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other grants 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales from Project 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Income 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Expenditure (£) Pay of Staff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Rent & Rates 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Tax & NHI 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Heating & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Materials 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Property Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Repairs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Telephone 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Postage & Stationery 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Travel & Vehicle Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Audit & Accountancy Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Advertising 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Charges: Bank 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Charges: Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Capital Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Loan/HP, Lease Payments 0 0 0 0 0 0 0 0 0 0 0 0 0 0 VAT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Professional Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Surplus (Deficit) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Opening Balance (b/f from previous month) 0 0 0 0 0 0 0 0 0 0 0 0 Closing Balance (c/f to next month) 0 0 0 0 0 0 0 0 0 0 0 0Year 2 of Project Month 13 14 15 16 17 18 19 20 21 22 23 24 Total Year 2 Income (£) Equity 0 0 0 0 0 0 0 0 0 0 0 0 0 Loans 0 0 0 0 0 0 0 0 0 0 0 0 0 R&D Grant 0 0 0 0 0 0 0 0 0 0 0 0 0 Other grants 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales from Project 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Income 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 Expenditure (£) Pay of Staff 0 0 0 0 0 0 0 0 0 0 0 0 0 Rent & Rates 0 0 0 0 0 0 0 0 0 0 0 0 0 Tax & NHI 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 Heating & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 0 Materials 0 0 0 0 0 0 0 0 0 0 0 0 0 Property Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0 Repairs 0 0 0 0 0 0 0 0 0 0 0 0 0 Telephone 0 0 0 0 0 0 0 0 0 0 0 0 0 Postage & Stationery 0 0 0 0 0 0 0 0 0 0 0 0 0 Travel & Vehicle Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 Audit & Accountancy Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 Advertising 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Charges: Bank 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Charges: Other 0 0 0 0 0 0 0 0 0 0 0 0 0 Capital Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 Loan/HP, Lease Payments 0 0 0 0 0 0 0 0 0 0 0 0 0 VAT 0 0 0 0 0 0 0 0 0 0 0 0 0 Professional Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 Surplus (Deficit) 0 0 0 0 0 0 0 0 0 0 0 0 Opening Balance (b/f from previous month) 0 0 0 0 0 0 0 0 0 0 0 0 Closing Balance (c/f to next month) 0 0 0 0 0 0 0 0 0 0 0 0Year 3 of Project Month 25 26 27 28 29 30 31 32 33 34 35 36 Total Year 3 Income (£) Equity 0 0 0 0 0 0 0 0 0 0 0 0 0 Loans 0 0 0 0 0 0 0 0 0 0 0 0 0 R&D Grant 0 0 0 0 0 0 0 0 0 0 0 0 0 Other grants 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales from Project 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Income 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 Expenditure (£) Pay of Staff 0 0 0 0 0 0 0 0 0 0 0 0 0 Rent & Rates 0 0 0 0 0 0 0 0 0 0 0 0 0 Tax & NHI 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 Heating & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 0 Materials 0 0 0 0 0 0 0 0 0 0 0 0 0 Property Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0 Repairs 0 0 0 0 0 0 0 0 0 0 0 0 0 Telephone 0 0 0 0 0 0 0 0 0 0 0 0 0 Postage & Stationery 0 0 0 0 0 0 0 0 0 0 0 0 0 Travel & Vehicle Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 Audit & Accountancy Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 Advertising 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Charges: Bank 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Charges: Other 0 0 0 0 0 0 0 0 0 0 0 0 0 Capital Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 Loan/HP, Lease Payments 0 0 0 0 0 0 0 0 0 0 0 0 0 VAT 0 0 0 0 0 0 0 0 0 0 0 0 0 Professional Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Expenditure 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 Surplus (Deficit) 0 0 0 0 0 0 0 0 0 0 0 0 Opening Balance (b/f from previous month) 0 0 0 0 0 0 0 0 0 0 0 0 Closing Balance (c/f to next month) 0 0 0 0 0 0 0 0 0 0 0 0