Building Your First XRP Model

Before writing a single formula, establish design principles that will guide construction:

Transparency: Every calculation should be visible and traceable. No hidden formulas, no black boxes. Anyone reviewing your model should be able to follow the logic from inputs to outputs.

Flexibility: Assumptions will change. New information will arrive. The model should accommodate updates without requiring reconstruction. Keep adjustable parameters in one place.

Modularity: Separate concerns cleanly. Inputs don't mix with calculations. Calculations don't mix with outputs. Each section has a clear purpose.

Documentation: Your model should explain itself. Sources should be cited. Assumptions should be justified. Version history should be tracked.

Organize your model into distinct sections:

Sheet 1: Inputs & Assumptions

This sheet contains all adjustable parameters. Anyone wanting to understand or modify the model starts here. Include current market data (price, supply, market cap), Ripple-specific data (ODL volume, escrow), valuation parameters (discount rates, growth rates), and source citations with dates.

Sheet 2: Scenario Definitions

Define your bear, base, and bull cases explicitly. Each scenario should specify ODL growth assumptions, speculation premium assumptions, regulatory outcomes, time horizon, and other key variables.

Sheet 3: Calculations

This is where the math happens. Show all intermediate steps. Don't hide complexity—display it clearly. Include ODL projections, working capital requirements, total value calculations, and present value adjustments.

Sheet 4: Outputs & Summary

Present results clearly. Key findings should be immediately visible. Include scenario comparison tables, sensitivity analysis, and visualizations where helpful.

Sheet 5: Data Archive

Maintain historical data, track version changes, and record past assumptions. This enables learning from your model's track record.

Your XRP model needs several categories of inputs:

• XRP price

• Circulating supply

• Total supply

• Market capitalization

• Date of data

• Current annual ODL volume

• Historical growth rates

• Corridor information

• Ripple partnership data

• Current speculation premium estimate

• Premium scenarios (bull/base/bear)

• Comparable asset premiums

• Required return / discount rate

• Time horizon

• Risk adjustments

---

Create your input section with clear organization:

INPUTS & ASSUMPTIONS
====================
Model Version: 1.0
Last Updated: [DATE]

MARKET DATA (as of [DATE])
──────────────────────────────────────────
Current XRP Price:           $0.50
Circulating Supply:          57,000,000,000
Total Supply:                100,000,000,000
Current Market Cap:          $28,500,000,000
Source: CoinGecko

ODL DATA (Source: Ripple Q3 2024 Report)
──────────────────────────────────────────
Current Annual ODL Volume:   $8,000,000,000
Current Quarterly ODL:       $2,000,000,000
YoY Growth Rate:             ~50%
Active Corridors:            20+

ESCROW DATA (Source: XRPScan)
──────────────────────────────────────────
Escrow Balance:              40,000,000,000
Monthly Release Cap:         1,000,000,000
Avg Monthly Net Release:     200,000,000
Annual Net Release:          2,400,000,000

VALUATION PARAMETERS
──────────────────────────────────────────
Discount Rate:               30%
Time Horizon:                5 years
Working Capital Buffer:      1.5×

Every number should have a source. Every source should have a date.

Define three scenarios that span reasonable outcomes:

Bear Case (Pessimistic but Plausible)

ODL growth stalls at 10% annually due to competition from stablecoins and slow bank adoption. Regulatory environment remains uncertain. Speculation premium contracts as enthusiasm fades. This isn't a catastrophic scenario—ODL still grows—but it represents disappointment relative to current expectations.

Base Case (Most Likely)

ODL grows at 40% annually, roughly in line with recent trends. Regulatory clarity improves but isn't fully resolved. Speculation premium remains elevated but doesn't expand dramatically. This represents continuation of current trajectory.

Bull Case (Optimistic but Achievable)

ODL achieves 100% annual growth as major banks adopt and new corridors open rapidly. Regulatory clarity arrives with ETF approval. Speculation premium expands on positive sentiment. This is optimistic but within the realm of possibility.

SCENARIO DEFINITIONS
====================

BEAR        BASE        BULL
─────────────────────────────────────────────────────────
ODL Annual Growth         10%         40%         100%
Years to Project          5           5           5
Regulatory Outcome        Unclear     Favorable   Very Good
ETF Approved              No          Yes         Yes + Flows
Speculation Premium       5×          10×         20×
Working Capital Days      2           3           5
XRPL Ecosystem Growth     10%         25%         50%
─────────────────────────────────────────────────────────

ODL Volume Projection:

Using compound growth formula: Future Volume = Current Volume × (1 + Growth Rate)^Years

For each scenario, project ODL volume over your time horizon:

• Year 0: $8.0B

• Year 1: $8.8B

• Year 2: $9.7B

• Year 3: $10.6B

• Year 4: $11.7B

• Year 5: $12.9B

• Year 0: $8.0B

• Year 1: $11.2B

• Year 2: $15.7B

• Year 3: $22.0B

• Year 4: $30.7B

• Year 5: $53.8B

• Year 0: $8.0B

• Year 1: $16.0B

• Year 2: $32.0B

• Year 3: $64.0B

• Year 4: $128.0B

• Year 5: $256.0B

The range is enormous—$12.9B to $256B by Year 5. This reflects genuine uncertainty.

Working Capital Requirement:

ODL requires XRP to be held during settlement. Calculate the working capital needed:

Formula: Required XRP Value = (Daily Volume × Hold Days × Buffer)

Convert annual to daily: Daily Volume = Annual Volume / 365

• Daily Volume = $12.9B / 365 = $35.3M

• Required Value = $35.3M × 2 days × 1.5 buffer = $106M

• Daily Volume = $53.8B / 365 = $147.4M

• Required Value = $147.4M × 3 days × 1.5 buffer = $663M

• Daily Volume = $256B / 365 = $701M

• Required Value = $701M × 5 days × 1.5 buffer = $5.26B

Adding Non-ODL Utility:

XRP has value beyond ODL. Include XRPL ecosystem utility:

• Current estimate: $500M

• Bear growth (10%/year): $805M by Year 5

• Base growth (25%/year): $1.53B by Year 5

• Bull growth (50%/year): $3.80B by Year 5

• Current estimate: $200M

• Bear: $322M by Year 5

• Base: $610M by Year 5

• Bull: $1.52B by Year 5

Total Utility Value:

Bear Case Year 5: $106M + $805M + $322M = $1.23B
Base Case Year 5: $663M + $1,530M + $610M = $2.80B
Bull Case Year 5: $5,260M + $3,800M + $1,520M = $10.58B

Utility alone doesn't explain crypto prices. Add speculation:

Formula: Total Value = Utility Value × (1 + Speculation Premium)

Or equivalently with multiplier: Total Value = Utility Value × Multiplier

Bear Case (5× multiplier): $1.23B × 5 = $6.15B
Base Case (10× multiplier): $2.80B × 10 = $28.0B
Bull Case (20× multiplier): $10.58B × 20 = $211.6B

These are Year 5 values. Discount to present value:

Formula: PV = FV / (1 + discount rate)^years

At 30% discount rate over 5 years:
Discount Factor = 1 / (1.30)^5 = 0.269

• Bear: $6.15B × 0.269 = $1.65B → $0.029 per XRP
• Base: $28.0B × 0.269 = $7.53B → $0.132 per XRP
• Bull: $211.6B × 0.269 = $56.9B → $0.998 per XRP

Current price: $0.50

• Bear case: Current price is 17× model value
• Base case: Current price is 3.8× model value
• Bull case: Current price is below model value

---

Test how outputs change with single variable changes:

Sensitivity to ODL Growth Rate (Base assumptions otherwise):

Growth Rate    Year 5 ODL    Total Value (PV)    Price
────────────────────────────────────────────────────────
10%            $12.9B        $1.65B              $0.03
20%            $19.9B        $2.41B              $0.04
30%            $29.6B        $3.84B              $0.07
40%            $53.8B        $7.53B              $0.13
50%            $60.8B        $8.76B              $0.15
75%            $126B         $19.1B              $0.34
100%           $256B         $56.9B              $1.00
────────────────────────────────────────────────────────

Finding: ODL growth rate is the most sensitive variable. The difference between 20% and 100% growth is 25× in implied price.

Cross-tabulate two key variables:

ODL Growth vs. Speculation Premium:

                    SPECULATION PREMIUM (Multiplier)
                    5×      10×     15×     20×
ODL GROWTH  ─────────────────────────────────────────
   20%              $0.02   $0.04   $0.06   $0.09
   40%              $0.07   $0.13   $0.20   $0.26
   60%              $0.14   $0.28   $0.42   $0.56
   80%              $0.27   $0.54   $0.81   $1.08
  100%              $0.50   $1.00   $1.50   $2.00
─────────────────────────────────────────────────────

Discount Rate    Base Case PV    Implied Price
────────────────────────────────────────────────
15%              $13.9B          $0.24
20%              $11.3B          $0.20
25%              $9.2B           $0.16
30%              $7.5B           $0.13
35%              $6.2B           $0.11
40%              $5.2B           $0.09
────────────────────────────────────────────────

Finding: Discount rate has significant impact. Lower required returns substantially increase fair value.

---

Create a clear summary for quick reference:

XRP VALUATION MODEL - SUMMARY DASHBOARD
=======================================
Model Version: 1.0
Analysis Date: November 2024
Current XRP Price: $0.50

SCENARIO VALUATIONS
                    Year 5 Value    Present Value    Price/XRP    vs Current
─────────────────────────────────────────────────────────────────────────────
Bear Case           $6.2B           $1.7B            $0.03        -94%
Base Case           $28.0B          $7.5B            $0.13        -74%
Bull Case           $211.6B         $56.9B           $1.00        +100%
─────────────────────────────────────────────────────────────────────────────

PROBABILITY-WEIGHTED EXPECTED VALUE
Bear (25% probability):    0.25 × $0.03 = $0.008
Base (50% probability):    0.50 × $0.13 = $0.065
Bull (25% probability):    0.25 × $1.00 = $0.250
─────────────────────────────────────────────────
Expected Price:                         $0.32

ASSESSMENT
Current Price:        $0.50
Expected Value:       $0.32
Premium/(Discount):   56% premium to expected value

KEY DRIVERS
Most sensitive: ODL growth rate
Second: Speculation premium multiplier
Third: Discount rate

1. Utility alone doesn't justify current price.

Even in the bull case, pure utility value ($10.6B Year 5) is below current market cap ($28.5B). Speculation premium is essential to bridge the gap.

2. ODL growth is the swing variable.

The model is most sensitive to ODL growth assumptions. If you believe 100% growth is achievable, the model supports current price. If you expect 20-40% growth, the model suggests overvaluation.

3. Current price implies optimism.

• Much higher ODL growth than base case, OR
• Much higher speculation premium, OR
• Lower discount rate, OR
• Value sources not captured in model

4. Uncertainty is enormous.

Bear to bull ranges from $0.03 to $1.00—a 33× spread. This reflects genuine uncertainty about XRP's future, not model error.

Be explicit about what the model doesn't capture:

• Tail events (regulatory destruction, CBDC adoption)

• Market cycle effects

• Competition dynamics over time

• Optionality value

• Non-quantifiable factors (brand, community)

• Linear growth rates (reality is lumpy)

• Static speculation premium (varies with sentiment)

• Single discount rate (risk changes over time)

---

Weekly: Update price data, check for major news

Monthly: Refresh on-chain metrics, update escrow data

Quarterly: Full model review when Ripple reports ODL data, adjust growth assumptions if warranted

Ad Hoc: Major news events, regulatory developments, significant market moves

---

✅ Model produces quantified outputs - We can calculate implied values from explicit assumptions

✅ Sensitivity analysis reveals key drivers - ODL growth matters most

✅ Multiple scenarios show the range - $0.03 to $1.00 spans reasonable outcomes

✅ Current price requires specific assumptions - We can reverse-engineer what must be true

⚠️ Growth rate projections - We're guessing ODL's future trajectory

⚠️ Appropriate speculation premium - Is 10× right? 5×? 20×?

⚠️ Discount rate selection - 30% is debatable

⚠️ Non-ODL value components - Rough estimates

📌 Treating outputs as predictions - This is a framework, not a crystal ball

📌 Single-point estimates - Always use ranges

📌 Overconfidence in precision - $0.132 doesn't mean not $0.10 or $0.18

📌 Ignoring qualitative factors - Models miss important reality

This model provides structured thinking about XRP value. The base case ($0.13) is below current price ($0.50), suggesting either the market is wrong or the model misses something. The key variable is ODL growth—bulls need 75%+ annual growth for current price to make sense. Use this as a framework for evaluation, not as investment advice.

---

Assignment: Build your own XRP valuation model following the architecture in this lesson.

Requirements:

• All key inputs organized clearly

• Sources cited for all data

• Current as of your build date

• Bear, Base, Bull definitions

• All assumptions explicit and justified

• Reasonable but distinct cases

• ODL projections for all scenarios

• Working capital calculations

• Non-ODL utility estimates

• Speculation premium application

• Present value adjustments

• At least two sensitivity tables

• Key drivers identified

• Findings documented

• Clear output presentation

• Probability-weighted expected value

• Assessment vs. current price

• Key insights highlighted

• Model structure and clarity (25%)

• Calculation accuracy (25%)

• Sensitivity analysis quality (20%)

• Documentation completeness (15%)

• Interpretation quality (15%)

Time Investment: 4-5 hours

---

For Next Lesson:
We'll dive deeper into monetary models using the equation of exchange (MV=PQ) in Lesson 7: Monetary Models - The Equation of Exchange.

---

End of Lesson 6

Total words: ~6,200
Estimated completion time: 60 minutes reading + 4-5 hours for deliverable