Kalkulator Poin Basis Logo
Kalkulator Poin Basis

How to Calculate Basis Points: Formulas, Examples & Excel Guide

Core Rule: 1 basis point = 0.01% = 0.0001. Everything else flows from this.

The Core Formula for Basis Points

Two master formulas cover most situations:

  • BPS from two rates: BPS = (Rate A − Rate B) × 100 (use percentage values, e.g. 6.50 and 6.25)
  • BPS from a single percentage: BPS = Percentage × 100 (e.g. 0.25% × 100 = 25 BPS)

How to Calculate Basis Points from a Percentage

Formula: BPS = Percentage (%) × 100  |  Reverse: Percentage = BPS ÷ 100

Percentage Calculation Basis Points
0.01%0.01 × 1001 BPS
0.25%0.25 × 10025 BPS
0.50%0.50 × 10050 BPS
1.00%1.00 × 100100 BPS
2.50%2.50 × 100250 BPS

How to Calculate Basis Points Between Two Rates

Formula: BPS = (Rate A − Rate B) × 100

Worked Examples:

  • Mortgage negotiation: (7.00 − 6.50) × 100 = 50 BPS reduction
  • Fed rate hike: (5.50 − 5.25) × 100 = 25 BPS increase
  • Bond yield spread: (5.85 − 4.20) × 100 = 165 BPS spread

How to Calculate Basis Point Value (Dollar Impact)

Formula: Dollar Impact = Loan Amount × (BPS ÷ 10,000)

Example — $300,000 mortgage, 25 BPS change: $300,000 × (25 ÷ 10,000) = $750 per year (~$62.50/month).

BPS Change % Change Annual Impact ($300k loan) Monthly Impact
10 BPS0.10%$300/yr$25/mo
25 BPS0.25%$750/yr$62.50/mo
50 BPS0.50%$1,500/yr$125/mo
100 BPS1.00%$3,000/yr$250/mo

How to Calculate Basis Points in Excel

BPS between two rates (as decimals)

=(B2-C2)*10000

Convert percentage to BPS

=B3*10000

Convert BPS to percentage

=B4/10000

Dollar impact of BPS on a loan

=B5*(C5/10000)

B5 = loan amount, C5 = BPS value

Quick Reference: All BPS Formulas

What to Calculate Formula Example
BPS from two rates(Rate A − Rate B) × 100(6.50 − 6.25) × 100 = 25 BPS
BPS from a percentage% × 1000.75% × 100 = 75 BPS
Percentage from BPSBPS ÷ 10050 BPS ÷ 100 = 0.50%
Dollar impact on loanLoan × (BPS ÷ 10,000)$300k × (25÷10,000) = $750/yr
Commission in dollarsValue × (BPS ÷ 10,000)$400k × (75÷10,000) = $3,000
Spread between two rates(High − Low) × 100(6.80−4.25) × 100 = 255 BPS
Try Our Basis Point Calculators →

Pertanyaan yang Sering Diajukan

How do you calculate basis points from a percentage?
Multiply the percentage by 100. For example, 0.25% × 100 = 25 basis points. In reverse, divide basis points by 100 to get a percentage: 75 BPS ÷ 100 = 0.75%.
How do you calculate basis points between two interest rates?
Subtract the smaller rate from the larger rate, then multiply by 100. Example: (6.50% − 6.25%) × 100 = 25 basis points.
How do you calculate 25 basis points?
25 basis points equals 0.25%. To find the dollar value on a loan, multiply the loan amount by 0.0025. On a $200,000 loan: $200,000 × 0.0025 = $500 per year.
How do I calculate basis points to dollars?
Use: Dollar Impact = Loan Amount × (BPS ÷ 10,000). For example, 100 basis points on a $500,000 loan = $500,000 × (100 ÷ 10,000) = $5,000 per year.
What is the Excel formula for basis points?
To find BPS between two rates (as decimals): =(A1−B1)×10000. To convert a percentage to BPS: =A1×10000. To convert BPS to percentage: =A1/10000.