financial data sheet r d fund large projects

Financial Data Sheet

Instructions

1to calculate standard financial ratios. It is also employed to compute an economic cost benefit ratio.

2 The spreadsheet is password protected

3the financial model and financial ratios.

4 All monetary figures should be entered in thousands of Euro (€000's).

5

6whether audited accounts are available. New Start-Ups should use 'Current Year' (Base Year+1) for first year of trading. e.g. When completing the FDS in 2014 with a December year-end should select 31/12/2013 as base year.However, if at least 10 months of management accounts are available and there is a reasonable expectation

e.g. When completing the FDS in October 2014 with a December year-end, 31/12/2014 should be selected as the base year.

7 Please ensure that the totals of the Balance Sheet are balanced i.e. that the Net Assets in each year equal the total of the 'Financed By' section.

8 Additional clarification for each field is available by placing the mouse cursor over all cells with a red triangle located in the upper right corner

9 The FDS financial model is based on the assumption that short term funding is fully utilised i.e. invoicing discounting and overdraft facilities are drawn down in full.

Colour Key

White cells represent areas available for Company input.

Yellow shading represents automatically calculated formulae [password protected].

Blue shading represents cells requiring input from Enterprise Ireland staff.

The Financial Data Sheet (FDS) is used by Enterprise Ireland to generate a standard financial model and

Please do not insert additional rows or columns nor delete existing ones. Doing so may distort the results of

Please fill in all applicable cells on Company Input Sheet 1 & 2, leaving non-relevant cells empty. Company Input Sheet 1 contains historic and projected financial information, including P&L and Balance Sheets. Company Input Sheet 2 contains a pro-forma monthly cash flow for the next 12 months A monthly cashflow is required; however, it is not necessary to submit it in this format, as alternative formats will be accepted. Company Input Sheet 3 must be completed where the company is applying for employment grants

The Base year is normally selected as the latest accounting period which has elapsed, regardless of

that the end of year projections will be met, the current financial year is the base year.

Last Update 16-May-14Version 11.0

Company Input Sheet 1 document.xlsx


Company NameSingle EntityPlease note Current Year date is greater than 10 months, it is reasonable to expect the company to meet its end of year projections - current year should be used as the base year in this case. Please Refer to instruction 6

Information required prior to completing Profit & Loss and Balance Sheet sectionsBase Year-2 Base Year-1 Base Year Current Year Base Year+2 Base Year+3

Year End 31/12/11 31/12/12 31/12/13 31/12/14 31/12/15 31/12/16No. of Global Employees @ y/e (incl Irish employment)No. of Irish Based Employees @ y/eNo. of Global R&D Employees @y/eNo. of Irish Based R&D Employees @ y/e

VAT / PAYE / PRSI paid / (Received) in yearBank Overdraft (Facility Limit for Projected Years)Invoice discounting (Projected Year End Balance)Site/Buildings PurchaseSite/Buildings ModificationsNew Machinery / other CapexIntangible asset (Excl Capitalised R&D)Promoters' Equity Investment / (Divestment)Other Equity Investment / (Divestment)Dividends Paid to EIOther Dividends Paid

Profit & LossYear End 31/12/11 31/12/12 31/12/13 31/12/14 31/12/15 31/12/16

Account Status Audited Audited Management Projected Projected ProjectedSales €000's €000's €000's €000's €000's €000's

Own Product / Service Produced in Ireland & ExportedOwn Product / Service Produced Abroad & sold AbroadOwn Product / Service Produced & Sold in IrelandDistribution Sales of Other Co's Product

Total Sales 0 0 0 0 0 0

Direct LabourPurchasesOther Cost of Goods Sold

Cost of Sales 0 0 0 0 0 0

Gross Profit/(Loss) 0 0 0 0 0 0

Selling, General & Admin ExpensesIndirect Labour (excluding R&D Salaries)

R&D SalariesOther R&D expenditureR&D Expenditure 0 0 0 0 0 0

Other Operating Expenses/(Gains)

Operating Expenditure 0 0 0 0 0 0

Operating Profit/(Loss) - EBITDA 0 0 0 0 0 0

Interest PayableInterest / Dividends (Receivable)DepreciationAmortisationGrant Amortisation (This application only) 0 0 0Remitted Profits to Ireland From Foreign SubsidiaryNon-Operating Expenses/(Gains)

Profit/(Loss) before Tax 0 0 0 0 0 0

Tax

Net Profit/(Loss) 0 0 0 0 0 0

Dividends

Profit Retained for the Year 0 0 0 0 0 0

Balance SheetYear End 31/12/11 31/12/12 31/12/13 31/12/14 31/12/15 31/12/16

€000's €000's €000's €000's €000's €000's

Fixed Assets Intangible 0 0 0 Tangible Fixed Assets 0 0 0 Investments

Total Fixed Assets 0 0 0 0 0 0

Current Assets Inventory Trade Debtors Bank/Cash 0 0 0 Connected Parties / Inter Company Loans Prepayments / Other Debtors

Total Current Assets 0 0 0 0 0 0

Current Liabilities Bank Overdraft (Facility Limit in Projected Years) 0 0 0 Invoice discounting (YE Balance) 0 0 0 Short Term loans / Leasing (<1 year) Trade Creditors Accruals / Other Creditors

Total Current Liabilities 0 0 0 0 0 0

Net Current Assets 0 0 0 0 0 0

Liabilities > 1 Year Long Term Loans Leases Connected Parties / Inter Company Loans Directors / Shareholders Loans EI Grant Liability (This application only) 0 0 0 Other Long Term Liabilities

Total Liabilities > 1 Year 0 0 0 0 0 0

Net Assets 0 0 0 0 0 0

Financed by

Total Irish Labour Costs (€000's)

Capitalised R&D (€000's)

D13

See Note 6 on 'Instructions' Sheet. This is the latest accounting period which has elapsed, regardless of whether audited accounts are available. If greater than 10 months actual information is available then please use as the base year

E13

This is the current Financial Year. if at least 10 months of actual information is available in the current financial year, then there is a reasonable expectation that the company will meet its end of year projections. In these situations the company should use the current financial year as the base year.

A15

Insert the number of global full time employees ( or full time equivalents*) at the year end. This includes the total Irish based employees. Employees may be permanent or employed on contract. * 2 staff working half days count as one full time equivalent position.

A16

Insert the number of full time employees ( or full time equivalents*) based in the Republic of Ireland at the year end. Employees may be permanent or employed on contract. * Two staff working half days count as one full time equivalent position.

A17

Insert the number of global R&D employees at year end. This includes Irish based R&D employees.

A18

Insert the number of R&D employees based in the Republic of Ireland at year end.

A19

Include wages, salaries, bonuses, overtime, fringe benefits and Employers PRSI of employees based in the Republic of Ireland.

A20

Insert Capitalised R&D asset here. This equates to R&D capitalised in year.

A22

Please insert the expected facility limit at the year end in each forecast year

A23

Please Insert the expected balance at the Year End. It is assumed that this balance is a % of the Trade Debtor Balance and the full facility may not be available.

A24

If sale of asset please enter proceeds as a negative. The amount should be net of VAT

A25


A26


A27

If sale of asset please enter proceeds as a negative

A28

Information entered here will automatically update the "Ordinary Shares & Share Premium" field in the Balance sheet Do not include Convertible Loan Notes

A29

Information entered here will automatically update the "Ordinary Shares & Share Premium" field in the Balance sheet - Do not include Convertible Loan Notes

A38

Total sales by the Irish enterprise and any sales by agents of the Irish enterprise to non-residents (does not include sales by subsidiaries based overseas)

A39

items involved in billing out of Ireland but not physically touching Ireland - e.g. items assembled and sold abroad

A40

Goods / services sold in Ireland

A41

Other companies product sold either at home or abroad

A44

Labour used in the production of finished product - Include wages, salaries, bonuses, overtime, fringe benefits and Employers PRSI - DO NOT INCLUDE R&D LABOUR

A45

Purchases of raw materials, components etc. If not relevant or immaterial leave blank.

A47

Cost of purchasing raw materials and manufacturing into finished product.

A49

Formula: Gross Profit = Sales - Cost of Sales

A51

Please exclude all Labour costs as this is captured below

A52

Include wages, salaries, bonuses, overtime, fringe benefits and Employers PRSI - - DO NOT INCLUDE R&D Salaries

A55

For example: Overheads, Capital Equipment, Materials, Travel & Subsistence, Consultancy/Contracting, Certification/Clinical Trials Technology Licensing Patenting

A56

Insert R&D expenditure in the 2 rows directly ABOVE. Capitalised R&D should be entered in Row [Capitalised R&D].

A58

Insert other operating expenses as positive and other operating gains as negative. Please Provide a brief description of what the other operating expenses / gains relates too

A61

Formula: Op Profit = Gross Profit - SG&A - R&D - Other Expenses

A63

Insert interest payable as positive

A64

Insert interest receivable as negative.

A65

Insert total depreciation expenditure.

A66

Insert total Amortisation expenditure.

A67

This is a calculated field - for ease of calculation and for comparison purposes - this is treated as a gain and written off over 5 years. Please note it relates to EI support for this application only

A68

Where Subsidiary Revenues and Costs have not been already incorporated into the P&L, please include the Subsidiary Profits (only) here.

A69

Insert non-operating expenses (e.g. litigation fees) as positive and non-operating gains (e.g. gains on asset sales; grants; dividends received) as negative.

A70

Formula: PBT = Operating Profit - Interest - Non-Operating Expenses

A73

Formula: Net Profit = PBT - Tax

A76

Formula: Profit Retained = Net Profit - Dividends

A85

Includes goodwill, patents, development costs etc.

E85

Intangible Asset purchases should be inputted in the additional information table above on line 69 and capitalised R&D on line 62

F85


G85


A86

Includes land & buildings; plant & machinery; fixtures & fittings etc.

E86

Tangible Asset purchases should be inputted in the additional information table above between lines 66 - 68

F86


G86


A87

Includes financial assets; shares and loans to Group companies etc.

A93

Please do not net with Bank overdraft - movement in overdraft is captured separately

E93

This is automatically calculated in the funding table below

F93


G93


A94

Directors loans, inter-company loans, etc

A95

Other Debtors includes such things as VAT Receivable, income due as a result of non trading activities etc. Please specify in comment box to the right.

A99

For all historic years please insert actual balance

A100

Please insert the expected balance at the Year End

A103

Other Creditors includes such things as VAT Payable, PAYE/PRSI, deferred income etc. - Please specify in comment box to the right.

A106

Formula: Net Current Assets = Current Assets - Current Liabilities

A111

inter-company loans, etc

A113

This is an automated field and relates to EI grants in this proposal only - other grant liabilities should be included in "other Long Term Liabilities" below

A117

Formula: Net Assets = Fixed Assets + Net Current Assets - LT Liabilities


Preference Shares EI Equity Assistance (This application only) 0 0 0 Ordinary Shares & Share Premium 0 0 0 Provisions/Grants/Other Reserves Retained Earnings 0 0 0 0 0

Shareholders Funds 0 0 0 0 0 0

A121

This is inputted by the DA Please ignore this field

E122

This is automatically calculated from the inputs in the cash flow below

F122


G122


A124

Yellow Box: Enter Opening Retained Earnings. Orange boxes - Formula: Retained Earnings = Retained Earnings from previous year + Profit Retained for the year.


0 0 0 0 0 0

Projected Cash Funding Table

Year End 31/12/10 31/12/11 31/12/12 31/12/14 31/12/15 31/12/16

€000's €000's €000's €000's €000's €000's

Cash Flow Statement For the year ended

Profit Retained for the Year 0 0 0

Add back; Depreciation / Amortisation 0 0 0

Working Capital (Increase)/Decrease

Stocks 0 0 0

Trade Debtors 0 0 0

Prepayments / Other Debtors 0 0 0

Trade Creditors 0 0 0

Accruals / Other Creditors 0 0 0

Total 0 0 0

Operating Cash Inflow / (Outflow) 0 0 0

Capex - Tangible 0 0 0

Capex - Intangible 0 0 0

Capital Expenditure 0 0 0

Funding Inc/ (Dec)OverDraft & Invoice Discounting Facility 0 0 0

Short Term loans / Leasing (<1 year) 0 0 0

Long Term Loans / Leasing / convertible 0 0 0

Convertible/Other Loans 0 0 0

Connected Parties / Inter Company Loans 0 0 0

Directors Loans 0 0 0

EI Equity 0 0 0

EI Grant 0 0 0


of year projections - current year should be used as the base year in this case. Please Refer to instruction 6

Insert Additional Information

Please provide a description of Other


Insert Additional Information





Summary Monthly Cashflow Statement for the NEXT 12 MONTHS Total

Month End MM/YY MM/YY MM/YY MM/YY MM/YY MM/YY MM/YY MM/YY MM/YY MM/YY MM/YY MM/YY Dec-14

€000's €000's €000's €000's €000's €000's €000's €000's €000's €000's €000's €000's €000's

Operating Cash Inflow

0

Sales Receipts - Invoice discounting 0Other Revenue - specify 0Other Revenue - specify 0

Non - Operating Cash Inflow

Loan 1 0Loan 2 0

Non EI Equity/Grants

Promoters' Equity Investment 0Other Equity Investment 0

EI Monies (This investment) 0

Total Cash Receipts 0 0 0 0 0 0 0 0 0 0 0 0 0

Operating Cash Payments

Payments to Creditors/Suppliers 0Wages/Salaries 0Other Cash Operating Expenses 0Other Expense 1 - Specify 0Other Expense 2 - Specify 0

Capital Investment 0

Dividends

Dividends Paid to EI 0 Other Dividends Paid 0

Non-Operating Cash Payments

Invoice Discounting Payments 0Loan Repayment 2 0

0

Equity/Grants

EI Share/Grant Redemptions 0 Other Share Redemptions 0

Total Cash Payments 0 0 0 0 0 0 0 0 0 0 0 0 0

Total Cash Inflow/(Outflow) 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0

OverDraft Facility

Inv Disc (Proj Month End Bal) 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0

Sales receipts - Non Invoice Discounting Supported

Directors Loans/ Related Parties Payments

Net Opening Cash (Excl Short Term Facilities)

Net Closing Cash (Excl Short Term Facilities)

Net Closing Cash (Incl Short Term Facilities)

B9

Date is automatically calculated based on the input from the previous sheet

A12

Insert sales receipts as positive. - separate sales into those supported by Invoice Discounting and those that are cash received directly from customers

A13

Windows User: It should be noted these inputs have the effect of cumulating the Invoice Discounting Facilities in use. To prevent the cumulative effects of this progression an input is required on corresponding Invoice Discounting Payments at Line 39

A21

Insert monies received from non EI sources e.g. Promoter Equity or other investors

A25

Insert Money received from EI e.g. Equity or Grants

A30

Insert payments as positive figures.

A31

Exclude capitalised R&D and capture below in Capital Investment

A37

Insert (cash) overhead expenses here.

A77

Insert opening cash balance at beginning of year in yellow box. Enter negative cash position (e.g. overdraft) as a negative.

A82

This calculation nets the available cash and bank facilities available to the Company i.e. cash plus sanctioned overdraft/debt facilities. If the Company is overdrawn this is taken from the available facilities.

Sustainable Growth AnalysisBase Year-2 Base Year-1 Base Year Current Year Base Year+2 Base Year+3

31/12/11 31/12/12 31/12/13 31/12/14 31/12/15 31/12/16Audited Audited Management Projected Projected Projected

1 Additional Fixed Assets 0 0 0 2 Additional Working Capital Assets (Spontaineously Generated) 0 0 0 3 Capital Repayments (Loan & Lease) 0 0 0 4 Overdraft & ID Withdrawn 0 0 0 5 Directors or Connect Party Loans Withdrawn 0 0 0

Trade Working Capital withdrawn 0 0 0 6 Additional Financial Needs (AFN) 0 0 0 7 0 0 0 8 Additional Termed Capital Advanced (Loan & Lease) 0 0 0 9 Retained Earnings 0 0 0 10 Cash Resources Utilised 0 0 0 11 Overdraft & ID Advanced 0 0 0 12 Directors or Connect Party Loans Advanced 0 0 0 13 Additional Financial Needs (AFN) - Unfunded 0 0 0 14 What If 15 Additional Sales volume that can be funded from internal resources - - - - 16 Planned additional sales volume - - - 17

18 Capital Intensity Ratio 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 19 Debt Equity Ratio 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 20 MSGR Drivers 21 Net Profit Margin 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 22 Asset Turnover Ratio 0.00 0.00 0.00 0.00 0.00 0.00 - 23 Equity Multiplier 1.00 1.00 1.00 1.00 1.00 1.00 - 24

25 Return on Total Assets 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 26 Return on Equity 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 27 Dividend Ratio 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 28 Maximum internal Growth Rate 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

29 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

30

31 Organic Enterprise Growth (Less external equity injections) € - € - € - € - € - 32 Organic Enterprise Growth Rate 0 0 0 0 0 33 Growth in excess of projected MSGR 0.0% 0.0% 0.0% 34

35 Movement in MSGR Drivers 36 Net Profit Margin 0.0% 0.0% 0.0% 37 Asset Turnover Ratio 0.00 0.00 0.00 38 Equity Multiplier 0.00 0.00 0.00

Dividend Policy 0.0% 0.0% 0.0%

Ref Core Issues Key Questions

1 Capital Intensity Requirement Is asset investment absolutely necessary to drive increase in sales?22 & 37 Is there spare capacity in existing asset base - historic intensity rate?

15 & 16 & 21 & 36 Movement in Net Profit Is volume component of sales movement attainable and what are the drivers?21 & 36 Is gross margin component of movement attainable and what are the drivers?21 & 36 Is expense component of movement realistic and what are the drivers?21 & 36 Is component outside EBIT of movement realistic and what are the drivers?

19 & 23 & 38 External Funding Capacity What sources of external funding are available and the realistic probability of attaining it?19 & 23 & 38 What is the cash available for debt service and what are its major drivers?19 & 23 & 38 What are the debt service requirements and ratios and can they be varied?

Financed By: Additional Trade Working Capital Advanced

Maximum Sustainable Growth Rate= MSGR

E3

See Note 6 on 'Instructions' Sheet. This is the latest accounting period which has elapsed, regardless of whether audited accounts are available. If > 10 months actual information is available then please use as the base year

F3

This is the current Financial Year. if at least 10 months of actual information is available in the current financial year, then there is a reasonable expectation that the company will meet its end of year projections. In these situations the company should use the current financial year as the base year.

1 2 3 4 5 6

0

5,000

10,000

15,000

20,000

25,000

30,000

35,000

0

2,500

5,000

7,500

10,000

12,500

15,000

17,500

20,000

22,500

25,000Expenditure Analysis

Revenue Non R&D Opex COS R&D ExpenditureTotal Opex

Re

ve

nu

e -

Eu

ro

Ex

pe

nd

itu

re -

Eu

ro

2011 2012 2013 2014 2015 2016

0

2

4

6

8

10

12Revenue Summary

Distribution Sales Domestic Sales International Sales Exports

Eu

ro

2011 2012 2013 2014 2015 2016-(5,000)

0

5,000

10,000

15,000

20,000

25,000

30,000

35,000Summary of key profit & loss indicators

Total Sales Gross Margin EBIDTA Net Margin

€'0

00

2011 2012 2013 2014 2015 2016

0

5,000

10,000

15,000

20,000

25,000

30,000

35,000 KPI's

Revenue EBITDA

Eu

ro

2011 2012 2013 2014 2015 20160

500

1,000

1,500

2,000

2,500

3,000

3,500

4,000

4,500

5,000Analysis of Debt

ST Loans/Leases LT Loans LT Leases Intercompany loans

Interest Payable

Eu

ro

2011 2012 2013 2014 2015 2016

0

100

200

300

400

500

0

1,000

2,000

3,000

4,000

5,000

6,000

7,000Labour Analysis

Global Employees Irish Employees Indirect Labour Costs

Total Labour Costs R&D Costs Direct Labour Costs

Em

plo

ye

e N

um

be

rs

La

bo

ur

Co

sts

- €

2011 2012 2013 2014 2015 2016

0

1,000

2,000

3,000

4,000

5,000

6,000 Fixed Asset Analysis

Investments

Tangible Asstes

Intangible Assest

Depreciation & Amortisation

Capex

Eu

ro-1000

0

1000

2000

3000

4000

5000 Cashflow Analysis

Year

Eu

ro

2011 2012 2013 2014 2015 20161899

1899

1899 Working Capital Analysis

Trade Debtors Inventory Trade Creditors Current Assets

Current Liabilities Net Working Capital

Eu

ro

2000

2000

2001

2001

2002

2002

2003

2003

2004

2004

2005

2005

2006

2006

2007

2007

2008

2008

2009

2009

0

20

40

60

80

100

120

0%

200%

400%

600%

800%

1000%

1200%Working Capital Analysis

Da

ys %

Please note the following assumptions

1. Debtors will be directly impacted as a result of a movement in sales

2. Creditors will be directly impacted as a result of a movement in Purchases

3. Stock will be directly impacted as a result of a movement in Purchases

4. In Scenario Test A, purchases is the only element of Total Cost of Sales category that is variable

5. I n cases where the value of Purchases is very low (or zero) Scenario Test B should be used

Scenario Test A 31/12/14 31/12/15 31/12/16

Sales 100% 100% 100%

Purchases only 100% 100% 100%

Operating Expenditure 100% 100% 100%

Profit & Loss - Scenario Test

Current Year Base Year+2 Base Year+3

Year End 31/12/14 31/12/15 31/12/16

Account Status 42004 42369 42735

€000's €000's €000's

0 0 0

Total Sales 0 0 0

Purchases 0 0 0

Total Cost of Sales 0 0 0

Gross Profit/(Loss) 0 0 0

0 0 0

Operating Expenditure 0 0 0

Operating Profit/(Loss) - EBITDA 0 0 0

Profit/(Loss) before Tax 0 0 0

Net Profit/(Loss) 0 0 0


Balance Sheet - Scenario Test

Year End 31/12/14 31/12/15 31/12/16

€000's €000's €000's

Total Fixed Assets 0 0 0

Stock 0 0 0

Debtors 0 0 0

Bank/Cash 0 0 0

Total Current Assets 0 0 0

Please select from the drop down boxes below to perform a simple scenario analysis, that will enable the user to understand the impact of variances in sales & costs forecasts.

B21

This is the current Financial Year. if at least 10 months of management accounts are available and there is a reasonable expectation that the company will meet its end of year projections, the current financial year is the base year.

A26

This is altered by the % selected in the sales line in scenario testing above

A29

This is altered by the % selected in the Cost of sales line in scenario testing above

A31


A36


A38


A40


A42



Total Current Liabilities 0 0 0

Net Current Assets 0 0 0

Total Liabilities > 1 Year 0 0 0

Net Assets 0 0 0

Financed by

Retained Earnings 0 0 0

Shareholders Funds 0 0 0

0 0 0

Projected Cash Funding Table - Scenario Test

31/12/14 31/12/15 31/12/16




Working Capital (inc)/dec

Stocks 0 0 0

Debtors 0 0 0


Creditors 0 0 0


Total 0 0 0


Funding (inc)/dec

OD & ID Facility 0 0 0

Short Term loans / Leasing (<1 year) 0 0 0

Long Term Bank Loans/Leasing 0 0 0

Convertible/Other Loans 0 0 0

Related Parties 0 0 0

Directors Loans 0 0 0

EI Equity 0 0 0

EI Grant 0 0 0

Other Equity 0 0 0

Other Reserves 0 0 0

Net Movement in Cash 0 0 0

Opening Cash Balance 0 0 0

Closing Cash Balance - Available Funds 0 0 0

Overdraft Facility 0 0 0

Invoice Discounting Balance 0 0 0

Closing Cash (Excl Facilities i.e. net cash) 0 0 0

Scenario Test B 31/12/14 31/12/15 31/12/16

Sales 100% 100% 100%

Cost of Sales 100% 100% 100%

A58


A62


Operating Expenditure 100% 100% 100%

Profit & Loss - Scenario Test

Current Year Base Year+2 Base Year+3

Year End 31/12/14 31/12/15 31/12/16

Account Status 0 0 0

€000's €000's €000's

0 0 0

Total Sales 0 0 0

Purchases 0 0 0

Total Cost of Sales 0 0 0

Gross Profit/(Loss) 0 0 0

0 0 0

Operating Expenditure 0 0 0

Operating Profit/(Loss) - EBITDA 0 0 0

Profit/(Loss) before Tax 0 0 0

Net Profit/(Loss) 0 0 0


Balance Sheet - Scenario Test

Year End 31/12/14 31/12/15 31/12/16

€000's €000's €000's

Total Fixed Assets 0 0 0

Stock 0 0 0

Debtors 0 0 0

Bank/Cash 0 0 0

Total Current Assets 0 0 0


Total Current Liabilities 0 0 0

Net Current Assets 0 0 0

Total Liabilities > 1 Year 0 0 0

Net Assets 0 0 0

Financed by

Retained Earnings 0 0 0

Shareholders Funds 0 0 0

0 0 0

Projected Cash Funding Table - Scenario Test

31/12/14 31/12/15 31/12/16



B118

This is the current Financial Year. if at least 10 months of management accounts are available and there is a reasonable expectation that the company will meet its end of year projections, the current financial year is the base year.

A123

This is altered by the % selected in the sales line in scenario testing above

A126

This is altered by the % selected in the Cost of sales line in scenario testing above

A128


A133


A135


A137


A139


A155


A159



Working Capital (inc)/dec

Stocks 0 0 0

Debtors 0 0 0


Creditors 0 0 0


Total 0 0 0


Funding (inc)/dec

OD & ID Facility 0 0 0

Short Term loans / Eeasing (<1 year) 0 0 0

Eong Term Bank Eoans/Eeasing 0 0 0

Convertible/Other Eoans 0 0 0

Related Parties 0 0 0

Directors Eoans 0 0 0

EI Equity 0 0 0

EI Grant 0 0 0

Other Equity 0 0 0

Other Reserves 0 0 0

Net Movement in Cash 0 0 0

Opening Cash Balance 0 0 0

Closing Cash Balance - Available Funds 0 0 0

Overdraft Facility 0 0 0

Invoice Discounting Balance 0 0 0

Closing Cash (Excl Facilities i.e. net cash) 0 0 0

Scenario Test A

Scenario Test B

EI DA Input Sheet document.xlsx


Company Name

Company Information

Region Please Select

Type of Company Please Select

Ownership/Strategic Control Please Select

Employment Numbers

Base Year

Year End 31/12/13

Base Irish Employment Level 0

EI Funding

Development Adviser to input proposed grant and equity package as applicable.

Base Year+1 Base Year+2 Base Year+3

Year End 31/12/14 31/12/15 31/12/16

€000's €000's €000's

Grants

EI Capital Grants - - -

EI Employment Grants - - -

EI HRD/Mgt Development Grants - - -

EI R&D Grants - - -

EI Marketing & Strategy Grants - - -

Total Grants 0 0 0

Equity

EI Ordinary Shares - - -

EI HPSU CCRPs - - -

EI Preference Shares - - -

Total EI Equity 0 0 0

Equity amount to be used for Value for Money measures 0 0 0

Value for Money measures

Cost per Job Inputs €000's

Value For Money (VFM) (from CSS)

CEB Funding (Grant - past 7 years)

CEB Funding (Equity - past 7 years)

New Proposed Cancellations (Grant) Should be a negative amount

New Proposed Cancellations (Equity) Should be a negative amount

New Support 0

Total Support 0

Business Expansion Scheme (BES)*

BES Redemption amount €0

BES Redemption date DD/MM/YY

*If applicable

Assumptions For BC calculation

Repayable element of Capital Grant 0%

Capital Amount Waived -

Cost Benefit Ratio

If you need assistance with this ratio, please contact Commercial Evaluation.

EI Cost Benefit Ratio Please complete the above 'Company Information' section to calculate

the Cost Benefit Ratio.

Drivers of Cost Benefit Ratio

€000's

Increase in Sales 0

Increase in Exports 0

Increase in Irish Payroll 0

Increase in Post Tax Profits 0

ImpactsEI Targets* Base Year Base Year+3 Increase

dd/mm/yy dd/mm/yy (€'000) %

Sales (€000’s) 0 0 0

Exports (€000’s) 0 0 0

Employees (Irish Based) 0 0 0 n/a

Productivity** n/a n/a

Value for Money Measures

Ratio of

IncreasedExport Sales

To EI Support €'000 €'000

EI Funding Guidelines - justification required if exceeded

Ratio of 3:1 Minimum of 1 Max €15k / €25k Max €15k / €25k

Benefit to Cost Ratio

Total Support per Existing

Employees (Base Year)

Total Support per Projected

Employees (Base Year+3)*

A8

Dublin: Dublin Mid East: Kildare, Meath, Wicklow BMW: Cavan, Donegal Monaghan Galway, Leitrim, Mayo, Roscommon, Sligo Laois, Longford, Louth, Offaly, Westmeath South East: Carlow, Kilkenny, S. Tipperary, Waterford, Wexford South West: Cork, Kerry Mid West: Clare, Limerick, N. Tipperary

A9

Choose whether company is: HPSU Established Company

A10

Choose whether ownership/strategic control is: Irish Foreign (e.g. certain clients in Food, Timber industries)

D17

Linked Directly to the Company Input Sheet

To insert the below tables into the Commercial Assessment (CA) Document please follow the below steps:

Step 2: Open the CA document and place the cursor where you want the selected table to appear

Step 3: Using the mouse go to the Edit menu on the tool bar and left click on "Paste Special"

Step 4: A "Paste Special" pop up box will appear - select Microsoft Office Excel Worksheet Object and left click on OK

Step 6: Repeat steps 2 to 4



Track Record & Projections: Company Name FDS Template as at 41775Month Base Year-2 Base Year-1 Base Year Base Year+1 Base Year+2 Base Year+3Year End Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16Account Status Audited Audited Management Projected Projected Projected

SALES & EXPORTS

Sales (€000's) 0 0 0 0 0 0

Domestic Sales (€'000s) 0 0 0 0 0 0

Exports (€000's) 0 0 0 0 0 0

International Sales (€000's) 0 0 0 0 0 0

Exports as % of Sales n/a n/a n/a n/a n/a n/a

International Sales as % of Sales n/a n/a n/a n/a n/a n/a

PROFITABILITY

Gross Profit / (Loss) 0 0 0 0 0 0

EBITDA 0 0 0 0 0 0

Net Profit/(Loss) (€000's) 0 0 0 0 0 0

Gross Proft as a % of Sales n/a n/a n/a n/a n/a n/a

Operating as a % of Sales n/a n/a n/a n/a n/a n/a

EBITDA as a % of Sales n/a n/a n/a n/a n/a n/a

Net Margin n/a n/a n/a n/a n/a n/a

Return on Shareholders' Funds n/a n/a n/a n/a n/a n/a

GROWTH

Sales growth % n/a n/a n/a n/a n/a

Export growth % n/a n/a n/a n/a n/a

PRODUCTIVITY

Sales / total asets less current liabilities n/a n/a n/a n/a n/a n/a

Sales / working capital n/a n/a n/a n/a n/a n/a

Sales / fixed assets n/a n/a n/a n/a n/a n/a

Sales per Irish employee (€000's) n/a n/a n/a n/a n/a n/a

RESEARCH & DEVELOPMENT

Total R&D spend (€000's) 0 0 0 0 0 0

R&D as % of sales n/a n/a n/a n/a n/a n/a

R&D as a % of OPEX n/a n/a n/a n/a n/a n/a

MANAGEMENT

Asset turnover n/a n/a n/a n/a n/a n/a

Net Current Asset Turnover n/a n/a n/a n/a n/a n/a

Current Ratio n/a n/a n/a n/a n/a n/a

WORKING CAPITAL ANALYSIS

Working Capital 0 0 0 0 0 0

Working capital (exc short term facilities) ('000s) 0 0 0 0 0 0

Short term facilities ('000s) 0 0 0 0 0 0

Working Capital Turnover (times) n/a n/a n/a n/a n/a n/a Avg Dr Days 90 Anything above 90 days should be considered excessive - identify why

Inventory Turnover n/a n/a n/a n/a n/a n/a Avg Cr Days 90 Anything above 90 days should be considered excessive - identify why

Total Debtors (inc pre payments) days n/a n/a n/a n/a n/a n/a Interest Cover 1 Anything less than 1 suggests an inability to meet finance repayments

Invoice Discounting as a % of Tr Debtors 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Std % Dr's 75% 75% is the standard amount provided by the bank

Total Creditors (inc accruals) days n/a n/a n/a n/a n/a n/a

GEARING

Equity (Incl Shareholders Funds & Director Loans) 0 0 0 0 0 0

Total Debt 0 0 0 0 0 0

Total Bank Debt 0 0 0 0 0 0

Free Cash Flow (FCF) 0 0 0

Debt/Equity n/a n/a n/a n/a n/a n/a

1+( LT liabilities/S/H funds) n/a n/a n/a n/a n/a n/a

Interest Cover n/a n/a n/a n/a n/a n/a

EMPLOYMENT

Global Employees at year-end 0 0 0 0 0 0

Irish Employees at year-end 0 0 0 0 0 0

No. of R&D Employees @y/e 0 0 0 0 0 0

No. of Irish R&D Employees @ y/e 0 0 0 0 0 0Base Employment = 0

Profit & Loss

Base Year-2 Base Year-1 Base Year Current Year Base Year+2 Base Year+3

Year End 31/12/11 31/12/12 31/12/13 31/12/14 31/12/15 31/12/16

Account Status Audited Audited Management Projected Projected Projected

€000's €000's €000's €000's €000's €000's

Own Product / Service Produced in Ireland & Exported 0 0 0 0 0 0

Own Product / Service Produced Abroad & sold Abroad 0 0 0 0 0 0

Own Product / Service Produced & Sold in Ireland 0 0 0 0 0 0

Distribution Sales of Other Co's Product 0 0 0 0 0 0

Total Sales 0 0 0 0 0 0

Direct Labour 0 0 0 0 0 0

Purchases 0 0 0 0 0 0

Other Cost of Goods Sold 0 0 0 0 0 0

Cost of Sales 0 0 0 0 0 0

Gross Profit/(Loss) 0 0 0 0 0 0

Selling, General & Admin Expenses 0 0 0 0 0 0

Indirect Labour (excluding R&D Salaries) 0 0 0 0 0 0

R&D Expenditure 0 0 0 0 0 0

Other Operating Expenses/(Gains) 0 0 0 0 0 0

Operating Expenditure 0 0 0 0 0 0

Operating Profit/(Loss) - EBITDA 0 0 0 0 0 0

Interest Payable 0 0 0 0 0 0

Interest / Dividends (Receivable) 0 0 0 0 0 0

Depreciation 0 0 0 0 0 0

Amortisation 0 0 0 0 0 0

Grant Amortisation (This application only) 0 0 0

Remitted Profits to Ireland From Foreign Subsidiary 0 0 0 0 0 0

Non-Operating Expenses/(Gains) 0 0 0 0 0 0

Profit/(Loss) before Tax 0 0 0 0 0 0

Tax 0 0 0 0 0 0

Net Profit/(Loss) 0 0 0 0 0 0

Dividends 0 0 0 0 0 0

Profit Retained for the Year 0 0 0 0 0 0

Balance Sheet

Balance Sheet: Company Name FDS Template as at 41775

Year End 31/12/11 31/12/12 31/12/13 31/12/14 31/12/15 31/12/16

€000's €000's €000's €000's €000's €000's

Fixed Assets

Intangible 0 0 0 0 0 0

Tangible Fixed Assets 0 0 0 0 0 0

Investments 0 0 0 0 0 0

Total Fixed Assets 0 0 0 0 0 0

Current Assets

Inventory 0 0 0 0 0 0

Trade Debtors 0 0 0 0 0 0

Bank/Cash 0 0 0 0 0 0

Connected Parties / Inter Company Loans 0 0 0 0 0 0

Prepayments / Other Debtors 0 0 0 0 0 0

Total Current Assets 0 0 0 0 0 0

Current Liabilities

Bank Overdraft (Facility Limit in Projected Years) 0 0 0 0 0 0

Invoice discounting (YE Balance) 0 0 0 0 0 0

Short Term loans / Leasing (<1 year) 0 0 0 0 0 0

Trade Creditors 0 0 0 0 0 0

Accruals / Other Creditors 0 0 0 0 0 0

Total Current Liabilities 0 0 0 0 0 0

Net Current Assets 0 0 0 0 0 0

Liabilities > 1 Year

Long Term Loans 0 0 0 0 0 0

Leases 0 0 0 0 0 0

Connected Parties / Inter Company Loans 0 0 0 0 0 0

Directors / Shareholders Loans 0 0 0 0 0 0

EI Grant Liability (This application only) 0 0 0

Other Long Term Liabilities 0 0 0 0 0 0

Total Liabilities > 1 Year 0 0 0 0 0 0

Net Assets 0 0 0 0 0 0

Financed by

Preference Shares 0 0 0 0 0 0

EI Equity Assistance (This application only) 0 0 0

Ordinary Shares & Share Premium 0 0 0 0 0 0

Provisions/Grants/Other Reserves 0 0 0 0 0 0

Retained Earnings 0 0 0 0 0 0

Shareholders Funds 0 0 0 0 0 0

Capital Expenditure

Capex 0 0 0 0 0

Loans Facilities Total 0 0 0 0 0

Bank Overdraft 0 0 0 0 0

Invoice disc 0 0 0 0 0

Short Term loans / Leasing (<1 year) 0 0 0 0 0

Long Term Bank Loans/Leasing 0 0 0 0 0

Convertible/Other Loans 0 0 0 0 0

Related Parties 0 0 0 0 0

Directors Loans 0 0 0 0 0

Loans Repayment Total - 0 0 0 0 0

Bank Overdraft Payments 0 0 0 0 0

Invoice Discounting Payments 0 0 0 0 0

Short term Loan / Leasing Payments 0 0 0 0 0

Long Term Bank Loans/Leasing Payments - 0 0 0 0 0

Other Long Term Liabilities Redeemed 0 0 0 0 0

Related Parties Payments 0 0 0 0 0

Directors Loans Redeemed - 0 0 0 0 0

Additional Ratios

Base Year-2 Base Year-1 Base Year Base Year+1 Base Year+2 Base Year+3

Year End Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16

Account Status 30/12/99 30/12/99 30/12/99 30/12/99 30/12/99 30/12/99

GROWTH

Net increase in Sales 0 0 0 0 0

Net increase in Exports 0 0 0 0 0

PROFITABILITY

EBIT 0 0 0 0 0 0

EBIT as % of Sales n/a n/a n/a n/a n/a n/a

Purchases as a % of Sales n/a n/a n/a n/a n/a n/a

Direct labour as a % of Sales n/a n/a n/a n/a n/a n/a

SGA as a % of Gross Profit n/a n/a n/a n/a n/a n/a

Indirect Labour as a % of Sales n/a n/a n/a n/a n/a n/a

R&D as a % of Sales n/a n/a n/a n/a n/a n/a

Other n/a n/a n/a n/a n/a n/a

Depreciation-Amortization n/a n/a n/a n/a n/a n/a

ROCE n/a n/a n/a n/a n/a n/a

ROI n/a n/a n/a n/a n/a n/a

PRODUCTIVITY

Sales per total employee (€000's) n/a n/a n/a n/a n/a n/a

Value Add To Ireland 0 0 0 0 0 0

Value Add To Ireland per Total employee n/a na na na na na

Value Add To Ireland per Irish employee n/a n/a n/a n/a n/a n/a

Step 1: Copy the Track Record & Projections Table into the CA document by Hi-lighting cells A15 to H70

Step 5: Copy the Projected Cash Funding Table into the CA document by Hi-lighting cells A118 to H162

Step 7: Copy the Profit & Loss Table into the CA document by Hi-lighting cells A164 to H204

Step 9: Copy the Balance Sheet into the CA document by Hi-lighting cells A206 to H251

A29

Earnings Before Interest, Taxes, Depreciation and Amortisation - used to analyse and compare profitability between companies and industries because it eliminates the effects of financing and accounting decisions

A49

Revenue / Assets Asset turnover measures a firm's efficiency at using its assets in generating sales or revenue - the higher the number the better. It also indicates pricing strategy: companies with low profit margins tend to have high asset turnover, while those with high profit margins have low asset turnover.

A50

Sales / Net Current Assets - shows the productivity of the the company's current assets

A53

Sum of Investory, Debtors & prepayments less Creditors & Accruals

A57

Purchases / Inventory - Stock turnover measures how well a company coverts stock into revenues

A63

Including Connected parties & contingent Liabilities

A66

Debt / Equity A measure of a company's financial leverage calculated by dividing its total liabilities by stockholders' equity. It indicates what proportion of equity and debt the company is using to finance its assets. NB Shareholder Loans & EI Pref shares are treated as equity

A68

Operating Profit ÷ Interest Payable

A217

Please note this captures the net movement in loans only

A218

This is a calculated field and relates to the movement in figures as captured in the balance sheet - please note it capture the net effect only

A219


A220


A221


A222


A223


A224


A226

Please note this captures the net movement in loans only

A227


A228


A229


A230


A231


A232


A233


A254

PBIT / (S/H funds + non-current liabilities) A ratio that indicates the efficiency and profitability of a company's capital investments

A255

See separate sheet "ROI" for a detailed breakdown: EBITDA/Total Assets (Fixed + Current Assets) or alternative view is EBITDA margin * (Sales/Total assets)

A258

This is Sales Less Purchases

Payback Period without EI Support 0 The % of the company's profit increases attributed to this project: 25%Year: 0 1 2 3 4 5*Cash Flow (€,000s): € - - - - -

- - - - - See Example of Payback Period Exercise at Line 48 below

* EI Support package not included

Payback Period: #DIV/0! Years#DIV/0!

Payback Period with EI Support0 0 0

Year: 0 1 2 3 4 5**Cash Flow (€,000s): € - - - - - Cumulative Cash Flow (€,000s): 0 - - - - - Assumed Stream of EI Financial Support (Years 1, 2 & 3 only): (€,000s)

** EI Support package included

Payback Period: #DIV/0! YearsPayback Period (where time period requires extension): #DIV/0! Years

Assumed annual cashflow reduction due to curtailed proposal: 10%Year: 0 1 2 3 4 5Cash Flow (€,000s) - As per C/F above 'without EI support': € - - - - - Cumulative Cash Flow (€,000s): - - - - -

(€,000s) €0 = necessary reduction in project investment in order to bring payback period measure in line with that required (say - as per Cell F21 above)

Payback Period: #DIV/0! Years#DIV/0!

Project [Name]

Cumulative Cash Flow - incl. at Yr.0 the Cost of Proj. as Neg. Fig. (€,000s):

Note: Base Yr. (Yr.0) Fig. above to include R&D, Capital Costs, Start-Up losses, etc

Adjusted Payback Period without EI Support

The 'Goal Seek' function may be used to amend Assumed Costs (Blue Box above)

G2

Windows User: Change this 50% default figure to an appropriate alternative figure

B5

Windows User: Value in this Cell needs to be inputted as a negative Figure to reflect Initial investment/costs

G25

Windows User: The annual cash flow figures will be increased by the % figure inserted here. Change % figure as appropriate

B28

Windows User: In the 'Goal Seek' exercise an initial guess needed for this cell - inputted as a negative figure

financial data sheet r d fund large projects

Documents