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

Financial functions

Description

The description for the function TBILLYIELD is not available yet.

Availability

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

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

Syntax

TBILLYIELD(Settlement,Maturity,Pr)

Arguments

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

DesignationDescription
Settlement
Maturity
Pr

 


VDB

Categories: Financial, Functions
Comments: No

Description

The description for the function VDB is not available yet.

Availability

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

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

Syntax

VDB(Cost,Salvage,Life,Start_period,End_period,Factor,No_switch)

Arguments

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

DesignationDescription
Cost
Salvage
Life
Start_period
End_period
Factor
No_switch

 


XIRR

Categories: Financial, Functions
Comments: No

Description

The description for the function XIRR is not available yet.

Availability

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

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

Syntax

XIRR(Values,Dates,Guess)

Arguments

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

DesignationDescription
Values
Dates
Guess

 


XNPV

Categories: Financial, Functions
Comments: No

Description

The description for the function XNPV is not available yet.

Availability

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

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

Syntax

XNPV(Rate,Values,Dates)

Arguments

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

DesignationDescription
Rate
Values
Dates

 


YIELD

Categories: Financial, Functions
Comments: No

Description

The description for the function YIELD is not available yet.

Availability

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

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

Syntax

YIELD(Settlement,Maturity,Rate,Pr,Redemption,Frequency,Basis)

Arguments

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

DesignationDescription
Settlement
Maturity
Rate
Pr
Redemption
Frequency
Basis

 


Description

The description for the function YIELDDISC is not available yet.

Availability

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

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

Syntax

YIELDDISC(Settlement,Maturity,Pr,Redemption,Basis)

Arguments

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

DesignationDescription
Settlement
Maturity
Pr
Redemption
Basis

 


Description

The description for the function YIELDMAT is not available yet.

Availability

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

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

Syntax

YIELDMAT(Settlement,Maturity,Issue,Rate,Pr,Basis)

Arguments

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

DesignationDescription
Settlement
Maturity
Issue
Rate
Pr
Basis

 

 
Top