五、财务函数(国外英文资料).doc

五、财务函数(国外英文资料) Frequency = 4), the Basis is the daily count base type (0 or omission is 30/360,1 for actual days/actual days, 2 is the actual number of days / 360,3 is the actual number of days / 365,4 is 30/360 in Europe). 7. COUPDAYSNC Purpose: to return the number of days between the closing date and the next day of payment. Syntax: COUPDAYSNC (settlement, maturity, frequency, basis) Parameters: the securities Settlement is closing date, expiration date of Maturity for the securities, the Frequency for years service number (if paid for years, the Frequency = 1; pay, on the Basis of the 6-month Frequency = 2; the quarterly payment, Frequency = 4), the Basis for the benchmark day count type (0 or omitted for 30/360, 1 for the actual number of days/the actual number of days, for the actual number of days / 2 360, 3 for the actual number of days / 365, 4 for the European 30/360). 8. COUPNUM Purpose: to return the amount of interest payable between the closing date and the maturity date, to the nearest integer. Syntax: COUPNUM (settlement, maturity, frequency, basis) Parameter: same 9. COUPPCD Purpose: to return to the date of the day before the closing date of the closing date. Grammar: COUPPCD (settlement, maturity, frequency, basis) Parameter: same 10. CUMIPMT Purpose: returns the amount of interest that a loan accumulates during a given start - period and end-period period. Syntax: CUMIPMT (rate, nper, pv, start_period, end_period, type) Parameters: the Rate of interest rates, Nper for total payment periods, Pv for present value, Start_period for calculating the initial payment (Nper starting from 1), End_period for calculating the end, the Type of payment time Type (0 (zero) for the final payment, 1) for the early payment. 11. CUMPRINC Purpose: to return a loan from a given start - period to end - period total amount of principal paid. The syntax: CUMPRINC (rate, nper, pv, start_period, end_period, type) Parameters: the Rate of interest rates, Nper for total paym