In this formula 7 items , you have to noted . Understand these one by one

Issue → is the issue date of the security.First_interest → is the first interest date of the security.Settlement → is the maturity date.Rate → is the annual nominal rate of interest (coupon interest rate).Par → is the par value of the security.Frequency → is the number of interest payments per year (1, 2 or 4).Basis → is chosen from a list of options and indicates how the year is to be calculated.[Special Note : The basis argument specifies the number of days in the month and in the year assumed for the date calculations. You specify the basis as 0 for the US (or NASD) version of 30 days in a month and 360 days in a year; as 1 for the actual number of days in the month and year; 2 for the actual number of days in the month but 360 days in a year; 3 for the actual number of days in the month and 365 days in a year; and 4 for the European version of 30 days in a month and 360 days in a year. Thanks Stephen L. Nelson for telling about basis in Using Microsoft Excel's Accrued Interest Add-In Functions]

For ExampleIf you want to calculate the accrued interest on a bond that was issued on March 8, 1999, first paid interest on May 8, 1999, was purchased on June 23, 2000, pays an 10% coupon, shows a $2,000 par value, pays interest two times a year, and uses the US, or NASD, day-count-basis assumption, you use the following formula:

Not found any lectureVIEW ALLReadmoreReplyCancel replyDeleteByHomePAGESLecturesView AllRECOMMENDED FOR YOUCategoryARCHIVESEARCHALL LecturesNot found any lecture match with your request, please help to write it and send it to our email at vinod@svtuition.org for making this website free accounting and finance encyclopedia.Back HomeSundayMondayTuesdayWednesdayThursdayFridaySaturdaySunMonTueWedThuFriSatJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanFebMarAprMayJunJulAugSepOctNovDecjust now1 minute ago$$1$$ minutes ago1 hour ago$$1$$ hours agoYesterday$$1$$ days ago$$1$$ weeks agomore than 5 weeks agoFollowersFollowTHIS CONTENT IS PREMIUMPlease share to unlock