BESS (Battery Energy Storage System) Business Financial Proj (Excel XLSX)

VIDEO DEMO

BENEFITS OF THIS EXCEL DOCUMENT

1. Provide a robust, best-practice financial modelling framework to evaluate the feasibility, profitability, and bankability of Battery Energy Storage System (BESS) projects using transparent and structured assumptions.
2. Enable informed investment and financing decisions by delivering integrated financial statements, valuation metrics, and scenario analysis aligned with industry and project finance standards.
3. Save time and reduce modelling risk by offering a fully automated, customizable Excel model that replaces complex manual modelling while maintaining accuracy, consistency, and auditability.

RENEWABLE ENERGY EXCEL DESCRIPTION

This product (BESS [Battery Energy Storage System] Business Financial Proj) is an Excel template (XLSX) with a supplemental Excel document, which you can download immediately upon purchase.

BESS MODEL OVERVIEW
A BESS (Battery Energy Storage System) business develops, owns, or operates battery systems that store electricity when it's cheap or abundant and release it when the grid needs it. It earns revenue through energy arbitrage, capacity payments, and grid support services, turning battery flexibility and reliability into a commercial asset.

Our highly versatile and user-friendly Excel model enables the preparation of a 20-year rolling 3-statement (Income Statement, Balance Sheet, and Cash Flow Statement) financial projection with an annual timeline. It supports a mix of actual and forecast periods, making it suitable for both new BESS developments and existing operating portfolios. The model also accommodates up to five distinct BESS projects, each at different lifecycle stages, including pipeline/forecast and in operation.
The model incorporates key BESS-specific functionality, including:
• Revenue modelling for energy arbitrage and capacity/availability payments.
• Battery performance assumptions, including cycles, throughput, degradation, round-trip efficiency and availability.
• Comprehensive CAPEX schedules including depreciation, asset lives, and future replacement additions.
• Detailed OPEX projections, including direct and indirect staff costs and operating costs
• Borrowings and financing, including debt drawdowns, interest, repayments, and funding additions.
• Corporate tax, sales tax/VAT treatments, equity additions and dividend distributions.
The model follows good-practice financial modelling principles and includes clear instructions, line-item explanations, built-in checks, and input validations. It also features a discounted cash flow (DCF) valuation together with a clean, visual dashboard for results and key performance indicators.

BESS MODEL KEY OUTPUTS
•  Projected full financial statements (Income Statement, Balance Sheet and Cash flow Statement) presented on an annual basis across 5 years.
•  Dashboard with:
•  Summarised projected Income Statement and Balance Sheet.
•  Compounded Annual Growth Rate (CAGR) for each summarised income statement and balance sheet line item.
•  Key ratios including average revenue growth, average profit margins, average return on assets and equity and average debt to equity ratio.
•  Tables and Bar charts summarising revenue and gross profit by mining location.
•  Charts and graphs showing: cash balance by month, free cash flow generation, cash flow statement breakdown, profit margins, income statement breakdown, net cash vs net income, working capital, valuation and capital structure.
•  Discounted cash flow valuation using the projected cash flow output.
•  Breakeven analysis

BESS MODEL KEY INPUTS
Setup Inputs:
•  Name of business.
•  Currency.
•  Timeline start year and first projection year.
•  Naming for BESS projects, CAPEX and OPEX cost categories, staff cost categories and borrowings.

Actuals Inputs:
•  Opening balance sheet (for existing businesses);
•  Income Statement actuals (for trend analysis);

Projection Inputs:
•  BESS project general assumptions: lifecycle status, project start year, total project lifetime, installed power capacity (MW), maximum energy capacity (MWh), battery degradation, charge/discharge cycles per day, round-trip efficiency (RTE) and system availability.
•  Revenue assumptions: energy arbitrage pricing and capacity market revenue.
•  Direct operating cost assumptions expressed on a per MW per year.
•  Direct labour: annual full-time equivalent (FTE) requirements for operational staffing
•  CAPEX assumptions including useful life assumptions, addition amounts and timing of additions.
•  Other operating costs: non-direct staff costs and additional site or corporate operating expenses.
•  Tax inputs: sales tax and corporate tax rates, timing and payment periods.
•  Dividend policy: distributions based on fixed amounts or a percentage of retained earnings.
•  Borrowings: new debt drawdowns, interest rates and repayment profiles.
•  Share capital: planned equity injections.
•  Valuation inputs: discount rate assumptions for DCF valuation.

BESS MODEL STRUCTURE
The model comprises of 9 tabs split into input ('i_'), calculation ('c_'), output ('o_') and system tabs. The tabs to be populated by the user are the input tabs ('i_Setup', ‘i_Actuals' and 'i_Assumptions'). The calculation tab uses the user-defined inputs to calculate and produce the projection outputs which are presented in 'o_Fin Stats', ‘o_Dashboard' and ‘o_DCF'.

BESS MODEL KEY FEATURES
•  The model contains a flexible timeline that allows for a mix of actual and forecast periods across a 20-year period. This allows projections to be easily rolled forward as forecast periods become actual period.
•  The model is not password protected and can be modified as required following download.
•  The model allows the user to model up to 5 BESS projects (both existing and new) with own assumptions for lifecycle stage, revenue, direct costs, CAPEX, and direct labour usage.
•  The model allows for the following number of underlying categories for each line item (these can be easily expanded if required):
•  BESS projects – 5 projects.
•  Direct costs – 10 categories.
•  Staff costs – 8 direct staff categories and 8 non-direct staff categories.
•  Development Costs – 10 categories (split soft and hard).
•  Other expenses – 15 categories.
•  Borrowings – 5 facilities.
•  Apart from projecting revenue and costs the model includes the possibility to model, development costs, borrowings (amortising), dividends and corporate tax.
•  Business name, currency, starting projection period and revenue and cost naming are fully customisable.
•  The model included an integrated discounted cash flow valuation using the projected cash flow outputs.
•  The model includes instructions, line-item explanations, checks and input validations to help ensure input fields are populated accurately.
•  The model includes a checks dashboard which summarises all the checks included in the various tabs making it easier to identify any errors.

SUPPORT / MODIFICATIONS
We are keen to ensure our customers are satisfied and find the models useful for their financial projection needs. Our models are developed with the user in mind and include instructions, line-item explanations, checks and input validations to ensure they are as user-friendly and easy to use as possible without requiring extensive knowledge of Microsoft Excel, finance or accounting. If any questions do arise, we are more than happy to assist. We are also happy to support with any be-spoke modifications you may require to the models to better suit your business needs. To get in touch, please send us a message through the website or contact us on:
We are also always keen to receive feedback so please do let us know what you think of our models by sending us a message or submitting a review.

ABOUT PROJECTIFY
We are financial modelling professionals with experience working in big 4 business modelling teams and strong experience supporting businesses with their financial modelling and decision support needs. Our aim is to provide robust and easy-to-use tools that follow good practice financial modelling guidelines and assist individuals and businesses with their financial projection and analysis requirements.

Source: Best Practices in Renewable Energy, Integrated Financial Model Excel: BESS (Battery Energy Storage System) Business Financial Proj Excel (XLSX) Spreadsheet, Projectify