Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Excel Finance Formulas > Name and Definition > Flashcards

Name and Definition Flashcards

1
Q

ACCRINT

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
2
Q

ACCRINTM

A

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

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

AMORDEGRC

A

Returns the prorated returns of an asset for each accounting period.

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

AMORLINC

A

Returns the prorated linear depreciation of an asset for each accounting period.

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

COUPDAYBS

A

Returns the number of days from the beginning of the coupon period that contains the settlement period.

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

COUPDAYS

A

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

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

COUPDAYSNC

A

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

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

COUPNCD

A

Returns the next coupon date after the settlement date.

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

COUPNUM

A

Returns the number of coupons payable between the settlement date and maturity date.

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

COUPPCD

A

Returns the previous coupon date before the settlement date.

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

CUMIPMT

A

Returns the cumulative interest paid between the two periods.

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

CUMPRINC

A

Returns the cumulative principal paid on a loan between two periods.

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

DB

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
14
Q

DDB

A

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

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

DISC

A

Returns the discounted rate for a security.

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

DOLLARDE

A

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal.

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

DOLLARFR

A

Converts a dollar price, expressed as a decimal, into a dollar price, expressed as a fraction.

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

DURATION

A

Returns the annual duration of a security with periodic interest payments.

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

EFFECT

A

Returns the effective annual interest rate.

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

FV

A

Returns the future value of an investment based on periodic, constant payments and a constant interest rate.

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

FVSCHEDULE

A

Returns the future value of an initial principal after applying a series of compound interest rates.

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

INTRATE

A

Returns the interest rate for a fully invested security.

23
Q

IPMT

A

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

24
Q

IRR

A

Returns the internal rate of return for a series of cash flows.

25
Q

ISPMT

A

Returns the interest paid during a specific period of an investment.

26
Q

MDURATION

A

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

27
Q

MIRR

A

Returns the internal rate of return for a series of of cash flows, considering both the rest of investment and interest on re-investment of cash.

28
Q

NOMINAL

A

Returns the annual nominal interest rate

29
Q

NPER

A

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

30
Q

NPV

A

Returns the net present value of an investment based on a discount rate and a series of future payments payments (negatives values) an income (positive values).

31
Q

ODDFPRICE

A

Returns the price per $100 face value of a security with an odd first period.

32
Q

ODDFYIELD

A

Returns the yield of a security with an odd first period.

33
Q

ODDLPRICE

A

Returns the price per $100 face value of a security with an odd last period.

34
Q

ODDLYIELD

A

Returns the yield of a security with an odd last period.

35
Q

PMT

A

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

36
Q

PPMT

A

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

37
Q

PRICE

A

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

38
Q

PRICEDISC

A

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

39
Q

PRICEMAT

A

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

40
Q

PV

A

Returns the present value of an investment: the total amount that a series of future payments is worth.

41
Q

RATE

A

Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments and 6% annually.

42
Q

RECEIVED

A

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

43
Q

SLN

A

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

44
Q

SYD

A

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

45
Q

TBILLPRICE

A

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

46
Q

TBILLEQ

A

Returns the bond-equivalent yield for a treasury bill.

47
Q

TBILLYIELD

A

Returns the yield for a treasury bill.

48
Q

VDB

A

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

49
Q

XIRR

A

Returns the internal rate of return for a schedule of cash flows.

50
Q

XNPV

A

Returns the net present value for a schedule of cash flows.

51
Q

YIELD

A

Returns the yield on a security that pays periodic interest.

52
Q

YIELDDISC

A

Returns the annual yield for a discounted security. Example: a treasury bill.

53
Q

YIELDMAT

A

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

Excel Finance Formulas (1 decks)

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