Skip to content

Latest commit

 

History

History
175 lines (131 loc) · 9.76 KB

File metadata and controls

175 lines (131 loc) · 9.76 KB

Financial Modeling & Cash Flow Projections

Document: LAMG-FIN-001 Prepared by: Asset Management Analyst, Lunar Asset Management Group Date: 14 August 2026 Classification: Internal — Portfolio Management Model Version: v3.2 (Lunar Cycle Adjusted)


1. Executive Summary

This document presents the financial modeling framework and cash flow projections for the Moon portfolio. The model uses a discounted cash flow (DCF) methodology adapted for an asset class with a ~4.51 billion year operating history and zero historical revenue.

The central modeling challenge is straightforward: the Moon has never generated a dollar of income. Projecting future cash flows therefore requires assumptions that range from "optimistic" to "speculative" to "violates thermodynamics." We have labeled each assumption with a confidence tier.

Important

All projected cash flows are based on hypothetical future scenarios including Helium-3 fusion commercialization, lunar water ice extraction for in-situ resource utilization (ISRU), and near-side solar energy export. None of these revenue streams currently exist. The model is presented for analytical demonstration only.


2. Model Architecture

2.1 Revenue Streams Modeled

Revenue Stream TRL (Tech Readiness Level) Earliest Revenue Confidence Tier
Helium-3 fusion fuel sales TRL 4–5 2045+ Speculative
Water ice ISRU (drinking, fuel) TRL 6–7 2032+ Moderate
Surface lease income (Artemis program) TRL 8 2028+ Moderate
Solar energy generation (near side) TRL 3–4 2040+ Speculative
Scientific research leasing TRL 8 2026+ Moderate
Tidal service contract (Earth) TRL 9 In effect Active (in-kind, non-monetary)
Heritage tourism licenses TRL 5 2035+ Speculative
Far-side radio telescope leasing TRL 7 2030+ Moderate

2.2 Key Model Assumptions

Assumption Value Rationale
Discount rate (WACC) 8.5% Weighted cost of capital; interplanetary risk premium of 3.5% added to terrestrial 5.0% baseline
Terminal growth rate 0.1% Conservative; the Moon is not growing (it's shrinking at 3.8 cm/year in orbital distance)
Modeling period 50 years (2026–2076) Standard long-range real-assets horizon
Inflation assumption 2.5% Earth CPI + 0.5% lunar logistics inflation factor
Regulatory risk premium 15% probability of material disruption per year No established lunar property rights framework
Insurance cost $0 No insurer will underwrite the Moon (we checked)

3. Cash Flow Projections

3.1 Base Case (Moderate Scenario)

Year Surface Leases Mineral Rights (He-3) Water ISRU Energy Research Tidal (in-kind) Total Revenue OpEx NOI
2026 $0 $0 $0 $0 $2,000,000 In-kind $2,000,000 $8,500,000 $(6,500,000)
2028 $15,000,000 $0 $0 $0 $5,000,000 In-kind $20,000,000 $12,000,000 $8,000,000
2030 $25,000,000 $0 $3,000,000 $0 $8,000,000 In-kind $36,000,000 $18,000,000 $18,000,000
2035 $50,000,000 $0 $25,000,000 $0 $15,000,000 In-kind $90,000,000 $45,000,000 $45,000,000
2040 $80,000,000 $5,000,000 $60,000,000 $2,000,000 $25,000,000 In-kind $172,000,000 $85,000,000 $87,000,000
2045 $120,000,000 $50,000,000 $100,000,000 $15,000,000 $35,000,000 In-kind $320,000,000 $160,000,000 $160,000,000
2050 $180,000,000 $200,000,000 $150,000,000 $60,000,000 $50,000,000 In-kind $640,000,000 $320,000,000 $320,000,000

3.2 Operating Expenses Breakdown (FY2026)

OpEx Category Annual Cost Notes
Lunar surface maintenance $2,000,000 Micrometeorite erosion monitoring; dust mitigation studies
Mission support & logistics $3,500,000 Launch coordination, comms relay, telemetry
Regulatory & compliance $1,200,000 Treaty monitoring, Artemis Accords liaison
Insurance $0 No available product
Asset management fees (1.0% GAV) $4,810,000,000,000,000 Theoretically; in practice waived (the Moon cannot pay)
Data management & analytics $800,000 GIS mapping, thermal data processing, crater database
Investor reporting $500,000 Quarterly reports, stakeholder presentations
Legal (space law counsel) $500,000 International space law firm retainer
Total OpEx $8,500,000 Excluding theoretical management fee

Warning

The asset management fee line above is theoretical. At 1.0% of gross asset value ($4.81 quadrillion), the annual fee would be $48.1 trillion — roughly half of Earth's GDP. We have waived this fee in recognition of the fact that the Moon cannot pay it, no one owns the Moon, and charging $48 trillion to manage a rock would be indefensible even by asset management industry standards.


4. Discounted Cash Flow Valuation

4.1 Portfolio-Level NPV

Using the base case cash flows over a 50-year horizon, discounted at 8.5% WACC:

Sum of Discounted NOI (2026–2076)  =  $1.24 billion (illustrative)
Terminal Value (Gordon Growth)     =  $0.19 billion
Enterprise Value                   =  $1.43 billion
Less: Theoretical Debt             =  $0 (no one will lend against the Moon)
Net Asset Value                    =  $1.43 billion

4.2 Valuation Reconciliation

Valuation Method Value Comment
Discounted Cash Flow $1.43 billion Based on hypothetical revenue from 2028+
Gross Asset Value (cost approach) $4.81 quadrillion Replacement cost of 7.34 × 10²² kg material at current launch costs
Comparable Sales N/A No comparable transactions (no celestial body has ever been sold)
Market Approach $0 No liquid market exists for Moon assets

Note

The $1.43 billion DCF and $4.81 quadrillion GAV differ by approximately 3.37 trillion percent. This is what financial professionals call "a valuation gap." It reflects the difference between what the Moon is theoretically made of and what anyone would actually pay for it. We recommend the DCF figure for reporting purposes, and the GAV figure for cocktail parties.


5. Historical Operating Statement Analysis

5.1 TTM Operating Statement

Line Item TTM Amount Notes
Revenue
Scientific research grants $2,000,000 NASA LRO data licensing, ESA SMART-1 residuals
Surface lease — Apollo heritage sites $0 Lease expired 1972; no renewals
Tidal service contract In-kind Value estimated at $800B/yr if monetized (see note)
Total Revenue $2,000,000
Operating Expenses
Mission support & logistics $3,500,000
Regulatory compliance $1,200,000
Data & analytics $800,000
Legal (space law) $500,000
Investor reporting $500,000
Surface maintenance $2,000,000
Total OpEx $8,500,000
NOI $(6,500,000) The Moon operates at a loss
CapEx $0 No capital improvements made to the Moon since acquisition
Free Cash Flow $(6,500,000)

Note

The tidal service contract — the Moon's gravitational pull driving Earth's ocean tides — is the portfolio's most valuable service. If monetized at the estimated value of coastal fisheries, shipping navigation, and tidal energy enabled by lunar tides (~$800B/yr Earth-side economic activity), this single contract would dwarf all other revenue streams. However, the contract is barter: the Moon provides tidal services, and Earth provides... continued orbital stability. Neither party has invoiced the other in 4.51 billion years.


6. Sensitivity Analysis

6.1 Key Sensitivities

Variable Base Case Low Case High Case Impact on NAV
He-3 commercialization year 2045 Never 2035 ±$800M
Artemis program scope Base Cancelled Expanded ±$320M
Water ice extraction cost/ton $50,000 $200,000 $15,000 ±$180M
Discount rate 8.5% 12.0% 6.0% ±$290M
Regulatory approval probability 85% 50% 95% ±$210M

6.2 Scenario Summary

Scenario Probability Portfolio NAV
Bull case (He-3 by 2035, Artemis expanded) 15% $3.8 billion
Base case (moderate program progression) 55% $1.43 billion
Bear case (Artemis delayed, no He-3) 25% $120 million
Catastrophic (full regulatory shutdown) 5% $0

7. Model Limitations

  1. Zero historical revenue. All projections are forward-looking with no historical calibration data.
  2. No comparable transactions. No celestial body has ever been sold, making market-based valuation impossible.
  3. Regulatory uncertainty. The Outer Space Treaty prohibits national appropriation of celestial bodies. All "ownership" in this model is theoretical.
  4. Technology risk. He-3 fusion does not yet exist commercially. ISRU is TRL 6–7. Solar energy export from the Moon is TRL 3–4.
  5. Orbital drift. The Moon recedes at 3.8 cm/year. Over the 50-year modeling horizon, this reduces tidal service contract value by approximately 0.0000006%. We have rounded this to zero.
  6. Insurance gap. No insurance product exists for lunar assets. All risk is self-retained (by no one).

This model was built in Excel using standard DCF methodology. It was then transferred to Markdown, which was a significant downgrade in formatting but a significant upgrade in honesty about its limitations.

— Asset Management Analyst, LAMG