Companion files
What It Costs to Raise Money, and Who Decides the Number
These are the companion files of Capital Markets by Julian R. Sterling.The book on Amazon →
The four Excel workbooks that go with the book, re-verified and corrected where their notes and this page were wrong. Every figure the book prints is reproduced in them by a live formula rather than a typed constant, from the four readings of one secondary curve to the register of every convention in euros, and each workbook ends with a Checks sheet setting the printed figure beside the computed one: 272 controls in all, every one green. Around them: the same four models with the inputs emptied, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Twelve workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it prints can be traced to a live formula, and each closes on its checks sheet. Download these four110 KB
Chapters 1 to 3
Three of the issuer’s own bonds trade. The new one is issued at seven years, where none of them sits, so the fair value has to be interpolated — and interpolation is a choice. Four conventions give 117.81, 117.84, 120.32 and 122.78 basis points over mid-swaps, and with them concessions of 4.19, 4.16, 1.68 and minus 0.78. On the last reading the issuer printed inside its own curve and paid nothing at all.
Enter your own three quotations and your own target maturity, and the sheet returns all four at once with the spread between them priced in euros at your size. On Ardennes’ curve that spread was EUR 1,473,880, or 84 per cent of the underwriting commission. The point is to have the number before the mandate is signed. Revised: the read-me’s first experiment ran the wrong way. Nine basis points off the nine-year bond take the logarithmic reading down to 116.88, below the reoffer spread, and its concession to plus 5.12; it does not come back above the reoffer spread, where it already sits. The move is now computed on the sheet.
Download the workbook23 KBChapters 6 to 8
The fee, the expenses and the concession discounted properly at the annuity factor. On this transaction the total is EUR 3,611,953, of which 34.38 per cent appears on no invoice — and the sheet says plainly what the book says: at 2026 spread levels the invoiced commission is the larger number. The concession is 0.71 times the fee, not more than it.
Recompute under each convention and the uninvoiced share runs from 34.38 per cent down to minus 10.85, because under the softest reading the concession is a rebate. Two thresholds are computed live: the concession at which the uninvoiced cost equals the fee, and the one at which it equals the fee and the expenses together: 5.90 and 7.99 basis points. Both sit just below the eight to twelve that were normal in 2022 and 2023, which is why the same arithmetic on the same transaction gave the opposite answer three years ago. Revised: this page used to say both thresholds fall inside that range; the second sits 0.009 of a basis point below it. The span of the four conventions is 84.22 per cent of the commission.
Download the workbook27 KBChapters 12 to 14
Nine and a half million shares at EUR 40.55. The press release said 4.81 per cent. It could have said 2.99, or 5.96, or 6.67 — four references, all quoted in real transactions, 3.68 percentage points apart and worth EUR 15,675,000 on the size sold.
The cost is split into commission, placement discount and the cost of the leak, and kept split, because they are different costs with different remedies. The leak counterfactual is computed at a constant discount and not at a constant share count: an accelerated placement is sized in proceeds and priced at a discount to a reference, so the right question is what price the same proceeds would have fetched. That is the difference between a defensible EUR 7,686,414 and a figure that assumes the company would have sold the same shares for more. Revised: the workbook’s note put the discount and the leak at six and a half times the commission; they are 6.41 times. The sheet now shows that the fall in the reference during the soundings, 1.96 per cent, is the share of the issue the leak costs.
Download the workbook25 KBChapter 16
One row for each place in the two transactions where a convention, not a measurement, decides a published number. Who chose it, what the defensible alternative was, and the difference in euros. Nine rows across the two transactions, from EUR 15,675,000 for the choice of discount reference, 3.70 times the placement’s commission, down to EUR 1,333 for the repricing method; two of them are worth more than the fee of their own transaction. The rows are not additive, and there is deliberately no total.
Two entries are deliberately kept off it. The order book has no identifiable elasticity — it lost EUR 100,000,000 at an unchanged spread — and retention by investor type is not sourceable from any published study. The workbook sets them out as absences rather than conventions, and prices only the cost of pretending otherwise. Work down it against your own deal. Revised: this page used to say the rows come to EUR 17,148,880. That was two of the nine rows added together, 15,675,000 and 1,473,880, which is the sum the register exists to prevent.
Download the workbook38 KBThe four workbooks with the 89 inputs of their Inputs sheets emptied. The checks sheets count what is still missing and test what holds for any inputs.
All chapters
The interpolation, the cost of the bond, the placement and the register, with the same formulas and every input emptied: the three secondary quotations, the bond and its invoices, the dollar indication, the share count and the four references, the order book with its service and retention rates, and the execution. The two further sizes, the regimes of new issue premium and the move in the first experiment stay, because they are the axes of their tables, not data.
The book’s 89 inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: 1,473,880 between the four readings, 3,611,953 for the bond, 31,398,889 for the placement.
Download the blank set90 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1 to 18
The secondary curve read four ways, with Ardennes’ figures beside a blank column. The pricing note header, with one basis point in euros on its last line. The bond’s bill in three lines. The two thresholds and the regime. The first day. The funding comparison across currencies, curve by curve. The allocation record, with a column for the source of each retention rate. The execution log and what the book can say. The announcement’s four references. The wall-crossing log and the pre-sounding close, to be initialled. The placement’s bill. Cost per euro with its conventions stated. The register, with its last column left for you.
Download the PDF30 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Eight on the curve and the concession, seven on the bond’s bill and the other currency, seven on the placement, five on the allocation and the order book, seven on the register, and six on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book17 KBNew material, not a restatement. Three situations the chapters name and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapters 9 and 16 · Case one
The book finds that pro rata would have left 9.6 points more of the bond resold within thirty days, and says the whole gap rests on four retention rates nobody publishes. Measured: the hedge fund rate carries most of it, 0.126 points for every point of retention. Hedge funds would have to keep 97.24 per cent of their paper, more than insurers, before the directed allocation stopped keeping more of the issue. At 50 per cent (ADDED) the gap is 5.94 points, EUR 29,704,494, not 9.59. The direction can be published; the size only with its assumption beside it.
Chapters 15 and 16 · Case two
The book prints the placement’s cost per euro at 11.28 times the bond’s, adds 19.06 on the softest reading, and warns that a figure inheriting two conventions should never be published as a point. All sixteen pairs run from 8.55 to 23.96. The bond’s convention, worth EUR 1,473,880, moves the ratio further than the placement’s, worth EUR 15,675,000: a span of 7.78 against 5.63, because it sits in the denominator of a small number.
Chapters 12 to 14 · Case three
The commission was the one line anybody argued about. The whole central half of the 2016 study, 0.70 to 1.25 per cent, is worth EUR 2,118,738 on this placement; the choice of reference is 7.40 times that and the leak 3.63 times. A drift of 23.43 cents in the reference during the soundings costs as much as the entire range, and 2.13 cents as much as Ardennes’ 1.10 per cent over the mean of 1.05. The reference drifted 85 cents.
Download the three cases34 KB| Blue text | a hardcoded input — you may edit these |
| Yellow fill | an input cell; everything else on the sheet is a formula |
| Black text | a formula — do not overtype these |
| Checks sheet | the printed figure beside the computed one, with a PASS or a FAIL; in the blank set and the cases, each control states its own verdict and the file ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Each file has one Inputs sheet, and it carries the only entered values: the secondary
quotations, the target maturity, the execution levels, the fees, the share count and the four
price references. Everything else is computed from them. Where two readings are defensible, both
are shown and neither is chosen — which is the argument of the book rather than a hedge.
The workbooks were checked by moving the inputs and confirming that every dependent figure moved with them. Shifting the nine-year quotation by nine basis points moves all four fair values, all four concessions and every euro figure that depends on them. Switching the quoted reference in the placement sheet moves the discount, the leak counterfactual and the dilution together.
Capital Markets develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play.
These files accompany Capital Markets. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 24 Sep 2026 | The four workbooks re-verified and corrected, 272 checks. Every figure the book prints still reproduces. The Interpolation Workbook’s first experiment ran the wrong way: nine basis points off the nine-year bond take the logarithmic reading down to 116.88, not back above the reoffer spread. The two thresholds, 5.90 and 7.99, sit below the eight to twelve basis points of 2022 and 2023, not inside them. The placement’s discount and leak are 6.41 times the commission, not six and a half. The register has no total: the EUR 17,148,880 this page printed was two of its nine rows added. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
More in corporate finance, with free companion files. The full list of titles is on the author page.