Inputs
Example Data
Use this sample to validate your setup.
| Scenario | Baseline kWh | Rate | Reduction | Upfront | Incentives | Years |
|---|---|---|---|---|---|---|
| Small office lighting + controls | 2,500 | $0.16 | 15% | $4,500 | $500 | 10 |
| Retail HVAC tune-up + scheduling | 6,800 | $0.18 | 10% | $2,200 | $0 | 7 |
| Warehouse LED retrofit | 18,000 | $0.14 | 25% | $28,000 | $4,000 | 12 |
Formula Used
- Improved monthly usage: kWhnew = kWhbase × (1 − r), where r = reduction% / 100.
- Monthly bill estimate: Bill = (kWh × rate) + fixed + demand.
- Annual savings (Year 1): Savings1 = 12 × (Billbase − Billnew) − maintenance.
- Escalation: Costy = Cost1 × (1 + e)(y−1), where e = escalation% / 100.
- Discounted savings: PVy = Savingsy / (1 + d)y, where d = discount% / 100.
- NPV: NPV = −(upfront − incentives) + Σ PVy.
- Payback: first year where cumulative savings ≥ 0.
How to Use
- Enter your typical monthly kWh and your energy rate.
- Add fixed and demand charges if they apply to your bill.
- Choose a realistic reduction percentage for your project.
- Enter implementation cost, incentives, and yearly maintenance.
- Set escalation and discount rates for long‑term evaluation.
- Press Calculate. Review payback, NPV, and the yearly projection.
- Download CSV or PDF to share with stakeholders.
Baseline cost drivers and a practical starting point
Energy spend is usually dominated by usage and the per‑kWh rate, while fixed and demand charges set a predictable floor. For example, 2,500 kWh at $0.16 equals $400 in energy, and adding $25 in fixed fees creates a $425 baseline month. Capturing these drivers helps you separate controllable consumption from unavoidable tariff components.
Translating percentage reduction into monthly cash savings
A reduction target converts directly into fewer kilowatt‑hours. With a 15% reduction, monthly usage falls from 2,500 to 2,125 kWh, so energy charges drop from $400 to $340 at the same rate. Keeping fixed and demand charges constant makes the savings traceable, and the calculator reports both the baseline and improved bill for quick comparison.
Project economics with incentives and ongoing maintenance
Upfront spending should be evaluated after rebates. If implementation costs $4,500 and incentives are $500, net upfront cost becomes $4,000. Annual maintenance is deducted from savings to reflect real operating costs; a $50 yearly service plan reduces the first‑year savings slightly but produces more realistic payback and ROI estimates.
Long-term outlook using escalation and discounted value
Because energy prices can rise, the projection escalates both scenarios by your selected rate, such as 3% per year. Discounting future savings at 8% converts the stream into present value, producing an NPV that favors projects with faster, larger savings. This approach supports consistent comparisons across different upgrade options and equipment lifetimes.
Using the results to prioritize the next efficiency step
Use payback to screen options, but rely on NPV and total savings to rank finalists. If payback is not reached within the analysis period, reduce assumptions, extend the horizon, or revisit cost inputs. Track annual kWh saved and optional CO2 savings to align financial goals with sustainability targets and reporting needs. today today today today today today today today today today today today today today today today today today today today today today today today today today
FAQs
What inputs matter most for accuracy?
Monthly kWh, the per‑kWh rate, and the reduction percentage drive most results. Add fixed and demand charges if shown on your bill, and include realistic incentives and maintenance to avoid overstating savings.
Does the calculator include demand savings?
Demand is treated as a fixed monthly charge in this version. If your project reduces peak demand, lower the demand charge input to reflect the improved tariff outcome or run separate scenarios.
Why is first‑year savings lower than expected?
Annual maintenance is subtracted from savings. Also, fixed and demand charges do not change unless you adjust them, so only the kWh portion of the bill responds to the reduction percentage.
What is the difference between payback and NPV?
Payback reports the first year cumulative savings exceed the net upfront cost. NPV discounts future savings to present value, helping compare projects with different lifetimes and timing of benefits.
How should I choose escalation and discount rates?
Use a conservative escalation based on recent tariff trends and your utility outlook. For discount rate, use your hurdle rate or weighted cost of capital so the NPV reflects your organization’s financing reality.
Can I share results with my team?
Yes. After calculating, download the CSV for spreadsheets or the PDF for quick review. Use multiple runs to compare scenarios and document the assumptions behind each option.