Renewable Energy Financial Modeling Excel

Project Title: Renewable Energy + BESS Financial Model Excel Template Project Description: I am looking for an experienced financial modeler with strong knowledge in renewable energy projects and Battery Energy Storage Systems (BESS) to develop a user-friendly and flexible Excel financial model template. The model should be designed for utility-scale renewable energy projects (Solar PV + BESS preferred), and must be intuitive, transparent, and easy to modify for different project assumptions. Key Requirements: * Build in Microsoft Excel only (no proprietary software) * Clear input/output structure * Color-coded input cells * Easy-to-understand formulas and logic * Fully editable and unlocked model * Professional formatting and dashboard presentation Main Functionalities Required: 1. Flexible Financial Modeling The model should allow users to input or modify: * Project CAPEX * OPEX * Installed capacity (MW/MWh) * Generation profile / degradation * BESS parameters * Financing assumptions * Debt/equity structure * Tax assumptions * Inflation/escalation * Project lifetime * Target IRR / profit margin * Tariff / PPA selling price * Energy charge tariff * Capacity charge tariff 2. Revenue Modeling The template should support multiple revenue structures, including: * Energy-based revenue (LCU/MWh or USD/MWh) * Capacity charge revenue (LCU/MW/month or equivalent) * Hybrid tariff structures * Renewable + BESS revenue stacking where applicable The model should allow users to: * Input energy charge tariff and automatically calculate revenue * Input capacity charge tariff and automatically calculate revenue * Combine both energy and capacity charges to derive total project revenue * Adjust dispatch/utilization assumptions and observe revenue impact 3. Automatic Financial Outputs The model should automatically calculate: * Project IRR * Equity IRR * NPV * LCOE / LCOS * Payback period * EBITDA * Revenue and cash flow projections * Debt repayment schedule * DSCR * Sensitivity analysis 4. Reverse / Iterative Calculation Capability One of the key requirements is flexibility in forward and reverse calculations. Examples: * If CAPEX is entered → model calculates required tariff, IRR, LCOE, revenue, etc. * If target IRR and tariff are entered → model back-calculates maximum allowable CAPEX * If profit margin is entered → model calculates sellable tariff * If sellable tariff and target return are entered → model calculates feasible project economics * If energy charge and capacity charge tariffs are adjusted → revenue and returns update automatically The model should support interchangeable scenario analysis without breaking formulas. 5. Scenario & Sensitivity Analysis Please include: * Base / Best / Worst case scenarios * Sensitivity tables for: * CAPEX * Tariff * Interest rate * Energy yield * Capacity factor * Battery augmentation/degradation * Energy charge tariff * Capacity charge tariff * Optional tornado chart/dashboard is a plus 6. Deliverables * Excel financial model (.xlsx) * Clear instructions or notes tab explaining: * Inputs * Outputs * Formula logic * How to run scenarios * Sample filled-in case study for demonstration Preferred Experience: * Renewable energy financial modeling * Solar PV and BESS projects * Project finance / infrastructure investment modeling * Energy yield and tariff modeling Please share: * Relevant previous work or portfolio * Estimated timeline * Proposed cost * Experience with renewable/BESS projects Important: I am looking for a practical and commercially usable model, not just an academic template. The model should be easy for non-financial users to operate while still being robust enough for investment and project evaluation purposes.

Project ID: 40472374