# How to Create a Material Balance Sheet in Excel – Easy Steps

## Overview of the Material Balance

The Material balance is quite common in Chemistry, especially in chemical reactions. It refers to the balance of materials or masses on both sides of a chemical reaction. It is also known as mass balance. A chemical reaction contains: the reactants (on the left) and the the products (on the right. The mass of these two sides needs to be equal in every chemical reaction.

Create a material balance sheet for the neutralization reaction of Hydrochloric Acid (HCl) and Calcium Hydroxide [Ca(OH)2].

### Step 1 – Select the Reaction to Create a Material Balance Sheet

Select a random chemical reaction. Here:

2HClÂ  +Â  Ca(OH)2Â  =Â  CaCl2Â  +Â  2H2O

2 mole HCl reacts with 1 mole Ca(OH)2 and produces 1 mole CaCl2 and 2 mole H2O.

### Step 2 – Find the Molecular Weight and Number of Moles

Calculate the molecular mass by using the atomic mass of each element and get the number of moles in the reaction. The coefficient of each material is considered to be the mole number of that material.

### Step 3 – Balance Calculation

Calculate the amount of materials to complete the reaction:

• Select D14 and enter the following formula.

`=D9*E9`

You will get the amount of HCl in grams.

• Press Enter and drag down the AutoFill Â to get the amount of other materials.

Read More: Rental Property Balance Sheet in Excel

### Step 4 – Generate the Material Balance Sheet Result

Calculate the mass of the Reactants Side and the mass of the Products Side.

• Select D19 and enter the following formula to get the mass of the Reactants.

`=D14+D15`

Calculate the total mass of the Products Side.

Mass of Reactant Side of the reaction = Mass of Product side of the Reaction

## Related Articles

<< Go Back to Balance Sheet | Finance Template | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan

Mehedi Hasan, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a profound passion for research and innovation, he actively engages with Excel. In his capacity, Mehedi not only adeptly tackles intricate challenges but also showcases enthusiasm and expertise in navigating tough situations with finesse, underscoring his unwavering dedication to consistently delivering exceptional and high-quality content. He... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF