Understanding the bitcoin ETF calculator — concept and principle
This calculator estimates what an investment in a spot bitcoin exchange-traded fund (ETF) would be worth at a bitcoin price you choose, after the fund's yearly fee. It compares the result with holding bitcoin directly, shows the fees paid and the bitcoin price needed to break even. Use it to test scenarios and to see how the expense ratio affects returns over time.
How it is calculated
- ETF value = amount × (bitcoin price later ÷ bitcoin price at purchase) × (1 − expense ratio)^years.
- Holding directly (no fund fee) = amount × price later ÷ price at purchase.
- Fund fees = direct value − ETF value.
- Break-even bitcoin price = purchase price ÷ (1 − expense ratio)^years.
- Bitcoin exposure = amount ÷ purchase price.
The fee is compounded yearly as an approximation of the daily accrual most funds use.
The principle
A spot bitcoin ETF holds actual bitcoin. Each share represents a fixed amount of bitcoin, and the sponsor's fee is paid by selling a little of the fund's bitcoin every day, so the bitcoin per share slowly shrinks. That is why the fee reduces your holding whether the price rises or falls. Over the period, your value follows bitcoin's price change multiplied by the share of holdings left after fees.
Worked example
Default inputs: $10,000 invested at $100,000 per bitcoin, test price $130,000, fee 0.25% a year, 2 years.
- Exposure bought: 10,000 ÷ 100,000 = 0.1 BTC.
- Price ratio: 130,000 ÷ 100,000 = 1.3; direct holding = $13,000.
- Fee factor: 0.9975² ≈ 0.995006.
- ETF value = 10,000 × 1.3 × 0.995006 ≈ $12,935.08; gain $2,935.08 (29.35%).
- Fees ≈ $64.92; break-even price = 100,000 ÷ 0.995006 ≈ $100,502.
| Bitcoin price when you buy | Value of the ETF holding |
|---|---|
| 25,000 | $51,740.33 |
| 50,000 | $25,870.16 |
| 75,000 | $17,246.78 |
| 100,000 | $12,935.08 |
| 125,000 | $10,348.07 |
| 150,000 | $8,623.39 |
| 200,000 | $6,467.54 |
How to read the result
The difference from direct holding is the cost of the fund's convenience: no wallet or exchange account, and the shares sit in a normal brokerage account. Over a few years the fee difference between funds is small compared with bitcoin's price swings, but it grows with time. The break-even price shows how much bitcoin must rise just to cover the fee.
Common mistakes
- Treating the scenario price as a forecast.
- Ignoring trading costs, bid-ask spreads and taxes, which are not included.
- Assuming the ETF price always equals its net asset value exactly.
- Forgetting that the fee is charged even when bitcoin falls.
Frequently asked questions
Does a spot bitcoin ETF hold real bitcoin?
Yes. A spot ETF holds bitcoin in custody, unlike a futures-based fund.
How is the ETF fee paid?
It is deducted from the fund's assets over time, which reduces the bitcoin behind each share.
Is an ETF cheaper than holding bitcoin directly?
Not in fees, but it avoids exchange and custody costs and the risk of losing your own keys.
Sources: Price-return arithmetic with an annual expense ratio deducted from fund assets (compounded yearly as an approximation)