{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calcul loyer","Région","Superficie","Feuil1"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":0,"defined_names":1,"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":"Calcul loyer","index":0,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[5,0,5,2],[4,0,4,2],[1,0,1,7],[2,0,2,7],[4,5,4,6],[5,5,5,6],[77,4,78,4],[79,0,80,0],[79,1,80,1],[79,2,80,2],[79,3,80,3],[79,4,80,4],[77,0,78,0],[77,1,78,1],[77,2,78,2],[77,3,78,3],[81,4,82,4],[83,0,84,0],[83,1,84,1],[83,2,84,2],[83,3,84,3],[83,4,84,4],[81,3,82,3],[85,4,86,4],[87,0,88,0],[87,1,88,1],[87,2,88,2],[87,3,88,3],[87,4,88,4],[85,3,86,3],[75,0,76,0],[75,1,76,1],[75,2,76,2],[85,0,86,0],[85,1,86,1],[85,2,86,2],[81,0,82,0],[81,1,82,1],[81,2,82,2],[9,5,9,6],[44,0,44,7],[58,0,58,2],[54,0,54,2],[53,0,53,2],[55,0,55,2],[45,5,45,7],[39,0,39,7],[40,0,40,7],[41,0,41,7],[0,0,0,7],[42,0,42,7],[6,0,6,2],[14,0,14,2],[10,0,10,2],[15,0,15,2],[9,0,9,2],[7,0,7,2],[13,0,13,2],[18,0,18,7],[23,0,23,6],[12,0,12,2],[11,0,11,2],[6,5,6,6],[7,5,7,6],[8,5,8,6]]}
["Calcul du loyer disponible et des coûts d'occupation"]
["Insérer vos informations dans les zones en vert, votre nombre de places totales, votre nombre de places poupons ainsi que votre région et le calcul se fera automatiquement."]
["Exemple fait pour un CPE de 78 places incluant 20 poupons, situé dans le Bas-Saint-Laurent région ressources"]
[]
["Locataire",null,null,"L",null,"Région",null,"Code de région"]
["Code de région (tableau de droite)",null,null,3,null,"Agglomération de Montréal",null,1]
["Nombre de places poupon",null,null,20,null,"Communauté métropolitaine Québec",null,2]
["Nombre de places 18 mois et plus",null,null,80,null,"Régions urbaines",null,3]
["Nombre de place totale",null,null,{"$f":"D7+D8","v":100},null,"Régions centrales",null,4]
["Nombre de pieds carrés AVEC salle multi calculé par le MFA",null,null,{"$f":"SUM(VLOOKUP('Calcul loyer'!D9,Superficie!A3:D103,2,FALSE),VLOOKUP('Calcul loyer'!D7,Superficie!A3:D103,4,FALSE),VLOOKUP('Calcul loyer'!D9,Superficie!A3:D103,3,FALSE))","v":9300.042138364779},null,"Régions ressources",null,5]
["Coût au pied carré AVEC calculé par MFA",null,null,{"$f":"H22/D10","v":22.754305502233812}]
["Nombre de pieds carrés SANS salle multi calculé par le MFA",null,null,{"$f":"SUM(VLOOKUP('Calcul loyer'!D9,Superficie!A3:D103,2,FALSE),VLOOKUP('Calcul loyer'!D7,Superficie!A3:D103,4,FALSE))","v":8440.410062893081}]
["Coût au pied carré SANS calculé par MFA",null,null,{"$f":"H22/D12","v":25.071767653841377}]
[]
["Nombre de pieds carrés offert en location",null,null,3659]
["Coût annuel d'occupation des locaux au pied carré offert par le propriétaire",null,null,{"$f":"H35/D15","v":18.13664935774802}]
[]
[]
["Subvention du COÛT D'OCCUPATION DES LOCAUX "]
["Volet A","Financement de base",null,552.16,"x",{"$f":"D9","v":100},"=",{"$f":"D20*F20","v":55216}]
["Volet B ","Financement locataire",null,{"$f":"IF(D5=\"L\",LOOKUP(D6,Feuil1!B2:B6,Feuil1!C2:C6),0)","v":1564},"x",{"$f":"D9","v":100},"=",{"$f":"D21*F21","v":156400}]
["Total - Subvention de fonctionnement du coût d'occupation des locaux - Volets A + B ",null,null,null,null,null,null,{"$f":"H21+H20","v":211616}]
[]
["Dépenses FRAIS RELIÉS AUX LOCAUX "]
["541.1","Loyer proposé par le propriétaire",null,null,null,null,null,65862]
["541.2","Frais de consommation d'énergie (estimation)",null,null,null,null,null,0]
["541.3","Frais d'assurance feu/vol et de branchement à une centrale d'alarme",null,null,null,null,null,500]
["541.4","Frais d'entretien et de réparations (voir exemples dans le tableau ici-bas)",null,null,null,null,null,0]
["541.5","Coût du bail emphytéotique"]
["541.6","Taxes foncières, si dans le loyer demander au locateur d'identifier le montant ",null,null,null,null,null,0]
["541.7","Autres : "]
["541.7 ","Autres : "]
["541.7","Autres : "]
["541.7","Autres : "]
[541,"Total des coûts d'occupation des locaux",null,null,null,null,null,{"$f":"SUM(H25:H34)","v":66362}]
[]
["EXCÉDENT (INSUFFISANCE) de la subvention par rapport aux dépenses pour le coût d'occupation des locaux",null,null,null,null,null,null,{"$f":"H22-H35","v":145254}]
[]
["Définitions"]
["Frais d’entretien : dépenses qui n’ont d’autre objet que de maintenir un bien dans de bonnes conditions d’utilisation. L’entretien ne confère pas un surplus de valeur à l’élément d’actif auquel il se rapporte et n’augmente pas la durée de vie de celui-ci. Les frais d’entretien sont imputés aux résultats de l’exercice au cours duquel les travaux sont exécutés. "]
["Frais de réparations : coûts engagés pour remettre en bon état un bien, notamment une immobilisation qui présente une diminution de son potentiel de service. Les coûts engagés pour accroître le potentiel de service d’une immobilisation correspondent à une amélioration, et non à une réparation. Les frais de réparations sont imputés aux résultats de l’exercice au cours duquel les travaux sont exécutés. "]
["Projet d’investissement en infrastructure : les dépenses engagées pour lesquelles une subvention pour les projets en infrastructure a été accordée ne doivent pas être inscrites à titre de dépenses d’entretien ou de réparations. Les coûts associés à ce projet doivent être capitalisés dans les immobilisations corporelles. "]
["Entretien ménager : les frais engagés pour le maintien de l’hygiène et de la propreté des locaux ne répondent pas à la définition de frais d’entretien ou de réparations. Ils doivent être inscrits à la ligne 529.1 (Entretien ménager, paysager et déneigement). "]
[]
["Exemples de classification de certaines dépenses dans le RFA (non exhaustifs)"]
["           ",null,null,"Frais reliés aux locaux",null,"Frais généraux"]
[null,null,null,"Ligne 541.4",null,"Ligne 529.1","Ligne 535.1","Ligne 535.2"]
["  Type de dépense",null,null,"Frais d’entretien et de réparations",null,"Entretien ménager et paysager et déneigement","Entretien et réparations de l’équipement","Location d’équipement"]
["Nettoyage de tapis permanent ou temporaire",null,null,null,null,"X"]
["Décapage et cirage des planchers",null,null,null,null,"X"]
["Peinture d’un ou de plusieurs locaux",null,null,"X"]
["Peinture extérieure",null,null,"X"]
["Sablage et vernissage des planchers de bois",null,null,"X"]
["Changement d’une porte ou d’une fenêtre à la suite d’un bris",null,null,"X"]
["Changement de quelques bardeaux d’un toit et solidification causé par forts vents",null,null,"X"]
["Entretien annuel ou semestriel du système central de climatisation ou de ventilation",null,null,"X"]
["Entretien de jeux d’eau capitaliseés",null,null,"X"]
["Réparation du comptoir fixe de la cuisine",null,null,"X"]
["Changement d’une pièce de la cuisinière ou du réfrigérateur",null,null,null,null,null,"X"]
["Déneigement de tout type",null,null,null,null,"X"]
["Désinfection du carré de sable",null,null,null,null,"X"]
["Paillis, copeaux de bois, sable",null,null,null,null,"X"]
["Frais d'extermination - insecticide",null,null,null,null,"X"]
["Location de tapis pour l’hiver",null,null,null,null,null,null,"X"]

{"sheet":"Région","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Superficie","index":2,"n_rows":103,"n_cols":4,"rows_kept":103,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Estimation superficie"]
["Nombre de places en installation    (0-59 mois)","Superficie pieds2","Superficies Salle Multi pieds2","Superficie pieds2 0-18 mois"]
[0,0,0,0]
[1,2100.3899371069183,299.88050314465409,25.84]
[2,2100.3899371069183,299.88050314465409,51.68]
[3,2100.3899371069183,299.88050314465409,77.52]
[4,2100.3899371069183,299.88050314465409,103.36]
[5,2100.3899371069183,299.88050314465409,129.19999999999999]
[6,2100.3899371069183,299.88050314465409,155.04]
[7,2100.3899371069183,299.88050314465409,180.88]
[8,2100.3899371069183,299.88050314465409,206.72]
[9,2100.3899371069183,299.88050314465409,232.56]
[10,2100.3899371069183,299.88050314465409,258.39999999999998]
[11,2100.3899371069183,299.88050314465409,284.24]
[12,2100.3899371069183,299.88050314465409,310.08]
[13,2100.3899371069183,299.88050314465409,335.92]
[14,2100.3899371069183,299.88050314465409,361.76]
[15,2100.3899371069183,299.88050314465409,387.6]
[16,2100.3899371069183,299.88050314465409,413.44]
[17,2100.3899371069183,299.88050314465409,439.28]
[18,2100.3899371069183,299.88050314465409,465.12]
[19,2100.3899371069183,299.88050314465409,490.96]
[20,2169.7264150943397,399.82075471698113,516.79999999999995]
[21,2239.0786163522012,399.82075471698113,542.64]
[22,2308.4182389937105,399.82075471698113,568.48]
[23,2377.7704402515724,399.82075471698113,594.32000000000005]
[24,2447.135220125786,399.82075471698113,620.16]
[25,2516.4622641509436,399.82075471698113,646]
[26,2585.817610062893,399.82075471698113,671.84]
[27,2655.1635220125786,399.82075471698113,697.68]
[28,2724.5125786163521,399.82075471698113,723.52]
[29,2793.8773584905662,399.82075471698113,749.36]
[30,2863.2106918238992,399.82075471698113,775.2]
[31,2932.5597484276727,399.82075471698113,801.04]
[32,3001.9056603773583,399.82075471698113,826.88]
[33,3071.248427672956,399.82075471698113,852.72]
[34,3140.616352201258,399.82075471698113,878.56]
[35,3209.9748427672957,399.82075471698113,904.4]
[36,3279.3113207547171,399.82075471698113,930.24]
[37,3348.6666666666665,399.82075471698113,956.08]
[38,3418.0031446540879,399.82075471698113,981.92]
[39,3487.3584905660377,399.82075471698113,1007.76]
[40,3625.3553459119498,499.79559748427675,1033.5999999999999]
[41,3694.7106918238992,499.79559748427675,1059.44]
[42,3764.0628930817611,499.79559748427675,1085.28]
[43,3833.3962264150941,499.79559748427675,1111.1199999999999]
[44,3902.7452830188681,499.79559748427675,1136.96]
[45,3972.1037735849059,499.79559748427675,1162.8]
[46,4041.4622641509436,499.79559748427675,1188.6400000000001]
[47,4110.8176100628934,499.79559748427675,1214.48]
[48,4180.1603773584902,499.79559748427675,1240.32]
[49,4249.5094339622638,499.79559748427675,1266.1600000000001]
[50,4318.8396226415098,499.79559748427675,1292]
[51,4388.2106918238997,499.79559748427675,1317.84]
[52,4457.5534591194964,499.79559748427675,1343.68]
[53,4526.9088050314467,499.79559748427675,1369.52]
[54,4596.2578616352203,499.79559748427675,1395.36]
[55,4734.2610062893082,499.79559748427675,1421.2]
[56,4803.6100628930817,499.79559748427675,1447.04]
[57,4872.9654088050311,499.79559748427675,1472.8799999999999]
[58,4942.3018867924529,499.79559748427675,1498.72]
[59,5011.6509433962265,499.79559748427675,1524.56]
[60,5081.0094339622638,515.79245283018872,1550.4]
[61,5150.3396226415098,515.79245283018872,1576.24]
[62,5219.6949685534591,515.79245283018872,1602.08]
[63,5289.0534591194964,515.79245283018872,1627.92]
[64,5358.3962264150941,515.79245283018872,1653.76]
[65,5427.7515723270444,558.77672955974845,1679.6]
[66,5497.0880503144654,558.77672955974845,1705.44]
[67,5566.4496855345915,558.77672955974845,1731.28]
[68,5635.7955974842771,558.77672955974845,1757.12]
[69,5705.135220125786,558.77672955974845,1782.96]
[70,5843.166666666667,601.75471698113211,1808.8]
[71,5912.5031446540879,601.75471698113211,1834.64]
[72,5981.864779874214,601.75471698113211,1860.48]
[73,6051.2075471698117,601.75471698113211,1886.32]
[74,6120.5597484276732,601.75471698113211,1912.16]
[75,6189.8993710691821,644.74842767295593,1938]
[76,6259.2515723270444,644.74842767295593,1963.84]
[77,6328.5943396226412,644.74842767295593,1989.68]
[78,6397.9496855345915,644.74842767295593,2015.52]
[79,6467.2955974842771,644.74842767295593,2041.36]
[80,6536.6415094339627,687.72327044025155,2067.1999999999998]
[81,6605.9874213836474,687.72327044025155,2093.04]
[82,6675.3364779874209,687.72327044025155,2118.88]
[83,6744.6855345911954,687.72327044025155,2144.7199999999998]
[84,6814.0345911949689,687.72327044025155,2170.56]
[85,6883.3836477987425,730.70125786163521,2196.4]
[86,6952.7295597484281,730.70125786163521,2222.2399999999998]
[87,7022.0786163522016,730.70125786163521,2248.08]
[88,7091.4276729559751,730.70125786163521,2273.92]
[89,7160.7767295597487,730.70125786163521,2299.7599999999998]
[90,7230.1257861635222,773.67924528301887,2325.6]
[91,7299.4716981132078,773.67924528301887,2351.44]
[92,7368.8207547169814,773.67924528301887,2377.2800000000002]
[93,7438.1698113207549,773.67924528301887,2403.12]
[94,7507.5188679245284,773.67924528301887,2428.96]
[95,7576.867924528302,816.6540880503145,2454.8000000000002]
[96,7646.2138364779876,816.6540880503145,2480.64]
[97,7715.5628930817611,816.6540880503145,2506.48]
[98,7784.9119496855346,816.6540880503145,2532.3200000000002]
[99,7854.2610062893082,816.6540880503145,2558.16]
[100,7923.6100628930817,859.63207547169816,2584]

{"sheet":"Feuil1","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Région","Code de la région","Locataire -montant par place 2022-2023","Locataire -montant par place 2021-2022","Augmentation"]
["Agglomération de Montréal",1,1823,1100,{"$f":"C2-D2","v":723}]
["Communauté métropolitaine Québec",2,1564,995,{"$f":"C3-D3","v":569}]
["Régions urbaines",3,1564,949,615]
["Régions centrales",4,878,845,33]
["Régions ressources",5,771,743,28]