CAPITAL MARKETS - BLANK MODEL SET: THE BOOK'S OWN INPUTS

Each of the four workbooks has its own Inputs sheet. Type these 89 values into them - the
cell references are on the Inputs sheet of the workbook named above each block - and the
book's results come back. Percentages are entered as decimals (0.0425 is 4.25 per cent).

The_Interpolation_Workbook_Blank.xlsx   (13 inputs)
   Inputs!B8     2.500% March 2028, maturity, years                                 1.58
   Inputs!C8     2.500% March 2028, spread over mid-swaps, bp                       62
   Inputs!B9     3.250% September 2030, maturity, years                             4.12
   Inputs!C9     3.250% September 2030, spread over mid-swaps, bp                   88
   Inputs!B10    1.875% January 2036, maturity, years                               9.24
   Inputs!C10    1.875% January 2036, spread over mid-swaps, bp                     141
   Inputs!B19    Target maturity, years                                             7
   Inputs!B20    Reoffer spread over mid-swaps, bp                                  122
   Inputs!B21    Tenor, years                                                       7
   Inputs!B22    Annual coupon                                                      0.0425
   Inputs!B23    Seven-year euro mid-swap at 30 June 2026                           0.031
   Inputs!B31    Amount raised, EUR                                                 500000000
   Inputs!B32    Size at which the span between conventions is valued, EUR          500000000

The_Cost_Workbook_Blank.xlsx   (17 inputs)
   Inputs!B8     2.500% March 2028, maturity, years                                 1.58
   Inputs!C8     2.500% March 2028, spread over mid-swaps, bp                       62
   Inputs!B9     3.250% September 2030, maturity, years                             4.12
   Inputs!C9     3.250% September 2030, spread over mid-swaps, bp                   88
   Inputs!B10    1.875% January 2036, maturity, years                               9.24
   Inputs!C10    1.875% January 2036, spread over mid-swaps, bp                     141
   Inputs!B18    Amount raised, EUR                                                 500000000
   Inputs!B19    Target maturity, years                                             7
   Inputs!B20    Reoffer spread over mid-swaps, bp                                  122
   Inputs!B21    Tenor, years                                                       7
   Inputs!B22    Annual coupon                                                      0.0425
   Inputs!B23    Seven-year euro mid-swap at 30 June 2026                           0.031
   Inputs!B28    Underwriting commission, bp of the amount raised                   35
   Inputs!B29    Legal fees, EUR                                                    285000
   Inputs!B30    Rating agency fees, EUR                                            195000
   Inputs!B31    Listing and paying agent, EUR                                      65000
   Inputs!B32    Roadshow, EUR                                                      75000

The_Placement_Workbook_Blank.xlsx   (10 inputs)
   Inputs!B8     Shares already in issue                                            118000000
   Inputs!B9     Shares placed                                                      9500000
   Inputs!B10    Placement price, EUR                                               40.55
   Inputs!B11    Commission, share of gross proceeds                                0.011
   Inputs!B19    Thirty-day volume weighted average                                 41.8
   Inputs!B20    Last close                                                         42.6
   Inputs!B21    Five-day volume weighted average                                   43.12
   Inputs!B22    Close before the wall-crossing                                     43.45
   Inputs!B30    Row of the reference the announcement quotes                       2
   Inputs!B31    Row of the reference standing before the wall-crossing             4

The_Register_Blank.xlsx   (49 inputs)
   Inputs!B8     2.500% March 2028, maturity, years                                 1.58
   Inputs!C8     2.500% March 2028, spread over mid-swaps, bp                       62
   Inputs!B9     3.250% September 2030, maturity, years                             4.12
   Inputs!C9     3.250% September 2030, spread over mid-swaps, bp                   88
   Inputs!B10    1.875% January 2036, maturity, years                               9.24
   Inputs!C10    1.875% January 2036, spread over mid-swaps, bp                     141
   Inputs!B15    Amount raised, EUR                                                 500000000
   Inputs!B16    Target maturity, years                                             7
   Inputs!B17    Reoffer spread over mid-swaps, bp                                  122
   Inputs!B18    Tenor, years                                                       7
   Inputs!B19    Annual coupon                                                      0.0425
   Inputs!B20    Seven-year euro mid-swap at 30 June 2026                           0.031
   Inputs!B21    Underwriting commission, bp of the amount raised                   35
   Inputs!B22    Legal, rating, listing and roadshow, EUR                           620000
   Inputs!B23    Spread at the close of the first day, bp                           118.5
   Inputs!B28    Dollar amount indicated, USD                                       300000000
   Inputs!B29    Dollar coupon indicated                                            0.0518
   Inputs!B30    Seven-year dollar mid-swap at 30 June 2026                         0.041
   Inputs!B31    Cross-currency basis, seven years, bp                              -18
   Inputs!B39    Shares already in issue                                            118000000
   Inputs!B40    Shares placed                                                      9500000
   Inputs!B41    Placement price, EUR                                               40.55
   Inputs!B42    Commission, share of gross proceeds                                0.011
   Inputs!B45    Thirty-day volume weighted average                                 41.8
   Inputs!B46    Last close                                                         42.6
   Inputs!B47    Five-day volume weighted average                                   43.12
   Inputs!B48    Close before the wall-crossing                                     43.45
   Inputs!B49    Row of the reference the announcement quotes                       2
   Inputs!B50    Row of the reference standing before the wall-crossing             4
   Inputs!B55    Long-only asset managers, demand, EUR                              1420000000
   Inputs!C55    Long-only asset managers, service rate                             1
   Inputs!D55    Long-only asset managers, retained at thirty days                  0.94
   Inputs!B56    Insurers and pension funds, demand, EUR                            610000000
   Inputs!C56    Insurers and pension funds, service rate                           1
   Inputs!D56    Insurers and pension funds, retained at thirty days                0.97
   Inputs!B57    Bank treasuries, demand, EUR                                       380000000
   Inputs!C57    Bank treasuries, service rate                                      0.55
   Inputs!D57    Bank treasuries, retained at thirty days                           0.88
   Inputs!B58    Hedge funds, demand, EUR                                           440000000
   Inputs!C58    Hedge funds, service rate                                          0.15
   Inputs!D58    Hedge funds, retained at thirty days                               0.21
   Inputs!B66    Initial price thoughts, spread, bp                                 145
   Inputs!C66    Initial price thoughts, order book, EUR                            1750000000
   Inputs!B67    Price guidance, spread, bp                                         128
   Inputs!C67    Price guidance, order book, EUR                                    3600000000
   Inputs!B68    Launch, spread, bp                                                 122
   Inputs!C68    Launch, order book, EUR                                            2950000000
   Inputs!B69    Reoffer, spread, bp                                                122
   Inputs!C69    Reoffer, order book, EUR                                           2850000000
