def calc_excel_npv(rate, values): orig_npv = np.npv(rate, values) excel_npv = orig_npv/(1+rate) return excel_npv