Skip to main content

Applications for the autumn mentorship cohort are open until 30 September. Apply now

Workbook

Treasury Deep Review

One deep review for treasury requests. A 45 minute core pass, then optional modules for budget reconstruction, rates and FX, and delivery risk.

Type
Workbook
Difficulty
Advanced
Time
45 min
Version
v1.0.0
Updated
8/10/2026
budgetsdatadeliveryprocessrisktreasury

What this helps you do

The budget workbook, the rate and FX calculator and the delivery-risk register, merged into a single record. Work the core, then switch on only the modules the request earns. Nothing from the three source tools was removed in the merge.

When to use this

  • A proposal promises outcomes over a period long enough for conditions to change.
  • A request depends heavily on staffing costs and you want to see the sensitivity.
  • A treasury request publishes a total you cannot trace to line items.
  • Delivery depends on parties or systems the proposer does not control.
  • The proposal prices costs in one currency and requests funds in another.
  • You are comparing two proposals whose budgets are presented in different shapes.
  • You want to define what you will monitor after enactment, before you vote.
  • You want to know which categories drive the request before you question any of them.
  • You want to test whether a contingency percentage is doing the work of a missing line item.

When NOT to use this

  • No cost assumptions are published at all; ask for them first using the question tracker.
  • The action has no delivery component, such as an informational action.
  • The proposal is not staffing-led and the roles are incidental.
  • The request is small enough that reconstruction costs more than it reveals.
  • You are assessing delivery capability rather than cost; use the risk register.
  • You are assessing financial assumptions; use the reconstruction workbook or the calculator.
  • You are looking for a single correct answer; this tool produces a range.
  • You intend the register as an argument against the proposal rather than as an assessment.
  • You want a full budget rebuild across all categories; use the reconstruction workbook.

What you'll need

  • Any prior delivery record for the same team
  • Stated headcount, rates, durations and unit costs
  • Stated roles, headcount, hours or days, and rates
  • The ADA amount requested and any stated ADA price or FX assumption
  • The contingency percentage and the base it applies to
  • The currency each cost is incurred in
  • The date the proposer priced the budget
  • The delivery plan, milestone schedule and dependency list
  • The full budget breakdown as published
  • The FX and ADA price assumptions used by the proposer
  • The team composition and stated capacity
  • Your intake brief and claim-evidence map

Estimated completion time

45 minutes

Working time for one governance action, assuming the inputs listed here are already to hand.

How to use it

  1. 1Module: Budget reconstruction: Enter the proposer figure per category exactly as published, before you calculate anything.
  2. 2Module: Budget reconstruction: Rebuild each category from its own units: heads times rate times period, or unit cost times quantity.
  3. 3Module: Budget reconstruction: Where an assumption is missing, enter your own and label it clearly as your assumption.
  4. 4Module: Budget reconstruction: Record the ADA price and FX assumptions separately from the line items so they can be varied.
  5. 5Module: Budget reconstruction: Treat contingency as its own line, never spread through other categories.
  6. 6Module: Budget reconstruction: Calculate subtotals per category and a reconstructed total.
  7. 7Module: Budget reconstruction: Compare proposer total, reconstructed total, variance and variance percentage.
  8. 8Module: Budget reconstruction: Explain each material variance in one sentence: missing line, different assumption, or arithmetic error.
  9. 9Module: Budget reconstruction: Send unexplained variances to the question tracker rather than resolving them yourself.
  10. 10Module: Rates, FX and contingency: Enter one row per role, with headcount, hours or days, rate, and period.
  11. 11Module: Rates, FX and contingency: Set the currency per row rather than converting as you go.
  12. 12Module: Rates, FX and contingency: Record the FX assumption and its source and date once, at the scenario level.
  13. 13Module: Rates, FX and contingency: Apply contingency as an explicit percentage of a stated base, and name the base.
  14. 14Module: Rates, FX and contingency: Read the calculated cost per role and the scenario total.
  15. 15Module: Rates, FX and contingency: Create a second scenario changing exactly one assumption, so the effect is attributable.
  16. 16Module: Rates, FX and contingency: Add a third scenario for the adverse case: higher rates, weaker ADA price, or a longer period.
  17. 17Module: Rates, FX and contingency: Compare scenario totals against the requested amount and record which assumptions dominate.
  18. 18Module: Delivery risk: Write one risk per row, phrased as an event with a consequence rather than as a worry.
  19. 19Module: Delivery risk: Categorise it: technical, financial, team, dependency, governance, legal, or market.
  20. 20Module: Delivery risk: Score probability from one to five, and impact from one to five, on the delivery of the stated outcome.
  21. 21Module: Delivery risk: Let severity fall out of probability times impact rather than setting it by feel.
  22. 22Module: Delivery risk: Record the evidence for the score. A score with no evidence is an opinion in a numeric costume.
  23. 23Module: Delivery risk: State the mitigation the proposal already offers, and name its owner.
  24. 24Module: Delivery risk: Re-score residual risk after that mitigation, honestly.
  25. 25Module: Delivery risk: Define one monitoring indicator per material risk, measurable by someone outside the team.
  26. 26Module: Delivery risk: Read the matrix for concentration, then carry the top residual risks into your decision record.

The tool

Full workbook - v1.0.0

Module: Budget reconstruction: Cost categories to reconstruct

  • Personnel: role, headcount, rate, period
  • Contractors: scope, day rate, days
  • Infrastructure: hosting, tooling, hardware
  • Marketing: channel, unit cost, volume
  • Professional services: legal, audit, accounting
  • Travel: trips, people, unit cost
  • Contingency: percentage and the base it applies to
  • Other costs, itemised rather than pooled

Module: Budget reconstruction: Assumption block

  • ADA amount requested
  • ADA price assumed by the proposer, and the date
  • ADA price you are using, and the date
  • Fiat currency of the underlying costs
  • FX rate assumed, and the source
  • Whether the request is denominated in ADA or in fiat

Module: Budget reconstruction: Comparison block

  • Proposer total per category
  • Reconstructed total per category
  • Variance in absolute terms
  • Variance as a percentage
  • Explanation for each material variance
  • Unexplained variance carried to the question tracker

Module: Rates, FX and contingency: Role row fields

  • Role title
  • Headcount
  • Hours or days per period
  • Rate per hour or day
  • Period and number of periods
  • Currency of the rate
  • Calculated cost before contingency

Module: Rates, FX and contingency: Scenario-level assumptions

  • FX rate and the source
  • Date of the FX reading
  • ADA price assumption and its date
  • Contingency percentage
  • Contingency base: which lines it applies to
  • Requested amount for comparison

Module: Rates, FX and contingency: Scenario comparison

  • Base case as published by the proposer
  • Your reconstruction of the base case
  • Adverse case with the assumptions you consider plausible
  • Difference between scenarios in absolute and percentage terms
  • Which single assumption moves the total most

Module: Delivery risk: Risk row fields

  • Risk, as an event with a consequence
  • Category
  • Probability, one to five
  • Impact, one to five
  • Severity, probability times impact
  • Evidence for the scoring
  • Mitigation offered or available
  • Mitigation owner
  • Residual risk after mitigation
  • Monitoring indicator and its measurement interval

Module: Delivery risk: Probability and impact matrix

  • Score probability one to five where five is near certain
  • Score impact one to five where five prevents the stated outcome
  • Severity of 15 or more is treated as material for this register
  • Plot each risk to see whether the register is concentrated in one category
  • Concentration in a single category is itself a finding

Module: Delivery risk: Scoring discipline

  • Score the delivery risk, not your view of the proposers
  • A risk with no evidence is recorded with the evidence field left explicitly empty
  • Mitigations that exist only as intentions do not reduce residual risk
  • Every material residual risk needs a monitoring indicator or it cannot be tracked
Fictional Example

Invented for illustration. It does not describe a real governance action, proposal, or organisation.

Module: Budget reconstruction: Fictional reconstruction: Regional Developer Hubs pilot

  • Proposer total: 1,850,000 ADA at an assumed price of 0.55 USD
  • Personnel reconstructed: 4 staff, 12 months, 5,500 USD per month equals 264,000 USD
  • Infrastructure reconstructed: 3 sites, 2,400 USD per month equals 86,400 USD
  • Contingency stated at 10 percent, applied to a base the proposal does not define
  • Reconstructed total: 1,610,000 ADA at the same assumed price
  • Variance: 240,000 ADA, or 13 percent above the reconstruction
  • Explanation: contingency base undefined and a marketing line with no units
  • Both variances sent to the question tracker on 2026-08-07

Module: Rates, FX and contingency: Fictional scenario set

  • Base case: 4 roles, 160 hours per month, 45 USD per hour, 12 months equals 345,600 USD
  • Contingency at 10 percent of personnel only equals 34,560 USD
  • At the proposer ADA price of 0.55 USD the personnel request is about 691,000 ADA
  • Adverse case: ADA price at 0.40 USD raises the same personnel cost to about 950,000 ADA
  • Sensitivity finding: the ADA price assumption moves the total more than a 20 percent rate increase
  • Question raised: is the request denominated in ADA or in USD, and who carries the price risk?

Module: Delivery risk: Fictional risk row

  • Risk: the single named technical lead leaves and the hub build stalls for a quarter
  • Category: team
  • Probability: 3
  • Impact: 4
  • Severity: 12
  • Evidence: no deputy named; the same individual appears in all three site plans
  • Mitigation: proposal states a contractor could be engaged, with no contract in place
  • Mitigation owner: proposer, unnamed
  • Residual risk: 12, unchanged, because the mitigation is an intention
  • Monitoring indicator: named technical lead listed in each quarterly report

How to interpret the result

  • Module: Budget reconstruction: A variance under roughly five percent usually reflects rounding and differing assumptions rather than a defect.
  • Module: Budget reconstruction: A variance you can explain is not a problem. A variance nobody can explain is the finding.
  • Module: Budget reconstruction: If the reconstruction comes out higher than the request, the proposal may be underfunded, which is its own delivery risk.
  • Module: Budget reconstruction: Categories where you had to invent assumptions show where disclosure is thin, regardless of the numbers.
  • Module: Rates, FX and contingency: The most useful output is which assumption dominates, not the totals themselves.
  • Module: Rates, FX and contingency: If the adverse case is unaffordable, the real question is who carries the price risk, not whether the rates are fair.
  • Module: Rates, FX and contingency: Contingency above roughly fifteen percent usually indicates either genuine uncertainty or a line item nobody wanted to itemise. Ask which.
  • Module: Delivery risk: Read severity as a triage aid, not a measurement. It tells you what to examine next.
  • Module: Delivery risk: The gap between raw and residual severity measures how much real mitigation exists. A zero gap means the mitigations are words.
  • Module: Delivery risk: A register concentrated in one category tells you where to seek expert input.
  • Module: Delivery risk: Material risks with no monitoring indicator mean you would not know if the risk landed.

Limitations

  • Module: Budget reconstruction: Reconstruction tests internal consistency, not whether the prices are reasonable in the market.
  • Module: Budget reconstruction: It depends on the assumptions the proposer published; thin disclosure produces a weak reconstruction.
  • Module: Budget reconstruction: ADA price movement between pricing date and enactment can dominate every line-item difference.
  • Module: Rates, FX and contingency: Scenario outputs are only as good as the assumptions you enter, and they are your assumptions.
  • Module: Rates, FX and contingency: It does not benchmark rates against any market; it tests internal consistency and sensitivity.
  • Module: Rates, FX and contingency: FX and ADA price readings are point-in-time and go stale quickly.
  • Module: Delivery risk: Scores are subjective and are not comparable across reviewers without a shared calibration.
  • Module: Delivery risk: The register captures foreseeable risks only, and delivery often fails on unforeseen ones.
  • Module: Delivery risk: A high-risk register does not mean a proposal should not proceed; it means the risks should be visible and monitored.

Sources and methodology

  • CIP-1694 treasury withdrawal actions

    Cardano Improvement Proposals

    Defines the treasury withdrawal mechanism this workbook reviews.

  • Cardano treasury and reserves data

    Placeholder entry. A canonical treasury data source has not been fixed for this edition.

    Canonical link not yet verified. Treat this entry as incomplete.

  • ISO 31000 risk management principles and guidelines

    International Organization for Standardization

    Underlying structure for the probability and impact register.

  • Cardano project delivery reporting

    Placeholder entry. A canonical delivery reporting source is not yet established.

    Canonical link not yet verified. Treat this entry as incomplete.

  • Sensitivity analysis in project budgeting

    Placeholder entry. Method summarised from standard practice; a canonical citation is pending.

    Canonical link not yet verified. Treat this entry as incomplete.

  • ADA market price reference

    Placeholder entry. No single canonical price source is endorsed; record the one you used.

    Canonical link not yet verified. Treat this entry as incomplete.

Learn this method

This tool records the work. The Training Lab teaches how to do it.

  • treasury-and-budget · Reading a Treasury Withdrawal Like an Operator

    Reading a Treasury Withdrawal Like an Operator

    Teaches how to reconstruct a budget from its stated assumptions.

    Open lesson
  • treasury-and-budget · Reading a Treasury Withdrawal Like an Operator

    Reading a Treasury Withdrawal Like an Operator

    Teaches how to test staffing and rate assumptions.

    Open lesson
  • risk-security-legal · Evaluating Team and Delivery Risk

    Evaluating Team and Delivery Risk

    Builds a risk register and proportionate mitigations.

    Open lesson
  • Lab lesson planned

    A dedicated lesson on budget reconstruction is planned.

  • Lab lesson planned

    A dedicated lesson on FX and contingency sensitivity is planned.

  • Lab lesson planned

    A dedicated lesson on monitoring indicators is planned.

Downloads

  • Markdown export: the complete tool, including metadata, instructions, the template, limitations, sources and version history.

No other file formats are published for this resource. We list a format only when the file exists.

Version and governance

Current version
v1.0.0
Published
Not recorded
Last updated
8/10/2026
Next scheduled review
2/6/2027
Licence
CC BY 4.0
Editorial status
Not yet externally reviewed

No named reviewer is shown because no external review has been completed. Attribution appears only once a verified reviewer has signed off.

Changelog

  • v1.0.0 (2026-08-10) - Merged from the Budget Reconstruction Workbook, the Staffing, Rate, FX & Contingency Calculator and the Delivery-Risk Register. Content carried over unchanged; the three sources are retired and point here.