Bitcoin Stack & Borrowing Tracker FULL version

Bitcoin Stack & Borrowing Tracker

No wallet connection.

No exchange connection.

No API setup.

Manual Google Sheets tracker only.

A simple Google Sheets tracker for Bitcoin holders who want to track their Bitcoin accumulation, cost base, average buy price, current stack value, projection estimates, and Bitcoin-backed loan risk in one place.

This full version builds on the Free Bitcoin DCA Tracker by adding borrowing-risk tools, LVR stress testing, projection estimates, scenario planning, and a tax log.

The tracker is designed for long-term Bitcoin holders who want a clear manual system without connecting exchange APIs or relying on complicated portfolio apps.

Use one currency consistently throughout the tracker. For example: USD, AUD, EUR or your preferred local currency.

What’s included:

• Dashboard — view your Bitcoin stack, total invested, average buy price, current Bitcoin value, unrealised gain/loss, weekly DCA amount, projected annual DCA, loan snapshot, and projection estimator.
• Inputs tab — update Bitcoin price, weekly DCA amount, selected currency, loan interest rate, LVR limits, projection assumptions, and scenario settings.
• Bitcoin Purchase Log — record every Bitcoin purchase, including amount invested, Bitcoin bought, Bitcoin price, fees, exchange, and notes.
• Loan LVR Calculator — model Bitcoin-backed loan amount, collateral value, current LVR, interest cost, and risk status.
• Bitcoin Price Scenario Planner — stress test how your Bitcoin stack value, gain/loss, and loan LVR could change if Bitcoin rises or falls.
• Projection Estimator — estimate future Bitcoin stack value based on your current stack, weekly DCA amount, projection years, and assumed annual return.
• Tax Log — record transactions for accountant or tax software use.
• Instructions tab — simple guidance on how to use the tracker and understand LVR.

Useful for:

• Long-term Bitcoin holders
• Bitcoin DCA investors
• People tracking cost base and average buy price
• Users considering Bitcoin-backed borrowing
• Anyone wanting to understand LVR risk before using Bitcoin as collateral
• Bitcoin holders who prefer a simple manual tracker instead of exchange-connected apps

Important:

This is a Google Sheets template. After purchase, you will receive an access instructions PDF with the template link.

Open the template link, then go to File → Make a copy to save your own editable version to Google Drive.

Disclaimer:

This spreadsheet is an educational tracking tool only. It is not financial, tax, legal, borrowing, or credit advice. Bitcoin is volatile, and borrowing against Bitcoin carries risk. Always speak with a qualified professional before making investment, tax, or borrowing decisions.