About 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 duratinn for a security.
Our 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. Full instructions.