# The Fair Value Measurement Handbook: companion files

Julian R. Sterling, julianrsterling.com/asc820

## What is here

- **Fair_Value_Model.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Calderwick Instruments, Inc., a listed instrument maker, at 31 December 2025 and 2026. Every case figure is a teaching assumption, never a market figure.

## The eleven tabs, in the order to read them

1. **Inputs**: every typed number of the case, by instrument, with a column for each year-end. Nothing typed appears elsewhere except a few level labels and the zeros of empty roll-forward lines.
2. **Level1**: Treasury bills and the listed shares, including the locked-up shares measured without a discount.
3. **Bonds**: the pricing service prices, the challenged bond and the second source.
4. **Swap**: the mid-market value, the credit adjustment of each year and the significance test.
5. **EarnOut**: the probability-weighted scenarios at acquisition, at each year-end and in the sensitivity case.
6. **Ravelstone**: the calibration to the entry round and the adviser's values per share at three volatilities.
7. **Fund**: the net asset value rolled forward and the later statement.
8. **BrindleRoad**: current use against the permitted alternative use, and the impairment.
9. **Hierarchy**: the table of the note, by level, with the fund outside the hierarchy.
10. **Level3**: the roll-forward of the recurring Level 3 items.
11. **Checks**: each key figure reached by two routes; every line must read PASS.

## How to use it

Change one input at a time on Inputs, follow it to the hierarchy table and the roll-forward, and read Checks before any figure.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Rules are described as read in November 2026. This is education, not accounting or audit advice: your entity's facts govern, and its accountants and auditors decide.
