Class
Ispmt

Calculates the interest paid during a specific period of an investment using straight-line amortization, provided for Lotus 1-2-3 compatibility.

Definition

Constructors

Ispmt()

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

Declaration

cs-api-definition
public Ispmt()

Fields

FunctionName

The name of the function.

Declaration

cs-api-definition
public static readonly string FunctionName

Field Value

string

Properties

FunctionInfo

Provides metadata including category, description, and argument definitions.

Declaration

cs-api-definition
public override FunctionInfo FunctionInfo { get; }

Property Value

FunctionInfo

The function info as FunctionInfo.

Overrides FunctionBase.FunctionInfo

Name

Returns the function identifier "ISPMT".

Declaration

cs-api-definition
public override string Name { get; }

Property Value

string

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.

Declaration

cs-api-definition
protected override RadExpression EvaluateOverride(FunctionEvaluationContext<double> context)

Parameters

context

FunctionEvaluationContext<double>

The context.

Returns

RadExpression

Functions result as RadExpression.

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