Saturday, October 3, 2009

NPV & IRR Excel Template for Periodic Cash Flows

NPV & IRR Excel Template for Periodic Cash Flows - Ready to use Excel Template for NPV & IRR & EVA 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 is 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:
- evacalc.xls - 5, 10 and 15 Year Project NPV and EVA Calculation. NPV and EVA Excel templates for 2 to 15 period projects. Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.
- 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.