Vybe Documentation
Vybe Main page
Financial Functions
Vybe supports standard financial functions for loan payments, investment tracking, and asset depreciation.
Loan & Investment Calculations
| Function | Syntax | Description |
|---|---|---|
| Pmt | Pmt(rate, nper, pv, [fv], [type]) |
Calculates the payment for a loan based on constant payments and interest rate. |
| FV | FV(rate, nper, pmt, [pv], [type]) |
Calculates the future value of an investment. |
| PV | PV(rate, nper, pmt, [fv], [type]) |
Calculates the present value of an investment. |
| NPer | NPer(rate, pmt, pv, [fv], [type]) |
Calculates the number of periods for an investment. |
| Rate | Rate(nper, pmt, pv, [fv], [type], [guess]) |
Calculates the interest rate per period for an annuity. |
| IPmt | IPmt(rate, per, nper, pv, [fv], [type]) |
Calculates the interest payment for a specific period. |
| PPmt | PPmt(rate, per, nper, pv, [fv], [type]) |
Calculates the principal payment for a specific period. |
Depreciation Calculations
| Function | Syntax | Description |
|---|---|---|
| SLN | SLN(cost, salvage, life) |
Calculates the straight-line depreciation of an asset for a single period. |
| DDB | DDB(cost, salvage, life, period, [factor]) |
Calculates the sum-of-years' digits depreciation of an asset. |
| SYD | SYD(cost, salvage, life, period) |
Calculates the sum-of-years' digits depreciation for a specified period. |
Parameters
- rate: Interest rate per period.
- nper: Total number of payment periods in the annuity.
- pv: Present value.
- fv: Future value (default is 0).
- type: When payments are due (0 = end of period, 1 = start of period).
- per: Period for which the payment is to be calculated.