I'm trying to price the following floating rate note:
The price displayed on Bloomberg is 100.103063.
If I pass the following to the PRICE() function in Bloomberg, I get 100.1019629.
=PRICE(Settlement, Maturity, Rate, Yield, Redemption, Frequency, Basis)
Settlement: 11/10/17 Maturity: 4/30/19 Rate: 1.258560% Yield: 1.188560% Redemption: 100 Frequency: 4 Basis 2 (Act/360)
Is it possible to use an Excel function to arrive at that price of 100.103063?