if c==excelfiles[1]:
    b ==excelfiles[1]
    wb = xlrd.open_workbook(a)
    wb.sheet_names()
    sh = wb.sheet_by_index(0)
    for rownum in range(sh.nrows):
        print sh.row_values(rownum)
 
for i in range(sheet.nrows):
    cashflow = [sheet.cell_value(i,0)],[sheet.cell_value(i,1)],[sheet.cell_value(i,2)]
    print cashflow
 
def npv(rate, cashflow):
    value = cashflow[1] * ((1 + rate/100) ** (12 - cashflow[0]))
    FV = 0
    FV += value
    return FV
 
def irr(cashflow, iterations = 100):
    rate = 1.0
 
    i = 0
    while (cashflow[0][1] == 0):
        i += 1
 
    investment = cashflow[i][1]
 
    for i in range(1, iterations+1):
        rate *= (1 - (npv(rate, cashflow) / investment))
        return rate
 
r = irr(cashflow) # why is list index out of range?
print r
 

aWYgYz09ZXhjZWxmaWxlc1sxXToKICAgIGIgPT1leGNlbGZpbGVzWzFdCiAgICB3YiA9IHhscmQub3Blbl93b3JrYm9vayhhKQogICAgd2Iuc2hlZXRfbmFtZXMoKQogICAgc2ggPSB3Yi5zaGVldF9ieV9pbmRleCgwKQogICAgZm9yIHJvd251bSBpbiByYW5nZShzaC5ucm93cyk6CiAgICAgICAgcHJpbnQgc2gucm93X3ZhbHVlcyhyb3dudW0pCgpmb3IgaSBpbiByYW5nZShzaGVldC5ucm93cyk6CiAgICBjYXNoZmxvdyA9IFtzaGVldC5jZWxsX3ZhbHVlKGksMCldLFtzaGVldC5jZWxsX3ZhbHVlKGksMSldLFtzaGVldC5jZWxsX3ZhbHVlKGksMildCiAgICBwcmludCBjYXNoZmxvdwoKZGVmIG5wdihyYXRlLCBjYXNoZmxvdyk6CiAgICB2YWx1ZSA9IGNhc2hmbG93WzFdICogKCgxICsgcmF0ZS8xMDApICoqICgxMiAtIGNhc2hmbG93WzBdKSkKICAgIEZWID0gMAogICAgRlYgKz0gdmFsdWUKICAgIHJldHVybiBGVgoKZGVmIGlycihjYXNoZmxvdywgaXRlcmF0aW9ucyA9IDEwMCk6CiAgICByYXRlID0gMS4wCiAgICAKICAgIGkgPSAwCiAgICB3aGlsZSAoY2FzaGZsb3dbMF1bMV0gPT0gMCk6CiAgICAgICAgaSArPSAxCiAgICAKICAgIGludmVzdG1lbnQgPSBjYXNoZmxvd1tpXVsxXQogICAgCiAgICBmb3IgaSBpbiByYW5nZSgxLCBpdGVyYXRpb25zKzEpOgogICAgICAgIHJhdGUgKj0gKDEgLSAobnB2KHJhdGUsIGNhc2hmbG93KSAvIGludmVzdG1lbnQpKQogICAgICAgIHJldHVybiByYXRlCgpyID0gaXJyKGNhc2hmbG93KSAjIHdoeSBpcyBsaXN0IGluZGV4IG91dCBvZiByYW5nZT8KcHJpbnQgcgo=