Crypto Retirement Corpus Planner
Excel Sheet 2 ModelLogic: Annual Expense × Years = Corpus; Corpus ÷ Expected Future Price = Tokens Needed
Actuarial Planning Method:
Retirement AssumptionsTarget Asset: SOL
$1.20M/yr
Monthly equivalent: $100.00K/mo30 Years
$667.00
$166.67
Required Retirement Corpus
$36.00M($36,000,000.00)
SOL Needed at Future Price ($667.00)53,973.01 SOLExcel Cell B10: =IFERROR(Corpus / Future_Price, 0)
Capital Needed Today (at $166.67)$9.00MExcel Cell B11: =Tokens_Needed × Today_Price
Calculation Logic & Disclosed Assumptions
Annual Expense ($1200000) × 30 Years = Required Corpus
- •Assumes constant undiscounted spending over the retirement duration.
- •Ignores annual inflation, capital gains taxation, and cryptocurrency price volatility.
- •Treat the result as a baseline planning estimate.
Sensitivity: SOL Needed by Future PriceExcel Sheet 2 Rows 14–20
Required token quantity across various expected terminal prices.
| Future SOL Price (USD) | SOL Needed | Current Value at Today's Price |
|---|---|---|
| $200.00 | 180,000.00 SOL | $30.00M |
| $400.00 | 90,000.00 SOL | $15.00M |
| $667.00 (Workbook Example) | 53,973.01 SOL | $9.00M |
| $1,000.00 | 36,000.00 SOL | $6.00M |
| $1,500.00 | 24,000.00 SOL | $4.00M |
Workbook Limitation Notice (Excel Cell A23): "This method ignores inflation, taxes, and price volatility. Treat the result as a rough planning estimate." Never present hypothetical crypto returns as guaranteed.