Help. I am trying to value a treasury bond with
Face Value =1000
Market Price = 960
4 Years until Maturity
Coupon Rate = 7%
When I enter the below code and try to solve for YTM. I get an error saying "runtime error 6 - overflow"
it says it about half way down where "Dif = P - (Cv * SumIt(N...