7. Excel For Finance Tips - What is a Basis Point ?
What is a Basis Point ?
A basis point is quite simply 0.01 of 1% So if an interest rate is 5.00% and it increases to 5.01%, that corresponds to 1 basis point increase. What is it used for ? Profit margins for fixed income products are measured in basis points.
Lets look at an example in Excel:
In this example, we have a 1 year loan of 100,000,000. The bank can borrow money at 5.00% and loans the money at 5.01% The profit on this trade is 10,000.
Download Spreadsheet to look at how a basis point can be represented in Excel
Training Video on: What is a Basis point ?
- Nick's blog
- Login or register to post comments
- 24143 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago