Below is my formula, basically taking the 10Year Bond price from a data point adding a Margin resulting in an end rate, but I want to add a floor or a not less than function to ensure we don’t drop the formula rate below 4.0%
=ROUND('Data Sheet & 10 Year Update'!B20/(1/8)%,0)*(1/8)%
Bookmarks