{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","General information","Financing"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":31,"comments":1,"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 investment tax credits for manufacturing and processing equipment"]
[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":403,"n_cols":19,"rows_kept":403,"cut":false,"hidden":false,"merged":[[163,12,163,15],[156,12,156,15],[162,12,162,15],[155,12,155,15],[159,13,159,15],[149,12,149,15],[140,1,140,15],[142,1,142,15],[70,1,70,5],[71,14,72,15],[71,12,72,13],[73,12,74,13],[73,1,73,5],[73,10,74,11],[70,10,70,11],[70,12,70,13],[71,6,72,9],[70,6,70,9],[89,10,90,11],[89,1,89,5],[79,12,80,13],[79,10,80,11],[83,10,84,11],[87,10,88,11],[212,1,212,11],[222,13,222,14],[144,1,144,5],[184,1,184,16],[162,1,167,3],[156,1,161,3],[147,1,155,3],[213,13,213,14],[215,13,215,14],[178,1,178,15],[156,4,161,8],[162,4,167,8],[146,1,146,3],[146,4,146,8],[147,4,155,8],[169,1,169,15],[147,9,155,11],[165,13,165,15],[162,9,167,11],[170,1,170,15],[176,1,176,15],[206,1,206,11],[144,6,144,8],[211,1,211,11],[235,1,235,10],[232,12,232,13],[233,12,233,13],[217,1,217,11],[218,1,218,11],[217,13,217,15],[235,14,235,15],[233,1,233,10],[220,1,220,11],[233,14,233,15],[234,1,234,10],[234,14,234,15],[223,1,223,11],[226,13,226,14],[229,11,229,12],[231,1,231,11],[335,1,335,4],[225,1,225,11],[333,12,333,14],[329,12,329,14],[332,12,332,14],[331,12,331,14],[321,12,321,14],[318,12,318,14],[320,12,320,14],[327,8,327,11],[319,6,319,7],[319,12,319,14],[324,12,324,14],[316,8,316,11],[316,6,316,7],[321,8,321,11],[318,6,318,7],[321,6,321,7],[320,1,320,4],[318,1,318,4],[288,7,289,8],[238,0,238,16],[226,1,226,11],[227,1,227,11],[390,13,391,15],[338,1,338,4],[292,1,292,5],[293,7,293,8],[331,1,331,4],[327,1,327,4],[329,1,329,4],[327,6,327,7],[232,14,232,15],[291,7,291,8],[317,8,317,11],[292,14,292,15],[314,1,314,15],[317,1,317,4],[317,12,317,14],[333,1,333,4],[234,12,234,13],[235,12,235,13],[313,1,313,15],[326,8,326,11],[325,12,325,14],[326,12,326,14],[335,12,335,14],[328,6,328,7],[292,12,292,13],[293,10,293,11],[317,6,317,7],[322,1,322,4],[321,1,321,4],[331,6,331,7],[326,1,326,4],[328,1,328,4],[330,12,330,14],[330,8,330,11],[329,6,329,7],[324,1,324,4],[319,1,319,4],[327,12,327,14],[320,6,320,7],[322,12,322,14],[316,12,316,14],[316,1,316,4],[293,12,293,13],[293,1,293,5],[292,7,292,8],[293,14,293,15],[292,10,292,11],[322,8,322,11],[397,13,397,15],[336,6,336,7],[333,6,333,7],[332,6,332,7],[332,8,332,11],[337,6,337,7],[335,6,335,7],[334,8,334,11],[395,13,396,15],[336,8,336,11],[390,6,391,12],[335,8,335,11],[334,6,334,7],[340,6,341,7],[376,1,376,16],[392,6,392,12],[338,6,338,7],[337,8,337,11],[338,12,338,14],[334,12,334,14],[332,1,332,4],[333,8,333,11],[340,15,341,15],[339,8,339,11],[405,5,405,9],[395,1,396,5],[395,6,396,12],[337,12,337,14],[397,1,397,5],[397,6,397,12],[320,8,320,11],[403,5,403,9],[390,1,391,5],[339,6,339,7],[392,1,392,5],[334,1,334,4],[340,1,341,4],[339,1,339,4],[343,1,343,4],[337,1,337,4],[336,1,336,4],[392,13,392,15],[323,1,323,4],[340,5,341,5],[359,1,359,15],[343,6,343,7],[338,8,338,11],[325,1,325,4],[339,12,339,14],[323,8,323,11],[323,6,323,7],[323,12,323,14],[329,8,329,11],[331,8,331,11],[318,8,318,11],[319,8,319,11],[324,6,324,7],[324,8,324,11],[328,8,328,11],[325,8,325,11],[325,6,325,7],[328,12,328,14],[322,6,322,7],[326,6,326,7],[336,12,336,14],[237,0,237,16],[206,13,206,14],[128,1,128,15],[121,1,121,2],[122,1,122,2],[130,1,130,15],[132,1,132,15],[122,11,122,14],[123,3,123,5],[122,3,122,5],[123,1,123,2],[180,1,180,15],[208,1,208,11],[209,1,209,11],[209,13,209,14],[215,1,215,11],[218,13,218,14],[220,13,220,14],[232,1,232,10],[222,1,222,11],[221,1,221,11],[216,1,216,11],[224,13,224,14],[224,1,224,11],[252,1,252,3],[254,1,254,7],[290,1,290,5],[290,14,290,15],[286,1,286,16],[290,10,290,11],[290,12,290,13],[291,12,291,13],[268,1,268,16],[288,12,289,13],[288,14,289,15],[290,7,290,8],[284,1,284,16],[291,1,291,5],[291,10,291,11],[291,14,291,15],[2,0,2,16],[3,0,3,16],[14,5,14,15],[11,5,11,15],[12,5,12,15],[10,5,10,15],[7,7,7,15],[8,7,8,15],[5,1,5,16],[157,12,157,15],[160,13,160,15],[120,1,120,2],[134,1,134,15],[77,14,78,15],[73,14,74,15],[79,1,79,5],[83,1,83,5],[90,1,90,5],[89,12,90,13],[78,1,78,5],[85,1,85,5],[77,10,78,11],[77,6,78,9],[89,6,90,9],[123,11,123,14],[122,6,122,8],[123,6,123,8],[123,9,123,10],[120,9,120,10],[121,9,121,10],[122,9,122,10],[151,13,151,15],[152,13,152,15],[85,6,86,9],[83,6,84,9],[86,1,86,5],[83,12,84,13],[32,1,32,16],[36,6,36,15],[36,1,36,5],[146,12,146,15],[146,9,146,11],[59,4,59,10],[40,6,40,8],[40,11,40,12],[98,1,98,15],[87,6,88,9],[84,1,84,5],[89,14,90,15],[121,3,121,5],[87,14,88,15],[118,1,118,15],[121,6,121,8],[112,1,112,15],[102,1,102,15],[95,1,95,15],[105,1,105,15],[116,1,116,15],[120,6,120,8],[120,3,120,5],[68,1,68,16],[72,1,72,5],[73,6,74,9],[63,12,63,15],[75,6,76,9],[70,14,70,15],[71,10,72,11],[82,1,82,5],[63,10,63,11],[76,1,76,5],[75,14,76,15],[81,6,82,9],[77,1,77,5],[79,6,80,9],[74,1,74,5],[75,1,75,5],[75,12,76,13],[71,1,71,5],[75,10,76,11],[63,4,63,8],[77,12,78,13],[21,11,21,15],[28,6,28,8],[26,6,26,15],[58,11,58,13],[39,13,39,15],[56,6,56,15],[54,1,54,16],[58,4,58,10],[39,6,39,8],[40,13,40,15],[53,1,53,16],[404,5,404,9],[289,1,289,3],[378,0,378,16],[330,1,330,4],[330,6,330,7],[340,8,341,11],[343,12,343,14],[340,12,341,14],[79,14,80,15],[81,14,82,15],[85,14,86,15],[81,10,82,11],[81,12,82,13],[83,14,84,15],[85,10,86,11],[85,12,86,13],[81,1,81,5],[88,1,88,5],[87,1,87,5],[80,1,80,5],[110,1,110,15],[91,14,91,15],[120,11,120,14],[87,12,88,13],[136,7,136,9],[107,1,107,15],[402,1,403,3],[288,10,289,11],[242,1,242,3],[240,1,240,16],[166,13,166,15],[15,5,15,15],[16,5,16,15],[28,13,28,15],[19,1,19,5],[23,1,23,5],[156,9,161,11],[121,11,121,14],[17,1,17,5],[20,11,20,15],[58,14,58,15],[61,10,61,15],[41,0,41,16],[18,9,18,15],[20,3,20,7],[22,11,22,15],[24,6,24,15],[25,6,25,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Financing of investment tax credits for manufacturing and processing equipment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I8","v":0}]
["LOAN / GUARANTEE APPLICATION"]
["General Information"]
[]
["1.","IDENTIFICATION"]
[]
[null,"Name of the company submitting the application:",null,null,null,null,null," "]
[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,"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:",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,"Date on which"]
[null,null,null,null,null,null,"(yyyy-mm-dd)",null,null,null,null,"  operations began:",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 with the Canada Revenue Agency "]
[null,"or Revenu Québec?"]
[]
[null,"Are any disputes or notices of objection outstanding in respect of the Canada Revenue Agency"]
[null,"or of 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 person responsible for the account at the financial institution:"]
[]
[null,"Phone:",null,null,null,null,null,null,null,null,"Fax:"]
[]
[]
[]
[]
["4.","SHAREHOLDERS AND 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,"Years of experience in the industry",null,"Years of experience with the company",null,"% of voting shares held"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total :",{"$f":"IF(SUM(O72:P91)=0,\"\",SUM(O72:P91))","v":""}]
[]
[]
[]
["5.","ELIGIBILITY FOR THE TAX CREDITS"]
["  "]
[null,"5.1 Eligible company"]
[null,"Any company or partnership of which it is directly or indirectly a member, other than an excluded company which, during a taxation year, carries on a business in Québec and has an establishment there may, under certain conditions, claim the investment tax credit for such taxation year."]
[]
[null,"The expression “excluded company”, regarding a taxation year, means:"]
[]
[null,"    −    a company that is tax-exempt for the year;\n    −    a Crown corporation or a wholly-controlled subsidiary of such a corporation;\n    −    a company that produces aluminum;\n    −    an oil refining company."]
[]
[null,"5.2 Eligible investment"]
[null,"An eligible investment is an asset of class 43 (manufacturing and processing equipment) or class 29 acquired in 2008-2009. For the asset to be eligible, it must be a new asset used solely in Québec and mainly in the course of carrying on a business. The company must begin to use such asset within a reasonable time following its acquisition and must use it for a minimum period of  730 days."]
[]
[null,"The amount of a company’s eligible investment, for a taxation year, corresponds to the portion of the capital cost of the eligible investment that the company incurs during the year."]
[]
[null,"The assets must be acquired after March 13, 2008 and before January 1, 2016, unless:"]
[null,"    −    they are acquired in accordance with a written obligation contracted no later than March 13, 2008;\n    −    their construction, by the taxpayer or on his behalf, was already in progress on March 13, 2008. "]
[]
[null,"The amount of the eligible investment must be reduced by the amount of any government assistance, any non government assistance and any profit or gain, according to the usual rules."]
[]
[null,"The expense must have been paid at the time the company claims the investment tax credit."]
[]
[null,"The federal investment tax credit does not constitute government assistance for the purposes of determining the amount of an investment eligible for the investment tax credit."]
[]
[null,"5.3 History of tax credits received"]
[]
[null,"Year",null,"Level",null,null,"Amount claimed",null,null,"Date of income tax return filed",null," Amount received",null,null,null,"Date"]
[null,null,null,"Provincial"]
[null,null,null,"Provincial"]
[null,null,null,"Provincial"]
[]
[]
[]
[]
[null,"5.4 Paid-up capital calculated on a consolidated basis"]
[]
[null,"A company’s paid-up capital, calculated on a consolidated basis, is used to set the applicable rate of the investment tax credit as well as the refund rate of this tax credit."]
[]
[null,"Paid-up capital must be determined on a world basis, considering the paid-up capital attributable to associated companies including that of associated companies not subject to the Taxation Act."]
[]
[null,"The paid-up capital of the eligible company applicable to this given taxation year is the paid-up capital determined for its preceding taxation year. If this is the company's first fiscal year, paid-up capital is determined on the basis of its opening balance sheet prepared in accordance with generally accepted accounting principles."]
[]
[null,"Paid-up capital of the preceding taxation year:"]
[]
[null,"5.5 Rate of the credit"]
[]
[null,"The rate of the investment tax credit is 5%."]
[]
[null,"This rate is raised to 20% where the eligible investment is made in an intermediate zone, to 30% where the investment is made in the Bas-Saint-Laurent region and to 40% where the investment is made in a remote zone."]
[]
[null,"Please choose a zone",null,null,null,null,"Rate of the credit:",null,null,{"$f":"IF(B145=\"Please choose a zone\",\"-\",IF(H137<250000000,S148,IF(H137<500000000,S148-((S150*(H137-250000000))/250000000),0.05)))","v":"-"}]
[]
[null,"ZONES",null,null,"REGIONS",null,null,null,null,"PAID-UP CAPITAL OF THE PRECEDING TAXATION YEAR < $250 MILLION",null,null,"PAID-UP CAPITAL OF THE PRECEDING TAXATION YEAR > $250 MILLION < $500 MILLION"]
[null,"Intermediate zones",null,null," - Saguenay-Lac-Saint-Jean (02)\n - Mauricie (04)\n - Vallée-de-la-Gatineau RCM (50)\n - Pontiac RCM (51)\n - Antoine-Labelle RCM (52)",null,null,null,null,"  TC11 = 20%",null,null,null,null,null,null,null,null,{"$f":"IF(B145=B148,20%,IF(B145=B157,30%,IF(B145=B163,40%)))","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TC11 = 20% -",null,null,null,null,null,{"$f":"IF(B145=B148,15%,IF(B145=B157,25%,IF(B145=B163,35%)))","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," 15% X (Paid-up capital - $250 million)",null,null,null,null,{"$f":"IF(S148=J145,\"\",S148&\"- (\"&S150&\" * (\"&H137&\" - 250 000 000\" & \") / 250 000 000)\")","v":"FAUX- (FAUX * ( - 250 000 000) / 250 000 000)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"                     $250 million"]
[]
[]
[]
[null,"Bas-Saint-Laurent",null,null," - Bas-Saint-Laurent (01)",null,null,null,null,"  TC11 = 30%"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TC11 = 30% -"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"25% X (Paid-up capital - $250 million)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"                     $250 million"]
[]
[null,"Remote zones",null,null," - Abitibi-Témiscamingue (08)\n - Côte-Nord (09)\n - Nord-du-Québec (10)\n - Gaspésie - Iles-de-la-Madeleine (11)",null,null,null,null,"  TC11 = 40%"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TC11 = 40% -"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"35% X (Paid-up capital - $250 million)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"                     $250 million"]
[]
[]
[null,"-      TC11 = Rate of the investment tax credit"]
[null,"-      Paid-up capital: Paid-up capital is calculated on a world basis"]
[]
[]
[null,"Using the above table, establish the rates of the refundable tax credits for the fiscal year ending"]
[null,{"$f":"IF(ISBLANK(N207),\"(Enter a date in line 208)\",IF(ISBLANK(P207),TEXT(N207,\"AAAA-MM-JJ\") & \".\",TEXT(N207,\"AAAA-MM-JJ\") &\" and for the fiscal year ending \"& TEXT(P207,\"AAAA-MM-JJ\") &\".\"))","v":"(Enter a date in line 208)"}]
[]
[null,"If paid-up capital is ≥ $500 million, the rate of the tax credit is 5%; in this situation, the tax credit is not refundable."]
[]
[null,"The non-refundable portion of the investment tax credit relating to a taxation year that exceeds income tax and the tax on capital payable for such taxation year can be carried back to the preceding three taxation years or forward for twenty years."]
[]
[null,"However, such carry-over is not allowed regarding a taxation year ended before the day following the March 13, 2008 Budget Speech."]
[]
[]
[]
["6.","PROJECT"]
[]
[null,"6.1 Information on the eligible investment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6.2 Calculation of the eligible investment"]
[]
[null,"Fiscal year(s) ended (yyyy-mm-dd):"]
[]
[null,"Portion of the capital cost of the eligible investment made in the region that was "]
[null,"incurred in the taxation year and was paid;",null,null,null,null,null,null,null,null,null,null,"A)"]
[]
[null,"Payment, in the taxation year, of an amount received on account of government or non-"]
[null,"government assistance regarding an eligible investment made in the same region and "]
[null,"whose amount was entered in line “D” of a prior taxation year;",null,null,null,null,null,null,null,null,null,null,"B)"]
[]
[null,"Add the amounts of lines “A” and “B”;",null,null,null,null,null,null,null,null,null,null,"C)",{"$f":"N210+N214","v":0},null,{"$f":"P210+P214","v":0}]
[]
[null,"Government or non-government assistance attributable to the expense entered in line “A”;"]
[null,"(except for the federal investment tax credit)",null,null,null,null,null,null,null,null,null,null,"D)"]
[]
[null,"Profit or gain;",null,null,null,null,null,null,null,null,null,null,"E)"]
[]
[null,"Add the amounts of lines “D” and “E”;",null,null,null,null,null,null,null,null,null,null,"F)",{"$f":"N219+N221","v":0},null,{"$f":"P219+P221","v":0}]
[]
[null,"Amount of line “C” less that of line “F”. If the result is negative, enter “0”;",null,null,null,null,null,null,null,null,null,null,"G)",{"$f":"IF(N216-N223<0,\"0,00 $\",N216-N223)","v":0},null,{"$f":"IF(P216-P223<0,\"0,00 $\",P216-P223)","v":0}]
[]
[null,"Eligible investment.",null,null,null,null,null,null,null,null,null,null,"H)",{"$f":"N225","v":0},null,{"$f":"P225","v":0}]
[]
[]
[null,"6.3 Calculation of the investment tax credit "]
[]
[]
[null,{"$f":"B207","v":"Fiscal year(s) ended (yyyy-mm-dd):"},null,null,null,null,null,null,null,null,null,{"$f":"N207","v":"00:00:00"},{"$f":"P207","v":"00:00:00"},null,"Total"]
[null,"Amount of line “H”",null,null,null,null,null,null,null,null,null,{"$f":"N225","v":0},{"$f":"P225","v":0},null,{"$f":"SUM(L234,M234)","v":0}]
[null,"Rate of the investment tax credit determined in point 5.5",null,null,null,null,null,null,null,null,null,{"$f":"J145","v":"-"},{"$f":"J145","v":"-"},null,{"$f":"J145","v":"-"}]
[null,"Total of available tax credits",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(L234*L235),\"\",L234*L235)","v":""},{"$f":"IF(ISERROR(M234*M235),\"\",M234*M235)","v":""},null,{"$f":"SUM(L236,M236)","v":0}]
[]
[]
["SECTION IQ"]
[]
["7.","CAPACITÉ DE GESTION"]
[]
[null,"Capacité de gestion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Comité de gestion et/ou d'administration?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["8.","MISE EN SITUATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["9.","FINANCES"]
[]
[null,"10.1  Résultats d'exploitation et prévisions (000 $)"]
[]
[null,"Exercice(s) se terminant le :",null,null,null,null,null,"Revenus",null,null,"Amortissements",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(J291:L291)-M291=0,\"\",SUM(J291:L291)-M291)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J292:L292)-M292=0,\"\",SUM(J292:L292)-M292)","v":""}]
[null,null,null,null,null,null,"P",null,null,null,null,null,null,null,{"$f":"IF(SUM(J293:L293)-M293=0,\"\",SUM(J293:L293)-M293)","v":""}]
[null,null,null,null,null,null,"P",null,null,null,null,null,null,null,{"$f":"IF(SUM(J294:L294)-M294=0,\"\",SUM(J294:L294)-M294)","v":""}]
[]
[]
[null,"Est-ce que les prévisions financières apparaissent réalistes?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"9.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(F317=\"\",\"\",F317)","v":""},null,null,{"$f":"IF(G317=\"\",\"\",G317)","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,"Partiel-total actif court terme",null,null,null,{"$f":"IF(SUM(F318:F324)=0,\"\",SUM(F318:F324))","v":""},{"$f":"IF(SUM(G318:H324)=0,\"\",SUM(G318:H324))","v":""},null,"Partiel-total passif court terme",null,null,null,{"$f":"IF(SUM(M318:O324)=0,\"\",SUM(M318:O324))","v":""},null,null,{"$f":"IF(SUM(P318:P324)=0,\"\",SUM(P318:P324))","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,"Partiel-total passif",null,null,null,{"$f":"IF(SUM((M325:O330))=0,\"\",SUM((M325:O330)))","v":""},null,null,{"$f":"IF(SUM((P325:P330))=0,\"\",SUM((P325:P330)))","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(M333:O338)=0,\"\",SUM(M333:O338))","v":""},null,null,{"$f":"IF(SUM(P333:P338)=0,\"\",SUM(P333:P338))","v":""}]
[]
[null,"Total",null,null,null,{"$f":"IF(SUM(F325:F340)=0,\"\",SUM(F325:F340))","v":""},{"$f":"IF(SUM(G325:H340)=0,\"\",SUM(G325:H340))","v":""},null,"Total",null,null,null,{"$f":"IF(SUM(M331,M339)=0,\"\",SUM(M331,M339))","v":""},null,null,{"$f":"IF(SUM(P331,P339)=0,\"\",SUM(P331,P339))","v":""}]
[]
[]
[null,"Ratio fonds de roulement :",null,null,null,{"$f":"IF(ISERROR(IF((F325)>0,(F325/M325),0)),\"\",IF((F325)>0,(F325/M325),0))","v":""},{"$f":"IF(ISERROR(IF((G325)>0,(G325/P325),0)),\"\",IF((G325)>0,(G325/P325),0))","v":""},null,null,null,null,"Dette long terme / avoir net :",{"$f":"IF(ISERROR(IF((M339=0),0,M327/M339)),\"\",IF((M339=0),0,M327/M339))","v":""},null,null,{"$f":"IF(ISERROR(IF((P339=0),0,P327/P339)),\"\",IF((P339=0),0,P327/P339))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"9.3  Commentaires sur la capacité financière de l'entreprise à opérer jusqu'à l'encaissement des crédits d'impôt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10.","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":"Financing","index":2,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[29,14,29,15],[34,14,34,15],[31,12,31,13],[32,12,32,13],[30,14,30,15],[31,14,31,15],[32,14,32,15],[38,2,38,10],[37,2,37,10],[37,12,37,13],[34,12,34,13],[34,2,34,10],[36,2,36,10],[35,2,35,10],[35,12,35,13],[36,12,36,13],[0,1,0,5],[4,0,4,16],[5,0,5,16],[12,14,12,15],[12,12,12,13],[11,1,11,10],[11,14,11,15],[10,11,10,13],[12,1,12,10],[11,12,11,13],[13,1,13,10],[36,14,36,15],[15,12,15,13],[35,14,35,15],[14,12,14,13],[17,12,17,13],[18,12,18,13],[33,12,33,13],[33,2,33,10],[24,10,24,13],[30,12,30,13],[25,2,25,10],[29,2,29,10],[30,2,30,10],[26,2,26,10],[16,12,16,13],[13,14,13,15],[13,12,13,13],[14,14,14,15],[15,14,15,15],[16,14,16,15],[17,14,17,15],[18,14,18,15],[16,1,16,10],[17,1,17,10],[37,14,37,15],[18,1,18,6],[18,7,18,9],[19,1,19,13],[31,2,31,10],[32,2,32,10],[33,14,33,15],[29,12,29,13],[25,14,25,15],[26,14,26,15],[26,12,26,13],[25,12,25,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Financing of investment tax credits for manufacturing and processing equipment"]
[]
[]
["LOAN / GUARANTEE APPLICATION"]
["Calculations for tax credits to be financed"]
[]
[]
[null,"1. MAXIMUM LOAN ($)"]
[]
[]
[null,"Fiscal year(s) ended: ",null,null,null,null,null,null,null,null,null,{"$f":"'General information'!L233","v":"00:00:00"},{"$f":"'General information'!M233:N233","v":"00:00:00"},null,"Total"]
[null,"Refundable tax credits (Québec) to be financed",null,null,null,null,null,null,null,null,null,{"$f":"'General information'!L236","v":""},{"$f":"'General information'!M236:N236","v":""},null,{"$f":"IF(ISERROR(SUM(L13+M13)),\"\",SUM(L13+M13))","v":""}]
[null,"Maximum loan at 75%",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(L13*75%),\"\",L13*75%)","v":""},{"$f":"IF(ISERROR(M13*75%),\"\",M13*75%)","v":""},null,{"$f":"IF(ISERROR(SUM(L14:N14)),\"\",SUM(L14:N14))","v":0}]
[null,"Montant financé par dossier précédent",null,null,null,null,null,null,null,"n°.",null,null,null,null,{"$f":"SUM(L15:N15)","v":0}]
[null,"Montant à financer par ce nouveau dossier",null,null,null,null,null,null,null,"n°.",null,{"$f":"IF(ISERROR(L14-L15),\" \",L14-L15)","v":" "},{"$f":"IF(ISERROR(M14-M15),\"\",M14-M15)","v":""},null,{"$f":"SUM(L16:N16)","v":0}]
[null,"Portion financée (en %)",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND((L13)>0,L13<>\"\"),(L18/L13),0)","v":0},{"$f":"IF(AND((M13)>0,M13<>\"\"),(M18/M13),0)","v":0},null,{"$f":"IF(AND((O13)>0,O13<>\"\"),(O18/O13),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(L18:N18)","v":0}]
[null,"1er certificat de garantie annuel :",null,null,null,null,null,0.8,null,null,null,{"$f":"L18*H19","v":0},{"$f":"M18*H19","v":0}]
[null,"The total maximum loan must be greater than $25 000"]
[]
[]
[null,"2. FINANCEMENT (en $)"]
[]
[]
[null,null,"Exercice(s) financier(s) terminé(s) le : ",null,null,null,null,null,null,null,null,{"$f":"L12","v":"00:00:00"},{"$f":"M12","v":"00:00:00"},null,"Total"]
[null,null,"Total des dépenses (report des feuilles Calculs.)",null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR('General information'!N227),\"\",'General information'!N227)","v":0},{"$f":"IF(ISERROR('General information'!P227),\"\",'General information'!P227)","v":0},null,{"$f":"SUM(L27,M27)","v":0}]
[]
[]
[null,null,"Exercice(s) financier(s) terminé(s) le : ",null,null,null,null,null,null,null,null,{"$f":"L26","v":"00:00:00"},{"$f":"M26","v":"00:00:00"},null,"Total"]
[null,null,"Actions ordinaires. - Promoteurs (mise de fonds)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M31+L31)","v":0}]
[null,null,"Actions privés - Promoteurs (mise de fonds)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M32+L32)","v":0}]
[null,null,"Avance d'actionnaires",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M33+L33)","v":0}]
[null,null,"Crédits d'impôt (non financés par IQ)",null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(L13-L18),\"\",L13-L18)","v":""},{"$f":"IF(ISERROR(M13-M18),\"\",M13-M18)","v":""},null,{"$f":"IF(ISERROR(L34+M34),\"\",L34+M34)","v":""}]
[null,null,"Fonds de roulement",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M35+L35)","v":0}]
[null,null,"Prêt garanti par IQ",null,null,null,null,null,null,null,null,{"$f":"L18","v":0},{"$f":"M18","v":0},null,{"$f":"L36+M36","v":0}]
[null,null,"Autre (précisez) :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M37+L37)","v":0}]
[null,null,"Total :  ",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L37)","v":0},{"$f":"SUM(M31:N37)","v":0},null,{"$f":"SUM(O31:P37)","v":0}]
[null,null,"Total expenses must equal total financing"]
[]
[]
[]
[null,"3. MONTANT DE LA GARANTI ET DES HONORAIRES"]
[]
[null,"Calcul du montant de la garantie"]
[null,"Montant du prêt",null,null,null,null,null,null,null,null,null,{"$f":"O18","v":0}]
[]
[null,"Montant de la garantie à 80 %",null,null,null,null,null,null,null,null,null,{"$f":"L46*0.8","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":"L46*0.025","v":0}]
[null,"Frais d'étude (1,0 % du prêt)",null,null,null,null,null,null,null,null,null,{"$f":"L46*0.01","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"L51+L52","v":0}]