{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INSTRUCTIONS","Eligible & Ineligible Costs","1. Budget-CP-ETWW","2. Sources of Funding"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["BUDGET - Capital Projects\nEnergy, Water and Waste Sectors"]
["INSTRUCTIONS"]
["▪ PROJECT COSTS: Please indicate your project budget allocations according to GMF cost categories. The majority of  costs should fall under “Capital” or “Services.” Enter a description and cost estimate for each item. Costs should be separated into eligible and ineligible categories to help clarify what costs can be partially reimbursed by FCM.\nPlease see the eligible and ineligible costs worksheet for a detailed list.\n▪ IN-KIND COSTS: The budget should include cash costs only.  Add eligible or ineligible in-kind costs to the “In-kind costs” rows at the bottom of the table. Note that eligible in-kind costs cannot exceed 10% of total eligible costs. \n▪ CONTINGENCY COSTS: Contingency costs are eligible, but cannot be listed as a separate budget item. Allocate contingency costs within the relevant budget items as and where appropriate, and add an explanation of the contingency percentage or amount in the “Contingency costs” section below the table."]
["▪ TAXES: You may include the portion of taxes for which your organization is not eligible for a rebate (provincial, territorial, or federal) in your budget. Allocate this amount within the relevant tasks as and where appropriate.\n▪ SCHEDULE:  A project schedule must be submitted as a separate document with your application form."]
["▪ DELETING ROWS: Rows cannot be deleted, due to the template’s structure. Please leave extra or empty rows blank."]

{"sheet":"Eligible & Ineligible Costs","index":1,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["GMF Eligible and Ineligible Costs\nCapital Projects: Energy, Water and Waste Sectors"]
["This table outlines what costs can be partially reimbursed by FCM. Please pay particular attention to any costs that may be ineligible."]
["Note: If your application is approved, expenses that are eligible for partial reimbursement must be: \n•        incurred after the date the application is received by FCM (except consulting services to prepare the application undertaken up to 90 days prior to receipt of the application by FCM).\n•        invoiced directly to your organization.\n•        an integral and an essential component of the initiative and required to help achieve the environmental objective of the initiative.\n•        actually and reasonably incurred in accordance with applicable industry standards.\n•        listed in a statement of expenses attached to an external audit report. You must keep all invoices, receipts and backup documents for seven years after the final FCM disbursement."]
["Cost Category","Eligible costs","Ineligible costs"]
["Section A: Costs incurred prior to date application received by FCM"]
["1) Pre-application","Consulting costs to write the GMF application incurred up to 90 days prior to application receipt date","All other costs incurred prior to application receipt date"]
["Section B: Costs incurred after date application received by FCM"]
["2) Administrative","Administrative costs that are directly linked to and have been incurred for the project, such as: ","Office space, supplies and general overhead costs incurred in the ordinary course of business."]
[null,"•         communication costs (e.g. long-distance calls or faxes) "]
[null,"•         permits or certifications required for the project"]
[null,"•         printing or photocopying by outside suppliers"]
[null,"•         acquisition of documents used exclusively for the project"]
[null,"•         document translation"]
["3) Advertising","Advertising costs essential to communicating the project to the public, as well as project evaluation, such as:","•         Advertising costs for general education or publicity that is a result of ongoing or other business activity and not a specific requirement of the project. "]
[null,"•         fees for advertising development","•         Promotional items."]
[null,"•         fees for media distribution"]
[null,"•         website development"]
[null,"•         public surveys"]
["4) Audit","The cost of a financial audit for the capital project if required by FCM."]
["5) Capital","Capital costs as defined and determined in accordance with generally accepted accounting principles (GAAP), including:","•         Purchase or lease of real property."]
[null,"•         costs for acquiring, developing, constructing, modernizing or leasing systems (equipment, hardware, software, etc.). "]
[null,"•         costs of construction, renovation or modernization of facilities and structures such as materials and installation costs."]
["6) Equipment rental","Rental of tools and equipment.","Rental of tools or equipment related to ongoing or other business activities."]
["7) Meetings and public gatherings","Costs related to meetings and public gatherings that communicate the project to the public and that collect feedback, such as:","Any hospitality expenses such as:"]
[null,"•         facility rental","•         food and drink"]
[null,"•         audiovisual equipment rental","•         alcohol"]
[null,null,"•         door prizes"]
[null,null,"•         entertainment"]
[null,null,"•         music"]
[null,null,"•         decorations"]
[null,null,"•         flowers, centerpieces"]
["8) Services","Fees for professional or technical consultants and contractors. ","•         Any costs associated with person(s) enrolled on your organization’s payroll, except for those defined under the category listed as “in-kind.”"]
[null,null,"•         Costs for engineering studies, audit studies or feasibility studies for which grants or contributions are provided by or committed to be provided by any program of the Government of Canada."]
["9) Transportation, shipping and courier charges","Transportation costs for delivery of materials and services essential for the project.","Any transportation expense related to ongoing or other business activities."]
["10) Travel and accommodation","Travel and associated expenses for you and consultants to the extent that the travel and accommodation rates comply with Treasury Board of Canada guidelines and to the extent the such travel is necessary to complete the project. ","•         Travel and associated expenses of a partner in the project."]
[null,null,"•         Travel, accommodation and fees to attend conferences, missions, trade shows, etc."]
["11) Taxes","The portion of taxes for which your organization is not otherwise eligible for rebate.","The portion of taxes for which your organization is eligible for rebate (provincial, territorial, or federal)."]
["    In-kind","Contribution of staff time by your organization’s employees (including permanent and contract employees). The value of the total in-kind contributions for staff salaries or other remuneration cannot exceed 10% of the other eligible costs. ","•         In-kind contribution of goods and services other than salaries."]
[null,null,"•         In-kind contribution made by organizations other than yours."]
[null,"To claim this type of in-kind contribution, you will have to submit a letter from an authorized officer in your organization confirming the details of the in-kind contribution.","•         In-kind contribution by your organization above 10% of the eligible costs."]

{"sheet":"1. Budget-CP-ETWW","index":2,"n_rows":112,"n_cols":5,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
["BUDGET - Capital Projects\nEnergy, Water and Waste Sectors"]
["Lead Applicant:"]
["Project title:"]
["Planned Start date: ",null,"End date:"]
["Cost category"," ","Eligible Costs ($)","Ineligible Costs ($)","Total Costs ($)"]
["Administrative"]
["[Add description of cost item here]",null,null,null,{"$f":"C7+D7","v":0}]
["[Add description of cost item here]",null,null,null,{"$f":"C8+D8","v":0}]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["Advertising"]
["[Add description of cost item here]",null,null,null,{"$f":"C18+D18","v":0}]
["[Add description of cost item here]",null,null,null,{"$f":"C19+D19","v":0}]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["Audit"]
["Financial Audit",null,null,null,{"$f":"C29+D29","v":0}]
["Environmental results audit by a third party",null,null,null,{"$f":"C30+D30","v":0}]
["[Add description of cost item here]",null,null,null,0]
["Capital Costs"]
["[Add description of cost item here]",null,null,null,{"$f":"C33+D33","v":0}]
["[Add description of cost item here]",null,null,null,{"$f":"C34+D34","v":0}]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["Equipment Rental"]
["[Add description of cost item here]",null,null,null,{"$f":"C44+D44","v":0}]
["[Add description of cost item here]",null,null,null,{"$f":"C45+D45","v":0}]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["Meetings and Public Gatherings"]
["[Add description of cost item here]",null,null,null,{"$f":"C55+D55","v":0}]
["[Add description of cost item here]",null,null,null,{"$f":"C56+D56","v":0}]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["Services"]
["[Add description of cost item here]",null,null,null,{"$f":"C66+D66","v":0}]
["[Add description of cost item here]",null,null,null,{"$f":"C67+D67","v":0}]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["Transportation, Shipping and Courier Charges"]
["[Add description of cost item here]",null,null,null,{"$f":"C77+D77","v":0}]
["[Add description of cost item here]",null,null,null,{"$f":"C78+D78","v":0}]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["Travel and Accommodation"]
["[Add description of cost item here]",null,null,null,{"$f":"C88+D88","v":0}]
["[Add description of cost item here]",null,null,null,{"$f":"C89+D89","v":0}]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["[Add description of cost item here]",null,null,null,0]
["Subtotal - Cash costs:",null,{"$f":"SUM(C7:OFFSET(C98,-1,0))","v":0},{"$f":"SUM(D7:OFFSET(D98,-1,0))","v":0},{"$f":"SUM(E7:OFFSET(E98,-1,0))","v":0}]
["In-kind costs (Lead applicant - staff time) - Change ONLY if less than 10% of Eligible Cash Costs",null,{"$f":"ROUNDDOWN((0.1*C98), -2)","v":0},0,{"$f":"C99+D99","v":0}]
["In-kind costs (Other)",null,null,0,{"$f":"D100","v":0}]
["TOTAL PROJECT COSTS:",null,{"$f":"C98+C99","v":0},{"$f":"D98+D99+D100","v":0},{"$f":"E98+E99+E100","v":0}]
[]
[null,"Total Eligible Costs",null,{"$f":"C101","v":0}]
[]
[null,"NB: Click on the Calculate Budget button to round off all figures to the nearest $100."]
[]
[]
["Contingency costs: Have you included room for contingencies in some or all of your task costs? Please explain."]
["[Add explanation about contingency here]"]
[]
["Other Notes:"]
["[Add any other relevant details about your workplan and budget here]"]

{"sheet":"2. Sources of Funding","index":3,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["SOURCES OF FUNDING"]
["INSTRUCTIONS\nEnter all funding sources for this environmental or sustainable initiative. For each funding source, please indicate the amount of the funding, and when the funding is confirmed or expected to be confirmed. The total of all funding sources must equal the total project costs in your Budget table (tab 1).  All sources of funding must be confirmed in writing and submitted to FCM prior to the first disbursement.\n\nNote:  FCM offers below-market loans, in combination with grants, to implement capital projects in the Energy, Transportation, Waste and Water sectors. Funding is provided for up to 80% of eligible project costs. The loan maximum is $5 million and grants are typically 15% of the loan amount. The spreadsheet will auto-calculate the maximum eligible GMF loan and grant amounts according to the Total Eligible Costs in the budget. FCM will cap the GMF loan and grant amounts according to the other confirmed sources of funding."]
["Funding source","Description","Confirmed (Y/N)","Date Committed\nDD-MM-YYYY","Amount","Percentage of Total Budget"]
["Green Municipal Fund","Loan","N",null,{"$f":"ROUND(MIN((0.8*'1. Budget-CP-ETWW'!D103/1.15),5000000), -2)","v":0},{"$f":"E4/$F$26","v":{"$error":"#DIV/0!"}}]
["Green Municipal Fund","Grant","N",null,{"$f":"(E4*0.15)","v":0},{"$f":"E5/$F$26","v":{"$error":"#DIV/0!"}}]
["Lead Applicant","Cash",null,null,null,{"$error":"#DIV/0!"}]
["Lead Applicant","In-kind",null,null,{"$f":"'1. Budget-CP-ETWW'!C99","v":0},{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Total Funding:",{"$f":"SUM(E4:OFFSET(E23,-1,0))","v":0}]
["[Equivalent to Total Cost from the Workplan and Budget Table]"]
[]
[null,null,null,"Budget Total Costs",null,{"$f":"'1. Budget-CP-ETWW'!E101","v":0}]
[null,null,null,"Budget Total Eligible Costs",null,{"$f":"'1. Budget-CP-ETWW'!D103","v":0}]