(C) 2012 - 2018 by Mourad Louha · All rights reserved.
Privacy  ·  Imprint

Financial functions

Description

The description for the function DOLLARFR is not available yet.

Availability

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

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

Syntax

DOLLARFR(Decimal_dollar,Fraction)

Arguments

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

DesignationDescription
Decimal_dollar
Fraction

 


Description

The description for the function DURATION is not available yet.

Availability

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

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

Syntax

DURATION(Settlement,Maturity,Coupon,Yld,Frequency,Basis)

Arguments

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

DesignationDescription
Settlement
Maturity
Coupon
Yld
Frequency
Basis

 


EFFECT

Categories: Financial, Functions
Comments: No

Description

The description for the function EFFECT is not available yet.

Availability

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

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

Syntax

EFFECT(Nominal_rate,Npery)

Arguments

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

DesignationDescription
Nominal_rate
Npery

 


FV

Categories: Financial, Functions
Comments: No

Description

The description for the function FV is not available yet.

Availability

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

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

Syntax

FV(Rate,Nper,Rmz,Pv,Type)

Arguments

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

DesignationDescription
Rate
Nper
Rmz
Pv
Type

 


Description

The description for the function FVSCHEDULE is not available yet.

Availability

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

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

Syntax

FVSCHEDULE(Principal,Schedule)

Arguments

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

DesignationDescription
Principal
Schedule

 


Description

The description for the function INTRATE is not available yet.

Availability

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

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

Syntax

INTRATE(Settlement,Maturity,Investment,Redemption,Basis)

Arguments

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

DesignationDescription
Settlement
Maturity
Investment
Redemption
Basis

 


IPMT

Categories: Financial, Functions
Comments: No

Description

The description for the function IPMT is not available yet.

Availability

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

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

Syntax

IPMT(Rate,Per,Nper,Pv,Fv,Type)

Arguments

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

DesignationDescription
Rate
Per
Nper
Pv
Fv
Type

 


IRR

Categories: Financial, Functions
Comments: No

Description

The description for the function IRR is not available yet.

Availability

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

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

Syntax

IRR(Values,Guess)

Arguments

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

DesignationDescription
Values
Guess

 

 
Top