|
|
| Line 70: |
Line 70: |
| | * [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">Coupdaybs]] | | * [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">Coupdaybs]] |
| | * [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays]] | | * [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays]] |
| − | }}
| |
| − | ==Financial Functions==
| |
| − | The Financial functions provide common business calculations.
| |
| − |
| |
| − | {| border="0" cellpadding="0" cellspacing="10" align="left"
| |
| − | |-valign="top"
| |
| − | |colspan="2"|'''<big> Depreciation</big>'''
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: AMORDEGRC function|'''AMORDEGRC''']]
| |
| − | |Returns depreciation for a period using degressive depreciation (French system).
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: AMORLINC function|'''AMORLINC''']]
| |
| − | |Returns depreciation for a period using linear depreciation (French system).
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: DB function|'''DB''']]
| |
| − | |Returns the depreciation of an asset for a given year using the fixed rate declining-balance method.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[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.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]
| |
| − | |Returns the depreciation of an asset in a single period using the straight-line depreciation method.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]
| |
| − | |Returns the depreciation of an asset for a given year using the sum-of-years'-digits method.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]
| |
| − | |Returns the depreciation of an asset for a given year using a variable declining-balance method.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |colspan="2"|'''<big> Payment Streams, Annuities, Loans</big>'''
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']]
| |
| − | |Returns the total interest paid on a loan in specified periodic payments.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: CUMIPMT_ADD function|'''CUMIPMT_ADD''']]
| |
| − | |Returns the total interest paid on a loan in specified periodic payments.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']]
| |
| − | |Returns the total capital repaid on a loan in specified periodic payments.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
| |
| − | |Returns the total capital repaid on a loan in specified periodic payments.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: FV function|'''FV''']]
| |
| − | |Returns the future value of an initial sum with a subsequent stream of payments.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]
| |
| − | |Returns the future value of an initial sum, with changing future interest rates.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
| |
| − | |Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
| |
| − | |Calculates the internal rate of return of a series of cash flows.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]
| |
| − | |Returns the interest paid in a period for a fixed rate loan.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
| |
| − | |Returns the modified internal rate of return of a series of cash flows.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
| |
| − | |Returns the number of payment periods for an annuity.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
| |
| − | |Returns the net present value of an investment with regular cash payments.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: PMT function|'''PMT''']]
| |
| − | |Returns the payment per period for a fixed rate loan.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
| |
| − | |Returns the portion of the periodic payment which is repaid capital for a fixed rate loan or annuity.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: PV function|'''PV''']]
| |
| − | |Returns the present value of a stream of future payments with a final lump sum.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: RATE function|'''RATE''']]
| |
| − | |Calculates the interest rate for an annuity.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
| |
| − | |Returns an equivalent interest rate when an investment increases in value.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
| |
| − | |Calculates the internal rate of return of a series of irregular cash flows.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
| |
| − | |Returns the net present value of an investment with irregular cash payments.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |colspan="2"|'''<big> Securities</big>'''
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']]
| |
| − | |Calculates the accrued interest for a security with periodic interest payments.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']]
| |
| − | |Calculates the accrued interest for a security that pays at maturity.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
| |
| − | |Returns the discount rate of a security.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]
| |
| − | |Returns the number of periods needed for an investment to reach a certain value.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
| |
| − | |Returns the Macaulay duration of a security.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
| |
| − | |Returns the effective compounded interest rate given a nominal interest rate.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
| |
| − | |Returns the effective compounded interest rate given a nominal interest rate.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
| |
| − | |Returns the equivalent annual interest rate for an investment bought at one price and sold at another.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
| |
| − | |Returns the modified Macaulay duration of a security.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: NOMINAL function|'''NOMINAL''']]
| |
| − | |Returns a nominal interest rate given the effective compounded interest rate.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]
| |
| − | |Returns a nominal interest rate given the effective compounded interest rate.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: ODDFPRICE function|'''ODDFPRICE''']]
| |
| − | |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.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: ODDFYIELD function|'''ODDFYIELD''']]
| |
| − | |Returns the yield of a security, where the time to the first interest payment is not a whole period.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: ODDLPRICE function|'''ODDLPRICE''']]
| |
| − | |Returns the value of a security per 100 currency units of face value, where the last interest payment
| |
| − | is not a whole period.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: ODDLYIELD function|'''ODDLYIELD''']]
| |
| − | |Returns the yield of a security, where the last interest payment is not a whole period.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: PRICE function|'''PRICE''']]
| |
| − | |Calculates a quoted price for an interest paying security, per 100 currency units par value.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: PRICEDISC function|'''PRICEDISC''']]
| |
| − | |Calculates a price for a non-interest paying discounted bond.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: PRICEMAT function|'''PRICEMAT''']]
| |
| − | |Calculates a price (per 100 currency units par value) for a bond that pays interest on maturity.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
| |
| − | |Calculates the amount received at maturity for a zero coupon bond.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: TBILLEQ function|'''TBILLEQ''']]
| |
| − | |Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]
| |
| − | |Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]
| |
| − | |Returns the yield for a US Treasury bill.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
| |
| − | |Calculates the yield for an interest paying security.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
| |
| − | |Calculates the yield for a non-interest paying discounted bond.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
| |
| − | |Calculates the yield for a bond that pays interest on maturity.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |colspan="2"|'''<big> Coupons</big>'''
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]
| |
| − | |Returns the number of days between the coupon date preceding the settlement, and the settlement date.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']]
| |
| − | |Returns the number of days in the coupon period that contains the settlement date.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']]
| |
| − | |Returns the number of days between the settlement date and the next coupon date.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]
| |
| − | |Returns the coupon date next after the settlement date.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
| |
| − | |Returns the number of coupons (interest payments) between the settlement
| |
| − | date and maturity.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]
| |
| − | |Returns the coupon (interest payment) date which precedes the settlement date.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |colspan="2"|'''<big> Miscellaneous</big>'''
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]
| |
| − | |Converts a fractional number representation of a number into a decimal number.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]
| |
| − | |Converts a decimal number into a fractional representation of that number.
| |
| − | |}
| |
| − | <br style="clear:both;" />
| |
| − | <!-- why on earth is this necessary? -->
| |
| − |
| |
| − | {{SeeAlso|EN|
| |
| − | * [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]
| |
| − | * [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]]
| |
| − |
| |
| − | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]],
| |
| − | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]
| |
| | }} | | }} |
| | | | |
| | [[Category: Documentation/Reference/Calc]] | | [[Category: Documentation/Reference/Calc]] |
| | [[nl:NL/Documentation/How_Tos/Calc:_Financiële_functies]] | | [[nl:NL/Documentation/How_Tos/Calc:_Financiële_functies]] |
