Brainscape's Knowledge GenomeTM

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


See full index

DAX > DAXFinancial > Flashcards

DAXFinancial Flashcards

1
Q

LINEST(‘Sales’, [XValues], [YValues], TRUE)

A

This DAX code uses the ‘LINEST’ function to calculate the least squares regression line that best fits the data in the ‘Sales’ table, where ‘XValues’ and ‘YValues’ are the input data columns. The ‘TRUE’ parameter forces the intercept to be zero.

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

LINESTX(‘Sales’, [XValues], [YValues], TRUE)

A

Similar to ‘LINEST’, this DAX code uses the ‘LINESTX’ function to calculate the least squares regression line for the ‘Sales’ table, but it operates on expressions evaluated for each row in the table, rather than specific columns. The ‘TRUE’ parameter still forces the intercept to be zero.

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

ACCRINT(“01/01/2023”, “06/30/2023”, “07/01/2022”, 0.05, 1000, 2, 0)

A

The ACCRINT function calculates the accrued interest for a security that pays periodic interest. In this example, it calculates the accrued interest for a security with a principal amount of $1,000, a 5% annual interest rate, and a semi-annual payment frequency, between January 1, 2023, and June 30, 2023, with the settlement date on July 1, 2022.

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

ACCRINTM(“01/01/2023”, “07/01/2022”, 0.05, 1000)

A

The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity. In this example, it calculates the accrued interest for a security with a principal amount of $1,000, a 5% annual interest rate, and a settlement date of July 1, 2022, with the maturity date on January 1, 2023.

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

AMORDEGRC(120, 1, “01/01/2022”, “12/31/2022”, 0.1, 6)

A

The AMORDEGRC function calculates the depreciation for each accounting period using a declining balance method with a coefficient applied based on the life of the assets. In this example, it calculates depreciation for an asset with a cost of $120, a 10% annual depreciation rate, and a 6-month life, between January 1, 2022, and December 31, 2022.

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

AMORLINC(120, “01/01/2022”, “12/31/2022”, 6)

A

The AMORLINC function calculates the depreciation for each accounting period using a linear depreciation method. In this example, it calculates depreciation for an asset with a cost of $120 and a 6-month life, between January 1, 2022, and December 31, 2022.

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

COUPDAYBS(“01/01/2022”, “06/30/2022”, 2, 1)

A

The COUPDAYBS function returns the number of days from the beginning of a coupon period until its settlement date. In this example, it calculates the number of days from the beginning of the coupon period (2) until the settlement date (1) for a period ending on June 30, 2022.

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

COUPDAYS(“01/01/2022”, “06/30/2022”, 2, 1)

A

The COUPDAYS function returns the number of days in the coupon period that contains the settlement date. In this example, it calculates the number of days in the coupon period (2) that contains the settlement date (1) for a period ending on June 30, 2022.

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

COUPDAYSNC(“01/01/2022”, “06/30/2022”, 2, 1)

A

The COUPDAYSNC function returns the number of days from the settlement date to the next coupon date. In this example, it calculates the number of days from the settlement date (1) to the next coupon date (2) for a period ending on June 30, 2022.

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

COUPNCD(“01/01/2022”, “06/30/2022”, 2, 1)

A

The COUPNCD function returns the next coupon date after the settlement date. In this example, it calculates the next coupon date (2) after the settlement date (1) for a period ending on June 30, 2022.

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

COUPNUM(“01/01/2022”, “06/30/2022”, 2, 1)

A

The COUPNUM function returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. In this example, it calculates the number of coupons payable between the settlement date (1) and maturity date for a period ending on June 30, 2022, with a frequency of 2.

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

COUPPCD(“01/01/2022”, “06/30/2022”, 2, 1)

A

The COUPPCD function returns the previous coupon date before the settlement date. In this example, it calculates the previous coupon date (2) before the settlement date (1) for a period ending on June 30, 2022.

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

CUMIPMT(0.05/12, 2, 5*12, 1, 12, 0)

A

The CUMIPMT function returns the cumulative interest paid on a loan between start_period and end_period. In this example, it calculates the cumulative interest paid on a loan with a 5% annual interest rate, 5 years term, 1st payment made after 12 months, and payments made monthly.

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

CUMPRINC(0.05/12, 2, 5*12, 1, 12, 0)

A

The CUMPRINC function returns the cumulative principal paid on a loan between start_period and end_period. In this example, it calculates the cumulative principal paid on a loan with a 5% annual interest rate, 5 years term, 1st payment made after 12 months, and payments made monthly.

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

DB(10000, 5000, 5, 1)

A

The DB function returns the depreciation of an asset for a specified period using the fixed-declining balance method. In this example, it calculates the depreciation of an asset with a cost of $10,000, a salvage value of $5,000, a 5-year life, and a 1-year depreciation period.

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

DDB(10000, 5000, 5, 1)

A

The DDB function returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. In this example, it calculates the depreciation of an asset with a cost of $10,000, a salvage value of $5,000, a 5-year life, and a 1-year depreciation period.

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

DISC(“01/01/2022”, “12/31/2022”, 950, 1000)

A

The DISC function returns the discount rate for a security. In this example, it calculates the discount rate for a security with a settlement date on January 1, 2022, a maturity date on December 31, 2022, a price of $950, and a redemption value of $1,000.

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

DOLLARDE(100.25, 16)

A

The DOLLARDE function converts a dollar price expressed as an integer part and a fraction part into a dollar price expressed as a decimal number. In this example, it converts the price 100 25/16 into a decimal number.

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

DOLLARFR(100.25, 16)

A

The DOLLARFR function converts a dollar price expressed as an integer part and a fraction part into a dollar price expressed as a decimal number. In this example, it converts the price 100 25/16 into a decimal number.

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

DURATION(“01/01/2022”, “12/31/2022”, 0.05, 100)

A

The DURATION function returns the Macaulay duration for an assumed par value of $100. In this example, it calculates the Macaulay duration for a security with a settlement date on January 1, 2022, a maturity date on December 31, 2022, a yield of 5%, and a par value of $100.

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

EFFECT(0.06, 4)

A

The EFFECT function returns the effective annual interest rate, given the nominal annual interest rate (APR) of 6% and the number of compounding periods per year (4).

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

FV(0.1, 5, -100, 0, 0)

A

The FV function calculates the future value of an investment based on a constant interest rate of 10%, 5 years, an initial investment of -$100, no periodic payments, and no compounding frequency specified (default is 0).

23
Q

INTRATE(“01/01/2022”, “12/31/2022”, 1000, 1100)

A

The INTRATE function returns the interest rate for a fully invested security. In this example, it calculates the interest rate for a security with a settlement date on January 1, 2022, a maturity date on December 31, 2022, a purchase price of $1,000, and a redemption value of $1,100.

24
Q

IPMT(0.05/12, 1, 5*12, 5, 12, 0)

A

The IPMT function returns the interest payment for a given period for an investment based on periodic, constant payments, and a constant interest rate. In this example, it calculates the interest payment for the 1st month of a 5-year investment with a 5% annual interest rate, monthly payments, and a principal of $5,000.

25
Q

ISPMT(0.05, 1, 12, 5)

A

The ISPMT function calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments. In this example, it calculates the interest payment for the 1st period of a 12% annual interest rate loan with 5 periods.

26
Q

MDURATION(“01/01/2022”, “12/31/2022”, 0.05, 100)

A

The MDURATION function returns the modified Macaulay duration for a security with an assumed par value of $100. In this example, it calculates the modified Macaulay duration for a security with a settlement date on January 1, 2022, a maturity date on December 31, 2022, a yield of 5%, and a par value of $100.

27
Q

NOMINAL(0.06, 4)

A

The NOMINAL function returns the nominal annual interest rate, given the effective rate (APY) of 6% and the number of compounding periods per year (4).

28
Q

NPER(0.1, -100, 500, 0, 0)

A

The NPER function returns the number of periods for an investment based on periodic, constant payments, and a constant interest rate. In this example, it calculates the number of periods required to reach a future value of $500 with a 10% annual interest rate, an initial investment of -$100, no periodic payments, and no compounding frequency specified (default is 0).

29
Q

ODDFPRICE(“01/01/2022”, “12/31/2022”, “06/30/2022”, 0.05, 1000, 0.06, 2)

A

The ODDFPRICE function returns the price per $100 face value of a security having an odd (short or long) first coupon period. In this example, it calculates the price per $100 face value for a security with a settlement date on January 1, 2022, a maturity date on December 31, 2022, a first coupon date on June 30, 2022, a yield of 5%, a redemption value of $1,000, an annual coupon rate of 6%, and a semi-annual frequency of 2.

30
Q

ODDFYIELD(“01/01/2022”, “12/31/2022”, “06/30/2022”, 0.05, 950, 1000, 2)

A

The ODDFYIELD function returns the yield of a security that has an odd (short or long) first coupon period. In this example, it calculates the yield for a security with a settlement date on January 1, 2022, a maturity date on December 31, 2022, a first coupon date on June 30, 2022, a purchase price of $950, a redemption value of $1,000, and a semi-annual frequency of 2.

31
Q

ODDLPRICE(“01/01/2022”, “12/31/2022”, 0.05, 0.03, 100)

A

The ODDLPRICE function calculates the price per $100 face value of a security with an odd last coupon period. It takes parameters like settlement date, maturity date, discount rate, yield, and face value.

32
Q

ODDLYIELD(“01/01/2022”, “12/31/2022”, 0.05, 0.03, 100)

A

The ODDLYIELD function calculates the yield of a security that has an odd last period. It requires parameters like settlement date, maturity date, discount rate, price, and face value.

33
Q

PDURATION(0.05, 1000, 1100)

A

The PDURATION function returns the number of periods required by an investment to reach a specified value. In this example, it calculates the periods needed for an investment to grow from $1,000 to $1,100 at an annual interest rate of 5%.

34
Q

PMT(0.05, 5, 1000)

A

The PMT function calculates the payment for a loan based on constant payments and a constant interest rate. In this case, it computes the periodic payment for a loan with a 5% annual interest rate, 5 periods, and a principal amount of $1,000.

35
Q

PPMT(0.05, 2, 5, 1000)

A

The PPMT function returns the payment on the principal for a given period of an investment with periodic, constant payments and a constant interest rate. In this example, it calculates the principal payment for period 2 of a loan.

36
Q

PRICE(“01/01/2022”, “12/31/2022”, 0.05, 0.03, 100)

A

The PRICE function calculates the price per $100 face value of a security that pays periodic interest. It takes parameters like settlement date, maturity date, annual coupon rate, yield, and face value.

37
Q

PRICEDISC(“01/01/2022”, “12/31/2022”, 0.05, 0.03)

A

The PRICEDISC function calculates the price per $100 face value of a discounted security. It requires parameters like settlement date, maturity date, discount rate, and yield.

38
Q

PRICEMAT(“01/01/2022”, “12/31/2022”, 0.05, 0.03, 100)

A

The PRICEMAT function calculates the price per $100 face value of a security that pays interest at maturity. It takes parameters like settlement date, maturity date, annual coupon rate, yield, and face value.

39
Q

PV(0.05, 5, 100)

A

The PV function calculates the present value of a loan or investment based on a constant interest rate. In this example, it computes the present value of $100 to be received in 5 periods at a 5% interest rate.

40
Q

RATE(5, -100, 1000)

A

The RATE function returns the interest rate per period of an annuity. In this case, it calculates the rate for an investment that grows from -$100 to $1,000 in 5 periods.

41
Q

RECEIVED(“01/01/2022”, “12/31/2022”, 0.05, 1000, 1100)

A

The RECEIVED function calculates the amount received at maturity for a fully invested security. It considers parameters like settlement date, maturity date, discount rate, investment amount, and maturity amount.

42
Q

RRI(0.05, 1000, 1100)

A

The RRI function returns an equivalent interest rate for the growth of an investment. In this example, it calculates the rate for an investment that grows from $1,000 to $1,100 with a 5% nominal rate.

43
Q

SLN(1000, 100, 5)

A

The SLN function calculates the straight-line depreciation of an asset for one period. In this case, it computes the depreciation for an asset with a cost of $1,000, a salvage value of $100, and a useful life of 5 periods.

44
Q

SYD(1000, 100, 5, 3)

A

The SYD function returns the sum-of-years’ digits depreciation of an asset for a specified period. This example computes the depreciation for year 3 of an asset with a cost of $1,000, a salvage value of $100, and a useful life of 5 years.

45
Q

TBILLEQ(“01/01/2022”, “12/31/2022”, 0.04)

A

The TBILLEQ function calculates the bond-equivalent yield for a Treasury bill. It requires parameters like settlement date, maturity date, and discount rate.

46
Q

TBILLPRICE(“01/01/2022”, “12/31/2022”, 0.04)

A

The TBILLPRICE function calculates the price per $100 face value for a Treasury bill. It takes parameters like settlement date, maturity date, and discount rate.

47
Q

TBILLYIELD(“01/01/2022”, “12/31/2022”, 95)

A

The TBILLYIELD function calculates the yield for a Treasury bill. It considers parameters like settlement date, maturity date, and price per $100 face value.

48
Q

VDB(‘Asset’[Asset Cost], ‘Asset’[Accumulated Depreciation], 5, 2)

A

The VDB function calculates the depreciation of an asset (specified in the ‘Asset’ table) for a specific period (5 years in this example) using the double-declining balance method with a specified factor (2 in this example).

49
Q

XIRR(‘Cashflows’[Cash Amount], ‘Cashflows’[Date])

A

The XIRR function calculates the internal rate of return for a schedule of cash flows (from the ‘Cashflows’ table) that are not necessarily periodic, based on the provided cash amounts and corresponding dates.

50
Q

XNPV(0.1, ‘Cashflows’[Cash Amount], ‘Cashflows’[Date])

A

The XNPV function calculates the present value for a schedule of cash flows (from the ‘Cashflows’ table) that are not necessarily periodic, using a specified discount rate (0.1 or 10%) and the provided cash amounts and dates.

51
Q

YIELD(‘Bonds’[Coupon Rate], ‘Bonds’[Maturity Date], ‘Bonds’[Purchase Date], ‘Bonds’[Purchase Price], 2, 1)

A

The YIELD function calculates the yield on a security (from the ‘Bonds’ table) that pays periodic interest, considering the coupon rate, maturity date, purchase date, purchase price, frequency, and basis.

52
Q

YIELDDISC(‘DiscountedBonds’[Settlement Date], ‘DiscountedBonds’[Maturity Date], ‘DiscountedBonds’[Discount], ‘DiscountedBonds’[Redemption], 2)

A

The YIELDDISC function returns the annual yield for a discounted security (from the ‘DiscountedBonds’ table), taking into account the settlement date, maturity date, discount, redemption, and basis.

53
Q

YIELDMAT(‘MaturingBonds’[Settlement Date], ‘MaturingBonds’[Maturity Date], ‘MaturingBonds’[Issued Price], ‘MaturingBonds’[Maturity Value], 2)

A

The YIELDMAT function calculates the annual yield of a security (from the ‘MaturingBonds’ table) that pays interest at maturity, considering the settlement date, maturity date, issued price, maturity value, and basis.

DAX (4 decks)

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