New to Telerik Document Processing? Start a free 30-day trial

Ispmt

Class

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.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class Ispmt : NumbersInFunction

Inheritance: objectFunctionBaseFunctionWithArgumentsFunctionWithSameTypeArguments<double>NumbersInFunctionIspmt...

Inherited Members NumbersInFunction.ArgumentConversionRulesFunctionWithSameTypeArguments<double>.EvaluateOverride(FunctionEvaluationContext<object>)FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<RadExpression>)FunctionWithArguments.EvaluateLiftedElement(FunctionEvaluationContext<RadExpression>, RadExpression[], int, int)FunctionBase.IsSpillingArgument(int, RadExpression)FunctionBase.Evaluate(FunctionEvaluationContext<RadExpression>)FunctionBase.IsArgumentNumberValid(int)FunctionBase.LiftsOverArrays...

Constructors

Ispmt()

Initializes a new ISPMT function instance for calculating interest payments with Lotus 1-2-3 semantics.

public Ispmt()

Fields

FunctionName

string

The name of the function.

public static readonly string FunctionName

Properties

FunctionInfo

Provides metadata including category, description, and argument definitions.

public override FunctionInfo FunctionInfo { get; }

Property Value:

The function info as FunctionInfo.

Overrides: FunctionBase.FunctionInfo

Name

string

Returns the function identifier "ISPMT".

public override string Name { get; }

Property Value:

The name as String.

Overrides: FunctionBase.Name

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.

protected override RadExpression EvaluateOverride(FunctionEvaluationContext<double> context)

Parameters:contextFunctionEvaluationContext<double>

The context.

Returns:

RadExpression

Functions result as RadExpression.

Overrides: FunctionWithSameTypeArguments<double>.EvaluateOverride(FunctionEvaluationContext<double>)