Large manufacturing client (Xcel Energy territory) is asking for detailed ROI calculations to be included in our audit report. They want to justify implementation costs to their corporate office. I usually just present savings amounts, but they're asking for payback periods, NPV, IRR, etc. Anyone have templates or best practices for financial analysis in utility audit reports?
Client Wants ROI Calculations in Report
Paul, I include a separate financial analysis section for corporate clients. Key metrics: simple payback, 5-year NPV, IRR assuming standard discount rates. Most billing corrections have immediate payback since there's no implementation cost.
Be careful about discount rate assumptions. I typically present ROI calculations with multiple scenarios - 5%, 8%, and 10% discount rates. Lets the client choose based on their internal hurdle rates.
Don't forget to factor in ongoing monitoring costs if applicable. Also consider utility rate escalation assumptions - I use 3-5% annual increases for long-term projections unless client has specific guidance.
Include risk assessment in your financial analysis. Rate tariff changes have "low risk" since they're regulatory. Equipment modifications have "medium risk" depending on implementation complexity. Helps executives understand confidence levels.
Add sensitivity analysis for major assumptions. Show how ROI changes if savings are 10% higher or lower than projected. Corporate finance teams love seeing best case/worst case scenarios.
Consider tax implications in your ROI calculations. Utility savings flow directly to bottom line, so effective tax rate affects actual financial benefit. Usually increases ROI significantly.
Great discussion. I'd add that some corporations have specific ROI calculation methodologies they require. Always ask if they have internal financial analysis templates you should follow for consistency.
I create a summary table with all projects ranked by ROI. Makes it easy for clients to prioritize which recommendations to implement first based on payback periods and investment required.