Spreadsheet: 99a41f88-b16a-4870-b781-a845e35748ca
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: 07/05/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 GILT FUND-LONG TERM | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 52025000 | 104.05 | 8.6145 | MARKET TRADE
2 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51970000 | 103.94 | 8.6287 | MARKET TRADE
3 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51970000 | 103.94 | 8.6287 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51975000 | 103.95 | 8.6274 | MARKET TRADE
5 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 2000000 | 206500000 | 103.25 | 8.7179 | MARKET TRADE
6 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM GILT FUND-LONG TERM | 05-DEC-2030 | 6789 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1500000 | 150675000 | 100.45 | 8.9187 | MARKET TRADE
7 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51735000 | 103.47 | 8.6893 | MARKET TRADE
8 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51735000 | 103.47 | 8.6893 | MARKET TRADE
9 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 52025000 | 104.05 | 8.6145 | MARKET TRADE
10 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51975000 | 103.95 | 8.6274 | MARKET TRADE
11 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51920000 | 103.84 | 8.6415 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51920000 | 103.84 | 8.6415 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51800000 | 103.6 | 8.6725 | MARKET TRADE
14 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51773750 | 103.55 | 8.6793 | MARKET TRADE
15 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51800000 | 103.6 | 8.6725 | MARKET TRADE
16 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51773750 | 103.55 | 8.6793 | MARKET TRADE
17 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1000000 | 103450000 | 103.45 | 8.6919 | MARKET TRADE
18 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1000000 | 103450000 | 103.45 | 8.6919 | MARKET TRADE
19 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51750000 | 103.5 | 8.6855 | MARKET TRADE
20 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51725000 | 103.45 | 8.6919 | MARKET TRADE
21 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51750000 | 103.5 | 8.6855 | MARKET TRADE
22 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51750000 | 103.5 | 8.6855 | MARKET TRADE
23 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1000000 | 103500000 | 103.5 | 8.6855 | MARKET TRADE
24 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1500000 | 155272500 | 103.52 | 8.6835 | MARKET TRADE
25 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1000000 | 103550000 | 103.55 | 8.679 | MARKET TRADE
26 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 500000 | 51775000 | 103.55 | 8.679 | MARKET TRADE
27 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1500000 | 155400000 | 103.6 | 8.6725 | MARKET TRADE
28 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1000000 | 103600000 | 103.6 | 8.6725 | MARKET TRADE
29 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1500000 | 155205000 | 103.47 | 8.6893 | MARKET TRADE
30 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4577 | T+1 | 04-MAY-2012 | 04-MAY-2012 | 07-MAY-2012 | 1000000 | 103470000 | 103.47 | 8.6893 | MARKET TRADE
33 | KOTAK MAHINDRA PRIME LTD 0% 07.05.12 | INE916D070G2 | SBI DEBT FUND SERIES - 15 M - 6 (07/02/2011) | 07-MAY-2012 | 0 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 200 | 200000000 | 1000000 | 0 | MARKET TRADE
32 | BAJAJ FINANCE LTD 9.90% 07/05/2012 | INE296A08482 | MAGNUM CHILDREN BENEFIT PLAN | 07-MAY-2012 | 0 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 1 | 10000000 | 10000000 | 0 | MARKET TRADE
31 | BAJAJ FINANCE LTD 9.90% 07/05/2012 | INE296A08482 | SBI DEBT FUND SERIES - 15 M - 6 (07/02/2011) | 07-MAY-2012 | 0 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 17 | 170000000 | 10000000 | 0 | MARKET TRADE
34 | SUNDARAM BNP PARIBAS HOME FINANCE  LTD., 0% 07.05.2012 | INE667F07352 | SBI DEBT FUND SERIES - 15 M - 6 (07/02/2011) | 07-MAY-2012 | 0 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 190 | 190000000 | 1000000 | 0 | MARKET TRADE
35 | KOTAK MAHINDRA BANK CD MAT - 23.07.2012 | INE237A16OK8 | MICF-LIQUID FLOATER PLAN | 23-JUL-2012 | 77 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 500 | 49015611.23626 | 98031.22 | 9.5199 | INTERSCHEME
36 | KOTAK MAHINDRA BANK CD MAT - 23.07.2012 | INE237A16OK8 | MAGNUM INSTACASH FUND | 23-JUL-2012 | 77 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 500 | 49015611.23626 | 98031.22 | 9.5199 | INTERSCHEME
37 | AXIS BANK CD MAT. 23.07.2012 | INE238A16PE6 | MICF-LIQUID FLOATER PLAN | 23-JUL-2012 | 77 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 500 | 49014090.227225 | 98028.18 | 9.5349 | INTERSCHEME
38 | AXIS BANK CD MAT. 23.07.2012 | INE238A16PE6 | MAGNUM INSTACASH FUND | 23-JUL-2012 | 77 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 500 | 49014090.227225 | 98028.18 | 9.5349 | INTERSCHEME
39 | VIJAYA BANK CD MAT 23.07.12 | INE705A16FC9 | MICF-LIQUID FLOATER PLAN | 23-JUL-2012 | 77 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 500 | 49019046.556035 | 98038.09 | 9.4861 | INTERSCHEME
40 | VIJAYA BANK CD MAT 23.07.12 | INE705A16FC9 | MAGNUM INSTACASH FUND | 23-JUL-2012 | 77 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 500 | 49019046.556035 | 98038.09 | 9.4861 | INTERSCHEME
41 | YES BANK CD MAT 23.07.2012 | INE528G16OQ4 | MICF-LIQUID FLOATER PLAN | 23-JUL-2012 | 77 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 500 | 49013578.086255 | 98027.16 | 9.54 | INTERSCHEME
42 | YES BANK CD MAT 23.07.2012 | INE528G16OQ4 | MAGNUM INSTACASH FUND | 23-JUL-2012 | 77 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 500 | 49013578.086255 | 98027.16 | 9.54 | INTERSCHEME
43 | INDIAN OIL [NAME] MAT 27.06.2012 | INE242A14BU9 | MICF-LIQUID FLOATER PLAN | 27-JUN-2012 | 51 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 700 | 345425656.464588 | 493465.22 | 9.4776 | INTERSCHEME
44 | INDIAN OIL [NAME] MAT 27.06.2012 | INE242A14BU9 | MAGNUM INSTACASH FUND | 27-JUN-2012 | 51 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 700 | 345425656.464588 | 493465.22 | 9.4776 | INTERSCHEME
45 | INDIAN OIL [NAME] MAT 27.06.2012 | INE242A14BU9 | SBI PREMIER LIQUID FUND | 27-JUN-2012 | 51 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 800 | 394772178.816672 | 493465.22 | 9.4776 | INTERSCHEME
46 | INDIAN OIL [NAME] MAT 27.06.2012 | INE242A14BU9 | MAGNUM INSTACASH FUND | 27-JUN-2012 | 51 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 800 | 394772178.816672 | 493465.22 | 9.4776 | INTERSCHEME
47 | VIJAYA BANK CD MAT 11.03.13 | INE705A16EK5 | MAGNUM INCOME FUND-FLOATIG RT-LTP | 11-MAR-2013 | 308 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 50 | 4613607.235 | 92272.14 | 9.925 | INTERSCHEME
48 | VIJAYA BANK CD MAT 11.03.13 | INE705A16EK5 | SBI DYNAMIC BOND FUND | 11-MAR-2013 | 308 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 50 | 4613607.235 | 92272.14 | 9.925 | INTERSCHEME
49 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | MAGNUM INCOME FUND-FLOATIG RT-LTP | 21-MAR-2013 | 318 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 35 | 3221442.322 | 92041.21 | 9.925 | INTERSCHEME
50 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI DYNAMIC BOND FUND | 21-MAR-2013 | 318 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 35 | 3221442.322 | 92041.21 | 9.925 | INTERSCHEME
51 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | MAGNUM INCOME FUND-FLOATIG RT-LTP | 15-MAR-2013 | 312 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 30 | 2765388.948 | 92179.63 | 9.925 | INTERSCHEME
52 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI DYNAMIC BOND FUND | 15-MAR-2013 | 312 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 30 | 2765388.948 | 92179.63 | 9.925 | INTERSCHEME
53 | COROMANDEL INTERNATIONAL LTD CP MAT 26.06.2012 | INE169A14679 | SBI PREMIER LIQUID FUND | 26-JUN-2012 | 50 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 1000 | 493343000 | 493343 | 9.8504 | MARKET TRADE
54 | J M FINANCIAL PRODUCTS PVT LTD CP MAT 06.08.2012 | INE523H14EE5 | SBI PREMIER LIQUID FUND | 06-AUG-2012 | 91 | T+0 | 07-MAY-2012 | 07-MAY-2012 | 07-MAY-2012 | 1000 | 486890000 | 486890 | 10.8 | 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.