Clean Price calculation of T/Bond in excel

J

John267

New member
Joined
Aug 5, 2015
Messages
0
Reaction score
0
Excel has inbuilt function “PRICE” to calculate the current price of a bond.I think this price is the dirty price of the bond including accrued interest. How can I calculate the clean price of a bond using excel formula? Description for PRICE in Excel does not provide any information about this.
 
You can use the ACCRINT function to calculate the accrued interest, then subtract that from the dirty price to get the clean price.
 
You must log in or register to reply here.
Back
Top