Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DAX Syntax > Financial Functions > Flashcards

Financial Functions Flashcards

1
Q

FV(rate, nper, pmt[, pv[, type]])

A

Calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, and/or a single lump sum payment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ISPMT(rate, per, nper, pv)

A

Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

PMT(rate, nper, pv[, fv[, type]])

A

Calculates the payment for a loan based on constant payments and a constant interest rate.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

PV(rate, nper, pmt[, fv[, type]])

A

Calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), and/or a future value that’s your investment goal.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

DOLLARFR(decimal_dollar, fraction)

A

Converts a dollar price expressed as a decimal number into a dollar price expressed as an integer part and a fraction part, such as 1.02. Fractional dollar numbers are sometimes used for security prices.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

DOLLARDE(fractional_dollar, fraction)

A

Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

RRI(nper, pv, fv)

A

Returns an equivalent interest rate for the growth of an investment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

ACCRINTM(issue, maturity, rate, par[, basis])

A

Returns the accrued interest for a security that pays interest at maturity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

ACCRINT(issue, first_interest, settlement, rate, par, frequency[, basis[, calc_method]])

A

Returns the accrued interest for a security that pays periodic interest.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

RECEIVED(settlement, maturity, investment, discount[, basis])

A

Returns the amount received at maturity for a fully invested security.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

YIELDDISC(settlement, maturity, pr, redemption[, basis])

A

Returns the annual yield for a discounted security.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

YIELDMAT(settlement, maturity, issue, rate, pr[, basis])

A

Returns the annual yield of a security that pays interest at maturity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

TBILLEQ(settlement, maturity, discount)

A

Returns the bond-equivalent yield for a Treasury bill.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

CUMIPMT(rate, nper, pv, start_period, end_period, type)

A

Returns the cumulative interest paid on a loan between start_period and end_period.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

CUMPRINC(rate, nper, pv, start_period, end_period, type)

A

Returns the cumulative principal paid on a loan between start_period and end_period.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

AMORLINC(cost, date_purchased, first_period, salvage, period, rate[, basis])

A

Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate[, basis])

A

Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

DDB(cost, salvage, life, period[, factor])

A

Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

DB(cost, salvage, life, period[, month])

A

Returns the depreciation of an asset for a specified period using the fixed-declining balance method.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

VDB(cost, salvage, life, start_period, end_period[, factor[, no_switch]])

A

Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

DISC(settlement, maturity, pr, redemption[, basis])

A

Returns the discount rate for a security.

21
Q

EFFECT(nominal_rate, npery)

A

Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.

22
Q

IPMT(rate, per, nper, pv[, fv[, type]])

A

Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.

23
Q

INTRATE(settlement, maturity, investment, redemption[, basis])

A

Returns the interest rate for a fully invested security.

24
Q

RATE(nper, pmt, pv[, fv[, type[, guess]]])

A

Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, an error is returned.

25
Q

XIRR(table, values, dates, [, guess[, alternateResult]])

A

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

26
Q

DURATION(settlement, maturity, coupon, yld, frequency[, basis])

A

Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price’s response to changes in yield.

27
Q

MDURATION(settlement, maturity, coupon, yld, frequency[, basis])

A

Returns the modified Macauley duration for a security with an assumed par value of $100.

28
Q

COUPNCD(settlement, maturity, frequency[, basis])

A

Returns the next coupon date after the settlement date.

29
Q

NOMINAL(effect_rate, npery)

A

Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.

30
Q

COUPNUM(settlement, maturity, frequency[, basis])

A

Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.

31
Q

COUPDAYBS(settlement, maturity, frequency[, basis])

A

Returns the number of days from the beginning of a coupon period until its settlement date.

32
Q

COUPDAYSNC(settlement, maturity, frequency[, basis])

A

Returns the number of days from the settlement date to the next coupon date.

33
Q

COUPDAYS(settlement, maturity, frequency[, basis])

A

Returns the number of days in the coupon period that contains the settlement date.

34
Q

NPER(rate, pmt, pv[, fv[, type]])

A

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

35
Q

PDURATION(rate, pv, fv)

A

Returns the number of periods required by an investment to reach a specified value.

36
Q

PPMT(rate, per, nper, pv[, fv[, type]])

A

Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.

37
Q

XNPV(table, values, dates, rate)

A

Returns the present value for a schedule of cash flows that is not necessarily periodic.

38
Q

COUPPCD(settlement, maturity, frequency[, basis])

A

Returns the previous coupon date before the settlement date.

39
Q

TBILLPRICE(settlement, maturity, discount)

A

Returns the price per $100 face value for a Treasury bill.

40
Q

PRICEDISC(settlement, maturity, discount, redemption[, basis])

A

Returns the price per $100 face value of a discounted security.

41
Q

ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency[, basis])

A

Returns the price per $100 face value of a security having an odd (short or long) first period.

42
Q

ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency[, basis])

A

Returns the price per $100 face value of a security having an odd (short or long) last coupon period.

43
Q

PRICEMAT(settlement, maturity, issue, rate, yld[, basis])

A

Returns the price per $100 face value of a security that pays interest at maturity.

44
Q

PRICE(settlement, maturity, rate, yld, redemption, frequency[, basis])

A

Returns the price per $100 face value of a security that pays periodic interest.

45
Q

SLN(cost, salvage, life)

A

Returns the straight-line depreciation of an asset for one period.

46
Q

SYD(cost, salvage, life, per)

A

Returns the sum-of-years’ digits depreciation of an asset for a specified period.

47
Q

TBILLYIELD(settlement, maturity, pr)

A

Returns the yield for a Treasury bill.

48
Q

ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency[, basis])

A

Returns the yield of a security that has an odd (short or long) first period.

49
Q

ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency[, basis])

A

Returns the yield of a security that has an odd (short or long) last period.

50
Q

YIELD(settlement, maturity, rate, pr, redemption, frequency[, basis])

A

Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield.

DAX Syntax (15 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions