Finance Functions
Guesstimate uses Finance.js (opens in a new tab) for financial functions. Most functions are available, and we have good overlap with most spreadsheet financial functions (if you need more, please contact us). In particular, the following functions are available.
- AM(principal, rate, total number of payments, [type]) (opens in a new tab)
- CAGR(beginning value, ending value, number of periods) (opens in a new tab)
- CI(rate, compoundings per period, principal, number of periods) (opens in a new tab)
- DF(rate, number of periods) (opens in a new tab)
- FV(rate, cash flow, number of periods) (opens in a new tab)
- LR(total liabilities, total debts, total income) (opens in a new tab)
- NPV(rate, initial investment, [cash flows]) (opens in a new tab)
- PP(number of periods, [cash flows]) (opens in a new tab)
- PV(rate, cash flow) (opens in a new tab)
- PI(rate, initial investment, [cash flows]) (opens in a new tab)
- ROI(initial investment, earnings) (opens in a new tab)
- R72(rate) (opens in a new tab)
- WACC(market value of equity, market value of debt, cost of equity, cost of debt, tax rate) (opens in a new tab)