NPV & IRR Excel Template for Periodic Cash FlowsReady to use Excel Template for NPV & IRR calculations for periodic cash flows in Excel 97 or later. Allows you to evaluate your business. The net present value of an investment is the current value of a future series of payments and receipts.The internal rate of return is the interest rate received for an investment consisting of payments and receipts that occur at regular intervals. Here the short description of NVP/IRR calculation. You define a cash flow in Excel list, enter a rate of interest for NPV calculation, initial rate of interest for IRR calculation, and click on a button. NPV & IRR are calculated automatically and stored in special cells of this template. Also contains the bonus: - MIRR.xls - MIRR (Modified Rate of Return) calculation - Npvirrdate.xls - NPV & IRR calculations for non-periodic cash flows. - finExcelSoft.xls - contains Excel templates for the following more usefull financial functions: NPV, IRR, MIRR, future value of initial principal, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule. finExcelSoft.xls workbook contains also the spreadsheet for easy function navigation in 4 workbooks. Use of some complex financial functions are simplified by VBA procedures. |
|
|
