Written by Computes the total interest paid over a specified number of payment periods for an investment, utilizing fixed periodic payments and a stable interest rate.
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.
Returns the initial n entries of a dataset following a sorting operation.
Sorts the rows of a specified array or range based on the values in one or more columns.
Returns a modified version of the source range, displaying only the rows or columns that satisfy the specified criteria.