Interest Rate and Fee Schedules
This dataset provides comprehensive pricing schedules for financial products, including detailed interest rates, APY calculations, fee structures, tiered and promotional rates, and historical rate changes for both deposits and loans. It enables financial institutions, analysts, and regulators to track, compare, and audit product pricing and changes over time for compliance and strategic decision-making.
Sample rows
preview · 8 of 301 rows · all 19 columns| product_idstring | product_typestring | interest_ratefloat | fee_typestring | product_namestring | tier_min_balancefloat | tier_max_balancefloat | apyfloat | fee_amountfloat | fee_frequencystring | promotional_ratefloat | promotion_start_datedate | promotion_end_datedate | rate_effective_datedate | rate_expiry_datedate | rate_change_reasonstring | rate_history_idstring | is_activeboolean | currencystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| D-SAV-001-USD | deposit | 0.75 | monthly_maintenance | Premier Savings Account USD | 0 | 10000 | 0.76 | 8.5 | monthly | 1.25 | 2024-03-01 | 2024-06-01 | 2024-02-15 | blank | Seasonal campaign adjustment | RH-001-A | true | USD |
| L-MTG-002-USD | loan | 4.75 | origination | Home Mortgage Loan USD | 5000 | 350000 | blank | 950 | one-time | blank | blank | blank | 2024-01-20 | blank | Market rate update | RH-002-B | true | USD |
| C-CRD-003-USD | credit_card | 17.99 | annual | Platinum Credit Card USD | 0 | blank | 18.05 | 120 | annual | 0 | blank | blank | 2024-02-01 | blank | New product launch | RH-003-C | true | USD |
| D-CHK-004-EUR | deposit | 0.15 | blank | Euro Checking Account | 75000 | 800000 | 0.16 | blank | blank | 2.5 | 2024-03-10 | 2024-05-10 | 2024-02-20 | blank | European market update | RH-004-D | true | EUR |
| L-AUT-005-EUR | loan | 7.25 | prepayment | Auto Loan EUR | 1000 | 35000 | blank | 360 | one-time | 1.15 | 2024-04-01 | 2024-07-01 | 2024-03-05 | blank | Regulatory update | RH-005-E | true | EUR |
| D-SAV-006-GBP | deposit | 0.22 | monthly_maintenance | Premier Savings GBP | 120000 | 2500000 | 0.23 | 2.5 | monthly | blank | blank | blank | 2024-01-28 | blank | Currency adjustment | RH-006-F | true | GBP |
| O-BND-007-USD | other | 3.25 | other | Corporate Bond Fund USD | 2500 | 150000 | 3.28 | 90 | annual | blank | blank | blank | 2024-03-15 | blank | Bond market adjustment | RH-007-G | true | USD |
| C-CRD-008-USD | credit_card | 22.59 | late_payment | Cashback Credit Card USD | 0 | blank | 22.65 | 39 | per_transaction | 10 | 2024-04-05 | 2024-08-05 | 2024-03-20 | blank | Fee structure update | RH-008-H | true | USD |
| D-CHK-009-CHF | deposit | 0.09 | blank | Swiss Checking Account CHF | 50000 | 3000000 | 0.09 | blank | blank | 2.75 | 2024-02-18 | 2024-06-18 | 2024-02-10 | blank | Swiss market adjustment | RH-009-I | true | CHF |
| L-PRSN-010-USD | loan | 11.49 | origination | Personal Loan USD | 1500 | 25000 | blank | 425 | one-time | 2.99 | 2024-05-01 | 2024-08-01 | 2024-04-20 | blank | Loan product refresh | RH-010-J | true | USD |
| D-SAV-011-EUR | deposit | 0.33 | monthly_maintenance | Euro Savings Account | 250000 | 15000000 | 0.33 | 2 | monthly | blank | blank | blank | 2024-03-11 | blank | Quarterly review | RH-011-K | true | EUR |
| O-FND-012-EUR | other | 3.99 | other | Global Equity Fund EUR | 3500 | 950000 | 4.05 | 115 | annual | 9.25 | 2024-04-15 | 2024-10-15 | 2024-03-22 | blank | Fund performance adjustment | RH-012-L | true | EUR |
| C-CRD-013-USD | credit_card | 19.99 | annual | Travel Rewards Credit USD | 0 | blank | 20.05 | 89 | annual | 0 | blank | blank | 2024-03-01 | blank | Travel rewards update | RH-013-M | true | USD |
| L-MTG-014-USD | loan | 6.99 | origination | Jumbo Mortgage USD | 50000 | 2000000 | blank | 2200 | one-time | blank | blank | blank | 2024-02-11 | blank | High value segment update | RH-014-N | true | USD |
| D-SAV-015-USD | deposit | 0.55 | monthly_maintenance | Everyday Savings USD | 0 | 25000 | 0.56 | 7.1 | monthly | blank | blank | blank | 2024-03-19 | blank | Monthly update | RH-015-O | true | USD |
| O-CRP-016-USD | other | 7.25 | other | Crypto Investment USD | 100 | 500000 | 7.35 | 75 | one-time | 10 | 2024-05-10 | 2024-11-10 | 2024-04-15 | blank | Crypto market volatility | RH-016-P | true | USD |
| D-CHK-017-USD | deposit | 0.95 | blank | Smart Checking Account USD | 500 | 12000 | 0.96 | blank | blank | 1.75 | 2024-04-01 | 2024-07-01 | 2024-03-10 | blank | Introductory offer | RH-017-Q | true | USD |
| C-CRD-018-USD | credit_card | 16.5 | late_payment | Student Credit Card USD | 0 | blank | 16.52 | 25 | per_transaction | 0 | blank | blank | 2024-01-15 | blank | Student segment update | RH-018-R | true | USD |
| L-AUT-019-USD | loan | 5.45 | prepayment | Auto Loan Prime USD | 1000 | 35000 | blank | 320 | one-time | blank | blank | blank | 2024-03-12 | blank | Prime segment change | RH-019-S | true | USD |
| D-SAV-020-USD | deposit | 1.15 | monthly_maintenance | Family Savings USD | 2500 | 32000 | 1.16 | 9.9 | monthly | 2.75 | 2024-03-18 | 2024-06-18 | 2024-03-01 | blank | Family segment update | RH-020-T | true | USD |
What the 301 rows show
from the 301-row sampleCredit_
- 5.1median interest_
rate - 4fee frequencies
- 4currencies
- 950median tier_
min_ balance - 325,000median tier_
max_ balance - 2.8median apy
Median 5.1, from 0.03 to 61.0.
- string 8
- float 6
- date 4
- boolean 1
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
product_id | string | Unique identifier for the financial product (e.g., savings account, loan type)unique | D-SAV-001-USD |
product_name | string | Name of the financial product | Home Mortgage Loan USD |
product_type | string | Type of product (e.g., deposit, loan, credit card)deposit · loan · credit_card · other | deposit |
fee_type | string | Type of fee charged (e.g., monthly maintenance, overdraft, origination)6 values · optional | monthly_maintenance |
fee_frequency | string | Frequency at which the fee is charged (e.g., monthly, one-time, annual)monthly · one-time · annual · per_transaction · other · optional | monthly |
rate_change_reason | string | Reason for the rate change (e.g., market adjustment, regulatory change)optional | Market rate update |
rate_history_id | string | Unique identifier for the rate change history recordunique · optional | RH-001-A |
currency | string | Currency code for the product pricing (e.g., USD, EUR)4 currencies | USD |
| Numbers 6 columns | |||
tier_min_balance | float | Minimum balance required for this rate tier0 or more · optional | 0 |
tier_max_balance | float | Maximum balance allowed for this rate tier0 or more · optional | 10000 |
interest_rate | float | Annual interest rate for this product/tier (as a percentage, e.g., 2.5)0 to 100 | 0.75 |
apy | float | Annual Percentage Yield for this product/tier (as a percentage)0 to 100 · optional | 0.76 |
fee_amount | float | Amount of the fee charged0 or more · optional | 8.5 |
promotional_rate | float | Promotional interest rate offered for a limited period (percentage)0 to 100 · optional | 1.25 |
| Dates and times 4 columns | |||
promotion_start_date | date | Start date for the promotional rate periodoptional | 2024-03-01 |
promotion_end_date | date | End date for the promotional rate periodoptional | 2024-06-01 |
rate_effective_date | date | Date when the current rate became effective | 2024-02-15 |
rate_expiry_date | date | Date when the current rate expires (if applicable)optional | 2025-05-01 |
| True or false 1 column | |||
is_active | boolean | Indicates if this rate/fee schedule is currently active | true |
Use it for
A finance dashboard
Interest_
rate by product_ type and a breakdown of fee_ type. Excel, Power BI or Tableau. Why do the 61 credit_
card rows have a mean interest_ rate of 24.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Products301D-SAV-001-USD0.75depositL-MTG-002-USD4.75loanC-CRD-003-USD17.99credit_c…
A software demo
Believable products with product_
name, product_ type and tier_ min_ balance to fill a screen in front of a buyer.
blueprint · interest-rate-and-fee-schedules
Behind this dataset
Same schema. As many rows as you need.
These 301 rows came out of a blueprint — 19 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Product type: checking, savings, CD, money market, loan
- Interest rate tiers based on balance
- Annual Percentage Yield (APY) disclosed
- Fee schedule: monthly maintenance, overdraft, wire, ATM
- Fee waivers with balance or relationship
- Rate change notice period: 30 days
- Truth in Savings Act compliance
- Promotional rate expiration dates
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- interest-rate-and-fee-schedules