These functions use similar definitions for the arguments: See the Excel help file on this function.
EFFECT( nominal_rate, compounding_periods_per_year) - Calculates the effective annual interest rate. CUMPRINC( rate, nper, pv, n1, n2,0) - Cumulative principal payment for the periods n1 through n2. CUMIPMT( rate, nper, pv, n1, n2,0) - Cumulative interest payment for the periods n1 through n2. NPER( rate, pmt, pv) - The number of payment periods. PMT( rate, nper, pv) - The amount of the periodic payment. 
ISPMT( rate, per, nper, pv) - The amount of interest paid during a specific period.
Excel's help file does a good job of explaining the following functions, but the spreadsheet examples will demonstrate how some of these formulas might be used.
0 kommentar(er)
