gofin

Functions for performing financial calculations

Installation

Add this to your source code

import "github.com/drum445/gofin"

Run in a terminal in your project root

$ go get

Examples (showing rounded results)

Payment - Float64

# Excel function: =PMT((9.3/100)/12,36,-12995,6000,0)
gofin.PMT(9.3/100/12, 36, -12995, 6000, 0) // => 269.92

# Excel function: =PMT((9.3/100)/12,36,-12995,6000,1)
gofin.PMT(9.3/100/12, 36, -12995, 6000, 1) // => 267.84

Present Value - Float64

# Excel function: =PV((9.3/100)/12,36,350.50,1000,0)
gofin.PV(9.3/100/12, 36, 350.50, 1000, 0) // => -11731.21

# Excel function: =PV(0,36,350.50,1000,0)
gofin.PV(0, 36, 350.50, 1000, 0) // => -13618.00

# Excel function: =PV((9.3/100)/12,36,350.50,1000,1)
gofin.PV(9.3/100/12, 36, 350.50, 1000, 1) // => -11816.26

NPER - Float64

# Excel function: =NPER((10/100)/12,2625.73,-81374.62,0,0)
gofin.NPER(10.0/100/12, 2625.73, -81374.62, 0, 0) // => 36

# Excel function: =NPER(0,2625.73,-81374.62,0,1)
gofin.NPER(0, 2625.73, -81374.62, 0, 1) // => 31

Future Value - Float64

# Excel function: =FV((5.8/100)/12,48,2265.63,-133781.21,0)
gofin.FV(5.8/100/12, 48, 2265.63, -133781.21, 0) // => 46550.0

# Excel function: =FV((5.8/100)/12,48,2265.63,-133781.21,1)
gofin.FV(5.8/100/12, 48, 2265.63, -133781.21, 1) // => 45960.0

# Excel function: =FV((10/100)/12,36,2625.73,-81374.62,0)
gofin.FV(10.0/100/12, 36, 2625.73, -81374.62, 0) // => 0.0

Rate - Float64

# Excel function: =RATE(60,1600,-75304.59,0)
gofin.Rate(60, 1600, -75304.59, 0) // => 0.008333

# Excel function: =RATE(30,4337.33,-112072.94,0)
gofin.Rate(30, 4337.33, -112072.94, 0) // => 0.009917

# Excel function: =RATE(18,1909.53,-103616.44,77477)
gofin.Rate(18, 1909.53, -103616.44, 77477) // => 0.005

Contributing

1. Fork it ( https://github.com/drum445/gofin/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

• drum445 ed - creator, maintainer