(C) 2012 - 2017 by Mourad Louha · All rights reserved.

Financial functions

Description

The description for the function ACCRINT is not available yet.

Availability

The ACCRINT function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

ACCRINT(Issue,First_Interest,Settlement,Rate,Par,Frequency,Basis,Calc_method)

Arguments

The ACCRINT has the following arguments. Required arguments are bold.

DesignationDescription
Issue
First_Interest
Settlement
Rate
Par
Frequency
Basis
Calc_method

 


Description

The description for the function ACCRINTM is not available yet.

Availability

The ACCRINTM function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

ACCRINTM(Issue,Settlement,Rate,Par,Basis)

Arguments

The ACCRINTM has the following arguments. Required arguments are bold.

DesignationDescription
Issue
Settlement
Rate
Par
Basis

 


Description

The description for the function AMORDEGRC is not available yet.

Availability

The AMORDEGRC function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

AMORDEGRC(Cost,Date_purchased,First_period,Salvage,Period,Rate,Basis)

Arguments

The AMORDEGRC has the following arguments. Required arguments are bold.

DesignationDescription
Cost
Date_purchased
First_period
Salvage
Period
Rate
Basis

 


Description

The description for the function AMORLINC is not available yet.

Availability

The AMORLINC function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

AMORLINC(Cost,Date_purchased,First_period,Salvage,Period,Rate,Basis)

Arguments

The AMORLINC has the following arguments. Required arguments are bold.

DesignationDescription
Cost
Date_purchased
First_period
Salvage
Period
Rate
Basis

 


Description

The description for the function COUPDAYBS is not available yet.

Availability

The COUPDAYBS function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

COUPDAYBS(Settlement,Maturity,Frequency,Basis)

Arguments

The COUPDAYBS has the following arguments. Required arguments are bold.

DesignationDescription
Settlement
Maturity
Frequency
Basis

 


Description

The description for the function COUPDAYS is not available yet.

Availability

The COUPDAYS function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

COUPDAYS(Settlement,Maturity,Frequency,Basis)

Arguments

The COUPDAYS has the following arguments. Required arguments are bold.

DesignationDescription
Settlement
Maturity
Frequency
Basis

 


Description

The description for the function COUPDAYSNC is not available yet.

Availability

The COUPDAYSNC function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

COUPDAYSNC(Settlement,Maturity,Frequency,Basis)

Arguments

The COUPDAYSNC has the following arguments. Required arguments are bold.

DesignationDescription
Settlement
Maturity
Frequency
Basis

 


Description

The description for the function COUPNCD is not available yet.

Availability

The COUPNCD function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

COUPNCD(Settlement,Maturity,Frequency,Basis)

Arguments

The COUPNCD has the following arguments. Required arguments are bold.

DesignationDescription
Settlement
Maturity
Frequency
Basis

 

 
Top