Saturday, October 3, 2009

FinExcelSoft Securities Excel Templates

FinExcelSoft Securities Excel templates - Contains 26 securities Excel templates:
  • templates for coupons (6 templates),
  • templates for price calculation (6 templates),
  • templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.
Free bonus:

10 Annuities Excel templates ann.xls contains Excel templates for: 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.