While working in Excel, we often need to **create a common size balance sheet in Excel**. By definition, a **common size balance sheet **considers every **balance sheet** account as a percentage of **Total Assets**. In Excel, we can easily make a **common size balance sheet** by following some simple steps. Now, let’s explore this article and learn **3 **simple steps to do this.

**Table of Contents**hide

## Download Practice Workbook

## 3 Simple Steps to Create a Common Size Balance Sheet in Excel

In this section of the article, we will learn **3 **easy steps to **create a common size balance sheet in Excel**. In a **common size balance sheet**, both the numeric and relative percentage data with respect to the **Total Assets** are displayed.

Let’s say, we have the **Balance Sheet of ABC Store** as our dataset. Our goal is to **create a common size balance sheet** for this dataset. Now, let’s follow the steps mentioned below to do this.

Not to mention that we have used the *Microsoft Excel 365 *version for this article, you can use any other version according to your convenience.

### Step 01: Create a New Table

In the first step, we will create our output table where we will display the relative percentage.

- Firstly, create an identical table just like the dataset. Just keep the
**Amount**column blank as shown in the following picture.

**Read More: ****How to Make Balance Sheet Format in Excel for Individual**

### Step 02: Calculate Relative Percentage

Now, we will calculate the relative percentage with respect to the **Total Assets**. Let’s use the instructions outlined below.

- Firstly, enter the following formula in cell
**F6**.

`=C6/$C$14`

Here, cell **C6 **represents a cell of the **Category **column, and cell **$C$14** refers to the cell of **Total Assets**.

- Following that, press
**ENTER**.

Consequently, the relative percentage of **Cash **will be displayed in cell **F6 **as marked in the following image.

- Now, use the
**AutoFill**option of Excel to get the remaining outputs.

**Read More: ****How to Create Vertical Balance Sheet Format in Excel**

**Similar Readings**

**How to Make Projected Balance Sheet in Excel (with Quick Steps)****Make Stock Balance Sheet in Excel (with Quick Steps)****Net Worth Formula Balance Sheet in Excel (2 Suitable Examples)****How to Tally a Balance Sheet in Excel****Balance Sheet Format of a Company in Excel (Download Free Template)**

### Step 03: Format Output Table

As the relative percentages are not in a percentage format, we need to change the formatting of the cells to display percentage values. Let’s follow the procedure outlined below to do this

- Firstly, select the cells as marked in the image below.
- After that, go to the
**Home**tab from**Ribbon**. - Then, click on the
**Number Format**drop-down. - Now, select the
**Percentage**option from the drop-down.

Alternatively, you can just multiply **100 **to the inserted formula in Excel. So, the adjusted formula for the **F6 **will be-

`=C6/$C$14*100`

As a result, the cells of the output column will be formatted as percentage values as shown in the following picture.

- Following that, select the cells
**E14**and**F14**. - Next, go to the
**Home**tab from**Ribbon**. - Subsequently, click on the
**Fill Color**drop-down. - Then, choose your preferred color from the drop-down.

Consequently, you will have the **common size balance sheet **like in the following image.

*Note: **Here, the cell of the relative percentage of Total Assets works as an identifier. If its value is 100%, that will mean that we have done the calculations correctly.*

**Read More: ****Balance Sheet Format in Excel with Formulas (Create with Easy Steps)**

## How to Create Common Size Income Statement in Excel

In Excel, sometimes we need to** create a** **common size income statement in Excel**. It is almost similar to the previous method. But here we will calculate the relative percentage with respect to the **Total Revenue** instead of **Total Assets**.

Let’s say, we have the **Income Statement of XYZ Tech Store **for **4 **years. Our goal is to create a common size income statement with this dataset. Now, follow the steps outlined in the following section to do this.

__Steps:__

- Firstly, create a table as shown in the following image.

- Following that, enter the following formula in cell
**C16**.

`=C5/C$5`

Here, cell **C5 **represents the **Sales Revenue** for the year **2019**.

- After that, press
**ENTER**.

*Note:** Here, for the denominator, we only locked the row number (C$5). For this reason, we will be able to drag this formula both horizontally and vertically.*

As a result, you will have the relative percentage of **Sales Revenue** for the year **2019**.

- Now, drag the
**Fill Handle**in the row direction up to cell**F16**and you will get the following outputs.

- After that, by using the
**AutoFill**feature of Excel, you can get the remaining outputs as demonstrated in the following picture.

- Finally,
**follow the steps mentioned in Step 03 of the 1st method**to format the cells correctly.

After formatting the cells your output table will look like the following image.

**Read More: ****Income and Expenditure Account and Balance Sheet Format in Excel**

## Practice Section

In the **Excel Workbook**, we have provided a **Practice Section **on the right side of the worksheet. Please practice it by yourself.

## Conclusion

That’s all about today’s session. I strongly believe that this article was able to guide you to **create a common size balance sheet in Excel**. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. To learn more about Excel, you can visit our website, **ExcelDemy**, a one-stop Excel solution provider. Happy learning!

## Related Articles

**Create Projected Balance Sheet Format for Bank Loan in Excel****Revised Schedule 3 Balance Sheet Format in Excel with Formula****Balance Sheet Format for Construction Company in Excel****Debit Credit Balance Sheet with Excel Formula (3 Suitable Examples)****Schedule 6 Balance Sheet Format in Excel****How to Prepare Balance Sheet from Trial Balance in Excel****Balance Sheet Format in Excel for Proprietorship Business**