Difference between revisions of "Documentation/How Tos/Calc: Financial functions"

|[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']]

 

|-valign="top"

|[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']]

|Returns depreciation for a settlement period as degressive amortization.  

|Returns depreciation for a settlement period as linear amortization.  

|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]

|Returns the number of days between the coupon date preceding the settlement, and the settlement date.  

|[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']]

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

|[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']]

|Returns the number of days between the settlement date and the next coupon date.

|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]

|Returns the coupon date next after the settlement date.  

|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]

|Returns the number of coupons (interest payments) between the settlement date and maturity.  

|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]

|Returns the total interest paid on a loan in specified periods.

|Returns the total interest paid on a loan in specified periods.  

|Returns the total capital repaid on a loan in specified periods.  

|Returns the total capital repaid on a loan in specified periods.  

|[[Documentation/How_Tos/Calc: DB function|'''DB''']]

|Returns the depreciation of an asset for a given year using the fixed rate declining-balance method.  

|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']]

|Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method.  

|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]

|Calculates the allowance (discount) of a security as a percentage.

|[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]

|Converts a fractional number representation of a number into a decimal number.  

|[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]

|Converts a decimal number into a fractional representation of that number.

|[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]

|Calculates the number of periods required by an investment to attain the desired value.

|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]

|Calculates the duration of a fixed interest security in years.

|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]

|Returns the effective compounded interest rate given a nominal interest rate.  

|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]

|Returns the effective compounded interest rate given a nominal interest rate.  

|[[Documentation/How_Tos/Calc: FV function|'''FV''']]

|Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).

|[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]

|Calculates the accumulated value of the starting capital for a series of periodically varying interest rates.

|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]

|Returns the equivalent annual interest rate for an item bought at one price and sold at another.  

|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]

|Returns the interest paid in a period for a fixed rate loan.  

|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]

|Calculates the internal rate of return for an investment. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income).

|[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]

|Returns the interest paid in a period for a fixed rate loan.  

|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]

|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]

|Calculates the modified internal rate of return of a series of investments.

|[[Documentation/How_Tos/Calc: NOMINAL function|'''NOMINAL''']]

|Returns a nominal interest rate given the effective compounded interest rate.  

|[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]

|Returns a nominal interest rate given the effective compounded interest rate.  

|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]

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

|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]

|Returns the net present value of an investment given cash payments and a discount rate.  

|Returns the value of a security per 100 currency units of face value, where the time to the first interest payment is not a whole period.

|Returns the value of a security per 100 currency units of face value, where the last interest payment is not a whole period.

|Returns a calculated quoted price for a bond, per 100 currency units par value.

|Calculates the price per 100 currency units of par value of a non-interest- bearing security.

|Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.

|[[Documentation/How_Tos/Calc: PV function|'''PV''']]

|Returns the present value of a stream of future payments.  

|[[Documentation/How_Tos/Calc: RATE function|'''RATE''']]

|Returns the constant interest rate per period of an annuity.

|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]

|Calculates the amount received that is paid for a fixed-interest security at a given point in time.

|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]

|Calculates the interest rate resulting from the profit (return) of an investment.

|[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]

|Returns the depreciation of an asset in a single period using the straight-line depreciation method.  

|[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]

|Returns the depreciation of an asset for a given year using the sum-of-years'-digits method.

|[[Documentation/How_Tos/Calc: TBILLEQ function|'''TBILLEQ''']]

|Returns the bond-equivalent-yield (BEY) for a US Treasury bill.

|[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]

|Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate.  

|[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]

|Returns the yield for a US Treasury bill.

|[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]

|Returns the depreciation of an asset for a given year using a variable declining-balance method.

|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]

|Calculates the internal rate of return for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.

|[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]

|Calculates the capital value (net present value)for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.

|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]

|Calculates the yield of a security.

|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]

|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]

|Calculates the annual yield of a security, the interest of which is paid on the date of maturity.

'''[[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]'''

'''[[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]'''