{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Working Sheet","Eligible Issuer & ISIN"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Working Sheet","index":0,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,3,1]]}
["ISSUER Core SGF Payable Calculator"]
["NOTE: Please enter data only in the boxes highlighted in Green."]
[]
[]
[]
[]
["Eligible Issuer"]
["ISIN","INE000000000"]
["Eligible /Ineligible",{"$f":"IF(IF(B11=\"Yes\",\"Yes\",IF(B11=VLOOKUP(B7,'Eligible Issuer & ISIN'!B:F,5,0),\"Yes\",\"No\"))&IF(B12=\"Yes\",\"Yes\",IF(B13=VLOOKUP(B7,'Eligible Issuer & ISIN'!B:E,4,0),\"Yes\",\"No\"))&IF(B15=\"Fixed\",\"Yes\",IF(B16=\"FRB\",\"Yes\",\"No\"))=\"YesYesYes\",\"Eligible\",\"Ineligible\")","v":"Eligible"}]
["Issuer Long Term Credit Rating",{"$f":"IFERROR(VLOOKUP('Working Sheet'!B7,'Eligible Issuer & ISIN'!$B:$D,3,0),\"\")","v":""}]
["Secured","Yes"]
["Senior","Yes"]
["Subordiante Tier 2","Yes"]
["Tier 1","No"]
["Fixed/Floating","Fixed","FRB other than market linked benchmarks namely G-Sec, T-Bill, MIBOR\nand Repo Policy Rate."]
["MLD/FRB","FRB"]
["Issue (Allotment) Date "]
["Maturity Date"]
["Quantity"]
["Face value"]
["Issuance Amount in Rs. Crore",{"$f":"IF(B9=\"Ineligible\",\"0\",B19*B20/10000000)","v":0}]
["Core SGF Payable Amount in Rs.",{"$f":"ROUND(SUM(Table1[Column10])*10000000,0)","v":0}]
[]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Start","End","Calendar year start","Calendar year End","No. of Days  in period","No. of Days in calendar year ","Actual /actual","Core SGF charge","Issuance Amiunt in Crore ","Core SGF Contribution"]
[{"$f":"B17","v":"00:00:00"},{"$f":"IF($B$18<=D26,$B$18-1,D26)","v":-1},{"$f":"DATE(YEAR(A26),1,1)","v":"1900-01-01"},{"$f":"DATE(YEAR(C26)+1,1,1)-1","v":"1900-12-31"},{"$f":"IF(B26-A26+1 < 0,0,B26-A26+1)","v":0},{"$f":"D26-C26+1","v":366},{"$f":"E26/F26","v":0},5.0000000000000002E-5,{"$f":"$B$21","v":0},{"$f":"I26*H26*G26","v":0}]
[{"$f":"IF(AND($B$17>=C27,$B$17<=D27),B17,C27)","v":"1901-01-01"},{"$f":"IF($B$18<=D27,$B$18-1,D27)","v":-1},{"$f":"D26+1","v":"1901-01-01"},{"$f":"DATE(YEAR(C27)+1,1,1)-1","v":"1901-12-31"},{"$f":"IF(B27-A27+1 < 0,0,B27-A27+1)","v":0},{"$f":"D27-C27+1","v":365},{"$f":"E27/F27","v":0},5.0000000000000002E-5,{"$f":"$B$21","v":0},{"$f":"I27*H27*G27","v":0}]
[{"$f":"IF(AND($B$17>=C28,$B$17<=D28),B18,C28)","v":"1902-01-01"},-1,{"$f":"D27+1","v":"1902-01-01"},"1902-12-31",0,365,0,5.0000000000000002E-5,0,0]
[{"$f":"IF(AND($B$17>=C29,$B$17<=D29),B21,C29)","v":"1903-01-01"},-1,"1903-01-01","1903-12-31",0,365,0,5.0000000000000002E-5,0,0]
[{"$f":"IF(AND($B$17>=C30,$B$17<=D30),#REF!,C30)","v":"1904-01-01"},-1,"1904-01-01","1904-12-31",0,366,0,5.0000000000000002E-5,0,0]
[{"$f":"IF(AND($B$17>=C31,$B$17<=D31),B24,C31)","v":"1905-01-01"},-1,"1905-01-01","1905-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1906-01-01",-1,"1906-01-01","1906-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1907-01-01",-1,"1907-01-01","1907-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1908-01-01",-1,"1908-01-01","1908-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1909-01-01",-1,"1909-01-01","1909-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1910-01-01",-1,"1910-01-01","1910-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1911-01-01",-1,"1911-01-01","1911-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1912-01-01",-1,"1912-01-01","1912-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1913-01-01",-1,"1913-01-01","1913-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1914-01-01",-1,"1914-01-01","1914-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1915-01-01",-1,"1915-01-01","1915-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1916-01-01",-1,"1916-01-01","1916-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1917-01-01",-1,"1917-01-01","1917-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1918-01-01",-1,"1918-01-01","1918-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1919-01-01",-1,"1919-01-01","1919-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1920-01-01",-1,"1920-01-01","1920-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1921-01-01",-1,"1921-01-01","1921-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1922-01-01",-1,"1922-01-01","1922-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1923-01-01",-1,"1923-01-01","1923-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1924-01-01",-1,"1924-01-01","1924-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1925-01-01",-1,"1925-01-01","1925-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1926-01-01",-1,"1926-01-01","1926-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1927-01-01",-1,"1927-01-01","1927-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1928-01-01",-1,"1928-01-01","1928-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1929-01-01",-1,"1929-01-01","1929-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1930-01-01",-1,"1930-01-01","1930-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1931-01-01",-1,"1931-01-01","1931-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1932-01-01",-1,"1932-01-01","1932-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1933-01-01",-1,"1933-01-01","1933-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1934-01-01",-1,"1934-01-01","1934-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1935-01-01",-1,"1935-01-01","1935-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1936-01-01",-1,"1936-01-01","1936-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1937-01-01",-1,"1937-01-01","1937-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1938-01-01",-1,"1938-01-01","1938-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1939-01-01",-1,"1939-01-01","1939-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1940-01-01",-1,"1940-01-01","1940-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1941-01-01",-1,"1941-01-01","1941-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1942-01-01",-1,"1942-01-01","1942-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1943-01-01",-1,"1943-01-01","1943-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1944-01-01",-1,"1944-01-01","1944-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1945-01-01",-1,"1945-01-01","1945-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1946-01-01",-1,"1946-01-01","1946-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1947-01-01",-1,"1947-01-01","1947-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1948-01-01",-1,"1948-01-01","1948-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1949-01-01",-1,"1949-01-01","1949-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1950-01-01",-1,"1950-01-01","1950-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1951-01-01",-1,"1951-01-01","1951-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1952-01-01",-1,"1952-01-01","1952-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1953-01-01",-1,"1953-01-01","1953-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1954-01-01",-1,"1954-01-01","1954-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1955-01-01",-1,"1955-01-01","1955-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1956-01-01",-1,"1956-01-01","1956-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1957-01-01",-1,"1957-01-01","1957-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1958-01-01",-1,"1958-01-01","1958-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1959-01-01",-1,"1959-01-01","1959-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1960-01-01",-1,"1960-01-01","1960-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1961-01-01",-1,"1961-01-01","1961-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1962-01-01",-1,"1962-01-01","1962-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1963-01-01",-1,"1963-01-01","1963-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1964-01-01",-1,"1964-01-01","1964-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1965-01-01",{"$f":"IF($B$18<=D91,$B$18-1,D91)","v":-1},"1965-01-01",{"$f":"DATE(YEAR(C91)+1,1,1)-1","v":"1965-12-31"},{"$f":"IF(B91-A91+1 < 0,0,B91-A91+1)","v":0},{"$f":"D91-C91+1","v":365},{"$f":"E91/F91","v":0},5.0000000000000002E-5,{"$f":"$B$21","v":0},{"$f":"I91*H91*G91","v":0}]
[{"$f":"IF(AND($B$17>=C92,$B$17<=D92),B85,C92)","v":"1966-01-01"},-1,{"$f":"D91+1","v":"1966-01-01"},"1966-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1967-01-01",-1,"1967-01-01","1967-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1968-01-01",-1,"1968-01-01","1968-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1969-01-01",-1,"1969-01-01","1969-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1970-01-01",-1,"1970-01-01","1970-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1971-01-01",-1,"1971-01-01","1971-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1972-01-01",-1,"1972-01-01","1972-12-31",0,366,0,5.0000000000000002E-5,0,0]
["1973-01-01",-1,"1973-01-01","1973-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1974-01-01",-1,"1974-01-01","1974-12-31",0,365,0,5.0000000000000002E-5,0,0]
["1975-01-01",-1,"1975-01-01","1975-12-31",0,{"$f":"D101-C101+1","v":365},{"$f":"E101/F101","v":0},5.0000000000000002E-5,0,{"$f":"I101*H101*G101","v":0}]
[null,null,null,null,null,null," "]

{"sheet":"Eligible Issuer & ISIN","index":1,"n_rows":152,"n_cols":7,"rows_kept":152,"cut":false,"hidden":true,"merged":[]}
[]
["Sr. no","Issuer name","SECTOR","Rating","Senior/Tier 2","Secured"]
[1,"AADHAR HOUSING FINANCE LIMITED","NBHFC","AA","Senior",{"$f":"IF(D3=\"AAA\",\"No\",\"Yes\")","v":"Yes"},"Fixed"]
[2,"ADITYA BIRLA CAPITAL LIMITED","NBHFC","AAA","Senior",{"$f":"IF(D4=\"AAA\",\"No\",\"Yes\")","v":"No"},"Floating"]
[3,"ADITYA BIRLA HOUSING FINANCE LIMITED","NBHFC","AAA","Senior","No","FRB"]
[4,"ADITYA BIRLA MONEY LIMITED","CORP","AA+","Senior","Yes","MLD"]
[5,"ADITYA BIRLA SUN LIFE INSURANCE COMPANY LIMITED","CORP","AA+","Senior","Yes","Yes"]
[6,"ALEMBIC PHARMACEUTICALS LIMITED","CORP","AA+","Senior","Yes","No"]
[7,"ANZEN INDIA ENERGY YIELD PLUS TRUST","CORP","AAA","Senior","No"]
[8,"APOLLO TYRES LIMITED","CORP","AA+","Senior","Yes"]
[9,"ASHOK LEYLAND LIMITED","CORP","AA+","Senior","Yes"]
[10,"AU SMALL FINANCE BANK LIMITED","PSBFI","AA","Senior","Yes"]
[11,"AVENUE SUPERMARTS LIMITED","CORP","AAA","Senior","No"]
[12,"AXIS BANK LIMITED","PSBFI","AAA","Yes","No"]
[13,"AXIS FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[14,"BAJAJ FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[15,"BAJAJ HOUSING FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[16,"BALKRISHNA INDUSTRIES LIMITED","CORP","AA","Senior","Yes"]
[17,"BANK OF BARODA","PSBFI","AAA","Yes","No"]
[18,"BANK OF INDIA","PSBFI","AA+","Senior","Yes"]
[19,"BANK OF MAHARASHTRA","PSBFI","AA+","Senior","Yes"]
[20,"BHARAT FORGE LIMITED","CORP","AA+","Senior","Yes"]
[21,"BHARAT PETROLEUM CORPORATION LIMITED","PSBFI","AAA","Yes","No"]
[22,"BLUE STAR LIMITED","CORP","AA+","Senior","Yes"]
[23,"BRITANNIA INDUSTRIES LIMITED","CORP","AAA","Senior","No"]
[24,"CAN FIN HOMES LIMITED","NBHFC","AA+","Senior","Yes"]
[25,"CANARA BANK","PSBFI","AAA","Yes","No"]
[26,"CEAT LIMITED","CORP","AA","Senior","Yes"]
[27,"CHENNAI PETROLEUM CORPORATION LIMITED","PSBFI","AAA","Yes","No"]
[28,"CHOLAMANDALAM INVESTMENT AND FINANCE COMPANY LIMITED","NBHFC","AA+","Senior","Yes"]
[29,"CITICORP FINANCE (INDIA) LIMITED","NBHFC","AAA","Senior","No"]
[30,"COCHIN SHIPYARD LIMITED","PSBFI","AAA","Yes","No"]
[31,"COROMANDEL INTERNATIONAL LIMITED","CORP","AAA","Senior","No"]
[32,"CROMPTON GREAVES CONSUMER ELECTRICALS LIMITED","CORP","AA+","Senior","Yes"]
[33,"DABUR INDIA LIMITED","CORP","AAA","Senior","No"]
[34,"DAMODAR VALLEY CORPORATION","PSBFI","AAA","Yes","No"]
[35,"EMBASSY OFFICE PARKS REIT","CORP","AAA","Senior","No"]
[36,"EPL LIMITED","CORP","AA+","Senior","Yes"]
[37,"EXPORT IMPORT BANK OF INDIA","PSBFI","AAA","Yes","No"]
[38,"FOOD CORPORATION OF INDIA","PSBFI","AAA","Yes","No"]
[39,"G R INFRAPROJECTS LIMITED","CORP","AA","Senior","Yes"]
[40,"GAIL INDIA LIMITED","PSBFI","AAA","Yes","No"]
[41,"GATEWAY DISTRIPARKS LIMITED","CORP","AA","Senior","Yes"]
[42,"GIC HOUSING FINANCE LIMTED","NBHFC","AA+","Senior","Yes"]
[43,"GODREJ PROPERTIES LIMITED","CORP","AA+","Senior","Yes"]
[44,"GRASIM INDUSTRIES LIMITED","CORP","AAA","Senior","No"]
[45,"GUJARAT FLUOROCHEMICALS LIMITED","CORP","AA+","Senior","Yes"]
[46,"HDB FINANCIAL SERVICES LIMITED","NBHFC","AAA","Senior","No"]
[47,"HDFC BANK LIMITED","PSBFI","AAA","Yes","No"]
[48,"HDFC ERGO GENERAL INSURANCE COMPANY LIMITED","CORP","AAA","Yes","No"]
[49,"HDFC LIFE INSURANCE COMPANY LIMITED","CORP","AAA","Yes","No"]
[50,"HINDUSTAN ZINC LIMITED","CORP","AAA","Senior","No"]
[51,"HOUSING AND URBAN DEVELOPMENT CORPORATION LIMITED","PSBFI","AAA","Yes","No"]
[52,"ICICI BANK LIMITED","PSBFI","AAA","Yes","No"]
[53,"ICICI HOME FINANCE COMPANY LIMITED","NBHFC","AAA","Senior","No"]
[54,"ICICI LOMBARD GENERAL INSURANCE COMPANY LIMITED ","CORP","AAA","Yes","No"]
[55,"ICICI PRUDENTIAL LIFE INSURANCE COMPANY LIMITED","CORP","AAA","Yes","No"]
[56,"ICICI SECURITIES LIMITED","CORP","AAA","Senior","No"]
[57,"ICICI SECURITIES PRIMARY DEALERSHIP LIMITED","CORP","AAA","Senior","No"]
[58,"IDFC FIRST BANK LIMITED","PSBFI","AA+","Senior","Yes"]
[59,"INDIA INFRADEBT LIMITED","NBHFC","AAA","Senior","No"]
[60,"INDIA INFRASTRUCTURE FINANCE COMPANY LIMITED","PSBFI","AAA","Yes","No"]
[61,"INDIAN BANK","PSBFI","AAA","Yes","No"]
[62,"INDIAN OIL CORPORATION LIMITED","PSBFI","AAA","Yes","No"]
[63,"INDIAN RAILWAY FINANCE CORPORATION LIMITED","PSBFI","AAA","Yes","No"]
[64,"INDIAN RENEWABLE ENERGY DEVELOPMENT AGENCY LIMITED","PSBFI","AAA","Yes","No"]
[65,"INDIGRID INFRASTRUCTURE TRUST","CORP","AAA","Senior","No"]
[66,"INDUS TOWERS LIMITED","CORP","AA+","Senior",{"$f":"IF(D68=\"AAA\",\"No\",\"Yes\")","v":"Yes"}]
[67,"INDUSIND BANK LIMITED","PSBFI","AA+","Senior","Yes"]
[68,"J.K.CEMENT LIMITED","CORP","AA+","Senior","Yes"]
[69,"JAGRAN PRAKASHAN LIMITED","CORP","AA+","Senior","Yes"]
[70,"JAMNAGAR UTILITIES & POWER PRIVATE LIMITED","CORP","AAA","Senior","No"]
[71,"JIO CREDIT LIMITED","NBHFC","AAA","Senior","No"]
[72,"JOHN DEERE FINANCIAL INDIA PRIVATE LIMITED","NBHFC","AAA","Senior","No"]
[73,"JSW ENERGY LIMITED","CORP","AA","Senior","Yes"]
[74,"JSW STEEL LIMITED","CORP","AA","Senior","Yes"]
[75,"KALPATARU PROJECTS INTERNATIONAL LIMITED","CORP","AA","Senior","Yes"]
[76,"KIRLOSKAR FERROUS INDUSTRIES LIMITED","CORP","AA","Senior","Yes"]
[77,"KOTAK INFRASTRUCTURE DEBT FUND LIMITED","NBHFC","AAA","Senior","No"]
[78,"KOTAK MAHINDRA BANK LIMITED","PSBFI","AAA","Yes","No"]
[79,"KOTAK MAHINDRA INVESTMENTS LIMITED","NBHFC","AAA","Senior","No"]
[80,"KOTAK MAHINDRA PRIME LIMITED","NBHFC","AAA","Senior","No"]
[81,"L&T FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[82,"LARSEN AND TOUBRO LIMITED","CORP","AAA","Senior","No"]
[83,"LIC HOUSING FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[84,"MAHINDRA AND MAHINDRA FINANCIAL SERVICES LIMITED","NBHFC","AAA","Senior","No"]
[85,"MAHINDRA AND MAHINDRA LIMITED","CORP","AAA","Senior","No"]
[86,"MANAPPURAM FINANCE LIMITED","NBHFC","AA","Senior","Yes"]
[87,"MINDSPACE BUSINESS PARKS REIT","CORP","AAA","Senior","No"]
[88,"MRF LIMITED","CORP","AAA","Senior","No"]
[89,"MUTHOOT FINANCE LIMITED","NBHFC","AA+","Senior","Yes"]
[90,"NATIONAL BANK FOR AGRICULTURE AND RURAL DEVELOPMENT","PSBFI","AAA","Yes","No"]
[91,"NATIONAL BANK FOR FINANCING INFRASTRUCTURE AND DEVELOPMENT","PSBFI","AAA","Yes","No"]
[92,"NATIONAL HIGHWAYS AUTHORITY OF INDIA","PSBFI","AAA","Yes","No"]
[93,"NATIONAL HIGHWAYS INFRA TRUST","CORP","AAA","Senior","No"]
[94,"NATIONAL HOUSING BANK","PSBFI","AAA","Yes","No"]
[95,"NHPC LIMITED","PSBFI","AAA","Yes","No"]
[96,"NIIF INFRASTRUCTURE FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[97,"NLC INDIA LIMITED","PSBFI","AAA","Yes","No"]
[98,"NOMURA FIXED INCOME SECURITIES LIMITED","NBHFC","AAA","Senior","No"]
[99,"NORTH EASTERN ELECTRIC POWER CORPORATION LIMITED","PSBFI","AA+","Senior","Yes"]
[100,"NTPC LIMITED","PSBFI","AAA","Yes","No"]
[101,"NUCLEAR POWER CORPORATION OF INDIA LIMITED","PSBFI","AAA","Yes","No"]
[102,"OBEROI REALTY LIMITED","CORP","AA+","Senior","Yes"]
[103,"OIL AND NATURAL GAS CORPORATION LIMITED","PSBFI","AAA","Yes","No"]
[104,"PNB HOUSING FINANCE LIMITED","NBHFC","AA+","Senior","Yes"]
[105,"POWER FINANCE CORPORATION LIMITED","PSBFI","AAA","Yes","No"]
[106,"POWER GRID CORPORATION OF INDIA LIMITED","PSBFI","AAA","Yes","No"]
[107,"PUNJAB NATIONAL BANK","PSBFI","AAA","Yes","No"]
[108,"REC LIMITED","PSBFI","AAA","Yes","No"]
[109,"RELIANCE INDUSTRIES LIMITED","CORP","AAA","Senior","No"]
[110,"RELIANCE JIO INFOCOMM LIMITED","CORP","AAA","Senior","No"]
[111,"SAMVARDHANA MOTHERSON INTERNATIONAL LIMITED","CORP","AAA","Senior","No"]
[112,"SBI CARDS AND PAYMENT SERVICES LIMITED","NBHFC","AAA","Senior","No"]
[113,"SBI GENERAL INSURANCE COMPANY LIMITED","CORP","AAA","Yes","No"]
[114,"SBI GLOBAL FACTORS LIMITED","NBHFC","AAA","Senior","No"]
[115,"SHREE CEMENT LIMITED","CORP","AAA","Senior","No"]
[116,"SHRIRAM FINANCE LIMITED","NBHFC","AA+","Senior","Yes"]
[117,"SIKKA PORTS & TERMINALS LIMTED","CORP","AAA","Senior","No"]
[118,"SJVN LIMITED","PSBFI","AA+","Senior","Yes"]
[119,"SMALL INDUSTRIES DEVELOPMENT BANK OF INDIA","PSBFI","AAA","Yes","No"]
[120,"SMFG INDIA CREDIT COMPANY LIMITED","NBHFC","AAA","Senior","No"]
[121,"SMFG INDIA HOME FINANCE COMPANY LIMITED","NBHFC","AAA","Senior","No"]
[122,"SRF LIMITED","CORP","AA+","Senior","Yes"]
[123,"STANDARD CHARTERED CAPITAL LIMITED","NBHFC","AAA","Senior","No"]
[124,"STATE BANK OF INDIA","PSBFI","AAA","Yes","No"]
[125,"STEEL AUTHORITY OF INDIA LIMITED","PSBFI","AA","Senior","Yes"]
[126,"SUNDARAM FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[127,"SUNDARAM HOME FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[128,"TATA AIG GENERAL INSURANCE COMPANY LIMITED","CORP","AA+","Yes","Yes"]
[129,"TATA CAPITAL HOUSING FINANCE LIMITED","NBHFC","AAA","Senior","No"]
[130,"TATA CAPITAL LIMITED","NBHFC","AAA","Senior",{"$f":"IF(D132=\"AAA\",\"No\",\"Yes\")","v":"No"}]
[131,"TATA COMMUNICATIONS LIMITED","CORP","AAA","Senior","No"]
[132,"TATA CONSUMER PRODUCTS LIMITED","CORP","AAA","Senior","No"]
[133,"TATA INVESTMENT CORPORATION LIMTED","CORP","AAA","Senior","No"]
[134,"TATA STEEL LIMITED","CORP","AA+","Senior","Yes"]
[135,"THDC INDIA LIMITED","PSBFI","AA","Senior","Yes"]
[136,"THE FEDERAL BANK LIMITED","PSBFI","AA+","Senior","Yes"]
[137,"THE GREAT EASTERN SHIPPING COMPANY LIMITED","CORP","AA+","Senior","Yes"]
[138,"THE RAMCO CEMENTS LIMITED","CORP","AA+","Senior","Yes"]
[139,"THE TATA POWER COMPANY LIMITED","CORP","AA+","Senior","Yes"]
[140,"TITAN COMPANY LIMITED","CORP","AAA","Senior","No"]
[141,"TORRENT PHARMACEUTICALS LIMITED","CORP","AA+","Senior","Yes"]
[142,"TORRENT POWER LIMITED","CORP","AA+","Senior","Yes"]
[143,"TRENT LIMITED","CORP","AA+","Senior","Yes"]
[144,"TVS MOTOR COMPANY LIMITED","CORP","AA+","Senior","Yes"]
[145,"ULTRATECH CEMENT LIMITED","CORP","AAA","Senior","No"]
[146,"UNION BANK OF INDIA","PSBFI","AAA","Yes","No"]
[147,"TATA POWER RENEWABLE ENERGY LIMITED","CORP","AA+","Senior","Yes"]
[148,"SOLAR ENERGY CORPORATION OF INDIA LIMITED","PSBFI","AAA","Yes","No"]
[149,"NUMALIGARH REFINERY LIMITED","PSBFI","AAA","Yes","No"]
[150,"RASHTRIYA CHEMICALS AND FERTILIZERS LIMITED","PSBFI","AA","Senior","Yes"]