Um, not to be a stickler, but that is coming up with the security's annual
yield, not the security's annual rate.
--
** John C **

"Gary''s Student" wrote:


When plotted it is an absolute straight line!

The function really has the form:
Y = A*X + B
or
X = (Y - B) / A

In F19 & F20:

=C1 The B Factor (53.59741246)
=(C100-C1)/B100 The A Factor (713.6860724)


Finally the way to get the rate that gives you a price of, say, 200:
=(200-F19)/F20 which displays 20.51%