Excel Model - Yield Calc Using Newton's Method


This free spreadsheet model from our Resources page shows how to calculate the yield of a bond issue using standard municipal bond market conventions (30/360 daycount, semi-annual discounting) and Newton's Method to converge. It is the companion model to a video explaining the calculation in detail.  

describe the image