# The Investor Relations Officer: companion files

Julian R. Sterling

## What is here

- **IRO_Model.xlsx**: the workbook that rebuilds the Veltrane case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Earnings, Guidance and Consensus, Shareholder Base and Targeting, Valuation and Budget, Votes, Checks.
- **IR_Toolkit.docx**: the checklists and templates of Appendix B (disclosure policy checklist, earnings calendar template, earnings release checklist, call script and q&a preparation checklist, guidance change checklist, shareholder base review template, targeting and meeting log template, investor day checklist, proxy season calendar, activism preparedness checklist, crisis and rumor response checklist), in editable form.

## Which sheet answers which chapter

- Chapters 4 and 5: Earnings (the three releases against consensus, the second-quarter bridge from GAAP EPS to adjusted EPS)
- Chapters 6 and 7: Guidance and Consensus (the three versions of 2026 guidance, consensus before and after, the analysts' ratings)
- Chapters 8 and 9: Shareholder Base and Targeting (the register by style, the rotation, the targeting funnel)
- Chapters 10 and 11: Valuation and Budget (the discount to the peer group, the investor day targets, the IR budget)
- Chapters 12 to 14: Votes (say-on-pay, the Quillmont stake, the universal proxy count)

## Two inputs to change first

1. On Inputs, lower the closing peer-group median from 16.0x to 15.0x: watch the discount narrow and the price implied by the peer multiple fall.
2. On Inputs, lower Quillmont nominee A's vote from 52.4% to 49.0%: watch nominee A drop to twelfth place and company nominee 11 keep the seat. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Veltrane Technologies and Quillmont Partners are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not prices, recommendations or market benchmarks. Provided as is, without warranty. Not investment, legal or tax advice.
