SmartHelping / Battery Energy Storage / Excel
BESS Financial Model
Build a complete 10-year forecast for a battery energy storage system operator. Connect project construction, tolling and merchant revenue to dynamic debt, cash requirements, valuation and equity returns.
- Plan phased battery deployment, degradation and augmentation.
- Set project financing percentages, loan terms and repayment assumptions.
- See how operating decisions affect debt coverage and investor cash flow.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Walk through the business, inputs and results.
Follow the video from battery capacity and revenue assumptions through operating costs, financing, the financial statements and the cash returned to equity.
The business being modeled
Own storage capacity. Earn revenue from its use.
This workbook models a standalone, grid-connected BESS owner/operator. Batteries are purchased and installed at operating sites, charged with electricity, and used to provide contracted storage capacity, energy trading and grid services.
Tolling agreements
Reserve a share of battery capacity for a customer and earn a capacity-based fee. The model assigns that customer's dispatch and charging economics to the tolling customer, while the owner maintains the asset.
Merchant energy sales
Buy charging electricity and sell discharged energy using captured-price assumptions. Charging costs, round-trip losses, variable maintenance and optimizer fees help determine the owner's trading contribution.
Capacity-only revenue
Earn payments on qualified merchant energy capacity under contracts that retain the owner's energy-trading rights. Required duration, contract coverage and availability determine the modeled eligible MW.
Ancillary services
Allocate part of the non-tolled capacity to grid-support services. Model reserved MW, award hours, service pricing and the energy losses associated with providing those services.
The workbook represents an energy storage operator purchasing installed equipment. Owned solar or wind generation is outside its current scope. Revenue allocations should reflect the dispatch rights and obligations in the project's actual agreements.
Inside the workbook
A connected operating and investment model.
Start with the physical projects and the activities that produce revenue. Follow the results through costs, capital spending, debt, taxes, cash balances and investor returns.
Build the storage portfolio in phases
Plan up to eight project phases with separate capacity, construction timing, commercial operation dates and useful lives. Enter battery energy costs, power equipment costs, owner costs and contingency to build the capital budget.
Connect usable capacity to revenue
Model MW and MWh, availability, round-trip efficiency, seasonal dispatch, calendar and cycling degradation, and periodic augmentation. Follow how battery performance changes the electricity available to sell.
Separate the rights behind each revenue stream
Model tolling, merchant energy sales, capacity-only payments and ancillary services. Allocate tolled and merchant capacity separately, with duration and availability adjustments for qualified capacity.
Include the cost of charging and dispatch
Connect electricity purchases to charging requirements and efficiency losses. Include grid and market fees, throughput-based maintenance, optimizer fees, service O&M, land leases, insurance and property taxes.
Follow earnings through to cash
Review 120 monthly periods and ten annual summaries across the income statement, balance sheet and cash flow statement. Working capital, physical capex, depreciation, financing and taxes flow through the connected schedules.
See what investors contribute and receive
Track initial capital, scheduled contributions, equity backstop funding, operating distributions and net exit proceeds. Measure equity IRR, MOIC and NPV after debt service and the debt deducted at exit.
Value the remaining operating life
Discount unlevered project cash flows and estimate Year 10 value from remaining-life operations. Compare that result with an EBITDA-multiple exit and football field ranges for DCF, EBITDA, asset book value and operating capacity.
Test the drivers and explain the results
Switch between Base, Downside and Upside assumptions. Review valuation sensitivity and the effect of tolling and captured energy prices on Year 10 EBITDA and margin, alongside financial charts, operating KPIs and model checks.
Dynamic debt and funding
Connect the financing plan to the project cash flow.
Project construction and term debt
Set a financing percentage for each phase's initial construction capex and capitalized construction interest. Adjust interest rates, loan terms, interest-only periods and draw fees, then follow borrowing, scheduled principal and outstanding balances.
Working capital and cash reserves
Model a working-capital revolver with a borrowing base, interest and commitment fees. Include debt-service reserves, a minimum cash target, scheduled equity and optional backstop contributions to see when additional funding is required.
Optional investment tax credit
Enable a transferable ITC only when the eligibility assumptions are confirmed. Model the credit sale price, cash receipt delay, tax-basis adjustment and the share of proceeds applied to term debt. ITC prepayments keep the scheduled loan payment unchanged and can accelerate payoff.
Debt coverage and distributions
Review cash available for debt service, scheduled repayments, closing debt and DSCR. Distribution controls connect cash reserves and coverage requirements to the cash that can be returned to investors.
How to use it
Move from project assumptions to an investment decision.
- 01
Define the project rollout
Enter each phase's build timing, MW, storage duration, equipment costs, useful life and augmentation plan in Project_Plan.
- 02
Set the operating and contract assumptions
Choose a scenario and adjust tolling shares, merchant prices, dispatch, availability, service allocations and operating costs.
- 03
Choose the financing and funding structure
Set project debt percentages and terms, operating liquidity, reserve requirements, tax assumptions and any confirmed ITC treatment.
- 04
Review cash needs and investor outcomes
Use the statements, equity summary, DCF, sensitivities, charts and model checks to evaluate the plan and compare changes.
Who can use it
Built for storage, financing and investment decisions.
Developers and founders
Estimate capital needs, phase construction and test whether the proposed revenue mix supports the operating and financing plan.
Battery owners and operators
Evaluate contract allocations, changing merchant economics, augmentation spending and the cash consequences of expansion.
Investors and lenders
Examine debt coverage, funding gaps, remaining-life value and the timing of contributions, distributions and net exit proceeds.
CFOs, advisors and consultants
Use an editable framework to develop forecasts, compare scenarios and explain how physical and commercial assumptions affect financial results.
Also available in these bundles
Get this model as part of a larger collection.
The BESS Financial Model is included in the Industry-Specific, Renewable Energy and Super Smart bundles. Compare the collections if you need models for additional projects or business types.
Industry-Specific Bundle
Explore operating models built around the revenue, cost and growth drivers of individual industries.
View Industry-Specific BundleRenewable Energy Bundle
Compare models for energy generation, storage, charging infrastructure, recycling and production economics.
View Renewable Energy BundleSuper Smart Bundle
Access the complete SmartHelping template collection for operating forecasts, valuation, financing and more.
View Super Smart BundleQuestions before you purchase
A few useful details.
What business does this model represent?
A standalone, grid-connected battery energy storage owner/operator. It models purchasing and installing battery equipment, then earning tolling, merchant energy, capacity and ancillary service revenue. It does not model battery manufacturing or owned solar generation.
How long is the forecast?
The connected operating and financial model covers 120 months, with ten annual summaries. A separate residual-value schedule projects remaining-life cash flows beyond Year 10 for valuation; it does not extend the full three-statement forecast.
Can I finance different project phases differently?
Yes. Each project phase has its own financing percentage, interest rate, loan term, interest-only period and fee assumptions. The percentage applies to initial construction costs and capitalized construction interest. Later augmentation is a separate cash requirement.
Does the equity analysis account for debt repayment?
Yes. The equity summary uses investor contributions, distributions after financing obligations, and optional net exit proceeds after debt and selling costs. The project DCF separately evaluates unlevered cash flows using the project discount rate.
How is the Year 10 exit value calculated?
Choose remaining-life DCF or an EBITDA multiple for the equity exit. The remaining-life approach accounts for continued operations, degradation, augmentation, contract expiry and retirement. The football field provides valuation comparisons using editable assumptions.
Does the model optimize hourly battery dispatch?
No. It uses expected captured prices, cycling, availability and seasonality to build the financial forecast. Users should align those assumptions and any capacity revenue stacking with the relevant market, operating limits and contract rights.
Is the investment tax credit automatically included?
No. It is off by default and requires the user to enable it and confirm eligibility. The workbook models credit transfer proceeds, timing, tax-basis reduction and optional debt prepayments. It does not determine legal eligibility or calculate ITC recapture.
What do I receive, and how much does it cost?
The BESS Financial Model is a downloadable Excel workbook, available for a one-time payment of $85. Review the video and presentation above to see the model before purchasing. It is also included in the three bundles linked on this page.
Put the operating and investment decisions together
Build your battery storage financial plan.
Connect project capacity, revenue, debt and equity in one editable 10-year model. $85 / Excel download.
