FORGEBOX Enterprise 🚀 - Take your ColdFusion (CFML) Development to Modern Times! Learn More...

finance

v0.2.2 Public

Finance

Master Branch Build Status

The repository contains common financial functions that will hopefully be contributed too and reviewed. This is a CFML code is setup as a Coldbox's module. The actual working code is in models/finance.cfc file.

Common financial functions

Most functions are implemented following the spreadsheet formulas from Microsoft's Excel program

Implemented methods/functions

  • LTV: Loan to Value ratio
  • EFFECT: Returns the effective annual interest rate
  • FV: Returns the future value of an investment
  • IPMT: Returns the interest payment for an investment for a given period
  • NOMINAL: Returns the annual nominal interest rate
  • NPER: Returns the number of periods for an investment
  • NPV: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
  • PMT: Returns the periodic payment for an annuity
  • PPMT: Returns the payment on the principal for an investment for a given period
  • PV: Returns the present value of an investment
  • RATE: Returns the interest rate per period of an annuity

NOT implemented

  • ACCRINT: Returns the accrued interest for a security that pays periodic interest
  • ACCRINTM: Returns the accrued interest for a security that pays interest at maturity
  • AMORDEGRC: Returns the depreciation for each accounting period by using a depreciation coefficient
  • AMORLINC: Returns the depreciation for each accounting period
  • COUPDAYBS: Returns the number of days from the beginning of the coupon period to the settlement date
  • COUPDAYS: Returns the number of days in the coupon period that contains the settlement date
  • COUPDAYSNC: Returns the number of days from the settlement date to the next coupon date
  • COUPNCD: Returns the next coupon date after the settlement date
  • COUPNUM: Returns the number of coupons payable between the settlement date and maturity date
  • COUPPCD: Returns the previous coupon date before the settlement date
  • CUMIPMT: Returns the cumulative interest paid between two periods
  • CUMPRINC: Returns the cumulative principal paid on a loan between two periods
  • DB: Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
  • DDB: Returns the depreciation of an asset for a specified period by using the double-declining balance method or some their method that you specify
  • DISC: Returns the discount rate for a security
  • DOLLARDE: Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
  • DOLLARFR: Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
  • DURATION: Returns the annual duration of a security with periodic interest payments
  • FVSCHEDULE: Returns the future value of an initial principal after applying a series of compound interest rates
  • INTRATE: Returns the interest rate for a fully invested security
  • IRR: Returns the internal rate of return for a series of cash flows
  • ISPMT: Calculates the interest paid during a specific period of an investment
  • MDURATION: Returns the Macauley modified duration for a security with an assumed par value of $100
  • MIRR: Returns the internal rate of return where positive and negative cash flows are financed at different rates
  • ODDFPRICE: Returns the price per $100 face value of a security with an odd first period
  • ODDFYIELD: Returns the yield of a security with an odd first period
  • ODDLPRICE: Returns the price per $100 face value of a security with an odd last period
  • ODDLYIELD: Returns the yield of a security with an odd last period
  • PDURATION: Returns the number of periods required by an investment to reach a specified value
  • PRICE: Returns the price per $100 face value of a security that pays periodic interest
  • PRICEDISC: Returns the price per $100 face value of a discounted security
  • PRICEMAT: Returns the price per $100 face value of a security that pays interest at maturity
  • RECEIVED: Returns the amount received at maturity for a fully invested security
  • RRI: Returns an equivalent interest rate for the growth of an investment
  • SLN: Returns the straight-line depreciation of an asset for one period
  • SYD: Returns the sum-of-years' digits depreciation of an asset for a specified period
  • TBILLEQ: Returns the bond-equivalent yield for a Treasury bill
  • TBILLPRICE:Returns the price per $100 face value for a Treasury bill
  • TBILLYIELD: Returns the yield for a Treasury bill
  • VDB: Returns the depreciation of an asset for a specified or partial period by using a declining balance method
  • XIRR: Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
  • XNPV: Returns the net present value for a schedule of cash flows that is not necessarily periodic
  • YIELD: Returns the yield on a security that pays periodic interest
  • YIELDDISC: Returns the annual yield for a discounted security; for example, a Treasury bill
  • YIELDMAT: Returns the annual yield of a security that pays interest at maturity

Credits

Nothing here is original work, credit is due to the people from the companies/organizations below:

Here are all the versions for this package. Please note that you can leverage CommandBox package versioning to install any package you like. Please refer to our managing package version guide for more information.

Version Created Last Update Published By Stable Actions
Current
0.2.2 Jun 29 2017 07:09 PM Jun 29 2017 07:09 PM
Version History
0.2.0 Jun 01 2017 11:37 AM Jun 01 2017 11:37 AM
0.1.0 May 08 2017 10:48 PM May 08 2017 10:48 PM

 

No collaborators yet.
     
  • May 06 2017 01:17 PM
  • Jun 29 2017 07:09 PM
  • 478
  • 0
  • 20