The book's own figures, for the five blank workbooks
Type them back in and the book's results come back.

Market_Approach_and_Calibration_Blank.xlsx

   1. Assumptions!B2                         42
   1. Assumptions!B3                         2.4
   1. Assumptions!B4                         -5.6
   1. Assumptions!B6                         90
   1. Assumptions!B10                        0
   1. Assumptions!B13                        264.65
   1. Assumptions!B14                        33.5
   1. Assumptions!B15                        8.6
   1. Assumptions!B18                        7.6
   1. Assumptions!B19                        37
   1. Assumptions!B20                        93
   2. Comparable set!B2                      7.1
   2. Comparable set!C2                      61
   2. Comparable set!D2                      0.155
   2. Comparable set!E2                      0.021
   2. Comparable set!B3                      7.8
   2. Comparable set!C3                      48
   2. Comparable set!D3                      0.171
   2. Comparable set!E3                      0.018
   2. Comparable set!B4                      8
   2. Comparable set!C4                      73
   2. Comparable set!D4                      0.182
   2. Comparable set!E4                      0.024
   2. Comparable set!B5                      8.6
   2. Comparable set!C5                      95
   2. Comparable set!D5                      0.19
   2. Comparable set!E5                      0.031
   2. Comparable set!B6                      9.5
   2. Comparable set!C6                      120
   2. Comparable set!D6                      0.205
   2. Comparable set!E6                      0.038
   2. Comparable set!D14                     0.212
   2. Comparable set!E15                     0.014
   4. Multiple build!B3                      -0.45
   4. Multiple build!B4                      -0.35
   4. Multiple build!B5                      -0.2
   4. Multiple build!B6                      0.3
   2. Comparable set!A2                      Northmoor Industrial
   2. Comparable set!A3                      Calderon Components
   2. Comparable set!A4                      Halstead Precision
   2. Comparable set!A5                      Verrier Manufacturing
   2. Comparable set!A6                      Ostheim Werke
   2. Comparable set!F2                      Same end-market, similar production footprint. Larger.
   2. Comparable set!F3                      Closest on size and mix. The anchor of the set.
   2. Comparable set!F4                      Broader product range; a touch more diversified by customer.
   2. Comparable set!F5                      Bigger, faster-growing, and less customer-concentrated.
   2. Comparable set!F6                      On probation: scale and growth put it in a different bracket.

   Result: EBITDA 38.8, multiple 7.3, enterprise value 283.24, equity 193.24; calibration gap 0.00 turns; roll-forward 14.80 + 13.14.

Income_Approach_and_Terminal_Value_Blank.xlsx

   1. Assumptions!B2                         24
   1. Assumptions!B3                         0.022
   1. Assumptions!B7                         0.085
   1. Assumptions!B8                         0.018
   1. Assumptions!B9                         14
   1. Assumptions!B12                        15

   Result: 171.5 of forecast, 196.2 of terminal value, 53.4 per cent of the total.

Equity_Waterfall_and_the_Bridge_Blank.xlsx

   1. Assumptions!B2                         283.24
   1. Assumptions!B5                         60
   1. Assumptions!B6                         30
   1. Assumptions!B7                         40
   1. Assumptions!B8                         20
   1. Assumptions!B9                         45
   1. Assumptions!B10                        8
   1. Assumptions!B11                        1.5
   2. Net debt!B2                            78
   2. Net debt!B3                            12
   2. Net debt!B4                            9
   2. Net debt!B5                            1.4
   2. Net debt!B6                            4.6
   2. Net debt!B7                            6
   2. Net debt!B8                            -21

   Result: Common 1.2432 a share, 62.2 per cent of what the headline implies for it; kinks at 190, 302.5 and 344.

Credit_Marks_Across_the_Cycle_Blank.xlsx

   1. Assumptions!B2                         50
   1. Assumptions!B3                         0.0575
   1. Assumptions!B4                         0.01
   1. Assumptions!B5                         4
   1. Assumptions!B6                         2
   1. Assumptions!B9                         0.043
   1. Assumptions!B10                        0.0575
   1. Assumptions!B13                        44
   1. Assumptions!B14                        8
   1. Assumptions!B15                        31
   1. Assumptions!B16                        1.5
   1. Assumptions!B17                        0.18
   1. Assumptions!B18                        0.55
   1. Assumptions!B19                        0.35
   1. Assumptions!B20                        0.1
   1. Assumptions!B21                        0.0775
   1. Assumptions!B24                        30
   1. Assumptions!B25                        0.12
   1. Assumptions!B26                        95
   1. Assumptions!B27                        0.03
   1. Assumptions!B28                        60
   1. Assumptions!B29                        6

   Result: Par; the floor at 101.75; the troubled mark 74.8 per cent of face; coverage below one in year 4.

The_Hardest_Judgment_Calls_Blank.xlsx

   1. The Inputs!B5                          50
   1. The Inputs!B6                          -0.04
   1. The Inputs!B7                          3
   1. The Inputs!B9                          1.55
   1. The Inputs!B10                         4.5
   1. The Inputs!B11                         0.17
   1. The Inputs!B14                         7.3
   1. The Inputs!B15                         8.9
   1. The Inputs!B16                         0.2
   1. The Inputs!B17                         120
   1. The Inputs!B18                         0.45
   1. The Inputs!B19                         2.5
   1. The Inputs!B20                         0.04
   1. The Inputs!B21                         0.3
   1. The Inputs!B25                         3
   1. The Inputs!C25                         71
   1. The Inputs!B26                         42
   1. The Inputs!C26                         78
   1. The Inputs!B27                         63
   1. The Inputs!C27                         84
   1. The Inputs!B28                         96
   1. The Inputs!B29                         60
   1. The Inputs!B32                         6.4
   1. The Inputs!B33                         0.0525
   1. The Inputs!B34                         0.05
   1. The Inputs!B35                         0.0575
   1. The Inputs!B8                          12

   Result: Bid 34.41; discount 10.0 + 21.2; double-count 16.4 points; put 22.0 per cent; orderly price 81.7; appraisal range 13.7 per cent.

