ACCRINTReturns the accrued interest for a security that pays periodic interestACCRINTMReturns the accrued interest for a security that pays interest at maturityAMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientAMORLINCReturns the depreciation for each accounting periodCOUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateCOUPDAYSReturns the number of days in the coupon period that contains the settlement dateCOUPDAYSNCReturns the number of days from the settlement date to the next coupon dateCOUPNCDReturns the next coupon date after the settlement dateCOUPNUMReturns the number of coupons payable between the settlement date and maturity dateCOUPPCDReturns the previous coupon date before the settlement dateCUMIPMTReturns the cumulative interest paid between two periodsCUMPRINCReturns the cumulative principal paid on a loan between two periodsDBReturns the depreciation of an asset for a specified period by using the fixed-declining balance methodDDBReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specifyDISCReturns the discount rate for a securityDOLLARDEConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal numberDOLLARFRConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fractionDURATIONReturns the annual duration of a security with periodic interest paymentsEFFECTReturns the effective annual interest rateFVReturns the future value of an investmentFVSCHEDULEReturns the future value of an initial principal after applying a series of compound interest ratesINTRATEReturns the interest rate for a fully invested securityIPMTReturns the interest payment for an investment for a given periodIRRReturns the internal rate of return for a series of cash flowsISPMTCalculates the interest paid during a specific period of an investmentMDURATIONReturns the Macauley modified duration for a security with an assumed par value of $100MIRRReturns the internal rate of return where positive and negative cash flows are financed at different ratesNOMINALReturns the annual nominal interest rateNPERReturns the number of periods for an investmentNPVReturns the net present value of an investment based on a series of periodic cash flows and a discount rateODDFPRICEReturns the price per $100 face value of a security with an odd first periodODDFYIELDReturns the yield of a security with an odd first periodODDLPRICEReturns the price per $100 face value of a security with an odd last periodODDLYIELDReturns the yield of a security with an odd last periodPMTReturns the periodic payment for an annuityPPMTReturns the payment on the principal for an investment for a given periodPRICEReturns the price per $100 face value of a security that pays periodic interestPRICEDISCReturns the price per $100 face value of a discounted securityPRICEMATReturns the price per $100 face value of a security that pays interest at maturityPVReturns the present value of an investmentRATEReturns the interest rate per period of an annuityRECEIVEDReturns the amount received at maturity for a fully invested securitySLNReturns the straight-line depreciation of an asset for one periodSYDReturns the sum-of-years' digits depreciation of an asset for a specified periodTBILLEQReturns the bond-equivalent yield for a Treasury billTBILLPRICEthe price per $100 face value for a Treasury billTBILLYIELDthe yield for a Treasury billVDBReturns the depreciation of an asset for a specified or partial period by using a declining balance methodXIRRReturns the internal rate of return for a schedule of cash flows that is not necessarily periodicXNPVReturns the net present value for a schedule of cash flows that is not necessarily periodicYIELDReturns the yield on a security that pays periodic interestYIELDDISCReturns the annual yield for a discounted security; for example, a Treasury billYIELDMATReturns the annual yield of a security that pays interest at maturity
Quaisquer soluções e/ou desenvolvimento de aplicações pessoais, ou da empresa, que não constem neste Blog podem ser tratados como consultoria freelance.
Excel Tips - Funções Financeiras - Financial functions
Para utilizarmos bem as funções do MS Excel precisamos ao menos saber que existem e conhecermos onde as podemos aplicar.
O que segue são algumas destas que podemos utilizar extensivamente, agora com um pouco mais de conhecimento.
Tenham em mente que elas estão expressas em inglês, escolhi assim para que pudéssemos ter proveito delas tanto funcionalmente no MS Excel quanto na programação VBA. Sei que na maioria das empresas a instalação está em português, o que pessoalmente acho péssimo, nestes casos poderá procurar pela referência de como escrevê-la em Português.
Tags: Function, Excel, Tips, functions, Financial, financeira