How to Calculate BPS in Excel: A Beginner’s Guide

In the world of finance, BPS or basis points is a common term used to measure the percentage change in interest rates or bond yields. It is a unit of measurement used to represent a tiny percentage, usually 1/100th of a percentage point. In Excel, you can easily calculate BPS using a simple formula. In this article, we’ll guide you through the process of calculating BPS in Excel, step by step.

Understanding BPS in Finance

Basis points or BPS in Finance is a widely used term in the finance industry. It is used to measure the difference between two interest rates or bond yields. For instance, if the interest rate of a bond is 5% and it increases by 25 basis points, the new rate would be 5.25%. In other words, one basis point is equal to 0.01%, or 0.0001 in decimal form.

How to Calculate BPS in Excel

How to Calculate BPS in Excel: Step-by-Step Guide

Calculating BPS in Excel is an easy process that involves the following steps:

Step 1: Open a New Excel Sheet:

Open a new Excel sheet by clicking on the Excel icon on your desktop. You can also open it by clicking on the Start menu and searching for Excel.

Step 2: Enter the Formula for BPS Calculation:

To calculate BPS, you need to use the following formula:

=Bond_Yield_New – Bond_Yield_Old

Bond_Yield_Old is the original yield, and Bond_Yield_New is the new yield after a change in basis points.

Step 3: Enter the Required Data:

Enter the required data in the appropriate cells. For instance, if the original bond yield is 5%, and it increases by 25 basis points, you need to enter 0.05 in cell A1 and 0.0525 in cell A2.

Step 4: Get the BPS Result:

To get the BPS result, enter the formula in cell A3, i.e., =A2-A1. The result will be 0.0025 or 25 basis points.

Tips for Accurate BPS Calculation

Here are some tips to help you calculate BPS accurately in Excel:

  • Make sure you use the correct formula for BPS calculation
  • Double-check the data entered in each cell to ensure accuracy
  • Use the format cells option to set the number of decimal places for the result
  • Round off the BPS result to the nearest whole number for easy interpretation


What is the formula to calculate basis points in Excel?

The formula to calculate basis points in Excel is =Bond_Yield_New – Bond_Yield_Old.


In conclusion, calculating BPS in Excel is a simple process that can be done using the right formula and inputting the correct data. With the above steps, you should be able to calculate BPS in Excel without any difficulties. Remember to double-check your data and use the tips provided to get accurate results. Excel is a powerful tool that can help you with financial calculations, and knowing how to calculate BPS is a useful skill in the world of finance. We hope this guide has been helpful, and you can now confidently calculate BPS in Excel.