CALC.ipmt(rate, per, nper, pv, fv, type)
CALC.accrint(issue, interest, settlement, rate, par, freq, [basis])
CALC.accrintm(issue, maturity, rate, par, [basis])
CALC.amordegrc(cost, date_purchased, first_period, salvage, period, rate, [basis])
CALC.amorlinc(cost, date_purchased, first_period, salvage, period, rate, [basis])
CALC.coupdaybs(settlement, maturity, frequency, [basis])
CALC.coupdays(settlement, maturity, frequency, [basis])
CALC.coupdaysnc(settlement, maturity, frequency, [basis])
CALC.coupncd(settlement, maturity, frequency, [basis])
CALC.coupnum(settlement, maturity, frequency, [basis])
CALC.couppcd(settlement, maturity, frequency, [basis])
CALC.cumipmt(rate, nper, pv, start_period, end_period, type)
CALC.cumprinc(rate, nper, pv, start_period, end_period, type)
CALC.db(cost, salvage, life, period, [month])
CALC.ddb(cost, salvage, life, period, [factor])
CALC.disc(settlement, maturity, pr, redemption, [basis])
CALC.duration(settlement, maturity, coupon, yld, frequency, [basis])
CALC.effect(nominal_rate, npery)
CALC.fv(rate, nper, pmt, [pv], [type])
CALC.fvschedule(principal, schedule)
CALC.intrate(settlement, maturity, investment, redemption, [basis])
CALC.ipmt(rate, per, nper, pv, fv, type)
CALC.ispmt(rate, per, nper, pv)
CALC.mduration(settlement, maturity, coupon, yld, frequency, [basis])
CALC.mirr(values, finance_rate, reinvest_rate)
CALC.nominal(effect_rate, npery)
CALC.nper(rate, pmt, pv, fv, type)
CALC.npv(rate, [value1, value2, [....]])
CALC.pmt(rate, nper, pv, fv, type)
CALC.ppmt(rate, per, nper, pv, fv, type)
CALC.price(settlement, maturity, rate, yld, redemption, frequency, [basis])
CALC.pricedisc(settlement, maturity, discount, redemption, [basis])
CALC.pricemat(settlement, maturity, issue, rate, yld, [basis])
CALC.pv(rate, nper, pmt, fv, type)
CALC.received(settlement, maturity, investment, discount, [basis])
CALC.syd(cost, salvage, life, per)
CALC.tbilleq(settlement, maturity, discount)
CALC.tbillprice(settlement, maturity, discount)
CALC.tbillyield(settlement, maturity, pr)
CALC.vdb(cost, salvage, life, start_period, end_period, factor, no_switch)
CALC.xnpv(rate, values, dates)
CALC.yielddisc(settlement, maturity, pr, redemption, [basis])
CALC.yieldmat(settlement, maturity, issue, rate, pr, [basis])
Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. Rate is the interest rate per period. Per is the period for which you want to find the interest and must be in the range 1 to Nper. Nper is the total number of payment periods in an annuity. Pv is the present value, or the lump-sum amount that a series of future payments is worth right now. Fv is the future value, or a cash balance you want to attain after the last payment is made. Type is the number 0 or 1 and indicates when payments are due.
Example
CALC.ipmt(10/12, 1*3, 3, 8000, 0, 0);
// returns -22.406
(interest due in the first month of a 3 year loan with a 10% annual interest rate)
| << CALC.intrate(settlement, maturity, investment, redemption, [basis]) | © 1996-2013 InetSoft Technology Corporation (v11.5) | CALC.ispmt(rate, per, nper, pv) >> |