Calculator Inputs
Example Data Table
| Scenario | Rooms | Occupancy | Baseline kWh / Room-Night | Improved kWh / Room-Night | Rate | Year 1 Total Savings | Simple Payback |
|---|---|---|---|---|---|---|---|
| LED + Smart Controls | 120 | 72% | 18.00 | 13.00 | $0.18 | $34,882.43 | 3.01 years |
| HVAC Optimization | 180 | 76% | 22.00 | 16.50 | $0.17 | $53,517.55 | 3.46 years |
| Laundry Heat Recovery | 90 | 68% | 15.50 | 12.40 | $0.20 | $18,753.17 | 2.93 years |
These figures are illustrative and help users understand the data format expected by the calculator.
Formula Used
1) Occupied room-nights per month
Occupied Room-Nights Monthly = Rooms × Occupancy Rate × 30.4167
2) Annual energy use
Annual Energy Use = Occupied Room-Nights Monthly × kWh per Occupied Room-Night × 12
3) Annual energy saved
Annual Energy Saved = Baseline Annual kWh − Improved Annual kWh
4) Year 1 utility savings
Year 1 Utility Savings = Annual Energy Saved × Utility Rate
5) Year 1 total savings
Year 1 Total Savings = Year 1 Utility Savings + Maintenance Savings + Other Savings
6) Net project cost
Net Project Cost = Project Cost − Incentive
7) Simple payback
Simple Payback = Net Project Cost ÷ Year 1 Total Savings
8) Net present value
NPV = Sum of discounted annual savings over analysis period − Net Project Cost
9) Carbon reduction
Annual Carbon Avoided = Annual Energy Saved × Emission Factor
How to Use This Calculator
- Enter the property name and preferred currency symbol.
- Add the total available rooms and average annual occupancy rate.
- Input baseline and improved kWh per occupied room-night.
- Enter the current utility rate paid for electricity.
- Include yearly maintenance savings and any other operational savings.
- Provide the project cost and subtract incentives or rebates.
- Set the analysis period, energy escalation, and discount rate.
- Enter the local emission factor to estimate carbon reduction.
- Press Calculate Savings to show the results above the form.
- Use the CSV or PDF buttons to export the calculated report.
FAQs
1. What does this calculator estimate?
It estimates hotel energy savings, annual cost reduction, payback, NPV, ROI, carbon reduction, and savings per occupied room-night for efficiency projects.
2. Should I use occupied rooms or total rooms?
Enter total available rooms and the average occupancy rate. The calculator converts both values into occupied room-nights for annual energy modeling.
3. Can I include maintenance savings?
Yes. Use the maintenance savings field for labor, replacement, and service reductions created by new lighting, controls, HVAC upgrades, or similar work.
4. What is energy cost escalation?
Energy cost escalation is the yearly increase expected in utility prices. It helps project future savings more realistically across the analysis period.
5. Why include a discount rate?
A discount rate converts future savings into present value. This makes long-term projects easier to compare with current capital spending options.
6. How is payback different from ROI?
Payback shows how many years savings need to recover cost. ROI measures total gain relative to net project investment.
7. What emission factor should I enter?
Use your local grid electricity emission factor, usually expressed in kilograms of CO₂e per kWh. Utility reports or local energy agencies often publish it.
8. Can I use this for multiple properties?
Yes. Run the calculator once for each property or create weighted averages for portfolio planning, then compare exported reports side by side.