I generally do not like to use built-in financial formulas unless I understand how they pv - The present value of the loan (i.e.per, n1, n2 - Specific period (between 1 and nper).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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |