Spreadsheet: fc81b2c7-fa05-4d3a-a5f7-68bbf9774124
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Transaction Date: 19/07/2012
Debt and Money Market Securities Transaction Details
S.No | Name of the Security | ISIN | Scheme Name | Maturity Date | Residual days | Settlement Type | Trade Date | Valuation Date | Settlement Date | Quantity Traded | Value of the Trade | Price at which valued | Yield at which valued | Type of trade
1 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4502 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 500000 | 53260000 | 106.52 | 8.2924 | MARKET TRADE
2 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM INCOME FUND - 1998 | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 1100000 | 110583000 | 100.53 | 8.0692 | MARKET TRADE
3 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND - SHORT TERM | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 800000 | 80424000 | 100.53 | 8.0692 | MARKET TRADE
4 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND-LONG TERM | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 600000 | 60318000 | 100.53 | 8.0692 | MARKET TRADE
5 | GOI 8.19%  16/01/2020 | IN0020110071 | SBI SHORT HORI DEBT FUND-SHORTTERM | 16-JAN-2020 | 2738 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 500000 | 50160000 | 100.32 | 8.1319 | MARKET TRADE
6 | GOI 8.19%  16/01/2020 | IN0020110071 | SBI SHORT HORI DEBT FUND-SHORTTERM | 16-JAN-2020 | 2738 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 1000000 | 100320000 | 100.32 | 8.1319 | MARKET TRADE
7 | CORPORATION BANK CD MAT. 25.03.2013 | INE112A16BF0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 250 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 2500 | 235311750 | 94124.7 | 9.15 | MARKET TRADE
8 | CORPORATION BANK CD MAT. 25.03.2013 | INE112A16BF0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 250 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 2500 | 235311750 | 94124.7 | 9.15 | MARKET TRADE
9 | PUNJAB NATIONAL BANK CD MAT. 25.03.2013 | INE160A16HL4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 250 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 2500 | 235311750 | 94124.7 | 9.15 | MARKET TRADE
10 | UNION BANK CD MAT. 31.05.2013 | INE692A16BE4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 31-MAY-2013 | 317 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 7500 | 694503000 | 92600.4 | 9.23 | MARKET TRADE
11 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND-LONG TERM | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 600000 | 60288000 | 100.48 | 8.0766 | MARKET TRADE
12 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND - SHORT TERM | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 400000 | 40192000 | 100.48 | 8.0766 | MARKET TRADE
13 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND - SHORT TERM | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 400000 | 40172000 | 100.43 | 8.084 | MARKET TRADE
14 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM INCOME FUND - 1998 | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 1100000 | 110473000 | 100.43 | 8.084 | MARKET TRADE
15 | GOI 8.33%  09/07/2026 | IN0020120039 | SBI DYNAMIC BOND FUND | 09-JUL-2026 | 5104 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 2500000 | 253212500 | 101.29 | 8.1734 | MARKET TRADE
16 | GOI 8.28%  21/09/2027 | IN0020070069 | SBI SHORT HORI DEBT FUND-SHORTTERM | 21-SEP-2027 | 5543 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 500000 | 49757500 | 99.52 | 8.3346 | MARKET TRADE
17 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6714 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 2500000 | 262250000 | 104.9 | 8.4388 | MARKET TRADE
18 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6714 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 1000000 | 104920000 | 104.92 | 8.4367 | MARKET TRADE
19 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6714 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 500000 | 52462500 | 104.93 | 8.4362 | MARKET TRADE
20 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6714 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 500000 | 52463750 | 104.93 | 8.4359 | MARKET TRADE
21 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 1000000 | 100550000 | 100.55 | 8.0663 | MARKET TRADE
22 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3615 | T+1 | 18-JUL-2012 | 18-JUL-2012 | 19-JUL-2012 | 500000 | 50275000 | 100.55 | 8.0663 | MARKET TRADE
23 | ANDHRA BANK CD MAT. DT. 28.12.2012 | INE434A16AW5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-DEC-2012 | 162 | T+0 | 19-JUL-2012 | 19-JUL-2012 | 19-JUL-2012 | 5000 | 480712500 | 96142.5 | 9.04 | MARKET TRADE
24 | NATIONAL HOUSING BANK 9.40%  10.01.2015 | INE557F08EB5 | SBI SHORT HORI DEBT FUND-SHORTTERM | 10-JAN-2015 | 905 | T+0 | 19-JUL-2012 | 19-JUL-2012 | 19-JUL-2012 | 50 | 50198300 | 1003966 | 9.1715 | MARKET TRADE
25 | PIRAMAL HEALTHCARE LIMITED CP MAT 09.10.12 | INE140A14126 | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 09-OCT-2012 | 82 | T+0 | 19-JUL-2012 | 19-JUL-2012 | 19-JUL-2012 | 270 | 132210900 | 489670 | 9.3902 | MARKET TRADE
26 | ICICI BANK LTD CD MAT 17.07.2013 | INE090A16VL4 | SBI DEBT FUND SERIES - 366 DAYS - 9 (17.07.2012) | 17-JUL-2013 | 363 | T+0 | 19-JUL-2012 | 19-JUL-2012 | 19-JUL-2012 | 1100 | 100687400 | 91534 | 9.3 | MARKET TRADE
27 | AXIS BANK CD MAT. 17.07.2013 | INE238A16QO3 | SBI DEBT FUND SERIES - 366 DAYS - 9 (17.07.2012) | 17-JUL-2013 | 363 | T+0 | 19-JUL-2012 | 19-JUL-2012 | 19-JUL-2012 | 1100 | 100687400 | 91534 | 9.3 | MARKET TRADE
28 | PIRAMAL HEALTHCARE LIMITED CP MAT 09.10.12 | INE140A14126 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 09-OCT-2012 | 82 | T+0 | 19-JUL-2012 | 19-JUL-2012 | 19-JUL-2012 | 730 | 357459100 | 489670 | 9.3902 | MARKET TRADE
Note: | Value of the trade is based on the clean price.
 | Repo/CBLO and Fixed Deposits trades as not valued have not be reported.
 | Report is on Transaction level basis.