
Open
Posted
•
Ends in 1 hour
Paid on delivery
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
22 proposals
Open for bidding
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $70 USD for this job

I can build a fully structured renewable energy + BESS financial model in Excel with flexible inputs, tariff-based revenue modeling, IRR/NPV/DSCR outputs, scenario analysis, and reverse calculations (tariff ↔ CAPEX ↔ returns). The model will be clean, user-friendly, fully editable, and designed for real commercial project evaluation. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$50 USD in 2 days
6.6
6.6

CPA License holder Hi, I am an experienced Associate Member the Certified Cost and Management Accountant (ACMA), a Financial Analyst and a Certified Public Accountant (CPA) with more than 7+ years' experience in finance. I have gone through your project with interest, and it seems a perfect match with my skills. May I ask you a few questions about your project? What’s the principal activity of your business? Do you have any specific reporting requirements? When would you like to start? I have been providing financial modelling, business analysis, business plans, financial analysis, financial forecasting, Excel, advanced Excel, Visual Basic, payroll, data processing, data entry, finance, accounting, and financial research services and have more than 3+ years with a top-rated audit firm (KPMG), during which I have dealt with a number of clients and provided them extremely satisfactory services. Apart from that, I am also highly proficient in different accounting software packages like Excel, Advanced Excel, QuickBooks, Intuit QuickBooks, Xero, Microsoft Dynamics, Enterprise and more. I am a fast learner, problem solver, detail-orientated and highly organised. Looking forward to hearing from you soon! Looking forward to hearing from you Best regards. Zakwan
$50 USD in 1 day
6.4
6.4

. Hi, This is exactly the type of advanced infrastructure and project finance modeling work I specialize in. I have 7+ years of experience building financial models for energy, infrastructure, and investment projects, including renewable energy and long-term project finance structures. I can build a fully dynamic and commercially usable Excel model for Solar PV + BESS projects with: • Clean input/output architecture • Flexible tariff and revenue modeling • Debt/equity financing structure • Energy + capacity charge calculations • Reverse engineering capability for IRR, tariff, and CAPEX optimization • Scenario and sensitivity analysis • Professional dashboards and investment-ready presentation The model will be: • Fully editable and unlocked • Color-coded and easy to operate • Designed for non-financial users as well as investors/lenders • Structured for real commercial decision-making, not just academic analysis I can also include: • DSCR sculpting logic • LCOE / LCOS calculations • Revenue stacking for BESS • Base / best / worst case scenarios • Sensitivity tables and optional tornado charts A sample case study and instruction tab will also be included for usability. Estimated timeline: 1-3 days depending on final scope and complexity. Estimated cost: Can be discussed based on required depth and scenario sophistication. Please open the chat for further discussion. Thanks & regards, Naresh
$30 USD in 7 days
5.5
5.5

Hello, I can develop a professional and fully editable Excel financial model template for utility-scale Solar PV + BESS projects with clear input/output structure, color-coded assumptions, scenario analysis, dashboard presentation, revenue modeling, debt schedule, IRR, NPV, DSCR, LCOE/LCOS, payback, EBITDA, and sensitivity analysis. I have strong experience in Excel financial modeling, dashboards, automation, data analysis, and business intelligence, and I can make the model practical for commercial use while keeping formulas transparent and easy for non-financial users to modify. I can also include Base/Best/Worst scenarios, reverse calculations for target IRR, tariff, CAPEX, and profit margin, plus a notes tab with instructions and a sample filled case study. Relevant Certifications: Excel Basics for Data Analysis – IBM Data Visualization and Dashboards with Excel and Cognos – IBM Business Intelligence Essentials – IBM Data Visualization and Dashboards with Power BI – IBM Introduction to Data Analytics – IBM Regards, Talha Almas Data Scientist / Data Analyst / Full Stack Dev Relevant Skills: Excel Financial Modeling, Scenario Analysis, Sensitivity Analysis, Dashboards, Power BI, Data Analysis
$40 USD in 3 days
3.3
3.3

Hi, I am Syed Taha Hussain, and I would love to build this utility-scale Solar PV + BESS financial model template for you. Financial market analysis, corporate research, and automated spreadsheet modeling are my primary skills. I am a financial analyst with deep experience building commercially viable project finance models that blend complex operational mechanics with institutional-grade investment evaluation. I am an expert in structuring fully integrated infrastructure engines, specialising in linking operational capacities, degradation curves, and battery augmentation schedules directly to the 3-Statements and debt service modules. I have a strong background in embedding robust engineering logic into flexible Excel models, allowing non-financial users to manipulate dual-revenue stacking energy arbitrage and capacity charges without breaking the workbook. Kindly message me in the chat so I can share my previous modeling work as a reference and discuss your target timeline to get started immediately.
$35 USD in 3 days
3.0
3.0

Hi Hope you are doing well. I have done many rooftop solar project. I already have many solar financial model. I can do it perfectly for you. Thanks
$59.99 USD in 1 day
2.7
2.7

As a trusted and experienced financial professional, I have successfully empowered numerous clients with the AI-powered financial efficiency and effectiveness they need to thrive. In regard to your need for a renewable energy financial modeling expert with Solar PV and BESS project expertise, my track record is robust. From project finance to infrastructure investment modeling, as well as energy yield and tariff modeling, I have a deep understanding of the inner workings of such projects. Utilizing the extensive Excel skills I possess in solidifying flawless input/output structures, easy-to-understand formulas and logic, as well as professional formatting, I can deliver an intuitive and flexible Excel financial model template for your utility-scale renewable energy + BESS operations When it comes to scenario & sensitivity analysis in the realm of renewable energy, rest assured, proficiency in this area is part of what defines my work. I will not only include base/best/worst case scenarios but also tangibly demonstrate how adjustments in CAPEX&Mdash; target IRR&Mdash;sellable tariff&Mdash;energy charge&tornado chart are likely to affect different outputs longitudinally. Additionally, I guarantee to meet all other listed key requirements such as automatic calculation and offer optional thorough explanations in line with your desired format.
$20 USD in 7 days
2.9
2.9

Hi, I carefully reviewed your requirements, and this is exactly the type of structured, investment-grade Excel model that benefits from a clean architecture, transparent assumptions, and flexible scenario logic rather than a rigid academic template. What you’ll get: * Fully editable Excel model for Solar PV + BESS projects * Clear Inputs / Calculations / Outputs structure * Revenue modeling for energy, capacity, and hybrid tariffs * Project IRR, Equity IRR, NPV, LCOE/LCOS, DSCR, EBITDA, and debt schedules * Forward and reverse calculation capability for tariff/CAPEX/IRR targeting * Scenario manager with Base/Best/Worst cases * Sensitivity tables and optional dashboard/tornado visuals * Notes tab and sample case study included The model will be designed for commercial usability, fast scenario testing, and easy handover to non-financial users without breaking formulas. I’ve completed similar projects with 5⭐ feedback for accuracy and delivery. Estimated turnaround: 3–5 days Budget: $30 USD Please send me a message so we can get started immediately.
$30 USD in 4 days
2.1
2.1

I've built Solar PV and BESS financial models for utility-scale projects, and your spec is exactly the kind of work I enjoy doing properly. Here's what I'll deliver: A fully unlocked Excel model with color-coded inputs, automatic IRR/NPV/LCOE/DSCR outputs, and a clean dashboard. Revenue logic will handle energy charges, capacity charges, and hybrid tariff stacking. The reverse calculation feature (input target IRR, get back required tariff or max CAPEX) will work without circular reference issues using Goal Seek setup or iterative logic clearly documented. Sensitivity tables covering CAPEX, tariff, interest rate, energy yield, and battery degradation. Base/Best/Worst case toggle. A filled sample case study so you can see exactly how the model behaves before touching it yourself. I keep formulas transparent and labeled. No black-box logic, no locked sheets. Someone without a finance background should be able to open it and understand what each input does within minutes. Timeline: 3 to 4 days. I can share a previous model structure or a sample output tab if that helps you decide. Happy to adjust any assumption structure to fit your specific project type before I start.
$45 USD in 5 days
2.3
2.3

Hello, I am an experienced financial modeler with strong expertise in renewable energy project finance, including Solar PV and Battery Energy Storage Systems (BESS). I can develop a professional, commercially usable Excel financial model template that is flexible, transparent, and easy for both financial and non-financial users to operate. The model will be fully built in Microsoft Excel with clean architecture, color-coded inputs, unlocked formulas, and clear separation between assumptions, calculations, outputs, and dashboards. The model will include: • Flexible CAPEX, OPEX, financing, tax, tariff, degradation, and dispatch assumptions • Solar PV + BESS operational and revenue modeling • Energy charge and capacity charge tariff structures • Hybrid revenue stacking capabilities • Automatic calculation of Project IRR, Equity IRR, NPV, LCOE, LCOS, EBITDA, DSCR, payback period, and debt schedules • Forward and reverse calculation functionality for tariff optimization, target IRR, and maximum allowable CAPEX • Dynamic sensitivity analysis and scenario management (Base / Best / Worst cases) • Professional dashboard and presentation-ready outputs • Fully editable and transparent formulas with no locked logic I can also include: • Tornado charts and visual sensitivity dashboards • Sample case study for demonstration • Notes/instruction tab explaining assumptions, formulas, and scenario usage Looking forward to working with you.
$50 USD in 2 days
1.5
1.5

Hi, I have read and understood the requirements for the Renewable Energy + BESS Excel financial model. I can build a clean, fully editable and commercially usable Excel model for solar PV + BESS projects with clear input/output structure, transparent formulas, and a professional dashboard. The model will include full revenue logic (energy + capacity + hybrid), IRR/NPV/LCOE outputs, debt schedule, DSCR, and scenario/sensitivity analysis. It will also support reverse calculations like target IRR → required tariff or CAPEX adjustments. Everything will be structured for easy use by non-finance users while still being robust for investment and project evaluation. Please contact me for samples and detailed discussion.
$10 USD in 1 day
0.0
0.0

I'm a financial modeler, not a renewable energy engineer, and that's actually useful here. It means I'll build your model so that any user can update the BESS parameters, tariff assumptions, or CAPEX figures without breaking a single formula. The financial architecture will be solid regardless of what the energy inputs are. What I'll deliver in 7 days: structured input sheet with color-coded cells, automatic calculation of IRR, Equity IRR, NPV, DSCR, LCOE, and payback period, Base/Best/Worst scenario toggle, sensitivity tables for CAPEX/tariff/interest rate, and a notes tab explaining every section. For the reverse calculation logic, target IRR back-calculating to maximum CAPEX or sellable tariff from a profit margin, I'll use Excel's Goal Seek or iterative formulas depending on which approach keeps the model stable. One question: do you have a reference model or existing template I can use as a starting point, or are we building from a blank sheet?
$30.99 USD in 7 days
0.0
0.0

Hello, I’m very interested in developing your Renewable Energy + BESS Financial Model Excel Template. With experience in renewable energy financial modeling, project finance, and advanced Excel automation, I can build a practical, investment-grade model that is both commercially usable and easy for non-financial stakeholders to operate. I understand that this is not just a theoretical exercise — you need a flexible and robust tool capable of evaluating real-world Solar PV + BESS projects under multiple financing and tariff structures. That is exactly the type of model I specialize in.
$15 USD in 7 days
0.0
0.0

Hi, I'm a financial modeler with hands-on experience building structured, investor-grade Excel models for complex renewable energy across Africa and in Europe. I've built multiple Project Finance models for deal size between $50m and $430m with dynamic assumptions, color-coded inputs, automated outputs, and sensitivity tables, which maps directly to what you're describing here. For this project specifically, I'm comfortable with: - Full CAPEX/OPEX and revenue modeling for Solar PV + BESS assets - Debt structuring, DSCR, and equity return metrics (IRR, NPV, payback) - Reverse/iterative calculations — e.g., back-solving for required tariff given a target IRR, or solving for max CAPEX given a target margin - Energy and capacity charge revenue stacking (LCU/MWh and LCU/MW/month structures) - Scenario and sensitivity tables (CAPEX, tariff, capacity factor, degradation) - Clean, unlocked, fully transparent model architecture — no black boxes My approach: I build models that non-financial users can operate confidently, while remaining rigorous enough for investment committee or lender review. Every input is clearly labeled, color-coded, and sourced. Every output is traceable back to assumptions. I can deliver a complete first draft within 10 days, including a filled sample case study for demonstration. I'm happy to share relevant prior work or discuss the scope in more detail before you commit. Looking forward to hearing from you.
$500 USD in 10 days
0.0
0.0

Petaling Jaya, Malaysia
Payment method verified
Member since Apr 1, 2019
$30-250 USD
$10-30 USD
₹600-1500 INR
₹12500-37500 INR
£250-750 GBP
$30-250 USD
$15-25 USD / hour
$30-250 USD
₹750-1250 INR / hour
$10-30 AUD
₹12500-37500 INR
$250-750 USD
₹600-1500 INR
₹600-1500 INR
$15-25 USD / hour
$10-50 USD
₹12500-37500 INR
$250-750 USD
£10-15 GBP / hour
$250-750 USD
₹750-1250 INR / hour
₹400-750 INR / hour