Sample scenario and outputs
| Item | Example value | Notes |
|---|---|---|
| Monthly usage | 900 kWh | Typical mid-size household average. |
| Energy rate | $0.16 / kWh | Blended rate across tiers. |
| Fixed charges | $12.00 | Service and meter fees. |
| Taxes & fees | 6% | Applied to variable + fixed charges. |
| Expected reduction | 15% | LEDs + HVAC tune-up + behavior shifts. |
| Upgrade cost | $600 | Installed measures and materials. |
| Rebates | $100 | Utility or local program incentives. |
| Estimated monthly savings | $22–$24 | Depends on tariff and fixed charges. |
| Estimated payback | ~2 years | Net cost divided by annual savings. |
Calculation logic
- Baseline bill: (kWh × rate + fixed) × (1 + taxes%)
- Projected usage: new kWh = kWh × (1 − reduction%)
- Projected bill: (new kWh × rate + fixed) × (1 + taxes%) − extra monthly savings
- Savings: monthly savings = baseline − projected; annual savings = monthly savings × 12
- Net cost: net cost = upgrade cost − rebates
- Payback: payback years = net cost ÷ annual savings (when annual savings > 0)
- ROI: ROI% = (annual savings ÷ net cost) × 100 (when net cost > 0)
- Financing (optional): monthly payment uses the standard amortization PMT formula with APR and term.
- NPV: discounted cash flows across the horizon, with optional annual price escalation and financing payments in early years.
- Carbon impact: annual kWh saved × emission factor (kg CO₂ per year).
Steps for reliable estimates
- Find your average monthly kWh from recent bills (or a 6–12 month average).
- Enter your blended rate per kWh and any fixed monthly charges.
- Add an estimated taxes/fees percentage from your bill summary.
- Choose a realistic reduction percent for your planned upgrades.
- Enter upgrade cost and rebates to estimate net investment.
- Optionally enable financing and set APR and term to reflect payments.
- Use horizon, discount, and escalation rates for longer-term value (NPV).
- Press Calculate savings; results appear above the form.
- Use Download CSV or Download PDF to save outputs.
Baseline cost structure and inputs
A baseline monthly bill is built from three levers: energy use, unit price, and fixed charges. For example, 900 kWh at 0.16 per kWh creates 144.00 in variable cost. Adding 12.00 in fixed fees yields 156.00 before add‑ons. Separating fixed fees from usage charges helps you see what efficiency can and cannot change each month. With 6% taxes and fees, the baseline becomes about 165.36 per month. Using a recent bill average improves stability.
Usage reduction and projected bills
Savings start with a reduction percentage applied to monthly kWh. A 15% reduction on 900 kWh lowers usage to 765 kWh, cutting variable cost to 122.40 at the same rate. After fixed charges and 6% fees, the projected bill is about 142.46 per month. If you receive a recurring credit, enter it as “extra monthly savings.”
Investment view: net cost, payback, and ROI
Net upgrade cost equals upfront cost minus rebates. In the example, 600 minus a 100 rebate equals 500 net. Monthly savings of about 22.90 translate to 274.75 per year. Simple payback is net cost divided by annual savings: 500 ÷ 274.75 ≈ 1.82 years. Annual ROI is (274.75 ÷ 500) × 100 ≈ 54.95%.
Long-term value using escalation and discounting
To value multi‑year benefits, the calculator applies price escalation to annual savings and discounts future cash flows back to today. With a 10‑year horizon, 3% escalation, and a 6% discount rate, the example produces an NPV near 1,785.61. Higher discount rates reduce NPV, while higher escalation rates increase it.
Carbon impact and reporting
Energy savings can be translated into avoided emissions using an emission factor in kilograms of CO₂ per kWh. With a 0.40 factor and 1,620 kWh saved annually, the estimate is about 648 kg of CO₂ avoided each year (0.65 metric tons). Use a local grid factor if available for better accuracy.
Common questions
1) Which bill values should I enter?
Use an average of 6–12 recent bills. Enter kWh used, your blended price per kWh, fixed service fees, and the taxes/fee percent shown on the bill summary.
2) How do I pick a realistic reduction percent?
Start with a conservative range, like 5–25%. Use manufacturer estimates or audit reports, then adjust for your habits and climate. Re-run scenarios to see sensitivity.
3) Does this handle tiered or time-based rates?
The calculator uses a single blended rate. If you have tiers or time-based pricing, compute an average rate from your bill (total energy charges ÷ total kWh) and use that value.
4) What does NPV tell me?
NPV converts future savings into today’s money using your discount rate. A positive NPV suggests the savings outweigh the net cost over the chosen horizon, under your escalation and financing assumptions.
5) How should I use the financing option?
Enable financing when you will repay the upgrade over time. Enter APR and term to estimate monthly payment. Compare payment against monthly savings to judge near-term cash flow comfort.
6) How is carbon impact calculated?
Annual kWh saved is multiplied by the emission factor you enter (kg CO₂ per kWh). If you don’t know your grid factor, leave the default or replace it with a local published value.