Written by Determines the cumulative principal amount paid across a specified range of payment periods for an investment, relying on consistent periodic payments and a stable interest rate.
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 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.