AMORDEGRC Function in Excel: French Degressive Depreciation
AMORDEGRC returns depreciation for each period using the French degressive method with coefficients (for French accounting). Most users want DB or SLN instead.
Read article →Financial
Excel Financial functions explained with syntax, examples and common mistakes.
COUPDAYS Function in Excel: Days in the Current Coupon Period
COUPDAYS Function in Excel: Days in the Current Coupon Period
COUPDAYS returns the number of days in the coupon period that contains settlement. Used for bond pricing and accrued interest on half-yearly coupons.
Read article →ACCRINTM Function in Excel: Interest Accrued When Paid at Maturity
ACCRINTM Function in Excel: Interest Accrued When Paid at Maturity
ACCRINTM returns interest accrued on a security that pays all its interest at maturity, such as a cumulative fixed deposit or a zero-coupon-style note.
Read article →CUMPRINC Function in Excel: Principal Repaid Over a Period
CUMPRINC Function in Excel: Principal Repaid Over a Period
CUMPRINC totals the principal part of loan payments between two periods — how much of the loan you actually cleared this year.
Read article →PPMT Function in Excel: Principal Part of an EMI
PPMT Function in Excel: Principal Part of an EMI
FinancialLevel: ExpertAvailable in: Excel 2007+PPMT returns the principal repaid by a specific EMI.Syntax=PPMT(rate, per, nper, pv, [fv].
Read article →COUPDAYBS Function in Excel: Days From Last Coupon to Settlement
COUPDAYBS Function in Excel: Days From Last Coupon to Settlement
COUPDAYBS counts days from the last coupon date to the settlement date: the accrued-interest days. Used for bond pricing and accrued interest on half-yearly…
Read article →AMORLINC Function in Excel: Depreciation With Part-Year Start
AMORLINC Function in Excel: Depreciation With Part-Year Start
AMORLINC returns straight-line depreciation for an accounting period, prorating the first period by purchase date (French accounting system).
Read article →COUPDAYSNC Function in Excel: Days From Settlement to Next Coupon
COUPDAYSNC Function in Excel: Days From Settlement to Next Coupon
COUPDAYSNC counts days from settlement to the next coupon date. Used for bond pricing and accrued interest on half-yearly coupons.
Read article →COUPPCD Function in Excel: Previous Coupon Date
COUPPCD Function in Excel: Previous Coupon Date
COUPPCD returns the last coupon date before settlement. Used for bond pricing and accrued interest on half-yearly coupons.
Read article →COUPNCD Function in Excel: Next Coupon Date
COUPNCD Function in Excel: Next Coupon Date
COUPNCD returns the next coupon date after settlement — useful for cash-flow calendars of a bond portfolio.
Read article →COUPNUM Function in Excel: Coupons Left Until Maturity
COUPNUM Function in Excel: Coupons Left Until Maturity
FinancialLevel: ExpertAvailable in: Excel 2007+COUPNUM counts coupon payments remaining.Syntax=COUPNUM(settlement, maturity, frequency.
Read article →ODDFPRICE Function in Excel: Price of a Bond With an Odd First Period
ODDFPRICE Function in Excel: Price of a Bond With an Odd First Period
ODDFPRICE prices a bond whose first coupon period is shorter or longer than normal.
Read article →