How to Calculate YTM in Excel
We will calculate the YTM at ease, and you need a data that looks like this:
Important Note: It is extremely important that the frequency is 1 – 4, and the basis is 1 – 3. This would guarantee the calculation of the YTM being successful.
Click beside Yield (B11) (1), type
=YIELD(B4;B5;B6;B7;B8;B9;B10) (2), and press enter.
Note: You can now format the yield to any format you want.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
