精益>> financials>> 返回
项目作者： drum445

项目描述 ：
Collection of Financial Calculations in Crystal
高级语言： Crystal
项目地址: git://github.com/drum445/financials.git
创建时间： 2018-04-26T15:06:20Z
项目社区：https://github.com/drum445/financials
开源协议：MIT License
下载


financials

Methods for performing financial calculations
Rounds to 6 decimal places

Installation

Add this to your application’s shard.yml:

  1. dependencies:
  2.   financials:
  3.     github: drum445/financials

Usage

  1. require "financials"

Examples (showing rounded results)

Payment - Float64
  1. # Excel function: =PMT((9.3/100)/12,36,-12995,6000,0)
  2. puts Financials.pmt(9.3/100/12, 36, -12995, 6000, 0) # => 269.92
  4. # Excel function: =PMT((9.3/100)/12,36,-12995,6000,1)
  5. puts Financials.pmt(9.3/100/12, 36, -12995, 6000, 1) # => 267.84
Present Value - Float64
  1. # Excel function: =PV((9.3/100)/12,36,350.50,1000,0)
  2. puts Financials.pv(9.3/100/12, 36, 350.50, 1000, 0) # => -11731.21
  4. # Excel function: =PV(0,36,350.50,1000,0)
  5. puts Financials.pv(0, 36, 350.50, 1000, 0) # => -13618.00
  7. # Excel function: =PV((9.3/100)/12,36,350.50,1000,1)
  8. puts Financials.pv(9.3/100/12, 36, 350.50, 1000, 1) # => -11816.26
NPER - Float64
  1. # Excel function: =NPER((10/100)/12,2625.73,-81374.62,0,0)
  2. puts Financials.nper(10.0/100/12, 2625.73, -81374.62, 0, 0) # => 36
  4. # Excel function: =NPER(0,2625.73,-81374.62,0,1)
  5. puts Financials.nper(0, 2625.73, -81374.62, 0, 1) # => 31
Future Value - Float64
  1. # Excel function: =FV((5.8/100)/12,48,2265.63,-133781.21,0)
  2. puts Financials.fv(5.8/100/12, 48, 2265.63, -133781.21, 0) # => 46550.0
  4. # Excel function: =FV((5.8/100)/12,48,2265.63,-133781.21,1)
  5. puts Financials.fv(5.8/100/12, 48, 2265.63, -133781.21, 1) # => 45960.0
  7. # Excel function: =FV((10/100)/12,36,2625.73,-81374.62,0)
  8. puts Financials.fv(10.0/100/12, 36, 2625.73, -81374.62, 0) # => 0.0
Rate - Float64
  1. # Excel function: =RATE(60,1600,-75304.59,0)
  2. puts Financials.rate(60, 1600, -75304.59, 0) # => 0.008333
  4. # Excel function: =RATE(30,4337.33,-112072.94,0)
  5. puts Financials.rate(30, 4337.33, -112072.94, 0) # => 0.009917
  7. # Excel function: =RATE(18,1909.53,-103616.44,77477)
  8. puts Financials.rate(18, 1909.53, -103616.44, 77477) # => 0.005

Contributing

  1. Fork it ( https://github.com/drum445/financials/fork )
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am ‘Add some feature’)
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new Pull Request

Contributors