# The Goodwill Impairment Handbook: Companion Files

Julian R. Sterling, julianrsterling.com/goodwill-impairment

1. Goodwill_Impairment_Workbook.xlsx: the workbook behind every figure of the book (Appendix A). Tabs: Inputs, Forecasts, Rates and DCF, Market,
   Carrying amounts, Tests, Trade name, Asset group, Market capitalization, Roll-forward, Sensitivities, Private scenario, Checks.
   Inputs are blue, formulas black, case values used by the checks grey. Cell B2 of every tab counts the failed checks and must read 0.
2. Goodwill_Impairment_Test_Model.xlsx: the free one-unit test model (forecast, rate, DCF, market value, fair value, carrying amount, headroom,
   loss with the simultaneous equation, market capitalization reconciliation, rate and growth grid, checks).

The case (Tarrenford Analytical Group, Inc.) and the example unit are fictional; every figure is a teaching assumption, not a market norm.
Open the files in Excel or another spreadsheet that recalculates on opening. Education only: not accounting, tax, valuation or investment advice.
