Explanation/Reference:
Explanation:
Various financial functions (reference) are as follows:
1. ACCRINT function: It is used to return the accrued interest for a security that pays periodic interest.
2. ACCRINTM function: It is used to return the accrued interest for a security that pays interest at maturity.
3. AMORDEGRC function: It is used to return the depreciation for each accounting period by using a depreciation coefficient.
4. COUPDAYBS function: It is used to return the number of days from the beginning of the coupon period to the settlement date.
5. AMORLINC function: It is used to return the depreciation for each accounting period.
6. COUPDAYS function: It is used to return the number of days in the coupon period containing the settlement date.
7. COUPDAYSNC function: It is used to return the number of days from the settlement date to the next coupon date.
8. COUPNCD function: It is used to return the next coupon date after the settlement date.
9. COUPNUM function: It is used to return the number of coupons payable between the settlement date and maturity date.
10.COUPPCD function: It is used to return the previous coupon date before the settlement date.
11.CUMIPMT function: It is used to return the cumulative interest paid between two periods.
12.CUMPRINC function: It is used to return the cumulative principal paid on a loan between two periods.
13.DB function: It is used to return the depreciation of an asset for a specified period by using the fixed- declining balance method.
14.DDB function: It is used to return the depreciation of an asset for a particular period by using the double-declining balance method.
15.DISC function: It is used to return the discount rate for a security.
16.DOLLARDE function: It is used to convert a dollar price that is expressed as a fraction into a dollar price that is expressed as a decimal number.
17.DOLLARFR function: It is used to convert a dollar price that is expressed as a decimal number into a dollar price that is expressed as a fraction.
18.DURATION function: It is used to return the annual duration of a security with periodic interest payments.
19.EFFECT function: It is used to return the effective annual interest rate.
20.FV function: It is used to return the future value of an investment.
21.FVSCHEDULE function: It is used to return the future value of a starting principal after applying a series of compound interest rates.
22.INTRATE function: It is used to return the interest rate for a fully invested security.
23.IPMT function: It is used to return the interest payment for an investment for a specified period.
24.IRR function: It is used to return the internal rate of return for a series of cash flows.
25.ISPMT function: It is used to calculate the interest paid during a particular period of an investment.
26.MDURATION function: It is used to return the Macauley modified duration for a security with an assumed par value of $100.
27.MIRR function: It is used to return the internal rate of return in which positive and negative cash flows are financed at different rates.
28.NOMINAL function: It is used to return the annual nominal interest rate.
29.NPER function: It is used to return the number of periods for an investment.
30.NPV function: It is used to return the net present value of an investment on the basis of a series of periodic cash flows and a discount rate.
31.ODDFPRICE function: It is used to return the price per $100 face value of a security with an odd first period.
32.ODDFYIELD function: It is used to return the yield of a security with an odd first period.
33.ODDLPRICE function: It is used to return the price per $100 face value of a security with an odd last period.
34.ODDLYIELD function: It is used to return the yield of a security with an odd last period.
35.PMT function: It is used to return the periodic payment for an annuity.
36.PPMT function: It is used to return the payment on the principal for an investment for a particular defined period.
37.PRICE function: It is used to return the price per $100 face value of a security that pays Periodic interest.
38.PRICEDISC function: It is used to return the price per $100 face value of a discounted security.
39.PRICEMAT function: It is used to return the price per $100 face value of a security that pays interest at maturity.
40.PV function: It is used to return the current value of an investment.
41.RATE function: It is use d to return the interest rate per period of an annuity.
42.RECEIVED function: It is used to return the amount received at maturity for a fully invested security.
43.SLN function: It is used to return the straight-line depreciation of an asset for one period.
44.SYD function: It is used to return the sum-of-years' digits depreciation of an asset for a particular period.
45.TBILLEQ function: It is used to return the bond-equivalent yield for a Treasury bill.
46.TBILLPRICE function: It is used to return the price per $100 face value for a Treasury bill.
47.TBILLYIELD function: It is used to return the yield for a Treasury bill.
48.VDB function: It is used to return the depreciation of an asset for a specified or partial period by using a declining balance method.
49.XIRR function: It is used to return the internal rate of return for a schedule of cash flows that is not necessarily periodic.
50.XNPV function: It is used to return the net present value for a schedule of cash flows that is not necessarily periodic.
51.YIELD function: It is used to return the yield on a security that pays periodic interest.
52.YIELDDISC function: It is used to return the annual yield for a discounted security.
53.YIELDMAT function: It is used to return the annual yield of a security that pays interest at maturity.
References:
https://support.office.com/en-us/article/db-function-354e7d28-5f93-4ff1-8a52-eb4ee549d9d7
https://support.office.com/en-us/article/fvschedule-function-bec29522-bd87-4082-bab9-a241f3fb251d