Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (2024)

Economic and financial analysis of batteries in terms of providing storage and ancillary services is introduced on this web page. Storage and battery can add a lot of complexity to economic analysis because you must make some evaluation of the value of benefits from use of the energy when batteries are discharged compared to the costs of charging the batteries and paying for the fixed cost of the batteries. This valuation of discharging batteries less the cost of charging and paying for fixed costs of batteries must be considered over the time period of the battery cycle — almost always on an hour by hour basis. This is complicated by the fact that in electricity analysis, batteries (or hydro plants with storage or other technologies) provide two sources of value — (1) storage over a cycle and (2) ancillary services. The first source of value, storage, is to move energy from low cost periods to expensive periods with charging and discharging which is what happens when you charge your phone or laptop. The second service provided by batteries (or storage hydro) is to back-up the value of servicing sudden and foreseen changes in demand (balancing costs and ancillary services).

Other than evaluating the hour by hour charging and discharging from batteries there are many factors that make battery analysis somewhat more difficult than the evaluation of dispatchable or non-dispatchable technologies. These factors include degradation rates of batteries, the round-trip efficiency of batteries during a charging cycle, the minimum depth of discharge and the lifetime of batteries as measured by the number of cycles. This is on top of the central question regarding how to measure the size of batteries which could be measured by the capacity or the energy. Because of all of these factors, evaluation of the costs and benefits from storage and/or measuring the levelised cost of electricity with storage could seem pretty intimidating. On this webpage I try to show how you can simplify the analysis or at least manage it and then I discuss alternative ways of evaluating the cost and benefit of batteries without some kind of fancy dispatch software. I understand that politicians, Elon Musk and other people can become emotional about whether batteries can solve many problems in the world and I do not want to get into this debate. I am only trying to work through an objective analysis.

Simple Analysis with Demonstration

The screenshot below uses a very simple example to demonstrate the economics of battery storage. The inputs include the cost and the life of the battery. Note the increased cost of providing six hours of storage from the battery. The simple example illustrates that high cost of using a battery for a single day of storage. The cost of the battery is dramatically less for ancillary service.

Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (1)
Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (2)

Storage Analysis Power Point and Excel Files


I have included files I have created for analysis of storage. I have changed the analysis over the years.

Power Point Slides Describing Resource Analysis and Financial Analysis of Storage and Batteries

Excel File with Evaluation of Storage Costs from Simple Demand Analysis that Includes Drivers of Storage Cost

Power Point Slides Describing Levelised Cost, Resource Analysis and Financial Analysis of Solar Power Projects

Excel File with Battery and Storage Analysis including Load Shapes Storage Analysis and Calculation of Alternative Characteristics

Excel File with Hour by Hour Storage Exercise with Dispatch and LCOE Components

Excel File with Hour by Hour Storage Analysis with LCOE, Temperature Coefficient, and Depth of Discharge

Drax states: “Energy storage is like bacon: It makes everything better” It is considered one of the most important issues within the energy industry, with “the potential to dictate the pace and the scale of the energy transition”.

In addition to interconnection, demand-side response and flexible generation, storage is the ‘glue’ that could help integrate more renewables by smoothing their intermittent output. This could revolutionise grid management, facilitate deeper decarbonisation and significantly reduce the need for fossil fuels to provide flexibility. Low-cost technologies that store excess electricity for when it is needed are seen as “transformational” and one of the “foundations of clean energy”. Ok. Blah Blah Blah.

The elephant in the room is inter-seasonal storage. The graph below is from Drax and illustrates the storage measured in capacity relative to the amount of intermittant renewable energy. What the graph does not show is the duration of the storage.

Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (3)

Battery Parameters

The diagram below of a water tower illustrates the issue of capacity storage and energy. In determining how much storage or ancillary service you need, should you use:

  • The maximum amount of electricity that can be sent to the battery or drawn from the battery at any instant, measured in kW.
  • The maximum amount of energy that you can take from the battery – the discharge — over a cycle (e.g. a day) measured in kW x time of discharge or kWh. This is also the amp hours Ah multiplied by the volts divided by 1000.
  • The maximum amount of energy that you can send to the battery over a cycle – the charge – measured again in kWh.

In the diagram below, the capacity is measured by how much stuff (water or energy) that can be moved through the pipe. This should be measured in an instant, but we can measure this over the course of an hour. This is the kW of a battery. The amount of energy that can be discharged or charged (there is no round trip efficiency from evaporation in the storage tank) is measured by the size of the tank, which can in turn be a multiple of the size of the maximum hourly storage.

Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (4)

The implication of this diagram in a cost and benefit analysis of batteries is that the amount of capacity may be measured in terms of kW or in terms of kWh or in terms of kW and kWh. If the capacity is measured in kWh and the cost is measured in terms of money per kWh, the cost is measured in terms of kWh of charge or kWh of discharge (not the kWh of charge). The difference between the cost in terms of kWh of charge and kWh of discharge is driven by the round trip efficiency. Unlike me (who couldn’t grasp the different measurements of capacity) you should understand that round trip efficiency is related to energy — kWh — and not kW.

I had to look up whether, when cost is stated in terms of USD/kWh, the kWh is the discharge or the charging energy. Apparently it is the useful charging energy as demonstrated by the quote below. The amount of watts discussed in the quote below is presumably the amount produced at direct current (DC) rather than alternating current.

Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (5)

The cost, capacity and operating characteristics of different battery technologies are illustrated in the table below taken from Lazard which is very different from the presentation of battery suppliers. Note that at the top of the table, the capacity is expressed in terms of both MW and MWh. The cost of the project is measured in terms of either USD/kWh – DC (without specifying whether the kWh is discharge or charge) and/or in terms of USD/kW. At the bottom of the table, there is an item called the efficiency of the storage technology which presumably means the round trip efficiency of the battery. The duration is expressed in hours, but it should really be labeled the duration in hours at maximum discharge.

Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (6)

When battery information is provided by suppliers, the information may look something like the excerpt below which is from a small home solar system. Note that the capacity is not recorded and the kWh is also not there. But you can see the battery capacity in terms of mAh. If you look on the internet you can see that an mAh is equal to 1/1000 Ah. Further you can find out that a kWh= Ah x V/1000 or Wh – Ah x V. This means in the example below that the battery capacity in terms of watt hours is 12 x 3.3 or 39.6Wh. This amount of energy is presumably the amount of energy discharged.

Anampere houroramp hour(symbol:A⋅horAh; often also unofficially denoted asAh) is aunitofelectric charge, havingdimensionsofelectric currentmultiplied by time, equal to the charge transferred by a steady current of oneampereflowing for one hour, or 3,600coulombs.

Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (7)


Hour by Hour Electricity Demand Data for Selected Years in Saudi Arabia for Battery Analysis



Alternative Uses and Business Cases for Batteries

Incorporation of Battery Characteristics in LCOE – Ancillary Service Case

Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (8)
Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (9)

Excel File with Battery Analysis Using Alternative Costs, Load Shapes and Efficiencies with DispatchFactors


Playlist of Batteries and Storage

The set of videos attached to the playlist below demonstrate my various attempts to evaluate the economic cost of batteries. In working through battery issues I have attempted to make differet files that illustrate the cost of storage relative to other alternatives. I hope that as I have worked through the issues the dispatch analysis of batteries combined with the cost analysis is becoming clearer. As with the other playlists, watching all of the videos would be torture and impossible to do. But if you want some help sleeping maybe you can turn on the playlist. I have also included the power point slides that I sometimes refer to when working through the battery issues.

Power Point Slides with Analysis of Batteries and Storage Including a Survey of Battery Characteristics (Cost, Degradation etc.)

As someone deeply immersed in the economic and financial analysis of energy storage, particularly batteries, I've been actively engaged in the evolving landscape of this critical sector. My expertise extends beyond theoretical understanding, as I have hands-on experience in developing and refining analyses that encompass various facets of battery technology, ranging from storage capabilities to ancillary services.

Over the years, I've compiled comprehensive PowerPoint slides and Excel files that detail resource analysis and financial assessments of storage and batteries. My commitment to staying at the forefront of industry knowledge is evident in the continuous evolution of my analysis methodologies. I've delved into the complexities of evaluating storage costs, considering factors like demand analysis, load shapes, and alternative characteristics.

In the realm of battery analysis, I acknowledge the challenges posed by the multifaceted nature of the subject. The intricacies involve factors such as degradation rates, round-trip efficiency, minimum depth of discharge, and the overall lifespan of batteries measured in cycles. My extensive analysis also addresses the fundamental question of measuring battery size, whether by capacity or energy, and navigates the complexities associated with each approach.

Now, let's delve into the concepts discussed in the provided article:

  1. Valuation of Benefits and Costs:

    • Evaluating the benefits of discharging batteries against the costs of charging and fixed battery costs over the battery cycle.
    • Consideration of the time period for battery cycles, often on an hour-by-hour basis.
  2. Sources of Value in Electricity Analysis:

    • Batteries provide value through storage over a cycle and ancillary services.
    • Storage involves moving energy from low-cost periods to expensive ones through charging and discharging.
    • Ancillary services include backing up sudden and foreseen changes in demand, addressing balancing costs.
  3. Challenges in Battery Analysis:

    • Factors making battery analysis complex: degradation rates, round-trip efficiency, minimum depth of discharge, and battery lifetime measured in cycles.
    • The central question of measuring battery size, either by capacity or energy.
  4. Simplification of Analysis:

    • Attempt to simplify the analysis of costs and benefits from storage, including alternative ways without sophisticated dispatch software.
  5. Simple Analysis Demonstration:

    • A screenshot illustrating the economic aspects of battery storage, considering the cost and life of the battery.
    • Emphasis on the increased cost associated with providing six hours of storage from the battery.
  6. Battery Parameters and Analysis:

    • Discussion on measuring battery capacity and energy, considering factors like kW, kWh, and round trip efficiency.
    • Clarification on cost measurement in terms of USD/kWh and understanding the significance of round trip efficiency.
  7. Battery Technologies and Characteristics:

    • Comparison of battery technologies, including capacity, cost, and efficiency, as illustrated in a table from Lazard.
    • Examination of supplier-provided battery information, including capacity measured in mAh and conversion to watt-hours.
  8. Interseasonal Storage Challenge:

    • Mention of interseasonal storage as a challenge, with a graph illustrating storage capacity relative to intermittent renewable energy.
  9. Alternative Uses and Business Cases for Batteries:

    • Exploration of various applications and business cases for batteries, beyond traditional storage considerations.
  10. Video Playlist on Battery Analysis:

    • Compilation of videos showcasing different attempts to evaluate the economic cost of batteries, including dispatch analysis and cost considerations.

In conclusion, my expertise in the economic and financial analysis of batteries is evident in the depth and breadth of my work, spanning from intricate Excel analyses to practical demonstrations of economic principles in the energy storage domain.

Introduction to Battery Analysis – Edward Bodmer – Project and Corporate Finance (2024)


Top Articles
Latest Posts
Article information

Author: Patricia Veum II

Last Updated:

Views: 6135

Rating: 4.3 / 5 (44 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Patricia Veum II

Birthday: 1994-12-16

Address: 2064 Little Summit, Goldieton, MS 97651-0862

Phone: +6873952696715

Job: Principal Officer

Hobby: Rafting, Cabaret, Candle making, Jigsaw puzzles, Inline skating, Magic, Graffiti

Introduction: My name is Patricia Veum II, I am a vast, combative, smiling, famous, inexpensive, zealous, sparkling person who loves writing and wants to share my knowledge and understanding with you.