{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions ","General information - To fill","Year 1 - To fill","Year 2 - To fill","Calculation Details","Title"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":2,"defined_names":969,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions ","index":0,"n_rows":124,"n_cols":17,"rows_kept":124,"cut":false,"hidden":false,"merged":[[0,5,0,16],[2,0,2,16],[3,0,3,16],[63,0,63,16],[5,0,20,16],[25,0,60,16]]}
[null,null,null,null,null,"Financing of Refundable SR&ED Tax Credits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For fiscal year containing June 4, 2014"]
["LOAN / GUARANTEE APPLICATION"]
["Instructions"]
[]
["Complete the “General Information - To fill”, “Year 1 – to fill” and “Year 2 – to fill” tabs of this electronic “LOAN / GUARANTEE APPLICATION” form using Microsoft Excel and forward it to Investissement Québec. Be sure to answer all the questions and provide complete information. The “Calculation Details” tab provides the detailed calculation of your tax credits based on the information provided. No data entry is required in these tabs. \n\nThe application for financing can cover a maximum of two years; therefore, two forms have been provided to cover the two-year period.  \n\nThe data entry fields in each tab of the electronic form are in yellow. The lines on the form correspond to the lines on the company's T2 and CO-17 income tax return. The calculation zones left in white are automated and will be completed by the system. These calculations are provided as examples only and are in no way binding on Investissement Québec. The minimum loan granted is $50,000. The minimum loan guarantee granted is $62,500. \n\nTool tips have been provided where it was determined that explanations may be helpful in completing the form. They are identified by a red triangle in the top right corner of the cell . Move your mouse over the cell to view the tip. The T4088 Scientific Research and Experimental Development (SR&ED) Expenditures Claim - Guide to Form T661 is available on the Canada Revenue Agency (CRA)  website to assist you in completing the form. \n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["To expedite processing of your application send your form by email to your portfolio manager at Investissement Québec. \n                                                                                                                                                                                                                                                                                                                                                                                                                                   Additional documents to provide\n                                                                                                                                                                                                                                                                                                                                                                                                                                               You will also need to send the following documents with your application to the Investissement Québec business center in your region for your application to be reviewed:\n\nA)  If you are a first time filer for SR&ED tax credits  you must obtain an opinion on the eligibility of your projects. (See: Preclaim Project Review (PCPR) under Services offered on the CRA website at www.cra-  arc.gc.ca/taxecredit/sred/menu-e.html);\n\nB)  A duly completed and signed “Authorization to exchange information with the Canada Revenue Agency” (Schedule B) form that you obtained from Investissement Québec;\n\nC) A duly completed and signed “Declaration of the company” form that you obtained from Investissement Québec; \n\nD)  A description of the scientific content of each SR&ED project (this description should supplement Section 1.5 of the “General Information” tab) including:\n     1)  The title and main scientific or technological objectives of the SR&ED project;\n     2)  The timetable for completing the project (main steps/activities and corresponding level of advancement);\n     3)  The nature of the scientific or technological uncertainties that the project aims to resolve – issues that could not be resolved  using standard practice;\n     4)  The contribution to technological advancements achieved as a result of the work (type of product or process) and the impact on your company’s and current industry practices;\n     5)  An explanation of the scientific and technological content of the project to overcome the scientific and technological uncertainties;\n     6)  The names and qualifications (job titles, expertise or experience) of the personnel involved in the SR&ED project and the name of the scientist or technician responsible for the project with a copy of his/her résumé;\n\nE)  Financial statements for the last two (2) fiscal years (or the opening balance sheet) and the most recent internal financial statements available as well as the chronological (aged) list of accounts receivable and payable as at the same date;\n\nF)  A complete copy of the last three (3) provincial and federal income tax returns and the related notices of assessment;\n\nG)  The business plan or any other document describing your company (products, markets, competition, etc.). A document outlining the essential components of a business plan is available on Investissement Québec’s website at: http://www.investquebec.com/documents/qc/produitsfinanciers/PlanAffaires_en.pdf\n\nH)  Budgeted financial statement and monthly cash flow statements for the current and following  fiscal year;\n\nI)  A copy of all correspondence with Canada Revenue Agency (CRA) and Revenu Québec (RQ) pertaining to the SR&ED project;\n\nJ)  A copy of confirmations of government assistance (non-refundable financial contributions) related to the SR&ED project;\n\nK)  Any documents that may facilitate review of this application, if applicable.\n\nAdditional documents - for loan guarantee\n                                                                                                                                                                                                                                                                                                                                                                                                                                                  In addition to the documents listed above, have your lender complete the “Declaration of the lender” (Schedule A) form you obtained from Investissement Québec; it is required to process your application. Please provide the original document completed by your lender to Investissement Québec with your application.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Investissement Québec Service Outlets:"]
[]
[]
[]
[]
[]
[]
["                                                                           "]
[" "]
[]
[]
[]
[]
["                                                "]
[]
[]
["                                                    "]
["                   "]
["                                                 "]
[]
["                                                                        "]
["                        "]
["                             "]
[]
["                  "]
[]
["                                       "]
["                                  "]
["                                         "]
["                  "]
["                     "]
["                               "]
[]
["                                    "]
["                                        "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["                                "]
["                                "]
[]
[]
[null,null,"Toll-free number in Québec: 1 866 870-0437"]
[]
["                                  "]
["                                          "]
["                              "]
["                    "]
["                               "]
["                             "]
["                                "]
["                    "]

{"sheet":"General information - To fill","index":1,"n_rows":141,"n_cols":19,"rows_kept":141,"cut":false,"hidden":false,"merged":[[69,8,69,15],[78,9,78,15],[81,9,81,15],[133,7,133,9],[135,7,135,9],[137,7,137,9],[126,6,126,9],[0,0,0,2],[15,5,15,15],[2,0,2,16],[3,0,3,16],[8,8,8,15],[47,1,47,10],[10,5,11,15],[6,1,6,16],[27,6,27,15],[29,6,29,8],[13,5,13,15],[24,1,24,5],[25,6,25,15],[21,11,21,15],[22,11,22,15],[4,1,4,7],[40,13,40,15],[20,1,20,5],[12,5,12,15],[4,8,4,10],[16,5,16,15],[34,6,34,15],[26,6,26,15],[9,8,9,15],[4,12,4,14],[17,5,17,15],[29,13,29,15],[18,1,18,5],[23,11,23,15],[19,5,19,15],[19,1,19,2],[21,5,21,8],[37,1,37,5],[37,6,37,15],[85,9,86,10],[40,6,40,8],[71,3,71,7],[85,14,86,15],[67,4,67,10],[61,1,61,16],[41,6,41,8],[41,13,41,15],[65,4,65,10],[65,14,65,15],[66,4,66,10],[42,0,42,16],[85,2,86,2],[85,3,86,5],[85,6,86,8],[73,1,73,16],[78,3,78,6],[81,3,81,6],[85,11,86,13],[62,0,62,16],[71,10,71,15],[63,4,63,15],[91,2,92,2],[94,1,94,16],[98,14,98,15],[124,12,125,13],[87,9,87,10],[87,3,87,5],[87,11,87,13],[87,6,87,8],[89,11,89,13],[88,14,88,15],[89,2,90,2],[90,14,90,15],[89,14,89,15],[119,6,119,9],[91,3,91,5],[92,6,92,8],[92,3,92,5],[91,6,91,8],[92,11,92,13],[92,9,92,10],[124,6,124,9],[125,1,125,5],[124,14,125,15],[121,7,121,9],[91,11,91,13],[88,9,88,10],[99,13,101,13],[102,13,104,13],[99,14,101,15],[102,14,104,15],[105,13,107,13],[108,13,110,13],[111,13,113,13],[105,14,107,15],[91,9,91,10],[98,3,98,12],[88,11,88,13],[90,9,90,10],[88,3,88,5],[96,2,97,15],[87,2,88,2],[89,9,89,10],[92,14,92,15],[89,6,89,8],[91,14,91,15],[90,3,90,5],[88,6,88,8],[89,3,89,5],[136,16,137,16],[135,1,135,5],[132,1,132,5],[131,1,131,5],[126,1,126,5],[124,1,124,5],[123,1,123,5],[128,6,128,9],[130,6,130,9],[132,6,132,9],[134,6,134,9],[126,12,127,13],[124,10,125,11],[128,14,129,15],[133,1,133,5],[127,1,127,5],[132,12,133,13],[130,14,131,15],[136,1,136,5],[137,1,137,5],[136,6,136,9],[136,10,137,11],[126,10,127,11],[130,10,131,11],[87,14,87,15],[90,11,90,13],[90,6,90,8],[108,14,110,15],[111,14,113,15],[138,16,139,16],[120,16,121,16],[122,16,123,16],[124,16,125,16],[126,16,127,16],[128,16,129,16],[130,16,131,16],[132,16,133,16],[122,10,123,11],[132,10,133,11],[122,14,123,15],[120,14,121,15],[138,12,139,13],[134,12,135,13],[122,12,123,13],[136,14,137,15],[134,16,135,16],[134,14,135,15],[134,10,135,11],[140,14,140,15],[138,14,139,15],[136,12,137,13],[134,1,134,5],[130,1,130,5],[129,1,129,5],[128,1,128,5],[122,1,122,5],[121,1,121,5],[138,10,139,11],[138,1,138,5],[138,6,138,9],[139,1,139,5],[132,14,133,15],[126,14,127,15],[128,10,129,11],[130,12,131,13],[128,12,129,13],[139,7,139,9],[123,7,123,9],[125,7,125,9],[127,7,127,9],[129,7,129,9],[131,7,131,9],[119,1,119,5],[120,6,120,9],[122,6,122,9],[119,10,119,11],[99,2,101,2],[99,3,101,12],[102,2,104,2],[102,3,104,12],[105,2,107,2],[108,2,110,2],[111,2,113,2],[105,3,107,12],[108,3,110,12],[111,3,113,12],[120,10,121,11],[120,12,121,13],[120,1,120,5],[119,12,119,13],[117,1,117,16],[119,14,119,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Financing of Refundable SR&ED Tax Credits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For fiscal year containing June 4, 2014"]
["LOAN / GUARANTEE APPLICATION"]
["General information"]
[null,{"$f":"I9","v":0},null,null,null,null,null,null,"Nº. Organisation",null,null,null,"Nº. Dossier"]
["1.0","Has the company read and understood the “Instructions” tab?"]
["1.1 ","IDENTIFICATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[]
[null,"Name of company submitting the application:"]
[null,"NEQ (Québec enterprise number):"]
[]
[null,"Address of head office:"]
[]
[]
[]
[null,"Address of the main office "]
[null,"(If different from head office)"]
[]
[]
[null,"Contact person"]
[]
[null,"Title",null,null,null,null,null,null,null,null,"Phone:"]
[null,null,null,null,null,null,null,null,null,null,"Fax:"]
[null,null,null,null,null,null,null,null,null,null,"E-mail:"]
[]
[null,"Address of contact person"]
[null,"(if different from head office):"]
[]
[]
[null,"Number of employees before the project started:",null,null,null,null,null,null,null,null,null,null," after the project started:"]
[]
["1.2 ","INFORMATION ON THE COMPANY"]
[]
[null,"Canada Revenue Agency account"]
[null,"or company number:"]
[null,null,null,null,null,null,"(See Corporation Income Tax Return, T2)"]
[]
[null,"Revenu Québec registration number:"]
[null,null,null,null,null,null,"(See Corporation Income Tax Return, CO-17)"]
[]
[null,"Date of incorporation:",null,null,null,null,null,null,null,null,null,null,"     Date operations began:"]
[null,null,null,null,null,null,"(yyyy-mm-dd)",null,null,null,null,null,null,"(yyyy-mm-dd)"]
[]
[null,"Is the company a Canadian-controlled private corporation (CCPC)?"]
[null,"(within the meaning of the Income Tax Act of Canada and the Taxation Act of Québec)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,"Is the company a Canadian public corporation?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[null,"Is the company associated (as defined by Income Tax Act of Canada and the Taxation Act of Québec) with other companies?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"(if so, append a list and organization chart to your application)"]
[]
[null,"Is the company in arrears on any account with the Canada Revenue Agency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"or Revenu Québec?"]
[]
[null,"Is the company indebted to the Economic Development Agency of Canada or other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"federal organizations?"]
[]
[null,"Are any disputes or notices of objection outstanding in respect of the Canada Revenue Agency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"or Revenu Québec?"]
[null,"(if so, append the details to your application)"]
[]
[]
["1.3 ","INFORMATION ON THE FINANCIAL INSTITUTION"]
[]
[null,"Name of lender (company name):"]
[]
[null,"Address (branch):",null,null,null,null,null,null,null,null,null,null,null,"    Transit number:"]
[]
[]
[]
[null,"Name of person responsible for the account at the financial institution:"]
[]
[null,"Phone:",null,null,null,null,null,null,null,"Fax: "]
[]
["1.4 ","INFORMATION ON PRIOR YEAR  SR&ED TAX CREDIT CLAIMS"]
[]
[null,null,"Results of prior claims: "]
[]
[null,null,"During the last five years, indicate the most recent year a scientific audit was carried out."]
[null,null,"Fiscal year: ",null,null,null,null,null,"Conclusions : ",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"(yyyy-mm-dd)"]
[null,null,"During the last five years, indicate the most recent year a financial audit was carried out."]
[null,null,"Fiscal year:",null,null,null,null,null,"Conclusions: "]
[null,null,null,null,null,"(yyyy-mm-dd)"]
[null,null,"3 year claim history"]
[]
[null,null,"Year","Level",null,null,"Amount claimed ",null,null,"Date SR&ED claim filed ",null,"  Amount received",null,null,"Date"]
[]
[null,null,null,"Federal"]
[null,null,null,"Provincial"]
[null,null,null,"Federal"]
[null,null,null,"Provincial"]
[null,null,null,"Federal"]
[null,null,null,"Provincial"]
[]
["1.5 ","SR&ED PROJECTS "]
[]
[null,null,"A more detailed description of each project may be appended, where available (see Item D under Additional Documents of the instructions tab)"]
[]
[null,null,"Projects","Project title and brief description (maximum of five projects)",null,null,null,null,null,null,null,null,null,"Start date      ","End date "]
[null,null,1]
[]
[]
[null,null,2]
[]
[]
[null,null,3]
[]
[]
[null,null,4]
[]
[]
[null,null,5]
[]
[]
[]
[]
[]
["1.6 ","SHAREHOLDERS AND SENIOR MANAGEMENT"]
[]
[null,"First name, last name and address",null,null,null,null,"Title or position within company (if shareholder but not employed by company, write n/a)",null,null,null,"Industry experience (# of years)",null,"Time with company   \n(# of years)",null,"% of voting shares held",null,"CV\nAppended"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[]
[null,null,null,null,null,null,"Specify"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total :",{"$f":"IF(SUM(O121:P140)=0,\"\",SUM(O121:P140))","v":""}]

{"sheet":"Year 1 - To fill","index":2,"n_rows":189,"n_cols":28,"rows_kept":189,"cut":false,"hidden":false,"merged":[[20,7,20,9],[21,3,21,9],[18,2,18,9],[22,9,24,13],[0,7,0,13],[8,2,8,7],[9,2,9,7],[0,1,0,5],[2,0,2,13],[3,0,3,13],[4,2,4,8],[131,18,131,20],[133,18,133,20],[132,18,132,20],[31,11,32,11],[34,11,35,11],[76,1,76,11],[55,2,55,8],[62,2,62,8],[51,2,51,8],[53,2,53,8],[56,2,56,8],[57,2,57,8],[52,2,52,8],[41,1,41,13]]}
[null,null,null,null,null,null,null,"Financing of Refundable SR&ED Tax Credits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"For fiscal year containing June 4th, 2014"]
["LOAN / GUARANTEE APPLICATION"]
["Calculations for tax credits to be financed (year 1)"]
[null,null,{"$f":"'General information - To fill'!I9","v":0},null,null,null,null,null,null,null,{"$f":"'General information - To fill'!I5","v":"Nº. Organisation"},{"$f":"'General information - To fill'!L5","v":0},null,{"$f":"'General information - To fill'!M5","v":"Nº. Dossier"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RNumeroConfirmationDemande<>\"\",\"Nº. Demande\",\"\")","v":""},{"$f":"ANumeroConfirmationDemande","v":0},null,{"$f":"IF(RDateTransmissionDemande<>\"\",\"transmis le\",\"\")","v":""},null,null,null,null,null,null,"Québec applicable rate",null,null,null,null,null,null,"Yes"]
[null,"2.0 ELIGIBILITY FOR REFUNDABLE SR&ED TAX CREDITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(MONTH(DATE(YEAR(RCalculDateDebut1),2,29)) =2,MONTH(RCalculDateDebut1)<3),TRUE,FALSE)","v":true},null,null,"net eligible expenditures under $3,000,000 ",null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"(yyyy-mm-dd)",null,null,null,null,null,{"$f":"IF(AND(MONTH(DATE(YEAR(RCalculDateFin1),2,29)) =2,MONTH(RCalculDateFin1)>2),TRUE,FALSE)","v":false},null,null,"(based on assets as per financial statements)"]
[null,null,"Fiscal year to be financed:",null,null,null,null,null,null,"Start date :",null,null,{"$f":"\"   Warming :\"","v":"   Warming :"},null,null,null,null,{"$f":"RCalculDateFin1-RCalculDateDebut1","v":0},{"$f":"IF(OR(R7=TRUE,R8=TRUE),365,364)","v":365},null,"Net eligible expenditures"]
[null,null," (starting after December 31, 2012)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(example)",null,"Before June 4th, 2014","After June 4th,2014"]
[null,null,null,null,null,null,null,null,null,"End date",null,null,{"$f":"\"   doesn't represent 12 months\"","v":"   doesn't represent 12 months"},null,null,null,null,null,null,null,null,1,0.375,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000000,0.375,0.3]
[null,"2.1 ELIGIBILITY FOR REFUNDABLE SR&ED TAX CREDITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000000,0.375,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55000000,0.33500000000000002,0.26800000000000002]
[null,null,null,null,null,null,null,null,null,"The company submitting the application is a Canadian corporation ",null,null,null,null,null,null,null,3,null,null,null,60000000,0.29499999999999998,0.23599999999999999]
[null,null,null,null,null,null,null,null,null,"(as defined by the Québec Tax Act)",null,null,null,null,null,null,null,null,null,null,null,65000000,0.255,0.20399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70000000,0.215,0.17199999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75000000,0.17499999999999999,0.14000000000000001]
[null,null,"Assets as per financial statements (year preceding the fiscal year):",null,null,null,null,null,null,null,"$",null,null,null,null,null,null,{"$f":"ROUND(0.375-((MAX(25000000,(MIN(50000000,L19)))-25000000)*0.2)/25000000,4)","v":0.17499999999999999},null,null,"* The rate for eligible expenditures exceeding the limit of $ 3,000,000 is between 14% and 17.5%"]
[]
[null,null,null,null,null,null,null,"as at: "]
[null,null,null,"(If the company is a start-up, enter $1)",null,null,null,null,null,null,null,{"$f":"L8","v":"(yyyy-mm-dd)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(RONindicateurCorporationControlCanadienQuebec1=2,\"You have indicated you are not a canadian controlled corporation above, a such the answer bellow has to be no\",0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RCalculDateFin1-DATE(2008,3,13)","v":-39520}]
[null,null,"The company is a Canadian-controlled private corporation throughout the ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SaisiTerminer,IF(RCalculDateFin1>DATE(2008,3,13),IF(RCalculDateFin1>DATE(2009,3,13),3000000,ROUND(2000000+((RCalculDateFin1-DATE(2008,3,13))*(1000000/365)),0)),2000000),3000000)","v":3000000}]
[null,null,"taxation year, and taxable income and taxable capital for the year preceding"]
[null,null,"the fiscal year were less than $800,000 and $50,000,000, respectively"]
[null,null,"(including associated companies, if applicable)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(0.375-((MAX(50000000,(MIN(75000000,L19)))-50000000)*0.4)/50000000,4)","v":0.17499999999999999},{"$f":"ROUND(0.3-((MAX(50000000,(MIN(75000000,L19)))-50000000)*0.4)/62500000,4)","v":0.14000000000000001},{"$f":"(R30*'Calculation Details'!S10/365)+(S30*'Calculation Details'!T10/365)","v":4.0081232876712285}]
[null,null,null,null,null,null,null,null,null,"Taxable income according to the income tax return:","$"]
[null,null,null,null,null,null,null,null,null,"(year preceding the fiscal year)"]
[]
[null,null,null,null,null,null,null,null,null,"Taxable capital:","$"]
[null,null,null,null,null,null,null,null,null,"(year preceding the fiscal year)"]
[]
[null,null,null,null,null,null,null,null,null,"as at:",null,{"$f":"IF(S37=2,\"\",IF(L21=\"\",\"\",L21))","v":""},null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L8","v":"(yyyy-mm-dd)"},null,null,null,null,null,800000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"500000*((40000000-(RcapitaleImposableCanada1-10000000))/40000000)","v":625000}]
[null,"2.2 COST OF SR&ED PROJECT (in $) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(L31<>\"\",L31<>1,L31<>0),AND(L19<>\"\",L19<>1,L19<>0)),TRUE,FALSE)","v":false},"Revenus imposables saisis (Année précédente existente)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Fiscal year"]
[null,null,null,null,null,null,null,null,null,"Start date: ",null,{"$f":"RCalculDateDebut1","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"End date: ",null,{"$f":"RCalculDateFin1","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"(# of months) ",null,{"$f":"IF(ISERROR(+(L46-L45)/30.42),\"\",+(L46-L45)/30.42)","v":0}]
[]
[null,null,"Salaries of employees other than specified employees (Line 300 of the T661)"]
[null,null,"Salaries of specified employees (Line 305 of the T661)"]
[null,null,"Salaries of support staff (for Revenu Québec purposes) (Line 43 of the RD-222)"]
[null,null,"Costs of materials consumed and/or transformed (Lines 320 and 325 of the T661)"]
[null,null,"Arm’s-length contracts (Subcontractors) (Line 340 of the T661)"]
[null,null,"Non-arm’s-length contracts (Subcontractors) (Line 345 of the T661)"]
[null,null,"Lease costs of equipment used before January 1, 2014 (Line 350 and 355 of the T661)"]
[null,null,"Overhead and other expenditures (enter “0” if you use the proxy method) (Line 360 of the T661)"]
[null,null,"Third-party payments (Line 370 of the T661)"]
[null,null,"Capital expenditures for depreciable property available for use before January 1, 2014 (Line 390 of the T661)"]
[]
[]
[null,null,"Less: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L31<R41,L34<40000000),FALSE,TRUE)","v":false},"Si un plafond est applicable"]
[null,null,"Any assistance related to SR&ED expenditures"]
[null,null,"Taxable bonuses and benefits related to salaries of SR&ED employees (Line 812 of the T661)"]
[null,null,"Any assistance related to SR&ED capital expenditures "]
[null,null,"Reduction of qualified wages due to other tax credits in Québec, e.g. CDAE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($L34-10000000)>0,$L34-10000000,0)","v":0}]
[null,null,"Federal income tax payable, net of tax instalments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($R66/(R39-10000000),4)","v":0}]
[null,null,"Provincial income tax payable, net of tax instalments"]
[]
[]
[]
[null,null,{"$f":"'Calculation Details'!C79:I79","v":"Québec refundable SR&ED tax credits:"},null,null,null,null,null,null,null,null,{"$f":"'Calculation Details'!L79","v":0}]
[]
[null,null,{"$f":"'Calculation Details'!C146","v":"Federal refundable SR&ED tax credits:"},null,null,null,null,null,null,null,null,{"$f":"'Calculation Details'!L146","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL*",null,{"$f":"L74+L72","v":{"$error":"#VALUE!"}}]
[null,"Please note that the definitions have been simplified for the understanding of users and thus may not reflect all situations. The final tax credit amounts as assessed by the CRA and RQ may differ from the amounts calculated herein due to specific circumstances. These calculations are provided as examples only and are in no way binding on Investissement Québec. Investissement Québec reserves the right to make adjustments if deemed necessary."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L9<>\"\",L11<>\"\"),TRUE,FALSE)","v":false},"Si des dates ont été saisies"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SaisiTerminer,IF(DateChevauch1,S133,S134),S132)","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},"Restant pour dépenses en capital"]

{"sheet":"Year 2 - To fill","index":3,"n_rows":189,"n_cols":28,"rows_kept":189,"cut":false,"hidden":false,"merged":[[22,9,24,13],[0,1,0,5],[0,7,0,13],[4,2,4,8],[2,0,2,13],[3,0,3,13],[8,2,8,7],[9,2,9,7],[18,2,18,9],[20,7,20,9],[21,3,21,9],[132,18,132,20],[133,18,133,20],[56,2,56,8],[31,11,32,11],[34,11,35,11],[41,1,41,13],[51,2,51,8],[52,2,52,8],[55,2,55,8],[53,2,53,8],[57,2,57,8],[62,2,62,8],[76,1,76,11],[131,18,131,20]]}
[null,null,null,null,null,null,null,"Financing of Refundable SR&ED Tax Credits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"For fiscal year containing June 4th, 2014"]
["LOAN / GUARANTEE APPLICATION"]
["Calculations for tax credits to be financed (year 2)"]
[null,null,{"$f":"'General information - To fill'!I9","v":0},null,null,null,null,null,null,null,{"$f":"'General information - To fill'!I5","v":"Nº. Organisation"},{"$f":"'General information - To fill'!L5","v":0},null,{"$f":"'General information - To fill'!M5","v":"Nº. Dossier"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RNumeroConfirmationDemande<>\"\",\"Nº. Demande\",\"\")","v":""},{"$f":"ANumeroConfirmationDemande","v":0},null,{"$f":"IF(RDateTransmissionDemande<>\"\",\"transmis le\",\"\")","v":""},null,null,null,null,null,null,"Québec applicable rate",null,null,null,null,null,null,"Yes"]
[null,"2.0 ELIGIBILITY FOR REFUNDABLE SR&ED TAX CREDITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(MONTH(DATE(YEAR(RCalculDateDebut1),2,29)) =2,MONTH(RCalculDateDebut1)<3),TRUE,FALSE)","v":true},null,null,"net eligible expenditures under $3,000,000 ",null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"(yyyy-mm-dd)",null,null,null,null,null,{"$f":"IF(AND(MONTH(DATE(YEAR(RCalculDateFin1),2,29)) =2,MONTH(RCalculDateFin1)>2),TRUE,FALSE)","v":false},null,null,"(based on assets as per financial statements)"]
[null,null,"Fiscal year to be financed:",null,null,null,null,null,null,"Start date :",null,null,{"$f":"\"   Warning :\"","v":"   Warning :"},null,null,null,null,{"$f":"RCalculDateFin1-RCalculDateDebut1","v":0},{"$f":"IF(OR(R7=TRUE,R8=TRUE),365,364)","v":365},null,"Net eligible expenditures"]
[null,null," (starting after December 31, 2012)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(example)",null,"Before June 4th, 2014","After June 4th,2014"]
[null,null,null,null,null,null,null,null,null,"End date",null,null,{"$f":"\"   does not represent 12 months\"","v":"   does not represent 12 months"},null,null,null,null,null,null,null,null,1,0.375,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000000,0.375,0.3]
[null,"2.1 ELIGIBILITY FOR REFUNDABLE SR&ED TAX CREDITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000000,0.375,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55000000,0.33500000000000002,0.26800000000000002]
[null,null,null,null,null,null,null,null,null,"The company submitting the application is a Canadian corporation ",null,null,null,null,null,null,null,3,null,null,null,60000000,0.29499999999999998,0.23599999999999999]
[null,null,null,null,null,null,null,null,null,"(as defined by the Québec Tax Act)",null,null,null,null,null,null,null,null,null,null,null,65000000,0.255,0.20399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70000000,0.215,0.17199999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75000000,0.17499999999999999,0.14000000000000001]
[null,null,"Assets as per financial statements (year preceding the fiscal year):",null,null,null,null,null,null,null,"$",null,null,null,null,null,null,{"$f":"ROUND(0.375-((MAX(25000000,(MIN(50000000,L19)))-25000000)*0.2)/25000000,4)","v":0.17499999999999999},null,null,"* The rate for eligible expenditures exceeding the limit of $ 3,000,000 is between 14% and 17.5%"]
[]
[null,null,null,null,null,null,null,"as at: "]
[null,null,null,"(If the company is a start-up, enter $1)",null,null,null,null,null,null,null,"(yyyy-mm-dd)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(RONindicateurCorporationControlCanadienQuebec1=2,\"You have indicated you are not a canadian controlled corporation above, a such the answer bellow has to be no\",0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RCalculDateFin1-DATE(2008,3,13)","v":-39520}]
[null,null,"The company is a Canadian-controlled private corporation throughout the ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SaisiTerminer,IF(RCalculDateFin1>DATE(2008,3,13),IF(RCalculDateFin1>DATE(2009,3,13),3000000,ROUND(2000000+((RCalculDateFin1-DATE(2008,3,13))*(1000000/365)),0)),2000000),3000000)","v":3000000}]
[null,null,"taxation year, and taxable income and taxable capital for the year preceding"]
[null,null,"the fiscal year were less than $800,000 and $50,000,000, respectively"]
[null,null,"(including associated companies, if applicable)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(0.375-((MAX(50000000,(MIN(75000000,L19)))-50000000)*0.4)/50000000,4)","v":0.17499999999999999},{"$f":"ROUND(0.3-((MAX(50000000,(MIN(75000000,L19)))-50000000)*0.4)/62500000,4)","v":0.14000000000000001},{"$f":"(R30*'Calculation Details'!S30/365)+(S30*'Calculation Details'!T30/365)","v":4.0081232876712285}]
[null,null,null,null,null,null,null,null,null,"Taxable income according to the income tax return:","$"]
[null,null,null,null,null,null,null,null,null,"(year preceding the fiscal year)"]
[]
[null,null,null,null,null,null,null,null,null,"Taxable capital:","$"]
[null,null,null,null,null,null,null,null,null,"(year preceding the fiscal year)"]
[]
[null,null,null,null,null,null,null,null,null,"as at:",null,{"$f":"IF(R37=2,\"\",IF(L21=\"\",\"\",L21))","v":""},null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,"(yyyy-mm-dd)",null,null,null,null,null,800000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"500000*((40000000-(RcapitaleImposableCanada1-10000000))/40000000)","v":625000}]
[null,"2.2 COST OF SR&ED PROJECT (in $) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(L31<>\"\",L31<>1,L31<>0),AND(L19<>\"\",L19<>1,L19<>0)),TRUE,FALSE)","v":false},"Revenus imposables saisis (Année précédente existente)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Fiscal year"]
[null,null,null,null,null,null,null,null,null,"Start date: ",null,{"$f":"RCalculDateDebut1","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"End date: ",null,{"$f":"RCalculDateFin1","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"(# of months) ",null,{"$f":"IF(ISERROR(+(L46-L45)/30.42),\"\",+(L46-L45)/30.42)","v":0}]
[]
[null,null,"Salaries of employees other than specified employees (Line 300 of the T661)"]
[null,null,"Salaries of specified employees (Line 305 of the T661)"]
[null,null,"Salaries of support staff (for Revenu Québec purposes) (Line 43 of the RD-222)"]
[null,null,"Costs of materials consumed and/or transformed (Lines 320 and 325 of the T661)"]
[null,null,"Arm’s-length contracts (Subcontractors) (Line 340 of the T661) "]
[null,null,"Non-arm’s-length contracts (Subcontractors) (Line 345 of the T661)"]
[null,null,"Lease costs of equipment used before January 1, 2014 (Line 350 asnd 355 of the T661)"]
[null,null,"Overhead and other expenditures (enter “0” if you use the proxy method) (Line 360 of the T661)"]
[null,null,"Third-party payments (Line 370 of the T661)"]
[null,null,"Capital expenditures for depreciable property available for use before January 1, 2014 (Line 390 of the T661)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L31<R41,L34<40000000),FALSE,TRUE)","v":false},"Si un plafond est applicable"]
[null,null,"Less: "]
[null,null,"Any assistance related to SR&ED expenditures"]
[null,null,"Taxable bonuses and benefits related to salaries of SR&ED employees (Line 812 of the T661)"]
[null,null,"Any assistance related to SR&ED capital expenditures "]
[null,null,"Reduction of qualified wages due to other tax credits in Québec, e.g. CDAE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($L34-10000000)>0,$L34-10000000,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($R65/(R39-10000000),4)","v":0}]
[null,null,"Federal income tax payable, net of tax instalments"]
[null,null,"Provincial income tax payable, net of tax instalments"]
[]
[]
[]
[null,null,{"$f":"'Calculation Details'!C79:I79","v":"Québec refundable SR&ED tax credits:"},null,null,null,null,null,null,null,null,{"$f":"'Calculation Details'!O79","v":0}]
[]
[null,null,{"$f":"'Calculation Details'!C146","v":"Federal refundable SR&ED tax credits:"},null,null,null,null,null,null,null,null,{"$f":"'Calculation Details'!O146","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL*",null,{"$f":"L74+L72","v":{"$error":"#VALUE!"}}]
[null,"Please note that the definitions have been simplified for the understanding of users and thus may not reflect all situations. The final tax credit amounts as assessed by the CRA and RQ may differ from the amounts calculated herein due to specific circumstances. These calculations are provided as examples only and are in no way binding on Investissement Québec. Investissement Québec reserves the right to make adjustments if deemed necessary."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L9<>\"\",L11<>\"\"),TRUE,FALSE)","v":false},"Si des dates ont été saisies"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SaisiTerminer,IF(DateChevauch1,S133,S134),S132)","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},"Restant pour dépenses en capital"]

{"sheet":"Calculation Details","index":4,"n_rows":146,"n_cols":27,"rows_kept":146,"cut":false,"hidden":false,"merged":[[0,8,0,15],[35,14,36,14],[89,3,89,8],[91,3,91,8],[48,3,48,8],[55,3,55,8],[57,3,57,8],[28,11,28,12],[53,3,53,8],[53,9,54,9],[53,11,54,11],[54,3,54,7],[35,11,36,11],[6,2,6,9],[10,11,10,12],[11,2,11,9],[53,14,54,14],[119,2,119,10],[69,2,69,8],[71,2,71,7],[124,2,124,7],[78,2,78,8],[12,11,12,12],[26,11,26,12],[58,3,58,8],[93,3,93,8],[133,2,133,9],[123,2,123,10]]}
[" ",null,null,null,null,null,null,null,"Financing of Refundable SR&ED Tax Credits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For fiscal year containing June 4th, 2014"]
[null,null,null,null,null,null,null,null,"LOAN / GUARANTEE APPLICATION"]
[null,null,"For use by Investissement Québec",null,null,null,null,null,"Calculations of SR&ED tax credits "]
[null,null,"Québec - Applicable rates for the calculation of SR&ED tax credits ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNÉE 1"]
[]
[null,null,"Applicable rate for calculating SR&ED tax credits on eligible expenditures (Québec):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Split year 12-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-04"]
[null,null,null,null,null,null,null,null,null,"Start date:",null,{"$f":"RCalculDateDebut1","v":"00:00:00"},null,null,{"$f":"'Year 2 - To fill'!RCalculDateDebut1","v":"00:00:00"},null,null,null,"Jours 2012","Jours 2013"]
[null,null,null,null,null,null,null,null,null,"End date:",null,{"$f":"RCalculDateFin1","v":"00:00:00"},null,null,{"$f":"'Year 2 - To fill'!RCalculDateFin1","v":"00:00:00"},null,null,null,{"$f":"S8-RCalculDateDebut1+1","v":41795},{"$f":"RCalculDateFin1-'Calculation Details'!S8","v":-41794}]
[]
[null,null,"Applicable rate for eligible expenditures not exceeding the expenditure limit of $3,000,000",null,null,null,null,null,null,null,null,{"$f":"V22","v":0},null,null,{"$f":"V42","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Applicable rate for eligible expenditures exceeding the expenditure limit of $3,000,000",null,{"$f":"T22","v":0.17499999999999999},null,null,{"$f":"T42","v":0.17499999999999999}]
[]
[]
[null,null,"Federal - Calculation of expenditure limit  for  enhanced refundable SR&ED tax credits: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avant 06.04.2014",{"$f":"IF((RCalculDateFin1<DATE(2014,6,1)),0.175,0)","v":0.17499999999999999},"Avant 06.04.2014",{"$f":"IF((RCalculDateFin1<DATE(2014,6,1)),'Calculation Details'!W18,0)","v":0},{"$f":"IF(RONindicateurCorporationControlCanadienQuebec1=2,0.175,IF(OR(RmontantEtatFinancierQuebec1=\"\",RmontantEtatFinancierQuebec1=0),0,IF(AND(RmontantEtatFinancierQuebec1>0,'Year 1 - To fill'!R30>0,'Year 1 - To fill'!SaisiTerminer),'Year 1 - To fill'!R30,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entre",{"$f":"IF(AND(RCalculDateDebut1>=DATE(2013,7,1),RCalculDateDebut1<DATE(2014,6,1)),0.175*S10/365+0.14*T10/365,0)","v":0},"Entre",{"$f":"IF(AND(RCalculDateDebut1>=DATE(2013,7,1),RCalculDateDebut1<DATE(2014,6,1)),'Calculation Details'!W19,0)","v":0},{"$f":"IF(RONindicateurCorporationControlCanadienQuebec1=2,(0.175*S10/365+0.14*T10/365),IF(OR(RmontantEtatFinancierQuebec1=\"\",RmontantEtatFinancierQuebec1=0),0,IF(AND(RmontantEtatFinancierQuebec1>0,'Year 1 - To fill'!T30>0,'Year 1 - To fill'!SaisiTerminer),'Year 1 - To fill'!T30,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apres",{"$f":"IF(RCalculDateDebut1>=DATE(2014,6,1),0.14,0)","v":0},"Apres",{"$f":"IF(RCalculDateDebut1>=DATE(2014,6,1),W20,0)","v":0},{"$f":"IF(RONindicateurCorporationControlCanadienQuebec1=2,0.14,IF(OR(RmontantEtatFinancierQuebec1=\"\",RmontantEtatFinancierQuebec1=0),0,IF(AND(RmontantEtatFinancierQuebec1>0,'Year 1 - To fill'!S30>0,'Year 1 - To fill'!SaisiTerminer),'Year 1 - To fill'!S30,0)))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taux +3million",{"$f":"SUM(T18:T20)","v":0.17499999999999999},"Taux -3million",{"$f":"SUM(V18:V20)","v":0}]
[null,null,null,"Maximum",null,null,null,null,null,null,null,{"$f":"800000*10","v":8000000},null," $",{"$f":"800000*10","v":8000000}]
[null,null,null,"Less the higher of:"]
[null,null,null,"10 times $500,000 or ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anne 2"]
[null,null,null,"10 times the taxable income of the preceding year:",null,null,null,null,null,null,null,{"$f":"IF('Year 1 - To fill'!SaisiTerminer,IF(10*RmontantImposableDeclarationFiscaleCanada1>500000*10,RmontantImposableDeclarationFiscaleCanada1*10,500000*10),0)","v":0},null," $",{"$f":"IF('Year 2 - To fill'!SaisiTerminer,IF(10*'Year 2 - To fill'!RmontantImposableDeclarationFiscaleCanada1>500000*10,'Year 2 - To fill'!RmontantImposableDeclarationFiscaleCanada1*10,500000*10),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Split year 12-13"]
[null,null,null,"Expenditure limit:",null,null,null,null,null,null,null,{"$f":"IF('Year 1 - To fill'!S80,IF((L23-L26)>0,(L23-L26),0.000001),0)","v":0},null," $",{"$f":"IF('Year 2 - To fill'!S80,IF((O23-O26)>0,(O23-O26),0.000001),0)","v":0},null,null,null,"2014-06-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jours 2012","Jours 2013"]
[null,null,null,"Adjustment related to taxable capital:",null,null,null,null,null,null,null,{"$f":"IF('Year 1 - To fill'!S80,(1-'Year 1 - To fill'!R67)*100+0.000001,0)","v":0},"%"," %",{"$f":"IF('Year 2 - To fill'!S80,(1-'Year 2 - To fill'!R66)*100+0.000001,0)","v":0},"%",null,null,{"$f":"S28-'Year 2 - To fill'!RCalculDateDebut1+1","v":41795},{"$f":"'Year 2 - To fill'!RCalculDateFin1-'Calculation Details'!S28","v":-41794}]
[null,null,null,"(based on the preceding year’s taxable capital)"]
[]
[null,null,null,"Expenditure limit:",null,null,null,null,null,null,null,{"$f":"IF('Year 1 - To fill'!SaisiTerminer,IF(RONindicateurCorporationControlCanadienCanada1=2,0.000001,IF(L28*(1-'Year 1 - To fill'!R67)>0,L28*(1-'Year 1 - To fill'!R67),0.000001)),0)","v":0},null," $",{"$f":"IF('Year 2 - To fill'!SaisiTerminer,IF('Year 2 - To fill'!RONindicateurCorporationControlCanadienQuebec1=2,0.000001,IF(O28*(1-'Year 2 - To fill'!R66)>0,O28*(1-'Year 2 - To fill'!R66),0.000001)),0)","v":0}]
[]
[]
[null,null,"SR&ED tax credits on expenditures in excess of the expenditure limit:",null,null,null,null,null,null,null,null,{"$f":"IF('Year 1 - To fill'!S80=FALSE,\"\",IF(OR('Year 1 - To fill'!S61,'Year 1 - To fill'!R37=2),\"Non refundable\",\"Refundable at 40%\"))","v":""},null,{"$f":"IF('Year 1 - To fill'!SaisiTerminer= FALSE,\" ( Remboursables ou non )\",\"\")","v":" ( Remboursables ou non )"},{"$f":"IF('Year 2 - To fill'!S80=FALSE,\"\",IF(OR('Year 2 - To fill'!S60,'Year 2 - To fill'!R37=2),\"Non refundable\",\"Refundable at 40%\"))","v":""}]
[null,null,"'Refundable if the taxable income of the preceding year is < $500,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avant 06.04.2014",{"$f":"IF(('Year 2 - To fill'!RCalculDateFin1<DATE(2014,6,1)),0.175,0)","v":0.17499999999999999},"Avant 06.04.2014",{"$f":"IF(('Year 2 - To fill'!RCalculDateFin1<DATE(2014,6,1)),W38,0)","v":0},{"$f":"IF('Year 2 - To fill'!RONindicateurCorporationControlCanadienQuebec1=2,0.175,IF(OR('Year 2 - To fill'!RmontantEtatFinancierQuebec1=\"\",'Year 2 - To fill'!RmontantEtatFinancierQuebec1=0),0,IF(AND('Year 2 - To fill'!RmontantEtatFinancierQuebec1>0,'Year 2 - To fill'!R30>0,'Year 2 - To fill'!SaisiTerminer),'Year 2 - To fill'!R30,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entre",{"$f":"IF(AND('Year 2 - To fill'!RCalculDateDebut1>=DATE(2013,7,1),'Year 2 - To fill'!RCalculDateDebut1<DATE(2014,6,1)),0.175*S30/365+0.14*T30/365,0)","v":0},"Entre",{"$f":"IF(AND('Year 2 - To fill'!RCalculDateDebut1>=DATE(2013,7,1),'Year 2 - To fill'!RCalculDateDebut1<DATE(2014,6,1)),W39,0)","v":0},{"$f":"IF('Year 2 - To fill'!RONindicateurCorporationControlCanadienQuebec1=2,0.175*S30/365+0.14*T30/365,IF(OR('Year 2 - To fill'!RmontantEtatFinancierQuebec1=\"\",'Year 2 - To fill'!RmontantEtatFinancierQuebec1=0),0,IF(AND('Year 2 - To fill'!RmontantEtatFinancierQuebec1>0,'Year 2 - To fill'!T30>0,'Year 2 - To fill'!SaisiTerminer),'Year 2 - To fill'!T30,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apres",{"$f":"IF('Year 2 - To fill'!RCalculDateDebut1>=DATE(2014,6,1),0.14,0)","v":0},"Apres",{"$f":"IF('Year 2 - To fill'!RCalculDateDebut1>=DATE(2014,6,1),W40,0)","v":0},{"$f":"IF('Year 2 - To fill'!RONindicateurCorporationControlCanadienQuebec1=2,0.14,IF(OR('Year 2 - To fill'!RmontantEtatFinancierQuebec1=\"\",'Year 2 - To fill'!RmontantEtatFinancierQuebec1=0),0,IF(AND('Year 2 - To fill'!RmontantEtatFinancierQuebec1>0,'Year 2 - To fill'!S30>0,'Year 2 - To fill'!SaisiTerminer),'Year 2 - To fill'!S30,0)))","v":0}]
[null,null,"CALCULATION OF SR&ED TAX CREDITS THAT MAY BE FINANCED (in $)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taux +3million",{"$f":"SUM(T38:T40)","v":0.17499999999999999},"Taux -3million",{"$f":"SUM(V38:V40)","v":0}]
[null,null,"Calculation of Québec SR&ED tax credits"]
[]
[null,null,"Calculation of eligible current expenditures",null,null,null,null,null,null,null,null,"Fiscal year",null,null,"Fiscal year"]
[null,null,null,null,null,null,null,null,null,"Start date:",null,{"$f":"L9","v":"00:00:00"},null,null,{"$f":"O9","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"End date:",null,{"$f":"L10","v":"00:00:00"},null,null,{"$f":"O10","v":"00:00:00"}]
[]
[null,null,null,{"$f":"'Year 1 - To fill'!C49","v":"Salaries of employees other than specified employees (Line 300 of the T661)"},null,null,null,null,null,null,null,{"$f":"Ligne300","v":0},null,null,{"$f":"'Year 2 - To fill'!Ligne300","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C50","v":"Salaries of specified employees (Line 305 of the T661)"},null,null,null,null,null,null,null,{"$f":"Ligne305","v":0},null,null,{"$f":"'Year 2 - To fill'!L50","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C51","v":"Salaries of support staff (for Revenu Québec purposes) (Line 43 of the RD-222)"},null,null,null,null,null,null,null,{"$f":"'Year 1 - To fill'!L51","v":0},null,null,{"$f":"'Year 2 - To fill'!Ligne320","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C53","v":"Arm’s-length contracts (Subcontractors) (Line 340 of the T661)"},null,null,null,null,null,null,null,{"$f":"Ligne340*0.5","v":0},null,null,{"$f":"'Year 2 - To fill'!Ligne345*0.5","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C54","v":"Non-arm’s-length contracts (Subcontractors) (Line 345 of the T661)"},null,null,null,null,null,null,null,{"$f":"Ligne345","v":0},null,null,{"$f":"'Year 2 - To fill'!LocationMat","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C57","v":"Third-party payments (Line 370 of the T661)"},null,null,null,null,null,null,null,{"$f":"'Year 1 - To fill'!L57*I55","v":0},null,null,{"$f":"'Year 2 - To fill'!L57*I55","v":0}]
[null,null,null,"Eligible at:",null,null,null,null,0.5]
[]
[null,null,null,"Less:"]
[null,null,null,{"$f":"'Year 1 - To fill'!C62","v":"Any assistance related to SR&ED expenditures"},null,null,null,null,null,null,null,{"$f":"MoinAide","v":0},null,null,{"$f":"'Year 2 - To fill'!L62","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C65","v":"Reduction of qualified wages due to other tax credits in Québec, e.g. CDAE"},null,null,null,null,null,null,null,{"$f":"'Year 1 - To fill'!L65","v":0},null,null,{"$f":"'Year 2 - To fill'!L65","v":0}]
[null,null,null,"IQ","Minus other amounts:"]
[null,null,null,"adjustments","Plus other amounts:"]
[null,null,null,"Net eligible expenditures:",null,null,null,null,null,null,null,{"$f":"SUM(L49:L55)-SUM(L58:L60)+L61","v":0},null,null,{"$f":"SUM(O49:O55)-SUM(O58:O60)+O61","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Fiscal year",null,null,"Fiscal year"]
[null,null,"Calculation of Québec refundable SR&ED  tax credits",null,null,null,null,null,null,"Start date:",null,{"$f":"L46","v":"00:00:00"},null,null,{"$f":"O46","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"End date:",null,{"$f":"L47","v":"00:00:00"},null,null,{"$f":"O47","v":"00:00:00"}]
[]
[null,null,"Credit  year 1 and year 2 :",null,null,null,null,null,null,null,null,{"$f":"IF(L62>3000000,ROUND(3000000*'Calculation Details'!L12,0),ROUND(L62*'Calculation Details'!L12,0))","v":0},null,null,{"$f":"IF(O62>3000000,ROUND(3000000*'Calculation Details'!O12,0),ROUND(O62*'Calculation Details'!O12,0))","v":0}]
[null,null,"for eligible expenditures equal to or less than the expenditure limit"]
[null,null,"Credit  year 1 and year 2 :",null,null,null,null,null,null,null,null,{"$f":"IF(L62>3000000,ROUND((L62-3000000)*L14,0),0)","v":0},null,null,{"$f":"IF(O62>3000000,ROUND((O62-3000000)*O14,0),0)","v":0}]
[null,null,"for eligible expenditures in excess of  the expenditure limit"]
[null,null,{"$f":"'Year 1 - To fill'!C68","v":"Provincial income tax payable, net of tax instalments"},null,null,null,null,null,null,null,null,{"$f":"'Year 1 - To fill'!L68","v":0},null,null,{"$f":"'Year 2 - To fill'!L68","v":0}]
[]
[null,null,null,"IQ","Minus other amounts:"]
[null,null,null,"adjustments","Plus other amounts:"]
[]
[null,null,"Québec refundable SR&ED tax credits:",null,null,null,null,null,null,null,null,{"$f":"SUM(L70:L72)-L74-L76+L77","v":0},null,null,{"$f":"SUM(O70:O72)-O74-O76+O77","v":0}]
[]
[]
[]
[]
[null,null,"Calculation of Federal SR&ED  tax credits"]
[]
[null,null,"Calculation of eligible current expenditures"]
[null,null,null,null,null,null,null,null,null,"Start date:",null,{"$f":"L67","v":"00:00:00"},null,null,{"$f":"O67","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"End date:",null,{"$f":"L68","v":"00:00:00"},null,null,{"$f":"O68","v":"00:00:00"}]
[]
[null,null,null,{"$f":"'Year 1 - To fill'!C49","v":"Salaries of employees other than specified employees (Line 300 of the T661)"},null,null,null,null,null,null,null,{"$f":"Ligne300","v":0},null,null,{"$f":"'Year 2 - To fill'!Ligne300","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C50","v":"Salaries of specified employees (Line 305 of the T661)"},null,null,null,null,null,null,null,{"$f":"Ligne305","v":0},null,null,{"$f":"'Year 2 - To fill'!L50","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C52","v":"Costs of materials consumed and/or transformed (Lines 320 and 325 of the T661)"},null,null,null,null,null,null,null,{"$f":"Ligne320","v":0},null,null,{"$f":"'Year 2 - To fill'!Ligne340","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C53","v":"Arm’s-length contracts (Subcontractors) (Line 340 of the T661)"},null,null,null,null,null,null,null,{"$f":"Ligne340*0.8","v":0},null,null,{"$f":"'Year 2 - To fill'!Ligne345*0.8","v":0}]
[null,null,null,{"$f":"'Year 1 - To fill'!C55","v":"Lease costs of equipment used before January 1, 2014 (Line 350 and 355 of the T661)"},null,null,null,null,null,null,null,{"$f":"LocationMat","v":0},null,null,{"$f":"'Year 2 - To fill'!Proxy","v":0},null,null,null,"ANNÉE 1"]
[null,null,null,{"$f":"'Year 1 - To fill'!C57","v":"Third-party payments (Line 370 of the T661)"},null,null,null,null,null,null,null,{"$f":"Tiers*0.8","v":0},null,null,{"$f":"'Year 2 - To fill'!Capital*0.8","v":0}]
[null,null,null,"Calculation of proxy amount/ overhead amount",null,null,null,null,null,null,null,{"$f":"IF(Proxy<>0,V102,IF(Proxy=0,V111,0))","v":0},null,null,{"$f":"IF(Proxy<>0,V122,IF(Proxy=0,V131,0))","v":0},null,null,null,"Split year 12-13",null,"Split year 13-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-12-31",null,"2013-12-31"]
[null,null,null,"Net eligible expenditures:",null,null,null,null,null,null,null,{"$f":"SUM(L90:L96)","v":0},null,null,{"$f":"SUM(O90:O96)","v":0},null,null,null,"Jours 2012","Jours 2013","Jours en 2013","Jours en 2014"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S97-RCalculDateDebut1+1","v":41275},{"$f":"RCalculDateFin1-'Calculation Details'!S97","v":-41274},{"$f":"U97-RCalculDateDebut1+1","v":41640},{"$f":"RCalculDateFin1-'Calculation Details'!U97","v":-41639}]
[null,null,null,"Less:",{"$f":"'Year 1 - To fill'!C62","v":"Any assistance related to SR&ED expenditures"},null,null,null,null,null,null,{"$f":"MoinAide","v":0},null,null,{"$f":"'Year 2 - To fill'!L62","v":0}]
[null,null,null,null,"Québec SR&ED tax credits ",null,null,null,null,null,null,{"$f":"SUM(L70,L72)","v":0},null,null,{"$f":"SUM(O70,O72)","v":0}]
[null,null,null,"IQ","Minus other amounts:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traditional",{"$f":"Proxy","v":0}]
[null,null,null,"adjustments","Plus other amounts:"]
[null,null,null,"Net eligible current expenditures:",null,null,null,null,null,null,null,{"$f":"IF(RONindicateurCorporationControlCanadienQuebec1=2,0.000001,L98+L103-(L100+L101+L102))","v":0},null,null,{"$f":"IF(RONindicateurCorporationControlCanadienQuebec1=2,0.000001,O98+O103-(O102+O100+O101))","v":0},null,null,null,null,null,"Bonification",{"$f":"'Year 1 - To fill'!L63","v":0}]
[]
[]
[null,null,"Calculation of eligible capital expenditures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proxy 2012 - 2013",{"$f":"IF(AND(RCalculDateDebut1>=DATE(2012,1,1),RCalculDateDebut1<DATE(2013,1,1)),'Calculation Details'!W107,0)","v":0},{"$f":"(0.65*((L90+L91-V104)*(S99/(S99+T99)))+(0.6*((L90+L91-V104)*(T99/(T99+S99)))))","v":0},null,"Proxy 2012 - 2013",{"$f":"IF(AND(RCalculDateDebut1>=DATE(2012,1,1),RCalculDateDebut1<DATE(2013,1,1)),'Calculation Details'!AA107,0)","v":0},{"$f":"(0.2*((H139*0.4)*(S99/(S99+T99)))+(0.2*(H139*0.4)*(T99/(S99+T99))))","v":0}]
[null,null,null,null,null,null,null,null,null,"Start date:",null,{"$f":"L87","v":"00:00:00"},null,null,{"$f":"O87","v":"00:00:00"},null,null,null,null,null,"Proxy 2013-2014",{"$f":"IF(AND(RCalculDateDebut1>=DATE(2013,1,1),RCalculDateDebut1<DATE(2014,1,1)),'Calculation Details'!W108,0)","v":0},{"$f":"(0.6*((L90+L91-V104)*(U99/(U99+V99)))+(0.55*((L90+L91-V104)*(V99/(U99+V99)))))","v":0},null,"Proxy 2013-2014",{"$f":"IF(AND(RCalculDateDebut1>=DATE(2013,1,1),RCalculDateDebut1<DATE(2014,1,1)),'Calculation Details'!AA108,0)","v":0},{"$f":"(0.2*((H139*0.4)*(U99/(U99+V99)))+(0.15*((H139*0.4)*(V99/(U99+V99)))))","v":0}]
[null,null,null,null,null,null,null,null,null,"End date:",null,{"$f":"L88","v":"00:00:00"},null,null,{"$f":"O88","v":"00:00:00"},null,null,null,null,null,"Proxy 2014",{"$f":"IF(RCalculDateDebut1>=DATE(2014,1,1),W109,0)","v":0},{"$f":"0.55*((L90+L91-V104))","v":0},null,"Proxy 2014",{"$f":"IF(RCalculDateDebut1>=DATE(2014,1,1),AA109,0)","v":0},{"$f":"0.15*((H139*0.4))","v":0}]
[]
[null,null,null,"Capital expenditures",null,null,null,null,null,null,null,{"$f":"Capital","v":0},null,null,{"$f":"'Year 2 - To fill'!soutien","v":0},null,null,null,null,null,"Total Proxy",{"$f":"SUM(V107:V109)","v":0},null,null,"Total @ 40%",{"$f":"SUM(Z107:Z109)","v":0}]
[null,null,null,"Less:",{"$f":"'Year 1 - To fill'!C64","v":"Any assistance related to SR&ED capital expenditures "},null,null,null,null,null,null,{"$f":"AideCapital","v":0},null,null,{"$f":"'Year 2 - To fill'!L64","v":0}]
[null,null,null,"IQ","Minus other amounts:"]
[null,null,null,"adjustments","Plus other amounts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNÉE 2"]
[null,null,null,"Eligible capital expenditures:",null,null,null,null,null,null,null,{"$f":"IF(RONindicateurCorporationControlCanadienCanada1=2,0.000001,L111+L114-(L112+L113))","v":0},null,null,{"$f":"IF(RONindicateurCorporationControlCanadienCanada1=2,0.000001,O111+O114-(O112+O113))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Split year 12-13",null,"Split year 13-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-12-31",null,"2013-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jours 2012","Jours 2013","Jours en 2013","Jours en 2014"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S117-'Year 2 - To fill'!RCalculDateDebut1+1","v":41275},{"$f":"'Year 2 - To fill'!RCalculDateFin1-'Calculation Details'!S117","v":-41274},{"$f":"U117-'Year 2 - To fill'!RCalculDateDebut1+1","v":41640},{"$f":"'Year 2 - To fill'!RCalculDateFin1-'Calculation Details'!U117","v":-41639}]
[null,null,"Calculation of federal enhanced refundable SR&ED tax credits up to the expenditure limit"]
[]
[null,null,null,null,null,null,null,null,null,"Start date:",null,{"$f":"L87","v":"00:00:00"},null,null,{"$f":"O87","v":"00:00:00"},null,null,null,null,null,"Traditional",{"$f":"'Year 2 - To fill'!Tiers","v":0}]
[null,null,null,null,null,null,null,null,null,"End date:",null,{"$f":"L88","v":"00:00:00"},null,null,{"$f":"O88","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonification",{"$f":"'Year 2 - To fill'!AideCapital","v":0}]
[]
[null,null,null,"Set expenditure limit:",null,null,null,null,null,null,null,{"$f":"IF('Year 1 - To fill'!SaisiTerminer,IF(('Calculation Details'!L33>0),'Calculation Details'!L33,0),0)","v":0},null,null,{"$f":"IF('Year 2 - To fill'!SaisiTerminer,IF(('Calculation Details'!O33>0),'Calculation Details'!O33,0),0)","v":0}]
[null,null,null,null,null,null,null,"Year 1","Year 2",null,null,null,null,null,null,null,null,null,null,null,"Proxy 2012 - 2013",{"$f":"IF(AND('Year 2 - To fill'!RCalculDateDebut1>=DATE(2012,1,1),'Year 2 - To fill'!RCalculDateDebut1<DATE(2013,1,1)),'Calculation Details'!W127,0)","v":0},{"$f":"(0.65*((O90+O91-V124)*(S119/(S119+T119)))+(0.6*((O90+O91-V124)*(T119/(T119+S119)))))","v":0},null,"Proxy 2012 - 2013",{"$f":"IF(AND('Year 2 - To fill'!RCalculDateDebut1>=DATE(2012,1,1),'Year 2 - To fill'!RCalculDateDebut1<DATE(2013,1,1)),'Calculation Details'!AA127,0)","v":0},{"$f":"(0.2*((I139*0.4)*(S119/(S119+T119)))+(0.2*((I139*0.4)*(T119/(S119+T119)))))","v":0}]
[null,null,null,"Applicable current expenditures",null,null,null,{"$f":"MIN(L33,L104)","v":0},{"$f":"MIN(O33,O104)","v":0},"X 35% (credit) X 100%  =",null,{"$f":"H128*0.35","v":0},null,null,{"$f":"I128*0.35","v":0},null,null,null,null,null,"Proxy 2013-2014",{"$f":"IF(AND('Year 2 - To fill'!RCalculDateDebut1>=DATE(2013,1,1),'Year 2 - To fill'!RCalculDateDebut1<DATE(2014,1,1)),'Calculation Details'!W128,0)","v":0},{"$f":"(0.6*((O90+O91-V124)*(U119/(U119+V119)))+(0.55*((O90+O91-V124)*(V119/(U119+V119)))))","v":0},null,"Proxy 2013-2014",{"$f":"IF(AND('Year 2 - To fill'!RCalculDateDebut1>=DATE(2013,1,1),'Year 2 - To fill'!RCalculDateDebut1<DATE(2014,1,1)),'Calculation Details'!AA128,0)","v":0},{"$f":"(0.2*((I139*0.4)*(U119/(U119+V119)))+(0.15*((I139*0.4)*(V119/(U119+V119)))))","v":0}]
[null,null,null,"Applicable capital expenditures",null,null,null,{"$f":"MIN(L115,X135)","v":0},{"$f":"MIN(O115,X136)","v":0},"X 35% (credit) X 40%  = ",null,{"$f":"ROUND(ROUND(H129*0.35,0)*0.4,0)","v":0},null,null,{"$f":"ROUND(ROUND(I129*0.35,0)*0.4,0)","v":0},null,null,null,null,null,"Proxy 2014",{"$f":"IF('Year 2 - To fill'!RCalculDateDebut1>=DATE(2014,1,1),W129,0)","v":0},{"$f":"0.55*((O90+O91-V124))","v":0},null,"Proxy 2014",{"$f":"IF('Year 2 - To fill'!RCalculDateDebut1>=DATE(2014,1,1),AA129,0)","v":0},{"$f":"0.15*((I139*0.4))","v":0}]
[null,null,null,"Total : ",null,null,null,{"$f":"SUM(H128:H129)","v":0},{"$f":"SUM(I128:I129)","v":0},{"$f":"IF('Year 1 - To fill'!S80,\"( max. \"&FIXED('Calculation Details'!L33,0)&\" $ )\",\"( max. 3 000 000 $ )\")","v":"( max. 3 000 000 $ )"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Proxy",{"$f":"SUM(V127:V129)","v":0},null,null,"Total Proxy",{"$f":"SUM(Z127:Z129)","v":0}]
[null,null,null,"Total refundable enhanced tax credits",null,null,null,null,null,null,null,{"$f":"SUM(L128:L129)","v":0},null,null,{"$f":"SUM(O128:O129)","v":0}]
[]
[null,null,"Calculation of refundable SR&ED tax credits in excess of the company's  expenditure limit\n"]
[null,null,"Calculation of refundable SR&ED tax credits in excess of the expenditure limit\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YEAR1",{"$f":"L33-H128","v":0}]
[null,null,null,null,null,null,null,"Year 1","Year 2",null,null,null,null,null,null,null,null,null,null,null,null,null,"YEAR 2",{"$f":"O33-I128","v":0}]
[null,null,null,"Applicable current expenditures",null,null,null,{"$f":"IF('Year 1 - To fill'!S61=FALSE,IF(L104>'Calculation Details'!L33,(L104-'Calculation Details'!L33),0),0)","v":0},{"$f":"IF('Year 2 - To fill'!S60=FALSE,IF(O104>'Calculation Details'!O33,(O104-'Calculation Details'!O33),0),0)","v":0}]
[null,null,null,"Applicable capital expenditures",null,null,null,{"$f":"IF('Year 1 - To fill'!S61=FALSE,L115-H129,0)","v":0},{"$f":"IF('Year 2 - To fill'!S60=FALSE,O115-I129,0)","v":0}]
[null,null,null,"Total : ",null,null,null,{"$f":"SUM(H137:H138)","v":0},{"$f":"SUM(I137:I138)","v":0}," X 20/15% (credit) X 40% =",null,{"$f":"Z111","v":0},null,null,{"$f":"Z131","v":0}]
[]
[null,null,{"$f":"'Year 1 - To fill'!C67","v":"Federal income tax payable, net of tax instalments"},null,null,null,null,null,null,null,null,{"$f":"'Year 1 - To fill'!L67","v":0},null,null,{"$f":"'Year 2 - To fill'!L67","v":0}]
[]
[null,null,null,"IQ","Minus other amounts:"]
[null,null,null,"adjustments","Plus other amounts:"]
[]
[null,null,"Federal refundable SR&ED tax credits:",null,null,null,null,null,null,null,null,{"$f":"IF('Year 1 - To fill'!SaisiTerminer,IF(RONindicateurCorporationControlCanadienCanada1=2,0.000001,IF(ROUND(L132+L139-L141-L143+L144,0)<=0,0.000001,ROUND(L132+L139-L141-L143+L144,0))),\"\")","v":""},null,null,{"$f":"IF('Year 2 - To fill'!SaisiTerminer,IF(RONindicateurCorporationControlCanadienCanada1=2,0.000001,IF(ROUND(O132+O139-O141-O143+O144,0)<=0,0.000001,ROUND(O132+O139-O141-O143+O144,0))),\"\")","v":""}]

{"sheet":"Title","index":5,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["President"]
["Vice-president of finance"]
["Vice-president of R&D"]
["Controller"]
["Shareholder"]
["Other (specify)"]