Returns the total interest included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate. Returns the number of coupons remaining to be paid between the settlement date and the maturity date. Returns the number of days between the settlement date and the end of the coupon period in which settlement occurs.
Returns the number of days in the coupon period in which settlement occurs. Returns the number of days between the beginning of the coupon period in which settlement occurs and the settlement date. BONDMDURATIONĬalculates the modified weighted average of the present value of the cash flows for an assumed par value of $100. BONDDURATIONĬalculates the weighted average of the present value of the cash flows for an assumed par value of $100. ACCRINTMĬalculates the total accrued interest added to the purchase price of a security and paid to the seller when the security pays interest only at maturity. Calculates the accrued interest added to the purchase price of a security and paid to the seller when the security pays periodic interest.
0 kommentar(er)
