Written by Determines the final coupon or interest payment date preceding the settlement date.
Determines the total number of coupon payments, or interest disbursements, from the settlement date to the investment’s maturity date.
Determines the upcoming coupon or interest payment date following the settlement date.
Determines the total number of days from the settlement date to the upcoming coupon or interest payment date.
Determines the total number of days in the coupon or interest payment period that includes the specified settlement date.
Determines the number of days from the initial coupon or interest payment to the settlement date.
Calculates the depreciation for a specific accounting period, or the prorated depreciation if the asset is acquired mid-period.
Determines the accrued interest for a security that pays its interest upon maturity.
Determines the interest accumulated on a security that has recurring payments.
Provides unique rows from the given source range while eliminating duplicates. The rows appear in the same order as they first occurred in the source range.