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.