{"repo":"noverde/exonio","free":true,"listed":false,"github":"https://github.com/noverde/exonio","clone":"git clone https://github.com/noverde/exonio.git","description":"Bring some useful HP-12C and Excel financial formulas to Ruby ;)","language":"Ruby","stars":60,"topics":["loan","excel","hp12c","finance","team-architecture"],"license":"MIT","category":"trading","readme_excerpt":"Exonio This gem brings some useful Excel formulas to Ruby. For now, it just has financial formulas, but could have more (like statistical formulas) in the future. Installation Add this line to your application's Gemfile: And then execute: $ bundle Or install it yourself as: $ gem install exonio Usage To use Exonio you just have to call the method you like to use. Example: Available Formulas EFFECT The Excel EFFECT function returns the effective annual interest rate, given a nominal interest rate and the number of compounding periods per year. Effective annual interest rate is the interest rate actually earned due to compounding. More about this function EFFECT NOMINAL The Excel NOMINAL function returns the nominal interest rate when given an effective annual interest rate and the number of compounding periods per year. The effective rate is the actual rate due to compounding. The nominal rate is typically the stated rate. More about this function NOMINAL FV What is the future value after 10 years of saving $100 now, with an additional monthly savings of $100 with the interest rate at 5% (annually) compounded monthly? By convention, the negative sign represents cash flow out (i.e. money not available today). Thus, saving $100 a month at 5% annual interest leads to $15,692.93 available to spend in 10 years. IRR Suppose one invests 100 units and then makes the following withdrawals at regular (fixed) intervals: 39, 59, 55, 20. Assuming the ending value is 0, one's 100 unit inves","default_branch":null,"files":null,"tree":[],"storefront":"/r/noverde","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/noverde/exonio/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}