Project cash flow calculator
Evaluate the economic feasibility of an energy efficiency project
SUSTAINABLE AFFORDABLE HOUSING
We've developed two tools to help housing providers understand how much energy their buildings use, and the costs savings associated with the projected energy use. The first tool, called Energy benchmarking, lets housing providers see how much energy they use now, set realistic goals for using less energy, and figure out how much money they could save.
The second tool, the Project cash flow calculator, helps housing providers look at the money side of things. It helps them make smart choices for the long term. These tools work together to help affordable housing providers reach their energy-saving goals and manage financial expectations. This way, they can build strong, lasting communities for the future.
Energy benchmarking
Navigate the complexities of your building's energy consumption patterns with our energy benchmarking tool. This tool will facilitate insightful comparisons between your building's current performance, its historical efficiencies, and benchmarks against similar properties. Use this tool to determine your property's energy intensity and gauge the potential energy savings your project could deliver.
In this section, you can conduct an energy analysis of your project. By determining your building's energy intensity, you'll be well-equipped to compare it with similar structures. Additionally, this allows you to estimate potential energy savings and reductions in GHG emissions within an energy efficiency project. Please note that this section is optional and independent of the cash flow analysis.
Project cash flow calculator
This robust tool meticulously examines all financial inflows and outflows tied to a project over a defined timeframe. It allows housing providers to anticipate and tactically manage expenditures. The calculator is instrumental in facilitating informed decision-making by providing a comprehensive overview of the financial trajectory of energy-efficient initiatives throughout their entire life cycle. From illustrating the return on investment to offering a nuanced understanding of financial implications, this tool equips housing providers with the insights necessary to determine the viability of a project.
In this section, you can assess your project's profitability using the financial metrics provided in the table below.
Cash Flow
Net Annual Cash Flow
Calculation Table
Financial Metrics
Glossary
1. Net cash flow: Net cash flow is the difference between the total cash inflow and the total cash outflow. In this calculator the inflow corresponds to energy savings and the cash flow corresponds to the project cost and the operating and maintenance (O&M) costs.
2. Cumulative cash flow: Cumulative cash flow means, for any calendar year, the sum of the Annual Cash Flow for each calendar year prior to and including such calendar year.
3. Simple payback: Simple payback is defined as the number of years after which an investment will have paid for itself. In energy efficiency projects it can be translated as the number of years it takes for the energy savings to payback the initial cost of the project. The shorter your payback period is, the faster you will recover your initial investment.
Payback period = Initial investment / Annual pay
4. Present value: Present value (PV) is the current value of a future sum of money or stream of cash flows given a specific rate of return.
5. Cumulative present value: Cumulative present value means, for any calendar year, the sum of the Annual Present Value for each calendar year prior to and including such calendar year.
6. Net present value: Net present value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. NPV is the result of calculations that find the current value of a future stream of payments, using the proper discount rate. In general, projects with a positive NPV are worth undertaking while those with a negative NPV are not.
NPV = Cash flow / (1 + i)t – initial investment
* t = year of project
* i = discount rate
7. Savings to investment ratio: the Savings to investment ratio also called benefit-to-cost ratio is the ratio of the net present value to project costs. Ratios greater than 1 are representative of profitable projects. As for NPV, projects with a positive savings to investment ratio are worth undertaking while those with a negative savings to investment ratio are not.
8. Internal rate of return: Internal rate of return (IRR) follows the same reasoning as Net Present Value. But rather than picking a discount rate to find the current value of a future stream of cashflows, this method relies on an iterative solution to determine what discount rate will cause the NPV of the project to equal zero. IRR is calculated by trial and error by varying the discount rate in the NPV formula until the NPV is equal to 0. The IRR assumes the cash flows from a project are reinvested at the IRR itself.
9. Modified internal rate of return: The Modified internal rate of return (MIRR) follows the same reasoning as IRR but assumes that positive cash flows are reinvested at the firm's cost of capital.
Related Resources
See All
Local energy generation
Energy
Webinar recording: New GMF funding and support to accelerate community energy systems
Watch our webinar to explore GMF’s new funded learning offer: Accelerating Community Energy Systems. Discover best practices, funding insights and strategies for your municipality.
Community efficiency financing
Energy | Housing
Unlocking the potential of PACE financing: A comprehensive report on Canadian legislation
Read our informative report to discover an overview of PACE legislation in Canada and learn how a PACE initiative can benefit your community.
Sustainable affordable housing
Energy | Housing
Aspen Heights: Redefining affordable housing in Saskatoon
Sustainable affordable housing
Energy | Housing
Heartland Housing Foundation: Building a sustainable future in Fort Saskatchewan
Sustainable affordable housing
Energy | Housing
Building a better future: CABN’s net-zero affordable housing pilot
Sustainable affordable housing
Energy | Housing
Pine Tree Park: Transforming affordable housing with energy efficiency and solar power
Sustainable affordable housing
Energy | Housing
Rossland Yards: Transforming affordable housing in Rossland, BC
Sustainable affordable housing
Energy | Housing
YWCA Banff: Building stability and community through affordable housing
Sustainable affordable housing
Energy
Transforming communities with Sustainable Affordable Housing: Article series
In a series of six articles, we highlight impactful projects funded by GMF's Sustainable Affordable Housing (SAH) initiative, demonstrating how energy-efficient, community-centered housing can foster resilience and well-being.
Sustainable affordable housing
Energy | Housing
Regional Energy Coach list
Get in touch with a Regional Energy Coach in your region and start your energy efficiency journey
Municipal and community buildings
Energy
Webinar recording: Accelerate your community’s net-zero transformation with new GMF funding
Watch our webinar to discover how GMF’s new funding can help you upgrade infrastructure and reduce local GHG emissions.
Community efficiency financing
Energy
Webinar recording: The real impact of home-energy efficiency financing
Watch our webinar to discover how you can achieve your climate goals by implementing a home-energy efficiency financing program in your community
Sustainable affordable housing
Energy
Webinar recording: Transform your approach to energy efficiency with the Housing Providers’ Toolkit
Watch the discussion on how to take advantage of the Housing Providers’ Toolkit.
Sustainable affordable housing
Energy | Housing
Funders list for sustainable affordable housing
Access additional funding sources from across Canada to support your next affordable housing project.
Sustainable affordable housing
Energy | Housing
Toolkit: Navigating energy-efficient affordable housing projects
Discover a toolkit designed for affordable housing providers aiming to prioritize energy efficiency. This toolkit offers insights into the benefits of energy-efficient housing, addresses unique challenges, and provides practical tools to identify solutions.
Municipal and community buildings
Energy
Webinar recording: How to start reducing GHG emissions in community buildings
Watch the discussion on how to create a GHG reduction pathway for community buildings.
Municipal and community buildings
Energy | Housing
Webinar recording: How to get a project started, tips for small francophone communities
If you’re a small francophone municipality looking to develop sustainability projects and access funding, watch this webinar to learn how others overcame common challenges.
Community efficiency financing
Energy
Community Efficiency Financing market guide
Guide to help Canadian municipalities assess potential home energy upgrade programs
Sustainable affordable housing
Energy | Housing
Webinar recording: Affordable housing providers’ impact on energy poverty
The webinar will feature a housing project helping moderate income households while achieving high environmental standards.
Sustainable affordable housing
Energy
Understanding energy efficiency: A guide for affordable housing providers
This guide is for affordable housing providers, such as municipalities or housing cooperatives, interested in improving energy efficiency in their buildings.
Municipal and community buildings
Energy
Resource library: Community Buildings Retrofit
Find practical case studies and guidance for planning your local community building retrofit.
Community efficiency financing
Energy | Housing
Video: Nelson scales up local program to support home-energy upgrades
In this video, Carmen Proctor, Climate & Energy Manager at the City of Nelson, tells the story of the program’s success to date, shares key lessons learned from running the program, and highlights their next steps to scale up the program.
Sustainable affordable housing
Energy | Housing
Webinar recording: Asset management and energy conservation
Learn how the non-profit housing sector can integrate energy management into asset management to reduce costs and greenhouse gas emissions.
Community efficiency financing
Energy
Resources: Community Efficiency Financing
Read guidebooks and case studies to see how municipalities are designing home upgrade financing programs.
Sustainable affordable housing
Energy | Housing
Video: 5 keys for sustainable social housing success
Gordon Szaszi, Project Manager Housing Development, shares Niagara Regional Housing (NRH) experience creating the business case for a 67-unit affordable housing development for seniors.
Sustainable affordable housing
Energy | Housing
Video: 5 keys for sustainable social housing success
This video walks through the key sections of a successful business case: Needs Assessment, Organizational Readiness, Project Vision and Financials.
Sustainable affordable housing
Energy | Housing
Resources: Sustainable Affordable Housing
Learn how to retrofit existing housing for energy-efficiency and plan new builds for higher performance.
Energy | Housing
Webinar recording: Take your project from study to capital
Watch this webinar recording and discover how others have successfully converted studies into a capital project that provides social, economic and environmental benefits.
Energy
Webinar recording: The 5 keys to a green municipal project business case
Watch this webinar recording and discover the five critical focus areas you need to address to get your project started, from financing and partnerships to integrating a triple-bottom-line approach.
Sustainable affordable housing
Energy | Housing
Video: 1,500 Toronto residents benefit from retrofit initiative
Bryan Purcell, of The Atmospheric Fund, tells the story of how an initiative to perform energy efficiency retrofits of 7 community housing buildings in Toronto achieved so much more.
Sustainable affordable housing
Energy
Regional Energy Coaches
Regional Energy Coaches help affordable housing providers plan energy efficiency retrofits and new builds.
Sustainable affordable housing
Energy | Housing
Webinar recording: Making affordable housing sustainable
Watch this webinar recording to learn about the various forms of grant, loan and capacity building support we offer to help you retrofit existing units or build new ones.
Sustainable affordable housing
Energy | Housing
Factsheets: Sustainable Affordable Housing
Learn how to retrofit existing housing for energy-efficiency and plan new builds for higher performance.
Sustainable affordable housing
Energy | Housing
Webinar recording: Apply for GMF’s Sustainable Affordable Housing funding
Watch this joint webinar hosted by the Canadian Housing and Renewal Association (CHRA to learn how to apply for FCM’s newest funding initiative – Sustainable Affordable Housing.
Energy | Housing
Webinar recordings: Best practices in municipal sustainability
How are cities and communities of all sizes tackling their environmental challenges? Find out from our five-part webinar series on innovations and opportunities in municipal energy, waste, water, transportation and land use initiatives.
Energy | Housing
Webinar recording: How to prepare a GMF capital project application
Need advice for preparing your GMF capital project funding application? Watch our webinar recording to hear tips from our staff and find out what reviewers are looking for.
Related Projects
See All
Community efficiency financing
Energy | Housing
Case study: Bringing energy efficiency to Saskatoon homes
Community efficiency financing
Energy | Housing