Financial mathematics in a spreadsheet
ACA pricing and reserve calculations with a worked example
Richard Shumaker’s Asset Creation Algorithm records a sequence of unit prices, modeled purchase payments and point-in-time valuations. This example explains what those numbers mean and how a prospective user can review them.
What does ACA calculate?
The original workbook contains approximately one million transaction rows, presented as an approximately 30,000-page spreadsheet. Its opening settings include 1,000,000 units and a $0.02 opening unit price, giving an initial modeled pool value of $20,000. The workbook follows units left, the prescribed price, pool value, and cumulative payments under its rules.
The unit price changes as the sequence advances. A total valuation is calculated by applying a row’s prescribed unit price to the original 1,000,000-unit quantity. That is an ACA-calculated point-in-time figure; it is distinct from accumulated payments and independently established market value.
Two rows from the original workbook
| Excel row | Units left | Unit price | Modeled escrow | PIT valuation |
|---|---|---|---|---|
| 980,005 | 20,000 | $49.99755012 | $980,001.00 | $49,997,550.12 |
| 990,005 | 10,000 | $199.98020198 | $1,980,002.00 | $199,980,201.98 |
Source: Richard Shumaker’s workbook, Excel 7000000000(20261017-121301).xlsb, rows 980,005 and 990,005; columns B, C, G and H. These are modeled stored results, not verified bank balances. Displayed unit prices are rounded; the valuation uses the underlying precision.
What does point in time mean?
At row 980,005, the underlying unit price of approximately $49.9975501224978 multiplied by 1,000,000 gives approximately $49,997,550.12. The cumulative modeled escrow at that same row is $980,001.00. These columns answer different questions: one gives a valuation under the pricing rule, while the other totals the assumed payments.
Given ACA’s stated inputs and transaction rules, its calculated prices, accumulated payments, and point-in-time valuations follow deterministically from the mathematics. Applying the same inputs and rules allows the results to be independently reproduced and checked.
How would reverse redemptions work?
Shumaker’s intended mechanism is for redemptions to reverse the purchase sequence at the corresponding step prices. Each purchase adds its payment to the reserve; reversing that step removes the same payment. Funding that reversal requires the payments to have actually been received and retained, with a consistent rule for rounding and transaction order.
This describes a proposed operating rule. It does not establish an operating market or promise a redemption right to visitors. A real implementation would need its own ownership terms, transaction rules and professional review.
Who might use this model?
Potential review uses include teaching the difference between a unit price, cumulative proceeds and a total valuation; examining a rule-based pricing sequence; and testing purchase and reverse-redemption assumptions. These are proposed uses for evaluation, not independently validated commercial applications.
What can someone acquire or license?
Richard welcomes discussion of the workbook, documentation and specified rights to use or acquire the work. A written agreement would define the materials, permitted uses, price, and any retained rights. The exchange consideration could be negotiated separately; no modeled figure establishes the asking price or the value of a buyer’s payment.
Read the review and licensing guide or return to the ACA overview.
This page explains a mathematical model and a workbook licensing opportunity. It does not offer investment units, accept deposits, guarantee returns, or establish accounting recognition or realizable market value. Last updated October 17, 2026.