Saturday, October 3, 2009

FinExcelSoft NPV & IRR Excel Templates

FinExcelSoft NPV & IRR Excel templates -

Ready to use 5 Excel templates for NPV/EVA and IRR/MIRR calculation and more.

1. 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.

2. NPV & IRR Excel template for periodic cash flows

3. NPV & IRR Excel Template for a schedule that is not necessarily periodic.

4. MIRR Excel template.

5. Additional Financial Excel Templates. Requires Excel 97 or later.

Additional templates allow:
  • 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.