CUMPRINC function in Excel

Use When you take a loan, the CUMPRINC function calculates the cumulative principal paid on the loan between the specified period. Syntax CUMPRINC(rate, nper, pv, start_period, end_period, type) The CUMPRINC function (a Financial function) has the following arguments: rate – Required. The rate of interest. It needs to reflect the period length e.g. if you have a annual interest […]

COUPPCD function in Excel

Use The COUPPCD function is categorized as a financial function, it provides the most recent coupon payment date before the settlement date of the security. Syntax COUPPCD(settlement, maturity, frequency, [basis]) The function has the following arguments: settlement – Required. The date on which the security was purchased by a buyer. maturity – Required. The expiry date of […]

COUPNUM function in Excel

Use The COUPNUM function is a financial function, which calculates the total number of coupon payments to be made from the settlement date to the maturity date of the security. For example, being an investor, you invest in a bond, the COUPNUM function will calculate the total number of coupon payments that you will receive from the […]

COUPNCD function in Excel

Use The COUPNCD function is a financial function, which is used to find out the first coupon payment date after the settlement date of a security/bond. Syntax COUPNCD(settlement, maturity, frequency, [basis]) settlement – Required. The settlement date of the security.  The date on which the security is traded to the buyer. maturity – Required. The expiry date […]

COUPDAYSNC function in Excel

Use The COUPDAYSNC function calculates the number of days from the settlement date to the next coupon date. The NC, in the word: COUPDAYSNC means “Next Coupon” and the function belongs to the financial function category. Syntax COUPDAYSNC(settlement, maturity, frequency, [basis]) The function syntax has the following arguments: settlement – Required. After the security’s issue date, it the […]

COUPDAYBS function

Use The COUPDAYBS function calculates the number of days from the start of a coupon period to the settlement date of the security and it is categorized as a financial function. Syntax COUPDAYBS(settlement, maturity, frequency, [basis]) The function has the following arguments: settlement – Required. The date on which the security will be acquired. maturity – Required. The […]

ACCRINT function in Excel

Use The ACCRINT function calculates the accrued interest for a security that pays interest on a periodic basis. It is categorized as a financial function in Excel. Syntax ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) The ACCRINT function has the following arguments: issue – Required. The date on which the security was issued. first_interest – Required. The first date […]

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved