Excel provides several add-in functions that let you make yield calculations forsecurities such as bonds more easily. The functions can be challenging to use, however, explains the CPA author of the MBA’s Guide to Microsoft Excel.
Excel provides five functions that let you make price calculations for securities such as bonds more easily: YIELD, YIELDDISC, ODDFYIELD, ODDLYIELD, and ODDLYIELD. (Excel’s online help file supplies the actual formulas used for many of these yield functions.)
Some Background Info on the Yield Functions
As a group, the functions use a set of standard arguments: