0 ITEMS
BESS Ultimate Model + Portfolio Manager + Multilingual Guide — Standalone Battery Storage Financial Model | 8 Countries | 20-Year DCF
Production-ready Excel financial model for standalone utility-scale BESS projects, bundled with the Portfolio Manager and a five-language user guide. The BESS Ultimate Model covers 8 countries (Italy, Spain, UK, Germany, USA, France, Australia, Nordic) with 3 scenarios each, a four-stream revenue engine (Arbitrage, Ancillary/MSD, Capacity, Other) with country-specific market activation, and a full 20-year DCF producing Project IRR, Equity IRR, NPV, Payback, DSCR and LLCR from a single control panel. Assumptions updated April 2026 from Modo Energy, BESS Index, Capstone DC, enspired and Rystad. The Portfolio Manager aggregates this project alongside up to 49 others into a consolidated pipeline view. The multilingual guide covers the full workflow in Italian, English, French, Spanish and German.
This bundle packages three complementary tools into a single purchase designed for professionals who need to take a standalone battery storage deal from first screening to investment committee presentation.
What is included
The BESS Ultimate Model is a production-ready Excel financial model for standalone utility-scale BESS projects. It covers 8 countries — Italy, Spain, UK, Germany, USA, France, Australia, Nordic — each with Conservative, Base and Aggressive scenarios calibrated from April 2026 sources including Modo Energy Q1 2026, BESS Index April 2026, Capstone DC November 2025, enspired February 2026 and Rystad December 2025.
The model runs a 20-year DCF with a four-stream revenue engine covering Arbitrage, Ancillary/MSD, Capacity and Other revenues. Country-specific market activation is built in — the Capacity market is active for Italy, Spain, UK, USA and Australia but correctly disabled for Germany, France and Nordic where it does not exist. Revenue allocation across active streams is fully user-configurable and the model validates that allocations sum to 100% before running. The financing module covers debt sizing, interest rate and tenor by country, with default tenors of 12 years for European markets and 10 years for USA and Australia. A locked MARKET_REFERENCE copy preserves the original benchmarks so any customisation in MARKET_INPUTS can always be compared against the calibrated baseline.
Key outputs from a single control panel: Project IRR, Equity IRR, NPV, Payback, annual EBITDA, DSCR, LLCR, full debt schedule and revenue waterfall. A tornado sensitivity chart covers nine key variables at ±20%, and two data tables give IRR and Equity IRR across CAPEX vs Arbitrage Price and CAPEX vs Debt % respectively.
The Portfolio Manager aggregates the BESS project outputs alongside any other technology in the pipeline into a consolidated view across up to 50 active projects. Project IRR, Equity IRR, NPV, Revenue, OPEX and Debt ratio from the BESS model transfer directly into a single row. CapEx-weighted portfolio IRR, total NPV, DSCR traffic light and technology breakdown update immediately.
The Multilingual User Guide covers the complete workflow in Italian, English, French, Spanish and German — market benchmarks by country, step-by-step operation, interpretation of all KPIs, DSCR traffic light logic and technical notes on revenue haircut, battery degradation and debt tenor assumptions.
Model architecture
Sheets: CONTROL_PANEL · MARKET_INPUTS · MARKET_REFERENCE · MARKET_CONFIGURATION · ASSUMPTION_ENGINE · REVENUE_ENGINE · FINANCIAL_MODEL · DASHBOARD · SENSITIVITY. Colour coding: Blue = manual input · Green = cross-sheet link · Black = internal formula.
Key assumptions (Base scenario)
CAPEX: €128k–€165k/MWh by country. Ancillary revenues: €62k–€128k/MW/year. Battery degradation: 1.5%/year (NREL 2023). Revenue haircut: 5% flat. OPEX inflation: 2.5%/year. Revenue escalation: 1.0%/year. Debt tenor: 12 years EU / 10 years USA-Australia.
Who this is for
Developers and sponsors evaluating standalone BESS projects at early-stage feasibility. Financial advisors preparing investment memoranda or lender presentations for storage deals. Infrastructure investors screening battery storage assets across multiple markets. Anyone managing a mixed renewable pipeline who needs both a rigorous project-level BESS model and a consolidated portfolio view in a single purchase.
Files included
BESS_Ultimate_Model.xlsx · Portfolio_Manager.xlsx · BESS_Ultimate_Model_Guide.pdf (IT/EN/FR/ES/DE)
Per la Featured Image ti serve un banner 1200×630 px. Vuoi che te ne creo uno con il nome del prodotto e i dettagli chiave, oppure hai già un template grafico da seguire?
This bundle packages three complementary tools into a single purchase designed for professionals who need to take a standalone battery storage deal from first screening to investment committee presentation.
What is included
The BESS Ultimate Model is a production-ready Excel financial model for standalone utility-scale BESS projects. It covers 8 countries — Italy, Spain, UK, Germany, USA, France, Australia, Nordic — each with Conservative, Base and Aggressive scenarios calibrated from April 2026 sources including Modo Energy Q1 2026, BESS Index April 2026, Capstone DC November 2025, enspired February 2026 and Rystad December 2025.
The model runs a 20-year DCF with a four-stream revenue engine covering Arbitrage, Ancillary/MSD, Capacity and Other revenues. Country-specific market activation is built in — the Capacity market is active for Italy, Spain, UK, USA and Australia but correctly disabled for Germany, France and Nordic where it does not exist. Revenue allocation across active streams is fully user-configurable and the model validates that allocations sum to 100% before running. The financing module covers debt sizing, interest rate and tenor by country, with default tenors of 12 years for European markets and 10 years for USA and Australia. A locked MARKET_REFERENCE copy preserves the original benchmarks so any customisation in MARKET_INPUTS can always be compared against the calibrated baseline.
Key outputs from a single control panel: Project IRR, Equity IRR, NPV, Payback, annual EBITDA, DSCR, LLCR, full debt schedule and revenue waterfall. A tornado sensitivity chart covers nine key variables at ±20%, and two data tables give IRR and Equity IRR across CAPEX vs Arbitrage Price and CAPEX vs Debt % respectively.
The Portfolio Manager aggregates the BESS project outputs alongside any other technology in the pipeline into a consolidated view across up to 50 active projects. Project IRR, Equity IRR, NPV, Revenue, OPEX and Debt ratio from the BESS model transfer directly into a single row. CapEx-weighted portfolio IRR, total NPV, DSCR traffic light and technology breakdown update immediately.
The Multilingual User Guide covers the complete workflow in Italian, English, French, Spanish and German — market benchmarks by country, step-by-step operation, interpretation of all KPIs, DSCR traffic light logic and technical notes on revenue haircut, battery degradation and debt tenor assumptions.
Model architecture
Sheets: CONTROL_PANEL · MARKET_INPUTS · MARKET_REFERENCE · MARKET_CONFIGURATION · ASSUMPTION_ENGINE · REVENUE_ENGINE · FINANCIAL_MODEL · DASHBOARD · SENSITIVITY. Colour coding: Blue = manual input · Green = cross-sheet link · Black = internal formula.
Key assumptions (Base scenario)
CAPEX: €128k–€165k/MWh by country. Ancillary revenues: €62k–€128k/MW/year. Battery degradation: 1.5%/year (NREL 2023). Revenue haircut: 5% flat. OPEX inflation: 2.5%/year. Revenue escalation: 1.0%/year. Debt tenor: 12 years EU / 10 years USA-Australia.
Who this is for
Developers and sponsors evaluating standalone BESS projects at early-stage feasibility. Financial advisors preparing investment memoranda or lender presentations for storage deals. Infrastructure investors screening battery storage assets across multiple markets. Anyone managing a mixed renewable pipeline who needs both a rigorous project-level BESS model and a consolidated portfolio view in a single purchase.
Files included
BESS_Ultimate_Model.xlsx · Portfolio_Manager.xlsx · BESS_Ultimate_Model_Guide.pdf (IT/EN/FR/ES/DE)
Per la Featured Image ti serve un banner 1200×630 px. Vuoi che te ne creo uno con il nome del prodotto e i dettagli chiave, oppure hai già un template grafico da seguire?
Similar ProductsOther customers were also interested in...
eFinancialModels
Electric Vehicle (EV) Charging Station Financial M...
With this comprehensive 5- or 10-year monthly tool, investors can assess the viability of setting up... Read more
Financial Model for Mobile App | Mobile App Busine...
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when lau... Read more
HenrySheykin
Food Truck Financial Model Excel Template
The Food Truck Financial Model helps entrepreneurs, founders, business owners, consultants, and anal... Read more
Green Hydrogen Production from Wind Energy Financi...
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Simple Mutual Non-Disclosure Agreement Template
Protect your business secrets with ease using our Simple Mutual Non-Disclosure Agreement Template. S... Read more
Solar Energy Financial Model
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophistica... Read more
Peter Graf
The Customer-Centric Financial Model for Restauran...
Starting a restaurant without a financial plan is like driving a car blindfolded. You wouldn´t do i... Read more
You must log in to submit a review.