How to Calculate Bitcoin Mining Profitability by Hand: The Exact Formula, Worked Examples, and a Sheets Template

If you want to know how to calculate bitcoin mining profitability, the shortest answer is this: subtract your daily power cost and pool fees from your daily gross Bitcoin revenue. The manual formula is Profit = (Your Hashrate ÷ Network Hashrate) × (Daily Block Rewards + Fees) × BTC Price − (Device Watts ÷ 1000 × 24 × Electricity $/kWh) − (Gross Revenue × Pool Fee %). I’ve run this math on everything from a single Antminer S9 in a basement to a 40-rig warehouse, and the numbers from a calculator rarely match reality unless you understand the variables underneath.

Why I Stopped Trusting Black-Box Mining Calculators

When I first plugged an Antminer S19 Pro into a web profitability tool in 2021, it promised $22.40 daily profit. The actual payout from my pool was $19.10. The gap wasn’t a bug; the tool had assumed a fixed difficulty and zero stale shares.

That early mistake taught me to build the equation myself. Most people don’t realize that online calculators smooth out variance and ignore the 1–3% efficiency loss from rejected shares, cooling overhead, and difficulty retargeting. If you’re sizing a real operation, you need the manual formula.

Two years later I helped a friend model a 10-rig garage setup in Colorado. He used a popular calculator that showed payback in 11 months. When I layered in the 15% HVAC penalty from summer heat and the utility’s tiered rate jumping to $0.14/kWh after 600 kWh, the payback stretched to 26 months. The calculator never asked those questions.

The thing nobody tells you about home mining is that the noise and heat force you to upgrade insulation or run dehumidifiers, both of which draw power the calculators omit. My own electric bill rose 8% beyond the miner’s nameplate during January because of space heating trade-offs.

The Core Bitcoin Mining Profitability Formula

At its heart, bitcoin mining profitability is a simple accounting identity. You earn a fraction of the network’s newly issued coins proportional to your hashrate, then pay for the energy and fees required to stay competitive.

Gross BTC Revenue Component

The first term is your share of the block subsidy and transaction fees. The network mines roughly 144 blocks per day. Since the April 2024 halving, each block pays 3.125 BTC plus fees, according to the Bitcoin developer guide. Daily issued supply is about 450 BTC before fees.

Your daily BTC mined = (Your Hashrate ÷ Network Hashrate) × 450 BTC. Network hashrate currently sits near 600 EH/s as reported by Blockchain.com. If you run 100 TH/s (0.0001 EH/s), your fraction is 1.67e-7, yielding about 0.000075 BTC/day before fees.

Rated hashrate on the box is not your real hashrate. Firmware limits, thermal throttling, and pool difficulty settings often cut actual submitted work by 2–5%. I always multiply rated TH/s by 0.95 to get a planning number.

Power Costs: The Silent Profit Killer

Energy is the only variable cost that scales linearly with uptime. Convert your miner’s wattage to kilowatts, multiply by 24 hours, then by your $/kWh rate from the U.S. Energy Information Administration or local utility. A 3250W S19 Pro at $0.08/kWh burns $6.24/day.

But wall-power is higher than device draw. PSU inefficiency (90–94%) adds 6–10%. Measure at the outlet; my Kill-A-Watt readings showed 3520W for a “3250W” rig. That extra 8% silently erased $0.50/day of alleged profit.

Solar or flare-gas setups change the equation entirely. I modeled a 5kW off-grid array where marginal electricity cost dropped to $0.02/kWh, but the capital recovery of panels must be amortized or the sheet lies about true profitability.

Pool Fees and Hidden Deductions

Most pools take 1–2.5% of gross payout. There are also occasional orphaned blocks and stale share penalties. I always add a 2% “reality buffer” on top of stated fees to mirror what I’ve observed across Slush Pool and Foundry.

Payment method matters. FPPS pays stable amounts; PPLNS can swing ±5% per week. If you calculate with FPPS assumptions but mine on PPLNS, your spreadsheet will lie.

Profit = (Your Hashrate ÷ Network Hashrate) × 450 × BTC Price − (Watts ÷ 1000 × 24 × kWh $) − (Gross BTC × Fee %)

How to Calculate Mining Profitability Formula Step by Step

Let’s walk a real example. Assume a 100 TH/s rig, network 600 EH/s, BTC price $60,000, power 3250W, electricity $0.08, pool fee 2%.

  • Fraction of network = 100 TH/s ÷ 600,000,000 TH/s = 0.0000001667.
  • Daily BTC = 0.0000001667 × 450 = 0.000075 BTC.
  • Gross USD = 0.000075 × $60,000 = $4.50.
  • Power cost = 3.25 kW × 24 × $0.08 = $6.24.
  • Pool fee = $4.50 × 0.02 = $0.09.
  • Net profit = $4.50 − $6.24 − $0.09 = −$1.83 (a loss).

This scenario shows why inefficient hardware at residential rates loses money. The thing nobody tells you about home mining is that electricity tier pricing often jumps after 500 kWh/month, silently pushing cost to $0.12/kWh.

Now an industrial counterpart: 1000 TH/s (ten S21 units at 100 TH/s each), same network, BTC $60k, but power 1.95 kW per 100 TH/s (19.5 J/TH) at $0.03/kWh, pool fee 1.5%.

  • Daily BTC = (1000 ÷ 600,000,000) × 450 = 0.00075 BTC.
  • Gross USD = $45.00.
  • Power = 19.5 kW × 24 × $0.03 = $14.04.
  • Fee = $0.68.
  • Net = $30.28/day, or $3.03 per 100 TH/s.

The contrast is the entire game: same hashrate, different economics purely from efficiency and power cost. When planning, I also deduct a hardware depreciation line of $0.40 per TH/s per month to reflect resale erosion.

Worked Example: Finding Your Breakeven Electricity Rate

Rearrange the formula to solve for kWh cost when net profit = 0. Using 100 TH/s, gross $4.50, fee $0.09, power 3.25 kW. Breakeven power cost = ($4.50 – $0.09) ÷ (3.25 × 24) = $4.41 ÷ 78 = $0.0565/kWh. So at $0.08 you lose; at $0.05 you earn $0.51/day. This breakeven math is something calculators hide behind a slider.

How Much Hashrate to Mine 1 BTC per Day?

A common question is how much hashrate to mine 1 BTC per day. The network currently issues ~450 BTC daily (subsidy only; fees add ~20–30 BTC some days). To capture 1 BTC, you need 1 ÷ 450 = 0.222% of total hashrate.

At 600 EH/s network, that equals 0.00222 × 600 = 1.333 EH/s, or 1,333,000 TH/s. To put that in perspective, a modern 100 TH/s machine would need 13,330 identical units running perfectly. Even a fleet of 10,000 rigs would take over a day to average 1 BTC due to variance.

If you include transaction fees, the required hashrate drops slightly to about 1.28 EH/s. But the practical answer is: only industrial farms with direct power purchase agreements approach this scale.

Historically the bar was lower. In January 2017 network hashrate was ~2.5 EH/s; mining 1 BTC/day then needed only ~55,000 TH/s—still 550 rigs. The trend shows soloists will never hit this threshold; pool participation is mandatory. Variance follows a Poisson distribution, so a small miner might wait months for a lucky share spike.

How Much Profit Do Bitcoin Miners Make?

The answer to “how much profit do bitcoin miners make?” depends entirely on efficiency and power cost. At $0.08/kWh and $60k BTC, a 100 TH/s rig loses ~$1.8/day as shown. But a 20 J/TH rig at $0.03/kWh flips the math to about $3/net daily per 100 TH/s.

Public mining companies report all-in costs including labor, insurance, and depreciation that can eat 30–50% of gross margin. The most people don’t realize is that hardware resale value drops 40% every halving cycle, turning “profitable” rigs into e-waste.

A realistic home miner in the U.S. today earns negative net unless they have sub-$0.06 power. In contrast, a warehouse in West Texas with flare-gas arbitrage can bank $2–4 per TH/s monthly. The spread is not skill; it’s location and capital.

To frame it differently, a 1 PH/s (1000 TH/s) efficient farm at $0.03/kWh nets ~$30/day before overhead. After staffing and rent, that may shrink to $12. Scale multiplies absolute dollars but not percentage margins.

How Long Does It Take to Mine $1 of Bitcoin?

To answer how long does it take to mine $1 of Bitcoin, separate gross revenue from net profit. Using our 100 TH/s example, daily gross USD is $4.50. Therefore $1 of raw BTC arrives in 24 ÷ 4.5 = 5.33 hours.

If you mean $1 of net profit after power and fees, the rig at $0.08/kWh never gets there—it loses money. At the efficient $0.03/kWh scenario, net $3.01/day means $1 profit accrues in 24 ÷ 3.01 = 7.97 hours. Always specify which $1 you mean; calculators blur this.

At a BTC price of $30k, gross for 100 TH/s falls to $2.25/day, so $1 gross takes 10.6 hours. Price volatility alone can double or halve your “time to $1” without any hardware change. If you reinvest mined BTC, compound timing shifts further.

Buying vs Mining: A Trade-Off You Must Model

Many newcomers ask whether they should mine or simply buy BTC. The formula answers it: if your net profit rate annualized is less than the expected appreciation minus hardware depreciation, buying wins. I model a 3-year rig life; if cumulative net < spot BTC accumulated via DCA at same power spend, I buy.

Mining gives you hashrate as a hedge and potential tax deferral on mined coins, but it demands operations. A passive investor with $5k is better off buying BTC unless they have free cooling and <$0.04 power.

A Practical Framework: The Mining Profitability Decision Matrix

I use a three-threshold matrix when advising miners. It beats a single calculator number because it exposes trade-offs.

Electricity $/kWh Hardware Efficiency (J/TH) BTC Price Assumption Verdict
≤0.04 ≤20 >$50k Profitable at scale
0.05–0.08 20–30 >$70k Marginal, hedge with HODL
≥0.09 >30 Any Do not mine; buy BTC

This matrix forces you to acknowledge that below 20 J/TH and cheap power, you survive difficulty bumps. Above 30 J/TH at residential rates, you are donating to the grid.

I add a fourth column in practice: “Difficulty trend.” If network hashrate grew >20% in 60 days, even green cells can turn red within a retarget.

Common Mistakes That Skew Your Calculations

The first error is using static difficulty. Difficulty retargets every 2016 blocks (about two weeks) as documented on the Bitcoin Wiki, and a 10% upward swing cuts revenue overnight.

Second, ignoring cooling. In a Texas summer, I measured a 14% increase in wall-power draw because exhaust fans fought ambient heat. Third, pool payment methods (FPPS vs PPLNS) change variance; PPLNS can pay 5% less in unlucky streaks.

  • Assuming nameplate hashrate instead of measured.
  • Forgetting PSU inefficiency (use 0.92 factor).
  • Omitting hardware failure rate; I budget 3% rigs down at any time.
  • Using spot BTC price instead of 30-day average for planning.
  • Ignoring tax: mined coins are income at fair value; sell later triggers capital gains.
  • Overlooking network fee volatility that can add or remove 10–20% revenue.

Build Your Own Calculator in Google Sheets (Free Template)

You don’t need a SaaS tool. Below is the exact Google Sheets layout I give to new miners. Copy these cells into A1:B11.

  • A1: Your Hashrate (TH/s) | B1: 100
  • A2: Network Hashrate (TH/s) | B2: 600000000
  • A3: Daily BTC Issued | B3: 450
  • A4: BTC Price | B4: 60000
  • A5: Watts | B5: 3250
  • A6: kWh Cost | B6: 0.08
  • A7: Pool Fee % | B7: 0.02
  • A8: Gross BTC = B1/B2*B3
  • A9: Gross USD = B8*B4
  • A10: Power Cost = B5/1000*24*B6
  • A11: Net Profit = B9 – B10 – B9*B7

To model difficulty changes, add A12: Difficulty Adjustment % | B12: 0.1, and change B2 to =600000000*(1+B12). This lets you stress-test a 10% rise. After you build this, cross-check with our Bitcoin Mining Profitability Calculator to confirm your logic. The sheet lets you flex difficulty and fee assumptions a calculator hides.

How to Adjust for Difficulty Retargeting in Your Model

Every 2016 blocks the protocol recalculates target based on prior hashrate. If hashrate rose, difficulty rises, reducing your fraction. I keep a rolling 30-day average of network hashrate rather than snapshot.

A simple adjustment: multiply your projected daily BTC by (Prior Network ÷ New Network). If network goes from 600 to 660 EH/s, your revenue falls to 90.9% of base. This is the single biggest quarterly risk to any mining business plan.

Monitoring and Recasting Your Numbers Monthly

The biggest amateur mistake is calculating once. I recast the sheet every difficulty epoch. A 10% difficulty rise can turn a $3/day rig into $1.20, and a BTC price drop from $60k to $50k cuts gross another 16%.

Set a calendar reminder to pull fresh network hashrate from Blockchain.com and update B2. If net profit goes negative two epochs in a row, power down or renegotiate power.

Advanced Edge Cases: Transaction Fees, Firmware, and Heat

Transaction fees recently swung from 0.1 BTC to over 2 BTC per block during ordinal minting spikes. If you calculate profitability assuming zero fees, you understate bull-market revenue by up to 20%. Conversely, a stagnant mempool means subsidy-only math.

Another edge case: older firmware may not support the latest stratum protocol, causing 2–4% stale rates. I’ve had to reflash rigs mid-cycle to recover that margin. These are not theoretical; they are monthly operational realities.

Heat reuse is a loophole some use: venting into a workshop reduces heating bills, effectively lowering electricity cost. But it only works in cold climates and adds HVAC complexity the formula can’t capture automatically.

Final Takeaways: Turning the Math Into Action

Learning how to calculate bitcoin mining profitability by hand replaces blind faith with control. You now have the formula, the 1 BTC/day hashrate benchmark, margin expectations, and the $1 timing split.

Start with the Sheets template, plug your real electricity tier, and stress-test against a 15% difficulty rise. If the numbers still work, you have a business case no glossy calculator can dispute.

Leave a Reply

Your email address will not be published. Required fields are marked *