Spreadsheet: 922d8868-b65a-496f-9719-7406fcb14fad
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: 04/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 8.19%  16/01/2020 | IN0020110071 | SBI SHORT HORI DEBT FUND-SHORTTERM | 16-JAN-2020 | 2753 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 500000 | 49865000 | 99.73 | 8.2377 | MARKET TRADE
2 | GOI 8.19%  16/01/2020 | IN0020110071 | SBI SHORT HORI DEBT FUND-SHORTTERM | 16-JAN-2020 | 2753 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 500000 | 49865000 | 99.73 | 8.2377 | MARKET TRADE
3 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4517 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 1000000 | 105480000 | 105.48 | 8.4255 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4517 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 1500000 | 158220000 | 105.48 | 8.4255 | MARKET TRADE
5 | PUNJAB NATIONAL BANK CD MAT. 25.03.2013 | INE160A16HL4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 265 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 2500 | 234116500 | 93646.6 | 9.38 | MARKET TRADE
6 | CORPORATION BANK CD MAT. 25.03.2013 | INE112A16BF0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 265 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 5000 | 468233000 | 93646.6 | 9.38 | MARKET TRADE
7 | BANK OF INDIA CD MAT. DT. 27.03.2013 | INE084A16808 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-MAR-2013 | 267 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 2500 | 234004000 | 93601.6 | 9.3799 | MARKET TRADE
8 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 15-MAR-2013 | 255 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 5000 | 469393000 | 93878.6 | 9.3701 | MARKET TRADE
9 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2753 | T+1 | 03-JUL-2012 | 03-JUL-2012 | 04-JUL-2012 | 2500000 | 249500000 | 99.8 | 8.225 | MARKET TRADE
10 | POWER FINANCE CORPORATION LTD 89-B 9.46%  02/05/2015 | INE134E08EQ4 | SBI DYNAMIC BOND FUND | 02-MAY-2015 | 1032 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 250 | 249729500 | 998918 | 9.4807 | MARKET TRADE
11 | ING VYSYA BANK CD MAT 28.09.2012 | INE166A16FS0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-SEP-2012 | 86 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 2500 | 244786000 | 97914.4 | 9.0402 | MARKET TRADE
12 | ING VYSYA BANK CD MAT 28.09.2012 | INE166A16FS0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-SEP-2012 | 86 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 7100 | 695192240 | 97914.4 | 9.0402 | MARKET TRADE
13 | SUNDARAM FINANCE LTD CP MAT 28.09.2012 | INE660A14GM8 | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 28-SEP-2012 | 86 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 140 | 68514810 | 489391.5 | 9.2001 | MARKET TRADE
14 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-SEP-2012 | 82 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 2500 | 245080750 | 98032.3 | 8.9345 | MARKET TRADE
15 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-SEP-2012 | 82 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 7500 | 735242250 | 98032.3 | 8.9345 | MARKET TRADE
16 | ING VYSYA BANK CD MAT 28.09.2012 | INE166A16FS0 | MAGNUM INCOME FUND - 1998 | 28-SEP-2012 | 86 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 400 | 39165760 | 97914.4 | 9.0402 | MARKET TRADE
17 | SHRIRAM EQUIPMENT FINANCE CO LTD CP MAT 26.09.12 | INE468M14209 | SBI PREMIER LIQUID FUND | 26-SEP-2012 | 84 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 1000 | 489545000 | 489545 | 9.2799 | MARKET TRADE
18 | COROMANDEL INTERNATIONAL LTD CP MAT 17.09.2012 | INE169A14711 | SBI PREMIER LIQUID FUND | 17-SEP-2012 | 75 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 2000 | 981546000 | 490773 | 9.1498 | MARKET TRADE
19 | TATA CAPITAL FINANCIAL SERVICES LTD CP MAT 25.09.2012 | INE306N14233 | SBI PREMIER LIQUID FUND | 25-SEP-2012 | 83 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 2000 | 979508000 | 489754 | 9.2001 | MARKET TRADE
20 | SUNDARAM FINANCE LTD CP MAT 28.09.2012 | INE660A14GM8 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-SEP-2012 | 86 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 360 | 176180940 | 489391.5 | 9.2001 | MARKET TRADE
21 | MAHINDRA & MAHINDRA FINANCIAL SERVICES LTD CP MAT 22.08.2012 | INE774D14CN8 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 22-AUG-2012 | 49 | T+0 | 04-JUL-2012 | 04-JUL-2012 | 04-JUL-2012 | 2000 | 988259000 | 494129.5 | 8.8498 | 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.