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
ISPMT
Returns the interest paid during a specific period of an investment.
26
MDURATION
returns the Macauley modified duration for a security with an assumed par value of $100.
27
MIRR
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
NOMINAL
Returns the annual nominal interest rate
29
NPER
Returns the number of periods on for an investment based on periodic, constant payments and a constant interest rate.
30
NPV
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
ODDFPRICE
Returns the price per $100 face value of a security with an odd first period.
32
ODDFYIELD
Returns the yield of a security with an odd first period.
33
ODDLPRICE
Returns the price per $100 face value of a security with an odd last period.
34
ODDLYIELD
Returns the yield of a security with an odd last period.
35
PMT
Calculate the payment for a loan based on constant payments and a constant interest rate.
36
PPMT
Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate.
37
PRICE
Returns the price per $100 face value of a security that pays periodic interest.
38
PRICEDISC
Returns the price per $100 face value of a discounted security.
39
PRICEMAT
Returns the Price per $100 face value of a security that pays interest at maturity.
40
PV
Returns the present value of an investment: the total amount that a series of future payments is worth.
41
RATE
Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments and 6% annually.
42
RECEIVED
Returns the amount received at maturity for a fully invested security.
43
SLN
Returns the straight-line depreciation of an asset for one period.
44
SYD
Returns the sum-of-years' digits depreciation of an asset for a specified period.
45
TBILLPRICE
Returns the price per $100 face value for a treasury bill.
46
TBILLEQ
Returns the bond-equivalent yield for a treasury bill.
47
TBILLYIELD
Returns the yield for a treasury bill.
48
VDB
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
XIRR
Returns the internal rate of return for a schedule of cash flows.
50
XNPV
Returns the net present value for a schedule of cash flows.
51
YIELD
Returns the yield on a security that pays periodic interest.
52
YIELDDISC
Returns the annual yield for a discounted security. Example: a treasury bill.
53
YIELDMAT
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