{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Disclaimer","Scoring Grid","Rents & Affordability","Project Budget ","Proforma - Residential","Proforma - Non-Residential","Drawdown Schedule "],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":26,"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":"Disclaimer","index":0,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,1,15,10],[16,1,19,10]]}
[]
[null,null,null,null,null,null,null,null,"File Type","Repair and Renewal"]
[null,null,null,null,null,null,null,null,"Version ","2020-10-23"]
[]
[null,"Legal Disclaimer and Notice  - This Assessment Tool provided by CMHC is for general illustrative and estimation purposes only. The amounts it projects are based upon the information provided and the assumptions and estimates made by the model.  CMHC does not guarantee these projections. They are not intended to provide financial or other advice on particular housing projects and they should not be relied upon in that regard.  Neither CMHC nor any of its employees or advisors shall have any liability for the accuracy of the projections contained in the tool or for any damage caused by the use of the information.   The use of this Assessment Tool and its results with regard to any housing project do not oblige CMHC to insure the project financing nor provide funding for the housing project under this initiative or under any other CMHC program or initiative.  You are encouraged to contact your local CMHC Affordable Housing Consultant for assistance with this tool."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This Assessment Tool is protected by copyright and is subject to the protection of intellectual property laws. Users are authorized to download the Assessment Tool for its use in relation to the National Housing Co-Investment Fund only and may not further copy, reproduce, modify or distribute the Assessment Tool without the prior written consent of CMHC."]

{"sheet":"Scoring Grid","index":1,"n_rows":152,"n_cols":12,"rows_kept":152,"cut":false,"hidden":false,"merged":[[71,1,71,4],[1,0,1,13],[2,1,2,11],[2,13,112,13],[5,1,5,4],[12,1,12,4],[20,1,20,4],[27,1,27,4],[34,1,34,4],[43,1,43,4],[47,1,47,4],[51,1,51,4],[55,1,55,4],[59,1,59,4],[63,1,63,4],[67,1,67,4],[149,3,151,3],[75,1,75,4],[79,1,79,4],[84,1,84,4],[91,1,91,4],[97,1,97,4],[98,1,98,8],[101,1,101,11],[109,1,110,12],[124,3,124,6],[130,3,130,6],[136,3,136,6]]}
["Note: Only YELLOW hi-lighted fields that are applicable need to be input. "]
["NHCF Prioritization Scoring: Repair and Renewal"]
[null,"Please select the appropriate result for each criteria from the drop-down menu under \"Answer\". The combined score from all the categories will be used to determine the maximum primary funding.  The scores from the affodability, accessibility and environmental efficiency categories below will be used in determining the maximum eligibility for forgivable loan, for higher performance.  "]
[null,null,null,null,null,"Weight","Maximum Points Available",null,"Answer","Score","Weighted Score","Percentage Score"]
[null,"Affordability",null,null,null,30,{"$f":"SUM(G6,G13)","v":10},null,null,{"$f":"SUM(J6,J13)","v":0},{"$f":"SUM(K6,K13)","v":0},{"$f":"(K6+K13)/((F6*G6)+(F13*G13))","v":0}]
[null,"What percentage of units are at rental costs less than 80% of median market rent?",null,null,null,15,5,"¢",null,{"$f":"IF(I6=C7,G7,IF(I6=C8,G8,IF(I6=C9,G9,IF(I6=C10,G10,IF(I6=C11,G11,IF(I6=C12,G12,))))))","v":0},{"$f":"J6*F6","v":0}]
[null,null,"1.     30% of units are at rental cost of less than 80% of Median Market Rent ",null,null,null,0]
[null,null,"2.     31% to 40% of units at rental cost of less than 80% of Median Market Rent ",null,null,null,1]
[null,null,"3.     41% to 45% of units at rental cost of less than 80% of Median Market Rent ",null,null,null,2]
[null,null,"4.     46% to 50% of units at rental cost of less than 80% of Median Market Rent ",null,null,null,3]
[null,null,"5.     Above 50% of units at rental cost of less than 80% of Median Market Rent ",null,null,null,5]
[]
[null,"For units that are designated as affordable, what is the average rental amount?",null,null,null,15,5,"¢",null,{"$f":"IF(I13=C14,G14,IF(I13=C15,G15,IF(I13=C16,G16,IF(I13=C17,G17,IF(I13=C18,G18,IF(I13=C19,G19,))))))","v":0},{"$f":"J13*F13","v":0}]
[null,null,"1.      Designated affordable units, on average, are at or above 80% of the Median Market Rent",null,null,null,0]
[null,null,"2.      Designated affordable units, on average, are within 70 - 79% of the Median Market Rent",null,null,null,1]
[null,null,"3.      Designated affordable units, on average, are within 60 - 69% of the Median Market Rent",null,null,null,2]
[null,null,"4.      Designated affordable units, on average, are within 50 - 59% of the Median Market Rent",null,null,null,3]
[null,null,"5.      Designated affordable units, on average, are below 50% of the Median Market Rent",null,null,null,5]
[]
[null,"Accessibility",null,null,null,15,{"$f":"G21","v":5},null,null,{"$f":"J21","v":0},{"$f":"K21","v":0},{"$f":"K20/(F20*G20)","v":0}]
[null,"What percentage of units meet accessibility standards",null,null,null,15,5,"¢",null,{"$f":"IF(I21=C22,G22,IF(I21=C23,G23,IF(I21=C24,G24,IF(I21=C25,G25,IF(I21=C26,G26,)))))","v":0},{"$f":"J21*F21","v":0}]
[null,null,"1. Barrier free common areas and 20% of units meet accessibility standards ",null,null,null,0]
[null,null,"2. Barrier free common areas and 21-25% of units meet accessibility standards",null,null,null,1]
[null,null,"3. Barrier free common areas and 26-30% of units meet accessibility standards ",null,null,null,3]
[null,null,"4. Barrier free common areas and 31%+ of units meet accessibility standards ",null,null,null,5]
[]
[null,"Environmental Efficiency",null,null,null,15,{"$f":"G28","v":5},null,null,{"$f":"J28","v":0},{"$f":"K28","v":0},{"$f":"K27/(F28*G28)","v":0}]
[null,"What percentage reduction in operating energy consumption and greenhouse gas emissions will your project achieve?",null,null,null,15,5,"¢",null,{"$f":"IF(I28=C29,G29,IF(I28=C30,G30,IF(I28=C31,G31,IF(I28=C32,G32,))))","v":0},{"$f":"J28*F28","v":0}]
[null,null,"1.  Up to 25% reduction in operating energy consumption and greenhouse gas emissions",null,null,null,0]
[null,null,"2.  26 - 40% reduction in operating energy consumption and greenhouse gas emissions",null,null,null,1]
[null,null,"3.  41 - 55% reduction in operating energy consumption and greenhouse gas emissions",null,null,null,2]
[null,null,"4.  Over 55% reduction in operating energy consumption and greenhouse gas emissions ",null,null,null,5]
[]
[null,"Partnerships",null,null,null,15,{"$f":"G35","v":5},null,null,{"$f":"J35","v":0},{"$f":"K35","v":0},{"$f":"K34/(F35*G35)","v":0}]
[null,"What percentage of costs will be covered by financial support received from others?",null,null,null,15,5,"¢",null,{"$f":"IF(I35=C36,G36,IF(I35=C37,G37,IF(I35=C38,G38,IF(I35=C39,G39,IF(I35=C40,G40,IF(I35=C41,G41,IF(I35=C42,G42,)))))))","v":0},{"$f":"J35*F35","v":0}]
[null,null,"1. 10% or less of project costs are  covered from other sources.",null,null,null,0]
[null,null,"2.  11% to 25% of project costs are covered from other sources.",null,null,null,1]
[null,null,"3.  26% to 40% of project costs are covered from other sources.",null,null,null,2]
[null,null,"4.  41% to 55% of project costs are covered from other sources.",null,null,null,3]
[null,null,"5.  56% to 75% of project costs are covered from other sources.",null,null,null,4]
[null,null,"6.  More than 75% of project costs are covered from other sources.",null,null,null,5]
[]
[null,"Proximity to Amenities",null,null,null,10,{"$f":"SUM(G44,G48,G52,G56,G60,G64,G68,G72,G76,G80)","v":50},null,null,{"$f":"SUM(J44,J48,J52,J56,J60,J64,J68,J72,J76,J80)","v":0},{"$f":"SUM(K44,K48,K52,K56,K60,K64,K68,K72,K76,K80)","v":0},{"$f":"K43/((F44*G44)+(F48*G48)+(F52*G52)+(F56*G56)+(F60*G60)+(F64*G64)+(F68*G68)+(F72*G72)+(F76*G76)+(F80*G80))","v":0}]
[null,"Is the project within 1 kilometer of a public transit station or bus stop?",null,null,null,1,5,"¢",null,{"$f":"IF(I44=C45,G45,IF(I44=C46,G46,IF(I44=C47,G47,)))","v":0},{"$f":"J44*F44","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 1 kilometer of a grocery store?",null,null,null,1,5,"¢",null,{"$f":"IF(I48=C49,G49,IF(I48=C50,G50,IF(I48=C51,G51,)))","v":0},{"$f":"J48*F48","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 1 kilometer of a neighborhood park?",null,null,null,1,5,"¢",null,{"$f":"IF(I52=C53,G53,IF(I52=C54,G54,IF(I52=C55,G55,)))","v":0},{"$f":"J52*F52","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 1 kilometer of a pharmacy?",null,null,null,1,5,"¢",null,{"$f":"IF(I56=C57,G57,IF(I56=C58,G58,IF(I56=C59,G59,)))","v":0},{"$f":"J56*F56","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 1 kilometer of a community centre?",null,null,null,1,5,"¢",null,{"$f":"IF(I60=C61,G61,IF(I60=C62,G62,IF(I60=C63,G63,)))","v":0},{"$f":"J60*F60","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 1.5 kilometers of a publically funded elementary school?",null,null,null,1,5,"¢",null,{"$f":"IF(I64=C65,G65,IF(I64=C66,G66,IF(I64=C67,G67,)))","v":0},{"$f":"J64*F64","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 1.5 kilometers of a public library?",null,null,null,1,5,"¢",null,{"$f":"IF(I68=C69,G69,IF(I68=C70,G70,IF(I68=C71,G71,)))","v":0},{"$f":"J68*F68","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 1.5 kilometers of a child care centre?",null,null,null,1,5,"¢",null,{"$f":"IF(I72=C73,G73,IF(I72=C74,G74,IF(I72=C75,G75,)))","v":0},{"$f":"J72*F72","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 3 kilometers of  health care services or a hospital?",null,null,null,1,5,"¢",null,{"$f":"IF(I76=C77,G77,IF(I76=C78,G78,IF(I76=C79,G79,)))","v":0},{"$f":"J76*F76","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Is the project within 10 kilometers of an area with job opportunities (e.g. business district, commercial strip, industrial site)?",null,null,null,1,5,"¢",null,{"$f":"IF(I80=C81,G81,IF(I80=C82,G82,IF(I80=C83,G83,)))","v":0},{"$f":"J80*F80","v":0}]
[null,null,"Yes",null,null,null,5]
[null,null,"No",null,null,null,0]
[]
[null,"Priority Groups and Onsite Support",null,null,null,20,10,null,null,{"$f":"J92+J85","v":0},0,{"$f":"(K85+K92)/((F85*G85)+(F92*G92))","v":0}]
[null,"What percentage of units in your project are specifically dedicated to meeting the needs of priority groups or vulnerable populations?",null,null,null,10,5,"¢",null,{"$f":"IF(I85=C86,G86,IF(I85=C87,G87,IF(I85=C88,G88,IF(I85=C89,G89,IF(I85=C90,G90,)))))","v":0},{"$f":"J85*F85","v":0}]
[null,null,"1. there are no units dedicated to meeting the needs of priority groups or vulnerable populations",null,null,null,0]
[null,null,"2.  1% to 20% of units are dedicated to meeting the needs of priority groups or vulnerable populations",null,null,null,2]
[null,null,"3.  21% to 35% of units are dedicated to meeting the needs of priority groups or vulnerable populations",null,null,null,3]
[null,null,"4.  36% to 50% of units are dedicated to meeting the needs of priority groups or vulnerable populations",null,null,null,4]
[null,null,"5.  More than 50% of units are dedicated to meeting the needs of priority groups or vulnerable populations",null,null,null,5]
[]
[null,"Will there be integrated support or services available for tenants onsite?",null,null,null,10,5,"¢",null,{"$f":"IF(I92=C93,G93,IF(I92=C94,G94,IF(I92=C95,G95,)))","v":0},{"$f":"J92*F92","v":0}]
[null,null,"1.  There will be no  integrated supports / services for tenants onsite.",null,null,null,0]
[null,null,"2.  There will be part-time integrated supports / services for tenants onsite.",null,null,null,2.5]
[null,null,"3.  There will be full-time integrated supports / services for tenants onsite.",null,null,null,5]
[]
[null,"Total Prioritization scoring",null,null,null,{"$f":"SUM(F5,F20,F27,F34,F43,F84)","v":105},null,null,null,null,{"$f":"SUM(K5,K20,K27,K34,K43,K84)","v":0},{"$f":"K97/((F6*G6)+(F13*G13)+(F21*G21)+(F28*G28)+(F35*G35)+(F44*G44)+(F48*G48)+(F52*G52)+(F56*G56)+(F60*G60)+(F64*G64)+(F68*G68)+(F72*G72)+(F76*G76)+(F80*G80)+(F85*G85)+(F92*G92))","v":0}]
[null,"Total scoring for forgivable loan, for higher performance\n",null,null,null,{"$f":"SUM(F5,F20,F27)","v":60},null,null,null,null,{"$f":"SUM(K5,K20,K27)","v":0},{"$f":"K98/((G6*F6)+(G13*F13)+(G21*F21)+(G28*F28))","v":0}]
[]
[]
[]
[null,"Funding results\nThe maximum percentages of eligible funding are outlined below. Please note these are the maximum percentages available, however, these amounts are not guaranteed."]
[]
[null,"Select your organization type:",null,"¢",null,null,null,null,"Funding"]
[null,null,null,null,null,null,null,null,"Maximum NHCF Funding : "]
[null,"Select your funding option :",null,"¢",null,null,null,null,{"$f":"IF(AND(E104=B122,E106=C122),E127,IF(AND(E104=B123,E106=C122),F127,IF(AND(E104=B124,E106=C122),G127,IF(AND(E104=B122,E106=C123,L97>0%,L97<25%),E133,IF(AND(E104=B122,E106=C123,L97>24%,L97<75%),E134,IF(AND(E104=$B122,E106=C123,L97>74%),E135,IF(AND(E104=B123,E106=C123,L97>0%,L97<25%),F133,IF(AND(E104=B123,E106=C123,L97>24%,L97<75%),F134,IF(AND(E104=$B123,E106=C123,L97>74%),F135,IF(AND(E104=B124,E106=C123,L97>0%,L97<25%),G133,IF(AND(E104=B124,E106=C123,L97>24%,L97<75%),G134,IF(AND(E104=$B124,E106=C123,L97>74%),G135,\"\"))))))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E106=\"\",\"\",IF(E106=C122,\"Projects receiving a contribution for higher performance will have a portion of their loan made available as a contribution.\",\"Projects receiving a contribution for higher performance will be in addition to the maximum NHCF Funding\"))","v":""}]
[null,null,null,null,null,null,null,null,"Maximum NHCF Forgivable Loan for higher performance"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E104=B122,L98>0%,L98<30%),E139,IF(AND(E104=B122,L98>29%,L98<60%),E140,IF(AND(E104=$B122,L98>59%,L98<90%),E141,IF(AND(E104=B122,L98>89%),E142,IF(AND(E104=B123,L98>0%,L98<30%),F139,IF(AND(E104=B123,L98>29%,L98<60%),F140,IF(AND(E104=$B123,L98>59%,L98<90%),F141,IF(AND(E104=B123,L98>89%),F142,IF(AND(E104=B124,L98>0%,L98<30%),G139,IF(AND(E104=B124,L98>29%,L98<60%),G140,IF(AND(E104=$B124,L98>59%,L98<90%),G141,IF(AND(E104=B124,L98>89%),G142,\"\"))))))))))))","v":""}]
[null,"In exceptional cases, forgivable loans may also be available in addition to an NHCF repayable loan for projects that require reduced borrowing to attain break-even cash flows (defined as a Debt Coverage Ratio of 1)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Non-Profit / Co-op / Indigenous Group or Government","Repayable Loan",null,"Yes"]
[null,"Province / Territory / Municipality","Forgivable Loan",null,"No"]
[null,"For-Profit (Private Sector)"]
[null,null,null,"Loans"]
[null,"Repairs",null,"Prioritization Score","Non-Profit / Co-op / Indigenous Group or Government","Province / Territory / Municipality","For-Profit (Private Sector)"]
[null,null,null,null,0.95,0.75,0.75]
[]
[]
[]
[null,null,null,"Contributions"]
[null,null,null,"Prioritization Score","Non-Profit / Co-op / Indigenous Group or Government","Province / Territory / Municipality","For-Profit (Private Sector)"]
[null,null,null,"0 - 24",0.2,0.15,0.05]
[null,null,null,"25 - 74",0.25,0.2,7.4999999999999997E-2]
[null,null,null,"75 - 100",0.3,0.25,0.1]
[]
[null,null,null,"Contributions for Higher Performance"]
[null,null,null,"Incentive Score","Non-Profit / Co-op / Indigenous Group or Government","Province / Territory / Municipality","For-Profit (Private Sector)"]
[null,null,null,"0 - 29",0,0,0]
[null,null,null,"30-59",2.5000000000000001E-2,0.02,0.02]
[null,null,null,"60-89",0.05,3.5000000000000003E-2,3.5000000000000003E-2]
[null,null,null,"90 – 100",0.1,0.05,0.05]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total contributions, including contributions for higher performance cannot exceed the following:"]
[null,null,null,"Maximum Contributions","Non-Profit / Co-op / Indigenous Group or Government","up to 40% of cost"]
[null,null,null,null,"Province / Territory / Municipality","up to 30% of cost"]
[null,null,null,null,"For-Profit (Private Sector)","up to 15% of cost"]

{"sheet":"Rents & Affordability","index":2,"n_rows":50,"n_cols":26,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,12,6,13],[17,12,17,13],[5,12,5,13],[2,0,2,16]]}
["Note: Only YELLOW hi-lighted fields that are applicable need to be input. "]
[]
["Rents & Affordability: Repair and Renewal"]
[null,null,null,null,null,null,null,null,null,null,null,null,"To obtain data on Median Market rents (MMR) for your area, ",null,null,null,null,null,null,"Affordable Rent Ranges as percentage of MMR "]
[null,"Proforma Rents - Residential",null,"Determining Rent (incl. attached ancilliary component) Levels:",null,null,null,null,null,null,null,null,"please use the following link:"]
[null,null,null,"1) For units to be deemed \"Affordable\", rent must be below 80% of Median Market Rent for unit type",null,null,null,null,null,null,null,null,"HOUSING MARKET INFORMATION PORTAL"]
[null,"Province",null,"2) Remainder of units to be included as \"Market\"",null,null,null,null,null,null,null,null,"Test 1"]
[null,"City",null,"3) Input average rent for each unit type under Monthly Market Rent",null,null,null,null,null,null,null,null,"30% of units with "]
[null,"Zone",null,"4) **Input average monthly operational funding allocation for each unit under Affordable Rent",null,null,null,null,null,null,null,null,"rents below 80% of "]
[null,null,null,null,null,null,null,null,null,null,null,null,"MMR",null,null,null,null,null,null,null,"70% to","60% to","50% to","Below"]
[null,null,null,null,null,null,null,null,"Monthly","Annual",null,null,{"$f":"Z37","v":0},"# Units below 80% of MMR",null,null,null,null,null,0.8,0.79,0.69,0.59,0.5]
[null,null,"Unit","Number","Monthly Market","Affordable ","Monthly Median ","Affordable Rent","Proforma","PGI Proforma",null,null,{"$f":"Z38","v":0},"% Units that meet Test",null,null,null,null,"Lower Limit",null,0.7,0.6,0.5]
[null,"Unit type","Size (sq ft)","of Units","Rent (PGI)","Rent (PGI)","Mkt Rent (MMR)","as % of MMR ","Rents ","Total","Comments",null,{"$f":"IF(M12>=30%, \"Yes\", \"No\")","v":"No"},"30% Condition met?",null,null,null,null,"Upper Limit",0.8,0.79990000000000006,0.69989999999999997,0.59989999999999999,0.5]
[13,"Bachelor - market",null,null,null,null,null,null,{"$f":"E14*D14","v":0},{"$f":"I14*12","v":0}]
[null,"Bachelor - affordable",null,null,null,null,null,{"$f":"IFERROR(F15/G15,0)","v":0},{"$f":"F15*D15","v":0},{"$f":"I15*12","v":0},null,null,"# of Affordable",{"$f":"M11","v":0},null,null,null,null,null,{"$f":"IF(H15=0,0,IF(H15<=$T$11,D15,0))","v":0},{"$f":"IF(H15=0,0,IF(AND(H15<=$U$13,H15>=$U$12),D15,0))","v":0},{"$f":"IF(H15=0,0,IF(AND(H15<=$V$13,H15>=$V$12),D15,0))","v":0},{"$f":"IF(H15=0,0,IF(AND(H15<=$W$13,H15>=$W$12),D15,0))","v":0},{"$f":"IF(H15=0,0,IF(H15<$X$13,D15,0))","v":0}]
[14,"1 bed (incl. 1 bed plus den) - market",null,null,null,null,null,null,{"$f":"E16*D16","v":0},{"$f":"I16*12","v":0},null,null,"# of Market ",{"$f":"D37-N15","v":0}]
[null,"1 bed (incl. 1 bed plus den) - affordable",null,null,null,null,null,{"$f":"IFERROR(F17/G17,0)","v":0},{"$f":"F17*D17","v":0},0,null,null,"Total",{"$f":"SUM(N15:N16)","v":0},null,null,null,null,null,{"$f":"IF(H17=0,0,IF(H17<=$T$11,D17,0))","v":0},{"$f":"IF(H17=0,0,IF(AND(H17<=$U$13,H17>=$U$12),D17,0))","v":0},{"$f":"IF(H17=0,0,IF(AND(H17<=$V$13,H17>=$V$12),D17,0))","v":0},{"$f":"IF(H17=0,0,IF(AND(H17<=$W$13,H17>=$W$12),D17,0))","v":0},{"$f":"IF(H17=0,0,IF(H17<$X$13,D17,0))","v":0}]
[16,"2 bed (incl. 2 bed plus den) - market",null,null,null,null,null,null,{"$f":"E18*D18","v":0},0,null,null,"Test 2"]
[null,"2 bed (incl. 2 bed plus den) - affordable",null,null,null,null,null,{"$f":"IFERROR(F19/G19,0)","v":0},{"$f":"F19*D19","v":0},0,null,null,"Average rental cost of affordable units as a % of Average MMR",null,null,null,null,null,null,{"$f":"IF(H19=0,0,IF(H19<=$T$11,D19,0))","v":0},{"$f":"IF(H19=0,0,IF(AND(H19<=$U$13,H19>=$U$12),D19,0))","v":0},{"$f":"IF(H19=0,0,IF(AND(H19<=$V$13,H19>=$V$12),D19,0))","v":0},{"$f":"IF(H19=0,0,IF(AND(H19<=$W$13,H19>=$W$12),D19,0))","v":0},{"$f":"IF(H19=0,0,IF(H19<$X$13,D19,0))","v":0}]
[18,"3 bed (incl. 3 bed plus den) - market",null,null,null,null,null,null,{"$f":"E20*D20","v":0},0,null,null,"Median Market rent (weighted avg.)",null,{"$f":"IF(OR(D24<>0,D26<>0),\"Not Applicable\",T42)","v":0}]
[null,"3 bed (incl. 3 bed plus den) - affordable",null,null,null,null,null,{"$f":"IFERROR(F21/G21,0)","v":0},{"$f":"F21*D21","v":0},0,null,null,"Subject (weighted avg of affordable rents)",null,{"$f":"IF(OR(D24<>0,D26<>0),\"Not Applicable\",V42)","v":0},null,null,null,null,{"$f":"IF(H21=0,0,IF(H21<=$T$11,D21,0))","v":0},{"$f":"IF(H21=0,0,IF(AND(H21<=$U$13,H21>=$U$12),D21,0))","v":0},{"$f":"IF(H21=0,0,IF(AND(H21<=$V$13,H21>=$V$12),D21,0))","v":0},{"$f":"IF(H21=0,0,IF(AND(H21<=$W$13,H21>=$W$12),D21,0))","v":0},{"$f":"IF(H21=0,0,IF(H21<$X$13,D21,0))","v":0}]
[null,"4 bed (incl. 4 bed plus den) - market",null,null,null,null,null,null,{"$f":"E22*D22","v":0},{"$f":"I22*12","v":0},null,null,"Average level of Affordability",null,{"$f":"IF(OR(D24<>0,D26<>0), 100%,IF(N15=0,0,O21/O20))","v":0}]
[null,"4 bed (incl. 4 bed plus den) - affordable",null,null,null,null,null,{"$f":"IFERROR(F23/G23,0)","v":0},{"$f":"F23*D23","v":0},0,null,null,null,null,null,null,null,null,null,{"$f":"IF(H23=0,0,IF(H23<=$T$11,D23,0))","v":0},{"$f":"IF(H23=0,0,IF(AND(H23<=$U$13,H23>=$U$12),D23,0))","v":0},{"$f":"IF(H23=0,0,IF(AND(H23<=$V$13,H23>=$V$12),D23,0))","v":0},{"$f":"IF(H23=0,0,IF(AND(H23<=$W$13,H23>=$W$12),D23,0))","v":0},{"$f":"IF(H23=0,0,IF(H23<$X$13,D23,0))","v":0}]
[null,"Single Room Occupancy Rooms**",null,null,null,null,null,{"$f":"IF(F24<>0,100%,0)","v":0},{"$f":"F24*D24","v":0},0,null,null,null,null,null,null,null,null,null,{"$f":"IF(H24=0,0,IF(H24<=$T$11,D24,0))","v":0},{"$f":"IF(H24=0,0,IF(AND(H24<=$U$13,H24>=$U$12),D24,0))","v":0},{"$f":"IF(H24=0,0,IF(AND(H24<=$V$13,H24>=$V$12),D24,0))","v":0},{"$f":"IF(H24=0,0,IF(AND(H24<=$W$13,H24>=$W$12),D24,0))","v":0},{"$f":"IF(H24=0,0,IF(H24<$X$13,D24,0))","v":0}]
[null,"Single Room Occupancy Rooms - With Rental Income",null,null,null,null,null,{"$f":"IF(F25<>0,100%,0)","v":0},{"$f":"F25*D25","v":0},{"$f":"I25*12","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(H25=0,0,IF(H25<=$T$11,D25,0))","v":0},{"$f":"IF(H25=0,0,IF(AND(H25<=$U$13,H25>=$U$12),D25,0))","v":0},{"$f":"IF(H25=0,0,IF(AND(H25<=$V$13,H25>=$V$12),D25,0))","v":0},{"$f":"IF(H25=0,0,IF(AND(H25<=$W$13,H25>=$W$12),D25,0))","v":0},{"$f":"IF(H25=0,0,IF(H25<$X$13,D25,0))","v":0}]
[null,"Shelters, beds**",null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(H26=0,0,IF(H26<=$T$11,D26,0))","v":0},{"$f":"IF(H26=0,0,IF(AND(H26<=$U$13,H26>=$U$12),D26,0))","v":0},{"$f":"IF(H26=0,0,IF(AND(H26<=$V$13,H26>=$V$12),D26,0))","v":0},{"$f":"IF(H26=0,0,IF(AND(H26<=$W$13,H26>=$W$12),D26,0))","v":0},{"$f":"IF(H26=0,0,IF(H26<$X$13,D26,0))","v":0}]
[null,"Shelters, beds - With Rental Income",null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(H27=0,0,IF(H27<=$T$11,D27,0))","v":0},{"$f":"IF(H27=0,0,IF(AND(H27<=$U$13,H27>=$U$12),D27,0))","v":0},{"$f":"IF(H27=0,0,IF(AND(H27<=$V$13,H27>=$V$12),D27,0))","v":0},{"$f":"IF(H27=0,0,IF(AND(H27<=$W$13,H27>=$W$12),D27,0))","v":0},{"$f":"IF(H27=0,0,IF(H27<$X$13,D27,0))","v":0}]
[null,"Add - Additional Affordable Units"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(F29/G29,0)","v":0},{"$f":"F29*D29","v":0},{"$f":"I29*12","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(H29=0,0,IF(H29<=$T$11,D29,0))","v":0},{"$f":"IF(H29=0,0,IF(AND(H29<=$U$13,H29>=$U$12),D29,0))","v":0},{"$f":"IF(H29=0,0,IF(AND(H29<=$V$13,H29>=$V$12),D29,0))","v":0},{"$f":"IF(H29=0,0,IF(AND(H29<=$W$13,H29>=$W$12),D29,0))","v":0},{"$f":"IF(H29=0,0,IF(H29<$X$13,D29,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(F30/G30,0)","v":0},{"$f":"F30*D30","v":0},0,null,null,null,null,null,null,null,null,null,{"$f":"IF(H30=0,0,IF(H30<=$T$11,D30,0))","v":0},{"$f":"IF(H30=0,0,IF(AND(H30<=$U$13,H30>=$U$12),D30,0))","v":0},{"$f":"IF(H30=0,0,IF(AND(H30<=$V$13,H30>=$V$12),D30,0))","v":0},{"$f":"IF(H30=0,0,IF(AND(H30<=$W$13,H30>=$W$12),D30,0))","v":0},{"$f":"IF(H30=0,0,IF(H30<$X$13,D30,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(F31/G31,0)","v":0},{"$f":"F31*D31","v":0},0,null,null,null,null,null,null,null,null,null,{"$f":"IF(H31=0,0,IF(H31<=$T$11,D31,0))","v":0},{"$f":"IF(H31=0,0,IF(AND(H31<=$U$13,H31>=$U$12),D31,0))","v":0},{"$f":"IF(H31=0,0,IF(AND(H31<=$V$13,H31>=$V$12),D31,0))","v":0},{"$f":"IF(H31=0,0,IF(AND(H31<=$W$13,H31>=$W$12),D31,0))","v":0},{"$f":"IF(H31=0,0,IF(H31<$X$13,D31,0))","v":0}]
[null,"Add - Additional Market Units"]
[null,null,null,null,null,null,null,null,{"$f":"E33*D33","v":0},{"$f":"I33*12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"E34*D34","v":0},{"$f":"I34*12","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,"Total Square Feet (Residential)",{"$f":"SUMPRODUCT(C14:C25,D14:D25)+SUMPRODUCT(C29:C31,D29:D31)+SUMPRODUCT(C33:C35,D33:D35)+S_Area+S_Area2","v":0},null,null,null,null,null,null,{"$f":"SUM(J14:J35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Affordable"]
[null,"Total Residential Units",null,{"$f":"SUM(D14:D27,D29:D31,D33:D35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R_Units=0, 0,SUM(T15:T36)/R_Units)","v":0},{"$f":"IF(R_Units=0, 0,SUM(U15:U36)/R_Units)","v":0},{"$f":"IF(R_Units=0, 0,SUM(V15:V36)/R_Units)","v":0},{"$f":"IF(R_Units=0, 0,SUM(W15:W36)/R_Units)","v":0},{"$f":"IF(R_Units=0, 0,SUM(X15:X36)/R_Units)","v":0},null,{"$f":"SUM(T14:T36)","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,{"$f":"IF(R_Units=0,0,Z37/R_Units)","v":0}]
[]
[]
[null,"Helpful Tips for accessing Median Market Rents and Vacancy Rate on CMHC Market Analysis Portal"]
[null,"1) Click on Link - \"HOUSING MARKET INFORMATION PORTAL\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N15=0,0,SUMPRODUCT(D14:D35,G14:G35)/N15)","v":0},null,{"$f":"IF(N15=0,0,SUMPRODUCT(D14:D35,F14:F35)/N15)","v":0}]
[null,"2) Choose the province in which your project is located from the \"Select Location\" list"]
[null,"3) Choose the city or area in which your project is located. "]
[null,"4) Choose the most specific zone (or Market Area / Subdivision) applicable for your project."]
[null,"Note: If your project is not located in a surveyed centre or you are unable to find the required data, please contact your Affordable Housing Consultant. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30% of Units at or below 80% MMR ",null,{"$f":"M13","v":"No"}]
[null,"5) In the tables on the left panel, select \"Primary Rental Market\", then \"Median Rent ($)\". Please select full report to get detailed information.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31% to 40% of Units below 80% MMR ",null,{"$f":"IF('Rents & Affordability'!M12>=30.99%,\"Yes\",\"No\")","v":"No"}]
[null,"6) In the same table, you will find information on Vacancy Rate ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"41% to 50% of Units below 80% MMR ",null,{"$f":"IF('Rents & Affordability'!M12>=40.99%,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51% to 55% of Units below 80% MMR ",null,{"$f":"IF('Rents & Affordability'!M12>=50.99%,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"More than 55% of Units below 80% MMR ",null,{"$f":"IF('Rents & Affordability'!M12>=54.99%,\"Yes\",\"No\")","v":"No"}]

{"sheet":"Project Budget ","index":3,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[[24,7,24,9],[55,4,55,5],[55,7,55,8],[53,2,53,3],[1,0,1,11],[41,1,45,10],[8,7,8,9],[51,2,51,3],[52,2,52,3],[52,4,52,10],[29,7,29,9],[30,7,30,9],[31,7,31,9],[25,7,25,9],[26,7,26,9],[27,7,27,9],[28,7,28,9],[21,7,21,9],[22,7,22,9],[23,7,23,9]]}
["Note: Only YELLOW hi-lighted fields that are applicable need to be input. "]
["Project Budget: Repair and Renewal"]
[null,"Total Project Budget Costs"]
[null,"Project Characteristics",null,null,null,null,null,"Residential\n(A)","Non-Residential\n(B)","Total \n(A + B)"]
[null,"Total sq feet (Gross Floor Area estimated)",null,null,{"$f":"J5","v":0},null,null,null,null,{"$f":"H5+I5","v":0}]
[null,"Proportion of total",null,null,{"$f":"IF(J5=0,0,J6)","v":0},null,null,{"$f":"IF(J5=0,0,H5/J5)","v":0},{"$f":"IF(J5=0,0,I5/J5)","v":0},{"$f":"SUM(H6:I6)","v":0}]
[null,"Number of Residential units",null,null,{"$f":"'Rents & Affordability'!D37","v":0}]
[]
[null,"1. Project budget",null,null,"Total Project Costs","Per unit",null,"Pro-Rata Project Costs",null,null,null,"Comments (If Any)"]
[null,"Land",null,null,null,{"$f":"IF($E$7=0,0,E10/$E$7)","v":0},null,{"$f":"E10*H$6","v":0},{"$f":"E10*I$6","v":0},{"$f":"SUM(H10:I10)","v":0}]
[null,"Hard costs",null,null,null,{"$f":"IF($E$7=0,0,E11/$E$7)","v":0},null,{"$f":"E11*H$6","v":0},0,0]
[null,"Soft costs",null,null,null,0,null,0,0,0]
[null,"Financing costs",null,null,null,0,null,0,0,0]
[null,"HST (Net of Rebate, if any)",null,null,null,0,null,0,0,0]
[null,"Contingency",null,null,null,0,null,0,0,0]
[null,"Other (describe)",null,null,null,0,null,0,0,0]
[null,"Other (describe)",null,null,null,{"$f":"IF($E$7=0,0,E17/$E$7)","v":0},null,{"$f":"E17*H$6","v":0},{"$f":"E17*I$6","v":0},{"$f":"SUM(H17:I17)","v":0}]
[null,"Other (describe)",null,null,null,0,null,0,0,0]
[null,"Other (describe)",null,null,null,0,null,0,0,0]
[null,"Total Budget (Uses) (C)",null,null,{"$f":"SUM(E10:E19)","v":0},0,null,{"$f":"SUM(H10:H19)","v":0},{"$f":"SUM(I10:I19)","v":0},0]
[]
[null,"Sources of Funding (Non-NHCF)",null,null,null,null,null,"Comments\n(If Any)"]
[null,"Other Debt Financing ",null,null,null,{"$f":"IF($E$7=0,0,E23/$E$7)","v":0}]
[null,"           Other Grants / Contributions ",null,null,null,{"$f":"IF($E$7=0,0,E24/$E$7)","v":0}]
[null,"Land Value Equity",null,null,null,0]
[null,"Owner cash equity",null,null,null,0]
[null,"Other (describe)",null,null,null,0]
[null,"Other (describe)",null,null,null,0]
[null,"Other (describe)",null,null,null,0]
[null,"Other (describe)",null,null,null,0]
[null,"Other (Development Charge waiver )",null,null,null,0]
[null,"CMHC Seed",null,null,null,0]
[null,"Total Other Sources (D)",null,null,{"$f":"SUM(E23:E32)","v":0},0]
[]
[null,"CMHC NHCF - Forgivable Loan (E)",{"$f":"'Scoring Grid'!I109","v":""},null,{"$f":"IFERROR('Scoring Grid'!I109*E20,0)","v":0},{"$f":"IF($E$7=0,0,E35/$E$7)","v":0},null,{"$f":"E35*H6","v":0},{"$f":"I6*E35","v":0},{"$f":"SUM(H35:I35)","v":0}]
[]
[null,"Funding Required (C - D - E)",null,null,{"$f":"IF(E20-E33-E35<0,0,E20-E33-E35)","v":0},{"$f":"IF($E$7=0,0,E37/$E$7)","v":0},null,{"$f":"E37*H6","v":0},{"$f":"I6*E37","v":0},{"$f":"SUM(H37:I37)","v":0}]
[]
[]
[]
[null,"Additional Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NHCF Funding ( Estimated Maximum Eligibility as per Proritization Grid)"]
[]
[null,"Type of Organization",{"$f":"'Scoring Grid'!$E$104","v":0}]
[null,"Type of Funding",{"$f":"'Scoring Grid'!$E$106","v":0}]
[null,"Project DCR - Overall",{"$f":"IF('Proforma - Residential'!G97+'Proforma - Residential'!G90+'Proforma - Non-Residential'!G81=0,0,(('Proforma - Non-Residential'!G61+'Proforma - Residential'!G75)/('Proforma - Residential'!G97+'Proforma - Residential'!G90+'Proforma - Non-Residential'!G81)))","v":0}]
[]
[null,"Particulars","% of Eligible Cost","Total Funding","Residential",null,null,"Non-Residential"]
[null,"Eligible NHCF Funding ",{"$f":"IF('Scoring Grid'!I106=\"\",0,IF(C53=\"Forgivable loan\",'Scoring Grid'!I106,'Scoring Grid'!I106-'Scoring Grid'!I109))","v":0},{"$f":"IFERROR(C57*$E$20,0)","v":0},{"$f":"$H$6","v":0},{"$f":"E57*D57","v":0},null,{"$f":"$I$6","v":0},{"$f":"H57*D57","v":0}]
[null,"NHCF Funding Required",{"$f":"IFERROR(D58/E20,0)","v":0},{"$f":"E37","v":0},{"$f":"E57","v":0},{"$f":"E58*D58","v":0},null,{"$f":"H57","v":0},{"$f":"H58*D58","v":0}]
[null,"NHCF Recommended Funding*",{"$f":"IFERROR(D59/E20,0)","v":0},{"$f":"F59+I59","v":0},{"$f":"IFERROR(F59/D59,0)","v":0},{"$f":"'Proforma - Residential'!G95 + IF($C$53=\"Forgivable loan\",IF(F58<F57,F58,F57),0)","v":0},null,{"$f":"IFERROR(I59/D59,0)","v":0},{"$f":"'Proforma - Non-Residential'!G79 + IF($C$53=\"Forgivable loan\",IF(I58<I57,I58,I57),0)","v":0}]
[null,"Additional Funding Required",{"$f":"IFERROR(D60/E20,0)","v":0},{"$f":"IF(E37-D59<=0,0,E37-D59)","v":0}]
[null,"* Please note that this if the maximum funding available, however, the amounts are not guaranteed."]
[]
[null,"Particulars","% of Eligible Cost","Total Funding"]
[null,"Eligible NHCF Funding ",{"$f":"C57","v":0},0]
[null,"NHCF Funding Required",0,0]
[null,"NHCF Recommended Funding*",0,0]
[null,"Additional Funding Required",0,0]
[null,"* Please note that this if the maximum funding available, however, the amounts are not guaranteed."]

{"sheet":"Proforma - Residential","index":4,"n_rows":108,"n_cols":10,"rows_kept":108,"cut":false,"hidden":false,"merged":[[108,1,112,10],[88,8,88,9],[24,8,24,9],[23,8,23,9],[1,0,1,10]]}
["Note: Only YELLOW hi-lighted fields that are applicable need to be input. "]
["Proforma - Residential: Repair and Renewal"]
[null,"Residential New: Financial Viability Assessment"]
[]
[null,"Percentage of Project Costs - Residential ",{"$f":"'Project Budget '!H6","v":0}]
[null,"Number of Residential Units",{"$f":"'Rents & Affordability'!D37","v":0}]
[]
[null,"1. Project budget"]
[null,null,null,"Per Unit","New Rental","Comments \n(If Any)"]
[null,"Land",null,{"$f":"IF($C$6=0,0,E10/$C$6)","v":0},{"$f":"C$5*'Project Budget '!E10","v":0}]
[null,"Hard costs",null,{"$f":"IF($C$6=0,0,E11/$C$6)","v":0},{"$f":"C$5*'Project Budget '!E11","v":0}]
[null,"Soft costs",null,0,{"$f":"C$5*'Project Budget '!E12","v":0}]
[null,"Financing costs",null,0,{"$f":"C$5*'Project Budget '!E13","v":0}]
[null,"HST ",null,0,{"$f":"C$5*'Project Budget '!E14","v":0}]
[null,"Contingency",null,0,{"$f":"C$5*'Project Budget '!E15","v":0}]
[null,{"$f":"'Project Budget '!B16","v":"Other (describe)"},null,0,{"$f":"C$5*'Project Budget '!E16","v":0}]
[null,{"$f":"'Project Budget '!B17","v":"Other (describe)"},null,{"$f":"IF($C$6=0,0,E17/$C$6)","v":0},{"$f":"C$5*'Project Budget '!E17","v":0}]
[null,{"$f":"'Project Budget '!B18","v":"Other (describe)"},null,0,{"$f":"C$5*'Project Budget '!E18","v":0}]
[null,{"$f":"'Project Budget '!B19","v":"Other (describe)"},null,0,{"$f":"C$5*'Project Budget '!E19","v":0}]
[null,"Total Budget (Uses)",null,0,{"$f":"SUM(E10:E19)","v":0}]
[]
[null,"Maximum NHCF Eligible Funding",{"$f":"E20*('Project Budget '!C57)","v":0},"Pro-rata Cost * Max funding"]
[null,"NHCF Funding Required",{"$f":"'Project Budget '!F58+('Project Budget '!I58-'Proforma - Non-Residential'!G79)","v":0}]
[]
[null,"2. Income Analysis- Residential"]
[null,null,null,null,null,null,"Annual PGI Proforma",null,"Comments \n(If Any)"]
[null,"Potential Gross Income (Total rental income)",null,null,null,null,{"$f":"'Rents & Affordability'!J36","v":0}]
[null,"Vacancy rate /bad debt"]
[null,"Less: Vacancy rate /bad debt",null,null,null,null,{"$f":"G27*G28","v":0}]
[null,"Effective Residential Gross Income",null,null,null,null,{"$f":"G27-G29","v":0}]
[]
[null,"3. Ancillary Income"]
[null,null,"# Units","Rent",null,null,null,null,"Comments \n(If Any)"]
[null,"Parking (monthly)",null,null,null,null,{"$f":"D34*C34*12","v":0}]
[null,"Storage lockers (monthly)",null,null,null,null,{"$f":"D35*C35*12","v":0}]
[null,"Laundry (annually)"]
[null,"Total",null,null,null,null,{"$f":"SUM(G34:G36)","v":0}]
[null,"Vacancy rate /bad debt (%)",null,null,null,null,{"$f":"G28","v":0}]
[null,"Less: Vacancy rate /bad debt",null,null,null,null,{"$f":"G38*G37","v":0}]
[null,"Effective Gross Income",null,null,null,null,{"$f":"G37-G39","v":0}]
[]
[null,"4. Other income (Annual)"]
[null,null,null,null,null,null,null,null,"Comments \n(If Any)"]
[null,"Operational Funding (Municipal, Provincial / Territorial, Federal)"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G44:G48)","v":0}]
[null,"Vacancy rate /bad debt",null,null,null,null,{"$f":"G28","v":0}]
[null,"Less: Vacancy rate /bad debt",null,null,null,null,{"$f":"G50*G49","v":0}]
[null,"Effective Gross Income",null,null,null,null,{"$f":"G49-G51","v":0}]
[]
[null,"Total Effective Gross Income",null,null,null,null,{"$f":"G30+G40+G52","v":0}]
[]
[null,"5. Operating Costs"]
[null,null,null,null,null,"Per Unit/Yr","Annual",null,"Comments \n(If Any)"]
[null,"Realty / Property Taxes",null,null,null,{"$f":"IF($C$6=0,0,G58/$C$6)","v":0}]
[null,"Insurance",null,null,null,{"$f":"IF($C$6=0,0,G59/$C$6)","v":0}]
[null,"Heat",null,null,null,null,{"$f":"F60*$C$6","v":0}]
[null,"Hydro",null,null,null,null,{"$f":"F61*$C$6","v":0}]
[null,"Water",null,null,null,null,{"$f":"F62*$C$6","v":0}]
[null,"Total Utilities",null,null,null,{"$f":"IF($C$6=0,0,G63/$C$6)","v":0},{"$f":"SUM(G60:G62)","v":0}]
[null,"Repair and Maintenance",null,null,null,null,{"$f":"F64*$C$6","v":0}]
[null,"Wages- Super",null,null,null,null,0]
[null,"Other (describe)",null,null,null,null,0]
[null,"Other (describe)",null,null,null,null,0]
[null,"Other (describe)",null,null,null,null,0]
[null,"Other (describe)",null,null,null,null,0]
[null,"Replacement Reserve (Mandatory requirement)",null,null,null,0.04,{"$f":"IF(G27<>0,IF( OR('Rents & Affordability'!F26<>0,'Rents & Affordability'!F24<>0),(('Proforma - Residential'!G54-(('Rents & Affordability'!J24+'Rents & Affordability'!J26)*(1-'Proforma - Residential'!G28)))*'Proforma - Residential'!F70),'Proforma - Residential'!G54*'Proforma - Residential'!F70),0)","v":0}]
[null,"Management Fee (% of Effective Gross Income)",null,null,null,null,{"$f":"F71*G54","v":0}]
[null,"General and Admin (% of Effective Gross Income)",null,null,null,null,{"$f":"F72*G54","v":0}]
[null,"Total Operating Costs",null,null,null,{"$f":"IF($C$6=0,0,G73/$C$6)","v":0},{"$f":"SUM(G58:G62,G64:G72)","v":0},null,"Operating Expense Ratio",{"$f":"IF(G54=0,0,G73/G54)","v":0}]
[]
[null,"Net Operating Income (NOI)",null,null,null,null,{"$f":"G54-G73","v":0}]
[]
[null,"BELOW SECTION TO BE FILLED ONLY IF NHCF REPAYABLE LOAN REQUESTED"]
[null,"Lending Value*","Property Value",null,null,null,{"$f":"IF(E78=0,0,ROUND(E78,-3))","v":0}]
[null,"Existing Debt to remain in Priority to NHCF Loan"]
[null,"Maximum NHCF Loan at 85% LTV (combined with any Existing Debt)",null,null,null,null,{"$f":"(0.85*G78)-G79","v":0}]
[null,"* Please refer to the Appraisal Report (\"as-improved\" value) or latest Municipal Property Value Assessment, as available."]
[]
[null,"BELOW SECTION TO BE FILLED ONLY IF NHCF REPAYABLE LOAN REQUESTED"]
[null,"6. NHCF Repayable Loan -DCR and Ratio Calculation (Applicable ONLY for NHCF Repayable Loan Request)"]
[null,"NHCF Repayable Loan (ie. lesser of max funding OR Loan Requested / Required)",null,null,null,null,{"$f":"MIN(C22,C23,G80)","v":0}]
[null,"CMHC Qualifying Rate (contact CMHC to obtain more information about our lending rates)"]
[null,"Repayable Loan Amortization ( years)",null,null,null,null,null,null,"Note: Loan Amortization can not exceed 40 years"]
[null,"NHCF Repayable Loan Mortgage Payment (monthly) P+I ",null,null,null,null,{"$f":"IF(G85=0, 0, IF(G87=0,0, -PMT((((G86/2)+1)^(1/6))-1, G87*12, G85, 0, 0)))","v":0}]
[null,"NHCF Repayable Loan Mortgage Payment (annually) P+I",null,null,null,null,{"$f":"G88*12","v":0}]
[null,"Other Debt Mortgage Payment (annually) P+I"]
[null,"Total Mortgage payments (NHCF loan + Other)",null,null,null,null,{"$f":"SUM(G89:G90)","v":0}]
[null,"Debt Coverage Ratio (DCR) - NHCF Repayable Loan Requested / Required  ",null,null,null,null,{"$f":"IF(G89=0, 0, ROUND(G75/(G89+G90),2))","v":0}]
["     Max Loan at minimum DCR",null,null,null,"Minimum DCR",1,{"$f":"IF(OR(G$85=0,G75<=0),0,IF(G87=0,0,(((G75-G90)/F$93/12)/(((1+((G86*100)/200))^(1/6)-1)/(1-((1+(G86*100)/200)^(1/6))^(-12*G87))))))","v":0}]
[]
[null,"Recommended NHCF Repayable Loan - Residential Portion",null,null,null,null,{"$f":"MIN(G85,G93)","v":0}]
[null,"Mortgage Payment (monthly) P+I",null,null,null,null,{"$f":"IF(G95=0, 0, -PMT((((G86/2)+1)^(1/6))-1, G87*12, G95, 0, 0))","v":0}]
[null,"Mortgage Payment (annually) P+I",null,null,null,null,{"$f":"G96*12","v":0}]
[null,"Debt Coverage Ratio (DCR) - Recommended NHCF Repayable Loan (Excluding Other Debt Payments)",null,null,null,null,{"$f":"IF(G97=0, 0, ROUND(G75/G97,2))","v":0}]
[]
[null,"NHCF repayable loan required can be supported",null,null,null,null,{"$f":"IF(G95=C23,\"Yes\",IF(G95<C23,\"No\",\"Yes\"))","v":"Yes"}]
[null,"Loan - Maximum NHCF repayable loan (Residential portion)",null,null,null,null,{"$f":"G95","v":0}]
[null,"Additional Required funding - Can additional Loan be supported by Non-Residential",null,null,null,null,{"$f":"C23-G95","v":0},null,"Go to Non-Residential tab"]
[null,"Project Cost - Residential",null,null,null,null,{"$f":"E20","v":0}]
[null,"NHCF Loan to Cost (LTC) - Residential",null,null,null,null,{"$f":"IF(G101=0,0,G95/G103)","v":0}]
[]
[]
[]
[null,"Additional Comments:"]

{"sheet":"Proforma - Non-Residential","index":5,"n_rows":86,"n_cols":8,"rows_kept":86,"cut":false,"hidden":false,"merged":[[86,1,90,10],[21,3,22,5],[1,0,1,10]]}
["Note: Only YELLOW hi-lighted fields that are applicable need to be input. "]
["Proforma - Non-Residential: Repair and Renewal"]
[null,"Non-Residential : Financial Viability Assessment"]
[null,null,null,null,"Check"]
[null,"Percentage of Project Costs for Non-Residential ",null,{"$f":"'Project Budget '!I6","v":0},{"$f":"E6","v":"Yes"},"  (Non-Residential portion of project costs cannot exceed 30% of project costs)"]
[null,"Percentage of Project Floor Space for Non-Residential ",null,{"$f":"IFERROR('Project Budget '!I5/'Project Budget '!E5,0)","v":0},{"$f":"IF(D6<=30%,\"Yes\",\"No\")","v":"Yes"},"  (Non-Residential portion of floor space cannot exceed 30% of project space)"]
[]
[null,"1. Project budget - Non-Residential portion"]
[null,null,null,"Comments \n(If Any)"]
[null,"Land",{"$f":"D$5*'Project Budget '!E10","v":0}]
[null,"Hard costs",{"$f":"D$5*'Project Budget '!E11","v":0}]
[null,"Soft costs",{"$f":"D$5*'Project Budget '!E12","v":0}]
[null,"Financing costs",{"$f":"D$5*'Project Budget '!E13","v":0}]
[null,"HST ",{"$f":"D$5*'Project Budget '!E14","v":0}]
[null,"Misc. and Buffer",{"$f":"D$5*'Project Budget '!E15","v":0}]
[null,{"$f":"'Project Budget '!B16","v":"Other (describe)"},{"$f":"D$5*'Project Budget '!E16","v":0}]
[null,{"$f":"'Project Budget '!B17","v":"Other (describe)"},{"$f":"D$5*'Project Budget '!E17","v":0}]
[null,{"$f":"'Project Budget '!B18","v":"Other (describe)"},{"$f":"D$5*'Project Budget '!E18","v":0}]
[null,{"$f":"'Project Budget '!B19","v":"Other (describe)"},{"$f":"D$5*'Project Budget '!E19","v":0}]
[null,"Total Budget (Uses)",{"$f":"SUM(C10:C19)","v":0}]
[]
[null,"Maximum Loan Amount at 75% of costs ",{"$f":"MIN((C20*75%),'Project Budget '!I57)","v":0},"Note: This is applicable only if NHCF Loan is requested"]
[null,"Loan Still Required",{"$f":"'Project Budget '!I58","v":0}]
[]
[null,"2. Non-Residential / Commercial"]
[null,null,null,"Size (sf)","# Units","Monthly Rent","Annual ","Comments \n(If Any)"]
[null,"Retail/Office 1",null,null,null,null,{"$f":"E27*F27*12","v":0}]
[null,"Retail/Office 2",null,null,null,null,{"$f":"E28*F28*12","v":0}]
[null,"Retail/Office 3",null,null,null,null,{"$f":"E29*F29*12","v":0}]
[null,"Retail/Office 4",null,null,null,null,{"$f":"E30*F30*12","v":0}]
[null,"Retail/Office 5",null,null,null,null,0]
[null,"Retail/Office 6",null,null,null,null,{"$f":"E32*F32*12","v":0}]
[null,"Retail/Office 7",null,null,null,null,0]
[null,"Retail/Office 8",null,null,null,null,0]
[null,"Retail/Office 9",null,null,null,null,0]
[null,"Retail/Office 10",null,null,null,null,0]
[null,"Add: Recoveries"]
[null,"Total",null,{"$f":"SUM(D27:D36)","v":0},{"$f":"SUM(E27:E36)","v":0},null,{"$f":"SUM(G27:G37)","v":0}]
[null,"Vacancy rate /bad debt"]
[null,"Less: Vacancy rate /bad debt",null,null,null,null,{"$f":"G39*G38","v":0}]
[null,"Effective Gross Income",null,null,null,null,{"$f":"G38-G40","v":0}]
[]
[null,"3. Operating Costs"]
[null,null,null,null,null,null,"Annual","Comments \n(If Any)"]
[null,"Realty / Property Taxes"]
[null,"Insurance"]
[null,"   Heat"]
[null,"   Hydro"]
[null," Water"]
[null,"Total Utilities",null,null,null,null,{"$f":"SUM(G47:G49)","v":0}]
[null,"Repair and Maintenance"]
[null,"Wages- Super"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Management Fee (% of Effective Gross Income)",null,null,null,null,{"$f":"F57*$G$41","v":0}]
[null,"General and Admin (%of Effective Gross Income)",null,null,null,null,{"$f":"F58*$G$41","v":0}]
[null,"Total Operating Costs",null,null,null,null,{"$f":"SUM(G45:G49,G51:G58)","v":0}]
[]
[null,"Net Operating Income",null,null,null,null,{"$f":"G41-G59","v":0}]
[]
[null,"BELOW SECTION TO BE FILLED ONLY IF NHCF REPAYABLE LOAN REQUESTED"]
[null,"Lending Value*","Property Value",null,{"$f":"'Proforma - Residential'!E78","v":0},null,{"$f":"IF(E64=0,0,ROUND(E64,-3))","v":0}]
[null,"Existing Debt to remain in Priority to NHCF Loan",null,null,null,null,{"$f":"'Proforma - Residential'!G79","v":0}]
[null,"Maximum NHCF Loan at 75% LTV (combined with any Existing Debt)",null,null,null,null,{"$f":"(0.75*G64)-G65","v":0}]
[null,"* Please refer to the Appraisal Report (\"as-improved\" value) or latest Municipal Property Value Assessment, as available."]
[]
[null,"BELOW SECTION TO BE FILLED ONLY IF NHCF REPAYABLE LOAN REQUESTED"]
[null,"4. Loan - DCR and Ratio Calculation (Applicable ONLY for NHCF Repayable Loan Request)"]
[null,"Repayable Loan (Non-Residential component)",null,null,null,null,{"$f":"MIN(C22,C23,G66)","v":0},"Lesser of 75% LTC, 75% of LTV and Loan still required"]
[null,"CMHC Qualifying Rate",null,null,null,null,{"$f":"'Proforma - Residential'!G86","v":0}]
[null,"Repayable Loan Amortization ( years)",null,null,null,null,{"$f":"'Proforma - Residential'!G87","v":0}]
[null,"Mortgage Payment (monthly) P+I",null,null,null,null,{"$f":"IFERROR(IF(G71=0, 0, -PMT((((G72/2)+1)^(1/6))-1, G73*12, G71, 0, 0)),0)","v":0}]
[null,"Mortgage Payment (annually) P+I",null,null,null,null,{"$f":"G74*12","v":0}]
[null,"Debt Coverage Ratio (DCR) ",null,null,null,null,{"$f":"IF(G75=0, 0, G61/G75)","v":0}]
[null,"Max loan at Min DCR",null,"Minimum DCR",null,1.4,{"$f":"IFERROR(IF(G$71=0,0,((G61/F77/12)/(((1+((G72*100)/200))^(1/6)-1)/(1-((1+(G72*100)/200)^(1/6))^(-12*G73))))),0)","v":0}]
[]
[null,"Recommended NHCF Repayable Loan - Non-Residential Portion",null,null,null,null,{"$f":"MIN(G71,G77,C23)","v":0}]
[null,"Mortgage Payment (monthly) P+I",null,null,null,null,{"$f":"IF(G79=0, 0, -PMT((((G72/2)+1)^(1/6))-1, G73*12, G79, 0, 0))","v":0}]
[null,"Mortgage Payment (annually) P+I",null,null,null,null,{"$f":"G80*12","v":0}]
[null,"Debt Coverage Ratio (DCR) - on Non-Residential loan only",null,null,null,null,{"$f":"IF(G81=0, 0, ROUND(G61/G81,2))","v":0}]
[]
[]
[]
[null,"Additional Comments:"]

{"sheet":"Drawdown Schedule ","index":6,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[10,1,10,4],[10,6,10,9],[42,1,45,9],[1,0,1,10]]}
["Note: Only YELLOW hi-lighted fields that are applicable need to be input. "]
["Drawdown Schedule: Repair and Renewal"]
["Drawdown Schedule"]
[]
["Type of Funding",{"$f":"IF('Project Budget '!$C$53=0,\"-\",'Project Budget '!$C$53)","v":"-"}]
["NHCF Funding Recommended",{"$f":"'Project Budget '!D59","v":0}]
["NHCF Forgivable Loan Recommended",{"$f":"'Project Budget '!E35","v":0}]
[]
[]
[]
[null,"REPAYABLE LOAN",null,null,null,null,"FORGIVABLE LOAN"]
[null,"Year","Drawdown Date","Drawdown Amount","Available Repayable  Loan Balance",null,"Year","Drawdown Date","Drawdown Amount","Available Forgivable Loan Balance"]
[null,null,null,null,{"$f":"IF(B5=\"Loan\",B6-D13,\"Not Applicable\")","v":"Not Applicable"},null,null,null,null,{"$f":"IF(B5=\"Contribution\",(B6+B7)-I13,B7-I13)","v":0}]
[null,null,null,null,{"$f":"IF(D14>0,E13-D14,\" \")","v":" "},null,null,null,null,{"$f":"IF(I14>0,J13-I14,\" \")","v":" "}]
[null,null,null,null,{"$f":"IF(D15>0,E14-D15,\" \")","v":" "},null,null,null,null,{"$f":"IF(I15>0,J14-I15,\" \")","v":" "}]
[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,"Total",null,{"$f":"SUM(D13:D18)","v":0},{"$f":"B6-D19","v":0},null,"Total",null,{"$f":"SUM(I13:I18)","v":0},{"$f":"J13+I13-I19","v":0}]
[null,null,null,null," ",null,null,null,null,{"$f":"IF(I20>0,J19-I20,\" \")","v":" "}]
[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," "]
[null,"Total",null,{"$f":"SUM(D20:D25)","v":0},{"$f":"IF(D26>0,E19-D26,\"\")","v":""},null,"Total",null,{"$f":"SUM(I20:I25)","v":0},{"$f":"IF(I26>0,J19-I26,\"\")","v":""}]
[null,null,null,null," ",null,null,null,null,{"$f":"IF(I27>0,J26-I27,\" \")","v":" "}]
[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," "]
[null,"Total",null,{"$f":"SUM(D27:D32)","v":0},{"$f":"IF(D33>0,E26-D33,\"\")","v":""},null,"Total",null,{"$f":"SUM(I27:I32)","v":0},{"$f":"IF(I33>0,J26-I33,\"\")","v":""}]
[null,null,null,null," ",null,null,null,null,{"$f":"IF(I34>0,J33-I34,\" \")","v":" "}]
[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," "]
[null,"Total",null,{"$f":"SUM(D34:D39)","v":0},{"$f":"B6-D19-D26-D33-D40","v":0},null,"Total",null,{"$f":"SUM(I34:I39)","v":0},{"$f":"J13+I13-I19-I26-I33-I40","v":0}]
[]
[null,"Comments:"]