Spreadsheet: c67a05e6-dab3-41a1-b1f8-7e1767d7fd47
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 | Unnamed: 15
Transaction Date: 10/04/2012
Debt and Money Market Securities Transaction Details
SR. NO. | NAME OF SECURITY | ISIN | FUND HOUSE | 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 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 14/11/2024 | 4601 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 27000000 | 2794095000 | 103.49 | 8.6874 | MARKET TRADE
2 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 14/11/2024 | 4601 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 18000000 | 1862730000 | 103.49 | 8.6874 | MARKET TRADE
3 | 91 DAY TBILL MAT 04.05.12 |  | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 04/05/2012 | 24 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 10000000 | 992798000 | 99.28 | 11.0325 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 14/11/2024 | 4601 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 34500000 | 3570232500 | 103.49 | 8.6874 | MARKET TRADE
5 | 364 DAY TBILL MAT 08.03.2013 |  | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 08/03/2013 | 332 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 16701000 | 1549964696.7 | 92.81 | 8.5213 | MARKET TRADE
6 | 364 DAY TBILL MAT 28.06.2012 |  | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 28/06/2012 | 79 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 9699000 | 949979223.9 | 97.95 | 9.6885 | MARKET TRADE
7 | 364 DAY TBILL MAT 08.03.2013 |  | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 08/03/2013 | 332 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 10236000 | 949969381.2 | 92.81 | 8.5213 | MARKET TRADE
8 | 364 DAY TBILL MAT 25.01.2013 |  | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 25/01/2013 | 290 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 26466000 | 2479914485.4 | 93.7 | 8.4597 | MARKET TRADE
9 | 91 DAY TBILL MAT 09.07.2012 |  | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 09/07/2012 | 90 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 10214000 | 999948557.2 | 97.9 | 8.7002 | MARKET TRADE
10 | EDELWEISS FINANCIAL SERVICES LTD CP MAT 04.06.2012 | INE532F14GM8 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 04/06/2012 | 55 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 500 | 246015000 | 492030 | 10.7497 | MARKET TRADE
11 | BAJAJ  FINANCE LTD 8% 05/07/2012 | INE296A08441 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 05/07/2012 | 86 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 14 | 139074599.0732616 | 9933899.93 | 10.7275 | INTERSCHEME
12 | BAJAJ  FINANCE LTD 8% 05/07/2012 | INE296A08441 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-SHORTTERM | 05/07/2012 | 86 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 14 | 139074599.0732616 | 9933899.93 | 10.7275 | INTERSCHEME
13 | MOTHERSON SUMI SYSTEMS LTD CP MAT 29.06.2012 | INE775A14517 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 29/06/2012 | 80 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 500 | 244680000 | 489360 | 9.9201 | MARKET TRADE
14 | MOTHERSON SUMI SYSTEMS LTD CP MAT 29.06.2012 | INE775A14517 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 29/06/2012 | 80 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 500 | 244680000 | 489360 | 9.9201 | MARKET TRADE
15 | MAHINDRA & MAHINDRA FINANCIAL SERVICES LTD CP MAT 28.06.2012 | INE774D14CI8 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28/06/2012 | 79 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 1000 | 489563000 | 489563 | 9.8499 | MARKET TRADE
16 | MAHINDRA & MAHINDRA FINANCIAL SERVICES LTD CP MAT 28.06.2012 | INE774D14CI8 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 28/06/2012 | 79 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 4000 | 1958252000 | 489563 | 9.8499 | MARKET TRADE
17 | MAHINDRA & MAHINDRA FINANCIAL SERVICES LTD CP MAT 28.06.2012 | INE774D14CI8 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 28/06/2012 | 79 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 1000 | 489563000 | 489563 | 9.8499 | MARKET TRADE
18 | POWER FIN CORP LTD  60-A (1YINCMTBMK+135BPS RESET) 20/11/2012 | INE134E08CJ3 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 20/11/2012 | 224 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 80 | 79948192.472 | 999352.41 | 0 | INTERSCHEME
19 | POWER FIN CORP LTD  60-A (1YINCMTBMK+135BPS RESET) 20/11/2012 | INE134E08CJ3 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-SHORTTERM | 20/11/2012 | 224 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 80 | 79948192.472 | 999352.41 | 0 | INTERSCHEME
20 | IDBI BANK CD MAT 29.06.2012 | INE008A16HR2 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 29/06/2012 | 80 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 2500 | 244533250 | 97813.3 | 10.1999 | MARKET TRADE
21 | KOTAK MAHINDRA PRIME LTD 0% 21/06/2013 | INE916D076U0 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 15 MONTHS - 10 (22.03.12) | 21/06/2013 | 437 | T+0 | 10/04/2012 | 10/04/2012 | 2012-04-10 00:00:00 | 33 | 29473323 | 893131 | 9.9 | MARKET TRADE
22 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 14/11/2024 | 4601 | T+1 | 10/04/2012 | 10/04/2012 | 2012-04-11 00:00:00 | 500000 | 51940000 | 103.88 | 8.6366 | MARKET TRADE
23 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 14/11/2024 | 4601 | T+1 | 10/04/2012 | 10/04/2012 | 2012-04-11 00:00:00 | 500000 | 51943750 | 103.89 | 8.6356 | MARKET TRADE
24 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 14/11/2024 | 4601 | T+1 | 10/04/2012 | 10/04/2012 | 2012-04-11 00:00:00 | 1000000 | 103890000 | 103.89 | 8.6353 | MARKET TRADE
25 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 14/11/2024 | 4601 | T+1 | 10/04/2012 | 10/04/2012 | 2012-04-11 00:00:00 | 500000 | 51945000 | 103.89 | 8.6353 | MARKET TRADE
26 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 14/11/2024 | 4601 | T+1 | 10/04/2012 | 10/04/2012 | 2012-04-11 00:00:00 | 1000000 | 103895000 | 103.9 | 8.6347 | MARKET TRADE
27 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 14/11/2024 | 4601 | T+1 | 10/04/2012 | 10/04/2012 | 2012-04-11 00:00:00 | 500000 | 51920000 | 103.84 | 8.6417 | 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.