# The Corporate Development Professional: companion files

Julian R. Sterling

## What is here

- **Corporate_Development_Model.xlsx**: the workbook that rebuilds the Norcastle and Pellridge case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Value, Accretion, Capital, Checks.
- **Corporate_Development_Toolkit.docx**: the checklists and templates of Appendix B (acquisition criteria, target screening, first call and confidentiality, indication of interest, diligence request list, synergy case, board paper, day one, synergy tracking), in editable form.

## Which sheet answers which chapter

- Chapters 6, 7 and 10: Value (standalone value, synergies, walk-away price, premium)
- Chapter 8: Accretion (years one and two)
- Chapters 8 and 11: Capital (return on capital, leverage)

## Two inputs to change first

1. On Inputs, raise the agreed multiple from 12.0 to 13.0, the seller's ask: see the premium pass the walk-away price and the share of synergies paid away go above 100 percent.
2. On Inputs, cut the synergies from 18.0 to 9.0: watch year-two accretion and the return on capital fall. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

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

Norcastle Group, Pellridge Controls, Ashgrove Partners, Brennick Labs and Harwell & Sloane are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not market benchmarks or forecasts. Provided as is, without warranty. Not investment, legal, accounting or tax advice.
