Scribd Logo
Upload

Welcome to Scribd!

  • 47 views

    Financial Functions

    Uploaded by

    Bio Sciences
    This document contains descriptions of various financial functions in Microsoft Excel. It lists functions for calculating accrued interest, depreciation, coupon dates, interest and principal payments, discounts, and converting dollar prices. Some of the functions included are ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMPRINC, DB, DDB, DISC, and DOLLARDE.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Financial Functions

    Uploaded by

    Bio Sciences
    47 views1 page
    This document contains descriptions of various financial functions in Microsoft Excel. It lists functions for calculating accrued interest, depreciation, coupon dates, interest and principal payments, discounts, and converting dollar prices. Some of the functions included are ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMPRINC, DB, DDB, DISC, and DOLLARDE.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains descriptions of various financial functions in Microsoft Excel. It lists functions for calculating accrued interest, depreciation, coupon dates, interest and principal payments, discounts, and converting dollar prices. Some of the functions included are ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMPRINC, DB, DDB, DISC, and DOLLARDE.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    47 views1 page

    Financial Functions

    Uploaded by

    Bio Sciences
    This document contains descriptions of various financial functions in Microsoft Excel. It lists functions for calculating accrued interest, depreciation, coupon dates, interest and principal payments, discounts, and converting dollar prices. Some of the functions included are ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMPRINC, DB, DDB, DISC, and DOLLARDE.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    FinancialFunctions

    Function ACCRINT ACCRINTM Description Returnstheaccruedinterestforasecuritythatpaysperiodicinterest Returnstheaccruedinterestforasecuritythatpaysinterestatmaturity

    AMORDEGRC Returnsthedepreciationforeachaccountingperiodbyusinga depreciationcoefficient AMORLINC COUPDAYBS Returnsthedepreciationforeachaccountingperiod Returnsthenumberofdaysfromthebeginningofthecouponperiodto thesettlementdate Returnsthenumberofdaysinthecouponperiodthatontainsthe settlementdate

    COUPDAYS

    COUPDAYSNC Returnsthenumberofdaysfromthesettlementdatetothenext coupondate COUPNCD COUPNUM Returnsthenextcoupondateafterthesettlementdate Returnsthenumberofcouponspayablebetweenthesettlementdate andmaturitydate Returnsthepreviouscoupondatebeforethesettlementdate Returnsthecumulativeinterestpaidbetweentwoperiods Returnsthecumulativeprincipalpaidonaloanbetweentwoperiods Returnsthedepreciationofanassetforaspecifiedperiodbyusingthe fixeddecliningbalancemethod Returnsthedepreciationofanassetforaspecifiedperiodbyusingthe doubledecliningbalancemethodorsomeothermethodthatyou specify Returnsthediscountrateforasecurity Convertsadollarprice,expressedasafraction,intoadollarprice,

    COUPPCD CUMIPMT CUMPRINC DB

    DDB

    DISC DOLLARDE

    You might also like