Financial Functions
Guesstimate uses Finance.js 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])
- CAGR(beginning value, ending value, number of periods)
- CI(rate, compoundings per period, principal, number of periods)
- DF(rate, number of periods)
- FV(rate, cash flow, number of periods)
- LR(total liabilities, total debts, total income)
- NPV(rate, initial investment, [cash flows])
- PP(number of periods, [cash flows])
- PV(rate, cash flow)
- PI(rate, initial investment, [cash flows])
- ROI(initial investment, earnings)
- R72(rate)
- WACC(market value of equity, market value of debt, cost of equity, cost of debt, tax rate)