{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","General Information","Year 1 CALCULATIONS","Year 2 CALCULATIONS","Financing","Calculs"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":38,"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":157,"n_cols":4,"rows_kept":157,"cut":false,"hidden":false,"merged":[[99,1,99,2],[2,1,2,2],[3,1,3,2],[77,0,77,3],[86,1,86,2],[92,1,92,2]]}
[]
[null,null,null,"Financing of Working Capital for Export Projects - knowledge-based economy"]
[null,"LOAN / GUARANTEE APPLICATION"]
[null,"Instructions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Investissement Québec Service Outlets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Toll free number in Québec: 1 866 870-0437"]

{"sheet":"General Information","index":1,"n_rows":333,"n_cols":23,"rows_kept":333,"cut":false,"hidden":false,"merged":[[270,12,271,14],[258,12,258,14],[258,1,258,4],[220,1,220,5],[75,10,75,15],[68,1,68,16],[52,6,52,8],[73,4,73,10],[333,5,333,9],[218,1,218,3],[307,0,307,16],[260,1,260,4],[260,6,260,7],[260,12,260,14],[260,8,260,11],[263,8,263,11],[305,1,305,16],[332,1,333,3],[253,8,253,11],[258,8,258,11],[255,8,255,11],[321,6,321,12],[270,15,271,15],[270,8,271,11],[273,12,273,14],[72,14,72,15],[28,5,28,15],[29,5,29,15],[265,8,265,11],[264,8,264,11],[160,6,161,9],[155,1,155,5],[157,1,157,5],[150,6,151,9],[158,14,159,15],[152,10,153,11],[152,12,153,13],[154,10,155,11],[150,14,151,15],[152,14,153,15],[161,1,161,5],[248,8,248,11],[244,1,244,15],[248,6,248,7],[263,1,263,4],[261,1,261,4],[257,1,257,4],[259,1,259,4],[81,1,81,15],[181,1,181,7],[144,1,144,5],[145,1,145,5],[159,1,159,5],[158,1,158,5],[151,1,151,5],[77,4,77,8],[77,12,77,15],[160,12,161,13],[160,10,161,11],[158,10,159,11],[146,10,147,11],[156,14,157,15],[153,1,153,5],[141,14,141,15],[113,6,113,8],[103,1,103,16],[109,11,110,14],[112,3,112,5],[113,3,113,5],[107,5,107,15],[95,2,95,14],[255,1,255,4],[219,1,219,5],[255,6,255,7],[148,12,149,13],[148,14,149,15],[144,14,145,15],[220,14,220,15],[219,14,219,15],[220,12,220,13],[154,14,155,15],[217,14,218,15],[144,12,145,13],[146,14,147,15],[148,1,148,5],[146,6,147,9],[168,1,168,3],[144,10,145,11],[146,1,146,5],[156,1,156,5],[255,12,255,14],[254,1,254,4],[253,1,253,4],[256,12,256,14],[217,10,218,11],[219,12,219,13],[217,12,218,13],[156,6,157,9],[158,6,159,9],[158,12,159,13],[156,12,157,13],[219,10,219,11],[217,7,218,8],[165,0,165,16],[249,8,249,11],[247,6,247,7],[220,7,220,8],[221,7,221,8],[246,1,246,4],[246,8,246,11],[219,7,219,8],[222,7,222,8],[222,10,222,11],[215,1,215,16],[248,12,248,14],[249,12,249,14],[160,1,160,5],[0,0,0,2],[2,0,2,16],[3,0,3,16],[27,5,27,15],[24,5,24,15],[25,5,25,15],[13,11,13,13],[23,5,23,15],[15,11,15,13],[4,1,4,7],[13,4,13,5],[14,4,14,5],[20,7,20,15],[21,7,21,15],[18,1,18,16],[11,10,11,14],[4,11,4,12],[7,1,7,5],[9,2,9,14],[14,11,14,13],[15,6,15,8],[13,6,13,8],[14,6,14,8],[30,1,30,5],[32,1,32,5],[156,10,157,11],[178,1,178,3],[160,14,161,15],[148,10,149,11],[148,6,149,9],[154,6,155,9],[152,1,152,5],[142,1,142,5],[141,1,141,5],[152,6,153,9],[150,12,151,13],[112,1,112,2],[142,14,143,15],[142,12,143,13],[154,12,155,13],[162,14,162,15],[142,6,143,9],[92,2,93,14],[113,11,113,14],[111,6,111,8],[98,2,98,14],[72,11,72,13],[36,1,36,5],[31,9,31,15],[41,6,41,8],[39,6,39,15],[49,1,49,5],[38,6,38,15],[52,13,52,15],[70,6,70,15],[33,11,33,15],[34,11,34,15],[33,3,33,7],[35,11,35,15],[37,6,37,15],[41,13,41,15],[53,13,53,15],[53,6,53,8],[45,1,45,16],[49,6,49,15],[67,1,67,16],[72,4,72,10],[54,0,54,16],[250,1,250,4],[246,6,246,7],[221,10,221,11],[221,1,221,5],[222,1,222,5],[243,1,243,15],[247,8,247,11],[221,14,221,15],[221,12,221,13],[247,12,247,14],[246,12,246,14],[222,12,222,13],[249,6,249,7],[222,14,222,15],[220,10,220,11],[147,1,147,5],[154,1,154,5],[248,1,248,4],[247,1,247,4],[249,1,249,4],[150,10,151,11],[149,1,149,5],[102,1,102,15],[109,1,110,2],[109,3,110,5],[109,6,110,8],[113,1,113,2],[109,9,110,10],[111,9,111,10],[112,9,112,10],[109,15,110,15],[113,9,113,10],[112,6,112,8],[143,1,143,5],[144,6,145,9],[268,8,268,11],[319,1,320,5],[94,2,94,14],[111,1,111,2],[261,6,261,7],[96,2,96,14],[111,11,111,14],[112,11,112,14],[142,10,143,11],[257,12,257,14],[263,12,263,14],[259,12,259,14],[262,12,262,14],[261,12,261,14],[213,1,213,16],[195,1,195,16],[141,6,141,9],[139,1,139,16],[111,3,111,5],[150,1,150,5],[141,10,141,11],[97,2,97,14],[141,12,141,13],[273,1,273,4],[269,8,269,11],[268,12,268,14],[118,1,118,16],[146,12,147,13],[334,5,334,9],[324,1,325,5],[324,6,325,12],[267,12,267,14],[326,1,326,5],[326,6,326,12],[326,13,326,15],[270,1,271,4],[268,1,268,4],[269,6,269,7],[267,1,267,4],[267,8,267,11],[267,6,267,7],[268,6,268,7],[319,6,320,12],[321,1,321,5],[270,6,271,7],[270,5,271,5],[287,1,287,15],[252,12,252,14],[332,5,332,9],[253,6,253,7],[253,12,253,14],[256,6,256,7],[256,8,256,11],[254,12,254,14],[254,6,254,7],[257,6,257,7],[257,8,257,11],[252,6,252,7],[252,8,252,11],[254,8,254,11],[264,6,264,7],[265,6,265,7],[258,6,258,7],[259,6,259,7],[319,13,320,15],[321,13,321,15],[324,13,325,15],[266,8,266,11],[265,12,265,14],[256,1,256,4],[273,6,273,7],[118,22,121,33],[250,12,250,14],[269,12,269,14],[261,8,261,11],[262,8,262,11],[250,6,250,7],[250,8,250,11],[264,1,264,4],[265,1,265,4],[266,1,266,4],[251,1,251,4],[252,1,252,4],[262,1,262,4],[269,1,269,4],[251,12,251,14],[251,6,251,7],[251,8,251,11],[263,6,263,7],[266,6,266,7],[264,12,264,14],[259,8,259,11],[262,6,262,7],[266,12,266,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Financing of Working Capital for Export Projects - knowledge-based economy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I21","v":0}]
["LOAN / GUARANTEE APPLICATION"]
["General Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"++++++++++     Click here to choose the tax credit.     ++++++++++"]
[null,{"$f":"H21","v":0},null,null,null,null,null,null,null,"Organisation No.: ",null,null,null,null,"File No.: ",null,null,null,null,null,null,null,"Biotechnology development centres (CDB) – Expires 31-12-2013"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major employment-generating projects (GPCE) – Expires 31-12-2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Production of multimedia titles (PTM) – Permanent tax measure"]
[null,"CHOICE OF TAX CREDIT TO BE FINANCED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technology adaptation services (SAT) – Permanent tax measure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New economy centres (CNE) – Expires 31-12-2013"]
[null,null,"++++++++++     Click here to choose the tax credit.     ++++++++++",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre national des nouvelles technologies de Québec (CNNTQ) – Expires 31-12-2013"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information technology development centres (CDTI) - Expires 31-12-2013"]
[null,null,"Fiscal year to be financed:",null,null,null,null,"1st fiscal year",null,null,"2nd fiscal year (if need be)",null,null,null,null,null,null,null,null,null,null,null,"E-Commerce Place (CCE) – Expires 31-12-2013"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cité Multimédia de Montréal (CMM) – Expires 31-12-2013"]
[null,null,null,null,"Start date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Development of e-business (CDAE) – Expires 31-12-2025"]
[null,null,null,null,"End date:"]
[null,null,null,null,null,null,"(yyyy-mm-dd)",null,null,null,null,"(yyyy-mm-dd)",null,null,null,null,null,null,null,null,null,null,{"$f":"C10","v":"++++++++++     Click here to choose the tax credit.     ++++++++++"}]
[]
[]
["1.","IDENTIFICATION"]
[]
[null,"Name of the company submitting the application:"]
[null,"NEQ (Québec business number):"]
[]
[null,"Address of head office:"]
[]
[]
[]
[null,"Address of main office:"]
[null,"(if different from head office)"]
[]
[]
[null,"Person Investissement Québec should contact:"]
[]
[null,"Title:",null,null,null,null,null,null,null,null,"Telephone:","    "]
[null,null,null,null,null,null,null,null,null,null,"Fax:","     "]
[null,null,null,null,null,null,null,null,null,null,"Email:"]
[]
[null,"Address (if different from head office):"]
[]
[]
[]
[null,"Number of employees before the project:",null,null,null,null,null,null,null,null,null,null," after the project:"]
[]
[]
[]
["2.","INFORMATION ON THE COMPANY AND THE LOAN REQUESTED"]
[]
[]
[null,"Registration number with"]
[null,"Revenu Québec:"]
[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,"     Beginning of activities:"]
[null,null,null,null,null,null,"(yyyy-mm-dd)",null,null,null,null,null,null,"(yyyy-mm-dd)"]
[]
[null,"Is the company associated (as defined by the Taxation Act) with other companies?"]
[null,"(if so, append a list and organization chart to your application)"]
[]
[null,"Is the company in arrears on any account "]
[null,"with the Canada Revenue Agency or Revenu Québec?"]
[]
[null,"Are any disputes or notices of objection outstanding in respect of the Canada "]
[null,"Revenue Agency or Revenu Québec?"]
[null,"(if so, append the details to your application)"]
[]
[]
[]
[]
["3.","INFORMATION ON THE FINANCIAL INSTITUTION"]
[]
[null,"Name of lender (company name):"]
[]
[null,"Address (branch) :",null,null,null,null,null,null,null,null,null,"    Transit number:"]
[]
[]
[null,"Name of the person responsible for the account at the financial institution:"]
[]
[null,"Telephone:",null,null,"     ",null,null,null,null,null,"Fax:",null,"     "]
[]
[]
[]
["4.","ELIGIBILITY FOR REFUNDABLE TAX CREDITS"]
["  "]
[null,"4.1 Eligibility for the CCE, CDAE, CDTI, CNE, CNNTQ, CITÉ DU MULTIMÉDIA, PTM, GPCE refundable tax credits"]
[]
[null,null,"Does the company hold an eligibility certificate from Investissement Québec?"]
[null,null,"(if so, append a copy of the eligibility certificate to your application)"]
[]
[]
[]
[null,"4.2 Eligibility for the SAT (technology adaptation services) tax credits "]
[]
[null,null,"The company must satisfy the following condition, taking associated corporations into account."]
[]
[null,null,"The following corporations cannot receive the tax credit for a taxation year:"]
[null,null,"      - a corporation that, for a given taxation year, earns more than 10% of its gross income from a source other than  "]
[null,null,"        carrying on an eligible business;"]
[null,null,"       - a corporation exempt from tax for a given year;"]
[null,null,"       - a Crown corporation or a wholly-controlled subsidiary of a Crown corporation."]
[]
[]
[]
[null,"4.3 History of tax credits received"]
[]
[]
[null,"Tax credit regarding the knowledge-based economy"]
[]
[null,"Specify the credit(s):"]
[]
[null,"Year",null,"Level",null,null,"Amount claimed",null,null,"Date income tax return filed",null,"  Amount received",null,null,null,"Date"]
[]
[null,null,null,"Provincial"]
[null,null,null,"Provincial"]
[null,null,null,"Provincial"]
[]
[]
[]
[]
["5.","PROJECT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not resize textboxes manually. Once you have finished typing your text, use this button to do it automatically."]
[]
[null,"Brief description of the project and timetable for completion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6.","SHAREHOLDERS AND MANAGEMENT"]
[]
[null,"Name and address",null,null,null,null,"Title or position within company (if shareholder not employed by company, write n/a)",null,null,null,"Years of experience in the industry ",null,"Years of experience with the company",null,"% of voting shares"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"IF(SUM(O143:P162)=0,\"\",SUM(O143:P162))","v":""}]
[]
[]
["SECTION IQ"]
[]
[]
[null,"Capacité de gestion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Comité de gestion et/ou d'administration?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["7. ","MISE EN SITUATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["8.","FINANCES"]
[]
[null,"8.1  Résultats d'exploitation et prévisions (000 $)"]
[]
[null,"Exercice se terminant le :",null,null,null,null,null,"Revenus",null,null,"Amortis- sements",null,"Dépenses capitalisées",null,"Fonds disponibles"]
[null,"(aaaa-mm-jj)",null,null,null,null,null,null,null,"Profits nets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J220:L220)-M220=0,\"\",SUM(J220:L220)-M220)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J221:L221)-M221=0,\"\",SUM(J221:L221)-M221)","v":""}]
[null,null,null,null,null,null,"P",null,null,null,null,null,null,null,{"$f":"IF(SUM(J222:L222)-M222=0,\"\",SUM(J222:L222)-M222)","v":""}]
[null,null,null,null,null,null,"P",null,null,null,null,null,null,null,{"$f":"IF(SUM(J223:L223)-M223=0,\"\",SUM(J223:L223)-M223)","v":""}]
[]
[]
[]
[null,"Est-ce que les prévisions financières apparaissent réalistes?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"8.2    Bilan annuel vérifié préparé par « NOM DE LA FIRME »  (c.a.) au « DATE »"]
[null,"et bilan intérimaire au « DATE » ( 000$)"]
[]
[null,"ACTIF",null,null,null,null,null,null,"PASSIF",null,null,null,{"$f":"IF(F247=\"\",\"\",F247)","v":""},null,null,{"$f":"IF(G247=\"\",\"\",G247)","v":""}]
[null,"Encaisse",null,null,null,null,null,null,"Banque"]
[null,"Débiteurs",null,null,null,null,null,null,"Banque crédits d'impôt "]
[null,"Crédits d'impôt à recevoir",null,null,null,null,null,null,"Créditeurs"]
[null,"Stocks",null,null,null,null,null,null,"Partie cour. dette à terme"]
[null,"Autres débiteurs",null,null,null,null,null,null,"Autres créditeurs (1)"]
[]
[]
[null,"Sous-total actif à court terme",null,null,null,{"$f":"IF(SUM(F248:F254)=0,\"\",SUM(F248:F254))","v":""},{"$f":"IF(SUM(G248:H254)=0,\"\",SUM(G248:H254))","v":""},null,"Sous-total passif à court terme",null,null,null,{"$f":"IF(SUM(M248:O254)=0,\"\",SUM(M248:O254))","v":""},null,null,{"$f":"IF(SUM(P248:P254)=0,\"\",SUM(P248:P254))","v":""}]
[]
[null,"Immobilisations",null,null,null,null,null,null,"Dettes à long terme"]
[null,"Placements",null,null,null,null,null,null,"Impôts reportés"]
[]
[]
[null,null,null,null,null,null,null,null,"Sous-total passif",null,null,null,{"$f":"IF(SUM((M255:O260))=0,\"\",SUM((M255:O260)))","v":""},null,null,{"$f":"IF(SUM((P255:P260))=0,\"\",SUM((P255:P260)))","v":""}]
[]
[null,"Frais reportés",null,null,null,null,null,null,"Capital-actions"]
[null,null,null,null,null,null,null,null,"Crédits reportés"]
[null,null,null,null,null,null,null,null,"Autres surplus"]
[null,null,null,null,null,null,null,null,"Bénéfices non répartis"]
[]
[]
[null,null,null,null,null,null,null,null,"Sous-total avoir act.",null,null,null,{"$f":"IF(SUM(M263:O268)=0,\"\",SUM(M263:O268))","v":""},null,null,{"$f":"IF(SUM(P263:P268)=0,\"\",SUM(P263:P268))","v":""}]
[]
[null,"Total",null,null,null,{"$f":"IF(SUM(F255:F270)=0,\"\",SUM(F255:F270))","v":""},{"$f":"IF(SUM(G255:H270)=0,\"\",SUM(G255:H270))","v":""},null,"Total",null,null,null,{"$f":"IF(SUM(M261,M269)=0,\"\",SUM(M261,M269))","v":""},null,null,{"$f":"IF(SUM(P261,P269)=0,\"\",SUM(P261,P269))","v":""}]
[]
[]
[null,"Ratio fonds de roulement :",null,null,null,{"$f":"IF(ISERROR(IF((F255)>0,(F255/M255),0)),\"\",IF((F255)>0,(F255/M255),0))","v":""},{"$f":"IF(ISERROR(IF((G255)>0,(G255/P255),0)),\"\",IF((G255)>0,(G255/P255),0))","v":""},null,null,null,null,"Dette long terme / avoir net :",{"$f":"IF(ISERROR(IF((M269=0),0,M257/M269)),\"\",IF((M269=0),0,M257/M269))","v":""},null,null,{"$f":"IF(ISERROR(IF((P269=0),0,P257/P269)),\"\",IF((P269=0),0,P257/P269))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"8.3  Commentaires sur la capacité financière de l'entreprise à opérer jusqu'à l'encaissement des crédits d'impôt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["9.","CONCLUSION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Technicien(ne) en financement",null,null,null,null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[null,"Directeur(trice) de portefeuille",null,null,null,null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[null,"Annexes jointes"]
[]
[]
[null,"Les annexes pertinentes devraient être déposées dans SYGIC."]

{"sheet":"Year 1 CALCULATIONS","index":2,"n_rows":65,"n_cols":39,"rows_kept":65,"cut":false,"hidden":false,"merged":[[15,1,15,6],[0,0,0,2],[9,2,9,6],[13,2,13,6],[3,0,3,7],[4,0,4,7],[5,1,5,2],[382,12,383,12],[444,9,444,11],[445,9,445,11],[446,9,446,11],[17,9,17,14],[43,9,43,14],[130,12,131,12],[203,9,203,11],[202,9,202,11],[201,9,201,11],[194,9,194,11],[193,9,193,11],[192,9,192,11],[40,1,40,2],[31,1,31,2],[17,1,17,6],[18,1,18,2],[32,1,32,2],[32,4,32,5],[33,1,33,2],[41,1,41,6],[453,9,453,11],[46,1,46,2],[44,1,45,1],[44,2,45,2],[43,1,43,6],[44,4,45,4],[42,1,42,6],[454,9,454,11],[455,9,455,11],[44,3,45,3],[44,5,45,5],[44,6,45,6]]}
[]
[null,null,null,null,null,null,"Financing of Working Capital for Export Projects - knowledge-based economy",null,null,null,null,null,null,null,null,{"$f":"I21","v":0}]
[]
["LOAN / GUARANTEE APPLICATION"]
["Calculations for tax credits to be financed"]
[null,{"$f":"'General Information'!H21","v":0},null,null,{"$f":"'General Information'!J5&'General Information'!L5","v":"Organisation No.: "},null,{"$f":"'General Information'!O5&'General Information'!P5","v":"File No.: "}]
[]
["1.","ESTIMATE OF TAX CREDITS TO BE FINANCED"]
[]
[null,"Tax credit :",{"$f":"IF('General Information'!W16=\"++++++++++     Click here to choose the tax credit.     ++++++++++\",\"No tax credit selected\",'General Information'!W16)","v":"No tax credit selected"}]
[]
[]
[null,"Location where activities "]
[null,"will be carried out:"]
[]
[null,"Note: The table in section 2 below can be used to establish costs relating to salaries."]
[]
[null,{"$f":"IF(C10=M28,\"First fiscal year to be financed\",CONCATENATE(\"First fiscal year to be financed \",IF(AND('General Information'!G14<>0,'General Information'!G15<>0),(CONCATENATE(\"(from \",YEAR('General Information'!G14),\"-\",IF(MONTH('General Information'!G14)<10,CONCATENATE(\"0\",MONTH('General Information'!G14)),MONTH('General Information'!G14)),\"-\",IF(DAY('General Information'!G14)<10,CONCATENATE(\"0\",DAY('General Information'!G14)),DAY('General Information'!G14)),\" to \",YEAR('General Information'!G15),\"-\",IF(MONTH('General Information'!G15)<10,CONCATENATE(\"0\",MONTH('General Information'!G15)),MONTH('General Information'!G15)),\"-\",IF(DAY('General Information'!G15)<10,CONCATENATE(\"0\",DAY('General Information'!G15)),DAY('General Information'!G15)),\")\")),\"(from ______________ to _____________ )\")))","v":"First fiscal year to be financed (from ______________ to _____________ )"}]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,2,FALSE)","v":"No tax credit selected"},null,"Total costs ($)","Eligible costs ($)","Applicable tax credit % ","Tax credits to be financed (Québec) ($)",null,null,null,null,null,"No tax credit selected","No tax credit selected"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,4,FALSE)","v":0},{"$f":"IF((D20)>=E20,(E20*F20),0)","v":0},null,null,null,null,null,"Biotechnology development centres (CDB) – Expires 31-12-2013","CBD","Eligible salaries",0.3,"Equipment acquired or leased",0.3,"less: non-refundable financial contribution(s)",-0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,5,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,6,FALSE)","v":0},{"$f":"IF((D21)>=E21,(E21*F21),0)","v":0},null,null,null,null,null,"Major employment-generating projects (GPCE) – Expires 31-12-2016","GPCE (certificate required)","Eligible salaries incurred as of 2005-01-01",0.25,"less: non-refundable financial contribution(s)",-0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 000 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,7,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,8,FALSE)","v":0},0,null,null,null,null,null,"Production of multimedia titles (PTM) – Permanent tax measure","PTM (certificate required)","General public – Salaries",0.3,"                   -Sub-contracting salaries – related",0.3,"                   -Sub-contracting salaries – unrelated",0.15,"                  less: NRFC  ",-0.3,"French portion - Salaries",7.4999999999999997E-2,"                         -Sub-contracting salaries – related",7.4999999999999997E-2,"                         -Sub-contracting salaries – unrelated",3.7499999999999999E-2,"                         less: NRFC",-7.4999999999999997E-2,"Other multimedia titles – Salaries",0.26250000000000001,"                   -Sub-contracting salaries – related",0.26250000000000001,"                   -Sub-contracting salaries – unrelated",0.13125000000000001,"                  less: NRFC",-0.26250000000000001,"Aucun"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,9,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,10,FALSE)","v":0},0,null,null,null,null,null,"Technology adaptation services (SAT) – Permanent tax measure","SAT","Eligible expenses – Training",0.5,"                                  - Subscriptions",0.5,"                                  - 80% of fees",0.5,"less: non-refundable financial contribution(s)",-0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aucun"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,11,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,12,FALSE)","v":0},0,null,null,null,null,null,"New economy centres (CNE) – Expires 31-12-2013","CNE (certificate required)","Eligible salaries",0.4,"less: non-refundable financial contribution(s)",-0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,13,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,14,FALSE)","v":0},0,null,null,null,null,null,"Centre national des nouvelles technologies de Québec (CNNTQ) – Expires 31-12-2013","CNNTQ (certificate required)","Eligible salaries",0.4,"less: non-refundable financial contribution(s)",-0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,15,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,16,FALSE)","v":0},0,null,null,null,null,null,"Information technology development centres (CDTI) - Expires 31-12-2013","CDTI (certificate required)","Eligible salaries from 16-06-1999 to 31-12-2013",0.4,"Equipment acquired or leased",0.4,"less: non-refundable financial contribution(s)",-0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,17,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,18,FALSE)","v":0},0,null,null,null,null,null,"E-Commerce Place (CCE) – Expires 31-12-2013","CCE (certificate required)","Eligible salaries",0.35,"less: non-refundable financial contribution(s)",-0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 714,29 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,19,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,20,FALSE)","v":0},{"$f":"IF((D28)>=E28,(E28*F28),0)","v":0},null,null,null,null,null,"Cité Multimédia de Montréal (CMM) – Expires 31-12-2013","CMM (certificate required)","Eligible salaries from 16-06-1999 to 31-12-2013",0.4,"less: non-refundable financial contribution(s)",-0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,21,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,22,FALSE)","v":0},{"$f":"IF((D29)>=E29,(E29*F29),0)","v":0},null,null,null,null,null,"Development of e-business (CDAE) – Expires 31-12-2025","CDAE (certificate required)","Eligible salaries from 14-03-2008 to 31-12-2025",0.3,"less: non-refundable financial contribution(s)",-0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"66 667 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,23,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,24,FALSE)","v":0},{"$f":"IF((D30)>=E30,(E30*F30),0)","v":0}]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,25,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,26,FALSE)","v":0},0]
[null,"Subtotal: ",null,{"$f":"SUM(D20:D31)","v":0},{"$f":"SUM(E20:E31)","v":0},null,{"$f":"SUM(G20:G31)","v":0}]
[null,null,null,null,"Less income tax and tax on capital:"]
[null,"Total tax credits to be financed (Québec): ",null,null,null,null,{"$f":"IF(ISERROR(G32-G33),\"\",G32-G33)","v":0}]
[]
[]
[]
[]
[]
[]
["2.","LIST OF ELIGIBLE EMPLOYEES"]
[null,"Note: You can use an external table that is similar to this one. If you do, please send us the table. "]
[null,"CDAE: Maximum eligible salary of $66 667  ($75 000 starting with 2016)."]
[null,{"$f":"CONCATENATE(\"First fiscal year to be financed \",IF(AND('General Information'!G14<>0,'General Information'!G15<>0),(CONCATENATE(\"(from \",YEAR('General Information'!G14),\"-\",IF(MONTH('General Information'!G14)<10,CONCATENATE(\"0\",MONTH('General Information'!G14)),MONTH('General Information'!G14)),\"-\",IF(DAY('General Information'!G14)<10,CONCATENATE(\"0\",DAY('General Information'!G14)),DAY('General Information'!G14)),\" to \",YEAR('General Information'!G15),\"-\",IF(MONTH('General Information'!G15)<10,CONCATENATE(\"0\",MONTH('General Information'!G15)),MONTH('General Information'!G15)),\"-\",IF(DAY('General Information'!G15)<10,CONCATENATE(\"0\",DAY('General Information'!G15)),DAY('General Information'!G15)),\")\")),\"(from ______________ to _____________ )\"))","v":"First fiscal year to be financed (from ______________ to _____________ )"}]
[null,"Eligible employee ","Position","Salary paid ($)",{"$f":"IF(C10=M19,\"Eligible salary ($)\",CONCATENATE(\"Eligible salary ($) (Max: \",VLOOKUP($C$10,$M$20:$AM$29,27,FALSE),\")\"))","v":"Eligible salary ($)"},"Number of weeks worked","Number of hours worked during the year",null,null,null,null,null,{"$f":"OFFSET('Year 1 CALCULATIONS'!$A$1:$H$50,,,MAX(IF('Year 1 CALCULATIONS'!$B$1:$B$501<>\"\",ROW('Year 1 CALCULATIONS'!$B$1:$B$501))))","v":{"$error":"#VALUE!"}}]
[]
[null,"TOTAL:  ",null,{"$f":"SUM(D50:D501)","v":0},{"$f":"SUM(E50:E501)","v":0},{"$f":"SUM(F50:F501)","v":0},{"$f":"SUM(G50:G501)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"."]

{"sheet":"Year 2 CALCULATIONS","index":3,"n_rows":65,"n_cols":41,"rows_kept":65,"cut":false,"hidden":false,"merged":[[17,9,17,14],[31,1,31,2],[17,1,17,6],[18,1,18,2],[15,1,15,6],[40,1,40,2],[43,1,43,6],[32,1,32,2],[32,4,32,5],[0,0,0,2],[9,2,9,6],[13,2,13,6],[3,0,3,7],[4,0,4,7],[5,1,5,2],[33,1,33,2],[382,12,383,12],[192,9,192,11],[455,9,455,11],[46,1,46,2],[130,12,131,12],[194,9,194,11],[203,9,203,11],[444,9,444,11],[445,9,445,11],[453,9,453,11],[454,9,454,11],[446,9,446,11],[202,9,202,11],[201,9,201,11],[193,9,193,11],[43,9,43,14],[41,1,41,6],[44,4,45,4],[44,1,45,1],[44,2,45,2],[44,3,45,3],[42,1,42,6],[44,5,45,5],[44,6,45,6]]}
[]
[null,null,null,null,null,null,"Financing of Working Capital for Export Projects - knowledge-based economy",null,null,null,null,null,null,null,null,{"$f":"I21","v":0}]
[]
["LOAN / GUARANTEE APPLICATION"]
["Calculations for tax credits to be financed (year 2)"]
[null,{"$f":"'General Information'!H21","v":0},null,null,{"$f":"'General Information'!J5&'General Information'!L5","v":"Organisation No.: "},null,{"$f":"'General Information'!O5&'General Information'!P5","v":"File No.: "}]
[]
["1.","ESTIMATE OF TAX CREDITS TO BE FINANCED"]
[]
[null,"Tax credit:",{"$f":"IF('General Information'!W16=\"++++++++++     Click here to choose the tax credit.     ++++++++++\",\"No tax credit selected\",'General Information'!W16)","v":"No tax credit selected"}]
[]
[]
[null,"Location where activities"]
[null,"will be carried out:"]
[]
[null,"Note: The table in section 2 below can be used to establish costs relating to salaries."]
[]
[null,{"$f":"IF(C10=M28,\"Second fiscal year to be financed\",CONCATENATE(\"Second fiscal year to be financed \",IF(AND('General Information'!L14<>0,'General Information'!L15<>0),(CONCATENATE(\"(from \",YEAR('General Information'!L14),\"-\",IF(MONTH('General Information'!L14)<10,CONCATENATE(\"0\",MONTH('General Information'!L14)),MONTH('General Information'!L14)),\"-\",IF(DAY('General Information'!L14)<10,CONCATENATE(\"0\",DAY('General Information'!L14)),DAY('General Information'!L14)),\" to \",YEAR('General Information'!L15),\"-\",IF(MONTH('General Information'!L15)<10,CONCATENATE(\"0\",MONTH('General Information'!L15)),MONTH('General Information'!L15)),\"-\",IF(DAY('General Information'!L15)<10,CONCATENATE(\"0\",DAY('General Information'!L15)),DAY('General Information'!L15)),\")\")),\"(from ______________ to _____________ )\")))","v":"Second fiscal year to be financed (from ______________ to _____________ )"}]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,2,FALSE)","v":"No tax credit selected"},null,"Total costs ($)","Eligible costs ($)","Applicable tax credit % ","Tax credits to be financed (Québec) ($)",null,null,null,null,null,"No tax credit selected","No tax credit selected"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,4,FALSE)","v":0},{"$f":"IF((D20)>=E20,(E20*F20),0)","v":0},null,null,null,null,null,"Biotechnology development centres (CDB) – Expires 31-12-2013","CBD","Eligible salaries",0.3,"Equipment acquired or leased",0.3,"less: non-refundable financial contribution(s)",-0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,5,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,6,FALSE)","v":0},{"$f":"IF((D21)>=E21,(E21*F21),0)","v":0},null,null,null,null,null,"Major employment-generating projects (GPCE) – Expires 31-12-2016","GPCE (certificate required)","Eligible salaries incurred as of 2005-01-01",0.25,"less: non-refundable financial contribution(s)",-0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 000 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,7,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,8,FALSE)","v":0},0,null,null,null,null,null,"Production of multimedia titles (PTM) – Permanent tax measure","PTM (certificate required)","General public – Salaries",0.3,"                   -Sub-contracting salaries – related",0.3,"                   -Sub-contracting salaries – unrelated",0.15,"                  less: NRFC  ",-0.3,"French portion - Salaries",7.4999999999999997E-2,"                         -Sub-contracting salaries – related",7.4999999999999997E-2,"                         -Sub-contracting salaries – unrelated",3.7499999999999999E-2,"                         less: NRFC",-7.4999999999999997E-2,"Other multimedia titles – Salaries",0.26250000000000001,"                   -Sub-contracting salaries – related",0.26250000000000001,"                   -Sub-contracting salaries – unrelated",0.13125000000000001,"                  less: NRFC",-0.26250000000000001,"Aucun"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,9,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,10,FALSE)","v":0},0,null,null,null,null,null,"Technology adaptation services (SAT) – Permanent tax measure","SAT","Eligible expenses – Training",0.5,"                                  - Subscriptions",0.5,"                                  - 80% of fees",0.5,"less: non-refundable financial contribution(s)",-0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aucun"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,11,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,12,FALSE)","v":0},0,null,null,null,null,null,"New economy centres (CNE) – Expires 31-12-2013","CNE (certificate required)","Eligible salaries",0.4,"less: non-refundable financial contribution(s)",-0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,13,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,14,FALSE)","v":0},0,null,null,null,null,null,"Centre national des nouvelles technologies de Québec (CNNTQ) – Expires 31-12-2013","CNNTQ (certificate required)","Eligible salaries",0.4,"less: non-refundable financial contribution(s)",-0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,15,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,16,FALSE)","v":0},0,null,null,null,null,null,"Information technology development centres (CDTI) - Expires 31-12-2013","CDTI (certificate required)","Eligible salaries from 16-06-1999 to 31-12-2013",0.4,"Equipment acquired or leased",0.4,"less: non-refundable financial contribution(s)",-0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,17,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,18,FALSE)","v":0},0,null,null,null,null,null,"E-Commerce Place (CCE) – Expires 31-12-2013","CCE (certificate required)","Eligible salaries",0.35,"less: non-refundable financial contribution(s)",-0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 714,29 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,19,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,20,FALSE)","v":0},0,null,null,null,null,null,"Cité Multimédia de Montréal (CMM) – Expires 31-12-2013","CMM (certificate required)","Eligible salaries from 16-06-1999 to 31-12-2013",0.4,"less: non-refundable financial contribution(s)",-0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 500 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,21,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,22,FALSE)","v":0},{"$f":"IF((D29)>=E29,(E29*F29),0)","v":0},null,null,null,null,null,"Development of e-business (CDAE) – Expires 31-12-2025","CDAE (certificate required)","Eligible salaries from 14-03-2008 to 31-12-2025",0.3,"less: non-refundable financial contribution(s)",-0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"66 667 $"]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,23,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,24,FALSE)","v":0},{"$f":"IF((D30)>=E30,(E30*F30),0)","v":0}]
[null,{"$f":"VLOOKUP($C$10,$M$19:$AL$29,25,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP($C$10,M$19:AL$29,26,FALSE)","v":0},0]
[null,"Subtotal: ",null,{"$f":"SUM(D20:D31)","v":0},{"$f":"SUM(E20:E31)","v":0},null,{"$f":"SUM(G20:G31)","v":0}]
[null,null,null,null,"Less income tax and tax on capital:"]
[null,"Total tax credits to be financed (Québec): ",null,null,null,null,{"$f":"IF(ISERROR(G32-G33),\"\",G32-G33)","v":0}]
[]
[]
[]
[]
[]
[]
["2.","LIST OF ELIGIBLE EMPLOYEES"]
[null,"Note: You can use an external table that is similar to this one. If you do, please send us the table.ç"]
[null,"CDAE: Maximum eligible salary of $66 667  ($75 000 starting with 2016)."]
[null,{"$f":"CONCATENATE(\"Second fiscal year to be financed \",IF(AND('General Information'!L14<>0,'General Information'!L15<>0),(CONCATENATE(\"(from \",YEAR('General Information'!L14),\"-\",IF(MONTH('General Information'!L14)<10,CONCATENATE(\"0\",MONTH('General Information'!L14)),MONTH('General Information'!L14)),\"-\",IF(DAY('General Information'!L14)<10,CONCATENATE(\"0\",DAY('General Information'!L14)),DAY('General Information'!L14)),\" to \",YEAR('General Information'!L15),\"-\",IF(MONTH('General Information'!L15)<10,CONCATENATE(\"0\",MONTH('General Information'!L15)),MONTH('General Information'!L15)),\"-\",IF(DAY('General Information'!L15)<10,CONCATENATE(\"0\",DAY('General Information'!L15)),DAY('General Information'!L15)),\")\")),\"(from ______________ to _____________ )\"))","v":"Second fiscal year to be financed (from ______________ to _____________ )"}]
[null,"Eligible employee","Position","Salary paid ($)",{"$f":"IF(C10=M19,\"Eligible salary ($)\",CONCATENATE(\"Eligible salary ($) (Max: \",VLOOKUP($C$10,$M$20:$AM$29,27,FALSE),\")\"))","v":"Eligible salary ($)"},"Number of weeks worked","Number of hours worked during the year",null,null,null,null,null,{"$f":"OFFSET('Year 2 CALCULATIONS'!$A$1:$H$50,,,MAX(IF('Year 2 CALCULATIONS'!$B$1:$B$501<>\"\",ROW('Year 2 CALCULATIONS'!$B$1:$B$501))))","v":{"$error":"#VALUE!"}}]
[]
[null,"TOTAL:  ",null,{"$f":"SUM(D50:D501)","v":0},{"$f":"SUM(E50:E501)","v":0},{"$f":"SUM(F50:F501)","v":0},{"$f":"SUM(G50:G501)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"."]

{"sheet":"Financing","index":4,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[19,7,19,9],[20,1,20,13],[18,14,18,15],[19,14,19,15],[33,2,33,10],[26,14,26,15],[27,14,27,15],[30,14,30,15],[31,14,31,15],[32,14,32,15],[32,12,32,13],[30,12,30,13],[27,12,27,13],[17,14,17,15],[15,12,15,13],[16,12,16,13],[34,14,34,15],[13,14,13,15],[13,12,13,13],[17,12,17,13],[14,14,14,15],[14,12,14,13],[15,14,15,15],[16,14,16,15],[12,14,12,15],[0,1,0,5],[4,0,4,16],[5,0,5,16],[1,8,1,15],[6,2,6,11],[6,12,6,14],[12,1,12,10],[11,11,11,13],[12,12,12,13],[17,1,17,10],[18,1,18,10],[19,1,19,6],[39,2,39,10],[38,2,38,10],[27,2,27,10],[32,2,32,10],[25,10,25,13],[31,12,31,13],[26,2,26,10],[30,2,30,10],[31,2,31,10],[26,12,26,13],[18,12,18,13],[19,12,19,13],[34,12,34,13],[13,1,13,10],[14,1,14,10],[33,14,33,15],[38,12,38,13],[35,12,35,13],[34,2,34,10],[37,2,37,10],[36,2,36,10],[36,12,36,13],[37,12,37,13],[38,14,38,15],[33,12,33,13],[37,14,37,15],[36,14,36,15],[35,2,35,10],[35,14,35,15]]}
[]
[null,null,null,null,null,null,null,null,"Financing of Working Capital for Export Projects - knowledge-based economy"]
[]
[]
["LOAN / GUARANTEE APPLICATION"]
["Calculations for tax credits to be financed"]
[null,null,{"$f":"'General Information'!H21","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Information'!J5 & 'General Information'!L5","v":"Organisation No.: "},null,null,{"$f":"'General Information'!O5&'General Information'!P5","v":"File No.: "}]
[]
[]
[null,"3. MAXIMUM LOAN ($)"]
[]
[]
[null,"Fiscal year(s) ended: ",null,null,null,null,null,null,null,null,null,{"$f":"IF('General Information'!G15=\"\",\"\",'General Information'!G15)","v":""},{"$f":"IF('General Information'!L15=\"\",\"\",'General Information'!L15)","v":""},null,"Total"]
[null,"Refundable tax credits (Québec) to be financed",null,null,null,null,null,null,null,null,null,{"$f":"'Year 1 CALCULATIONS'!G34","v":0},{"$f":"'Year 2 CALCULATIONS'!G34","v":0},null,{"$f":"SUM(L14+M14)","v":0}]
[null,"Maximum loan at 85%",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(L14*85%),\"\",L14*85%)","v":0},{"$f":"IF(ISERROR(M14*85%),\"\",M14*85%)","v":0},null,{"$f":"IF(ISERROR(SUM(L15:N15)),\"\",SUM(L15:N15))","v":0}]
[null,"Montant financé par le dossier précédent",null,null,null,null,null,null,null,"no.",null,null,null,null,{"$f":"SUM(L16:N16)","v":0}]
[null,"Montant à financer par ce nouveau dossier",null,null,null,null,null,null,null,"no.",null,{"$f":"IF(ISERROR(L15-L16),\" \",L15-L16)","v":0},{"$f":"IF(ISERROR(M15-M16),\"\",M15-M16)","v":0},null,{"$f":"SUM(L17:N17)","v":0}]
[null,"Portion financée (en %)",null,null,null,null,null,null,null,null,null,{"$f":"IF((L14)>0,(L19/L14),0)","v":0},{"$f":"IF((M14)>0,(M19/M14),0)","v":0},null,{"$f":"IF((O14)>0,(O19/O14),0)","v":0}]
[null,"Crédits financés (année courante, arrondis)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L19:N19)","v":0}]
[null,"1er certificat de garantie annuel :",null,null,null,null,null,0.85,null,null,null,{"$f":"L19*H20","v":0},{"$f":"M19*H20","v":0}]
[null,"The total maximum loan must be greater than $58 825."]
[]
[]
[null,"4. FINANCEMENT (en $)"]
[]
[]
[null,null,"Exercice financier terminé le : ",null,null,null,null,null,null,null,null,{"$f":"IF('General Information'!G15=\"\",\"\",'General Information'!G15)","v":""},{"$f":"IF('General Information'!L15=\"\",\"\",'General Information'!L15)","v":""},null,"Total"]
[null,null,"Total des dépenses (report des feuilles Calculs.)",null,null,null,null,null,null,null,null,{"$f":"'Year 1 CALCULATIONS'!E32","v":0},{"$f":"'Year 2 CALCULATIONS'!E32","v":0},null,{"$f":"SUM(L28,M28)","v":0}]
[]
[]
[null,null,"Exercice terminé le :",null,null,null,null,null,null,null,null,{"$f":"IF('General Information'!G15=\"\",\"\",'General Information'!G15)","v":""},{"$f":"IF('General Information'!L15=\"\",\"\",'General Information'!L15)","v":""},null,"Total"]
[null,null,"Actions ord. - Promoteurs (mise de fonds)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M32+L32)","v":0}]
[null,null,"Actions priv. - Promoteurs (mise de fonds)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M33+L33)","v":0}]
[null,null,"Avance d'actionnaires",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M34+L34)","v":0}]
[null,null,"Crédits d'impôt (non financés par IQ)",null,null,null,null,null,null,null,null,{"$f":"L14-L19","v":0},{"$f":"M14-M19","v":0},null,{"$f":"L35+M35","v":0}]
[null,null,"Fonds de roulement",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M36+L36)","v":0}]
[null,null,"Prêt garanti par IQ",null,null,null,null,null,null,null,null,{"$f":"L19","v":0},{"$f":"M19","v":0},null,{"$f":"L37+M37","v":0}]
[null,null,"Autre (préciser) :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M38+L38)","v":0}]
[null,null,"Total:  ",null,null,null,null,null,null,null,null,{"$f":"SUM(L32:L38)","v":0},{"$f":"SUM(M32:N38)","v":0},null,{"$f":"SUM(O32:P38)","v":0}]
[null,null,"Le total des dépenses doit être égal au total du financement"]
[]
[]
[]
[null,"5. MONTANT GARANTI ET HONORAIRES"]
[]
[null,"Calcul du montant de la garantie"]
[null,"Montant du prêt",null,null,null,null,null,null,null,null,null,{"$f":"O19","v":0}]
[]
[null,"Montant de la garantie à 85%",null,null,null,null,null,null,null,null,null,{"$f":"L47*0.85","v":0}]
[]
[null,"Calcul des honoraires"]
[null,"Honoraires de garantie (2,5% du prêt)",null,null,null,null,null,null,null,null,null,{"$f":"L47*0.025","v":0}]
[null,"Frais d'étude (1,0% du prêt)",null,null,null,null,null,null,null,null,null,{"$f":"L47*0.01","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"L52+L53","v":0}]

{"sheet":"Calculs","index":5,"n_rows":173,"n_cols":21,"rows_kept":173,"cut":false,"hidden":true,"merged":[[0,7,0,15],[0,1,0,5],[2,0,2,16],[3,0,3,16],[56,2,56,16],[5,2,5,16],[7,3,7,16],[13,2,13,3],[14,2,14,3],[16,2,16,10],[19,2,19,4],[163,10,163,12],[149,10,149,12],[30,8,30,10],[22,3,22,15],[23,3,23,15],[35,2,35,15],[161,2,161,16],[31,8,31,10],[147,2,147,16]]}
[null,null,null,null,null,null,null,"Financement des crédits d'impôt remboursables à la R & D"]
[]
["SCHÉMA D'ANALYSE"]
["Calculs relatifs aux crédits d'impôt à financer"]
[]
[null,null,"1.  ADMISSIBILITÉ AUX CRÉDITS D'IMPÔT REMBOURSABLES"]
[]
[null,null,"1.1"," Admissibilité aux crédits d'impôt remboursables (Québec)"]
[]
[null,null,null,"Date de la fin du premier exercice financier financé :"]
[null,null,null,"Date de la fin du deuxième exercice financier financé :"]
[]
[]
[null,null,"Actifs de :",null,null,null,null,"$","*",null,"en date du :",null,{"$f":"IF(M10=\"\",\"\",IF(M10>DATE(2005,2,28),M10-365,IF(M10<DATE(2004,2,29),M10-365,IF(M10=\"\",0,M10-366))))","v":""}]
[null,null,"Actifs de :",null,null,null,null,"$","*",null,"en date du :",null,{"$f":"IF(M11=\"\",\"\",IF(M11>DATE(2005,2,28),M11-365,IF(M11<DATE(2004,2,29),M11-365,IF(M11=\"\",0,M11-366))))","v":""}]
[]
[null,null,"* : Y compris les actifs des corporations associées, s'il y a lieu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000000,0.33500000000000002]
[null,null,"Taux de calcul des crédits d'impôt à la R & D sur dépenses admissibles nettes n'excédant pas 2 millions $:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30000000,0.29499999999999998]
[null,null,"année teminée:",null,null,null,{"$f":"IF((K39>0),(K39),0)","v":""},":",{"$f":"IF(G14=\"\",\"\",IF(G14>0,VLOOKUP(G14,T17:U22,2),IF(G14<25000000,0.375,0)))","v":""},null,{"$f":"IF((M39>0),(M39),0)","v":""},":",{"$f":"IF(G15=\"\",\"\",IF(G15>0,VLOOKUP(G15,T17:U22,2),IF(G15<25000000,0.375,0)))","v":""},null,null,null,null,null,null,35000000,0.27500000000000002]
[null,null,"Taux de calcul des crédits d'impôt à la R & D sur dépenses admissibles nettes excédant 2 millions $ :",null,null,null,null,null,null,null,null,null,null,null,null,0.17499999999999999,null,null,null,37500000,0.255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40000000,0.215]
[null,null,"1.2","Admissibilité aux crédits d'impôt remboursables (Canada) pour le financement des EXERCICES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000000]
[null,null,null,"FINANCIERS 2004 ET SUIVANTS"]
[]
[null,null,"La corporation est une corporation privée à contrôle canadien dont le revenu imposable"]
[null,null,"pour le dernier exercice financier était inférieur à 500 000 $ (y compris les corporations"]
[null,null,"associées s'il y a lieu)."]
[]
[]
[null,null,"Revenu imposable de:",null,null,null,null,"$","Capital imposable:",null,null,null,null,"$","en date du:",{"$f":"+M14","v":""}]
[null,null,"Revenu imposable de:",null,null,null,null,"$","Capital imposable:",null,null,null,null,"$","en date du:",{"$f":"+M15","v":""}]
[]
[]
[]
[null,null,"2. PROJET"]
[]
[null,null,null,null,null,null,null,null,"Année financière débutant le : ",null,{"$f":"IF(K39=\"\",\"\",+K39-365)","v":""},null,{"$f":"IF(M11=\"\",\"\",+K39+1)","v":""}]
[null,null,null,null,null,null,null,null,"Année financière se terminant le : ",null,{"$f":"IF(M10=\"\",\"\",+M10)","v":""},null,{"$f":"IF(M11=\"\",\"\",+M11)","v":""}]
[null,null,null,null,null,null,null,null,null,"(nombre de mois)",{"$f":"IF(K38=\"\",\"\",+(K39-K38)/30.42)","v":""},null,{"$f":"IF(M38=\"\",\"\",+(M39-M38)/30.42)","v":""},null,null,"Total"]
[null,null,"Salaires - personnes désignées",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K41:O41)=0,\"\",SUM(K41:O41))","v":""}]
[null,null,"Autres salaires",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K42:O42)=0,\"\",SUM(K42:O42))","v":""}]
[null,null,"Avantages sociaux imposables",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Avantages sociaux non imposables",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Provision pour salaires et av. soc. ",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Sous-traitance (honoraires)",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Sous-traitance (honoraires) - personnes liées",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Sous-traitance - centres de recherche reconnus",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Matières, fournitures et prototypes",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Autres dépenses admissibles (fédéral seulement)",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Autres dépenses d'exploitation ou règle du 65 %",null,null,null,null,null,null,null,{"$f":"IF((K42+K41)*0.65=0,\"\",(K42+K41)*0.65)","v":""},null,{"$f":"IF((M42+M41)*0.65=0,\"\",(M42+M41)*0.65)","v":""},null,null,""]
[null,null,"Dépenses en capital",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Autres dépenses non admissibles",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(SUM(K41:K53)=0,\"\",SUM(K41:K53))","v":""},null,{"$f":"IF(SUM(M41:M53)=0,\"\",0)","v":""},null,null,""]
[]
[]
[null,null,"3. CALCUL DES CRÉDITS À FINANCER (en $)"]
[]
[null,null,null,null,null,null,null,null,null,"Exercice(s) terminé(s) le :",{"$f":"K39","v":""},null,{"$f":"M39","v":""},null,null,"Total"]
[null,null,"3.1","Crédits d'impôt (Québec)"]
[null,null,null,"Salaires - personnes désignées",null,null,null,null,null,null,{"$f":"IF(K41=0,\"\",K41)","v":""},null,{"$f":"IF(M41=0,\"\",M41)","v":""},null,null,{"$f":"IF(SUM(K61:O61)=0,\"\",SUM(K61:O61))","v":""}]
[null,null,null,"Autres salaires",null,null,null,null,null,null,{"$f":"IF(K42=0,\"\",K42)","v":""},null,{"$f":"IF(M42=0,\"\",M42)","v":""},null,null,""]
[null,null,null,"Avantages soc. imposables",null,null,null,null,null,null,{"$f":"IF(K43=0,\"\",K43)","v":""},null,{"$f":"IF(M43=0,\"\",M43)","v":""},null,null,""]
[null,null,null,"Provision pour salaires et av. soc.",null,null,null,null,null,null,{"$f":"IF(K45=0,\"\",K45)","v":""},null,{"$f":"IF(M45=0,\"\",M45)","v":""},null,null,""]
[null,null,null,"Sous-traitance (honoraires) admiss. à 50 %",null,null,null,null,null,null,{"$f":"IF(K46*50%=0,\"\",K46*50%)","v":""},null,{"$f":"IF(M46*50%=0,\"\",M46*50%)","v":""},null,null,""]
[null,null,null,"Ss-traitance (honoraires) pers. liées (adm. moyenne 80%)",null,null,null,null,null,null,{"$f":"IF(K47*80%=0,\"\",K47*80%)","v":""},null,{"$f":"IF(M47*50%=0,\"\",M47*50%)","v":""},null,null,""]
[null,null,null,"Ss-trait. Ctres recherche reconnus (adm. 50 % ou 80 %)",null,null,null,null,null,null,{"$f":"IF(K48*50%=0,\"\",K48*50%)","v":""},null,{"$f":"IF(M48*50%=0,\"\",M48*50%)","v":""},null,null,""]
[]
[null,null,null,"Moins:","dépenses refusées",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K69:O69)=0,\"\",SUM(K69:O69))","v":""}]
[null,null,null,null,"subventions",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K70:O70)=0,\"\",SUM(K70:O70))","v":""}]
[]
[null,null,null,"Dépenses nettes admissibles  ",null,null,null,null,null,null,{"$f":"IF(SUM(K61:K70)=0,\"\",SUM(K61:K70))","v":""},null,{"$f":"IF(SUM(M61:M70)=0,\"\",SUM(M61:M70))","v":""},null,null,{"$f":"IF(SUM(K72:O72)=0,\"\",SUM(K72:O72))","v":""}]
[]
[null,null,null,"Crédits à 37,5 % pr dép. adm. < = 2 000 000 $ ",null,null,null,null,null,null,{"$f":"IF(K72=\"\",\"\",IF(IF(K$38>0,IF(K72>2000000,(2000000*I20),(K$72*$I$20)),0)=0,\"\",IF(K$38>0,IF(K72>2000000,(2000000*I20),(K$72*$I$20)),0)))","v":""},null,{"$f":"IF(M72=\"\",\"\",IF(IF(M$38>0,IF(M72>2000000,(2000000*M20),(M$72*$M$20)),0)=0,\"\",IF(M$38>0,IF(M72>2000000,(2000000*M20),(M$72*$M$20)),0)))","v":""},null,null,{"$f":"IF(SUM(K74:O74)=0,\"\",SUM(K74:O74))","v":""}]
[null,null,null,"Crédits à 17,5 % pr dép. adm. > 2 000 000 $",null,null,null,null,null,null,{"$f":"IF(K72=\"\",\"\",IF(K$38>0,IF((K$72)>2000000,((K$72-2000000)*0.175),0)))","v":""},null,{"$f":"IF(M72=\"\",\"\",IF(M$38>0,IF((M$72)>2000000,((M$72-2000000)*0.175),0)))","v":""},null,null,{"$f":"IF(SUM(K75:O75)=0,\"\",SUM(K75:O75))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K74:K75)=0,\"\",SUM(K74:K75))","v":""},null,{"$f":"IF(SUM(M74:M75)=0,\"\",SUM(M74:M75))","v":""}]
[null,null,null,"Moins: taxe sur le capital (net)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K77:O77)=0,\"\",SUM(K77:O77))","v":""}]
[null,null,null,"Total des crédits d'impôt remboursables (Québec)",null,null,null,null,null,null,{"$f":"IF(K74=\"\",\"\",IF(ROUND(+K76+K77,0)=0,\"\",ROUND(+K76+K77,0)))","v":""},null,{"$f":"IF(M74=\"\",\"\",IF(ROUND(+M76+M77,0)=0,\"\",ROUND(+M76+M77,0)))","v":""},null,null,{"$f":"IF(IF(SUM(K78:O78)=0,\"\",SUM(K78:O78))=0,\"\",IF(SUM(K78:O78)=0,\"\",SUM(K78:O78)))","v":""}]
[]
[]
[null,null,"3.2","Crédits d'impôt (Canada)"]
[]
[null,null,null,"Salaires - personnes désignées",null,null,null,null,null,null,{"$f":"IF(K41=0,\"\",K41)","v":""},null,{"$f":"IF(M41=0,\"\",M41)","v":""},null,null,{"$f":"IF(SUM(K83:O83)=0,\"\",SUM(K83:O83))","v":""}]
[null,null,null,"Autres salaires",null,null,null,null,null,null,"",null,"",null,null,{"$f":"IF(SUM(K84:O84)=0,\"\",SUM(K84:O84))","v":""}]
[null,null,null,"Avantages soc. imposables",null,null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,"Avantages soc. non imposables",null,null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,"Provision pour salaires et av. soc. ",null,null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,"Sous-traitance (honoraires) Admiss. 100 %",null,null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,"Ss-traitance (hon.) - personnes liées. Admiss moy. 80%",null,null,null,null,null,null,{"$f":"IF(K47*80%=0,\"\",K47*80%)","v":""},null,{"$f":"IF(M47*80%=0,\"\",M47*80%)","v":""},null,null,""]
[null,null,null,"Ss-traitance - ctres de recherche reconnus. Admiss. 100%",null,null,null,null,null,null,{"$f":"IF(K48=0,\"\",K48)","v":""},null,{"$f":"IF(M48=0,\"\",M48)","v":""},null,null,""]
[null,null,null,"Matières, fournitures et prototypes",null,null,null,null,null,null,{"$f":"IF(K49=0,\"\",K49)","v":""},null,{"$f":"IF(M49=0,\"\",M49)","v":""},null,null,""]
[null,null,null,"Autres dépenses admissibles",null,null,null,null,null,null,{"$f":"IF(K50=0,\"\",K50)","v":""},null,{"$f":"IF(M50=0,\"\",M50)","v":""},null,null,""]
[null,null,null,"Autres dépenses d'exploitation ou règle du 65 %",null,null,null,null,null,null,{"$f":"IF(K51=0,\"\",K51)","v":""},null,{"$f":"IF(M51=0,\"\",M51)","v":""},null,null,""]
[]
[null,null,null,"Dépenses courantes admissibles",null,null,null,null,null,null,{"$f":"IF(SUM(K83:K93)=0,\"\",SUM(K83:K93))","v":""},null,{"$f":"IF(SUM(M83:M93)=0,\"\",SUM(M83:M93))","v":""},null,null,{"$f":"IF(SUM(K95:O95)=0,\"\",SUM(K95:O95))","v":""}]
[]
[null,null,null,"Moins:","dépenses refusées",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K97:O97)=0,\"\",SUM(K97:O97))","v":""}]
[null,null,null,null,"subventions",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K98:O98)=0,\"\",SUM(K98:O98))","v":""}]
[null,null,null,null,"crédits d'impôt du Québec (seul. ceux R & D)",null,null,null,null,null,{"$f":"IF(K78=\"\",\"\",IF(IF(K78>0,(-(K78)),0)=0,\"\",IF(K78>0,(-(K78)),0)))","v":""},null,{"$f":"IF(M78=\"\",\"\",IF(IF(M78>0,(-(M78)),0)=0,\"\",IF(M78>0,(-(M78)),0)))","v":""},null,null,{"$f":"IF(SUM(K99:O99)=0,\"\",SUM(K99:O99))","v":""}]
[]
[null,null,null,"Dépenses courantes nettes admissibles",null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(K95+K97+K98+K99,0)),\"\",ROUND(K95+K97+K98+K99,0))","v":""},null,{"$f":"IF(ISERROR(ROUND(M95+M97+M98+M99,0)),\"\",ROUND(M95+M97+M98+M99,0))","v":""},null,null,{"$f":"IF(SUM(K101:O101)=0,\"\",SUM(K101:O101))","v":""}]
[]
[null,null,null,"Dépenses en capital",null,null,null,null,null,null,{"$f":"IF(+K52=0,\"\",+K52)","v":""},null,{"$f":"IF(M52=0,\"\",M52)","v":""},null,null,{"$f":"IF(SUM(K103:O103)=0,\"\",SUM(K103:O103))","v":""}]
[]
[null,null,null,"Moins:","dépenses refusées",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K105:O105)=0,\"\",SUM(K105:O105))","v":""}]
[null,null,null,null,"subventions",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K106:O106)=0,\"\",SUM(K106:O106))","v":""}]
[]
[null,null,null,"Dépenses en capital nettes admissibles",null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(K103+K105+K106,0)),\"\",ROUND(K103+K105+K106,0))","v":""},null,{"$f":"IF(ISERROR(ROUND(M103+M105+M106,0)),\"\",ROUND(M103+M105+M106,0))","v":""},null,null,{"$f":"IF(SUM(K108:O108)=0,\"\",SUM(K108:O108))","v":""}]
[]
[null,null,null,"Calcul de la limite de dépenses donnant droit"]
[null,null,null,"aux crédits remboursables"]
[null,null,null,null,"Maximum",null,null,null,null,null,{"$f":"IF(P31=\"\",\"\",IF(IF(P31<=DATE(2002,12,31),4000000,5000000)=0,\"\",IF(P31<=DATE(2002,12,31),4000000,5000000)))","v":""},null,{"$f":"IF(P32=\"\",\"\",IF(IF(P32<=DATE(2002,12,31),4000000,5000000)=0,\"\",IF(P32<=DATE(2002,12,31),4000000,5000000)))","v":""}]
[null,null,null,null,"Moins: 10 fois le plus élevé de:"]
[null,null,null,null,"           300 000 $",null,null,null,null,null,3000000,null,3000000]
[null,null,null,null,"     revenu imposable:",null,null,null,null,null,{"$f":"IF(10*G31=0,\"\",10*G31)","v":""},null,{"$f":"IF(10*G32=0,\"\",10*G32)","v":""}]
[]
[null,null,null,null,"Limite de dépenses",null,null,null,null,null,{"$f":"IF(ISERROR(IF((K114-K112)>0,0,IF((K115-K112)>0,0,IF(K114>=K115,(K112-K114),(K112-K115))))),\"\",IF((K114-K112)>0,0,IF((K115-K112)>0,0,IF(K114>=K115,(K112-K114),(K112-K115)))))","v":""},null,{"$f":"IF(ISERROR(IF((M114-M112)>0,0,IF((M115-M112)>0,0,IF(M114>=M115,(M112-M114),(M112-M115))))),\"\",IF((M114-M112)>0,0,IF((M115-M112)>0,0,IF(M114>=M115,(M112-M114),(M112-M115)))))","v":""}]
[]
[null,null,null,null,"Limite de dépenses nette (a)",null,null,null,null,null,{"$f":"IF(ISERROR(IF(K117*(1-$T122)>0,K117*(1-$T122),0.01)),\"\",IF(K117*(1-$T122)>0,K117*(1-$T122),0.01))","v":""},null,{"$f":"IF(ISERROR(IF(M117*(1-$U122)>0,M117*(1-$U122),0.01)),\"\",IF(M117*(1-$U122)>0,M117*(1-$U122),0.01))","v":""}]
[null,null,null,null,"(a)  Calculée selon le montant du capital imposable."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($M31-10000000)>0,$M31-10000000,0)","v":0},{"$f":"IF(($M32-10000000)>0,$M32-10000000,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$T121/5000000","v":0},{"$f":"$U121/5000000","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+J59","v":"Exercice(s) terminé(s) le :"},{"$f":"+K59","v":""},null,{"$f":"+M59","v":""}]
[]
[null,null,null,"Calcul des crédits d'impôt bonifiés remboursables à 35 %",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P59","v":"Total"}]
[null,null,null,null,"Le moindre de:"]
[null,null,null,null,"     a)  dépenses courantes nettes admiss.",null,null,null,null,null,{"$f":"IF(ISERROR(IF(((K101+K108)<2000000),K101,T129)),\"\",IF(((K101+K108)<2000000),K101,T129))","v":""},null,{"$f":"IF(ISERROR(IF(((M101+M108)<2000000),M101,U129)),\"\",IF(((M101+M108)<2000000),M101,U129))","v":""},null,null,{"$f":"IF(SUM(K127:O127)=0,\"\",SUM(K127:O127))","v":""}]
[null,null,null,null,"          dépenses en capital nettes admiss.",null,null,null,null,null,{"$f":"IF(ISERROR(IF(((K101+K108)<2000000),K108,T130)),\"\",IF(((K101+K108)<2000000),K108,T130))","v":""},null,{"$f":"IF(ISERROR(IF(((M101+M108)<2000000),M108,U130)),\"\",IF(((M101+M108)<2000000),M108,U130))","v":""},null,null,{"$f":"IF(SUM(K128:O128)=0,\"\",SUM(K128:O128))","v":""}]
[null,null,null,null,null,null,"ou",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K101","v":""},{"$f":"M101","v":""}]
[null,null,null,null,"     b)  limite de dépenses nette",null,null,null,null,null,{"$f":"IF((K119>0),K119,0)","v":""},null,{"$f":"IF((M119>0),M119,0)","v":""},null,null,{"$f":"IF(SUM(K130:O130)=0,\"\",SUM(K130:O130))","v":""},null,null,null,{"$f":"IF(($K130-$K127)>0,($K130-$K127),$K108)","v":{"$error":"#VALUE!"}},{"$f":"IF(($M130-$M127)>0,($M130-$M127),$M108)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"35 % du moindre de (a) ou (b)"]
[null,null,null,null,"          dépenses courantes",null,null,null,null,null,{"$f":"IF(ISERROR(IF((K127>K130),(K130*0.35),(K127*0.35))),\"\",IF((K127>K130),(K130*0.35),(K127*0.35)))","v":""},null,{"$f":"IF(ISERROR(IF((M127>M130),(M130*0.35),(M127*0.35))),\"\",IF((M127>M130),(M130*0.35),(M127*0.35)))","v":""},null,null,{"$f":"IF(SUM(K133:O133)=0,\"\",SUM(K133:O133))","v":""}]
[null,null,null,null,"          dépenses en capital (remb. à 40 %)",null,null,null,null,null,{"$f":"IF(ISERROR(IF((K133=(K130*0.35)),0.01,(K128*0.35*0.4))),\"\",IF((K133=(K130*0.35)),0.01,(K128*0.35*0.4)))","v":""},null,{"$f":"IF(ISERROR(IF((M133=(M130*0.35)),0.01,(M128*0.35*0.4))),\"\",IF((M133=(M130*0.35)),0.01,(M128*0.35*0.4)))","v":""},null,null,{"$f":"IF(SUM(K134:O134)=0,\"\",SUM(K134:O134))","v":""}]
[]
[null,null,null,"Total des crédits d'impôt remboursables à 35 %",null,null,null,null,null,null,{"$f":"IF(SUM(K133:K134)=0,\"\",SUM(K133:K134))","v":""},null,{"$f":"IF(SUM(M133:M134)=0,\"\",SUM(M133:M134))","v":""},null,null,{"$f":"IF(SUM(K136:O136)=0,\"\",SUM(K136:O136))","v":""}]
[]
[null,null,null,"Calcul des crédits d'impôt réguliers "]
[null,null,null,"(20 %, remboursable à 40 %) pour dépenses"]
[null,null,null,"de R&D excédant 2 000 000 $"]
[null,null,null,"N.B.  Crédit remboursable seulement si le revenu imposable "]
[null,null,null,"de l'exercice précédant n'excède pas 300 000 $"]
[null,null,null,null,"dépenses totales excédant 2 000 000 $",null,null,null,null,null,{"$f":"IF(ISERROR(IF((K101+K108)>2000000,(K101+K108)-2000000,0)),\"\",IF((K101+K108)>2000000,(K101+K108)-2000000,0))","v":""},null,{"$f":"IF(ISERROR(IF((M101+M108)>2000000,(M101+M108)-2000000,0)),\"\",IF((M101+M108)>2000000,(M101+M108)-2000000,0))","v":""},null,null,{"$f":"IF(SUM(K143:O143)=0,\"\",SUM(K143:O143))","v":""}]
[null,null,null,null,"Crédits d'impôts réguliers remboursables",null,null,null,null,null,{"$f":"IF(ISERROR(IF((F31<200001),K143*0.2*0.4,0)),\"\",IF((F31<200001),K143*0.2*0.4,0))","v":""},null,{"$f":"IF(ISERROR(IF((F31<200001),M143*0.2*0.4,0)),\"\",IF((F31<200001),M143*0.2*0.4,0))","v":""},null,null,{"$f":"IF(SUM(K144:O144)=0,\"\",SUM(K144:O144))","v":""}]
[]
[null,null,null,"Crédits d'impôt remboursables à financer (Canada)",null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(K136+K144,0)),\"\",ROUND(K136+K144,0))","v":""},null,{"$f":"IF(ISERROR(ROUND(M136+M144,0)),\"\",ROUND(M136+M144,0))","v":""},null,null,{"$f":"IF(SUM(K146:O146)=0,\"\",SUM(K146:O146))","v":""}]
[]
[null,null,"4.  PRÊT MAXIMAL (en $)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Exercice(s) terminé(s) le :",{"$f":"K59","v":""},null,{"$f":"M59","v":""},null,null,"Total"]
[null,null,"Crédits d'impôt remboursables (Québec) à financer",null,null,null,null,null,null,null,{"$f":"+K78","v":""},null,{"$f":"M78","v":""},null,null,{"$f":"IF(SUM(K152:O152)=0,\"\",SUM(K152:O152))","v":""}]
[null,null,"Crédits d'impôt remboursables (Canada ) à financer",null,null,null,null,null,null,null,{"$f":"IF(F31<200001,K146,K136)","v":""},null,{"$f":"IF(F31<200001,M146,M136)","v":""},null,null,""]
[null,null,"Total des crédits de l'année",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(K152+K153),\"\",K152+K153)","v":""},null,{"$f":"IF(ISERROR(M152+M153),\"\",M152+M153)","v":""},null,null,""]
[null,null,"Prêt maximal à 75 %",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(K154*0.75),\"\",K154*0.75)","v":""},null,{"$f":"IF(ISERROR(M154*0.75),\"\",M154*0.75)","v":""},null,null,""]
[null,null,null,"Montant financé par le dossier précédent no ",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Montant à financer par ce nouveau dossier no",null,null,null,null,null,null,{"$f":"IF(ISERROR(K155-K156),\"\",K155-K156)","v":""},null,{"$f":"IF(ISERROR(M155-M156),\"\",M155-M156)","v":""},null,null,""]
[null,null,"Portion financée (en %)",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF((K154)>0,(K159/K154),0)),\"\",IF((K154)>0,(K159/K154),0))","v":""},null,{"$f":"IF(ISERROR(IF((M154)>0,(M159/M154),0)),\"\",IF((M154)>0,(M159/M154),0))","v":""},null,null,{"$f":"IF(ISERROR(IF((P154)>0,(P159/P154),0)),\"\",IF((P154)>0,(P159/P154),0))","v":""}]
[null,null,"Crédits financés (année courante, arrondis)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K159:O159)=0,\"\",SUM(K159:O159))","v":""}]
[null,null,"1er certificat de garantie annuel (80 %)",null,null,null,null,null,null,null,{"$f":"IF(K159*0.8=0,\"\",K159*0.8)","v":""},null,{"$f":"IF(M159*0.8=0,\"\",M159*0.8)","v":""},null,null,{"$f":"IF(SUM(K160:O160)=0,\"\",SUM(K160:O160))","v":""}]
[]
[null,null,"5. FINANCEMENT"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Exercice(s) terminé(s) le :",{"$f":"K151","v":""},null,{"$f":"M151","v":""},null,null,"Total"]
[null,null,"Mise de fonds",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K166:O166)=0,\"\",SUM(K166:O166))","v":""}]
[null,null,"Dettes à terme",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K167:O167)=0,\"\",SUM(K167:O167))","v":""}]
[null,null,"Subventions",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Fonds de roulement",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Autre (préciser) :",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Crédits d'impôt Québec",null,null,null,null,null,null,null,{"$f":"K152","v":""},null,{"$f":"M152","v":""},null,null,""]
[null,null,"Crédits d'impôt Canada",null,null,null,null,null,null,null,{"$f":"K153","v":""},null,{"$f":"M153","v":""},null,null,""]
[null,null,null,null,null,null,null,null,null,"Total :",{"$f":"IF(SUM(K166:K172)=0,\"\",SUM(K166:K172))","v":""},null,{"$f":"IF(SUM(M166:M172)=0,\"\",SUM(M166:M172))","v":""},null,null,{"$f":"SUM(P166:P172)","v":0}]