Our bonus includes 3 Excel workbooks:
- 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.
These workbooks contain Excel templates for most usefull financial functions.