ClassIspmt
Calculates the interest paid during a specific period of an investment using straight-line amortization, provided for Lotus 1-2-3 compatibility.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Expressions.Functions
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class Ispmt : NumbersInFunction
Inheritance: objectFunctionBaseFunctionWithArgumentsFunctionWithSameTypeArguments<double>NumbersInFunctionIspmt
Inherited Members
Constructors
Ispmt()
Initializes a new ISPMT function instance for calculating interest payments with Lotus 1-2-3 semantics.
Declaration
public Ispmt()
Fields
FunctionName
The name of the function.
Properties
FunctionInfo
Provides metadata including category, description, and argument definitions.
Declaration
public override FunctionInfo FunctionInfo { get; }
Property Value
The function info as FunctionInfo.
Overrides
Methods
EvaluateOverride(FunctionEvaluationContext<double>)
Evaluates the function by computing interest for the specified period using straight-line calculation from rate, period, total periods, and present value.
Declaration
protected override RadExpression EvaluateOverride(FunctionEvaluationContext<double> context)
Parameters
context
FunctionEvaluationContext<double>
The context.
Returns
Functions result as RadExpression.
Overrides