ZCG Grants Dashboard

Payouts are valued at the ZEC/USD price recorded on the payout date. Future scenarios are recalculated in the browser from the latest clean data.

Loading clean/zcg_clean.json and clean/payouts_rows.json...

Treasury position

Balances as recorded in the workbook Dashboard sheet — the figures we trust. (Spend and disbursement totals shown elsewhere are rebuilt from per-milestone rows, since that summary cell was corrupted.)

Grant payouts by year

USD value at each payout date. Contractors are excluded.

Funding by category

Grant milestone payouts, USD value at payout date.

Top recipients

Grant payouts only, aggregated by grantee.

Application pipeline

Counts from ZCG All Grants Tracking.

Date Type Recipient Project / milestone Category ZEC ZEC/USD @ payout USD @ payout Source

Future ZEC price scenario

Enter a future ZEC price to revalue current ZEC holdings, receivables, and unpaid grant commitments. Historical payouts stay fixed at their payout-date USD value.

Unpaid commitments

Derived from grant rows with no payout date, non-cancelled status, and a positive USD amount.

This model is intentionally simple: USD commitments are converted to ZEC at the scenario price, while receivables and balances are revalued at that same price. If future workbook rows are added, rerun python3 clean_zcg_data.py and reload this HTML.

Source row inspector

Click a source link in the payout table to inspect the exact spreadsheet sheet and row. The HTML reads faithful CSV mirrors under clean/source/ where line N equals Excel row N.

No source row selected yet.

Spending vs inflow & yield model

Compares current spending against a future ZEC inflow and a yield/dividend ("endowment") treasury. Slide spending from 50% to 400% of the baseline, set the annual ZEC inflow, the yield rate, and the ZEC price.

Sustainability check

Net annual flow = (treasury holdings × yield) + ZEC inflow − target spend. Positive means spending is funded from yield + inflow without eating principal.

Yield treasury needed @ 7% to fund spending from returns

Principal placed in a yield treasury so the annual return alone covers spending, preserving the principal. "Net of inflow" subtracts the ZEC inflow value first.

Treasury needed across spending levels (USD)

Principal required at the chosen yield to fund each spending level from returns.

Treasury needed across spending levels (ZEC)

Same principal expressed in ZEC at the chosen price.

Map: spending levels, inflow coverage & treasury sizing

Highlighted row = current slider position. "Net of inflow" is the extra principal needed after the ZEC inflow.

Level Annual spend (USD) Annual spend (ZEC) Inflow surplus / deficit Treasury @ yield (USD) Treasury @ yield (ZEC) Treasury net of inflow (USD) Covered by inflow?

Timeline to a self-funding treasury

Projects the treasury forward assuming the ZEC inflow keeps arriving, yield is reinvested, spending stays at the selected level, and the ZEC price holds at the chosen value. "Full self-sufficiency" = yield alone covers spend; "stop eating principal" = yield + inflow covers spend. Starting balance = current holdings revalued at the chosen price.

Year Treasury (USD) Treasury (ZEC) Yield generated Net flow Status